Summary

• Extensive experience in analysis, design and development of Client Server applications using various databases like Oracle, SQL Server and Sybase etc.
• Experience in working on vast DataWarehouses.
• Programming in Visual Basic.Net, Visual Basic (4, 5, 6.0) Oracle Forms on the front end.
• Involved in several Life Cycles of development on the front end and back end.
• Experience using several reporting tools like crystal reports, business objects, oracle reports, Sql server reports, report writer etc.
• Vast Experience with business intelligence and business logic tools.
• Worked as developer, business analyst and project lead on several of the projects.

Languages
Visual Basic.Net, Visual Basic, C, C++, PRO *C, SQL, PL/SQL, Java

Databases
Oracle (11G & below), SQL Server (2008 & below), Sybase 12.5, MS Access , DB2.

Unix, Windows, and VAX/VMS

Tools
Oracle Intelligence Builder, SQL * Forms (3.x, 4.x), SQL *Plus, SQL *Reports, Informatica, Cognos, Visual Basic (6.0 & below), VB.NET, ASP.Net, Crystal Reports (7.0, 8.0 & 8.5), AS 400, Erwin, Autosys, Power Builder (4.0, 5.0), Java Beans, Java Script,VB Script, ASP, JDBC,COM, DCOM, Active X, MTS, Perl, HTML, DHTML, XML.

Packages
Microsoft Project, Excel Macros, Visual Basic Application (VBA), Developer 2000, Erwin, Visual SourceSafe

WEB SERVER
Oracle Web Server (OAS) 4

Education

• MS Computer Science
• Master of Business Administration (Finance)
• Master of Business Administration (Marketing)
• Diploma in Computer Management.
• Advanced Toast Master, Toastmasters International.
• Pursuing Project Management Professional

Experience
Senior Developer/ Business Analyst
Confidential, Consultant April 2008 to December 2009

• Designed and Developed the Core Application of the firm - Key System using Visual Basic for Applications with Oracle 11g and SQL Server 8.0 database.
• Developed a pilot project on Visual Basic.Net to convert an old legacy system for management review.
• Maintained and developed the Share Point application for putting all data into the central repository.
• Conducted requirement gathering with end users and converted them into business specs and developed the specs into application design and development. Conducted user acceptance testing including the documentation and final turnover into production after due processes.
• Fine tuned the stored procedures in PL/SQL for optimum performance that saved the users a lot of delay time in accessing data from the front end.
• Helped the company to resolve issues with corruption of the front end system on Citrix by giving solutions that resolved the issue resulting in less downtime of the system during peak hours.
• Developed several reports in Business Objects XI R2, Crystal Reports, Oracle Reports for the users and management for effective decision making.
• Involved in loading data from Oracle and SQL Server and performing maintenance on the database servers for optimum performance that helped the firm with better customer service to the users.

Experience (continued)

Environment : Oracle 11G, Visual Basic.Net, Microsoft Visual Basic Applications, ASP.Net, XML, DHTML, VB Script, Java Script, PL/SQL, Oracle Reports 11G, Cognos, Microsoft Access 2007, Business Objects, SQL Server 8.0, Business Objects XIR3, Data Integrator - X1R2, Share Point, Remote Desktop, Oracle Lite Repository.

Senior Developer/ Business Analyst
Confidential, Burlington (NJ) - Consultant November 2007 - March 2008.

• Developed packages in PL/SQL that implemented the company's business rules on the Electronic Data Interchange(EDI) Project.
• Programmed in Unix Shell scripts to run the PL/SQL packages and schedule them.
• Developed user cases for the business rules of the company.
• Fine tuned the existing PL/ SQL procedures for optimum performance that helped the company serve its users effectively and efficiently.

Environment: Oracle 10G, Visual Basic.Net, ASP.Net, XML, Toad 8.6 * 9.5, SQL Navigator 4.5, Putty 0.54 (Perl), UNIX, SQL*Plus, Secure Shell 3.2.9, Crystal Reports X1.

