Summary

Hi I have over 12 years of experience in system and data analysis , designing and developing applications .14 years of Industry exposure has given me ample of opportunity to learn , implement different technical solutions to business domains such as transportation, telecommunication, healthcare finance. During these years, worked with System Analysts and/or business users to understand their business needs. Designed, developed, validated Database apps and Data warehouses, Data marts and ODS to support day to day business needs within the IT framework.

Work Experience

Senior Programmer Analyst/Tech Lead

Confidential

• Worked with different teams of business and IT, to collect data, analyze understand the information needs of users and the Systems.
• Worked with System Analysts to gather IT system requirements, and designed/developed/implemented the tactical/or strategic solution as appropriate to the Team Needs.
• Developed and supported datamart/ODS and Transaction systems and all the ETL layers to support the Dataflow across the systems.
• Analyzed existing systems to estimate and report impact of proposed changes.
• Designed and developed solutions to implement approved requirements.
• Developed test cases, documents, and validation protocols to complete unit testing, validation testing.
• Designed, developed, implemented and supported
• Oracle PL/SQL stored procedures /functions
• Oracle packages
• Insert/update/delete triggers
• Developed and tuned complex SQLs/views and materialized views
• Reading and Loading text and Binary PDF files using Blob/clob features
• And using SQR as the file processing language
• Developed Webservices and loading and Parsing XML files
• Scheduled ETL processes with the help of UNIX Shell Scripts and UC4 Batch Scheduling tool.

Tools: ORACLE 11/10g,Toad/sql developer , SQR , Unix and Uc4 batch processing /job scheduler.

Sr. BI ETL Consultant

Confidential

• Gathering day to day business requirements, issues and concerns from business users and worked with IT applications and IT Team to propose relevant long term or interim solutions.
• Analyzed System Data, to support individual needs of Business users.
• Supported the Sales, customer and invoice adjustment business units.
• Worked with different teams of business and IT, to collect, analyze understand the information needs of users and the Systems.
• Worked with SOX and IT compliance team to conduct and report test cycle results.
• Developed and supported SMART data warehouse.
• Designed, developed, and supported various systems including: Sales Roster and AMPS customer and sales representative alignment LASER, a contract management and billing system Returned Goods System RGS and Account Inventory Management System AIM
• Designed, developed, and supported various interfaces between Cordis systems and ERPs such as JDE, Siperian Master Data Management, and SAP Systems.
• Analyzed existing systems to estimate and report impact of proposed changes.
• Designed and developed solutions to implement approved requirements.
• Developed test cases, documents, and validation protocols to complete unit testing, validation testing, as well as integration testing to ensure proper SOX controls and Cordis validation controls were followed.
• Designed, developed, and implemented many Oracle PL/SQL stored procedures /packages /triggers/complex SQL/views/Triggers/Materialized Views/summary tables etc to troubleshoot and support performance issues and strategic solutions.

Tools: ORACLE 19i/0g,Toad , Excel , word, Custom developed ETL interface, in-house applications, Handheld Mobile sales rep inventory application , Unix.

Senior Programmer/Analyst

Confidential

• Responsible for maintenance and enhancement of projects: Licensure/DORA, using PowerBuilder 8 and Oracle 8 and Missouri Board of Registration and Call Tracking using PowerBuilder 8 and Sybase ASE as back-end. All the three projects used the custom developed framework.
• Analyzed the existing application and custom built framework and implemented solution to various issues.
• Wrote user objects, stored procedures, packages, triggers, and complex SQL to resolve various issues in Oracle environment.
• Developed Sybase and Oracle PL/SQL procedures and functions.
• Migrated the Call Tracking application to PowerBuilder 9.0.

Tools: ORACLE 8i/9i, Powerbuilder 9, PL/SQL developer.

Senior Programmer/Analyst

Confidential

• Maintained the PowerBuilder application.
• Provided production support, and wrote UNIX Shell Scripts and oracle stored procedures/packages/functions/complex SQLs/PL/SQL collections.
• Monitored the Autosys jobs and scheduled the jobs.
• Tools: Autosys Job scheduler, UNIX C Shell, Oracle 8, PowerBuilder 8

Programmer Analyst

Confidential

• Analyzed the existing application and implemented solutions to various issues.
• Analyzed the impact and developed a solution for Mobile Equipment Identification MEID , as a part of major enhancement for the project.
• Wrote and maintained stored procedures to enforce business rules to manipulate the data, and to fetch the data into DataWindow reports.
• Wrote packages to store and create the logically related procedures and functions.
• Wrote SQL queries to manipulate, retrieve, and to fine tune SQL performance.
• Updated the required documents, and developed help files for the requested changed using the RoboHelp 5 for Word.
• Tools: Powerbuilder , Oracle 8i , PFC and OLE and OCX controls, TOAD

Analyst/Developer

