SUMMARY

• Eleven (11+) years of IT experiences with (10+) years in the Analysis, Design, Development, Testing and Implementation of business application systems for Health care, Pharmaceutical, Financial, Telecom and Manufacturing Sectors.
• Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.
• Strong Data Warehousing ETL experience of using Informatica 10.x/9.6/9.5/8.6 Power Center Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.
• Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation, and production support.
• Extensive testing ETL experience using Informatica 9.1/8.6.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager) Confidential and Business Objects.
• Strong experience in Dimensional Modeling using Star and Snowflake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using Erwin and ER-Studio.
• Expertise in working with relational databases such as Confidential 12c/11g/10g/9i/8x, SQL Server 2008/2005, DB2 8.0/7.0, UDB, MS Access and Confidential .
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Confidential, DB2 and SQL Server Databases.
• Designed conceptual data model based on the requirement, interacted with non-technical end users to understand the business logics.
• Modeled the logical and physical diagram of the future state, Delivered BRD and the low-level design document. Discussed the Data model, data flow and data mapping with the application development team.
• Helped developing PL/SQL packages, Conducted Unit testing, coordinated the production deployment and resolved Post implementation issues.
• Provided Maintenance & Support of the existing applications.
• Knowledge of using SSIS, SAS, Talend, Pentaho & Confidential ODI as ETL tool in Enterprise Data warehouse experience has been used.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Confidential PL/SQL.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions, IDQ and prebuilt function uses.
• Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting.
• Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
• Proficient in the Integration of various data sources with multiple relational databases like Confidential 11g /Oracle10g/9i, MS SQL Server, DB2, Confidential, VSAM files and Flat Files into the staging area, ODS, Data Warehouse and Data Mart.
• Experience in using Automation Scheduling tools like Autosys and Control-M.
• Worked extensively with slowly changing dimensions.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, system integration and user acceptance testing.
• Hand on knowledge and exposure in Sales Force CRM Solution, Data Warehousing and Informatica data integration in clouding environment with Sales Force on Demand CRM solution. Sales force data migration and integration processes in web-portal in clouding concepts.
• Hand on experience with SCRUM methodology using Confidential and CA tools along with JIRA, Confluence
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, businesspeople, and developers across multiple disciplines.
• Exposer in IDQ module, data profiling, applying basic formatting and cleansing rules from built in application as well as creating specific rules to use internally.

TECHNICAL SKILLS

Operating Systems: Windows 2010/2008/2007/2005/ NT/XP, UNIX, MS-DOS

ETL Tools: Informatica Power Center 10.x/ 9.6/9.5/9.1/8.6/8.5/8.1/7.1 (Designer, Workflow Manager, Workflow Monitor, Repository manager and Informatica Server), Talend, SSIS, Ab-Initio.

Databases: Confidential 11g/10g/9i/8i, MS SQL Server 2012/2008/2005, DB2 v8.1, Confidential 14, PG Admin 8, SAP

Data modeling tools: Erwin, MS Visio

OLAP Tools: Cognos 8.0/8.1/8.2/8.4/7.0/, Business Objects XI r2/6.x/5.x, OBIEE 10.1.3.4/ 10.1.3.3, Micro strategy, Hyperion.

Languages: SQL, PL/SQL, UNIX, Shell scripts, C++

Scheduling Tools: Autosys, Control-M, TWS

Testing Tools: QTP, WinRunner, LoadRunner, Confidential ILM Q. Center, Test Director, Clear test, Clear case. Confidential JAZZ tool, Jira Tracker system.

Professional Experience:

Confidential, Charlotte, NC

Sr. Informatica Consultant

Responsibilities:

