SUMMARY

• Seven (7) Years of Total IT experience in the designing, developing and maintaining large business applications such as data migration, conversion, data warehouse and Testing.
• Extensive experience in Business Requirements Analysis, Application Design, Data Modeling, Development, Implementations and Testing of data warehousing.
• Seven (7) Years of hands on experience in oracle and PL/SQL writing Stored Procedures, Packages, functions, cursors, triggers, views, materialized views.
• Five Plus (5+) Years of experience in data warehousing applications including analysis, architecture, design, development, support and ETL architecture using Informatica Power Center. Experience in performance tuning of ETL Informatica code.
• Five Plus (5+) Years of data modeling experience using ERwin. Good understanding of Data Warehouse/Data mart concepts OLAP & OLTP systems from design and analysis to implementation. In depth experience in star or snowflake schemas, conceptual, logical and physical modeling.
• Four Plus (4+) years of hands - on experience with UNIX scripting.

TECHNICAL SKILLS

Data Modeling: OLAP, OLTP, Data Modeling, Star and Snowflake Modeling, Fact and Dimensions Tables, Conceptual, Logical and Physical Data Modeling, ERwin Data Modeler 7.1

Operating Systems: UNIX-Sun Solaris 2.8, HP-UX, IBM AIX 4.3, MS DOS 6.22, Windows 7

Databases: Oracle 11g, IBM DB2 8.0, MS SQL Server 2005, Teradata V2R6.

Data Warehousing: Informatica Power Center 9.0, Autosys, IBM Maestro. Data cleansing tools- First Logic (Ace, DataRight, Merge/Purge), Trillium 7.0 (Converter, Poster, Geo-Coder, Matcher). SQL Developer, PL/SQL Developer

Programming Languages/ GUI: SQL, PL/SQL, SQL Plus, C, C++, PL/SQL, Unix Shell Scripting

Business / Data Analysis: Functional Requirements Gathering, User Interviews, Business Requirements Gathering, Process Flow Diagrams, Data Flow Diagrams, MS Project, MS Access, MS Office

Business Intelligence: Business Objects 3.1

Other Tools: SQL *Loader, Toad, MS Access Reports, SQL Server Management Studio, Team Foundation Server (TFS), PowerSuite, Visual Studio 2012, Test Manager.

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

PL/SQL DEVELOPER

Responsibilities:

• Understand the Business point of view to implement coding using SQL Developer.
• Participated in project planning sessions with project managers, team leads and team members to analyze business requirements and outline the proposed solution.
• Participation in Database Design and Technical Specifications Documentation in SharePoint.
• Designed mappings for different subject area Claims, Policy, Provider, Customer etc.
• Wrote UNIX scripts and SQL commands to test and analyze the data.
• Design and develop ETL programs to move data from legacy to target using PL/SQL.
• Work with conversion development team to create conversion routes.
• Parsing high-level design spec to simple SQL coding and mapping standards.
• Extracting the data from different sources like Oracle, DB2 Mainframes and migrating to staging tables and to target (Power suite) using PL/SQL stored procedures & Packages.
• Work with subject matter experts to design and develop data validation approaches to confirm all data converted correctly.
• Developed the test scripts and performed the Unit Tests on PL/SQL stored procedures, packages.
• Used debugger to test the code and fixed the bugs.
• Performance tuning of SQL queries, SQL and PL/SQL coding.
• Execute mock conversions, review results, document, investigate and resolve conversion defects in a timely manner.
• Prepare unit test plans, code review, and testing, debugging, deployment of SQL jobs into production environment.
• Developed QA/QC processes using Team Foundation Server (TFS) and shell scripts to help identify data quality issues.
• Support data cleansing efforts.
• Worked extensively with Claims Data, Policy Data and ICD Codes. Followed HIPAA rules, regulations and transactions sets.

Environment: SQL Developer, PL/SQL Developer, SQL Loader, Team Foundation Server (TFS), Source Control explorer, Test Manager, Power Suite, Oracle 11g, DB2 8.0, UNIX, SharePoint, Visual Studio 2012

Confidential, Newark, NJ

SR. DW INFORMATICA DEVELOPER & PL/SQL DEVELOPER

Responsibilities:

• Participated in Users meetings to understand the Business point of view and to implement coding using Informatica power center designer.
• Worked with project managers, team members to analyze business requirements and outline the proposed solution.
• Assisted in logical and physical modeling, followed star schema to build claims Datamart using Erwin.
• Parsing high-level design spec to simple ETL coding and mapping standards.
• Designed mappings for different subject area Claims, Procedures, Provider, Reference, Member etc.
• Developed (SCD 1) and (SCD 2) to capture new changes while maintaining the historic information.
• Worked with workflow manager and workflow monitor to schedule batches and run the workflow and monitor session logs.
• Effectively tuned the performance of Informatica transformations, mappings, sessions and workflows.
• Used partitioning schemas in order to improve the overall session performance.
• Extensively involved in writing PL/SQL stored procedures, packages and functions.
• Preparation of unit test plans, verification of functional specifications and review of deliverables.
• Migrated mappings, sessions, workflows and common objects from development to test and to production.
• Wrote UNIX scripts and SQL commands to test and analyze the data.
• Used Autosys and Informatica scheduler for scheduling the jobs.
• Assisted in handling production support issues.
• Did design and code reviews for the Production support project.
• Developed QA/QC processes using shell scripts to help identify data quality issues prior to production and provide pre-processed data source.
• Performed various testing processes unit testing, end to end test & regression testing.
• Used BO reporting tool to generate internal reports for claims to review the data.
• Generated WebI and ad-hoc reports for the end users.
• Worked extensively with HL7 Data, HIPAA Transactions, and ICD Codes. Followed HIPAA rules, regulations and transactions sets.
• Extensively worked on different claims like ICD-9 codes relates to diagnosis, procedures and service related programs, other claims like Procedure Modifier Codes like CPT (Current Procedural Terminology) and HCPCS codes.

Environment: Informatica Power Center 9.0, Oracle 11g, SQL Server 2005, DB2 8.0, Autosys, UNIX-AIX VERSION 5, Erwin 7.1, TOAD, BO 3.1.

Confidential, Houston, TX

INFORMATICA DEVELOPER

Responsibilities:

• Worked with business analysts, Architects and functional team members to translate business requirements into technical specifications and finalizing the data model.
• Designed, developed and maintained ETL Code to meet the requirements of the Business Intelligence group.
• Participation in database design and database architecture.
• Design, develop, review and test the ETL process to handle extraction transformations and loading requirements of the data.
• Worked with Informatica and ODI for ETL.
• Used change data capture (CDC) to determine (and track) the data so that action can be taken using the changed data.
• Used Informatica to automate the process of Extract, Transform and Load from mainframe systems DB2 tables and datasets to target warehouse.
• Created Mapplets and used them in different Mappings for maintain the standards.
• Used debugger to test the mapping and fixed the bugs.
• Developed the test scripts and performed the Unit Testes on the ETL mappings.
• Developed and scheduled workflows using workflow designer in workflow manager and Maestro.
• Used trillium to cleanse the data.
• Writing Oracle packages, PL/SQL stored procedures, functions and call them through Informatica and /or UNIX scripts. Extensive UNIX Shell Scripting.
• Responsible for performance tuning for better performance.
• Used BO reporting tools to generate internal reports.
• Prepare unit and integration test plans, code review, testing, debugging, deployment of Informatica jobs into production environment. Provided Production Support.