SUMMARY

• Information Technology Data Warehouse Consultant with over Nine (9) years of experience and broad based technical knowledge and in - depth understanding of system/software engineering lifecycle phases.
• Experienced in Gathering & Analysis of requirements, implementation, testing and developing ETL solutions for leading clients.
• Interfacing with clients for business requirement gathering, conducting system analysis and finalizing technical / functional specifications.
• Designing, developing, testing, troubleshooting and debugging of the applications.
• ETL experience in using SAP BODS, Cognos Data Manager, Informatica, and SQL Server DTS.
• Expertise in using SAP Business Objects Data Services(BODS) 4.0/3.1 (Designer, Repository Manager, Server Manager, Metadata Reports, Configuring / Controlling Job Server and Web Admin)
• Extensively used stored procedures for Data Cleansing and Data Profiling.
• Have good hands on experience in ETL and Data Cleansing applications using Informatica Power Center, Data services, and PL/SQL.
• Hands on in using Information Steward for Advance Data Quality.
• Providing post-implementation, application maintenance and enhancement support to the client with regard to the product / software application.
• Performed Pre Migration Assessment, Migration & Post Migration.
• Good understanding in Ralph Kimball methodology for Star and Snowflake Schemas, Fact and Dimensions tables, Physical and Logical Data Modeling.
• Proficient in Oracle 11g/10g/9i/8i/8.0/7.x, MS SQL Server 2008/2005/2000 , (database triggers, materialized views, Packages, stored procedures, functions, and database constraints), SQL Loader, SQL*Plus, SQL Navigator, PL/SQL and oracle DBMS Packages, oracle supplied utilities
• Working knowledge with Data modeling tools like ERWIN.
• Used DB tools like SQL Developer and TOAD.
• Used Scheduling tools like Tivoli.
• Developed Test strategies to verify the ETL work flows, Data flows and transform logic based on Extraction and Loading.
• Strong experience in carrying Functional, Integration, Latency, Performance, reliability testing.
• Ability to analyze existing systems, conceptualize and design new ones, and deploying innovative solutions with high standards of quality.
• Strong analytical skills and in depth experience in Business Process analysis coupled with documentation and self-organizing skills.
• Domain expertise of working for Insurance, Telecom, Manufacturing & Banking/Finance industry.
• Lead a Team of 10 people in both Onsite/Offshore.
• Cooperating & communicating with other team members for efficient project work.
• Effective in communicating complex technical information to both top-level management and end-users. Flexible and resourceful, applying strong organizational, time-management and planning skills to deliver projects on time/budget, in pressure and aggressive timelines.
• Excellent Project Management skills.
• Strong communication and interpersonal skills. Experienced effective team leader as well as team player.

TECHNICAL SKILLS

ETL Tools: SAP Business Objects Data Services, 4.1/4.0/3.2, Cognos Data Manager 10.2/10/8.4.1 , Informatica 8.1, SQL Server DTS

OLAP/BI: Cognos Report Studio 10.2/10/8.4.1 .

Data Modeling: ERwin

Databases: Oracle 11g/10g/9i/8i/8.0/7.x, SQL Server 2008/2005/2000 , DB2

Languages: SQL, PL/SQL.

Operating Systems: UNIX, Windows, MS-DOS.

PROFESSIONAL EXPERIENCE

Confidential, Grand Rapids, MI

Sr. Technical Consultant

Responsibilities:

