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.

Operating Systems

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, 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 , MS Exchange, Developer 2000, MS Office 2000, Erwin, Peach tree, Polygon, Lotus AmiPro, Lotus Graphics, Visual Interdev, Visual SourceSafe, Lotus Notes, Quintus 3.1.

Experience

Senior Developer

Confidential

• Worked on the EAN Entity Aggragator Navigation system that was designed to optimally assemble, streamline and efficiently utilize the firm's current inventory of business transaction units which includes Organizations, Instruments, Quotes, Estimates etc. The data from the backend was pulled from different data sources through an Ingestion process and presented through a front end URL that accepts user parameters and outputs a XML data through webservices.
• Worked on the Ingestion process to write several stored procedures that pulled data from different data sources.
• Worked on Integrating the back end data with the front end web services by calling the data through stored procedures from web services. Used Agile programming methodology to develop the project with changing requirements.
• Scheduled the jobs to continuously pull Ingest data into the destination database from several data sources and making the data available for web services that gave the users XML output.

Environment : SQL Server 2008, C, Windows scripting, .Net, T SQL Stored procedures, Triggers, Indexes, Synonyms , Replication, Ingestion between various data sources, Microsoft Silverlight 3., Enterprise Library, Entity Framework 4.1, XML, XQuery, XSD, LINQ to XML, Fiddler2, Tortoise SVN, JIRA, Tidal Scheduler, SSIS, BIDS, BCP.

Senior SQL Developer and Business Analyst

Confidential

• Built and Modified the FIND Financial Intelligence Network Data Warehouse system that takes data from various sources and applies business rules and puts data into the central data warehouse and then build reports in various formats for the users management and field . This project involved multi layer interaction with the end users and managers from various departments to understand the data flow and implement the application.
• Worked on streamlining the tax implementation process through the third party application Vertex that allowed users to maintain and implement different tax rates for different products in various stores across the world. This process adhered to the tax laws of various countries, states, counties etc. I was involved in the architecture of building the application, the data flow and end to end testing of the application after implementation. We used Oracle 10g and third party application for this process.
• Building the Pospay application that interacted with the bank on the cheques issued and getting the acknowledgement of the cheques processed for the day for all vendors and stores. We used SSIS package and SQL Server to build this application.
• Involved in building, enhancing the Payroll application that built reports for all managers on the payroll processed for their areas of supervision. Strict adherence to access of reports only for authorized people was enforced through SQL Server reporting process.

Environment : Oracle 10 G, SQL Server 2005 2008, Visual Basic.Net, Microsoft Visual Basic Applications, XML, DHTML, VB Script, PL/SQL, SQL Server Business Intelligence Development Studio, Oracle Microsoft Access 2007, Business Objects XIR3, Data Integrator X1R2, Remote Desktop, Vertex.

Senior Programmer/ Business Analyst

Confidential

• 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 data base files on 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.

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, SQL Server 8.0, Business Objects XIR3, Data Integrator X1R2, Remote Desktop, Oracle Lite Repository.

Senior Programmer/ Business Analyst

Confidential

• 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.

Senior Programmer/ Business Analyst

Confidential

• 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

• 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

• 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

• 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.

Programmer/ Analyst

Confidential

• 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

Programmer/ Analyst

Confidential

• 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.