SUMMARY:

• Highly accomplished Data Warehouse Consultant with more than 10+ years of demonstrated experience designing and developing innovative, scalable solutions with significant expertise throughout the entire project lifecycle.
• Instrumental member of ETL Development team; designed end - to-end solutions for enterprise data warehouses and data marts. Developed data extracting, data cleansing, data conforming, and data delivering processes within the data warehouse.
• Experience in Requirement Analysis, System Analysis, Functional Analysis, Design, Development, implementation, Testing, Debugging, Productions Support, and Maintenance of various Data warehousing Applications.
• Working closely with BI Solutions Designer & BI Solutions Analyst experts to ensure translation of business/technical requirements result in detailed design resulting in the final solution.
• Design and Development experience in Data warehouse Modeling, both logical and physical models. Designed multi-dimensional models (Star, Snow Flake schema).
• Experience in integration of various data sources like Oracle, MS SQL Server, TERADATA, XML, flat files, DB2, SAP, sales force.com, Hadoop.
• Possess excellent communication and interpersonal skills with ability to work independently and as part of a team.

TECHNICAL SKILLS:

ETL Tools: Informatica 9,8.x/7.x, Ab Intio, SQLSERVER (SSIS)

Data Modeling Tools: Erwin 3.x/4.x, MS - Visio.

Databases: Oracle 10g/9i/8i, DB2, SQL Server 2000, Teradata

RDMS Load Tools: SQL *Loader (Oracle) OLAPBusiness Object XIR3, Crystal Reports, Oracle Suite, Cognos

Languages: SQL, PL/SQL, Perl, Shell Scripting

Operating System: Windows 9x/NT/2000/XP, Red Hat Linux, UNIX (Solaris, HP-UX, AIX).

Office Applications: MS-Office 97/2000/XP/2007, Open Office Suites.

Other Tools: Hadoop, sqoop, oozie, Autosys

PROFESSIONAL EXPERIENCE:

Confidential, Bellevue, WA

Principal BI Consultant

Responsibilities:

• Forecasting architecture needs and participating in architecture design planning.
• Analyze complex business needs presented by the user
• Designing, developing, and implementing data architecture, including overall ETL processes and architecture design.
• Performing source data analysis to develop ETL and/or data delivery solutions that meet business needs.
• Developing processes to integrate data received from various sources.
• Collaborates with technical and non-technical, internal resources to produce, and support, both analytic and transactional level reports for the internal and external clients.
• Loading data to Data warehouse using ETL tools.
• Performing data validation, analysis and modeling (Root Cause Analysis, Behavioral Analysis).

Environment: Informatica Powercenter9, Teradata, Oracle, Hadoop, UNIX, Business Objects 4.1, Tidal, Analysis

Confidential, Denver, CO

IT Senior Analyst

Responsibilities:

• Working closely with BI Solutions Designer & BI Solutions Analyst experts to ensure translation of business/technical requirements result in detailed design resulting in the final solution.
• Extracting data from various sources, transform data according to business rules and load to the target Enterprise Data Warehouse or data marts.
• Conducts analysis, scope and time estimation to develop and deliver data integration solutions.
• Designs, Develops and tests for extraction, transformation, and load (ETL) processes.
• Defining and captures metadata and rules associated with ETL processes.
• Participated in Proof Of Concept (POC) for Hadoop Implementation.
• Mentoring the junior developers.
• Understanding of both SQL and NoSQL technologies
• Participating (in rotation) for 24/7 on-call support.

Environment: Informatica Powercenter9, Teradata, Oracle, UNIX, OBIEE, Cognos, Autosys, Hadoop, No-sql DB

Confidential, New York, NY

Technical Lead

Responsibilities:

• Interacting with Busines users and Subject Matter Experts to understand the current ETL infrastructure and data integration process.
• Capture ETL specific Technical requirements and Requirements analysis for new enhancements.
• Involvement in the design & architecture related discussions for Application development.
• Define Extraction, Transformation and Load Strategies BI/ETL database design and schema.
• Created a ETL frame work for POC to provide better performance, restratability & reusability
• Participated in Proof of Concept (POC) for converting BODI Jobs in to Informatica.