• Modification in an existing integration of (GIS) geospatial data project where an application already implemented few years before.
• As regulatory requirement changes, simplify and gather informatica code information to Modifying existing ETL model with new requirement that needed for regulatory data reporting changes.
• This project consists connecting with Project manager and Multiple segment of business personnel needed, performs timely collaboration for exiting data validation as well as project’s needs.
• Programming ETL code, unit testing, move to QA and get ready to implement in future release in production in involved.
• Nature of data integrity shared across parties and ETL development changes as vendor data needed as a progressive ETL solution is addressed.
• Perform daily call among team and keep up with requirements and upcoming changes.
• Modify ETL as required, Suggest, and implement code changes. Persist in data analysis, data modeling while connecting with data architect as well as system architect. Follow up with downstream impact analysis.
• Connect with different team to maintain ETL and physical data model standards, document as needed for s.
• Timely delivery for test and documenting changes were highly aggregated.
• Jira/Confluence/Git hub uses for teamwork.
• Windows shell scripting for ETL as needed.

Environment: Informatica 10.2, Confidential, SQL server 19, Windows server R12 shared, CAWA scheduler.

Confidential, Dallas, Texas

Sr. Informatica DW Consultant L2

Responsibilities:

• Confidential integration project to implement multi segment of new source data.
• As company inherited some other organizational data, new project added to apply new ETL requirement in addition to existing framework.
• Gathering new requirement and lead among team to deliver code as needed.
• Connecting with team members, business, and client team.
• Delegate daily updates from team members as well as personal deliverable in a scrum.
• Planning Assignment and adjust allocation in scrum model performed, team efforts and performance trend kept in place to maintain project milestones.
• A continuous collaboration for code change, test and move to upper environments.
• Keep up with multiple thread for new releases. Batch scheduling.
• Analysis and prepare ETL requirements and technical design
• Specifications to address ETL code to deliver.
• Analysis and prepare document of business requirements and technical design
• Specifications to address ETL requirements that delivered by architect team.
• Ensure software design and code are consistent with development standards And align with industry guidelines/best practices
• Oversees the design, development and testing of enhancements spanning multiple
• Help code migration process for informatica, DB changes and script modifications.
• Use of Dev op process with GIT hub, Jenkins
• Windows shell scripting for ETL.

Environment: Informatica 10.2. Confidential, SQL server, Windows server shared platform.

Confidential, Dallas, Texas

Sr. Informatica DW Consultant

Responsibilities:

• Migration involved validating the accuracy of the existing data, designing the domain models required for understanding the existing structure, and integrating new functionality. Designed LDM and PDM for the Enterprise Data.
• Translated and assembled business requirements into detailed, production-level technical specifications, detailing new features and enhancements to existing business functionality.
• Executed data modeling using Erwin data modeling tool.
• Created the data models for OLTP and analytical systems. Engaged in data profiling to integrate data from different sources.
• Performed the gap analysis and impact analysis.
• Assisted DBAs on support needs and provided guidance on architectural issues.
• Worked with Development teams with loading and extracting data (ETL).
• Facilitated QA for developing test plans and test cases for unit, system, and Enterprise testing.
• Collaborated on the data mapping document from source-to-target and the data quality assessments for the source data.
• Analysis and prepare document of business requirements and technical design
• Specifications to address ETL requirements that delivered by architect team.
• Ensure software design and code are consistent with development standards
• And align with industry guidelines/best practices. Data modeling and connecting team for ETL data architectural design changes. Data migration from DB2 BPCS system to LX, Confidential . implementation using Informatica Power Exchange.
• Oversees the design, development and testing of enhancements spanning multiple areas and of moderate to high complexity of coding. Coordinate pipeline for migration phases
• Provides Pre-production application support as required. Responsibilities may
• Include documenting and preserving code in upper environment with deployment group and assist, issue identification, data analysis and break fixes
• Provides post-production application support as required.
• Responsibilities may Include triaging, issue identification, data analysis and break fixes
• Assists in providing technical expertise in evaluating and determining what new
• Technologies will work within the technical environment. Batch scheduling like Control-M.
• Designed conceptual data model based on the requirement, interacted with non-technical end users to understand the business logics.
• Modeled the logical and physical diagram of the future state, Delivered BRD and the low-level design document.
• Discussed the Data model, data flow and data mapping with the application development team.
• Helped developing PL/SQL packages, Conducted Unit testing, coordinated the production deployment and resolved Post implementation issues.
• Provided Maintenance & Support of the existing applications.
• Prepared, processed numerous customer input files; parsed and reformatted the data to meet product requirements.
• Processed and analyzed product return files; parsed and reformatted to meet customer specifications.
• Generated statistical reports for quality checks and other reports for reporting and billing departments.
• Actively participated in team meetings and inter-departmental workshops to discuss best practices/processes to improve.
• Actively participated in technical/professional