Confidential

• Collected and analyzed business requirements from the user community.
• Designed and developed BMS programs in PowerBuilder 8.0, Oracle 8.0.4, and Sybase ASE 12.0.
• Wrote and maintained data uploading scripts Transact SQL, procedures and functions for Sybase ASE 12.0 to upload the data into Sybase database.
• Wrote Sybase SQL statements that use joins or sub queries to combine data from multiple tables.
• Created scripts by using Sybase SQL. Programming elements included control-of-flow techniques, local and global variables, functions, and error handling techniques.
• Designed, created, used, and altered views.
• Modified data through a view.
• Query data through a ORACLE views.
• Created and executed stored procedures to enforce business rules, modify data in multiple tables, perform calculations, and to use input and output parameters.
• Developed interfaces to Process master detail relationships in a transaction processing, query time processing, transactional processing, validation and key processing.
• Wrote scripts to create temporary tables to manipulate and process data.
• Connected data was fetched from procedures into DataWindow through remote procedure calls, and depending on the database.
• Wrote test scripts and software testing.
• Worked on system maintenance, enhancements, and report generation.
• Developed database procedures and functions with PL/SQL and Oracle 8.0.4.
• Wrote T-SQL queries to retrieve and update the Sybase / Oracle database.
• Provided production support.
• Worked on application migration from PowerBbuilder 5 to PowerBuilder 8.
• Tracked development time schedule task using Niku Time.
• Tools: PowerBuilder 8.0,7.0, 5.0, PFC, Oracle 8.0.4, 7.3, Net8, PL/SQL, Humming Bird, SQL Loader, SQL Navigator 4, Erwin 3.5.2, Sun Solaris OS 5.8, UNIX
• Project: Congestion Management System A sub-system of TMS that includes CMS Gateway, Congestion Management, Geography Package, Area Package, Road Segment Package, and Deficient Segments.
• Collected and analyzed business requirements from the user community.
• Designed and developed CMS programs in PowerBuilder 8.0 and Oracle 8.0.4.
• Wrote test scripts and conducted software testing.
• Worked on system maintenance, enhancements, and report generation.
• Developed database procedures and functions with PL/SQL and Oracle 8.0.4.
• Provided production support and worked on application migration from PowerBuilder 5 to PowerBuilder 8.
• Tracked development time schedule task using Niku Time.

Tools: PowerBuilder 8.0,7.0, 5.0, Oracle 7.3, Oracle 8.0.4, PL/SQL, SQL Navigator, SQL Net, Humming Bird , Sun Solaris UNIX

Confidential

• Gathered and analyzed business requirements from the user community.
• Worked on migration of the code from third party product called PortMapper to the new tool Entera.
• Designed and developed SMS, IMS and PTMS programs in PowerBuilder 8.0 and Oracle 8.0.4.
• Wrote Sybase procedures for Sybase database, which does the same functionality as the Oracle does.
• Wrote and maintained data uploading scripts Transact SQL, procedures and functions for Sybase ASE 12.0 to upload the data into Sybase database.
• Wrote Sybase SQL statements that use joins or sub queries to combine data from multiple tables.
• Created scripts by using Sybase SQL. Programming elements include control-of-flow techniques, local and global variables, functions, and error handling techniques.
• Design, create, use, and alter views.
• Modified data through a view.
• Query data through a ORACLE views.
• Created and executed stored procedures to enforce business rules, modify data in multiple tables, perform calculations, and to use input and output parameters.
• Wrote scripts to create temporary tables to manipulate and process data.
• Wrote test scripts and software testing.
• Responsible for system maintenance, enhancements, and report generation.
• Developed database procedures and functions with PL/SQL, Oracle 8.0.4, Sybase procedures, and T-SQL for Sybase specific scripts for Sybase 12.x.
• Provided production support and worked on application migration from PowerBuilder 5 to PowerBuilder 8.
• Maintained and enhanced framework for which all six TMS subsystems were developed.
• Tracked development time schedule task using Niku Time.
• Tools: PowerBuilder 8.0,7.0, 5.0, Oracle 7.3, Oracle 8.0.4, Erwin 3.5, PL/SQL, SQL Navigator, SQL Net, Humming Bird, Sun Solaris, UNIX

Confidential

• Created PowerBuilder components.
• Created HTML DataWindow.
• Developed service classes.
• Tools: PowerBuilder 8.0, Oracle 8.0, Jaguar 4.x, Power Dynamo, JavaScript, HTML, HTML DataWindow

Analyst/Developer

Confidential

• Analyzed problems based on user inquiries.
• Wrote enhancement programs using PowerBuilder 4.0.
• Performed maintenance changes to existing QSend programs.
• Set up values and debugged code.
• Tools: PowerBuilder 4.0, 5.0 Oracle 7.3, PowerTool, Gupta SQL, Windows 95/NT