SUMMARY:

• 8 years of IT experience in Analysis, Design, Development, Implementation, Testing and Support of Data Warehousing and Data Integration Solutions.
• Experience in Data Warehousing tools including Informatica for extraction, transformation and loading (ETL) of data from multiple sources.
• Well versed with Data Warehousing Architecture on the Design, Development, Extraction, Transformation and Loading of data using Informatica Power Center 9.1/9.5/9.6 as an ETL tool.
• Data modeling experience using Dimensional Data modeling, Star Schema modeling, Snowflake modeling, FACT and Dimension tables, Physical and logical data modeling using Erwin.
• Used Big Data Edition to integrate with Hadoop Distributed File Systems.
• Hands on experience in developing Business Objects out of the ERPs like SAP R/3, SAP BW/BI Tables and Programs.
• Experienced in interacting with business users to analyze the business process and requirements and transforming requirements into screens, designing database, documenting and rolling out the deliverable
• Having excellent knowledge on Data Warehousing and BI concepts.
• Extensive experience in design and creating data warehouse, data marts using Informatica Power Center.
• Experience in Data Warehouse development working with Extraction/Transformation/Loading using Informatica Power Center with Oracle, DB2, Sql Server, SalesForce(SFDC) & Teradata.
• Strong knowledge in RDBMS Concepts, Dimensional Data Modeling (Star Schema, Snow - flake Schema, FACT and Dimension tables), Logical, Physical Data Modeling and XML files.
• Involved in the Software Development Life Cycle (SDLC) with Analysis, Design, Development, Testing, Deployment and Maintenance.
• Worked on the latest version of SAP Business Objects Enterprise (Information Design Tool, Dashboard Designer, Web Intelligence, Crystal Reports Enterprise, Explorer) on Business Objects BI Platform 4.0.
• Experience with migration of data and upgrading to newer versions of Informatica.
• Strong hands on experience using Teradata utilities (SQL, B-TEQ, Fast Load, MultiLoad, FastExport, Tpump) and Teradata parallel support
• Implemented Real time CDC for DB2, Oracle databases in Informatica Power Exchange. Developed Real-Time Prototype scenario using Informatica Power Center and Power Exchange.
• Involved in handling tickets, monitoring, troubleshooting and maintenance for Day to day Activities.
• Understand the business rules completely based on High Level documents specifications and implements the data transformation methodologies.
• Deployed workflows as an application to run them and tuned the mappings for better performance.
• Extensive experience working on Reporting tools - Micro strategy, Crystal reporting, Cognos and Tableau.
• Installed and configured Power Center 9.0.1 and 9.5 on UNIX and LINUX platforms.
• Developed Power Exchange data maps and used CDC techniques to capture the changed data that were used to pull the data from files on the Mainframe /VSAM files.
• Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Aggregators, Stored Procedures and Normalizes.
• Worked in configuration management/versioning to migrate updated mappings, sessions and workflows in XML form to rational clear case environment and promote the code from one environment to other.
• Expertise in RDBMS, database Normalization and Denormalization concepts and principles
• Created landing, base and staging tables according to the data model and number of source systems.
• Worked on end-to-end implementation of automated data integrity profiling, monitoring and reporting tool.
• Advanced experience using Informatica power center version 9.6 and used critical transformations such as transaction control, Java transformation and XML Generator.
• Experienced on writing SQL, MySQL queries to extract data from various source tables to perform database testing.
• Knowledge in back end testing and writing SQL queries and Joins using Oracle, MySQL
• Experience with major databases including Netezza, Teradata, Oracle, DB2 and SQL Server.

TECHNICAL SKILLS:

RDBMS: Oracle 11g/10g/9i, SQL Server 2012/2010/2008 R2/2008 MS Access 9.0/7.0, Teradata 12/13, My SQL.

ETL Tools: Informatica 9.6.1/9.5.1/9.5/9.1 products (Power Center)

BI/OLAP Tools: Cognos 10, Tableau, SAP Business Objects 4.1, Xi3.1, Xir2, UDT

Operating Systems: Window 9X/NT/2K/XP, UNIX, Linux.

Data Modeling: Logical/Physical Data Modeling, IBM Rational Rose, Microsoft Visio 2004, 2007, 2010.