Senior Developer/ Business Analyst
Confidential, Consultant February 2007 - November 2007

• Wrote Visual Basic programs to process the firms tele marketing lists to help management study the success and
• quality of the tele marketing calls.
• Fine tuned the existing PL/SQL stored procedures to reduce the data retrieval from the back end. Was able to reduce response time by almost 70%. This helped the company in providing better response time and service to users.
• Led a team of developers to successfully process several tele marketing lists within the budgeted time and allotted resources.
• Worked with end users in getting the requirements and converting them into business requirements and technical specs and allotted the work proportionally to the developers. Also took a large chunk of work for development in Visual Basic.Net, Visual Basic 6.0 and Oracle 10G.
• Conducted code reviews, developers reviews, process reviews and plan reviews to see that the projects were being completed within the time frames and budgets and adhering to firm standards.
• Interacted with third party vendors to help the company with mission critical applications.
• Developed and documented the User Acceptance testing and production roll outs and issues and notes on the project.

Environment: Oracle 10G, Visual Basic.Net, ASP.Net, XML, XSL, ADO.Net, Java Script, Visual Basic 6.0, Crystal Reports 11, Visual Source Safe,Oracle Reports 10G, UNIX, Oracle Loader, SQL Plus, PL/ SQL, TOAD.

Senior Developer/ Business Analyst
Confidential, Wall Street (NY) - Full Time June 2004 - February 2007

• Responsible for Technical support to over 40 controllers and brokers over several groups (Fixed Income, Treasury, Asset Management, Mortgages, Management Reporting etc).
• Designed and developed Visual Basic applications to read data from the dataware house to populate local databases that were used by the controllers.
• Developed DTS packages that read real time data. Wrote Visual Basic application that parsed over 300 tables with data from the mainframe files and flat files based on the arrival of the file on the firm's network domain. Worked on Informatica to pull data from several source database tables into the custom databases.
• Coordinated several mission critical updates like Oracle and SQL Server upgrade, File system upgrades, DLL installations, disaster recovery testing etc.
• Worked on making the applications that I supported SOX complaint.
• Supported the Controllers and Brokers with several ad hoc applications designed and developed in Visual Basic, VBA, PL/SQL, SQL Server reports, DTS packages, Crystal Reports, Business Objects reports etc.
• Built project plans for optimum utilization of the allocated budget and resources.
• Documented the existing procedures for the firm's knowledge management repository.

Environment: SQL Server 8.0, Sybase 12.5.1, Oracle 10G, Mainframe, Visual Basic 6.0, Visual Basic.Net, Access 2000, Excel Macros, Dameware, Crystal Reports 11, Cognos, Business Objects XI R2, Informatica, UNIX.

Experience (continued)

Confidential, Contractor January 2002 to May 2004

• Developed Visual Basic.Net applications using Oracle as a backend for the CVC reporting application that helped the management monitor and study the different financial instruments of the company.
• Interacted and liasoned with several departments to effectively design and implement the firms reporting process on the company's intranet.
• Worked on several reporting tools like Crystal Reports, Oracle Reports to help the company build a strong reporting process for effective management decisions.
• Allocated work among the developers for optimum utilization of the contractor's time and effective load balance of the work.
• Gave inputs to management for decisions on third party software procurement.

Environment: Visual Basic.Net & Visual Basic 6.0, Oracle 9.0, ASP.Net, HTML, DHTML, XML, Crystal Reports 9.0, UNIX, C, Microsoft Transaction Server (MTS), Compuware (QALoad etc), Microsoft Project 2000 , ASP, COM, DCOM, Java Script, VB Script, IIS Server

Senior Developer/ Project Leader/ Analyst
Confidential, Fulltime January 2000 to December 2001

