SUMMARY:

• Information Technology Data Warehouse Consultant with over Eleven (11) 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 SSIS.
• Expertise in using SAP Business Objects Data Services(BODS) 4.1/4.0 (Designer, Repository Manager, Server Manager, 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.
• 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 2012/2008/2005 , (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.
• Experience in writing SQL queries and stored procedure in Oracle and SQL Server databases.
• Experience in Data modeling using SAP Sybase Power Designer & ERWIN tools.
• Used DB tools like SQL Developer, Embarcadero and TOAD.
• Involved in ETL end to end implementation.
• Used Scheduling tools like Tivoli, Autosys & SAP Redwood (CPS).
• 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, 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 Reinsurance, 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, SSIS

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

Data Modeling: SAP Sybase Power Designer, ERwin

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

Languages: SQL, PL/SQL.

Scheduling Tools: Sap Redwood (CPS), Autosys, Control - M & Tivoli

Operating Systems: UNIX, Windows, MS-DOS.

PROFESSIONAL EXPERIENCE:

Confidential

Datawarehouse Architect

Responsibilities:

• s at CU during one week short gig
• Troubleshoot BODS 4.2 installation issues in DEV(which was already installed by BODS administrator before my short gig)
• Assisted the team with BODS 4.2 installation requirements and process.
• Provided recommendation document on Hardware Sizing and Architecture.
• Worked with DBA, Systems & NOC teams to resolve firewall, driver and RHL issues.
• Worked with various teams to setup user access levels, and server sizing.
• Installed in SAP BODS 4.2 in TEST environment.

Environment: SAP Business Objects Data Services (BODS) 4.2, Oracle 11g, RHL 6.6

Confidential

Datawarehouse Architect

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 sources, data Layout, Business needs, and naming conventions of the column and table names.
• Worked on Ralph Kimball methodology for Star and Snowflake Schemas, Fact and Dimensions tables, Physical and Logical Data Modeling.
• Coordinate with other teams to ensure availability of Source Data.
• Data Modeling
• Designed Logical, Physical models using ERwin.
• Designed views on top of the database for reporting needs.
• ETL
• Created source to target mapping documents, job dependency charts.
• Defined mapping rules for ETL.
• Defined Technical Design document.
• Involved in legacy historical data conversion from existing ODS & DW tables to new ODS & DW tables.
• 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.
• ETL Design (converting business functional specifications into mappings/workflows)and testing
• Involved in System integration testing along with other team members using various source data scenarios.
• Experienced in scheduling and monitoring of jobs using Control - M during pre-production phases.
• Involved in code enhancement, testing based on change request (CR) from end users.
• Experience in debugging execution errors and by examining the target data.

Environment: ERwin 9.5, SQL Server 2012, SSIS, Extract IS, SAP ECC 6.0, Control - M

Confidential

Datawarehouse Architect

Responsibilities:

• Provided recommendation document on Hardware Sizing and Architecture.
• Worked with various teams to setup user access levels, and server sizing.
• Data Modeling
• Worked closely with Data Modeler in implementing Datawarehouse data model.
• Business Objects Data Service
• Designed ETL framework & 40 Jobs as part of a report POC to enhance report performance.
• Defined best practices document.
• ETL Design & use of Complex ETL routines to extract data from ODS.
• Upgraded SAP BODS 4.1 to SAP BODS 4.2
• Created repositories, Job Server and managed users.
• Implemented Server groups to use advance performance tuning feature such as parallel data flow.

Environment: SAP Business Objects Data Services (BODS) 4.2/4.1, Oracle 11g, RHL 6.5

Confidential

Datawarehouse Architect

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 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.
• Worked on Ralph Kimball methodology for Star and Snowflake Schemas, Fact and Dimensions tables, Physical and Logical Data Modeling.
• Coordinate with other teams to ensure availability of Source Data.
• Data Modeling
• Designed Logical, Physical models using SAP Sybase Power Designer.
• Designed views on top of the database for reporting needs.
• Business Objects Data Service
• Designed ETL framework & jobs.
• Created source to target mapping documents, job dependency charts.
• Defined Technical Design document.
• Created Custom ABAP programs to pull CLOB data from ECC.
• 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.
• ETL Design (converting business functional specifications into mappings/workflows)and testing
• 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.
• Involved in writingDS scriptsand also used some built-in functions like Search, Replace, Lookup ext and Custom Functions for ETL audit process.
• Created Data Services mappings to load the data warehouse,the mappings involved extensive use of simple and complex transformations like SQL Query Transform, Table Comparison, Query, 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 SAP Redwood (CPS) during pre-production phases.
• 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.
• Enterprise wide Data Quality Dashboard
• Worked with various teams to setup user access levels, and server sizing.
• Guiding the development team right from requirement to deployment.
• Leading a Team of 6 in both Onsite/Offshore.
• Involved in ETL end to end implementation.

Environment: SAP Business Objects Data Services (BODS) 4.1/4.0, SAP Sybase Power Designer, SAP BW, SAP ECC 6.0, MS SQL server 2012

Confidential

Datawarehouse Architect

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.
• Worked on Ralph Kimball methodology for Star and Snowflake Schemas, Fact and Dimensions tables, Physical and Logical Data Modeling.
• 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
• 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.
• 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.
• 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.
• Involved in ETL end to end implementation.

Environment: SAP Business Objects Data Services (BODS) 4.0(Designer, Repository Manager, DS Management Console, CMC), MS SQL server 2008, Oracle 10g, SQL Developer

Confidential

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.
• Worked on Ralph Kimball methodology for Star and Snowflake Schemas, Fact and Dimensions tables, Physical and Logical Data Modeling.
• 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
• Involved in ETL end to end implementation.
• 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, TOAD, Cognos Framework Manager and Cognos Report Studio.

Confidential

Sr. Software Engineer

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
• 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(Designer, Repository Manager, DS Management Console), DB2 and UNIX.

Confidential

Sr. Software Engineer

Responsibilities:

• Re-designed the CMDR data model.
• Worked on Ralph Kimball methodology for Star and Snowflake Schemas, Fact and Dimensions tables, Physical and Logical Data Modeling.
• 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.
• Involved in ETL end to end implementation.

Environment: Informatica Power Center 8.1(Mapping Designer, Workflow Manager and Workflow Monitor), Oracle 10g, SQL, PL/SQL, TOAD, ERWIN, Autosys 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

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.