Programming Languages: SQL, PL/SQL, C, C++, VB.NET, C#.

Process: Data Profiling, Data Quality, Data Services, Change-Data-Capture (CDC), Push Down Optimization (PDO).

Schedulers: Control M, Autosys.

Other Tools: Toad, Oracle SQL Developer, Embarcadero Rapid SQL, Putty, MS Project Planner, Citrix Environments.

PROFESSIONAL EXPERIENCE:

Confidential, Portland, OR

ETL Developer

Responsibilities:

• Evaluate and prioritize business requirements and determine cost effective solutions that meet business goals while maintaining best practices of software design.
• Created new mappings, Unit and Integration Testing of Informatica Sessions, Batches and Target Data.
• Developed various transformations like expression, aggregator, joiner, source qualifier, router, lookup, update strategy, sequence generator, Union, Stored procedure and filter.
• Used Debugger to test the mappings and fix the bugs developing sessions and workflows to loading data from source to target tables.
• Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the Business requirements.
• Created Universes for report generation using SAP BOBI 4.0 Information Design Tool module Design, build and publish a set of webi reports and SAP BOBI 4.0 dashboard with interactive analytical capabilities
• Extract data from SAP BW/BexQuery for SAP BOBI 4.1 multi source Universe/IDT.
• Extract, Transformed and Load data from multiple data sources by SAP Data Service 4.0 ETL Tool
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Extensively worked on building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Worked on Java based application (ICAS). As part of support team deployed patches timely and also handles JVM setup and operations.
• Good Understating SOAP UI calls and XML.
• Created shell scripts for Data Validations, converting excel to csv.
• Understanding business requirements and the design.
• Worked on Upgrading process from Informatica 9.1 to Informatica 9.6
• Used stored procedures, functions to check any changes in data from ETL and update all the relevant tables, to improve the efficiency.
• Used Debugger to test the mappings and fix the bugs developing sessions and workflows to loading data from source to target tables.
• Significant experience & demonstrated proficiency in all aspects of database programming on T SQL and Oracle SQL/PLSQL and/or related technologies that encapsulate SQL, including Cursors, Procedures, Functions and Packages, Oracle Supplied Packages, Collections, Partitioned Tables, Triggers, Table Indexing.

Environment: Informatica Power Center 9.5/ IDR/ IDQ, Teradata 14.10, Netezza, Hadoop, Unix/ Linux, Scheduling tools Maestro & ESP.

Confidential, Dallas, TX

ETL Developer

Responsibilities:

• Referenced Functional Specification documents to understand the functional requirements to prepare the Technical Design documents
• Analyzed project requirements and participated to prepare the project plan at the task level
• Compared DB2 and Teradata databases properties/ metrics/ features to migrate DB2 warehouse to Teradata warehouse
• Worked closely on Infrastructure upgrades (Informatica, Teradata)
• Involved in meetings with key stakeholders of the business and discussed on strategies and roadmaps for Informatica Power Center Grid implementation.
• Prepared design documents as per the analysis of DB2 stored procedures
• Created the Teradata Set/ Multiset tables as per the data model/ requirements specifications
• Developed complex mappings to convert DB2 stored procedures into ETL mappings using Informatica Power Center to load data into Teradata
• Implemented Real time CDC for DB2 in Informatica.
• Developed Real-Time Advanced Prototype scenario using Informatica PowerCenter and PowerExchange for complex CDC requirements like filter on source.
• Tested and implemented appropriate Teradata loader utilities as per the load volume/ job requirements for better performance
• Designed delta or Incremental load process for all the ETL jobs
• Developed the error Logic for streamlining, automating the data loads for cleansing incorrect data and developed Auditing mechanism to maintain the load statistics of transactional records
• Worked on performance Tuning of the mappings to handle increasing data volume
• Design and review documents including Software Requirement Specifications to ensure all the requirements are covered
• Creation of Unit Test Cases (UTC’s), Unit Test Scripts and captured unit test results
• Involved in ETL, Unix and DDL’s code migration from one environment to other
• Reviewed complex mappings using multiple transformations, sessions, workflows in Informatica and lead the ETL team

