Summary

• Having 12 years of IT experience with expertise in ETL, Data Warehousing and Business Intelligence. Have created effective design and architecture, and process Methods. Have developed software components and best practices for delivery of service excellence. Have worked with teams across borders, time zones and cultures.
• Adept at managing projects with teams of 20 members, managing multiple projects, ensuring delivery across geographical locations and managing projects from inception to closure. Extensive Experience in requirement engineering for large, complex programs. Have been involved in business requirements for diverse areas of the applications. Have worked with business stakeholders and SMEs in defining the scope of large programs, process flows, interface specifications, ETL Mappings, Report design and data model design.
• Have worked on Level 2 and 3 Global Support projects. Have tuned the existing systems to optimize performance thereby business critical production cycles complete within SLA. Produced and baseline documents production support handbook. Developed new systems. Have very good experience in project lifecycle management.
• Have performed onshore and offshore coordinator role for both technical and management areas. Have performed Project Initiation and Project Planning, Managed project budgets, schedule, dependencies and risks. Have managed stakeholders' meetings and status reports.
• Experience in pre-sales, responding to RFP, RFI, defending proposals, performing due diligence, SOW preparation in BIDW multi-million dollar outsourcing projects

Technical Skills:

ETL tools Informatica 9.6 and Datastage. TOAD, SQL Developer for Oracle. Data Modeling using ERWIN. DB2 and ORACLE Databases. Autosys and Control M scheduler. Business intelligence reporting using OBIEE 11g, Business Objects 4.1

Confidential

Role : Data Warehouse Project Manager

Technology Used: ETL Reporting Informatica 9.6, OLAP on Oracle, SAP Business Objects 4.1

• Confidential to sunset its legacy Enterprise Data Warehouse EDW on Oracle 8i database and reporting tools Micro strategy 7.2, Micro strategy 7.5 and BO 6.5 and move all the data into BIDW which is built on Oracle 11g database as well as reports in to SAP Business Objects 4.1
• The scope of this EDW transformation project is to make the necessary changes to BIDW Application stream to process the data files received from Business team and load into Stage and BIDW databases and Rebuild the reports in SAP BO 4.1 on top of the data.
• The ETL application receives source data from 15 different sources and stores them in the data mart Star Schema using the ETL tool Informatica 9.6 . Subsequently, the data is retrieved and displayed on the UI reporting screens built on SAP BO. The de-normalized data kept in the star schema will be used by Business Users for data analysis. The BO universe is exposed to the business users for adhoc reporting and self-service BI.

Responsibilities:

• As-is study of the existing EDW system to understand the existing data and the reporting requirements it caters to using MSTR 7.5.
• Gap analysis between the as-is and to-be systems and identifying what needs to be bridged over to the new system
• Identified source systems based on the UI and OBI report requirements by interacting with various business lines and source systems' SME.
• Project Initiation and planning for the entire project across 4 releases.
• Developed Infrastructure, Solution and System design documents.
• Performed ETL Mapping exercise
• Performed Data profiling and Data Cleansing activities.
• Applied ETL concepts, ETL loading strategy, Data archiving, Data reconciliation, ETL Error Handling, Error logging mechanism, standards and Best practices.
• Applied warehousing techniques and ETL Frame work designing.
• Performed modeling for Hierarchy schema and Data Mart with Data Architect.
• Development of archival strategy.
• Built ETL routines to load star schema for cases such as: slowly changing dimensions, late arriving facts, late arriving dimensions, as is / as was reporting, revisions to history, surrogate keys.
• Performed Data Quality, Data Profiling and Metadata Management. Have designed and developed reusable components and transformations. Applied Performance Tuning methods, SQL Override and unconnected lookups using Informatica with large volumes of data load.
• Designed and built complex stages to handle high-volume scenarios. Created SIT, UAT and implementation plan and strategies. Provided SIT and UAT and Implementation support.
• Managed cost and schedule of the project for Infosys side.
• Managed risks and dependencies, and Managed clients and other stakeholders.
• Anchored Change Management.

