SUMMARY

• Over 7 years of IT experience with extensive experience in Data warehousing, Data Analysis, Reporting, ETL, Data Modelling, Development, Maintenance, Testing and Documentation.
• Excellence in the implementation of Data Warehouse and Business Intelligence using ETL tools like Informatica PowerCenter (versions 9.5/8.6) PowerMart, PowerExchange (version 9), PowerAnalyzer, IDQ, and Informatica B2B.
• Highly motivated and goal - oriented individual with a strong background in SDLC Project Management and Resource Planning using AGILE methodologies
• Proficient in the Integration of various data sources with multiple relational databases like Oracle11g /Oracle10g/9i, MS SQL Server, DB2, Netezza, Teradata, Flat Files into the staging area, ODS, Data Warehouse and Data Mart.
• Extensive experience in developing Stored Procedures, Functions, Views, Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL.
• Performed the data profiling and analysis making use of Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ).
• Involved in implementing the Land Process of loading the customer/product Data Set into Informatica MDM from various source systems
• Experienced in developing Test Plans, Test Strategies and Test Cases for Data Warehousing projects ensuring the data meets the business requirements.
• Good command in Designing/Developing complex Mappings and Mapplets using transformations like Connected/Unconnected Lookups, Router, Filter, Expression, Aggregator, Normalizer, Joiner and Update Strategy.
• Strong knowledge of Entity-Relationship concept, Facts and dimensions tables and developing database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional data modelling.
• Good in SQL tuning and Informatica performance tuning. Tuned performance of Informatica Sessions for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Good in OLAP Data modelling, for both Star Schemas and Snowflake Schemas. Solid understanding of Data Warehousing life cycle and strong working experience on Data Warehousing applications.
• Expertise in creating Universes and Reports using Business Objects 6.5.1 and BO-XI
• Extensively used Teradata Utilities like Tpump, Fast-Load, MultiLoad, BTEQ & Fast-Export.
• Good experience in Automation and scheduling of UNIX shell scripts and Informatica sessions and batches using control-m scheduling tool.
• Good experience in generated reports using OBIEE.
• Excellent communication & interpersonal skills.

TECHNICAL SKILLS

Operating System: Windows/XP/7/UNIX/Fedora/AIX

Database and utilities: Oracle 9i/10g/11g, MS SQLServer, Netezza, Teradata V13.10, Sybase, Erwin 3.5/4.0, IBM DB2, Business Objects.

Informatica Tools: Informatica PowerCenter 9.6/9.5/8.6/8.1/7.1 , Informatica B2BDT, Informatica Power exchange, Informatica Data Quality, Informatica Data Analyser, Informatica Metadata Manager

Database Tools: SQL *Plus, TOAD, Autosys.

Programming Languages: C, C++, SQL, PL/SQL, HTML, UNIX Shell Script

Other Tools: Crystal Reports, OBIEE, Tableau, Control-M

PROFESSIONAL EXPERIENCE

Confidential, VA

Informatica Developer

Responsibilities:

• Involved in analysis of source systems, business requirements and identification of business rule and responsible for developing, support and maintenance for the ETL process using Informatica.
• Comprehensively analyzed and systematically documented the end-to-end flow of the Inbound and Outbound claims file (834 HIPAA).
• Development of Informatica mappings and PL/SQL blocks ranging from medium level complexity to highly complex.
• Developed complex mappings using Informatica PowerCenter Designer to transform and load the data from various source systems like Oracle, Teradata, and Sybase into the Oracle target database.
• Extensively Worked in Processing Structured and Unstructured data.
• Informatica B2B Data Transformation used to support transformations and mappings, via XML, of most healthcare industry standards.
• Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records.
• Configured match rule set property by enabling search by rules in MDM according to Business Rules.
• Maintaining the Quality matrices, Knowledge management and Defect prevention & analysis.
• Used breakpoints and various test conditions with Debugger tool to test the logic and the validity of the data moving through the mappings.
• Extensively used the Slowly Changing Dimensions-Type II in various data mappings to load dimension tables in Data warehouse.
• Using Source Qualifier & Lookup SQL overrides, Persistent caches, Incremental Aggregation, Partitions, and Parameter Files for better performance.
• Used session logs, workflow logs and debugger to debug the session and analyse the problem associated with the mappings and generic scripts
• Tested all the applications and transported the data to the target Warehouse Oracle tables, schedule and run extraction and load process and monitor sessions and batches by using Informatica Workflow Manager.
• Created Migration Documentation and Process Flow for mappings and sessions.
• Migrated mappings from Development to Testing and performed Unit Testing and Integration Testing.

Environment: Informatica Power Center 9.6, Informatica B2BDT, Informatica MDM, PL/SQL, HIPPA5010, Teradata, TOAD, Oracle 10g, Korn Shell, OBIEE, Flat files (fixed width/delimited), Erwin.

Confidential, Jacksonville, FL

Informatica & IDQ Developer

Responsibilities:

