SUMMARY:

• Have a total experience of more than 19 years in the IT industry. Involved in plan, design and implementation and testing of enterprise applications.
• Have experience of more than 16 years in design and development of data warehousing and business intelligence systems. Strong ability to understand business requirements and convert to IT deliverables.
• Key strengths include RDBMS, ETL, Data Modeling, Data Analysis, Star and Snowflake Schemas, GUI, Business Objects, Multi Dimensional OLAP and Web enabled OLAP

TECHNICAL SKILLS:

Operating Systems: HP - UNIX, Tru64 UNIX, Windows 2000, Windows XP, VISTA.

Databases: Oracle 10g/9i/8i, SQL Server 2008/2005, SSAS

ETL Tools: Informatica, Data Stage, Oracle Warehouse Builder, DTS, SSIS, SQL Loader

Languages: SQL, PL/SQL, T-SQL, C++, C, C#

GUI Tools: Visual Basic, Visual C#.Net

Reporting Tools: Business Objects XI R3/R2, Crystal Reports XI R3/R2, SSRS, SAS, OBIEE

Internet Tools: ASP.Net, JavaScript, XML, XSL, HTML, DHTML, CSS, AJAX

Modeling Tools: Erwin, Visio, ER Studio

Project Management: Rational Clearcase, Rational Rose

PROFESSIONAL EXPERIENCE:

Confidential, Arlington, VA

Sr. Consultant

Environment: Oracle 11g, SQL Server, SQL, PL/SQL

Responsibilities:

• Analyze source systems and business requirements and create functional and technical design documents.
• Implement data quality and data quality metrics solutions for financial data based Operational data sources
• Conducted data modeling, data analysis and designed Star and Snowflake schema design.
• Conduct database schema design sessions with the project architecture and development resources.
• Plan, design, and implement operational data store (ODS), data warehouses and data marts including capacity planning, dimensional data modeling, data analysis, schema design, batch and real-time load processes.
• Define Source to target mapping and implement, and maintain ETL mappings, processflow using SQL Server Integration Services (SSIS) and Oracle Warehouse Builder (OWB)
• Design, implement and maintain analysis, reports and dashboards using SQL Server Reporting Services (SSRS)
• Optimize the SQL to improve the query performance.

Confidential, San Ramon, CA

Sr. Consultant

Environment: Oracle 11g, SQL, PL/SQL

Responsibilities:

• Analyze source systems and business requirements and create functional and technical design documents.
• Implement data quality and data quality metrics solutions for financial data based Operational data sources
• Conducted data modeling, data analysis and designed Star and Snowflake schema design.
• Conduct database schema design sessions with the project architecture and development resources.
• Plan, design, and implement operational data store (ODS), data warehouses and data marts including capacity planning, dimensional data modeling, data analysis, schema design, batch and real-time load processes.
• Define Source to target mapping and implement, and maintain ETL mappings, mapplets, and workflow using Informatica Powercenter. Informatica Data Quality
• Design the OBIEE Repository (RPD) for Physical layer, BMM layer and Presentation layer using OBIEE Administrator tool.
• Enable user and row level security using OBIEE Administrator tool.
• Design, implement and maintain analysis, reports and dashboards using OBIEE.
• Optimize the SQL to improve the query performance.

Confidential, San Francisco Bay Area

Sr.Consultant Data Quality Solutions

Environment: Oracle 11g, SQL

Responsibilities:

• Analyze source systems and business requirements and create functional and technical design documents.
• Implement data quality and data quality metrics solutions for financial data based Operational data sources
• Conducted data modeling, data analysis and designed Star and Snowflake schema design.
• Conduct database schema design sessions with the project architecture and development resources.
• Plan, design, and implement operational data store (ODS),data warehouses and data marts including capacity planning, dimensional data modeling, data analysis, schema design, batch and real-time load processes.
• Define Source to target mapping and implement, and maintain ETL mappings, mapplets, workflow using Informatica Powercenter. Informatica Data Quality

Confidential, Washington, DC

Sr. Data Warehouse Consultant

Environment: Oracle 11g, SQL, PL/SQL

Responsibilities:

