SUMMARY:

• 6+ years of overall experience working in the Information Technology Industry.
• Experience in BI / Data warehouse projects involving Informatica and Cognos suite of products.
• Experience in data warehousing using various ETL tools (Informatica 6.1/7.1/ 8).
• Experience in working with data warehouses and data marts using Informatica Power center (Designer, Repository Manager, Workflow Manager, and Workflow Monitor).
• Understanding & Working knowledge of Informatica CDC (Change Data Capture).
• Developed Strategies for Extraction Transformation Loading (ETL) mechanism.
• Extensive knowledge with Dimensional Data modeling, Star Schema/snowflakes schema, Fact and Dimension tables.
• Extensive work with PL/SQL, performance tuning of Oracle.
• Experienced with Informatica PowerExchange (5.x/8.x) for Loading/Retrieving data from mainframe systems.
• Experienced Oracle Apps (Oracle E-Business Suite).
• Experience in Data Modeling experience using ERWIN 3.x
• Experience with Teradata as the target for the data marts.
• Extensive Unix Shell Scripting knowledge.
• Extensive experience with relational databases (Oracle 8i/9i/10g, Teradata v2 R6, SSIS, Sql Server 2000/2005).
• Experience in Cognos 8 Series.
• Experience in Load balancing /optimizing resource usage and defining Environment Variables for performance tuning.
• Generating and deploying Powerplay cubes and reports in Unix and windows environments
• Proficient in network installations and troubleshooting.
• Reliable, responsible, hard working and good team player.

TECHNICAL SKILLS:

• ETL Tools:Informatica 6.0, 6.1, 7.1, 8,9, SSIS
  
• RDBMS: Oracle 8.x/9.x,10g, Teradata v2 R6, DB2, Sql Server 2000/2005
  
• Database skills: Stored Procedures, Database Triggers, and Packages
  
• BI / OLAP tools: Cognos Series 8 v8.2/8.3/8.4, SSRS,Business Objects.
  
• Languages: SQL, HTML/DHTML, UNIX, C, C++, Java, COBOL, VB .net, Assembly language
  
• Web Servers: IIS v4.0/5.0/6.0, Apache Tomcat
  
• OS:UNIX/Solaris, Red Hat Linux, AIX, Windows 2000/2003/XP/Vista
  
• Hardware: IBM PC Compatibles and NT servers
  
• Version Control: Visual Source Safe 6.0, CVS, Documentum Tools
  

EDUCATION:
Bachelor’s in Computer science engineering, Confidential India

Professional Summary:

Client: Confidential, Palatine, IL 2011 - Present
Sr. Informatica Developer

Description: Data from newly acquired companies are merged with the existing data. After the process of Data warehousing, different reports were generated for claims, billing, members/ subscribers and sent to respective departments and employees.

Responsibilities:

• Involved in requirement, analysis and understanding of business requirements identify the flow of information and analyzing the existing systems.
• Designed Distributed Architecture for new data mart for HR and Sales, 401K etc.
• Analyzed the source data coming from Oracle, Flat Files, and DB2 coordinated with data warehouse team in developing Dimensional Model.
• Involved in the data analysis for source and target systems and good understanding of Data Warehousing concepts, staging tables, Dimensions, Facts and Star Schema
• Integration of various data sources like Oracle, SQL Server, Fixed Width and Delimited Flat Files.
• Extensively worked on Informatica Power Center tools- Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager
• Developed slowly changed dimensions (SCD) Type 2 for loading data into Dimensions and Facts.
• Worked on Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Stored Procedure, Sequence Generator, Filter, Sorter, and Source Qualifier.
• Migration of New and Changed Informatica objects across the environments using Folder to Folder and Deployment Group methods.
• Created shell scripts to run daily jobs and extract the files from remote location for data loads.
• Created reusable Mappings, Mapplet, Transformations and Parameter files for Data Quality Plan.
• Improved Informatica process creating index, used cache files and session level partitions in Informatica.
• Created, updated and maintained ETL technical documentation for Production Migration.

Environment: Informatica Power Center 9.x/8.x, Oracle 10g, PL/SQL, PL/SQL Developer, Data Flux, BPM (Business Process Management), Win CVS, Window XP, DB2, UNIX

Client: Confidential, Lyndhurst, NJ May 2010-Sep 2011
Informatica Developer

Description: Quest Diagnostics offers a wide range of products and services that benefit patients, healthcare providers, and pharmaceutical medical device companies, life insurance companies and employers. Diagnostics test portal is a product that touches wide variety of healthcare aspects. The project enables patients to log in their disease records, symptoms, schedule appointments for diagnosis and also enables them to view electronic billing. It enables overall hospital management like billing/registration, in-patient scheduling, hospital inventory management, pharmacy management, reports generation etc. Also available are features such as reports generation.

Responsibilities:

