SUMMARY:

• Over 8+ years of extensive experience in Data Warehousing and Business Intelligence with emphasis on requirement analysis, design, development, testing, deployment and release management. Strong experience in Data movement solutions, worked extensively in development and migration projects using various versions of Informatica.
• Experience in Extraction, Transformation and Loading (ETL) processes for data Integration, data mapping and data conversion from various sources like Oracle, Teradata, SQL Server and Flat files using Informatica Power Center.
• Responsible for the development, implementation and support of ETL processes for large scale data warehouses.
• Extensive experience in ETL design, development and maintenance using Oracle SQL, PL/SQL, SQL Loader, Informatica Power Center v 5.x/6.x/7.x/8.x/9.x.
• Experience in testing the Business Intelligence applications developed in Qlikview.
• Well versed in developing the complex SQL queries, unions and multiple table joins and experience with Views.
• Experience in database programming in PL/SQL (Stored Procedures, Triggers and Packages). Excellent knowledge and experience in data warehouse development life cycle, dimensional modeling, implementation of STAR, Snowflake schemas and slowly changing dimensions.
• Worked with SCD (Slowly Changing Dimensions) Type 1, 2 and 3.
• Experience in implementing business rules by creating optimized and efficient mappings. Experience in identifying and eliminating bottlenecks to increase performance of mappings and sessions.
• Hands on experience with SQL / PL SQL and UNIX shell scripting.
• Providing 24/7 data warehouse production support in time pressured business environments. Enormous experience in Onsite - Offshore Model.
• Worked with Waterfall & Agile SDLC methodologies.
• Excellent communication, documentation and presentation skills using Microsoft Word, Excel, PowerPoint and Visio.

TECHNICAL SKILLS:

Data Warehousing/ ETL: InformaticaPowerCenter 9.5/9.1/8.6/8.1/7.1, InformaticaPowerMart9/8.x/7.x, Workflow Manager, Workflow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Repository manager, Metadata, Datamart, OLAP, OLTP, Cognos 7.0/6.0, ERWIN 4.x/3.x., ODI Oracle Data Integrator

Dimensional Data Modeling: Dimensional Data Modeling, Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin and Oracle Designer.

Databases Tools: Oracle 11g/10g/9i/8i/8.x, Teradata, Vertica, DB2 UDB 8.5, SQL Server, Teradata, OEM Grid control, RMAN, MS SQL Server 2005/2000/7.0/6.5, SQL Plus, SQL Loader, Net8, TOAD.

Scheduling Tools: Appworx 6.0, Informatica Workflow Manager, Tidal, Maestro/Tivoli, Apache, Tomcat, IIS.

Programming Languages: Unix Shell Scripting, SQL, PL/SQL

Environment: UNIX, Win XP/NT 4.0, Sun Solaris 2.6/2.7, HP-UX 10.20/9.0, IBM AIX 4.2/4.3

PROFESSIONAL EXPERIENCE:

Confidential, St Luis, MI

Senior ETL Developer

Responsibilities:

• Responsible for gathering business requirements and analyzing & developing detailed technical specifications for EDW (Enterprise Data Warehouse).
• ETL Design/Development through Informatica Power Center 9.5.1 version.
• Loaded data into ODS (SCD Type1) and EDW (SCD Type2) making use of various transformation objects in Informatica.
• Involved in the POC of Big data solution to implement efficient summarization processes using Hadoop platform with Vertica as the DW database.
• Contributed towards documenting IDW process flows as per AGILE methodology .
• This project involves production support and development for the systems -Order management Metasolv, Billing application Arbor BP, Customer Relationship Management Oracle CRM, Integration Manager TIBCO and also implementing new Change Requests.
• Developed database Schemas like Star schema, Snowflake schema used in relational, dimensional and multidimensional data modeling using ERWIN and XSD XML SCHEMA DEFINITION .
• Designed and Developed OraclePL/SQL Package for initial loading and processing of Derivative Data.
• Worked with various Informatica client tools like Source Analyzer,Warehouse Designer, Mapping Designer,Mapplet Designer,Transformation Developer,Informatica Repository Manager and Workflow Manager.
• Implemented weekly error tracking and correction process using Informatica .
• Involved in creation of Informatica mappings, sessions and workflows using mapping documents.
• Created Mappings / Sessions / Workflows in Informatica Power Center Designer, as per the BRD and STM specifications.
• Imported Mainframe COBOL copybooks as Sources using Informatica Power Exchange.
• Prepared test plans, test scripts, carrying out unit testing, integration testing and system testing without any issues.
• Coordinated and communicated for all approvals with business for smoother PRD implementation.
• Scheduled jobs making use of Tivoli Work Scheduler (TWS).
• Taken care of all EDW component deployments till Production, implemented successfully with in a prior time frame.
• Involved proactively in E2E testing with customer completely from onsite counterpart.
• Monitoring and resolved the bottlenecks in EDW for smoother process.
• Provide 24/7 on-call support whenever necessary

