CAREER SUMMARY:

• Over 12+ years of Information Technology experience in the Analysis, Design, Development and Implementation of Data Warehouse projects involving Teradata, Oracle and Informatica.
• Worked as SME (Subject matter expert) and reviewed many other projects for standards and performance improvements.
• Worked on a variety of BI scenarios, including enterprise DWH, data marts, high volume, metadata driven architecture, data integration and reporting solutions.
• Worked on BI architecture activities for multiple BI engagements for a large Healthcare product manufacturing company on the services domain. During this period, successfully participated in architecting, developing and deploying a variety of business intelligence solutions.
• Performed estimation of entire project including resource planning and SOW work.
• Extensively involved during user and performed knowledge transfer to support team.
• Experience with developing, testing and debugging complex Workflows/Mapping that utilize a wide variety of Transformations, on Informatica version 7.x, 8.x, 9.6.1, 10.1 using Power center client tools like Designer, Workflow Manager, Repository Manager, Workflow Monitor and Power Exchange Navigator.
• Perform data modeling in different project using client tools.
• Excellent backend programming skills in SQL, PL/SQL including stored procedures and triggers.
• Experience in Preliminary System Requirement Study, System Analysis & Development, Test Plan Preparation, Unit testing, System Integration testing and documentation.
• Involved in production support to resolve any critical issue and perform process improvement.
• Experience in Teradata, Oracle in developing Procedure and functions.
• Experience in Teradata Loaders/utilities like BTEQ, MLOAD, and FLOAD etc.
• Good business - facing skills and ability to successfully solve non-technical business and process issues.
• Strong communication skills when working with clients, developers, and system implementers.
• Analytical problem solver, team builder, and strong decision making skills. Manage communication gap between technical and non-technical team
• Effective management of stakeholder relationships at all levels of the business (both internally and with third party suppliers). Managed complex situation for different business process like Sales, Marketing, service and support.
• Proven Experience in Complete life cycle of Design, Development, Documentation and Maintenance of the Data marts and Data warehouse.

SKILLS:

ETL Tools: Informatica Power Center Versions (7.1, 8.6, 9.1, 9.6.1, 10.1.1), Power Exchange, Informatica Analyst, Informatica cloud

Database: Oracle (9i, 10g, 11g, 12c), Teradata (14), Sybase, Greenplum

Data Management: DWH/BI, Data Analysis, Data Integration, Data Engineering

Business Intelligence Tools: Business Objects, OBIEE, Tableau 10, Spotfire, Cognos 11

Other Tools/Utilities: SQL*Plus, Teradata SQL Assistant, TOAD, SQL Developer, Teradata Utilities (BTEQ, FLOAD, MLOAD, TPUMP, TPT)

Methodologies: Agile, Waterfall

Incident Management: Service Now, Cherwell

Programming Languages: UNIX shell scripting, SQL, PL/SQL, C, C++, Java

Operating System Windows: UNIX, MS DOS, Windows 9X/NT/2000/XP/VISTA/2007/2008

Configuration tools: SVN, Star team

Applications: MS Office, MS FrontPage, MS Project 98/200X, Rally, Asana

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

ETL Lead

Responsibilities:

• Participate in project that will take existing Oracle transactional data and ETL into enterprise data warehouse and data mart. The data mart is the source of Confidential ’s enterprise reporting using OBIEE.
• Participate in solution design activities including requirements gathering, ETL design & development
• Design and Develop detail ETL programs for the project.
• Maintenance and support of the existing applications.
• Collaborate with the quality assurance team in developing testing plans and streamlining testing activities
• Design and develop the overall data integration framework architecture for BI analytics
• Design / enhance the Dimensional model like Star Schema, Snow flake schema facilitating the reporting solution.
• Review of ETL Detailed design documents for Mapping and DDL specification document for creation of tables, defining keys/constraints on tables and data types.
• Helping the team in fixing the technical issues if any and Tuning of Database queries for better performance. Fine tuning mappings and sessions to improve performance
• Working with the Business Analysts, technical analysts and the business users to understand the data, the expected formats, data hierarchies and the functional hierarchies of various datasets.
• Responsible for code migration, Go live support and post production support.