• Requirement gathering, analysis and designing technical specifications for the data migration according to the business requirement.
• Developed logical and physical dimensional data models using ERWIN 7.1
• Developed test cases and test plans to complete the unit testing. Support System testing.
• Planned and coordinated testing across multiple teams, tracked and reported status, created testing cycle plan, scenarios etc
• Designed, developed and improved complex ETL structures to extract, transform and load data from multiple data sources into data warehouse and other databases based on business requirements.
• Developed complex mappings and SCD Type-I, Type-II and Type III mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Lookup, Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Normalize, Filter, Rank and Router, Stored Procedure, XML and SQL transformations.
• Responsible for normalizing COBOL files using Normalize Transformation.
• Responsible for testing, modifying, debugging, documenting and implementation of Informatica mappings.
• Performed metadata validation, reconciliation and appropriate error handling in ETL processes
• Troubleshoot data issues, validated result sets, recommended and implemented process improvements.
• Responsible for performance tuning in Informatica Power Center at the Target Level, Source level, Mapping Level, Session Level, and System Level.
• Extensively worked with SQL queries. Created Cursors, functions, stored procedures, packages, Triggers, views, materialized views using PL/SQL Programming.
• Extensively worked with performance tuning of Oracle
• Used ANALYZE, dbms stats, explain plan, sql trace, sql hints and Tkprof to tune sql queries.
• Extensively used Oracle partitioning (range/hash/list), indexes (bitmap, B-tree, reverse key, etc) and various join types (hash joins, sort merge, nested iteration join) to improve the performance.
• Used Informatica Power Exchange for loading/retrieving data from mainframe system.
• Hands on experience with Informatica Metadata Manager
• Design/developed and managed Power Center upgrades from v7.x to v8.6, Migrate ETL code from Informatica v7.x to v8.6. Integrate and managed workload of Power Exchange CDC.
• Extensively worked with incremental loading using Parameter Files, Mapping Variables and Mapping Parameters.
• Developed user defined functions (UDF) to extract data from flat files
• Developed and modified UNIX korn shell scripts to meet the requirements after the system modifications and was also involved in monitoring and maintenance of the batch jobs.
• Worked with Autosys for Job scheduling.
• Worked with complex Cognos reports in Report Studio using master-detail relationship, drill through, drill up and drill down, burst options, and Prompts.
• Created dashboards for a managerial overview with drill up and drill down capabilities.
• Created complex reports that had multiple pages, multiple UI items like lists, charts, graphs
• Used Data Source Query Subjects, Model Query Subjects and Stored Procedure Query Subjects in Framework manager.
• Supported and assist the Lead Architect with project planning, analysis, design, testing, system documentation and user training.
• Managed work assignments and coordinated within the development team

Environment: Informatica Powercenter 7.1.x, 8.6,Oracle 10g & 11g, PL/SQL, Cognos 8.3,Toad, Unix, Erwin 7.1,Windows XP, Autosys.

Client:Confidential, PA Mar 2009-April 2010
Informatica Developer

Description: Sanofi Pasteur is a multinational pharmaceutical company, the world’s fourth-largest by prescription Sales. Sanofi Pasteur is the vaccines division of sanofi-aventis Group. It is the largest company in the world devoted entirely to vaccines. Sanofi-Aventis engages in the research and development, manufacturing and marketing of pharmaceutical products. The Electronic Data Analysis & Design project performed at this company provided a standardized means for transforming, calculating and reporting Case Report Form (CRF) subject level data. This standardized capability provided an automated procedure for generating Clinical Study Report tables that are very essential for the company.

Job responsibilities:

• Source system evaluation, standardizing received data format, understanding business/data transformation rules, business structure and hierarchy, relationships, data transformation through mapping development, validation and testing of mappings.
• Developed logical & physical modeling as per business requirements using ERWIN 4.0
• Performed requirement analysis and developed designing technical specifications for the data migration according to the business requirement.
• Used Informatica Power Exchange for loading/retrieving data from mainframe systems.
• Developed complex ETL structures to extract, transform and load data from multiple data sources into data warehouse based on business requirements.
• Extensively worked with SCD Type-I, Type-II and Type-III dimensions and data warehousing Change Data Capture (CDC).
• Created mapplets in place of mappings which were repeatedly used like formatting date or data type conversion.
• Ensured accurate, appropriate and effective use of data; including data definition, structure, documentation, long-range requirements, and operational guidelines.
• Monitored ETL process activity and utilization, with particular strengths in performance tuning highly transactional data integration package in both the development and production environments.
• Responsible for troubleshooting and resolving issues related to system performance, Informatica applications, and data integrity
• Extensively worked with SQL queries, created stored procedures, packages, triggers, views using PL/SQL Programming.
• Involved in optimization and performance tuning of Informatica objects and database objects to achieve better performance.
• Sourced data from Teradata to Oracle using Fast Export and Oracle SQL Loader
• Created load scripts using Teradata Fast Load and Mload utilities and procedures in SQL Assistant.
• Offered production support for daily jobs
• Worked with UNIX commands and used Unix shell scripting to automate jobs
• Wrote Unix (korn shell scripts) to backup the log files in QA and production
• Performed Unit and Integration testing and wrote test cases
• Worked extensively in defect remediation and supported the QA testing
• Involved in periodic maintenance of environments by applying patches and content upgrades
• Involved in code migration for versioned repositories
• Involved in taking repository backup and restoring it, starting and stopping Informatica services and worked with pmcmd commands.
• Created Drill Through Reports & Master Detail Reports for Sales Department
• Extensively used prompts, filters, cascading prompts, calculations, conditional variables, multiple queries for data extraction in reports.

