Summary

• Over 9 Years of experience within the IT industry, primarily in delivery of Data Warehousing, Data Migration and Business Intelligence Solutions.
• Well-rounded Data Warehousing Professional with strong analysis, solutions/architecture design and development experience.
• In-depth exposure to Data warehousing, Data Integration and Business Intelligence Reporting Solutions including ETL.
• Responsible for delivery and build of BI Solutions including Enterprise Data Warehouse, Data Integration and BI Reporting subject areas across multiple domains and geographies.
• Involved in pre-sales activity, prototype building, supporting User Acceptance Testing, Change Management, early-life support and defect analysis.
• Good Leadership Skills. Lead a team of 15 members in last few projects.
• Recipient of many team awards and valuable contribution awards.
• Above all, technical abilities are complemented by good communication skills and a strong commitment towards Customer Satisfaction.

Roles Responsibilities

• Technical and Solutions Lead on projects for designing Enterprise Data Warehouse, Data Integration and Business Intelligence Solutions.
• Source System Analysis and Data Profiling for data quality assessment.
• Prototype reporting and data outcome to assist Business in defining Business Rules for the reports and Universe.
• Elaborate Business and Security Requirements. Identify Business Rules and implementation approach to determine Data Integration and Reporting Layer Design.
• Experience in SAP Business Objects Data Integrator/Services installation and administration on UNIX systems.
• Develop Application and Technical Architecture Design documents as part of PDF Deliverable.
• Participate in Logical and Physical data model creation and finalisation using Kimball and Inmon Methodology.
• Development of complex queries against normalized and dimensional models.
• Design and Creation of Data Loading Strategies. Development of ETL jobs and Builds for Staging, Atomic Data Layer and Data Marts.
• Performance Tuning and Optimization of ETL routines.
• Participate in Extraction of Historical Data and cleansing required for meeting future reporting needs.
• Development of view, materialized view, procedures and packages.
• Adherence to and compliance with Quality Assurance Framework including that of Customer's and Internal Organisation's.
• Played a BI Release Manager role for client's Project Delivery Framework for BI projects.
• Responsible for Testing, QA and Reviews pre-deployment.
• Assist in User Mentoring, Testing, Release and Post Go-Live adoption support.
• Adapted standard BI Methodologies including Iterative Development Methodology for facilitating an early benefit to customers.
• Involved in Change Management process for the users to adapt to the new BI tool.

Skills

• Data Warehousing SAP Business Objects Data Integrator 11.5/11.7, SAP Data Services 3.2, Talend, SSIS 2008
• Business Intelligence SAP Business Objects Suite of Products 6.5 XI R1/R2/R3 Designer, Web-I, Xcelsius, Live Office, CMC, Administration
• Language PL/SQL, C, C , C , Visual Basic 6.0, HTML, Shell Scripting
• Data Modeling ERWIN 7.2
• RDBMS Oracle 8i/9i/10/11g, SQL Server 2000/2008
• OS/Environment Linux, UNIX, Windows 95/98, Windows NT/XP/Server 2003
• Others .NET framework, MS SharePoint Services, Control-M, Autosys

Professional Profile

CONFIDENTIAL

Title ETL Lead

Date of Employment

CONFIDENTIAL

Title Project Manager

Date of Employment

CONFIDENTIAL

Title SAP Data Migration Consultant

Date of Employment

CONFIDENTIAL

Title SAP Business Objects Data Services Consultant

Date of Employment

Employer CONFIDENTIAL

Title Software Specialist

Date of Employment

Employer CONFIDENTIAL

Title Software Programmer

Date of Employment

Project Information

Work History at Confi-Chek:

CONFIDENTIAL

Technology SSIS 2008, SAP Business Objects Data Services, SQL Server 2008,

UNIX, Control-M, Erwin 7.2

Duration

• Data CONFIDENTIAL product by CONFIDENTIAL provides public record and investigative information to private investigators, attorneys and other licensed professionals. It has comprehensive collection of data and is an excellent source of records for locating people, businesses and performing background checks.
• Data CONFIDENTIAL takes the search criteria and performs matches on billions of records in seconds.
• CONFIDENTIAL was part of Data Tsunami's product team, managing and leading the data warehouse development team.

Role Responsibilities: As ETL Lead:

• Responsible to maintain project plan and coordinate with all stakeholders to ensure timely completion of deliverables.