• Analyze source systems and business requirements and create functional and technical design documents.
• Developed and enforced the Data Warehouse methodology - integrated data marts using Kimball methodology.
• Ensured that the Data warehouse contains cleaned, integrated data so that it serves as the ‘single source of truth’ for all reporting and other downstream consumption.
• Conducted data modeling, data analysis and designed Star and Snowflake schema design.
• Conduct database schema design sessions with the project architecture and development resources.
• Designed the aggregation and refresh strategy of the data warehouse.
• Plan, design, and implement operational data store (ODS),data warehouses and data marts including capacity planning, dimensional data modeling, data analysis, schema design, batch and real-time load processes.
• Define Source to target mapping and implement, and maintain ETL mappings, mapplets, workflow using Informatica Powercenter

Confidential, Centreville, VA

Sr. Data Warehouse Consultant

Environment: Oracle 11g, SQL, PL/SQL

Responsibilities:

• Analyze source systems and business requirements and create functional and technical design documents.
• Developed and enforced the Data Warehouse methodology - integrated data marts using Kimball methodology.
• Ensured that the Data warehouse contains cleaned, integrated data so that it serves as the ‘single source of truth’ for all reporting and other downstream consumption.
• Conducted data modeling, data analysis and designed Star and Snowflake schema design.
• Conduct database schema design sessions with the project architecture and development resources.
• Designed the aggregation and refresh strategy of the data warehouse.
• Plan, design, and implement operational data store (ODS), data warehouses and data marts including capacity planning, dimensional data modeling, data analysis, schema design, batch and real-time load processes.
• Design and implement the Master Data Management (Informatica MDM, IDQ) and Meta Data Management systems as part of the Enterprise Data warehouse.
• Define, implement, and maintain ETL mappings, mapplets, workflow using Informatica Powercenter and IDQ, PL/SQL and schedules using Ctrl M to ensure the accuracy and timeliness of data in various data marts.
• Participate in database schema design sessions with the project architecture and development resources.
• Plan, design, Implement and maintain reporting applications using Cognos
• Optimize the SQL to improve the query performance.

Confidential, McLean, VA

Sr. Data Modeler / Business Intelligence Architect

Environment: Oracle 10g, SQL, PL/SQL

Responsibilities:

• Analyze source systems and business requirements and create functional and technical design documents.
• Developed and enforced the Data Warehouse methodology - integrated data marts using Kimball methodology.
• Created the logical and physical database design using Erwin data modeling tool
• Designed the strategy to integrate data from disparate systems to create a reconciled data layer.
• Conducted data modeling, data analysis and designed Star and Snowflake schema design.
• Conduct database schema design sessions with the project architecture and development resources.
• Designed the aggregation and refresh strategy of the data warehouse.
• Plan, design, and implement operational data store (ODS),data warehouses and data marts including capacity planning, data modeling, data analysis, schema design, batch and real-time load processes.
• Define, implement, and maintain ETL procedures using SAS,PL/SQL and schedules to ensure the accuracy and timeliness of data in various data marts.
• Participate in database schema design sessions with the project architecture and development resources.
• Design the OBIEE Repository (RPD) for Physical layer, BMM layer and Presentation layer using OBIEE Administrator tool.
• Enable user and row level security using OBIEE Administrator tool.
• Design, implement and maintain analysis, reports and dashboards using OBIEE.
• Optimize the SQL to improve the query performance.

Confidential, Reston, VA

Senior Datawarehouse Consultant

Environment: SQL Server 2005, Oracle 10g, SQL, PL/SQL

Responsibilities:

• Analyze source systems and business requirements and create functional and technical design documents.
• Conduct design sessions and brain-storming sessions to design optimal data models beginning with logical data models for the star schemas culminating in physical data models.
• Functioned as the owner of the data models to maintain, and update them as required.
• Plan, design, and implement operational data store (ODS),data warehouses and data marts including capacity planning, data modeling, data analysis, schema design, batch and real-time load processes.
• Define, implement, and maintain ETL procedures using SSIS, PL/SQL and schedule to ensure the accuracy and timeliness of data in various data marts.
• Participate in database schema design sessions with the project architecture and development resources.
• Plan, design, Implement and maintain reporting applications using OBIEE
• Optimize the SQL to improve the query performance.
• Design the OBIEE Repository (RPD) for Physical layer, BMM layer and Presentation layer using OBIEE Administrator tool.
• Enable user and row level security using OBIEE Administrator tool.
• Design, implement and maintain analysis, reports and dashboards using OBIEE.
• Leading and mentoring team of 7 developers located in offshore development Centre, India.

