SUMMARY:

• Over 12 years of experience in software Development which includes 7+ years of ETL and Business Intelligence Experience in developing large - scale Data Warehousing Environment in Insurance Domain.
• 5 Years in Application/Product Development Experience in industries such as ERP and Banking.
• Proficient in Oracle Database (9i/10g/11g/12c), PL/SQL Programming, Oracle Data Integrator (ODI) 12c and Oracle Warehouse Builder 10g/11g.
• 2 Years of working experience in Oracle ERP (Oracle Application 11i) in HRMS Module.
• 5+ Years of experience in Client facing role (ONSITE locations: USA, UAE and East Africa).
• 2+ Years of work experience in USA (Work Location: Woodbury, MN 55125).
• Good understanding and working experience on Reporting Tools such as BOXIr3 and Tableau 8.1.
• Proficient in PL/SQL Programming with 11+ Years of Experience.
• Expertise in Data Warehousing (ETL) application development using Oracle 10g/11g/12c, PL/SQL, ODI 12c and OWB 10g/11g.
• Experience in developing Universes in SAP Business Objects XIr3 and Table Data Extract (TDE) in Tableau 8.1.
• Experience in developing Work books in Tableau 8.1.
• Expertise in Client-Server application development using Oracle 10g/9i, PL/SQL, Forms & Reports 6i/9i/10g Experience in designing/developing PL/SQL programs for .NET applications.
• Experience in Advanced PL/SQL such as Collections, BULK COLLECT, FORALL, Analytical Function, Table Partitions, etc.
• Experience in SQL & PL/SQL performance tuning.
• Experience in Development DBA activities.
• Exposure to both Relational and Dimensional data modelling.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
• Exposure to Big Data concepts.

TECHNICAL SKILLS:

Language: SQL, PL/SQL

RDBMS: Oracle9i/10g/11g/12c, Teradata

ETL Tools: ODI 12c, OWB 11g/10g

Reporting Tools: Business Object XIr3, Tableau 8.1

Operating Systems: Windows, UNIX,

GUI: Oracle Developer 2000 (Forms & Reports 6i,9i,10g)

ERP: Oracle Applications 11i (Module HRMS)

Scheduling Tools: Autosys

PROFESSIONAL EXPERIENCE:

Confidential, MN, Richfield

Tech. Lead 

Responsibilities:

• Had meeting with BA for Requirement Clarifications and sign off.
• Analyzed Requirements and provided the feedback on Requirements
• Involved in Design & Architecture Review
• Created Technical Specification Document for Final Approval
• Provided available Industry Standard Architectures for the current Requirements
• Involved in High Level Design Document creation
• Created ETL Programs in PLSQL.
• Involved in Code Review.
• Worked on performance improvements the of the PL/SQL.
• Timely resolution for Production Defects.
• Designing/implementing Archival Processes
• Estimation & Status Reporting
• Establish “Best Practices” and plan for continuous improvement of processes

Environment: Oracle 11g Database, PL/SQL & SQL Developer.

Confidential,FL

Tech. Lead 

Responsibilities:

• Had meeting with BA for Requirement Clarifications and sign off.
• Analyzed Requirements and provided the feedback on Requirements
• Involved in Design & Architecture Review
• Created Technical Specification Document for Final Approval
• Provided available Industry Standard Architectures for the current Requirements
• Involved in High Level Design Document creation
• Created SQL & PL/SQL Script to load Data (Historical Loads) into Target System
• Created ETL Programs in PLSQL, ODI12c and OWB11g.
• Involved in Code Review.
• Worked on performance improvements the of the PL/SQL & ETL programs
• Timely resolution for Production Defects.
• Upgrading from OWB 11g to ODI 12c
• Migrated ODI Components through Smart Export utility
• Configured Physical and Logical Architecture.
• Reverse Engineering Meta data into Work Repository
• Designing/implementing Archival Processes
• Estimation & Status Reporting
• Establish “Best Practices” and plan for continuous improvement of processes

Environment: Oracle 11g/12c Database, PL/SQL, ODI 12c, OWB 11g & Toad 11.

Confidential, MN

Tech. Lead 

Responsibilities:

• Had meeting with BA for Requirement Clarifications and sign off.
• Analyzed Requirements and provided the feedback on Requirements
• Created Technical Specification Document for Final Approval
• Provided available Industry Standard Architectures for the current Requirements
• Involved in High Level Design Document creation
• Involved in Design & Architecture Review
• Created SQL & PL/SQL Script to load Data (Historical Loads) into Target System
• Created ETL Programs in PLSQL and OWB11g and done code review.
• Worked on performance improvements the of the PL/SQL & ETL programs
• Timely resolution for Production Defects.
• Upgrading from OWB 10g to OWB 11g
• Project Monitoring and Metrics Reporting.
• Designing/implementing Archival Processes
• Estimation & Status Reporting
• Coordinate and Communicate with the Onshore
• Mentoring team Members.

Environment: Oracle 10g/11g Database, PL/SQL, OWB 10g/11g, Business Objects XIr3, Tableau 8.1, Autosys & Toad 11.

Confidential

Test Lead

Responsibilities:

• Technical Design Walkthrough with Dev Team.
• Prepared Preparing Test Plan & Scenario.
• Reviewing Test Plans/Cases/Data.
• Created test scripts
• Coordinate and Communicate with the Onsite
• Ensure the overall quality of the project
• Ensuring Timely Billing
• Training and Mentoring of the team members
• Estimating efforts.
• Preparing End of Test Report(EOTR)

Environment: Oracle 10g, Mainframes (JCL), Teradata, Data Stage & HP Quality Center 10

Confidential

Software Engineer 

Responsibilities:

• Developed and modified PL/SQL packages, functions and stored procedures for the GUI such as .NET and Oracle Forms 6i/Reports 6i.
• Created, maintained and Scheduled Materialized Views.
• Documented the changes made to the application periodically
• Worked with QA/UAT Team to setup Testing Environment
• Fine-tuned SQL queries to get maximum efficiency in various databases object using Oracle Hints
• Developed GUI in Forms6i and reports in Reports 6i
• Developed Reports in Oracle Discoverer 4
• Developed Customized Screens (Forms) in Oracle ERP
• Developed various data extracts based on business Demands.
• Involved in Incident/Problem management
• Involved in unit and integration testing.

Environment: Oracle 9i/10g Database, PL/SQL, Oracle ERP, Forms 6i, Reports 6i, PLSQL Developer & Oracle Discoverer 4.

Confidential

Software Engineer 

Responsibilities:

• Preparing low level design document
• Developed and modified PL/SQL packages, functions and stored procedures for the GUI Oracle Forms 6i/Reports 6i.
• Worked with UAT Team to setup Testing Environment
• Developed GUI in Forms6i and reports in Reports 6i
• Involved in Implementation and End User Training.

Environment: Oracle 9i Database, PL/SQL, Toad, Forms 6i & Reports 6i.

Confidential 

Software Engineer 

Responsibilities:

• Preparing low level design document
• Developed and modified PL/SQL packages, functions and stored procedures for the GUI Oracle Forms 6i/Reports 6i.
• Documented the changes made to the application periodically
• Worked with QA/UAT Team to setup Testing Environment
• Developed GUI in Forms6i and reports in Reports 6i
• Involved in Implementation and End User Training.

Environment: Oracle 9i Database, PL/SQL, Toad, Forms 6i & Reports 6i.