• Extensively involved in the Analysis, design and Data Modeling.
• Validated the archived jobs using DVO (data validation tool)
• Developed ETL procedures to ensure conformity, compliance with CareFirst standards.
• Created Migration Documentation and Process Flow for mappings and sessions.
• Developed the transformation logic; identifying and tracking the slowly changing dimensions, heterogeneous sources and determining the hierarchies in dimensions.
• Developed complex ETL Mappings and Mapplets in Informatica to load data from various sources to Data warehouse.
• Analyzed all the critical andHigh priority defectsand fully responsible for fixing it.
• Involved in various transformations like Source Qualifier, Look up, Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router transformations.
• Created Informatica server administration automation scripts, Shell scripts for data manipulation and process automation using UNIX Shell scripting.
• Worked extensively on Flat Files, as the data from various Legacy Systems parsed the Functional specifications into a Technical document, which would provide an efficient platform for peers for development.
• Designed multi-dimensional Star schema, Generated the database scripts, E-R diagrams using ERWIN.
• Generated server side PL/SQL scripts for data manipulation, validation and provided DDL scripts for creation of database objects such as tables, indexes, views, sequences, object types, collection types and Materialized Views.
• Generated reports of Multidimensional analysis, slice and dice and drill down reports.
• Created, Scheduled and Monitored Batches and Sessions using Power Center Server Manager/AutoSys/Crontab.

Environment: Informatica- Power Center 9.5, Oracle 11g, DB2, SQL Server, Shell Scripts, Control-M Autosys, Power Exchange, IDQ, Business Objects, Erwin, Windows 7, Unix .

Confidential, San Jose, CA

Informatica Developer

Responsibilities:

• Involved in the requirement definition and analysis in support of Data Warehousing efforts
• Developed ETL mappings, Transformations and Loading using Informatica Power Center
• Extensively used ACE Component from First Logic, which is an address-cleansing tool, in all the transformations.
• Used Active as well as Passive advanced external procedure transformations involving high complexity.
• Extensively used ETL to load data from Flat files which involved both fixed width as well as Delimited files and also from the relational database, which was Oracle 9i.
• Developed and tested all Informatica mappings involving Advanced External Procedure, complex lookups and update strategies.
• Created Shell scripts for moving the Flat files from one directory to another once the session is done.
• Wrote Shell scripts to create file list for different kinds of flat files that included both delimited and fixed width files.
• Configured sessions with email when failure, command task and decision task.
• Involved in partitioning of the sessions and performance tuning of database and Informatica
• Worked on Dimension as well as Fact tables, developed mappings and loaded data on to the relational database.
• Worked extensively on different types of transformations like source qualifier, expression, filter, aggregator, rank, update strategy, lookup, stored procedure, sequence generator, joiner and normalizer.
• Analyzed the session, event and error logs for troubleshooting mappings and sessions.
• Extensively used PL/SQL, TOAD for creating views, stored procedure, and indexes on the tables.

Environment: Informatica Power Center 9.1, Erwin 4.2, Oracle 9i, SQL * Plus, PL/SQL, First Logic ACE Component 7.2, Toad 7.6.0.1.1, F-Secure SSH Client 5.3 Build 21, F-Secure SSH File Transfer, Windows XP Professional, UNIX.

Confidential, Denver, CO

Informatica Developer

Responsibilities:

• Responsible for business analysis and requirements collection and involved in designing technical specification.
• Extracted data from relational databases Oracle and Flat Files.
• Developed data Mappings, Transformations between source systems and warehouse
• Created sessions, sequential and concurrent sessions for proper execution of mappings in workflow manager.
• Used Power Center Data Masking Options (Random Masking, Blurring, SSN and Credit Card) in mappings.
• Responsible to design, develop and test the software (Informatica, PL/ SQL, UNIX shell scripts) to maintain the data marts (Extract data, Transform data, Load data).
• Developed Complex transformations, Mapplets using Informatica to Extract, Transform and load data into Enterprise Data warehouse (EDW) and Operational Data Store (ODS).
• Managed writing test cases, test scenarios from requirement for newly added features and executing test scripts.
• Recording, tracking and closing of defects/bugs in a systematic manner into a Defect Tracking System and preparation of bug report with bug severity and bug priority.
• Used debugger to test the mapping and fixed the bugs.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data.
• Included data from different sources like Oracle Stored Procedures and Personal data files in the same report.
• Responsible for daily verification that all scripts, downloads, and file copies were executed as planned, troubleshooting any steps that failed, and providing both immediate and long-term problem resolution.

Environment: Informatica Power Center 8.6.1, Oracle 10g, Access, Flat files, UNIX shell scripting, Windows XP.

Confidential

Oracle/ETL Developer

Responsibilities:

• Involved in designing and developing the database for the business division of Creative Eye at Focus for effectively managing manufacturing processes.
• Designed and developed database views and stored procedures.
• Maintained user roles and privileges at the database level.
• Involved in enrolling users, maintaining the system security.
• Involved in controlling and monitoring user access.
• Used SQL to extract the data from the database.
• Worked with Development Life Cycle teams.
• Wrote Stored procedures, Stored functions, Packages and used in many Forms and Reports
• Wrote database triggers for automatic updating the tables and views.
• Designed and developed forms and reports.
• Involved in the creation of jobs using Informatica workflow manager to validate schedule run and monitor jobs using Workflow Monitor.
• Involved in the preparation of documentation for ETL using Informatica standards, procedures and naming conventions.

Environment: Informatica Power Center 7.1, Oracle, Oracle Forms 5.0/4.5, Reports 2.5, SQL, PL/SQL, Windows XP, SQL Navigator, Erwin3.5, UNIX.