Confidential, Washington D.C

Senior Data warehouse Engineer

Environment: Oracle 10g/9i, SQL, PL/SQL, SQL Loader

Responsibilities:

• Analyze source systems and business requirements and create functional and technical design documents.
• Developed the logical and physical data models using Erwin.
• Developed dimensional Star Schemas to enable optimal reporting from the data warehouse.
• Designed the data models for the staging area as well as the target system (Facts and Dimensions).
• Performed walk through of the data models with the stakeholders to confirm business requirements.
• Define, implement, and maintain ETL procedures using Kalido, PL/SQL and schedules to ensure the accuracy and timeliness of data in the data warehouse and various data marts.
• Participate in database schema design sessions with the project architecture and development resources.
• Plan, design, Implement and maintain reporting applications using Business Objects XI R3
• Optimize the SQL to improve the query performance.
• Assist in developing test cases and testing for user acceptance

Confidential

Data warehouse Technical Lead

Responsibilities:

• Analyze source systems and business requirements and create functional and technical design documents.
• Plan, design, and implement operational data stores, large data warehouses and data marts including capacity planning, data modeling, data analysis, schema design, batch and real-time load processes.
• Design and implement the Master Data Management and Meta Data Management systems as part of the Enterprise Data warehouse.
• Define, implement, and maintain ETL procedures using Informatica, PL/SQL and schedules to ensure the accuracy and timeliness of data in the operation data stores (ODS), data warehouse and various data marts.
• Participate in database schema design sessions with the project architecture and development resources.
• Plan, design and Implement reporting applications using Business Objects XI R2, Crystal Reports XI R2, C#, ASP.Net
• Optimize the SQL to improve the query performance.
• Configure and maintain version control system Rational Clearcase.
• Assist in developing test cases and testing for user acceptance
• Leading and mentoring team of 9 developers as a Technical Lead

Confidential

Senior Systems Analyst (Data warehouse)

Environment: Oracle 8i/7.x, SQL, PL/SQL, Visual Basic

Responsibilities:

• Analyze source systems and business requirements and create functional and technical design documents.
• Plan, design, and implement data warehouses and data marts including capacity planning, data modeling, schema design, batch and real-time load processes.
• Define, implement, and maintain ETL procedures using Data Stage and schedules to ensure the accuracy and timeliness of data in the data warehouse and various data marts.
• Participate in database schema design sessions with the project architecture and development resources.
• Plan, design and Implement reporting applications using Business Objects and Visual Basic
• Optimize the SQL to improve the query performance.
• Assist in developing test cases and testing for user acceptance

Confidential

Analyst Programmer

Environment: SQL Server 7.0, T-SQL, Visual Basic 6.0, Crystal Reports 6.0

Responsibilities:

• Discussing with customers on business requirements and create functional and technical design documents.
• Design the logical and physical data model in SQL Server
• Develop the stored procedures to implement the business logic
• Develop the GUI interfaces using Visual Basic 6.0
• Test the ERP Solution and receive user acceptance

Confidential

Software Consultant

Environment: Oracle 7.3, SQL, PL/SQL, Visual Basic 6.0, Crystal Reports 4.6

Responsibilities:

• Discussing with customers on business requirements and create functional and technical design documents.
• Collect and analyze business requirements and create functional and technical design documents.
• Design the logical and physical data model using Erwin.
• Conducted design reviews to finalize the data models.
• Develop PL/SQL stored procedures, functions, and database packages to implement business logic.
• Develop a common library to facilitate re-use of code by all developers.
• Develop coding standards to maintain consistency and easier debugging.
• Conducted code reviews to ensure adherence to standards.
• Managed application-related database objects like tables, views, materialized views, indexes, and partitions.
• Performed performance tuning by using tools such as Explain Plan, and other utilities provided by Oracle.
• Gathered statistics on the database objects to ensure selection of the optimal execution path by the Oracle optimizer.
• Suggested the indexes to be created to improve query performance.
• Develop the GUI interfaces using Visual Basic 6.0