SUMMARY:

• 10+ years of IT experience in Data warehousing, Data integration, Data Migration, Data visualization, ETL Processes and Business intelligence applications.
• Experience in the full development lifecycle including requirements gathering, design, programming/testing and implementation.
• Excellent knowledge in Business Intelligence and OLAP and Data Warehousing concepts.
• Expertise in development and support for informatica power center 7.x/8.x/9.x. Designer, workflow manager, workflow monitor.
• Experience in designing and developing mappings to extract data from diverse sources such as SQL Server/ Confidential /SAP ECC, flat files, Excel, .CSV files and legacy systems.
• In - depth knowledge of Data Warehouse concepts such as Star, Snowflake Schemas and Multi-Dimensional Models for Query and Analysis purpose
• Good working knowledge of Dimensional Modeling using Kimball methodologies.
• Expertise in implementing Data Quality Transforms like Match Consolidation and Address Cleansing
• Extensive experience in creating the Workflows, Worklets, Mappings, Mapplets, Reusable transformations and scheduling Workflows and sessions using Informatica Power Center
• Technically sound and excellent analytical skills with proper awareness of the Quality & Management Procedures
• Designed and developed complex mappings, from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner Update Strategy and more
• Developed Mappings, Sessions and Workflows for relational & flat file sources and targets
• Proficiency in data warehousing techniques for data cleansing, slowly changing dimensions types (1, 2 and 3)
• Worked on monitoring the load of the system using the Teradata Manager/View Point
• Experience in Development, Performance Tuning and testing phases of Enterprise Data warehouse with strong debugging and analytical skills
• Monitoring and scheduling the jobs through job scheduling tools
• Proficient in writing SQL and PLSQL/Teradata-SQL Queries in order to create Stored Procedures, use INNER and OUTER JOINS for Reports
• Proficient in using INFORMATICA Transformation such as Connected and UnConnected Look-up, Router and Filter, Aggregator, Joiner, Normalizer, Sequence Generator etc
• Expertise in Informatica Power Center 7.x, 8.x and 9.x
• Experience working on performance tuning of ETL code (Informatica & Database)
• Experience working on different source systems including Flat Files, Confidential, SqlServer, DB2 and Teradata
• Extensive Working experience in applying Relational Database concepts, Entity Relation diagrams and Normalization concepts
• Experience using TEARADATA SQL and Utilities like fastload, multiload, fast export, tpump
• Expertise in implementing ETL and ELT techniques
• Hands on experience in preparing User Specification Requirement, Software Requirement, Technical Documentation, and Test Plan
• Strong experience in interacting with business users, gathering requirements through interviews, workshops, and existing system documentation or procedures, defining business processes, identifying and analyzing risks using appropriate templates and Analyst tool
• Experience in Confidential 11g/10g/9i/8i, Teradata, MS SQL Server 2005/2008R2/2012, XML, Netezza, MS Access and MS Excel.
• Experience in creating complex, SQL, PL/SQL programs, Views, data base indexes and database links.
• Experience with SQL Reporting services like SSRS and SSAS against database tables.
• Working with Agile methodology in project execution processes.
• Experience in developing user manuals and documentation of the applications.
• Experience with UNIX, Linux and Windows operating systems.
• Excellent analytical, functional, design and development skills with excellent communication skills, both written and verbal. Ability to work in both individual and team environments.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 7.x/8.x/9.6.1, MS SQL Server SSIS.

BI Tools: SAP Business Objects 4.0/4.1, Dashboard, IDT/UDT Tools, SAP BW BEx Query Designer, BEx Query Analyzer, Tableau 8.x/9.1.

Languages: SQL, C, PL/SQL, UNIX, java, XML, shell scripts.

Web: IIS, Apache Server, Tom cat, JavaScript, XML, HTML, DHTML

Databases: Confidential 8i/9i/10g/11g, Netezza, Teradata, SQLServer 2005/08/2012, MS AccessGUI Tools VB.NET, Java, Visual Basic, Visual Studio, MS Office

QA Tools: HP Quality Center 9.0/ALM 11.

Version Control: IBM Rational Clear Case, informatica power center.

Others: Microsoft SharePoint, Quest Toad 11.x, Confidential SQL Developer.

Data Model Tool: Erwin7/8/r9.5.

PROFESSIONAL EXPERIENCE:

Confidential, Parsippany, NJ

Senior ETL Developer.

Responsibilities:

• Analyzed the business requirement to check the feasibility of reports and dashboard implementation.
• Worked with business process owners, stakeholders to understand and document the requirements. Interacted with the project managers to understand the business requirements and implemented the business rules to redesign and enhance the existing data flows.
• Architect ETL/reporting solutions.
• Extracting the data from different Domains: Finance(AP,AR), Sales and Marketing, Supply chain, Human Resources, People Soft HR
• Manage the day-to-day work of the BI team to ensure consistent technical direction and maintain best practices in all phases of project life cycle.
• Prepare Informatica ETL Mapping Documents according to ETL coding Standards
• Develop Informatica ETL mappings, workflows by following the ETL Development Standards and Guidelines.
• Involved in the Extraction, Transformation and Loading of data (ETL Process) from multiple sources to target using Informatica Power Center software (Repository Manager, Designer, Server Manager)
• Managing Requirement gathering, Analysis, Design, Coding, Unit Testing, DIT2 and UAT
• Developed standard and reusable mappings and mapplets using various transformations like Expression, Aggregator, Joiner, Router, XML, Lookup (Connected and Unconnected) and Filter
• Involved in fixing performance issues existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance through partitioning and other techniques.
• Testing and Deployment/Implementation support
• Understanding Business requirements and analyzing better approach.
• Analyzing, Indexes and SQL Optimizer for fine-tuning the SQL and PL/SQL queries.
• Worked with DBA to fine tune complex SQL’s, do regular Run-Stats on the tables, drop and re-create indexes to decrease run times of various mappings which process large volume of data.

Environment: Informatica Power Center 9.6.1, Tableau 8.x/9.x,, SQL Server 2012, Confidential 11g, Quest TOAD 11.x, MS Access, MS power pivot, SQL/PL SQL, MS Office, Unix, windows NT, Unix.

Confidential, South Portland, Maine

Senior ETL Developer.

Responsibilities:

• Analyzed the business requirement to check the feasibility of reports and dashboard implementation.
• Worked with business process owners, stakeholders to understand and document the requirements. Interacted with the project managers to understand the business requirements and implemented the business rules to redesign and enhance the existing data flows.
• Architect ETL/reporting solutions.
• Extracting the data from different Domains: SIEBEL, Sales Force CRM and (Account Payables, Account Receivables and Travel & Expense) People Soft HR
• Designed the reporting landscape: Rationalized the legacy databases (Account Payables department) into Confidential architecture and built BO WebI Reports lead the Universe Design Review meetings with the Developers, and guided them on implementing the universes based on best practices.
• Created Best Practice documents (for Informatica Power center, BO Universe, WebI Reports and Dashboards) for the development team.
• Manage the day-to-day work of the BI team to ensure consistent technical direction and maintain best practices in all phases of project life cycle.
• Prepare Informatica ETL Mapping Documents according to ETL coding Standards
• Develop Informatica ETL mappings, workflows by following the ETL Development Standards and Guidelines.
• Involved in the Extraction, Transformation and Loading of data (ETL Process) from multiple sources to target using Informatica Power Center software (Repository Manager, Designer, Server Manager)
• Managing Requirement gathering, Analysis, Design, Coding, Unit Testing, DIT2 and UAT
• Developed standard and reusable mappings and mapplets using various transformations like Expression, Aggregator, Joiner, Router, XML, Lookup (Connected and Unconnected) and Filter
• Involved in fixing performance issues existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance through partitioning and other techniques.
• Testing and Deployment/Implementation support
• Understanding Business requirements and analyzing better approach.
• Analyzing, Indexes and SQL Optimizer for fine-tuning the SQL and PL/SQL queries.
• Worked with DBA to fine tune complex SQL’s, do regular Run-Stats on the tables, drop and re-create indexes to decrease run times of various mappings which process large volume of data.

Environment: Informatica Power Center 9.6.1, Tableau 8.x/9.x,, SQL Server 2012, Confidential 11g, Quest TOAD 11.x, MS Access, MS power pivot, SQL/PL SQL, MS Office, Unix, windows NT, Unix.

Confidential, Carrollton, TX

ETL Lead Developer.

Responsibilities:

• Participated in weekly project planning sessions with project managers, business analysts and development team to analyze business requirements and outline proposed solutions to meet the delivery needs.
• Analyzed the business requirement to check the feasibility of reports and dashboard implementation.
• Involved in the Extraction, Transformation and Loading of data (ETL Process) from multiple sources to target using Informatica Power Center software (Repository Manager, Designer, Server Manager)
• Managing Requirement gathering, Analysis, Design, Coding, Unit Testing, SIT and UAT
• Developed standard and reusable mappings and mapplets using various transformations like Expression, Aggregator, Joiner, Router, Lookup (Connected and Unconnected) and Filter
• Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.
• Testing and Deployment/Implementation support
• Understanding Business creation, test script creation, defect reporting, debugging at integration level
• Requirements and testing the applications developed, to meet the business requirements.
• Used Analyze, Indexes, and SQL Optimizer for fine-tuning the SQL and PL/SQL queries
• Worked with DBA to fine tune complex SQL’s, do regular Run-Stats on the tables, drop and re-create indexes to decrease run times of various mappings which process large volume of data
• To perform environmental validations and make sure all the required database objects are in valid state.
• Coordinate with cross functional teams for EDW and ensure successful completion of End to End System Testing.
• Coordinate migration of code from Development to Testing and from Testing to Production environment.
• Understanding the defect reporting conventions, the several details related to priority, routing, cross-project functionality and the defect database.
• Provide support of systems after implementation by Defect tracking, resolution and root cause analysis using QUALITY CENTER.
• Provide assistance in feasibility analysis for new requirements.
• Support for SIT & UAT testing.
• Communication to Offshore team, Cross functional team and to the Downstream

