SUMMARY

• 5+ years of IT experience in design, analysis, development, documentation, coding and implementation including but not limited to Databases, Data Warehouse, ETL Design.
• Expertise in Healthcare, E - commerce, Manufacturing, Telecommunication domain.
• ETL experience using Informatica 9.0.1/8.6.1/8.6/8.5/8.1/8.0/7.1/6.2/5.1 (Power Center/ Power Mart/ Power Play) (Designer, Workflow Manager, Workflow Monitor and Server Manager)
• Dimensional modeling using Star schema and Snowflake schema.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping, Mapplet Designer and Transformation Developer.
• Extensive experience in Extraction, Transformation and Loading of data from multiple sources into Data warehouse using Informatica.
• Have extensive experience with authoring Business Requirement Document BRD, Functional Specification Documents FSD and Software Requirement Specifications.
• Worked with Informatica Power Center to move data from multiple sources into a common target area such as Data Marts and Data Warehouse using Source Qualifiers, Expressions, Normalizers, Routers, connected/unconnected Lookup/procedures, Update strategies, Mapplets and Slowly Changing Dimensions.
• Provide support to Onshore and Offshore team members.
• Knowledge of Migration, backup, recovery, tuning, tracing and troubleshooting.
• Extensive experience in extraction, transformation and loading of data directly from different heterogeneous source systems like flat files, XML files, Oracle, SQL Server, MQ-Series, Teradata.
• Expertise in Developing PL/SQL Packages, Stored Procedures/Functions, triggers.
• Expertise in utilizing Oracle utility tool SQL*Loader and expertise in Toad for developing Oracle applications.
• Extensively worked on Dimensional modeling, Data cleansing and Data Staging of operational sources using ETL processes.
• Proficiency in data warehousing techniques for data cleansing, Slowly Changing Dimension phenomenon, surrogate key assignment and change data capture, Periodic and Accumulating snapshots
• Good experience in Data Cleansing, Data profiling and Data Analysis.
• Extensive Working experience in applying Relational Database concepts, Entity Relation diagrams and Normalization concepts.
• Experience in Performance Tuning of sources, targets, mappings and sessions.
• Interpersonal skills and ability to work independently and deliver on time, hard working and ability to adapt to new technologies very quickly, ability to perform independently.
• Delivered 24/7 supports including scheduled and emergency night and weekend work.
• Excellent team player, Analytical, programming, written and verbal communication skills with ability to interact with individuals at all levels.

TECHNICAL SKILLS

ETL Tools: Informatica 9.0.1/8.6.1/8.6/8.5/8.1/8.0/7.1/6.2/5.1 (Power Center/Power Mart/Power Exchange ), SQL Server Integration Services(SSIS) 2005

Data Modeling: Star Schema Modelling, Snow Flake Modelling, Erwin 4.0

Databases: Oracle 11g/10g/9i, MS SQL Server 2008/2005, Teradata, PHPMyadmin

Reporting Tool: Cognos 8.0/7.0, Microstrategy 8.0, SQL Server Reporting Services(SSRS) 2005, Business Objects.

Languages: SQL, PL/SQL, XML / Web services, HTML, CSS, PHP, Perl, Javascript, batch and unix scripting, C#, VB.NET, ASP.NET, Java, Zend Framework

Tools: Microsoft Office - Word, Excel, Access, Visio, PowerPoint, Toad, SQL* Loader, Oracle Business Intelligence Data Warehouse Administration Console (DAC) 7.x, WinSCP 4.2, WinSQL 8.5, SQL Plus, Rapid SQL, Telnet, FTP, Putty, Filezilla, Tortoise SVN, Visual Studio, Visual Web Developer 2010

Operating Systems: Windows 95/98/ME/2003/2000/NT/XP/Vista/7 Unix Linux Ubuntu 8, Knoppix, Linux Mint, Vector Linux, Slax, Red Hat

PROFESSIONAL EXPERIENCE

Confidential, Troy, MI

Data Warehouse PL/SQL Developer

Responsibilities:

• Designed, Developed, Planned, Coded, Tested, Debugged, Configured, and Documented custom Oracle ETL applications for data warehouse.
• Designed and created new dimensions for the proper capture of incoming data from outside sources. Added the additional dimension keys to the fact table to ensure proper loading.
• Tested slowly changing dimensions through Oracle code.
• Created scripts to automate updates to our mappings
• Created look up tables to facilitate mapping for brands and products
• Created and replaced functions and procedures to capture data coming in from online sales and exporting this data to other databases and business through business objects.
• Provided Production support to our live products and live data.
• Created and replaced old non-functioning materialzed views in both development and production.
• Performed unit tests and debugging on individual SQL and PL/SQL blocks of code to gather information on performance tuning and improper coding standards and syntax.
• Reset sequence numbers, created indexes.
• Performed string integration testing using big bang approach and incremental testing. Tracing errors back to their sources under each form of testing.
• Documented all Major errors coming from development and production systems
• Documented all changes made by myself and included a re-write of original documentation to include the step by step process of our datawarehouse yearly roll-over.
• Gathered requirements from business. Inferring the best method to make changes to code based on business requests and needs..
• Created Mock up errors for proper error testing, handling, and debugging
• Usage of Microsoft Word, Excel, and Access
• Collected data from various internal and third party database systems and flat files.
• Imported records from excel and flat files directly into development and production databases.
• Tracked down appropriate source data for extraction into datawarehouse.
• Designed and developed database instances to support business requirements.
• Created technical design documents including transformation rules. Acted as a liason between business and development team for the translation of business rules.
• Developed testing requirements to ensure data meets specification.
• Developed and maintained user documentation.
• Worked with business analysts to understand and document business needs for decision support data.
• Accurate and timely maintenance of programs and documentation with a cooperative attitude.
• Worked with internal/external staff and information management and hosting to resolve system fixes/updates and customer requests and issues.
• Identified and implemented technologies for ongoing database scalability, monitoring, and performance improvement.

Confidential, Canton, MA

Sr. Informatica Developer

Responsibilities:

• Migrating data from Legacy system to Oracle Retail System.
• Conversion of LIN into Orins.
• Coordinated with Business Users to understand business needs and implement the same into a functional Data warehouse design.
• Designed technical specifications (HLD) for the ETL process based on Functional specifications.
• Installed and configured Informatica Power center Client tools.
• Analysis of data and requirement using Oracle analytical function.
• Dealt with big volume of record approximately 200 Million to 700 Million.
• Development of mappings as per the technical specifications approved by the client.
• Managing off shore team.
• Developed mappings using Informatica Power Center Designer to transform and load the data from source systems to target database.
• Worked on various types of transformations like Expression, Joiner, update strategy, Aggregator, Filter and Lookup.
• Developed UNIX shell scripts for scheduling workflows by using pmcmd.
• FTP is used for updating the parameter files for the sessions on UNIX server.
• Created Mapplets to reduce the development time and complexity of mappings and better maintenance and Worked on different sources like Oracle, flat files.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Created and Monitored Batches and Sessions using Informatica Power Center Server.
• Implemented the Slowly Changing Dimension Type 2 methodology to keep track of historical data.
• Created various stored procedures for dropping and recreating indexes on target tables.
• Used mapping variable for imparting flexible runs of workflows based on changing values.
• Involved in the debugging of the mappings by creating break points to gain trouble shooting information about data and error conditions.
• Designed Error handling process and generated Error reports.
• Responsible for testing and validating the Informatica mappings against the pre-defined ETL design standards.
• Performed Unit testing and created Unix Shell Scripts.
• Responsible for Developing Informatica development life cycle process documents.
• Created sessions and workflows to run with the logic embedded in the mappings using Power center Designer.
• Created various tasks like sessions, decision, timer and control to design the workflows based on dependencies.
• Co-coordinating with users and establishing good relations between users and development team.
• Scheduling the session’s tasks comprising of different mappings for data conversion, extractions in order to load data into oracle database.
• Involved in Requirements study, interact with the end users and responsible for gathering the reporting requirements.

Confidential, Oakland, CA

Informatica Developer

Responsibilities:

• Extracted the data from the Mainframe COBOL Files, flat files, XML and loaded into Data warehouse.
• Provide support and assist to onshore and offshore Team members.
• Used various transformations like Source Qualifier, Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure and Lookup to develop robust mappings in the Informatica Designer.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin 3.5 to design the business process, dimensions and measured facts.
• Used Type 1 SCD and Type 2 SCD mappings to update Slowly Changing Dimension Tables.
• Prepared ETL standards, Naming conventions and wrote ETL flow documentation for Stage and ODS.
• Created and monitored Sessions and Batches using Informatica Server Manager. Responsible for monitoring all the sessions that are running, scheduled, completed and failed. Debugged the mapping of the failed session.
• Involved in migrating the mappings and workflows from Development to Testing and then to Production environments.
• Involved in Unit Testing, User Acceptance Testing to check whether the data loads into target, which was extracted from different source systems, were accurate, according to the user requirements.
• Work with Client to set up a copy of a version 7.1.3 repository and restoring it at Upgrade location.
• Upgrade the contents of the repository.
• Extensively migrated data from different source system to ODS, Data marts and Data warehouse.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Standardized parameter files to define session parameters such as database connection for sources targets, last updated dates for Incremental loads and many default values of fact tables.
• Created sessions, configured Workflow to extract data from various sources, transformed data, and loading into data warehouse.
• Installed Informatica 7.1.3 on UNIX Server and did an upgrade to 8.1.1 with SP4.
• Used Debugger to test the data flow and fix the mappings.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Tested the data and data integrity among various sources and targets.
• Used Rapid SQL to test the SQL’S and to view the data coming from different systems.
• Developed UNIX shell scripts to move Staging files to DB2 database using DB2 bulk loads.
• Involved in Unit, Integration, system, and performance testing levels.
• Prepared documentation describing development of mappings, coding, testing and designing of Autosys jobs and Developed Autosys Jobs to run the workflows in batches.