• Lead a team of 6 programmers on a financial application designed and developed in Visual Basic and Oracle.
• Wrote several Visual Basic applications that read data from the dataware house and populated the tables in several custom databases in Oracle and SQL Server for specific groups (HR, Management Reporting etc).
• Customized several DLL's and Active X controls for the firm's specific usage.
• Developed and documented several business processes that helped the firm with effective implementation of projects.
• Wrote PL/SQL packages to pull data from mainframe and legacy applications to populate the custom databases.
• Liasoned with different departments for effective production rollouts and seamless integration of the new systems with the existing systems.
• Developed best practices to be followed by the developers. This included the process of version control, code review, User sign offs, business requirement documentation, user acceptance test scripts and sign off's and production roll outs.
• Trained with third party vendor software to understand the functionality and implement the software within the firms practice.

Environment: Oracle 7.4 & 8.0, Visual Basic.Net, Visual Basic 5.0 & 6.0, C, SQL Server 6.5 & 7.0, ASP, COM, DCOM, Active X, XML, DHTML, IIS, Crystal Reports 8.0 & 8.5, Java Beans, Dream weaver, CORBA, JDBC, Erwin, UNIX, LDAP, Windows NT & Windows 2000, Microsoft Transaction Server (MTS), Microsoft Project 98 & 2000 and Microsoft Outlook.

Senior Programmer/ Project leader/ Business Analyst
Confidential, Westchester (NY) - Contractor March 1999 - December 1999

• Lead a team of programmers on the MITS application that was developed on Visual Basic 6.0 and Oracle 8.0.
• Developed several reports in Crystal reports and Excel for end users.
• Generated expense codes through the Oracle General Ledger for the marketing personnel for allocation of expenses.
• Involved the administration of the database users and rights to the objects in the database based on formal approval from management. Backed up databases on specific demand.
• Designed the flow charts for the application development and functionality flow of the application process.

Environment: SQL Server 2000, Visual Basic (6.0), C, Crystal Reports 7.0, Crystal Enterprise, MS Access 2.0 & 97, AS 400, Oracle General Ledger, Windows NT, UNIX, Windows 97, Microsoft Project 98 and Microsoft Outlook.

Senior Programmer/ Project Leader/ Analyst
Confidential, Lyndhurst (NJ) - Contractor March 1998 - March 1999

• Worked on the CRM application Quintus that was purchased from a third party vendor for help desk.
• Developed and modified several front end screens using Visual Basic and VBA.
• Built alerts into the CRM application in VBA to notify groups that were being allocated tickets by help desk to help the users.
• Developed custom pop ups for easy navigation for the end users.
• Implemented tight database security on data objects and administered the database rights for the users.
• Created User acceptance test scripts and conducted migration of code from development into production seamlessly.
• Implemented the project plan for the roll outs and conducted regular review meetings of the developers to check the progress of the project and its adherence to time lines and resource allocation.

Environment: Visual Basic 5.0, Oracle 7.3, PL/SQL, C, UNIX, VBA, Crystal Reports 6.0 & 7.0, Lotus Notes, Windows NT, Windows 97 and Microsoft Project.

Confidential, Berkeley Heights (NJ) - Contractor January 1997 - February 1998

• Developed and Modified the Business Unit Result System using Visual Basic, Oracle, Crystal Reports.
• Developed shell scripts to schedule the reports and application runs to process at specific off business hours.
• Wrote PL/SQL procedures to process and read data from the front end application.
• Fine tuned existing PL/ SQL objects and wrote triggers to ensure data integrity.

Environment: Oracle 7.3, Visual Basic 5.0, Crystal Reports 6.0, UNIX, PL/SQL 2.3, Windows NT, Windows 97 and Microsoft Outlook, Forms 2.3, 3.0 & 4.0, VAX/ VMS

Confidential, Manhattan (NY) - Contractor September 1995 - December 1996

• Responsible for designing, data modeling and developing financial accounting database system in Oracle (7.1) on UNIX platform.
• Developed forms in SQL *Forms 4.5 for the accounts receivable, account payable, Cash Management and General Ledger.
• Wrote triggers and stored procedures.
• Developed ad hoc reports in SQL *Report Writer (2.5)

Environment: Oracle 7.1, UNIX, SQL *Forms 4.5, SQL Report Writer 2.5, UNIX, Windows NT, Microsoft Outlook.