Vinod Phone: 312-203-5547
Professional Summary:
· Over 7 years of experience in System Analysis, Design, Development, Data warehousing and Data Marts.
· Extensive experience in Informatica Power Center/Power Mart to implement Data Marts which involved creating debugging and executing Informatica Mappings, Sessions, Tasks and Workflow.
· Experience with high availability systems Very Large databases, hundreds of databases in a highly transactional environment with proper data Archive and Purge processes.
· Experience working with Data Warehousing Concepts like Ralph Kimball Methodology, Bill Inmon Methodology, OLAP, OLTP, Star Schema, Snow Flake Schema, Fact Table, Dimension Table, Logical Data Modeling, Physical Modeling, Dimension Data Modeling.
· Database and table design and implementation for data warehouse and related ETL processes.
· Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
· Expert knowledge in working with Informatica Power Center 8i, 7i.
· Worked on Slowly Changing Dimensions (SCD's) and its implementation (Type1, Type 2, and Type 3) to keep track of historical data.
· Knowledge in working with Informatica Power Exchange 8.6.1
· Business Intelligence and reporting experience using Business Objects - (Supervisor, Designer, Info view, Web Intelligence), Cognos - (Impromptu Administrator, Power Play Transformer, Scheduler, Impromptu Web Reports).
· Installation and configuration of Informatica Server and Informatica Repository Server in Windows-UNIX Operating Systems.
· Experience in building very large data warehouse with many complex transformations with many sources and targets.
· Extensively used Informatica Workflow manager and Workflow monitor for creating and monitoring workflows, Worklets and sessions.
· Experience on Informatica Designer tools - Transformations and Reusable Transformations, Mappings, Mapplets.
· Extensively worked with large Databases in Production environments.
· Extracted data from various sources like Oracle, DB2, Flat file, SQL Server, XML files, Teradata and loaded into Oracle database.
· Extensive experience in Oracle Packages, Stored Procedures, Functions and Database Triggers using PL/SQL.
· Experience in analyzing relational and dimensional databases (SQL, Oracle) and strong knowledge in UNIX Operating System.
· Implemented SCD -Type I Type II and Type III.
· Experience working in Oracle 9i/10g/11g with database objects like triggers, stored procedures, functions, packages, views, indexes.
· Experience in working with various Databases like Oracle, DB2 UDB, Teradata, flat files, SQL Server 2005/2008, Sales force and MS Access 2000.
· Extensive experience and knowledge of the Project Life Cycle, including Requirement gathering, and Test Plans Development and Execution.
· Extensive experience in error handling and problem fixing in Informatica.
· Experience in using Informatica Debugger to test the data flow and fix the mappings.
· Implemented CDC in Oracle databases to capture latest updates from source to destination.
· Experience in using Automation tools like Autosys; scheduling workflows
Using CA7 scheduling
· Experience on Performance Tuning of Mappings and Sessions and Batches.
· Extensive experience in Performance Tuning -Identified and fixed bottlenecks and tuned the complex Informatica mappings for better Performance.
· Skilled in Unit Test, System Integration Test and User Acceptance Test.
· Excellent communication skills, good organizational skills, self-motivated, positive attitude, ability to work independently or co-operatively in a team.
Technical Skills:
ETL Tools : Informatica Power Center 8i, 7i, 6i (Designer, Workflow
Manager, Repository Manager), Informatica Exchange 8i, SSIS, AbInitio
Database : Oracle 11g/10g/9i, SQL Server 2008/2005, DB2, Teradata (V2R5), MySQL,
MS Access.
Database Tools : Toad, SQL Server Management Studio, SQL*Plus, SQL*Loader, SQL
Server Profiler
Web Technologies : XML, HTML, DHTML, XHTML, MS FrontPage, JavaScript, AJAX
Data Modeling : Dimensional Data Modeling, Star Schema Modeling, Snow-Flake
Modeling, FACT and Dimensions Tables, Erwin 4.0/3.5.2/3.x, Oracle
Designer
Reporting Tools : Business Objects, OBIEE, SSRS, Hyperion, Cognos
Languages : SQL, PL/SQL, T-SQL, C, C++, Unix Shell Scripting, and Perl scripting.
Operating System : Windows Server 2003/2000/XP, Windows NT, Linux,
UNIX (SUN Solaris, AIX), LINUX (Red Hat)
FEDEX, Colorado (March 10 – Till Date)
Sr.Informatica Developer
Responsibilities:
· Worked with Informatica power center client tools like Source Analyzer, Warehouse Designer, and Mapping.
· Extensively used Informatica power center 8.6.1 for extraction, transformation and loading process.
· Worked with Kimball's Data Modeling concepts including data modeling, data marts, dimensional modeling, star and snowflake schema, fact aggregation and dimension tables, slowly changing dimensions and surrogate keys.
· Extensively developed various Mappings which perform Extraction, Transformation and Loading of Source data into the OLAP Schema, and used different Transformations like Source Qualifier, Expression, Lookup, Update Strategy, Aggregator, Stored Procedure, Filter, Router, Joiner etc.
· Extracted data from Oracle, DB2, SQL server, flat files and XML files transformed the data based on business requirement using Informatica Power Center and loaded data into target, by scheduling the sessions.
· Created SSIS Packages to migrate slowly changing dimensions.
· Have implemented both Type I and II ‘keep history’ (SCD) for data mart.
· Efficiently implemented Change Data Capture (CDC) to extract information from numerous Oracle tables.
· Involved in designing relational models for ODS and data marts using Kimball methodology.
· With Power Exchange (CDC option), captured the database inserts, updates, and deletes in the available data. Transformed and cleansed the data continuously with out staging tables.
· Created ETL design for a DB2 UDB data mart loading using Informatica PowerCenter.
· Designed dynamic SSIS packages to transfer data crossing different platforms, validate data and data clearing during transferring, and archived data files for different DBMS.
· Extensively used ETL to load data from multiple sources to Staging area (Oracle 11g) using Informatica PowerCenter.
· Improved performance using Oracle Partitions, Indexes and other Performance Tuning techniques.
· UsedTOAD, Oracle SQL Developerfor testing SQL code.
· Experience working with very large volumes of data.
· Responsible for migrating the folders, mappings and sessions from development to QA/production environment.
· Load operational data from Oracle, DB2, SQL Server, flat files, Excel Worksheets into various data marts.
· Performance tuning has been done to increase the through put for both mapping and session level and SQL Queries Optimization as well.
· Developed re-usable components in Informatica, Oracle and UNIX
· Created workflows using Workflow manager for different tasks like sending email notifications, timer that triggers when an event occurs, and sessions to run a mapping.
· Worked with third party CA7 scheduling Team for scheduling the Informatica PowerCenter Workflows.
· Developed and Implemented UNIX shell scripts and scheduled different Informatica jobs using CA7.
· Created advanced external procedures to test PERL functionality.
· Utilized Informatica debugger for trouble-shooting the Mappings.
· Created UNIX shell scripts and called as pre session and post session commands.
· Wrote shell scripts to work with flat files, to define parameter files and to create pre and post session commands.
· Involved in Unit Testing and Integration Testing of the application.
· Scheduled the ETL jobs daily, Weekly and monthly based on the business requirement.
· Developed the multidimensional reports in Business Objects by translating the business validations.
· Formatted Reports as per the user requirements using extensive functionalities in Business Objects, which allows the users to analyze the data.
· Documented the entire process. The documents included the mapping document, unit testing document and system testing document among others.
· Executed sessions, both sequential and concurrent for efficient execution of mappings and used other tasks like event wait, event raise, email, command and pre/post SQL.
Environment: Informatica PowerCenter 8.6.1(Repository Manager, Designer, Workflow Manager, Workflow Monitor, Repository Administration Console), Power Exchange 8.6.1 ,Business Objects XI r2,Oracle Developer, TOAD 9.6, DB2,Oracle 11g, SQL Server 2008/2005, PL/SQL, SSIS, UNIX(SUN Solaris),Flat Files.
VMware, Sunnyvale CA (Feb 09 – March 10)
Sr.Informatica Developer
Responsibilities:
· Analyzing the source data coming from different sources (SQL Server, Oracle, Sales force and also from flat files like Access and Excel) and working with business users and developers to develop the Model.
· Developed complex mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Update Strategy Rank and Router transformations.
· Expertise in Developing Mappings, Define Workflows &Tasks, Monitoring Sessions, Export & Import Mappings and Workflows and Backup, Recovery.
· Load the data into staging tables from different servers likeSQL server, Oracle, Sales force and also from flat files like Access and Excel.
· Migrating data from Access, Text file to SQL Server through DTS.
· Used SQL over rides in Source Qualifier and Lookups to improve mapping performance.
· Developing Reusable Transformations, Aggregations and created Target Mappings that contain business rules.
· Extensively worked with various Passive transformations in Informatica PowerCenter like Expression Transformation, Sequence Generator, and Lookup Transformation.
· Worked with various active transformations in Informatica PowerCenter like Filter Transformation, Aggregator Transformation, Joiner Transformation, Rank Transformation, Router Transformation, Sorter Transformation, Source Qualifier, and Update Strategy Transformation.
· Created and Configured Workflows, Work lets and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
· Created Business Intelligence Solutions and standardized reports using Business Objects XI R3.1.
· Partitioned Sessions for concurrent loading of data into the target tables.
· Created Connected and Unconnected lookup transformation for better performance of the mappings and sessions.
· Fixed invalid Mapping's using Informatica Debugger tested Stored Procedures and Functions, Unit Testing of Informatica Sessions, Workflows.
· Migrated the folders, mappings, sessions, Mapplets, Worklets, and Workflows from Informatica 8.1 to 8.5.
· Successfully Implemented Slowly Changing Dimensions (SCD). Used Type 2 dimension to keep the history changes.
· Implemented Slowly Changing Dimensions (SCD) to update the dimensional schema.
· Developed simple & complex mappings using Informatica to load Dimension & Fact tables as per STAR Schema techniques.
· Optimized the performance of the mappings by various tests on sources, targets and transformations.
· Involved in upgrading the Informatica version 8.1 to 8.5
· Created Materialized views for summary tables for better query performance.
· Developed PL/SQL stored procedures and UNIX shell scripts for pre and post session commands, batch jobs.
· Written Shell Scripts and control files to load data into staging tables and then into oracle base tables using SQL*Loader.
· Configuring sessions in a batch and scheduling them through Autosys job scheduler.
· Automated existing ETL operations using Autosys.
· Used PMCMD command to start, stop and ping server from UNIX and created UNIX Shell scripts to automate the process.
· Developed UNIX Shell Scripts and SQLs to get data from Oracle tables before executing Informatica workflows.
· Used perl and shell scripts to pre-process data in UNIX.
· Providing extensive changes as a part of User acceptance testing and deployment of mappings at client place.
· Performed extensive testing on the mappings and wrote queries in SQL to check if the data was loading to the dimension tables and fact tables properly.
· Setup of the ETL process for integration of Oracle EBS with OBIEE.
· Implemented User security in the integrated environment (EBS and OBIEE).
· Preparing the Design documents based on the Functional/requirements specifications.
Environment: Informatica Power Center 8.5 (Informatica PowerCenter Repository Manager, Designer, Workflow Manager, Workflow Monitor, Repository Administration Console), Sales force, Oracle 10g, SQL Server 2005,Oracle Developer, PL/SQL, Flat Files, UNIX, Erwin 3.5, TOAD 9.0, OBIEE,UNIX(AIX).
ExcellusBCBS, NY (July 07 – Dec 08)
Sr. Informatica/ETL Consultant
Responsibilities:
· Designed and developed ETL process using Informatica Power Center
· Accomplished automated data extraction from various RDBMS via scripts, ETL processing using Informatica and loading into Oracle Data warehouse.
· Involved in SDLC from analysis to production implementation, with emphasis on identifying the source and source data validation, developing particular logic and transformation as per the requirement and creating mappings and loading the data into different targets.
· Implemented Type1 and Type2 methodologies in ODS tables loading, to keep historical data in data warehouse.
· Done caching optimization techniques in Aggregator, Lookup, and Joiner transformation.
· Loading data from various data sources (Oracle, SQL Server) into Teradata production and development warehouse using BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD and Informatica.
· Created different types of business objects reports using multiple data providers.
· Coding using BTEQ SQL of TERADATA, write Unix scripts to validate, format and Execute the SQL’s on UNIX environment.
· Accomplished data movement process that load data from SQL Server, Oracle into Teradata by the development of Korn Shell scripts, using Teradata SQL and utilities such as BTEQ, FASTLOAD, FASTEXPORT, MULTILOAD.
· Creating /Running sessions & Batches to load the data into the target Database.
· Created User defined functions and Developed Informatica Variables and parameter files to filter the daily source data.
· Used various Oracle Index techniques like B*tree, bitmap index to improve the query performance and created scripts to update the table statistics for better explain plan.
· Created Materialized views for summary tables for better query performance.
· Created Test cases for Unit Test, System Integration Test and UAT to check the data quality.
· Documented the issues related to cleaning of the Data.
· Used PMCMD command to interact with Informatica server from command mode.
· Used PMREP command to create back ups, copy, and delete repositories.
· Developed UNIX Shell scripts for validating the files, running stored procedures & Informatica workflows.
· Created UNIX shell scripts and called as pre session and post session commands.
· Coordinating with the client and gathering the user requirements.
Environment: Informatica PowerCenter 8.1, Teradata V2R5,UC4, Business Objects 6.5, Oracle 10g, SQL Server 2005, PL/SQL, Flat Files, ERWIN Data Modeling tool, Advanced Query Tool, LINUX(Red hat).
Exelon, Oak Brook IL (Jan 07 – June 07)