Technology: Informatica Powercenter 10.1, Informatica Cloud, OBIEE, Oracle, SQL, PLSQL

Confidential, Overland Park, KS

ETL Implementation Lead/Architect

Responsibilities:

• Developed the overall flow, frequency of update and base time for refresh and set expectation before starting of project.
• Requirement and Data analysis of the JAROS and new identifying the business logic are in sync with the help of SQL.
• Led ETL team and responsible for the team deliverables and end to end implementation of the project.
• Translating requirements into Design with HLD, LLD.
• Design the overall data integration framework architecture replacing the JAROS BI analytics with simplified architecture.
• Design / enhance the Dimensional model like Star Schema, Snow flake schema facilitating the reporting solution.
• Remediation analysis and implementation of the existing JAROS to the simplified architecture.
• Review of ETL Detailed design documents for Mapping and DDL specification document for creation of tables, defining keys/constraints on tables and data types.
• Helping the team in fixing the technical issues if any and Tuning of Database queries for better performance. Fine tuning mappings and sessions to improve performance
• Worked with the Business Analysts, technical analysts and the business users to understand the data, the expected formats, data hierarchies and the functional hierarchies of various datasets.
• Developed and mentored team members for developing ETL Informatica mappings, review, and validate the same to have required data in the BI environment.
• Responsible for addressing the issues / defects highlighted during various testing phases like CRP, SIT and UAT.
• Responsible for code migration, Go live support and post production support.

Technology: Informatica Powercenter 10.1, JAROS, Oracle, SQL, PLSQL, Cognos 11

Confidential

ETL Lead

Responsibilities:

• Design and development of the data flow for the RACES ERP to ODS / EDW involving Informatica CDC and GP.
• Impact analysis of existing architecture and how architecture could be completed using Informatica CDC and GP.
• Estimation for the newer enhancement requests and Project schedule preparation.
• Responsible for end-to-end analysis of the JAROS application and flow and replicating the same logic and data flow using Informatica CDC and GP.
• Gathered requirements and data elements crucial for decision making for approach and analysis.
• Analyzed the data that was to be processed as part of the ETL process that was being built.
• Created mappings using the transformations like Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, XML transformation, Update Strategy and Joiner transformations.
• Created Documents such as (HLD, LLD) Technical Systems Design, Source-To-Target Data mapping Document, Backroom Services Document, and Metrics for ETL documents, Unit Test Cases and Migration Documents for Production support.
• Responsible for defect tracking and single point of contact for UAT.
• Developed test plans and test cases at various interfaces of the project.
• Migrated mappings, sessions and workflows from development environment to test environments and Production.
• Conducted various peer reviews and code reviews during the build period for the project.
• Involved in migration of Cognos reports to Tableau and Migration of Oracle DB to GP.
• Was responsible for anticipation of technical, environmental and delivery issues / risks and plan for the mitigation of the same.

Technology: Informatica 9.6 PowerExchange, JAROS, Oracle, Tableau 10, Greenplum, SQL, PLSQL, Cognos

Confidential

ETL Lead

Responsibilities:

• Analysis and worked on data reconciliation from various sources using SQL.
• Mainly focused on the data quality and data mismatch between the source and the target and highlighted the issue to client community.
• Proposed changes in the existing design of the data flow to mitigate the data quality issues.
• Analyze Informatica flow from source to target and reconcile the data based on the business logic implemented in Informatica.
• Designed server-side PL/SQL scripts for data manipulation, validations.
• Design of the data flow and to have common ODS/EDW for client architecture. Also worked on achieving this with Informatica and Teradata utilities like BTEQ, FLOAD, MLOAD and TPUMP scripts.
• Developed Shell Scripts which take care of truncate table, Archival the source and the target files and Clean up the log files
• Worked extensively on Flat Files, as the data from various Legacy Systems parsed the Functional specifications into a Technical document, which would provide an efficient platform for peers for development.

Technology: Teradata (Utilities - BTEQ, FLOAD, MLOAD, TPMUP), Informatica, Cronacle, SQL, PLSQL, Shell Scripts, Business Objects, Erwin, Windows 7, Unix (AIX).