Confidential

Role : Project Manager IT Support, Maintenance and enhancement activities.

Technology Used: Informatica 9.1, OBIEE 11g, Oracle, Netezza, Hyperion Planning, Hyperion Essbase, Crystal reports

• Confidential is a wholly owned subsidiary of Toyota Motor Corporation involved in providing financing and leasing options at Toyota Dealers for Toyota cars.
• Their financial reporting on top of Siebel CRM needs to be maintained and supported by a maintenance partner
• Insight BI is a suite of products sitting on top of the STARS CRM solution. It comprises a range of Oracle and other reporting products. The technology involves Hyperion Planning, Essbase, OBIEE, Crystal reports for planning and reporting and Informatica for the ETL needs.

Responsibilities:

• Managing the project from offshore.
• Ensuring timeliness and quality of deliverables adhering to SLA defined by customer - 98.5 .
• Handling Minor System Enhancements design, development, test and deployment. Ensured compliance to Target architecture, design and coding standards and best practices. Developed complex ETL jobs. Developed transformation and aggregation techniques
• Anchoring change management processes.
• Prepare KT plan for technology KT, Secondary Support and Primary Support
• Working with team in identifying possible areas of improvements and reducing ticket volumes. Reduce Sev 1 and Sev 2 tickets by applying permanent fixes
• Provide technical guidance and assist on daily operational activity.
• Ensured adherence to Software Development process standards. Performed and managed design and code reviews. Identifying root cause of incidents and raising Problem Management requests.
• Periodic status reporting on Project health, Achievements, Issues, Risks and remediation steps
• Coordinate efforts between onsite and offshore teams
• Manage a team of 22 at offshore on the diverse tools

Confidential

Role : Onsite Coordinator/Project Lead

Technology Used: Oracle Sales Analyzer, Siebel Reporting, SQL scripting, TOAD and Control-M on a UNIX platform

• Confidential has acquired a cosmetics giant, Confidential data now needs to be integrated into existing P G systems. Multiple teams are working on integrating the data into various systems. One of these systems is the Demand Planning Reporting solution called SourceOne
• Confidential is a Demand Planning Reporting solution which maintains Shipments and Forecast data. Demand planners look at shipments sent for various products and product lines and also the past forecasts to make Demand Forecasts for the future. There are upstream and downstream systems which feed data and receive data from SourceOne in the form of flat files. The Wella data for Professional care product line needs to be included in these flat files' extraction routines. The reporting is done through Oracle Sales Analyzer cubes, Siebel reports and Microsoft XL Trackers. Wella data needs to be integrated into the reports.

Responsible for:

• Understanding Client requirements, Do an As-Is study of existing system to understand how to seamlessly integrate the data
• Provide Design solutions for integrating data with the existing solution
• Modify the ETL used for loading data to the data warehouse to include the Wella professional care data sent from the SAP source systems
• Build the materialized views on top of the data to hold data by time, product and geography hierarchies. Establish MV refresh rules and refresh cycles to ensure optimal utilization of resources.
• Schedule the jobs in Control M
• Evolve development, testing and deployment strategies. Work with the application support on deployment to UAT and production environments and support UAT with user community
• Ensure data integrity and integrity of the application, and provide performance report
• Technical gatekeeper in charge of configuration management and Milestone sign-offs
• Training of support teams to handle the newly introduced procedures and trouble shoot in the event of failure.

Confidential

Role : Project Lead

Technology Used: PeopleSoft EPM 9.0, Peopletools, TOAD, AbInitio, BO XI and Autosys

