Sandra [email protected]
+917092970959

Objective

To bring value to the Organization, by being resourceful in short period, using my analytical problem solving, work ethics, technical and communication skills. Ensuring high quality output always, value addition and mutual growth in the process.

Summary of experience

Around 8 + Years of experience in Project Management and Datawarehousing Methodologies using Technical Tools like Informatica, OBIEE, Oracle DB.

Associated with Global Leaders such as Ford Information Technology Services, Citagus Software Private Limited, Deloitte & Touche, KPIT Cummins Infosystems.

Analysis, Design, Development, Implementation, Testing and Support of Data Warehousing and Data Integration Solutions using Informatica Powercenter.

Self Motivated, Diligent Learner, Customer centric.

Provided detailed feedback to team members pertaining to each project.

Monitored all incoming Business orders and prepared necessary documentation.

Managed client communications with timely responses to emails phone calls etc.

Arranged and Attended regular Scrummers Business meetings both in person and via Skype.

Provided support to other vertical teams when required.

Efficiently resolved client issues.

Maximise the efficiency of the service providers, people, locations, ERP systems, processes

Domain exposure Banking, Finance, Insurance, Health Care, Manufacturing.

Project Management

Experience in leading large, multi-skilled teams for delivering mission-critical, large-scale projects for domestic & international clients.
Experience in Involving designing of databases thru data modelling techniques.
Process vision and design, enhancement strategy and transition strategy.
Managing resource allocations.
Solid Team player and possess project management skills and abilities.
Strong business orientation and a thorough understanding of the organisation’s business.
Implemented the quality checks before the delivery.

Education

Bachelor of Corporate Secretaryship from University of Madras.

On-Site Exposure

Went to Poland on Business Visa on May 2007.

Awards and Recognition

WOW Award for MFG Domain Expertise on January 2008 from KPIT Cummins Infosystems.
Delighted Customer Award on August 2008 from KPIT Cummins Infosystems.

Technical Skill Set

Data Modelling. : Dimensional (Star, Snowflake Schema), 3NF, Erwin, Visio 2007.
ETL Tools : Informatica 10.x,9x, 8.1, 7.1.2 and Oracle Warehouse Builder 10g.
Reporting tools : OBIEE 11.1.1.5/10.1.3.4.1.
RDBMS : Oracle 11G/10G/9i/8i, Teradata, MS-Access.
O/S : Windows 9X / NT/2000, UNIX, MS-DOS.
Tools/Utilities : SQL*PLUS, TOAD, PL/SQL Developer, SQL Loader.

Professional Experiences