Confidential, Colorado

Sr. Informatica Consultant

Responsibilities:

• The Confidential provides a full range of securities, brokerage, banking, money management, and financial advisory services through its operating subsidiaries. Its broker-dealer subsidiary, Confidential & Co., Inc. (“ Confidential ”), Member SIPC, offers investment services and products, including Confidential brokerage accounts. Its banking subsidiary, Confidential member FDIC and an Equal Housing Lender), provides deposit and lending services and products.
• Deal with client financial data as well as application framework.
• Analysis and define document of business requirements and technical design
• Specifications to address ETL requirements that delivered by BA group.
• Ensure software design and code are consistent with CSHWB development standards
• And align with industry guidelines/best practices
• Participates in the testing and validation of new software to ensure software
• Changes meet data and functional requirements using informatica DVO with testing team.
• Oversees the design, development and testing of enhancements spanning multiple areas and of moderate to high complexity of coding.
• Python for excel spread sheet data and other file format conversion with lay out modification using panda and other add on utility.
• Windows shell scripting for ETL.
• Provides Pre-production application support as required. Responsibilities may
• Include documenting and preserving code in upper environment with deployment group and assist, issue identification, data analysis and break fixes
• Provides post-production application support as required. Responsibilities may
• Include triaging, issue identification, data analysis and break fixes
• Assists in providing technical expertise in evaluating and determining what new
• Technologies will work within the technical environment.
• Use of Dev op process with GIT hub.

Environment: Confidential 12g, Confidential 16, Unix, SQL server 14-16, informatica 10.X, Jira, Confluence, Visual Studio. Control-M as ETL Scheduler. Python using panda add on.

Confidential, MN

Sr. Informatica Consultant

Responsibilities:

• A trusted partner at more than one million customer locations, Confidential (ECL) is the global leader in water, hygiene and energy technologies and services that protect people and vital resources. With 2016 sales of $13 billion and 48,000 associates, Confidential delivers comprehensive solutions and on-site service to promote safe food, maintain clean environments, optimize water and energy use and improve operational efficiencies for customers in the food, Confidential, energy, hospitality and industrial markets in more than 170 countries around the world. Confidential is SAP data warehouse built in supply chain global data
• Analysis and define document of business requirements and technical design
• Specifications to address ETL requirements
• Ensure software design and code are consistent with Confidential development standards
• And align with industry guidelines/best practices
• Participates in the testing and validation of new software to ensure software
• Changes meet data and functional requirements.
• Oversees the design, development and testing of enhancements spanning multiple areas and of moderate to high complexity.
• Provides post-production application support as required. Responsibilities may
• Include triaging, issue identification, data analysis and break fixes.
• Windows shell scripting for ETL.
• Assists in providing technical expertise in evaluating and determining what new
• Technologies will work within the technical environment
• Deliver development environment based on internal Confidential standards
• SAP integrations (IDocs, BAPI, RFC), working with XML sources
• Ability to analyze performance issues within applications / databases and make
• Recommendations for improvement
• Excellent communications skills, both verbal and written
• Strong problem-solving, analytic, conceptual, and critical thinking skills
• Self-motivated and co-operate with business team
• Confidential AIX, SAP, Microsoft SQL Server 2012/16, UC4 and other scheduling tools, Agile environment.

Confidential, Greater Denver, CO

Sr. Informatica ETL Developer

Responsibilities:

