SUMMARY:

• Having 10+ years of total IT experience in Data Warehousing domain with the functional knowledge on ETL & BI concepts
• Having 6 years of experience in Data stage in both server and parallel edition including Analysis, Design, Development, Implementation and Testing
• Having 2 years of experience in Microsoft SQL Server 2005 Suite (SSIS, MSAS, MSRS) which includes KPI identification, Requirements gathering, Analysis, Design, Data Modelling, Development of ETL packages, OLAP Cubes, Report generation, Dashboards, Implementation, Testing
• Knowledge in writing SQL queries, Oracle PL/SQL scripts involving procedures, triggers, cursors
• Worked on other BI tools like Cognos, Hyperion and Business Objects
• Exposure in other ETL Tools like Informatica and Data modeling
• Exposure to some of the open source tools like Pentaho, Jaspersoft and an idea on Qlikview
• Experience in requirement analysis, system design, implementation and complete life cycle of a data - warehousing project
• Implemented Best Practices in DWH projects, Data stage tool and provided ideas to improvise the project execution
• Provided trainings to the new employees on DWH concepts and the ETL/BI tools
• Involved in creating proposals and ready build DWH solutions to suit for any manufacturing industry
• Worked for Retail, Banking and Manufacturing domain

TECHNICAL SKILLS:

ETL Tools: Data stage 7.5, 8 & 9.1, SSIS 2005 & 2008, Informatica 6.2 & 8

BI Tools: Business Objects, MSRS/MSAS 2005 & 2008, Cognos 7.2 & 8, Hyperion System 9

Database development tools: SQL Server 2005 & 2008, Oracle 9i & 10g, MS-Access, Teradata, DB2

Operating Systems: Windows NT/98/ 2000/ XP, UNIX

Open Source & Other Tools: MY SQL, Pentaho, Jaspersoft, BIRT, Qlikview

Languages: SQL, PL/SQL, JAVA, C, C++, ASP.Net, VB.Net

Application Development tools: TOAD, SQL*Loader, Putty

Web Technologies: HTML, XML

PROFESSIONAL EXPERIENCE

Confidential

Project Leader & SME

Environment: Unix, Oracle 10g, XML, Datastage 9.1

Responsibilities:

• Involved in preparing the design approach of the module Operational Reconciliation
• Interaction with the Business architects and the analysts on the issues identified
• Involved in the overall project plan and the migration approach
• Involved in the preparation of the high level design documents and mappings specifications
• Designed a reusable component using RCP and schema methodology to ease the design of Operational Reconciliation
• Participated in the review process and prepared the test plan

Confidential

Role: Project Leader

Environment: Unix, Oracle10g, XML, Datastage 9.1

Responsibilities:

• Involved in the preparation of the design document and guiding the developers on the build approach
• Reviewing of build test cases and the code
• Involved in the requirements gathering and preparation of Mid-level Platform Design
• Interacted with the Business analysts and the third party stakeholders on analyzing the issues. Performed Gap analysis on the source extract XML file.
• Involved in giving walkthrough of the design to the review panel
• Involved in the implementation approach

Confidential

Project Leader

Environment: Unix, Oracle 9i, Teradata, Datastage 9.1

Responsibilities:

• Interacted with the customer on the mapping requirements
• Involved in preparing the high level design documents
• Provided support on a timely basis on defects and technical support to the team
• Involved in design walkthrough, reviews and knowledge sharing to the team & mentoring
• Created reusable components to improvise the design & coding techniques and reduce the defects
• Incorporated performance tuning methods to increase the jobs performance
• Created best practices for the developers to build efficient jobs
• Had an experience of working as an SME in the portfolio

Confidential

Project Leader

Environment: Unix-AIX, Datastage 9.1

Responsibilities:

• Provide guidance and mentorship to ETL developers
• Prepare design documents
• Review Data stage jobs and test cases

Confidential

Project Leader

Environment: Unix-AIX, Cognos 8, DB2

Responsibilities:

• Capturing the business requirement and modeling the database design.
• Designed the loading strategy of the dimension and fact tables.
• Involved in providing technical guidance to the team
• Involved in Performance tuning and troubleshooting
• Formulated the migration and the test plan
• Involved in reconciling the cognos reports against SAP BW queries

Confidential

Project Leader

Environment: Datastage V8.0.1, Oracle 10g

Responsibilities:

• Understood the business requirement and designed the mapping documents for Star Schema
• Designed and loaded the interim tables for cards, authorization, star schemas using data stage jobs
• Used stages like SCD, Remove Duplicates and many more
• Created SQL scripts for star schema tables and DB sequences
• Inserted data into one time dimension tables through oracle PL/SQL statements
• Prepared test plans and tested the jobs through sql queries

Confidential

Project Leader

