Career Summary

• Above 15 years of progressive US experience in the Computer Industry as Technical/ETL Lead and Senior Programmer/Analyst with several complete project life cycles including Systems Analysis, Design, Development, Testing, Implementation, Production Support and interaction with the Business/Requirement Analysts, Testers, End users and Auditors
• Worked with Waterfall, RAD, RUP, Risk Model, Agile, Off-Shore Development methodologies
• Familiarity with Capability Maturity Model
• Experienced in Information Engineering concepts, Relational Database Design and Development, data and process modeling using Rational Rose, Select, Designer 6i, ERWIN and Visio Professional
• Worked Extensively on Oracle Forms 9i/6i/4.5 Created Libraries, Templates, Tab controls, Object Groups, Dynamic Record Groups, used Oracle Reports 9i/6i/4.5, created report triggers and used Run Product, open form and Call Form options passing parameters from Forms to Reports, and Forms to Forms.
• Performed SQL Tuning using Oracle Explain Plan and TKPROF utilities
• Worked on Unix, Created batch jobs using Shell Scripts and used Unix Cron and Maestro Scheduler for scheduling and execution of jobs
• Experienced in Application Enhancements, Version Upgrades, Performance Tuning and Production Support
• Highly experienced in converting data from legacy systems to Oracle Database using SQL, Pro C, PL/SQL, sql loader, Unix Scripts and ETL tools
• Exposed to in HTML, XML, WEB Services, Java and Java Script
• Good understanding of Object Oriented Analysis and Design patterns
• Excellent communication skills and a good team player
• Highly motivated self learner with ability to develop proficiency and adapt to new technologies and processes quickly
• Languages SQL, PL/SQL, C, FORTRAN, JAVA, HTML, XML, Java Script, Pro C
• Operating System MS-DOS, Windows NT, Windows 2000, XP, Windows 7, AIX, HP-UX and Sun Solaris
• Database Oracle 12c/11g/10g/9i/8i/7.3, SQL SERVER
• Application Software Oracle Forms 9i/6i/4.5 and Reports 9i/6i/2.5, Developer 2000, PL/SQL Catridge, SQL LOADER, Tuxedo 8.0, MQ Series 6, JDeveloper, Jbuilder, Beyond Compare V2.0.2, Visio Professional 5.0b, MSAcess, MSWord, MSExcel, MSPowerpoint, TextPad, WinZip, Calyx, APEX
• CASE Tools Designer 6i/2000, ERwin, RATIONAL ROSE, SELECT
• Reporting Tools Oracle Reports 9i/6i/4.5, SQR 5.0
• Tools TOAD, PL/SQL Developer, TEST DIRECTOR 7.6, Team Play, Peregrine Service Center 5.1.4.0
• SCM Tools PVCS Tracker I-NET 7.5, CVS, AllFusion Harvest CM Workbench 5.1.1, Clearcase, Accurev
• ETL Tools Informatica, SSIS, Talend, ODI
• OLAP Reporting Tools Business Objects

Confidential

Senior DW Developer

Enhancements and Production Support

• Daily and Monthly DW Jobs On-call duties
• Created a new Data mart for the training database
• Enhanced multiple existing jobs using Unix, Autosys, SQL, PL/SQL, ODI, Oracle Reports 11i, APEX Screens
• Documented the new daily and monthly processes
• Work Environment: Oracle 11g, ODI 10g, PVCS, Autosys, Cache DB, Oracle Reports 11, APEX

Confidential

Lead Programmer Analyst

• As part of Architecture Group involved in Database design discussions, Partitioning, API Specifications etc.
• Provided code for PL/SQL API's using OWM and Flashback features for Changed Data Capturing and set-based approach in ETL
• Created Mapping and Design Document, Database objects, PL/SQL API's for ODI Scenarios and Load Plans
• Created global variables, folders, interfaces, packages, scenarios, Load Plans and models
• Created Unit Test cases in Oracle SQL Developer to test Scenarios and Load Plans
• Created reports using APEX on ODI Metrics for Scenarios and Load Plans executions using ODI work repository information
• Written Developer's Guides for the PL/SQL API's so that developers can use them for reference while using them
• Prepared Operating Instructions document on how to run Load Plans
• Participated in Peer Code Reviews

Work Environment: Oracle 11g, ODI 10g and 11G, Accurev, JIRA

Confidential

• Participated in Design reviews and created Design Document
• Created E-R Diagram, Table and DB Triggers scripts
• Worked on ODI Topology, created Data Server, Physical Schema Data and Work under data server, Logical Schema as alias for Physical Schema
• Created ODI Data Stores in the Model to store the metadata Reverse Engineered from Sources
• Configuring a File store, to host all the load files used by ODI
• Worked on Loading and Integration KM in Flow tab in ODI Interfaces.
• Worked on the heterogeneous source by applying joins with execution location as Target.
• Worked on Insert and Update of the Target by associating the Update Key on the Target
• Performance tuning of databases and ODI Interfaces
• Created reports using APEX on ODI Metrics for Scenarios and Load Plans executions using ODI work repository information

Confidential

• Worked on Production Support Issues with higher priority
• Participated in weekly Design Review meetings
• Based on the Requirements Document and Statements of Work for enhancements prepared Impact Analysis and Design Documents for Database, changes
• Coordinated the development efforts with off-shore team on tickets

Confidential

• Responsible to create an Impact Analysis Document on existing database objects
• Also responsible to design and document the new database changes
• Created Database Mapping documents for Dealer Invoicing data
• ODI programming and job scheduling to ETL the data into Oracle Database

Work Environment: Oracle 10g and 11g, ODI 10G, SQL SERVER, ERWIN, APEX, Oracle Forms and Reports, Jasper Reports, Java