SUMMARY

• Extensive Experience in ORACLE PL/SQL Programming
• Excellent understanding of Database capabilities and Extensive Experience with ORACLE 8i/9i/10g/11g
• Strong Performance Tuning skills using Indexes Ranks Hints Exchange Partitions
• Extensive Experience in ODI Tools Topology Security Manager Designer and Operator
• Strong skills in Developing Stored Packages/Procedures Database Triggers Views Database Objects using PL/SQL
• Extensive Experience in Development of E-LT and ETL Mapping using Oracle Data Integrator ODI
• Strong Skills in creating ETL Jobs and Customization using Oracle Data Integrator ODI
• Excellent knowledge Data Warehousing concepts well versed with Dimension Modeling Star Schema Snowflake Schema Dimensions and Facts identification
• Hands on experience with Data Extraction Transformation and Data Loading in Data Warehouse Environments
• Experience with Oracle Forms 6i and Reports 6i/9i
• Experience with SQL Loader SQL Server Oracle Portal 9i/10g
• Experience with MS SRS Reporting Services
• Experience with SQL Navigator Toad
• Trained on Oracle Applications 11i APPS AOL Module
• Strong skills in writing Technical Specification and Design documents Scenarios Business Process Workflows Process Flows and Test Cases
• Exceptional ability to quickly master new concepts and capable of leading a team working in-group as well as independently with excellent communication skills.
• Knowledgeable of HIPAA and HITECH compliance regulations.

PROFESSIONAL EXPERIENCE

Sr Software Engineer.

Confidential

• Confidential is a Data Warehousing Solution that consolidates patient provider broker enrollment and insurance data from multiple sources through many ETL Interfaces and provides aggregated views with drill-down capabilities for Sales Claims Commissions Billing and Enrollments. Solution also includes multiple BI Reports with Custom enhancement capabilities.
• Lead a team that was responsible for Confidential.
• Development involved working with multiple sources such as Relational databases Flat files and required Extraction Transformation and Loading data into target tables and building Data Rich Views with Drill down capabilities.
• In addition to Team Lead I was also responsible for building ODS operational data store systems and OR operational reporting Modules.
• Primary responsibilities included but not limited to performing source-to-target mapping installing and creating Oracle11g database objects i.e. views tables functions architecting and developing custom ETL frameworks that consisted 300 plus processes using Oracle PL/SQL.
• Additional tasks included the creation of schema objects tables views indexes packages triggers etc. in an Oracle11g environment the expansion of a single dimensional data model star schema into multiple star schemas source to target mapping storage capacity planning . Modify existing ETL jobs in Oracle Data Integrator ODI . Developed data extracts from the data warehouse environment using ODI. Built many Inbound and outbound interfaces using PL/SQL.
• During the Initial phase focused on reengineering of the ETL processes using Oracle Data Integrator.

Responsibilities

• Provided 24x7 support for production operations incident break/fix change service request project and databases
• Ensured all production changes complied with change management policies and procedures.
• Developed a Troubleshooting Documents which listed all the support related activities and day-to-day issues encountered every day.
• Experience with full development cycle of a Data Warehouse including requirements gathering design implementation and maintenance.
• Worked with Type 1 and 2 dimensions Fact Tables Star Schema design Operational Data Store ODS leveling and other Data Warehouse concepts.
• Data cleansing data quality tracking and process balancing checkpoints.
• Create flexible data model design that is scalable reusable while emphasizing performance and business needs.
• Coordinated with all the concerned parties Database team/Project Teams/Application Team in trouble shooting issues and worked with other teams for major business critical production issues.
• Involved in Fine-tuning of Stored Procedures and SQL to obtain optimal performance and throughput.
• Participated in code reviews. Did code promotions from dev to test staging and production environment.
• Wrote unit test cases test scenarios unit test documents and also verified the test scenarios of the QA team. Unit tested for all the possible test scenarios.
• Did error analysis for continued improvement of the system by catching data anomalies and code issues.
• Planning and prioritizing the tasks to meet the deliverable deadlines.
• Used Oracle analytic functions global temporary tables etc
• Good understanding of ODI architecture and installation of Topology Security Manager agents Designer Operator Master repository and Work repository.
• Optimized the Knowledge modules for increasing the efficiency of jobs.

Reviewed code changes and coordinated migration from Development to SIT and then to Production Systems. Helped in Technical and Functional Documentation. Provided Production Support and addressed prioritized issues with urgency with minimal/no disruption to the Live System.

- Sr Software Engineer.

Confidential

Utilization and Analytics Profile product provides various Business Intelligence reporting capabilities and all with which PCP level specialist level analysis are conducted and ultimately the specialist level analysis is correlated back to the PCP final analysis for a global evaluation of the PCP s effectiveness. Solution also reliably measures the economic and quality performance of physicians identify and track Major Cost drivers in-depth insight into practice patterns.

• Worked on design and build of UA and Profile product using oracle packages store procedures configuration files tables views and functions implement best practices to maintain optimal performance.
• Created complex reports using multiple data providers user defined objects using MS SRS Reporting Services.
• Worked on all the profile methodologies and concepts.
• Involved in all phases of project and promotions from dev to test staging and production environment.

Confidential

Responsibility

• I was involved in all phases of project Requirement gathering to Production Support
• Because of large data volume performance tuning was a major part of this project.
• Some of the reports that I was closely involved are
• Fund Level Navigation Confluence Foreign exchange Trade Income Broker Cash management Transaction Summery Level holding Lot level holding.

Sr. Software Developer Confidential.

Responsibility

• Developed Control files UNIX scripts for the SQL Loader
• Developed Stored Procedures to load the repository
• Developed Stored Procedures to extract from the repository

Sr. Software Developer Confidential

Responsibility

• Enhancement of Search pages and Web Reports using Oracle Portal 9i.
• Enhanced all PDF and Excel JSP Reports using Oracle Reports 9i.
• Modified PL/SQL packages to populate and derive data for the reports
• Moved all reports from Oracle 9i to Oracle 10g Environment. Changes involved Oracle Portal setups PL/SQL procedure changes
• UAT support for Report Application