• Project for Data Migration in SAP environment using with current internal software tool set.
• In-depth of Software Development Life Cycle (SDLC), various phases such as Requirements, Analysis/Design, Development and Testing.
• Power Exchange adapter for SAP data extraction and LSMW load process with implementing partner.
• Interacting with Business and Client level for requirement changes and ETL process modifications.
• ETL using Informatica PowerCenter 9.6x, 9.5x, Informatica PowerMart 9.5x, Warehouse Designer, Power Exchange, Power Connect for SAP/ Confidential Apps/ Siebel, Power Analyzer, DataMart, OLAP, OLTP, ETL Scheduler.
• Confidential 's ODBC/Bteq, Fast, Multi load connection. The Load Date and Load Time are also captured in the Confidential tables.
• An Accenture implemented SAP data migration Project.

Confidential, Denver, CO

Sr. Informatica ETL Developer

Responsibilities:

• Data warehousing with STAR SCHEMA and package management for Risk management control.
• Data migration from Confidential EBS system, Confidential implementation using Informatica Power
• Exchange from Confidential supplemental log for semi-real-time changes.
• Use of Informatica IDR tools for another supplemental log retrieval for Confidential .
• Using Informatica Power Center Designer analyzed the source data to Extract & Transform from various source systems ( Confidential 12c, SQL server and Mainframe flat files).
• Legacy GEO data analysis using TOAD, SQL developer.
• Used various transformations like Source Qualifier, Joiner, Lookup, Aggregator, sql, Router, Filter, Expression and Update Strategy, SQL, Java
• Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement
• Unix Scripting, Scheduling, Conditioning, Monitoring and other ETL needs.
• Validating against business need and ETL transport timeline aspect.

Environment: Informatica Power Center 9.5x - (Designer, Repository Manager, Workflow Manager), Confidential 12c, Confidential 11g, TOAD, SQL Developer, UNIX.

Confidential, Monterey Park, CA

Sr. Informatica ETL Developer

Responsibilities:

• Logical and Physical data modeling was done using CA Erwin for data warehouse database in STAR SCHEMA. CA package management for Risk management control.
• Using Informatica PowerCenter Designer analyzed the source data to Extract & Transform from various source systems ( Confidential 11g, PgAdmin, SQL server and JCL (Mainframe flat files) by incorporating global financial business rules using different objects and functions that infa tool supports. Using TOAD, SQL developer 4, PostgreSQL 8.
• Using Informatica PowerCenter created mappings and mapplets to transform the data according to business rules. IDQ and Address doctor.
• Used various transformations like Source Qualifier, Joiner, Lookup, Aggregator, sql, Router, Filter, Expression and Update Strategy, SQL, XML perser.
• Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement
• ETL Automation using AutoSys v11. Scripting, Scheduling, Conditioning, Monitoring and
• Validating against business need and ETL transport timeline aspect.
• Implementing partner Cap Gemini.

Environment: Informatica Power Center 9.5 - (Designer, Repository Manager, Workflow Manager), Confidential 11g, Confidential 10g, PgAdmin, TOAD, SQL Developer, AQT, UNIX Shell Scripts.

Confidential, St. Louis, MO

Informatica ETL Developer

Responsibility:

• Logical and Physical data modeling was done using Erwin for data warehouse database in STAR SCHEMA
• Using Informatica PowerCenter Designer analyzed the source data to Extract & Transform from various source systems ( Confidential 10g, DB2, SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports.
• Using Informatica PowerCenter created mappings and mapplets to transform the data according to business rules.
• Used various transformations like Source Qualifier, Joiner, Lookup, Aggregator, sql, Router, Filter, Expression and Update Strategy.
• Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.
• Use of most recent TD 14.1 utility in temporal data set and capturing most recent data.
• Use IDR tool to map source and target, schedule migration of Confidential 11g log data.
• Use DVO to validate captured data in ELT automation in data validation process
• Use of most recent version of Autosys as ETL scheduler.
• Interact, Collaboration and emphasize new approaches as common goal
• Interact and manage team members
• MKS version control
• Working with Admin for real-time ETL solution in UNIX architecture, Data modeler using Erwin.

Environment: Unix, Windows 7, Informatica 9.5.1+, TD 14.1 Confidential 11g, Toad, Confidential MKS, SharePoint, and CA Erwin.