Environment: Informatica Power Center 9.1, Power Exchange 9.1, Teradata 13.10, DB2 8.1, Sybase and UNIX.

Client: Hitachi, New York, NY JAN'14 - SEP'15

ETL consultant

Responsibilities:

• Created new mappings, Unit and Integration Testing of Informatica Sessions, Batches and Target Data.
• Used Informatica power center 9.6.1 to Extract, Transform and Load data into Microsoft SQL Data Warehouse from various sources like JD Edwards and ERP data.
• Worked on Upgrading process from Informatica 9.1 to Informatica 9.6
• Developed various transformations like expression, aggregator, joiner, source qualifier, router, lookup, update strategy, sequence generator, Union, Stored procedure and filter.
• Used stored procedures, functions to check any changes in data from ETL and update all the relevant tables, to improve the efficiency.
• Worked with different sources such as ERP data, JDE (AS400), Excel Sheets and Flat Files.
• Used Debugger to test the mappings and fix the bugs developing sessions and workflows to loading data from source to target tables.
• Worked with different sources such as ERP data, JDE (AS400), Excel Sheets and Flat Files.
• Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the Business requirements.
• Created Stored Procedures, Functions, Packages and Triggers using PL/SQL.
• Was responsible for all the ETL work - Upgrading and installing Informatica tool.
• Worked on Micro strategy reporting tool - Scheduling and running cubes
• Point of Contact for the all the ETL Processes involved in Business Intelligence team.

Confidential

ETL Developer

Responsibilities:

• Understanding business requirements and the design
• Automated the jobs thru ESP scheduling tool using Change Man control, which runs every day by maintaining the data validations.
• Created new mappings, Unit and Integration Testing of Informatica Sessions, Batches and Target Data.
• Developed various transformations like expression, aggregator, joiner, source qualifier, router, lookup, update strategy, sequence generator, Union, Stored procedure and filter.
• Worked on UNIX shell scripting.
• Significant experience & demonstrated proficiency in all aspects of database programming on Oracle SQL/PLSQL and/or related technologies that encapsulate SQL, including Cursors, Procedures, Functions and Packages, Oracle Supplied Packages, Collections, Partitioned Tables, Triggers, Table Indexing.
• Used Oracle PL/SQL stored procedures to check any changes in data from ETL and update all the relevant oracle tables, to improve the efficiency.
• Worked with different sources such as Oracle, Teradata, and flat files.
• Used Debugger to test the mappings and fix the bugs developing sessions and workflows to loading data from source to target tables.
• Good understanding in financial concepts likes Investment planning and risk involved in it.
• Involved in analysis of different Risks in Capital Market.
• Involved in data modeling and design
• Worked on Bteq’s for one of the projects to handle performance.
• Involved in the conversion from Maestro to ESP scheduler.
• Involved in on call support rotation and handling incidents and tickets.

Confidential

Business Analyst

Responsibilities:

• Selecting a particular base state, the requirements were documented in story cards as ‘delta’ changes. These changes could either be positive or negative.
• The front end of the Agency system moved from green screens to a new GUI
• Design the architecture for the management of the requirements in Rational Requisite Pro. This architecture later served as the base for all the upcoming state roll outs.
• Engineer a process for handling regulatory changes in the requirements management tool. Through this process, the tool must reflect the changes brought about by the regulatory changes and also maintain a version of the previous requirements.
• Rules extraction and rules management through Rational Requisite Pro.
• Analyze requirements, develop User Stories / Use-Case diagrams, Activity/ Class Diagrams and Conceptual flow diagrams using Unified Modeling Language (UML) Techniques & Microsoft Visio
• Script Business Requirement Documents (BRDs), Functional Requirement Document (FRD), Systems Requirements Specification (SRS) Technical Requirement Documents (TRD’s)
• Worked with QA Team in drafting Test Cases, Test Plans, User Acceptance Testing (UAT) to ensure software meets system/business requirements
• Subject matter expert on several work streams to provide technical perspective to role management and provisioning enhancements plans.
• Evaluated client delivered requirements and built test cases to demonstrate functionality outlined in requirements.
• Led technical presentation and demo to key stakeholders and creating highly-detailed Use Cases for identity management.

Environment: Java IBM db2, Oracle, UNIX, Control M Scheduling tool