• Gathering Requirement and Analysis on the requirement.
• Provide Recommendation on Hardware Sizing and Architecture
• Interacting with Client, Managers, SME's, BA and Database team.
• Extensively in meetings and interviewing Business and Power users, to determine the flat file layouts, sources, data Layout, Business needs, and naming conventions of the column and table names.
• Performed complex troubleshooting, root cause analysis, solution development and implement reporting systems to address the issue.
• Coordinate with other teams to ensure availability of Source Data.
• Business Objects Data Service
• Configuration of BODS, Repository creation and server management
• Central Repository configuration and best practices for version control
• Data Profile Management
• Created custom Data Quality packages & rules using SAP Information Steward.
• Scheduling the jobs and User Management in Management Console
• ETL Design & use of Complex ETL routines to extract data from ODS (converting business functional specifications into mappings/workflows).
• Liaise with Business users and Business Analysts regarding requirements.
• Developed Source to Target Mapping as per the requirements.
• ETL Design (converting business functional specifications into mappings/workflows)and testing
• Exported and Data Integrator jobs to different repositories for backup and code migration purposes.
• Tuned performance for large data files byincreasing block size, cache size and implemented performance tuning logic on sources, workflows, and data flows.
• Performance tuning using Recovery mechanisms
• Implemented Server groups to use advance performance tuning feature such as parallel data flow, dividing dataflow in to sub dataflow and Degree of Parallelism.
• Involved in writingDS scriptsand also used some built-in functions like Search, Replace, Lookup ext and Custom Functions like Sending Email whenever an exception is raised.
• Created Data Services mappings to load the data warehouse,the mappings involved extensive use of simple and complex transformations like Key Generator, SQL Query Transform, Table Comparison, Case, Validation, Merge, lookup etc. in Data flows.
• Involved in System integration testing along with other team members using various source data scenarios.
• Experienced in scheduling and monitoring of jobs using DI management console during pre-production phases.
• Developed Data Integrator jobs as per requirement.
• Worked on Creating Repository and associating the Job server to it.
• Involved in code enhancement, testing based on change request (CR) from end users.
• Experience in debugging execution errors usingData Services logs (trace, statistics and error) and by examining the target data.
• Experienced in scheduling and monitoring of jobs using DI management console during pre-production phases.
• Enterprise wide Data Quality Dashboard
• Guiding the development team right from requirement to deployment.
• Leading a Team of 10 in both Onsite/Offshore.
• Handling Project Management for different assignments.

Environment: SAP Business Objects Data Services (BODS) 4.0, SAP Information Steward 4.0, SAP, MS Sql server 2008, Oracle 10g

Confidential, Grand Rapids, MI

Sr. Technical Consultant

Responsibilities:

• Gathering Requirement from Business, Working closely with Business Leaders to understand the requirement.
• Analysis on the requirements
• Setting up Dev, UAT and Production Environment.
• Interacting with Client, Managers, SME's, BA and Database team.
• Coordinate with other teams to ensure availability of Source Data.
• Timely response to customer requests.
• No customer complaints on delivery or quality of deliverables.
• The development of feeds with ease according to the functional specification document.
• Completeness of deliverables without any rework.
• Involved in performance tuning.
• Unit testing and UAT Testing
• UAT cycle support on every major release.
• Deploying into production and upgrading the production environment.
• Defining the new process for the application
• Setting up the new security rules and regulations for User and Developers
• Creating complex workflows, promoting the code from one environment to another environment.
• Deploying the code in Production.
• Taking care of PRD issues and release issues
• Giving the Estimates for the Implementation.
• Business Objects Data Service
• Configuration of BODS, Repository creation and server management
• Central Repository configuration and best practices for version control
• Data Profile Management
• Created custom Data Quality packages & rules using SAP Information Steward.
• Scheduling the jobs and User Management in Management Console
• ETL Design & use of Complex ETL routines to extract data from ODS (converting business functional specifications into mappings/workflows).
• Liaise with Business users and Business Analysts regarding requirements.
• Developed Source to Target Mapping as per the requirements.
• ETL Design (converting business functional specifications into mappings/workflows)and testing
• Exported and Data Integrator jobs to different repositories for backup and code migration purposes.
• Tuned performance for large data files byincreasing block size, cache size and implemented performance tuning logic on sources, workflows, and data flows.
• Performance tuning using Recovery mechanisms
• Implemented Server groups to use advance performance tuning feature such as parallel data flow, dividing dataflow in to sub dataflow and Degree of Parallelism.
• Involved in writingDS scriptsand also used some built-in functions like Search, Replace, Lookup ext and Custom Functions like Sending Email whenever an exception is raised.
• Created Data Services mappings to load the data warehouse,the mappings involved extensive use of simple and complex transformations like Key Generator, SQL Query Transform, Table Comparison, Case, Validation, Merge, lookup etc. in Data flows.
• Involved in System integration testing along with other team members using various source data scenarios.
• Experienced in scheduling and monitoring of jobs using DI management console during pre-production phases.
• Developed Data Integrator jobs as per requirement.
• Worked on Creating Repository and associating the Job server to it.
• Involved in code enhancement, testing based on change request (CR) from end users.
• Experience in debugging execution errors usingData Services logs (trace, statistics and error) and by examining the target data.
• Experienced in scheduling and monitoring of jobs using DI management console during pre-production phases.
• Enterprise wide Data Quality Dashboard
• Guiding the development team right from requirement to deployment.
• Leading a Team of 10 in both Onsite/Offshore.
• Handling Project Management for different assignments.