• Equity Compensation Data Warehouse is a centralized repository for all Equity Options and Awards ever granted to all employees of Citigroup, its Affiliates and Associates. It merges data from multiple sources into an EPM warehouse.
• Confidential is a significant and increasing component of the employee reward system. At present, there is no central system that houses the critical data elements required for accounting making it difficult to validate and reconcile the deferred compensation asset back to the corporate books and records. To address information integration and delivery issues, there is a need to build a data warehouse.
• Global Data Warehouse GDW provides the employee dimensional data.
• Financial Reporting System FRS provides the GAAP financials and intercompany balances
• Equity Compensation System ECS provides the equity compensation transaction data for both Options and Awards
• Options Accounting and Reporting System OARS provides stock option expense information
• Stock Award Accounting System SAAS is a centralized accounting database to hold all stock award data globally
• Data from all these various systems are organized in a Snowflake schema in ECDW. Various reports are generated out of this system for HR, Corporate Tax and Finance users

Responsible for:

• Coordinating amongst the various project teams PS EPM, BO and Ab-Initio. The teams were spread across onsite and multiple offshore locations. Continuous coordination amongst the teams was essential to project schedule adherence
• Understanding the requirements of the system and translating them to Functional Requirements.
• Contributing to the data model design. The data model consisted of a star schema with 2 facts for the Stock awards and the stock options
• Design Data Elements, App Engine Programs to load data and Pages in People Tools.
• Handle SIT and UAT fixes and Change Requests.

Confidential

Role : Sr. Developer

Technology Used: WebFocus, DB2

• Confidential had a lot of reporting solutions built around their 2 data marts Repairs and Provisioning,
• The purpose of RCMAC Recent Change Memory Administration Center Reports is to extend the coverage of the POEMS Performance and Operations Efficiency Management System application's tracking of work volumes, technician productivity, and hours tracking costs to the RCMAC East work centers. Focusing on the Productivity Report will allow management to develop individual benchmarks for their associates and establish local standards of acceptable productivity measures.
• Competitive Markets Performance Systems CMPS is a WEB based system that measures daily, weekly and monthly productivity and quality reports.
• This System was generating Verizon hierarchy level reports for their Repair and Provisioning Systems. The reports were used by clients using UNIX shell scripting. The need arise to create reports from different Marts. The Webfocus tool is used to achieve the goal.

Responsible for:

• Gathering user reporting requirements and translating them to functional specifications
• Converted functional specifications to technical specifications and designed the reports for user consumption
• Development, coding and unit testing of Webfocus reports
• Conducting user training on how to run the reports and get maximum benefit out of the reporting solution

Confidential

Role : Database Engineer

Technology Used: SQL DTS Packages, SQL Server 2000, ASP

Confidential maintains the systems for Nortel Networks. Satyam helps CSC maintain these systems. Plexus is an online order processing system of Nortel developed in ASP with a SQL Server 2000 Back-end. A set of DTS packages loads data to the Plexus system.

Responsible for:

• Monitoring of daily, weekly and monthly loads done by SQL DTS packages.
• Monitoring and reporting on load schedules, load success rates, volume of data loaded
• Correcting load failures, analyzing reasons for load failure and fixing issues in ASP pages

Confidential

Role : Implementation Engineer/Oracle Developer

Technology Used: PL/SQL, Oracle 8i, Developer 6i

Confidential. They are into manufacturing of clutch phasing for cars brands like Ford, Maruti Suzuki, etc. CES is already in place at Valeo. A Fixed Assets Maintenance System was developed as an add-on to the existing product. This add-on was configured to maintain fixed asset balances and depreciation thereof in multiple formats as prescribed by Income Tax Act, Company Law and as required by the parent organization i.e. January - December.

Responsible for:

• Understanding Fixed Assets accounting systems
• Setting up global variables for Fixed Assets Maintenance systems
• Training end-user on the system

Confidential

Role : Implementation Engineer/Oracle Developer

Technology Used: PL/SQL, Oracle 8i, Developer 6i, SQL, Oracle Reports 6i

Confidential Requirements of the user as to enhancements needed to the existing package were studied. Enhancements were made in Sale Order Processing, Budgeting and Invoicing to meet user needs. Reports were customized to cater to the specific needs of the customer

Responsible for:

• Implementation of the Finance and Sales Modules of CES
• Requirement Study to understand the scope of implementation and the amount of customization required
• Customization of Reports for purposes of MIS using Oracle Reports 6i