July14 – Till Date with Ford Information Technology Services, Chennai, India as Senior Software Consultant
(Ford Business units around the world, including product development, manufacturing, marketing, sales and service. Shaped Stratergies for applying technologies to deliver business results, our business IT teams helps to drive innovation and shape the future.
http://corporate.ford.com)

SKU EDW (Stock Keeping Unit) Duration: Jan’16-Till Date
Client: Ford
Team Size: 45 Role: Senior Manager
Technologies: ERP, Informatica 9.6.1, OBIEE 11.1.1.5,Oracle11g/12c,Excel,CSV Files, UNIX, Windows XP/Windows 7.

Scope: Ford Integrated the Companys vehicle plant data, purchasing data, inventory optimization for parts, service and logistics to build a vehicle level view of profitability that incorporates the impact of both raw materials and non-standard incremental features for each Stock Keeping Unit (SKU). Ford extracts the near real-time vehicle profitability details from Oracle and Teradata and delivers it to information stakeholders at least daily, or more often during peak reporting periods, Today Ford has migrated from a 30-day refresh cycle to a one-day cycle.

Responsibilities:

Responsible for defining key performance indicators (KPI’s) / establishing targets within the processes and reviewing performance at agreed intervals.

Develops, builds and offers innovative services around Scrum Master Process Improvement and management.

Provides Global Finance Transformation management in the areas of integration and/or governance

Continuously work to improve internal and cross-functional OTC processes

Take ownership and deliver continuous improvement initiatives, to improve operating agile models and processes

Undertakes change management customer engagement activities for transformation projects

Drive standardization efforts ensuring that processes are globally improved and standardized

Novast Holdings & Laboratories Duration: July14-Dec’15
Client: Novast Holdings, China & US.
Team Size: 25 Role: Senior Manager
Technologies: Informatica 9.6, OBIEE 11.1.1.5, Oracle11g, Excel, CSV Files, UNIX, Windows XP/Windows7

Scope: Novast Holdings & Laboratories is a diversified pharmaceuticals and health care company. The purpose of this project is to model customer profile, sales and trend analysis of marketing campaign seeking a customer centric solution In order to maximize performance and effectiveness and identify opportunity for continuous improvement using reporting tool Siebel Analytics.

Responsibilities:

Negotiated delivery terms with national and international clients.

Determined project goals and prepared project completion schedules.

Established quality standards for each assigned project.

Tracked project progress and presented regular reports to clients.

Monitored client programs and identified potential risks.

Designed mitigation plans and implemented quality assurance procedures.

Ensured that all project timelines were met in accordance with client specifications.

June10- March11 with Citagus Software Pvt Ltd, Bangalore, India as Senior Consultant
(Citagus is a global Information Technology services company with Sharp focus on BI and ERP Services.Service Providers throughout the globe for Information Technology mainly in Financial, Banking, Marketing and Insurance Domains.
http://www.citagus.com)

Merial Datawarehouse Duration: June10 March’11
Client: Merial
Team Size: 12 Role: Team Lead / Business Analyst
Technologies: Informatica7.1.2/8.1,OBIEE 11.1.1.5,Oracle, Excel, CSV Files, Tidal 5.3.1, Windows NT.

Scope: Finance and Business Operations needs the ability to report on AR cash applications for analytic reporting (will be used in the AR Dashboard enhancement), additional trend analysis reporting, and need for determining eligibility for rebate payments.
Daily Sales flyer is scheduled to run on working days. Daily sales flyer consists of 4 different types of sales types. Namely Gross-to-net (GTN), Open Order, Back Order and Total Orders. Gross-to-net is derived from financial cube aggregates, while open orders and back orders are derived from bookings fact.
After receiving the handshake from the ERP, the AR transactions are staged in the form of primary keys for which the transactions have undergone a change during the current processing date range. These keys are used by related views for further processing by the sales stages.
Consolidated sales used be a comprehensive materialized view on the EDW. After re-architecture this materialized view has been broken into 4 components, namely (i) SPTS sales, (ii) Indirect Sales, (iii) Tractor Sales and the (iv) Direct Sales. While parts (i), (ii) and (iii) are processed along with the Dimensions as a final step, step (iv) is processed after the Sales fact is completed.
When the order has been entered and saved in ERP system, the status of the order will be ENTERED status, when they click BOOKED the order status will become BOOKED. Based on the progress of the order it will go through following statuses.

Responsibilities:

Created Repository, system and non-system session variable and initialization blocks for various reporting needs.
Created role based dashboards, pages, reports with various views i.e. table, pivot, charts, narrator, column selector etc. and various report prompts.
Used several OBI reporting features (Navigational, Drill Down, Drill Across, Guided Navigation, Security etc).
Analyzed requirements, implemented prebuilt business intelligence solutions using the Oracle Business Intelligence Analytics platform.
Extensively used page prompts and dashboard prompts for filtering data values in financial reports.
Worked extensively to customize DAC (Execution Plans, Subject areas, Task Definitions and Tables) for OBIEE Financial Analytics.
Implemented Object level security and data level security.
Created functional and Technical design documents.
Dimensional Hierarchy, Level based Measures and Aggregate navigation in BMM layer.
Performance tuning of Dashboard/Reports and made changes to database by implementing materialized views and partitions, rebuilding of indexes.
Developed Packages for bulk updating of transaction table.

Dec09-June10 with Deloitte & Touche India Pvt Ltd, Bangalore, India as Senior Consultant-Technology Integration
(Deloitte is the brand under which tens of thousands of dedicated professionals in independent firms throughout the world collaborate to provide audit, consulting, financial advisory, risk management, IT services to selected clients. The primary industries that we focus on are Technology, Media and Telecommunications, Energy & Resources, Manufacturing.
http://www.deloitte.com)

Country Financial and AlliServices Duration: December09-June’10
Client: Country Financial, Bloomington, Illinois, US
Team Size: 12 Role: Team Lead / Business Analyst
Technologies: Informatica 8x, Oracle 10G, Oracle Apps, Excel, CSV Files, Erwin 3.5.2, OBIEE, Windows NT, UNIX.

Scope: Country Financial is one of the fastest growing Auto/Property/ Life Insurance Company. It serves its customers by offering a range of innovative products to individuals and group customers at more than 600 locations through its company-owned offices. The primary objective of this project is to capture different Customers, Policies, Claims Agents, Products and financial related data from multiple OLTP Systems and Flat files. Extracted Transformed Loaded data in to data warehouse using Informatica Powercentre and generated various reports on a daily, weekly monthly and yearly basis. These reports give details of the various products of Country Financial Insurance products that are sold. The reports are used for identifying agents for various rewards and awards and performance, risk analysis reports for Business development Managers.

Responsibilities:

Defining the complete data warehouse architecture (e.g. ODS, ETL process, Data Marts, EDW).
Lead Designer and Delivery Gateway.
Development and testing of performance tuning tools, Design/Utility tools with Unix Shell Script.
Providing Technical Architectures and technical requirements for the data warehouse.
Test Data Creation and creating the test cases, execution and verification of test results.
Analyzed and computed statistics to improve time for queries.
Extensively used Erwin for Data Modelling and Dimensional Data Modelling.
Defined Meta Data Standards for the data warehouse.
Interviewed Clients to gather business requirements and performed gap analysis between the requirements and the data being pulled in from the source systems.
Performed Performance tuning upon the ETL Load Strategy plan.
Prepared various documents like Interface Requirement Document, Customer Requirement document, Integration test plan, Unit test plan, Release notes etc.

Jan 07-May09 with KPIT Cummins Info systems, Pune, India as Senior Software Engineer
(KPIT Cummins provides technology solutions to global clients, in the areas of
Advanced Technology Solutions (ATS), Enterprise IT and Business / Knowledge Process Outsourcing (BPO /KPO) across the Manufacturing and Diversified Financial Services (DFS) industry verticals,
Enables technology solutions that generate measurable and tangible value for your business http://www.kpitcummins.com)

CGT Sales and Operations Planning Datamart Duration: October07-May09
Client: Cummins Inc, Columbus, US.
Team Size: 5 Role: Team Member
Technologies: Oracle Warehouse Builder 10g, Informatica7.1, Oracle 10G, Oracle Apps,
Excel,CSV Files, Mapics (ERP), Noetix, Oracle Discoverer, Appworx, Erwin 3.5.2 Windows NT, UNIX

Scope: The Sales and Operations Planning Datamart will source the raw data for S&OP plan and holds the final output from the S&OP plan. The data sources for Datamart are:

Four Mapics ODS
Oracle Apps ODS from Fridley for the sales in Americas
Sales forecast from sales team of various regions
Production plan from operations team via Excel Sheets
S&OP Plan from S&OP Team
Actual Sales ( Sales Margin Data Mart )
AVK Details from S&OP Plan via Excel.
Extraction of Oracle Apps, Excel Sheets and ODS Data (ie AS400 Data) using Oracle Warehouse Builder into Datawarehouse Database.
Creation of Discoverer Reports for the application like Sales and Finance

The input data for S&OP plan comes from the sales team and the final S&OP plan output
is pushed to the Datamart.

Responsibilities:

Lead a Team of Data warehousing professionals to achieve the project objective.
Created the Data model and the Schema Design.
Created Views, Procedures and scheduled the Jobs in Appworx for loading data from time to time.
Manage Data Cleansing.
Created Shell Scripts for scheduling the ETL jobs and monitoring the processes.
Moved Data from Oracle App, Excel and ODS data to staging tables based on Data constraints
Created the Macros for Excel sheets and converted them into CSV files and loaded the same into the External tables sources.
Prepared Solution Design Document, ETL Design Document, Functional Specifications, Test Plans and Test Cases.
Monitor Delivery Timelines with Development Support Team, coordinate with Business teams and timely appraise them on Project Status.
Overall Responsibility for End to End delivery and accountable to business users for all system enhancements and issues.
Conducted and Managed User Acceptance Testing and Getting User Sign-Off.

Data Center Consolidation Upgrade (DCC). Duration: Feb07-Sep07
Client: Hewlett-Packard (HP), US.
Team Size: 7 Role: Team Member.
Technologies: Informatica 7.1, SQL Server 2005, Windows NT.

Scope: KPIT has been engaged to provide 2 services to HP GDS team related to HP global Data Center Consolidation (DCC) Effort. Asset identification for moving Asset from old data center to new data center. Internally HP calls this process PAR Project Architecture Review

EMEA Portal DCC Upgrade:

The purpose of the project is to upgrade the EMEA Portal of assets to DCC standard technology
and move into a new DC site on new hardware/services.
Informatica 6.1 to Informatica 7.1
Sql to Tidal Conversion (DTS Jobs to Tidal Scheduling).
FTP to SFTP Upgrade.
Sql 2000 to SQL 2005.
IIS V5 to IIS V6.

LA Wave DCC Upgrade:

LA WAVE is Reporting System which collects and publishes information from CALADO, EMS,
RAS and other legacy systems for Sales Orders, Purchase Orders, Forecast and Inventory.

Informatica 6.1 to Informatica 7.1
Sql to Tidal Conversion (DTS Jobs to Tidal Scheduling).
DTS to SSIS.
Sql 2000 to SQL 2005.
IIS V5 to IIS V6.
MS Analysis Services / OLAP 2000 OLAP 2005

Responsibilities:

Worked on complete up gradation Process.
Created Questionnaire template which is require to gather knowledge upon the Asset.
Developed Project Plan for the Up gradation Process
Identifying all current components requiring upgrade to be in compliance with DCC.
The data migration included identifying various databases and servers, understanding the complex business rules that need to be implemented and planning the data transformation methodology.
Communicate Upgrade Plan with all teams.
Co-ordinate the Plan along with the Team members.
Responsible for filling up the Dashboard status every week, and preparing minutes, document for weekly meeting.
Extensively interacted with Factory manager, Move lead, Application Support to gathering required information respective to the particular Asset.