Environment: SAP Business Objects Data Services (BODS) 4.0. SAP Information Steward 4.0, MS Sql server 2008, Oracle 10g

Confidential, Grand Rapids, MI

Sr. Technical Consultant

Responsibilities:

• Gathering Requirement from Business, Working closely with Business Leaders to understand the requirement.
• Analysis on the requirements
• Setting up Dev, UAT and Production Environment.
• Provide Recommendation on Hardware Sizing and Architecture.
• Interacting with Client, Managers, SME's, BA and Database team.
• Extensively in meetings and interviewing Business and Power users, to determine the flat file layouts, sources, data Layout, Business needs, and naming conventions of the column and table names.
• Coordinate with other teams to ensure availability of Source Data.
• Timely response to customer requests.
• No customer complaints on delivery or quality of deliverables.
• The development of feeds with ease according to the functional specification document.
• Completeness of deliverables without any rework.
• Involved in performance tuning.
• Unit testing and UAT Testing
• UAT cycle support on every major release.
• Deploying into production and upgrading the production environment.
• Defining the new process for the application
• Setting up the new security rules and regulations for User and Developers
• Creating complex workflows, promoting the code from one environment to another environment.
• Deploying the code in Production.
• Taking care of PRD issues and release issues
• Giving the Estimates for the Implementation.
• Cognos Data Manager
• Created Job Streams, Fact and Dimension Builds, Look ups, user defined functions.
• Used SQL wherever necessary, inside and outside the mappings.
• Created simple cognos report studio reports as part of Console free solution.
• Created Cognos Framework Manager Model using stored procedures.
• Guiding the development team right from requirement to deployment.
• Leading a Team of 7 in both Onsite/Offshore.
• Handling Project Management for different assignments
• Upgraded the ConsoleFree Solution developed in Cognos Data Manager 8.4 to Cognos Data Manager 10.0, 10.1.1 & 10.2.
• Certified the solution free solution on oracle 9i, 10g, 11g versions.

Environment: IBM Cognos 8.4 Data manager 10.2/10.1.1/10.0/8.4 , MS Sql server 2008, Oracle 10g and Cognos BI

Confidential, Charlotte, NC

Sr. ETL Consultant

Responsibilities:

• Analyzing the existing mainframe job process.
• Analyze and Review, functional requirements captured into Data Migration Functional Specifications.
• Designing the HLL & LLD for each process.
• Preparing the High Level Column & Detailed Column Mapping Documents.
• Interprets business rules and requirements captured in Data Migration Functional Specifications.
• Interaction with technical team to explain the functional requirements and converts them into technical.
• Define the process for review and delivery of data migration documents.
• Handling MOCK run and Dress rehearsals.
• BODS installation
• Reviewing the BODS code for data migration.
• Identifying the business rule from Data Owners and Implementing in BODS.
• Creating Technical and Business reconciliation reports to support the Migration.
• Identifying the custom requirement for the data elements missing and designing the solution.
• Analyzing Legacy system.
• Understanding BODS standard content and assisting the usage of the standard content.
• Post Load Data Validations.
• Test case Preparation and reviewing with business team
• Training Data Owners and Business users
• Preparing Data Profiling reports
• Responsible for code migration to various environments
• Design/Develop/Review of BODS ETL code.
• Created Data Dictionary & Ref Data.
• Data Profile Management.
• Creating views for crystal reports.
• Scheduling of BODS ETL Jobs
• Design/Develop/Review of Data Quality Jobs using BODS as ETL
• Creating PL/SQL procedures and functions.
• Working with Oracle Text/CAT search indexes.
• Performance Tuning.
• Creating a reporting engine which involved developing materialized views and UNIX scripts for Enterprise Reporting Model.
• Creating summarized dashboards using Oracle OLAP for analytical reporting.
• Version control through SVN