Environment: MS SQL Server 2005 suite, QlikView

Responsibilities:

• Understood the business requirement and identified the metrics with lead indicators
• Prepared SRS, HLD, DLD, functional architecture, technical and report specifications
• Designed the Dimension Model and created the dimension modeling schema which involves multiple facts
• Interacting with the business team and did project monitoring and technical support
• Created prediction analyis
• Involved in showing demos

Confidential

ETL Developer

Environment: Datastage 7.5, Oracle 10g, Teradata, SQL Server 2000

Responsibilities:

• Identified the Datastage jobs in all the projects which uses SQL Server and Teradata
• Prepared standard checklists and designed the shell jobs with design specifications for the ETL jobs
• Modified the jobs with Teradata and SQL Server to Oracle and Bteq, MLOAD scripts in Teradata to Oracle
• Used PL/SQL stored procedures to migrate data from Teradata to oracle for one-time dimensions and created partitions for the different lines of business
• Involved in testing the jobs and assisting the quality team in resolving the issues
• Used SQL scripts to test the data loaded in the tables as per the mapping logic

Confidential,

ETL Developer

Environment: Datastage 7.5, Oracle 10g

Responsibilities:

• Identifying the limitations of the proposed approach of Sales Analytics and suggesting the inbound and the outbound processing logic to create a better approach
• Created the inbound processing logic document and conducted walk through to the team and devised ETL development approach pulling data from FTP to staging & capturing deltas and developed the jobs for the same
• Partitions were created on the oracle tables based on the lines of business
• Created a stored procedure for swapping the data in the partitions and developed ETL jobs needed for extracting data from FTP source, load the data to staging by capturing deltas
• Used CRC technique for capturing the deltas and automated ETL jobs to load daily data feeds coming in from various business units and unit testing was done and conducted the pilot work of automated daily feed
• Worked on profiling the data available from various business units and interacted with the offshore QA team to resolve the issues

Confidential

ETL Developer

Environment: Datastage 7.5, Oracle 10g, SQL Server 2000, Teradata

Responsibilities:

• Business requirement understanding and analysis which involves the high level DW architecture, gap analysis and business data flow and error handling
• Designed DFD, SDD, source to target mapping document and conducted design walkthrough to the team
• SQL scripts were used to create the dimension tables
• Developed the ETL jobs to load the staging area for the extracts from various business units and create the Enterprise data mart from staging
• Interacted with the offshore QA team to resolve the issues and in profiling of data

Confidential

ETL Developer

Environment: Datastage 7.5, Teradata, Sql Server 2000

Responsibilities:

• Understood the business process and the Project overview
• Designed the SDD for Sales Code and developed the jobs for the same
• Unit testing of the developed ETL jobs, Code walkthrough of the developed jobs
• Designed a job to fix the item group rejections by creating custom transforms
• Worked with the QA team to review the test cases and resolve the issues

Confidential

ETL/BI Developer

Environment: Microsoft SQL Server 2005, SSIS 2005, Cognos 7.2

Responsibilities:

• Gathering the requirements about their ERP, database structures, head office & branch details, product hierarchy and the customer relationships
• Prepared design specifications and developed the jobs to extract the data, cleaning and transforming it. Aggregator, data conversion, script component, conditional split, slowly changing dimension were used.
• Reports which include list, cross tab, drill thru, hierarchies, prompts were developed
• Scheduling the jobs using SQL Server Agent at the production environment.
• Test the data loaded in the tables using SQL queries, sub queries

Confidential

ETL/BI Developer

Environment: Datastage 7.5, Hyperion System 9, Oracle 9i

Responsibilities:

• Identifying the KPI’s of certain functional units in the manufacturing domain.
• Participate in designing the dimensional models for the functional units like sales, production, inventory and finance
• Developing jobs to extract the parts, assemblies and the work order details and queries were used to test the data
• Used surrogate key generator, aggregator, look up, transformer stages
• Reports were developed to show the part summary, assembly wise orders placed and the work order wise summary with prompts, pivots and charts

Confidential

ETL/BI Developer

Environment: Microsoft SQL Server 2005, SSIS 2005, MSAS / MSRS 2005

Responsibilities:

• Design the dimensional model to meet the gathered requirements
• Identify the source systems that include OLEDB, Excel and used transformations involving Merge Join, Sort, Derived Column, Slowly Changing Dimension etc.
• Developed truncate and load strategy for tables in the staging area for incremental data load and Scheduled the packages using windows batch scripts
• Developed the required cubes using analysis services and built the hierarchies in the cube dimensions. Configurations were implemented on the cube
• Design and develop the required reports which includes prompts, filters, hierarchies, highlighters for alerting the user and configurations in the report manager for web based access
• Develop test cases to test the developed artifacts to meet the business specifications