the project simply is writing one SELECT statement
we'll provide a dbase in mysql format, and all what we need is to write a single SELECT statement to choose few records acodring to multi conditions we'll provide.
the select statement might be complicated but if you're in a good knowledge with SQL statements, u'll write this in less than one hour task..
Looking to make some money?
- Set your budget and the time frame
- Outline your proposal
- Get paid for your work
Bids on this Project
Cannon Hill, Australia
## BIO Later ## Area of Expertise C/C++ MS SQL Server Linux Embedded systems
Hi, We are a good team of experts in different technologies and specially deals in Projects related to ORACLE CONSULTANT( BI PUBLISHER, ORACLE APPS R12/11i, D2K( FORMS AND REPORTS), Workflow, OAF, ADF, XML, PL/SQL and DATA ENTRY AUTOMATIONS.
I am a "Teradata certified professional". I have expertise in all the Teradata tools used in the ETL process of the datawarehousing. With deep interest in SQL, i not only have firm grip on the Teradata tools but also have good hands on experience on MySQL and SQL Server. WRITING is my second most interested subject and with the passage of time i have developed great expertise in it. Working as a freelancer, I have provided some good writings to my employers before. I have written columns for one of my national news papers. Most of all, I love and enjoy my work as i do it.
Auckland, New Zealand
I am a freelancer domiciled in New Zealand. Don't let my time zone fool you though - I work around the clock and can adjust my schedule to work around your project. My core strengths are programming, APIs, scripts, macros, diagnostics, server administration, troubleshooting ... have I just covered all aspects of IT? I have been in the industry nearly two decades and have done all sorts of projects from front end through back end and the middleware in between. Check out my reviews and completion rate, then judge me for yourself when I complete your project. I apologize to the stones that WILL be turned to uncover the solution to your problems, none shall be spared!
## BIO RAVIRANJAN KUMAR SINHA (Sun Certified Java Programmer) [Removed by Freelancer.com Admin for posting of Contact information] Objective To secure a challenging assignment in a dynamic environment that would require my aptitude and technical skills and give ample opportunity for my all around growth in the software industry. Work Experience Total 2.9 Years Of Experience in IT Industry. ? 2.9 Years of Experience working on VB.NET, ASP.NET, Oracle9i/10g, SQL Server 2005/2000 . Professional Summary 1.) Softrade Infoware Private Limited, Bangalore From July 2007 to till date. 2.) Laavanya Technology, Bangalore from January 2007 to June 2007. Technical Summary ? Very Good Knowledge of Programming in VB.NET, C# .NET. ? Very Good Knowledge of Programming in ASP.NET. ? Good knowledge of Web Services. ? Very Good Knowledge of writing Sequel Query in Oracle . ? Very Good Knowledge of writing stored procedure in Oracle. ? Very Good Knowledge of writing Sequel Query in Microsoft SQL Server 2005. ? Very Good Knowledge of Java Technology. ? Good Knowledge of VB6. ? Proven ability to work as a Team. ? Design, Development, and Coding. ? Debugging and troubleshooting the application. Technical Skill Languages : VB.NET, ASP.NET, Java, J2EE(JSP,Servlet) Database : Oracle9i/10g, SQL Server 200/2005 Web Development : ASP.NET, ADO .NET, J2EE(JSP,Servlet) Database Tools : TOAD, Oracle SQL Developer Reporting Tool : Crystal Report 11 OS : Windows 2000/XP Excellence SCJP Certified (Sun Certified Java Programmer) Academic Credentials BE (Computer Science & Engineering) in 2005 Bhagalpur College Of Engineering 69% TMB University Bhagalpur, Bihar 12th Sardar Patel Memorial College 52% Bihar Sharif, Nalanda, Bihar 10th HSDS Nalanda, Bihar 60% Project #1 Project Title FinOPS Language/Tools Used VB.NET 2008, SQL Server 2005, Dx Report, Infragistics 8.3 Team Size 4 Duration April 2009 to till Date Role Developer Project Objective This project is customized to meet SKS (A Finance Company) needs. The application is customized to provide solution for Finance management system. The purpose of FinOPS is basically to keep track of Clients, Loans taken by clients, repayment of loans, including Assignment, Stamping, Head Office Entry. FinOPS is developed to give updates of Loan taken by the clients, Repayments of Installment, Late payment , Head Office entry. In this project loan can also be sold to other banks. Also functionalities are calculating IRR(Internal Rate Of Return), Head Office entry, Stamping Transaction, Assignments and others. For the reporting purpose many reports are developed in different entities Loan Disbursement Summary, Loan Disbursement Detail, Product wise Loan Outstanding, Month wise Ageing Outstanding, Portfolio Rundown, Loan Written Details and others. Based On user rights many roles are defined. Responsibilities • Developing various functionality using VB.NET • Developed many stored procedure in SQL Server 2005. • Created Index and Partitions for making fast execution • Responsible for designing Report. Project #2 Project Title dbPays4 Client Deutsche Bank Language/Tools Used VB.NET 2005, Oracle 10g, Crystal Report, TOAD, Oracle SQL Developer Team Size 3 Duration July 2008 to April 2009. Role Developer Project Objective dbPays4 is used to monitor and maintain payment system for DEUTSCHE Bank. The major modules are Master Upload, Customer Instruction, Process, payments(WBR) ,Payments(ABR), Charges, Accountings, Cheque Atpar . In this project we are using DJ Convertor to convert different format of Cheques. Module which I have done is Master Upload, Payments, Customer Instruction, Accounting and charges. In this system two types of charges is there Customer charging and partner bank charging. Payments within Bank Reference means payment generation for a client given by single customer and Payments Across bank reference means payment generation for a client given by more than one customer. Responsibilities • Developing various functionality using VB.NET. • Developed various stored procedure to implement functionality of process program. • Responsible for Designing Report. Project #3 Project Title ChitSmart Language/Tools Used VB.NET 2008, SQL Server 2005, Dx Report, Infragistics 8.3 Team Size 4 Duration March 2008 to July 2008 Role Developer Project Objective This is a product based product of this company. This is based on chit fund system. In this foreman (Generally Owner) is responsible for the system. The main functionality of this project is giving money to many persons as borrow and they will payback in small installment Daily/Weekly/Fortnightly/ Monthly with very less interest. This is same like a person taking loan from bank but the difference is that in this system they can get money easily without providing any proof and they will pay in installment with very less interest. Because in this system the extra amount earned is dividing to each person. Responsibilities • Developing various functionality using VB.NET • Responsible for designing Report. • Developed many Stored procedure in SQL Server 2005. #Project 4 Project Title Cash Track Client Deutsche Bank Language Used ASP.NET 2003, SQL Server 2000 Team Size 3 Duration December 2007 to March 2008 Role Developer Project Objective Cash Track is used to Monitor and Maintains cash funding system for DEUTSCHE Bank. In this system there are three types of users Customer, DB user and Service provider. Process flow of this system is first customer send request to DESTSCHE Bank with request number then DB User upload customer file to the server, after that service provider user download current date request and he will open downloaded file and he will collect the cash at mention pickup location. Then service provider will do deposit entries. In this system we are using cut off time. If customer adding request after cut off time warning message will popup. This cut off time is defined at the system level by administrator in admin mode. Responsibilities • Implementing functionality using ASP.NET. • Responsible for Form Designing. Project #5 Project Title IMS NET Client Bharat Industrial Corporation(BIC) Language Used VB.NET 2005, SQL Server 2000,Crystal Report Team Size 3 Duration October 2007 to November 2007 Role Developer Project Description This Project Maintains the Ac ## Area of Expertise I have experience in VB.NET, C# .NET, Java , J2EE, JSP, Servlet, JSF, Oracle, Microsoft SQL Server, My SQL, Microsoft Access, Java Script, CSS, Web Services, XML, WCF, JQUery
I Am a MCTS certified individual with 10 years of experience in .NEt and software Development.
I have a masters degree in computer application. I have 2 years of experience as RPG, RPGLE programmer and 3 years of experience as JAVA programmer. I have worked for two different companies in last five years and received awards for outstanding performance and contribution to the projects. In Jan 2012 I started freelancing and completed an online booking system. I have good knowledge in HTML and MQSQL also.
Expertise in .net, SQL Server, HTML, Java Script.