SUMMARY

• Over 6 years of IT experience in Software Systems Analysis, Design, Development, Testing, Implementation and Support in various business sectors. Accomplished developer in Informatica ETL, Oracle and SQL server

TECHNICAL SKILLS

Languages: Visual Basic, SQL, PL/SQL, T - SQL, Shell, XML, HTML

ETL Tools: Informatica Power Center 9.x/8.x

Datawarehouse: Oracle 10g/11g, SQL server 2008/2012

RDBMS: Oracle, SQL Server

DBMS Tools: Rapid SQL, SQLPlus, Oracle developer

Methodologies: SDLC, SCRUM/Agile, Data warehouse, Data Mining, Data Marts, Data Modeling Logical / Physical, Star/ Snowflake Schema, FACT & Dimension Tables, ETL, OLAP

Data Modeling Tools: Oracle Designer, Erwin

GUI tools: Excel, PowerPoint, MSWord, MSVisio

Version Control: CVS, SCCS

Job Scheduling tools: Unix Cron, Informatica Scheduler

Testing tools: Test Director, Win Runner, QTP

Operating Systems: Unix (Sun Solaris), Linux, Windows XP, Win 7

UNIX Emulators: Putty, Reflection

PROFESSIONAL EXPERIENCE

Confidential

ETL Developer

Responsibilities:

• Participate in project/ SSCR (Small system change request) related discussions
• Involved in implementation of the patches for Facets system upgrades
• Monitoring and debugging daily/weekly ETL jobs to ensure SLA’s are met.
• Involved in analyzing the ICD (International classification of Diseases by WHO) data mapping (ICD9, ICD10)in source and target level. ICD contains codes for diseases, signs and symptoms, abnormal findings, complaints, social circumstances, and external causes of injury or disease
• Involved in Extract, transform and loading of EDI X12 transactions
• Involved in Extract, transform and loading of HIPAA transactions 837 (Institutional/Professional), 835(Payment Remittance Advice) 270 (Eligibility Request) / 271 (Eligibility Response), 276 (Claims Status Inquiry Request) / 277 (Claims Status Inquiry Response), 834(Benefit Enrollment and Maintenance Transaction).
• Involved in Performance Tune of Informatica for source, transformation, targets, mappings and session.
• From the business requirements developed Logical & Physical Data models using Erwin Data modeler
• Worked with SME’s and business managers to understand the source system.
• Prepare design documents specifying the variousETL approaches, pros and cons of the different approaches with suggestions of the best approach.
• Design an end-to-end ETL process involving complex transformation likeSource Qualifier,Lookup,Update Strategy,Router, Aggregator, Sequence Generator, Filter, Expression, Stored Procedure, Transactional Controlfor the efficient extraction, transformation and loading of the data to the staging and then to the Data Mart (Data Warehouse) checking the complex logics for computing the facts.
• Used the reusable transformation, mappings and codes using Mappletsfor faster development and standardization.
• Used reusableSessionfor different level of workflows.
• Createdvariablesandparametersfiles for the mapping and session so that it can migrate easily in different environments and database.
• ImplementedSlowly Changing DimensionsType-1,Type-2approach for loading the target tables

Environment: Informatica Power Center 9.x, Oracle 11g, Erwin Data Modeler, SQL, PL/SQL, XML, Rapid SQL, UNIX Shell

Confidential

ETL Developer

Responsibilities:

• Analyze the Business requirements shared by onsite teams and develop the Data model that meets the Business requirements.
• Develop Conceptual, Logical & Physical Data models using Erwin Data modeler
• Prepare design documents specifying the variousETL approaches, pros and cons of the different approaches with suggestions of the best approach.
• Used the reusable transformation, mappings and codes using Mappletsfor faster development and standardization.
• Perform thorough Data profiling on Client’s source system, identify data gaps and worked with respective counterparts for the resolution.
• Maintain the Requirement Traceability Matrix (RTM) & Change Requests requested by Business.
• Performance Tuning of ETL queries

Environment: Oracle 10g, SQL server 2008, Informatica 8.x/9.x, SQL, PL/SQL, SCCS, UNIX

Confidential

ETL Developer

Responsibilities:

• Interactions with client on requirements and producing a detailed design and approach documents.
• Design the ETL process involving transformation likeSource Qualifier,Lookup,Update Strategy,Router, Aggregator, Sequence Generator, Filter, Expression, Transactional Controlfor the efficient extraction, transformation and loading of the data to the staging and then to the Data Mart
• Involved in Performance Tune of Informatica source, transformation, targets, mappings and session.
• ImplementedSlowly Changing Dimensionsfor loading the target tables

Environment: Informatica Power Center 8.x, Oracle 10g, Erwin Data Modeler, SQL, PL/SQL, Rapid SQL, Unix

Confidential

Database Developer

Responsibilities:

• As a member of the database design team, involved in preparation of ER models, normalization of objects, designing table structures, defining integrity constraints and Indexes.
• Was responsible for the design and development of database Triggers and Stored Procedures.
• Developed various masters and transaction user Interface screens and MIS reports.
• Involved in preparation of Unit and system test cases for the module.

Environment: Visual Basic, Oracle8/9, SQL, PL/SQL, Erwin, Windows