• Overall responsibility for deliverables of the team to Management
• Source System Analysis and Data Profiling for data quality assessment.
• Elaborate Business and Security Requirements. Identify Business Rules and implementation approach to determine Data Integration and Reporting Layer Design.
• Develop Application and Technical Architecture Design Documents as part of PDF Deliverable.
• Participate in logical and physical data model creation and finalization.
• Participation in Extraction of Historical Data and cleansing required for meeting future reporting needs.
• Design and Creation of Data Loading Strategies. Development of ETL Jobs and Builds for Staging, Atomic Data Layer and Data Marts.
• Performance Tuning and Optimization of ETL routines.
• Creation of control-m jobs for Scheduling of ETL loads.
• Assist in User mentoring, Testing, Release and Post Go-Live adoption support.
• Lead a team of 8 people

Work History at L T Infotech:

CONFIDENTIAL

Technology UNIX, Oracle 11g, Talend, SAP Business Objects Data Services, Erwin 7.2, Autosys

• CONFIDENTIAL to design an automated Activity Based Costing Model,
• that identifies activities and assigns cost per activity for S PB Operations and CONFIDENTIAL This
• involves Feed procurement from various source systems for Exceptions and Head Count,
• People Soft for ABM Modelling, and Business Objects for Reporting.

Role Responsibilities: As ETL Solution Designer/Lead PMO:

• Source System Analysis and Data Profiling for data quality assessment.
• Requirements gathering for data enrichment for economic fields as well as regulatory and compliance attributes, to ensure consistency and quality of those attributes across products and regions.
• Co-ordination with Source IT and Business Operation Users to enable feed on boarding.
• Preparation of Business Requirement Document, Functional Specification Document, Technical Design Document and System Integration Test Plans.

• Participate in logical and physical data model creation and finalization.
• Design and Creation of Data Loading Strategies. Development of ETL Jobs and Builds for Staging and Atomic Data Layer.
• Performance Tuning and Optimization of ETL routines.
• Creation of JILS for Autosys jobs for Scheduling of ETL loads.
• Driving daily status call Scrum calls with offshore development and testing team to ensure timely delivery for each release.
• Responsible to maintain project plan and coordinate with all stakeholders to ensure timely completion of deliverables.
• Assist in User mentoring, Testing, Release and Post Go-Live adoption support.
• Overall responsibility for deliverables of the team to Management and Client
• i.e. Preparation of MIS, Daily Execution status report, Daily Tracker, Training, and Process Initiatives
• Lead a Team of 15 people.

Work History at Gold Coast City Council:

CONFIDENTIAL

Technology Oracle 11g, SAP ECC 6.0, SAP SRM, SAP CRM, SAP Business Objects

Data Services

• CONFIDENTIAL is an organization wide initiative that has been launched to enable continued business improvement for Gold Coast City Council GCCC . The ERP/Property Program would enable council to become more efficient and effective in its day to day operations and provide an improved service to Council's customers, ultimately benefiting the quality of living for Gold Coast residents.
• To achieve this GCCC is implementing SAP ECC with EAM, HR, SRM, CRM, FICO and PSCD modules.
• As an SAP Data Migration Analyst, I was responsible for migrating the Asset Data from GCCC Legacy System mainly Ellipse, Asset Master, SMEC, eFlow, ALVIN, Excel Spreadsheets and Flat Files into SAP.

Role Responsibilities: As ETL Solution Designer Developer:

• Source System Analysis and Data Profiling for data quality assessment.
• Understanding normalized databases, operational data stores and data marts.
• Design and Creation of Data Loading Strategies. Development of ETL Jobs and Builds for Staging, PDM and SAP Load Files.
• Creation of ad hoc queries to answer complex business questions or data issues.
• Performance Tuning and Optimization of ETL jobs.
• Performing Unit Integration testing.
• Assisting in User Acceptance testing.

Work History at Oakton:

CONFIDENTIAL

Technology Oracle 11g, Siebel 8.1.1, SAP Business Objects Data Services, Erwin

7.2, Control -M

• The Customer Management System CMS program is the vehicle by which Sydney Water will transform its customer service in order to achieve the following key outcomes:
• Provide a single view of a Customer's dealings with the corporation
• Provide a single view of Property within the corporation
• Deliver comprehensive customer centric processing for all Sydney Water staff, based on the various business roles they perform
• Establish consistency in work processes and customer communication
• Underpin customer contact with effective record keeping and quality assurance processes
• Improve data quality thereby ensuring data completeness and accuracy
• Reduce fragmentation of information, data and systems
• Renew the IT asset by replacing non Customer Management functionality in the Billing system and rationalizing satellite systems
• Significantly improve customer relationship management by providing staff with seamless access to business systems
• CMS Release delivers a new CRM Customer Relationship Management system based on the Siebel 8 platform. This application integrates enterprise middleware components with existing Sydney Water applications to centralize customer information.
• Ashish was part of the team responsible of the data migration In the Customer Management System CMS Program. The main objective of the project was to migrate data from Sydney Water's different legacy systems Including Access Billing system , Trade Waste stores commercial/Industrial trade waste agreements , CView customer contact and complaints application and EDC Every Drop Counts - provides water consumption details to corporate customers into the new CMS Siebel 8.1.1 application.