Environment: Informatica Power Center 9.5.1./ 8.x, Informatica Power Exchange, Sun Solaris, Oracle 11g, Shell Scripting, Tivoli Work Scheduler (TWS), Talend, BigData, Hadoop, HDFS, MapReduce.

Confidential, St. Louis, MI

Senior ETL Developer

Responsibilities:

• Analyzed the business requirements and functional specifications.
• Extracted data from Oracle database and spreadsheets and staged into a single place and applied business logic to load them in the central Oracle database.
• Used Informatica Power Center 8.x for extraction, transformation and load (ETL) of data.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.
• Involved in the POC of Big data solution to implement efficient summarization DW processes using Hadoop platform with Vertica as the DW database.
• Developed complex mappings in Informatica to load the data from various sources.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Parameterized the mappings and increased the re-usability.
• Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.
• Created procedures to truncate data in the target before the session run.
• Extensively used Toad utility for executing SQL scripts and worked on SQL for enhancing the performance of the conversion mapping.
• Created the ETL exception reports and validation reports after the data is loaded into the warehouse database.
• Created Test cases for the mappings developed and then created integration Testing Document.
• Followed Informatica recommendations, methodologies and best practices.

Environment: Informatica Power Center9.1/8.6.1,Oracle 11g/10g, Teradata V2R5, Vertica , TOAD for Oracle,SQL Server 2008, PL/SQL,DB2,SQL,Erwin 4.5, Business Objects,Unix Shell Scripting PERL, UNIX AIX, Windows XP,Autosys.

Confidential, Phoenix, AZ

ETL Consultant

Responsibilities:

• Analyzed and thoroughly studied various data sources and different development environments within the organization.
• Extensively worked on extracting the data from various flat files (fixed width, delimited), applying the business logic and then loading them to the Oracle databases.
• Extensively worked with Source qualifier, Filter, Joiner, Expression, Lookups, Aggregator, Router, Sequence Generator, and Update Strategy.
• Used various Informatica transformations in the development of complex mappings.
• Extracted data from different heterogeneous source systems applied business logic using transformations and loaded to the target systems using Informatica power center.
• Worked closely with business for requirement gathering and to understand the project needs.
• Interacted with environmental team and data architects in design and implementation data models.
• Designed and developed complex mappings to load the Historical, Weekly and Daily files to Oracle database.
• Extensively worked on data conversion and data cleansing.
• Created different move-it jobs to have inbound/outbound transition of files between Client and different vendors.
• Developed UNIX shell scripting, created command task, and email task for providing the pre-session post-session requirements for various informatica jobs. Provide database coding to support business applications using T-SQL
• Worked on automation of informatica job flow using autosys boxes/jobs.
• Extensively worked on basic SQL queries such as creating altering Tables, Indexes, Views also worked with PL/SQL stored procedures. Queried various tables to get resultant datasets as per the business requirements.
• Prepared ETL mapping documents explaining complete mapping logic.
• Prepared unit test document and performed unit testing, regression testing.
• Provided QA/UAT support while code promotion and worked with QA’s to resolve any defects if found.
• Worked with different teams as Release Management, DBA, and UNIX team for smooth code promotions.

Environment: Informatica Power Center 9.5.1./ 8.x, Informatica Power Exchange, SQL, Shell Scripting, Tivoli Work Scheduler (TWS).

Confidential, Dallas, TX

ETL Developer

Responsibilities:

• Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
• Analyzed the key functionalities of the institute and performed Data Analysis and abstracted the transactional nature of data.
• Profiled the data using Informatica Analyst tool to analyze source data (Departments, party and address) coming from Legacy systems and performed Data Quality Audit.
• Configured and installed Informatica MDM Hub server, cleanse, resource kit, and Address Doctor.
• Analyzed the source systems for erroneous, duplicative, and integrity issues related to the data.
• Planned, created and executed SSIS packages to integrate data from varied sources like Oracle, DB2, flat files and SQL databases and loaded into landing tables of Informatica MDM Hub.
• Involved in creating, monitoring, modifying, & communicating the project plan with other team members.
• Successfully managed in setting up the data and configured the components needed by Hierarchy Manager for MDM HUB implementation which included in implementing hierarchies, relationships types, packages and profiles by using hierarchies’ tool in model workbench.
• Involved with Informatica team members in Designing, document and configure the Informatica MDM Hub to support loading, cleansing, matching, merging, and publication of MDM data.
• Used Metadata manager for validating, promoting, importing and exporting repositories from development environment to testing environment.
• Involved with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data.
• Documented the issues and actions taken related to data cleansing using cleanse lists and predefined cleanse functions.
• Created Unit Test Case Document, Technical Design Document, Data Validation document and Knowledge Transfer Document.
• Prepared SQL Queries to validate the data in both source and target databases.
• Worked on TOAD and Oracle SQL Developer to develop queries and create procedures and packages.
• Created Test cases for the mappings developed and then created integration Testing Document.
• Prepared the error handling document to maintain the error handling process.
• Interaction with the Onsite team on a daily basis on the development activities