Environment: Informatica Powercenter 8.1, Informatica Power Exchange, Teradata, PL/SQL, SQL*Plus, SQL*Loader, Toad, UNIX, Windows XP, Erwin 4.0, Cognos 8.3.

Client:Confidential, Irvine CAOct 2008-Feb 2009
Informatica Consultant

Description: The firm is a leader in investment banking, financial services for consumers, small business and commercial banking, financial transaction processing, asset management, trading and private equity .They migrated data from a number of disparate legacy systems into Client Central as a central repository of all client data.

Job responsibilities:

• Designed and developed several ETL scripts using Informatica, UNIX shell scripts.
• Extensively used all the features of Informatica Versions 6.x and 7.x including Designer, Workflow manager and Repository Manager, Workflow monitor.
• Developed and modified UNIX shell scripts to reset and run Informatica workflows using pmcmd on Unix Environment. Conversant with the Informatica API calls.
• Worked extensively with mappings using expressions, aggregators, filters, lookup, update strategy and stored procedures transformations.
• Created flexible mappings/sessions using parameters, variables and heavily using parameter files.
• Improved session run times by partitioning the sessions. Was also involved into database fine tuning (creating indexes, stored procedures, etc), partitioning oracle databases.
• Setting up Batches and Sessions to schedule the loads at required frequency using Power Center Server manager.
• Worked on several data mart projects as a senior data warehouse architect, was involved in complete system development life cycle, starting from requirement specifications to delivering the tested product.
• Extensively worked with SQL queries. Created Cursors, functions, stored procedures, packages, Triggers, views, materialized views using PL/SQL Programming.
• Extensively worked with performance tuning of Oracle
• Extensively used Oracle partitioning (range/hash/list), indexes (bitmap, B-tree, reverse key, etc) and various join types (hash joins, sort merge, nested iteration join) to improve the performance.
• Sourced data from Teradata to Oracle using Fast Export and Oracle SQL Loader
• Created load scripts using Teradata Fast Load and Mload utilities and procedures in SQL Assistant.
• Creating ad-hoc reports/ Migrating reports from Cognos Impromptu
• Mentoring Junior Informatica developers and worked with off-shore teams for development

Environment: Informatica Power Center 7.1.x, Oracle 9i, Teradata, PL/SQL, Toad, Erwin 3.5.2, Report Net 1.1, UNIX, Shell Scripting, Windows XP, MS-Access.

Client: Confidential, India Oct 2006 - Sept 2008
Informatica Developer

Job Responsibilities:

• Assist data modeling using Erwin 3.5.
• Analyzed the Specifications and identifying the source data needs to be moved to data warehouse.
• Involved in Database design, entity relationship modeling and dimensional modeling using Star schema.
• Extensively used all the features of Informatica Versions 7.x including Designer, Workflow manager and Repository Manager, Workflow monitor.
• Developed and modified UNIX shell scripts to reset and run Informatica workflows using pmcmd on UNIX Environment. Conversant with the Informatica API calls.
• ETL mappings were developed to perform tasks like validating file formats, business rules, database rules and statistical operations
• Worked extensively with mappings using expressions, aggregators, filters, lookup, update strategy and stored procedures transformations.
• Created flexible mappings/sessions using parameters, variables and heavily using parameter files.
• This project is intended to load and extract Procurement, Order Management, and Accounting data from Oracle database.
• Performed tuning of Informatica sessions by using optimizing techniques such as database partitioning, increasing block size, and data cache size, sequence buffer length, target based commit interval and SQL overrides. Identify the Bottlenecks in mappings.
• Create test cases for the above projects in providing error free solution. Monitored Workflows and sessions using Workflow Monitor.
• Debug through Session logs and fix issues utilizing database for efficient transformation of data.
  Prepared Mapping documents, Data Migration documents, and other project related documents like mapping templates and VISIO diagrams.
• Develop technical documents in ease of improvements on existing code.
• Involved in data conversion, migration, integration quality profiling tasks.
• Implemented Filters, Calculations, Conditions, and Graphs & Prompts in Impromptu reports
• Developing reports in ReportNet1.1 using Report Studio & Query Studio.
• Creating ad-hoc reports/ Migrating reports from Cognos Impromptu

Environment: Informatica Power Center 7.1.x, Oracle 9i, DB2, MSSQL Server 2005 PL/SQL, SQL*Plus, SQL*Loader, Cognos 7 Series, Toad, UNIX, Windows XP.