Environment: SAP Business Objects Data Services (BODS) 3.2, DB2 and UNIX.

Confidential, Charlotte, NC

Sr. ETL Consultant

Responsibilities:

• Re-designed the CMDR data model.
• Designed the Security data model for CMDR application.
• Prepared CRUD Matrix.
• Preparing the High Level Column & Detailed Column Mapping Documents.
• Analyzed the specifications and identifying the source data that needs to be moved to the data warehouse.
• Responsibilities included designing and developingmappings.
• Extracted, transformed and load data from different source (Flat Files and Oracle) to Oracle 10g.
• Developed various Mappings with multiple Sources, Targets, and Transformations using Informatica 8.1.
• Used heterogeneous files from Oracle, Flat Files as source.
• Designed lookup transformations to perform lookups on related data.
• Extensively worked on all the transformations like Filter, Aggregator, Expression, Router, Lookup, Update Strategy, Sequence generator, Rank.
• Worked on troubleshooting the Mappings and improving Performance.
• Created Packages and Procedure for CMDR application.
• Used SQL wherever necessary, inside and outside the mappings.
• Created Materialized Views for reporting.

Environment: Informatica 8.1, Oracle 10g, SQL, PL/SQL, TOAD and UNIX.

Confidential

Sr. Software Engineer

Responsibilities:

• Analyzing the current Legacy databases.
• Identifying the databases and schemas to be replaced in Phase 1.
• Identifying the tables in each database from where data needs to be migrated.
• Documenting Business rules for each Legacy applications
• Creating Data Dictionary & Ref Data.
• Identifying the Source and Target Entities both in Legacy System and Siebel.
• Prepared CRUD Matrix.
• Preparing the High Level Column & Detailed Column Mapping Documents.
• Created Packages and Procedure for automation of Data Profiling & ETL Development.

Environment: SQL, PL/SQL, Oracle 10g, TOAD and Windows NT.

Confidential

Sr. Software Engineer

Responsibilities:

• Re-Created some of the existing Job Stream for better performance.
• Migration of database.
• Extraction of data from source systems present at different physical locations both for historical load and ongoing processes.
• Cleansing, Transformation and Application of business rules on the extracted data.
• Loading the transformed data into the data warehouse.
• Perform aggregations and calculations of the data warehouse data.
• Created Views for Generating reports.
• As a support person I used to run the all job streams both manually and monitoring the scheduled jobs on Tivoli.
• Fix the issues on a daily basis.
• Handled enhancement work.

Environment: Cognos 8 BI Data Manager, SQL Server DTS, SQL Server 2000, Tivoli, and Windows NT.

Confidential, CA

Software Engineer

Responsibilities:

• Responsibilities included designing and developingmappings.
• Extracted, transformed and load data from different source databases (AS400 and SQL server) to Oracle data warehouse.
• Developed various Mappings with multiple Sources, Targets, and Transformations using Data Manager.
• Designed lookup transformations to perform lookups on related data.
• Used SQL wherever necessary, inside and outside the mappings.
• Created and run Fact Builds and Job Streams.
• Created Materialized Views for reports generation.

Environment: Cognos 8 BI Data Manager, Oracle 10g, SQL Developer, TOAD, Windows NT.