Environment: Informatica Power Center 8.x, Sun Solaris, Oracle 10g, Scripting (Shell), Remedy.

Confidential, Warren NJ

Web/Front End Developer

Responsibilities:

• Closely worked with business system analyst to understand the requirements to ensure that right set of UI modules been built.
• Creating responsive web application,
• Wrote application level code to perform client side validation using jQuery and JavaScript.
• Designed the front end applications, user interactive (UI) web pages using web technologies like HTML5, XHTML, and CSS3.
• Used Angular JS in developing single page applications.
• Using advanced level of jQuery, AJAX, JavaScript, CSS and pure CSS layouts. Wrote jQuery function while implementing various UI Screens across the whole web application (both consumer facing as well as internal application).
• Involved in writing application level code to interact with APIs, Web Services using AJAX, JSON and XML.
• Good Experience in Angular Js.
• Designed and developed intranet web applications using JavaScript and CSS.
• Interacted with java controllers (jQuery, AJAX, and JSON to write/read data from back end systems).
• Used SVN for version control and QC for defect tracking.
• Interfaced with third-party vendors to customize UI/UX solutions for web verticals
• Component level design and defined the usage of AJAX to reuse the network bandwidth efficiently and making feel that the user resides in the same page of our website.
• Maintain, enhance, and recommend solutions that best suit business and technology needs from UI standpoint.
• Define technical requirements based upon business requirements.
• Creating cross-browser compatible and standards-compliant CSS-based page layouts.
• Strong communication, analytical and interpersonal skills working within cross-functional teams.
• Worked on cross browser compatibility issues and fix the bugs pertaining to various browsers.

Environment: HTML 4.x,HTML 5, CSS2.x,CSS 3, JavaScript, Angular JS, jQuery, AJAX, JSON, XML, SVN, Weblogic, Endeca, Accurev

Confidential, Dallas, TX

Informatica Developer

Responsibilities:

• Extensively used Informatica PowerCenter for extracting, transforming and loading data from relational sources and non-relational sources.
• Implemented Staging Area to improve performance for OLAP and OLTP systems.
• Extensively used various transformations such as Source Qualifier, Expression, Lookup, Sequence Generator, aggregator, Update Strategy, and Joiner while migrating data from various heterogeneous sources like Oracle, DB2, XML and Flat files to Oracle.
• Developed Informatica mappings, re-usable transformations, re-usable mappings and mapplets for Data Load.
• Built and load data from external source (ERP) using Informatica PowerExchange.
• Designed and Created data cleansing, data conversion, validation and External loading scripts like MLOAD and FLOAD for Teradata warehouse using Informatica ETL tool.
• Used Erwin for Logical / Physical data modeling and Dimensional Data Modeling, and designed STAR Schemas
• Involved in error handling, performance tuning of mappings, testing of Stored Procedures and Functions, Testing of Informatica Sessions, and the Target Data.
• Experienced in loading data into Data Warehouse/Data Marts using Informatica, Teradata Multi load, Fast load and BTEQ utilities.
• Handled slowly changing dimensions of Type 2 to populate current and historical data to Dimensions and Fact tables in the data warehouse.
• Designed complex UNIX scripts and automated it to run the workflows daily, weekly and Monthly.
• Setting up and Sessions and Workflows to schedule the loads at required frequency using PowerCenter Workflow manager.
• Created connected and Un-Connected transformations to lookup the data from Source and Target Tables.
• Monitoring the ETL jobs and fixing the Bugs.
• Monitored the ETL Production Jobs and coordinated with offshore team to delegate tasks and monitor the day-to-day progress status and resolve the technical bugs and issues.
• Involved in doing Unit Testing, Integration Testing and System Testing.

Environment: Informatica PowerCenter 8.6.1/8.1,Teradata, Informatica PowerExchange, ERWIN, Oracle 10g, DB2, XML, Flat files, SQL, PL/SQL, Autosys, Sybase, Oracle, Unix shell Script.