Environment: Informatica Power Center 8.1 / 7.1, Business Object XI R2, Oracle 10g, SQL Server 2005, Teradata, PL/SQL, Erwin 3.5, Star Schema, Mainframes, UNIX Shell Scripts, Autosys, MS-Office, Windows XP.

Confidential, Milwaukee, WI

Informatica Developer

Responsibilities:

• Coordinated with Business Users to understand business needs and implement the same into a functional Data warehouse design.
• Involved in creating the design and technical specifications for the ETL process based on Functional specifications.
• Installed and configured Informatica Power Mart Client tools and Server.
• Development of mappings as per the technical specifications approved by the client.
• Developed mappings using Informatica Power Center Designer to transform and load the data from source systems to target database.
• Worked on various types of transformations like Expression, Joiner, update strategy, Aggregator, Filter and Lookup.
• Created Mapplets to reduce the development time and complexity of mappings and better maintenance and Worked on different sources like Oracle, flat files.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Created and Monitored Batches and Sessions using Informatica Power Center Server.
• Implemented the Slowly Changing Dimension Type 2 methodology to keep track of historical data.
• Created various stored procedures for dropping and recreating indexes on target tables.
• Involved in enhancements and maintenance activities of the data warehouse including performance tuning.
• Used mapping variable for imparting flexible runs of workflows based on changing values.
• Involved in the debugging of mappings by creating break points to gain trouble shooting information about data and error conditions.
• Designed Error handling process and generated Error reports.
• Responsible for testing and validating the Informatica mappings against the pre-defined ETL design standards.
• Performed Unit testing and created Unix Shell Scripts and Cron jobs.
• Responsible for Developing Informatica development life cycle process documents.
• Created sessions and workflows to run with the logic embedded in the mappings using Power center Designer.
• Involved in UAT and Production support.
• Migrated repository and Informatica mapping 8.1 to 8.6
• Played a key role in designing the application and migrate the existing data from relational sources to corporate warehouse effectively by using Informatica Power center
• Created various tasks like sessions, decision, timer and control to design the workflows based on dependencies.
• Co-coordinating with users and establishing good relations between users and development team.
• Scheduling the session’s tasks comprising of different mappings for data conversion, extractions in order to load data into oracle database.
• Involved in Requirements study, interact with the end users and responsible for gathering the reporting requirements.
• Designed ER-diagrams, Dataflow diagrams, module logic & data using Erwin.
• Used workflow manager for session management, database connection management and scheduling of jobs.

Environment: Informatica Power Center 8.6 / 8.1 (Power Center Designer, workflow manager, workflow monitor),Business Objects XIR2,Erwin, Oracle 10g, SQL Server 2005, UNIX, Windows 2000, TOAD.

Confidential, Northfield, IL

ETL Developer

Responsibilities:

• Member of the warehouse design team, assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Extensively used loader utilities to load flat files into Teradata RDBMS.
• Performed high volume maintenance on large Teradata tables using Multiload loader utility.
• Translate Business Requirements into Informatica mappings, Review of DTL Detail design Technical Specification and Involved in end to end testing with unit test cases
• Created reusable transformations and Mapplet and used with various mappings.
• Created Connected, Unconnected and Dynamic lookup transformation for better performance and increased the cache file size based on the size of the lookup data.
• Involved in User training and handled user, developer and analysts reporting related problems/suggestions.
• Designed mappings for dimensions and facts.
• Extensively used various types of transformations such as Expression, Joiner, Update strategy, Look up, filter for developing mappings
• Responsible for loading data into warehouse from different sources using Multi load and Fast load to load millions of records, Designed and Maintained Universes.
• Development of mappings as per the technical specifications approved by the client.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Involved in Unit testing and integration testing of Informatica mappings.
• Implemented Error handling logic to capture the invalid data.
• Created sessions and workflows to run with the logic embedded in the mappings using Power center Designer.
• Used workflow manager for session management, database connection management and scheduling of jobs and creating the catalogs and analyzing the joins.

Environment: Informatica Power Center 6.0(Power Center Designer, workflow manager, workflow monitor), Oracle9i, Teradata V2R3, SQL Server, Windows 2005.