PROFESSIONAL SUMMARY

• 7 years of strong Data Warehousing experience in analysis, design, development and implementing software solutions in various business applications with ETL/Informatica PowerCenter 7.x/8.x
• Extensively worked with various components of the Informatica PowerCenter – PowerCenter Designer(Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation developer), Repository Manager, Workflow Manager, and Workflow Monitor to create mappings for the extraction of data from various source systems.
• Good knowledge of business/process dataflow in organizations and proficient in data modeling using ERWIN.
• Experience in implementing complex business rules by creating re-usable transformations, and robust mappings/mapplets using different transformations like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Stored Procedure, Normalizer etc.
• Proficient in full life cycle development of Data Warehousing, ETL strategies, reporting and hands on experience in Performance Tuning of sources, targets, transformations, mappings and sessions using Database Tuning, Partitioning, Index Usage, Aggregate Tables, Session partitioning, Load strategies, commit intervals and transformation tuning.
• Extensive experience in integrating data from various Heterogeneous sources like Relational database (Oracle, SQL Server, Teradata, DB2), Flat Files (Fixed Width and Delimited), COBOL files, XML Files and Excel files into Data Warehouse and Data Mart.
• Experience in Database Design, Entity-Relationship modeling, Dimensional modeling like Star schema and Snowflake schema, Fact and Dimension tables.
• Worked with Slowly Changing Dimensions type 1 and type 2.
• Experience in PL/SQL Programming (Stored procedures, Triggers, Functions, Packages) and UNIX shell scripting to perform job scheduling.
• Good experience in documenting the ETL process flow for better maintenance and analyzing the process flow.
• Demonstrated ability to take initiatives, grasp and expand on ideas, tackle and follow through difficult assignments in the fast-pace and changing environment.
• Independent yet team oriented with excellent analytical, problem solving, multi-tasking, oral and written communication skills.

Technical Skills

ETL Tools: Informatica Power Center 9.0/8.6/8.5/8.1/7.1 (Workflow Manager, Work Flow Monitor, Source Analyzer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager and Informatica Server)
Databases: Oracle 11g/10g/9i/8i, DB2, MS SQL Server 2008/2005, Teradata, SQL Server 
Data Modeling tools: ERWIN 4.x and Concepts like StarJoin Schema Modeling,SnowflakeModeling, FACT and Dimensions Tables, PhysicalandLogical Data Modeling
Languages: SQL, PL/SQL, UNIX Shell scripts, C, C++, Java, SQL Tuning/Optimization
Development Tools: SQL *Plus, TOAD, SQL Navigator, SQL Developer
Reporting Tools: Business Objects (Crystal Reports), Cognos.
Scheduling Tools: Autosys
Packages: MS Word, MS Excel, MS Visio, MS PowerPoint
Operating Systems: Windows XP/NT, UNIX, LINUX, MS-DOS
Processes/Methodologies: Agile Software development, Scrum/Sprint, Pair programming.

PROFESSIONAL EXPERIENCE

Confidential., Woodcliff Lake NJ Dec 2010 – Jan 2012
Role: Informatica Consultant

Confidential. is a leading pharmaceutical company with strong presence in fields of neurology, gastrointestinal disorders and oncology/critical care. The project with Eisai is to create a data warehouse that houses the customer review data across different subject areas related to neurology, gastrointestinal disorders, oncology etc. coming from multiple source systems. Various Business Rules and Business Processes were applied to Extract, Transform and Load the data into the Data Warehouse.

Responsibilities:

• Gathered requirements from users and translated into technical specifications.
• Developed complex mappings and SCD type-I and Type-II mappings in Informatica to load the data from various sources using different transformations and created complex mapplets for reusable purposes.
• Used various Transformations like Expression, Filter, Joiner and Lookups for better data messaging, migrate clean and consistent data.
• Deployed reusable transformation objects such as mapplets to avoid duplication of metadata, reducing the development time.
• Extensively used Workflow Manager for creating workflows, worklets and tasks like Email, Timer Event Raise, Event Wait, Decision and Command.
• Scheduled and ran Extraction-Load process and monitored tasks/workflows using the Workflow Manager and Workflow Monitor.
• Implemented post-session and pre-session UNIX shell scripts to run and control workflows using the pmcmd.
• Worked on scalability and performance tuning batch processing to handle large volumes.
• Involved in fixing the invalid mappings, and testing the stored procedures and functions as part of Unit and Integration Testing.
• Created documents for data flow and ETL process using Informatica mappings to support the project once it is rolled in to production.
• Troubleshoot problems by checking sessions/error logs in the Workflow Monitor and also used debugger in Mapping Designer to debug complex mappings.
• Resolved memory related issues like DTM buffer size, cache size to optimize session runs.
• Used Informatica Version Control for checking in all versions of the objects used in creating the mappings, workflows to keep track of the changes in the development, test and production environment.

Environment: Informatica Power Center 8.6.1, POWER EXCHANGE 8.x, Oracle 10g, XML files, SQL Server 2008, Oracle Express, SQL Developer, Flat Files, Autosys, UNIX, Business Objects XI reports.

Confidential, Westborough, MA Dec 2009 to Nov 2010
Role: Informatica Developer

Confidential is a leader in enterprise storage solutions and cloud computing technologies. The Powerlink application is an initiative to connect customers with the storage related knowledgebase and usage information for promoting effective usage and expertise sharing. As part of this application, customer and storage information is gathered and from different sources related different product lines and aggregated using ETL technologies to analyze and generate reports.