Environment: Informatica Power center 8.x/9.x, IBM Data Stage8.x, Netezza Aginity Workbench, SQL Server 2005/2008/2012, Confidential 10g/11g, MS Access, MS power pivot, SQL/PL SQL, MS Office, Unix, windows NT. MS Excel.

Confidential, Irving, Dallas, TX

Sr. ETL Developer

Responsibilities:

• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution to satisfy the needs of Business Units and Supplier Partners.
• Analyzed the business and requirement to check the feasibility of implementation.
• Fulfilled a Business Analyst and ETL Developer position in the current team for the Deployment projects.
• Source System Analysis.
• ETL Process Designing.
• Involved in the Extraction, Transformation and Loading of data (ETL Process) from multiple sources to target using Informatica Power Center software (Repository Manager, Designer, Server Manager)
• Managing Requirement gathering, Analysis, Design, Coding, Unit Testing, SIT and UAT
• Developed standard and reusable mappings and mapplets using various transformations like Expression, Aggregator, Joiner, Router, Lookup (Connected and Unconnected) and Filter
• Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.
• Test environment setup, test data creation, test script creation, defect reporting, debugging at integration level
• SME (Subject Matter Expert) review
• Testing and Deployment/Implementation support
• Understanding Business requirements and testing the applications developed, to meet the business requirements.
• Used Analyze, Indexes, and SQL Optimizer for fine-tuning the SQL and PL/SQL queries
• Worked with DBA to fine tune complex SQL’s, do regular Run-Stats on the tables, drop and re-create indexes to decrease run times of various mappings which process large volume of data
• To perform environmental validations and make sure all the required database objects are in valid state.
• Coordinate with cross functional teams for EDW and ensure successful completion of End to End System Testing.
• Coordinate migration of code from Development to Testing and from Testing to Production environment.
• Understanding the defect reporting conventions, the several details related to priority, routing, cross-project functionality and the defect database.
• Provide support of systems after implementation by Defect tracking, resolution and root cause analysis using QUALITY CENTER.
• Provide assistance in feasibility analysis for new requirements.
• Support for SIT & UAT testing.
• Communication to Offshore team, Cross functional team and to the Downstream
• Extensively worked in both Production and Development environments of resolving their daily issues and Improvements.
• Generated universe and report user documentation guide for the end users reference.

Environment: Informatica power center8.x, SQL Server 2005/2008, MS Access,Teradata, SAP BW,SQL,PL SQL,MS Office, VSS, Unix, windows NT. MS Excel, fiddler and visual studio

Confidential, New York

ETL developer

Responsibilities:

• Responsible for Extracting, Transforming and Loading data from Confidential, DB2 server and Flat Files placing it into PDS and EDW schemas.
• Created new mappings and updating old mappings according to changes in Business requirements.
• Performed major role in understanding the business requirements and designing and loading the data into data warehouse (ETL).
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
• Implemented performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency and performance.
• Helped in creating and updating Project Induction Pack for new hires.
• Involved in migrating mappings from Development Environment to Testing Environment.
• Ensure requirements have been analyzed sufficiently so that all implicit requirements have been documented.
• Preparing Analysis documents and Approach documents.
• Preparing UNIT test and SYSTEM test documents.
• Interacting with Project Leader and provide inputs on ETL design process and Report layout and designs.

Environment: Informatica power center7.x/8.1, Ms Excel, Windows NT/2000 Professional, Teradata, Confidential 9i, MS SQL Server 2000, Windows Server 2003, Unix.

Confidential

BI consultant

R esponsibilities:

• Created, designed, and implemented specifications and developed ETL processes to support the development and implementation of data warehouse projects using Informatica.
• Created Star Schema with slowly changing Dimension Type 1 and Type 2.
• Worked extensively with mappings using Expressions, Aggregators, Filters, Lookup, Joiner, Update Strategy, Sequence Generator, Sorter, Router to develop and feed ODS.
• Developed complex mappings using multiple sources and targets in different databases, flat files and XML files.
• Created pre- and post-load scripts to drop indexes and key constraints before session and rebuild those indexes and key constraints after the session completes.
• Independently created complete cycle of star schema development.
• Interacting with Project Leader and provide inputs on ETL design process and Report layout and designs

Environment: Informatica Power Center7.x/8.1.1, Teradata, Confidential 9/10gi, MS SQL Servers 2000, MS Access 2000, Windows 2003 Server/XP, UNIX, Sun Solaris.

Confidential

Software Engineer

Responsibilities:

• Created new mappings and updating old mappings according to changes in Business logic.
• Performed major role in understanding the business requirements and designing and loading the data into data warehouse (ETL).
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
• Implemented performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency and performance.
• Helped in creating and updating Project Induction Pack for new hires.
• Involved in migrating mappings from Development Environment to Testing Environment.
• Ensure requirements have been analyzed sufficiently so that all implicit requirements have been documented.
• Preparing Analysis documents and Approach documents.
• Preparing UNIT test and SYSTEM test documents.
• Interacting with Project Leader and provide inputs on ETL design process and Report layout and designs

Environment: Informatica power center7.1, Java, JavaScript, Confidential, Windows NT, HP Quality Center.