Confidential

Data Quality Lead

Responsibilities:

• Lineage / blueprint for the changes in the flow. Documenting HLD, LLD and system specifications. Design and implement data quality dashboards and scorecards for communicating progress to business stakeholders and data quality sponsors
• Perform source data profiling & analysis against established DQ controls and compliance standards. Implement a framework that addresses issues in existing data and provides a foundation for continuous improvement
• Analysis of the various business process, new requirements and activities to simplify the Equipment Finance (EF) models.
• Interact with the business users and the data stewards based on the analysis of the existing system, get the go-ahead approval on the new short-term and long-term remediation approach, and discuss with the development with for the implementation of the same.
• Development of the ETL mappings with involving the rules for short term and long term goals.
• Obtain business insight on exceptions and issues identified (review of metrics, data distributions, outliers, trends, etc.). Provide sustainable long-term plan and remediation and governance approach.

Technology: Informatica, Informatica Data Quality, SQL, PLSQL

Confidential

ETL Lead

Responsibilities:

• Impact analysis and detail requirement Analysis on the KPI's required in the Dashboard like Uptime, Infantile Failure rate (IFR), Mission Failure rate (MFR), Elapsed time to repair (ETTR), Mean Time between Failure (MTBF), Install and warranty etc. All the KPI mentioned were developed using SQL and embedded in the workflows and jobs.
• Extensively worked in data Extraction, Transformation and Loading from source to target system using Power Center of Informatica.
• Data reconciliation and integration checks against the existing and new environments through SQL queries.
• Informatica mappings design/ development and review for source to target loading.
• Worked on SQL/PLSQL programming to implement the business logic and data loads. Informatica mappings development for source to target loading.
• Analysis on the newer requirements from both the source end and the Warehouse and taking up with the Client community for any clarification /suggestion.
• Interact with various business communities and platforms to capture, verify, prioritize and finalize requirements. Preparation of HLD documents like SRS, SRDS, Impact analysis documents and review of LLD documents.
• Environment set up with predefined data model and with ODS, EDW client architecture model implemented.
• Ensure correct loading of the tables and build relations, and facilitate to reporting solution to achieve the KPI defined.
• Support user community during UAT for the issues if any.
• Design of the data flow and to have common ODS/EDW for client architecture.
• Analyze requirements and discuss with client community to identify the gaps and suggested changes on the URS and suggested design recommendations, as well as source side that were accepted and implemented.
• Estimation for the newer enhancement requests and Project schedule preparation.
• Responsible as technical liaison between the Business Users and the implementation teams.
• Responsible for defect tracking and single point of contact for CRP1, CRP2 and UAT.
• Coding and testing of the application.
• Co-coordinating with the various teams for reviewing and migrating of objects.
• Preparation of SRS, SRDS and other documentation required.
• Project status tracking and reporting
• Mentor the development team in technical aspects of the requirements and review the code.
• UAT support and go live support for the application.

Technology: Teradata (Utilities - BTEQ, FLOAD, MLOAD, TPMUP), Informatica, Cronacl0065, SQL, PLSQL

Confidential

Senior Software Engineer/Developer

Responsibilities:

• Create procedures, packages and functions to extract data from different sources.
• Developed mappings using expression, aggregator, filter, joiner, Lookup, router, update strategy and procedures to develop and feed Data Mart. Deployed and tested sessions in Informatica Server
• Creating shell scripts to trigger Informatica Sessions and Workflows.
• Programming the business logic (Oracle PL/SQL, Sybase) for LoanReg, TCO, External Interfaces & GMAC applications.
• Preparing System specification, Unit testing, test case preparation and Production support for LoanReg interface.
• Investigating and solving any production issues that may arise and suggest and make necessary changes to the applications if required to prevent similar issues from arising in the future.
• As Release manager, was responsible for the various release versions of the internal interfaces code and involved in the migration activities.
• Perform unit testing at various levels of the ETL.

Technology: Oracle, Sybase, VC++, Informatica Powercenter, SQL, PLSQL