Responsibilities:

• Participated in gathering the requirements and documented them accordingly.
• Involved in Dimensional Modeling, Designing ER diagrams, Logical model (relationships, cardinality, attributes, FACTS, and DIMENSIONS) and Physical database (capacity planning, object creation and aggregation strategies) as per business requirements with Erwin using Star Schema methodology.
• Identified and tracked the slowly changing dimensions, heterogeneous sources and determined the hierarchies in dimensions.
• Involved in ETL processes to load data from DB2, SQL Server, flat files and Excel Spreadsheet into the target SQL Server databases by applying business logic on transformation mappings for inserting and updating records when loaded.
• Used Power Exchange to import source definitions and to extract data from DB2 sources.
• Created mappings using Mapping Designer to load data from various sources using different transformations like Stored Procedure, Sequence Generator, Source Qualifier, Update Strategy, Aggregator etc,. Also developed reusable transformations and mapplets, which were used in other operations.
• Used stored procedures for dropping and recreating indexes for efficient Data Load and also for populating audit tables.
• Worked with Variables and Parameters in the mappings to pass the values between sessions.
• Conducted performance tuning on sessions by optimizing block size, data cache size, sequence buffer length and commit interval.
• Performed analysis of data to test the integrity, consistency and appropriateness of data.
• Used different tasks such as Session, Command, Email, Event-Raise, Event-wait and Control.
• Tuned the SQL queries for better performance.
• Prepared technical specifications, test design documents, deployment documents and test scripts.

Environment: Informatica Power Center 8.1.1/8.5, Power Exchange 8.0, AS-400(DB2), Oracle 10g, SQL Server 2005/2K, Windows XP.

Confidential, IN Mar 2008 - Nov 2009
Role: Informatica Developer

Confidential Financialis significantly expanding its Risk capability, subsequently, an EDW Risk Information Store (RIS) is required to provide suitable enterprise-wide risk information environment capable of meeting their future reporting and information requirements. The RIS is focused on providing a platform for risk information collection from various source systems, performing complex calculations (e.g. to calculate Risk-Weighted Assets), and information delivery (reporting). A primary focus is a repository of all information required to support compliance.

Responsibilities:

• Designed ETL processes using Informatica to load data from Flat Files, and Excel files to target Oracle Data Warehouse database
• Performed data manipulations using various Transformations like Joiner, Expression, Lookup, Aggregate, Filter, Update Strategy, and Sequence Generator, Stored Procedure etc.,
• Used SQL overrides in source Qualifier to meet business requirements
• Written pre session and post session scripts in mappings. Created sessions and workflows for designed mappings. Redesigned some of the existing mappings in the system to meet new functionality
• Created and used different tasks like command and email tasks for session status
• Used Workflow Manager to create Sessions and scheduled them to run at specified time with required frequency
• Monitored and configured the sessions that are running, scheduled, completed and failed
• Compiled report presentations using tools like Cognos reports.
• Involved in writing UNIX shell scripts for Informatica ETL tool to fire off services and sessions

Environment: Informatica 8.5, Oracle 9i, Flat files, Excel, SQL Server, PL/SQL, Toad, UNIX Shell Scripting, Windows XP, Cognos

Confidential., Hudson, OH July 2007 – Feb 2008 
Role: Informatica Developer
Confidential Fabrics is a leading national specialty retailer of crafting, decorating and sewing products. Informatica is used for reducing the cost of data storage, lowering application total cost of ownership, improving performance, mitigating risk and ensuring regulatory compliance. ETL integrates information from various systems to help buyers, merchandisers, marketers, finance professionals and other corporate personnel conduct price optimization, category management, inventory analysis and markdown analysis. 
Responsibilities:

• Interacted with business user groups through facilitated meetings understanding the business process.
• Extracted data from different sources like flat files, Oracle, DB2, and Teradata and loaded them into DB2 enterprise Data Warehouse.
• Involved in regular log and trace checks of files to make sure that any problems requiring action are not neglected.
• Extensively worked with Source Analyzer, Warehouse Designer, Transformation designer, mapping designer and Workflow Manager.
• Developed data Mappings between source systems and warehouse components
• Created various Transformations like Joiner, Aggregate, Expression, Lookup, Filter, Union, Update Strategy, Stored Procedures, and Router etc. and Fine-tuned the mappings for optimal performance.
• Developed and modified many scripts using Shell scripting in UNIX.
• Made use of System variables (SYSDATE), Mapping parameters and variables in the transformations within a mapping. Employed variable functions (like SetMaxVariable) to manipulate mapping variables and parameter files to initialize mapping parameters.
• Coordinating with the DBA’s for managing the databases in different environments for UAT and system testing, also involving with DBA’s during the release nights and troubleshooting with any of the production problems.
• Worked with testing team in trouble shooting the defects in application.
• Used Informatica as a tool for the test data preparation in various environments
• Involved in performance tuning of SQL Queries adding indexes, mapping, having files locally avoiding network connections and avoiding/correcting transformation errors in a mapping.

Environment:Informatica Power Center 7.1.1, Oracle 10g, 9i/8i, Teradata V2R6, Micro Strategy, MS SQL server 2000, Unix, Shell scripting and Windows XP, Erwin 4.2, SQL/PL SQL.

EDUCATION

• Bachelor of Science (Computer Science)