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.

• Comprehensive experience across entire SDLC from Requirements Elicitation and data modelling to post production support. Adept at modelling large DW and providing ETL architecture for large Enterprise data warehouses using Star Schema

• 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.

• Has worked as part of a PMO collecting metrics on projects, assessing project health, comparing metrics against benchmarks to ensure adherence to project, quality, risk and change management targets. Helped in forecasting resource requirements, preparing for delivery challenges and recommending course correction to bring projects within budgeted costs, efforts and schedule.

• 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
• Client : Nissan North America, Franklin, TN.
• Role : ETL Architect/Senior Project Manager
• Duration : June 2014 through Till
• Team Size : 12 1.0M Program - Offshore Onshore Model
• Technology Used: ETL Reporting Informatica 9.6, OLAP on Oracle, SAP Business Objects 4.1

Project: Nissan EDW Transformation

• Nissan intends 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 BI 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.

Role : Offshore Project Manager IT Support, Maintenance and Enhancement activities.

Confidential

Project: Insight Maintenance and support

• Toyota Financial Services 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
• Collecting metrics and Publishing Executive level analytics dashboards from the organizations CRM on call volumes, Call service levels, call service SLA, Campaign tracking effectiveness, Customer Loyalty.
• 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

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

• Stock Award Accounting System SAAS is a centralized accounting database to hold all stock award data globally
• Options Accounting and Reporting System OARS provides stock option expense information
• Equity Compensation System ECS provides the equity compensation transaction data for both Options and Awards
• Financial Reporting System FRS provides the GAAP financials and intercompany balances
• Global Data Warehouse GDW provides the employee dimensional data.
• Equity compensation 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.
• 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.
• 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

• Verizon 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 : Support Engineer

CSC 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

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

IMACO is a company manufacturing domestic electrical appliances under the brand name National/Panasonic. Implementation of CES at IMACO started in January 2001. 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