Environment: Informatica Powercenter9, SQLSERVER (2008), Business Objects, BODI, Windows Server

Confidential, Denver, CO

Lead Operational Analytics Consultant

Responsibilities:

• Facilitating, managing, and drive enterprise-wide programs and projects through a structured, data-driven, fact based, disciplined process
• Developed Financial Models to assess quality based activities that result in strong ROI's
• Analyzing of current state and identify cost control measures, analyze company performance and advocate changes where necessary to meet corporate goals
• Present results to management, including data-driven business recommendations and alternatives
• Generating the weekly and daily Self Service Dashboards reports and submitting to the C-level Executives &Business Users.
• Lead various matrix groups across the company to identify and solve a wide variety of cross-functional issues related (IVR,STB,CSA WEB&DN.COM) to the improved performance
• Conduct/participate in presentations ongoing process improvement opportunities and initiatives in response to operational issues
• Create monitoring tools to assist in the identification of issues and areas for operational improvement of ETL process using (Informatica & SQLSERVER-SSIS) and BI Solutions using BO & Crystal
• Involved in the OLTP design which is needed for the OLAP. Completed multi-step,Complex ETL to gather online purchases from OLTP systems and then load to the data
• Communicating to all audience levels the results of the data in an understandable fashion

Environment: Informatica Power center 9, SQL SERVER (SSIS2008), Oracle, Suite, Business Objects, Oracle 10g, SQL Developer, Putty, UNIX, Perl

Confidential, West Paterson, NJ

Sr. Informatica Consultant

Responsibilities:

• Participated in Requirement Gathering, Business Analysis discussing the issues to be resolved and translating user inputs into ETL design documents.
• Analysis, Design and Development, testing and implementation of Informatica transformations and workflows for extracting the data from the multiple sources.
• Executed test cases and conducted User Acceptance Tests, Functionality Tests.
• Provided Informatica environment support, maintenance and break/fix or defect support, perform data and systems research and work on distributed delivery.
• Focused on ensuring that the supported applications are operational and that defects are listed on work tickets.
• Design and Development of pre-session, post-session routines and batch execution routines using Informatica Server to run Informatica sessions.
• Created and scheduled workflows using Workflow Manager to load the data into the Target Database.
• Created and scheduled various scripts through workflow for Informatica maintenace like backup script, update statistics script for Informatica repository, recycle script, removal of old logs script, autopurge scripts etc
• Captured data error records corrected and loaded into target system.
• Involved in identifying the bottlenecks and tuning to improve the Performance.

Environment: Informatica Power center 9, Oracle 10g, SQL Developer, Putty, Cognos, UNIX, Bash

Confidential, San Jose, CA

Informatica Consultant

Responsibilities:

• Involved in the complete lifecycle of the data warehouse creation starting form requirements gathering to putting the product into production and Automation.
• Performed business analysis and requirements per high end users and managers and performed requirement gathering.
• Involved in review and finalizing the technical specs of source-target mapping documents
• Extensively used Erwin 4.0 for Logical/Physical data modeling and Dimensional Data Modeling, and designed Star Schemas.
• Involved in the OLTP design which is needed for the OLAP. Completed multi-step, complex ETL to gather online purchases from OLTP systems and then load to the data warehouse, including a flat-file feed.
• Extracted data from several SQL Server databases to join offline sales transactions with the existing online data warehouse fact and dimension tables.
• Developed Sessions and deployed in the Informatica Server. Developed Mapplets using corresponding Source, Targets and Transformations.
• Cleanse the source data, Extract and Transform data with business rules, and built ‘Mapplets’ using Informatica Designer.
• Implemented type 2/ type3 dimensions. Extensively used Dynamic lookup to implement the type 2 changes.
• Involved in performance tuning Informatica mappings with Joiner, Aggregator, Sequence Generator, Union, Router, Filter transformations