Role Responsibilities: As ETL Solution Designer Senior Developer:

• Source System Analysis and Data Profiling for data quality assessment.
• Participate in Data Migration Strategy.
• Develop Application and Technical Architecture Design Documents as part of PDF Deliverable.

• Participate in logical and physical data model creation and finalization using Kimball and Inmon Methodology.
• Design and Creation of Data Loading Strategies. Development of ETL Jobs and Builds for Staging, PDM and Siebel Base Tables.
• Performance Tuning and Optimization of ETL jobs.
• Creation of control-m jobs for Scheduling of ETL loads.
• Performing Unit Integration testing.
• Assisting in User Acceptance testing.
• Development of Data Migration Reports and Dashboards.

Work History at Patni Computer Systems Ltd:

CONFIDENTIAL

Technology Oracle 10g, SAP Business Objects Data Services, SAP Business Objects Suite of Products Designer, Web-I, Xcelsius, CMC, Admin , Erwin 7.2, Control-M

• CONFIDENTIAL as part of their BI Initiative in 2006. Property and Consumption BI is a major project in the series of projects under IA BI Program. This project provides Property and Consumption related analytical Information to Customer Billing, Sustainability, Finance Regulatory and Asset Management divisional managers. The primary source of this information is ACCESS Billing System, a mainframe based application. The objective of this project was to Design and Build Property and Consumption subject area as part of Enterprise Warehouse, and provides predefined as well as self-serve reporting capability to respective business Units.
• This information is generated in Mainframes system. The data from source is transformed to Corporate Data Repository and reported from EDW Enterprise Datawarehouse . The universe layer had over 900 objects and provided an ability to report history using current reference data as well point-in time reporting. In addition Project delivered 30 Complex Reports and 11 Data Extracts to Business Users primarily in the area of Consumption, Property Growth and IPART Reporting.

Role Responsibilities: As Solution Designer Technical Architect:

• Source System Analysis and Data Profiling for data quality assessment.
• Elaborate Business and Security Requirements. Identify Business Rules and implementation approach to determine Data Integration and Reporting Layer Design.
• Develop Application and Technical Architecture Design Documents as part of PDF Deliverable.

• Participate in logical and physical data model creation and finalization.
• Design and Creation of Data Loading Strategies. Development of ETL Jobs and Builds for Staging, Atomic Data Layer and Data Marts.
• Participation in Extraction of Historical Data and cleansing required for meeting future reporting needs
• Development of Property Consumption Universe. A complex universe providing both SCD Type 1 and SCD Type 2 as of point history reporting capability thus allowing Growth and Property Relationship and consumption pattern change Analysis.
• Development of Predefined Business Objects Reports and Consumption Dashboard.
• Assist in User mentoring, Testing, Release and Post Go-Live adoption support.
• Lead a Team of 6 people.

CONFIDENTIAL

Technology Oracle 11g, SAP Business Objects Data Services, Erwin 7.2, Control-M

Duration

Role Solution Designer Technical Architect

CONFIDENTIAL

Technology Oracle 11g, SAP Business Objects Data Services, Erwin 7.2, Control-M

Role Technical Designer Team lead

CONFIDENTIAL

Technology Oracle 10g, SAP Business Objects Data Integrator, Erwin 7.2, Control-M

Duration

Role Technical Designer

CONFIDENTIAL

Technology Oracle 10g, SAP Business Objects Data Integrator, SAP Business Objects Suite of Products Designer, Web-I, Xcelsius, CMC, Admin Erwin 7.2, Control-M

CONFIDENTIAL

Technology White Box Testing

Role Tester

CONFIDENTIAL

Technology C , Windows Sharepoint Services

Role Programmer

CONFIDENTIAL

Technology C, C , Tuxedo, Solaris 2.8

Duration

Role Programmer

CONFIDENTIAL

Technology Oracle 9i, SAP Business Objects Data Integrator 6.5

Duration

Role ETL Developer