Environment: Informatica Power center 8.6, Oracle 10g, Toad, Putty, Admin Console, UNIX, Erwin, SQL LOADER, OBIEE, SQLSERVER, TIDAL

Confidential, Berkeley, CA

ETL Consultant

Responsibilities:

• Analyzed and gathered end user Requirements.
• Involved in creating logical and physical data models using ERwin based on business requirements.
• Extensively used Informatica to load data from Oracle, flat files, files into the target Oracle 9i database.
• Informatica Administration - adding users, user privileges, creating roles, creating different folders, adding repositories, backup and restoring repositories.
• Various transformations like Joiner, Aggregator, Expression, Lookup, Filter, Update Strategy, Stored Procedures and Router were used to solve simple and complex business logic.
• Involved in migration of objects in all phases (DEV, QA and PRD) of project and trained developers to maintain system when in production.
• Providing architecture review for proposed projects and enhancements to aid the governance process in decision making
• Wrote PL/SQL stored procedures to fulfill the iterative process and to solve complex business logic.
• Created different target definitions using warehouse designer of Informatica PowerCenter and sources using Power Connect for Legacy systems.
• Experienced dealing with outsourced technical resources and coordinating global development efforts.
• Worked on different tasks in Workflows like sessions, events raise, event wait, e-mail and timer for scheduling of the workflow.
• Monitored the jobs on a daily basis and looked at the session logs to see if jobs completed successfully.

Environment: Informatica Power Exchange 8.1 Oracle9i, OBIEE, SQL, PL/SQL, SQL*Plus, Erwin, TOAD, SQL Developer

Confidential, San Jose, CA

BI Developer

Responsibilities:

• Worked with business analysts/ users in design of technical specification documents for data warehouse during multiple phases of the project
• Participated and provided input in business review meetings for approving logical and physical data models
• Extracted data from multiple sources (relational sources, flat files, XML files, VSAM, and COBOL files)
• Developed Informatica Standards document, naming conventions document, and mapping documents for all the subject areas with business logic from source to target
• Implemented SCD 1, SCD 2 techniques for handling history requirements
• Used Explain Plans, Indexes to improve SQL scripts performance
• Implemented performance tuning techniques at system, session, mapping, transformation, source and target levels
• Developed reusable maplets/ Worklets, which are used in workflows in other mappings
• Developed korn shell scripts to load data into the staging tables using PMCMD commands processing large amount of data (in millions of rows)
• Performed migration of jobs across Development, QA, Production environments
• Actively coordinated with testing team during Integration and Regression testing
• Planned, coordinated and executed reports in Crystal Reports 2.x for report users

Environment: Informatica Power Center Crystal Reports, UNIX, ORACLE

Confidential

Database Developer

Responsibilities:

• Extensively used ERwin for Data modeling and Dimensional Data Modeling.
• Coordinating with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.
• Worked on Informatica Power Center - Source Analyzer, Data warehousing designer, Mapping Designer & Mapplets, and Transformations
• Extracted data from multiple sources, which include relational sources, flat files and XML files.
• Developed Mappings and Workflows using Informatica Power Mart
• Various kinds of the transformations were used to implement simple and complex business logic. Transformations used are: Procedure, connected & unconnected lookups, Router, Expressions, source qualifier, aggregators, filters, sequence Generator, etc.
• Designed and Implemented plan for all types of data movement requested and approved by management.
• Executed sessions, both sequential and concurrent for efficient execution of mappings and used other tasks like event wait, event raise, email, command and pre/post SQL
• Tested reports created in Business Object using Web intelligence and Infoview
• Configured each step in the ETL process and can write programs with scripts, packages, mappings.
• Scheduling and Monitoring Workflows, Worklets and tasks using Workflow Monitor.
• Developed Unit test mappings with the test data.

Environment: Informatica power Center7.1, Oracle8i, PL/SQL, SQL*Plus, UNIX, Windows 2000.