Data Customer

Contact No: 408-***-****

Email Id: *************@*****.***

Linkedin: https://www.linkedin.com/in/sridevi-sankaran-5a491a21

AREAS OF EXPERTISE

Project and Program management

In-Depth Business Analysis

Requirement Gathering

Data Profiling

Dimensional Design and Modeling

Jira project Tracking

UAT and Quality Management

Customer Experience Analytics

Process Improvement

ETL & BI Design

Accomplished, proactive Engineer with 10 years of experience in IT specializing in Project and

Program Management, Business Analysis and Requirement Gathering, ETL (Informatica, Abinitio), SQL (Teradata, Oracle), Business Intelligence (OBIEE, Cognos) and Data Design(Erwin) with wide experience in end to end data warehousing design and development having desire to learn and work in a close-knit high performing team.

Conversant in Data warehousing concepts, Requirement Analysis, Business Systems design,

Prototyping, Business Intelligence Tools, Solution Development and implementation, Performance Analysis, and In-Depth Data Analysis. Possess extensive educational qualifications with Master’s (MTech) and Bachelor’s (B.E) degree in Computer Science. Effective Communication, Leadership, Presentation, and Coaching skills equally balanced for all tiers of business.

CAREER HIGHLIGHTS

Comprehensive experience in Business Analysis, Data Profiling, Data Modeling with good knowledge in ETL & BI Process, Project Management using Agile/SCRUM methodologies and other SDLC Models having hands on experience in BI and ETL Tools (Teradata, Informatica, Abinitio, DAC, Erwin, OBIEE Answers & Dashboards and Cognos 8.x BI).

Served a wide range of roles as a Business Analyst, Program Manager, Data Designer& ETL Architect.

Thought leadership around data infrastructure and Data mining for Customer Center Operations

Excellent knowledge in writing SQL, PL/SQL& Teradata scripts and Involved in Data Mining, Performance Tuning and Data Analysis of large Enterprise Data Warehouse.

Participated in POC’s like Trends on Agile Methodologies, Analysis on various In-Memory databases as part of Architecture Roadmap and published white papers on the same.

Analytical Thinker, consistently resolve ongoing issues or defects, often called upon to consult on problems that have eluded resolution by others.

PROFESSIONAL EXPERIENCE SUMMARY

Ebay Inc

Business Systems Analyst 3

Mar 2016 - Present

Ebay Inc

(Cognizant Technology Solutions)

Senior Associate

Apr 2014 – Mar 2016

Dell International Pvt Ltd

S/w Engineer Sr Analyst

Aug 2010 – Dec 2013

Oracle India Pvt Ltd

Member Technical Staff

Aug 2009 – Aug 2010

Oracle India Pvt. Ltd

(Symphony Services India Pvt. Ltd)

Software product development engineer

May 2008 – Aug 2009

Cognizant Technology Solutions

Programmer Analyst

Jan 2007 – May 2008

PROFESSIONAL EXPERIENCE

Ebay Inc, San Jose

Business Systems Analyst 3

(Business Analysis, Program Management and Data Analysis)

Ebay’s Global Customer Experience (GCX) team collaborates with various Customer Support (CS) applications to help business make timely decisions and to monitor the performance of their global workforce by providing reports based on validated sources and globally standardized CS metrics. This reporting solution is called End to End and it provides transactional, operational, and analytical information as driven by customer needs, time-zones, and frequencies.

Being part of the Business Analytics team involved in different modules such as Partner invoicing to generate right invoice to eBay’s third party contractors based on actual teammate schedule and contract signed, Work Force Management Team for capacity and forecast planning to determine the teammate availability, Skill Based Routing data for teammate productivity, availability, and adherence,

•Engaged client to gather requirements, business rules and ensured alignment with development team.

•Translated stakeholder’s requirements into tangible deliveries such as Functional specification document, Data flow diagrams and designed appropriate dimensional design to provision reporting to build necessary KPI’s and metrics for analysis.

•Project tracking in Jira and Program Management using Agile methodology

•Identified and reconciled errors in client data to ensure accurate business requirements.

•Facilitated meetings with customers, Integrated analytics team, development team, and testing team to document requirements and explore potential solutions

Ebay Inc, San Jose (Cognizant Technology Solutions)

(Business Analysis, Sr. ETL Developer using Abinitio, Teradata, UC4)

NPS development team facilitates eBay to obtain its NPS score. Net Promoter score correlates with revenue growth relative to competitors. NPS team has Monthly survey programs like Relationship NPS, Competitor NPS which calculates the Likelihood to recommend eBay by sending survey to Random sample of buyers and sellers who have been active in last 3 months. The Touchpoint NPS program is designed to help better understand the relationship eBay has with its members at different points where the user interacts with the eBay platform.

Surveys are sent to buyers or sellers–based on the nature of the Touchpoint daily. Survey responses are received from a third-party survey vendor on a daily/Monthly basis at the level of individual survey responses and can be attributed to the respondent's eBay user ID. As a result, user satisfaction, trust, and loyalty can be assessed across different countries, user types (buyer/seller), user activities, etc. Being part of NPS development team,

•Lead multiple touchpoint surveys and agile surveys to create sampling logic for the users to be surveyed

•Collaborated closely with business to understand the NPS requirements specific to an eBay feature

•Closely worked with 3rd party vendors like Decipher, ZS etc., to let the survey result set available for the business to analyze the data

•Subjected various bulletproofing mechanisms to avoid data miss across the vendors

•Coordinated with the offshore team to assign work, keep track of them and bringing it to completion

Worked as a Business Analyst and development lead for SBR which provides the capability to route contacts based on teammate skills. It routes the right customer with the right teammate.

Responsibilities include,

•Requirement analysis for the business needs, scoping for design and implementation and part of all SDLC life cycle stages of SBR

•Design, Develop, Implement and Test Business requirements though ETL using Teradata DB BTEQ scripts

•Unix Shell scripting and UC4 scheduling tool for the various End-To-End projects and legacy projects

•Creating necessary technical and functional artifacts for Solution and ETL design

•Perform Unit Testing, System Testing and Code Review of the modules developed Data Analysis and UAT Data Validation using BI reports

DELL International Pvt. Ltd

Software Development Senior Analyst/Software Dev Advisor

(ETL Architect -Informatica 8.x/9.x, Abinitio, Teradata, Oracle 11g, Data Architect - Erwin)

Dell uses Integrated Services Platform (ISP)/Delta an Oracle E-Business Suite for winning a fresh order, tracking customer complaints, dispatching a part, extending Warranty of the parts sold, After Point of Sales (APOS) services etc., wherein Oracle E-Biz is merged with Dell specific applications. Being part of services domain, worked on several projects on ISP loading necessary facts and dimensions in Warehouse for Dell Customer/Business Reports. It involved various systems like FTC, APS, GSCV, DIRT, Incidents etc.

Coordinated multiple projects as ETL architect and project lead, prepared various artifacts and ensured on-time, within budget completion by proper design and appropriate training to the team members

Took complete ownership for FSD EMEA, Japan, LA and US/CA which are major releases of Dell.

Learnt Abinitio in a short span and understood Legacy code to fix complex production issues whereby retired 10-year old legacy abinitio code by rewriting them in Informatica and BTEQ scripts.

Designed and Implemented ETL to bring the ISP/Delta data using Informatica, Teradata tpump, fload, mload and TPT utilities and migrated the data to Dell Data warehouse and made it available for reporting in SQL Server.

Awarded Bronze award twice and On-Spot award once for outperforming in the projects and fixing more complex production issues.

Wide exposure to Data modelling using Erwin and data profiling

Oracle India Pvt. Ltd, Bangalore

Member Technical Staff

(Informatica 8.6, OBIEE 11g, Oracle 10g, DAC)

Oracle Business Intelligence Analytics is a part of OBIEE 11g which deals with ETL from OLTP(Siebel, Peoplesoft, EBiz etc.,) to OLAP Data Warehouse which is used for reporting though answers and Dashboards of OBIEE. This project also deals with the common repository development to build the presentation layer with the required metrics using Administrator Tool. Extensively worked on Service/Customer Interaction module of the OBIEE 11g.

Designed, prepared necessary artefactfor semantic layer, presentation layer and ETL, build the complete repository model and solely implemented Customer Interaction module for OBIEE Fusion.

Actively involved in ETL and RPD testing and successfully implemented with Zero customer defects

First to set up the new OBIEE 11g environment in the Linux Box and did the ETL Design and Answers/Dashboards analysis

Extensively used the DAC scheduling environment to order and run EP’s for the Service Domain

Oracle India Pvt. Ltd, Bangalore

(Symphony Services India Pvt. Ltd)

(ETL Lead – OBIEE, Oracle 9.2.0, IBM Cognos 8.x )

Advanced Reporting is a new module for complex reports in the Enterprise1 GR product. The reports allow business users to analyze the key performance indicators of the organization across different merchandising, Warehousing, financial and operational hierarchies. Reports such as Flash sales, Open allocation, Purchase Order, Fast sellers, Packaway in store and warehouse etc., were developed for business users of a large retail enterprise.

Learnt Cognos tool in a span of 3 months and developed most complex reports like Packaway, Fast Sellers etc.,

Actively involved in Requirement analysis and estimation and closely met with business to understand the requirements and delivered reports exceeding customer’s expectation.

Worked extensively on Data modelling using Cognos Framework manager

Being part of the review committee generic coding standard document which was later used across teams and across domains

Awarded as STAR of the GOC

Cognizant Technology Solutions India Pvt. Ltd

Programmer Analyst

(Informatica 7.x, Oracle 8.x, Business Objects, Oracle 8.x, Mercury Quality Center)

Being the first company after completing post-graduation, explicitly trained in Various data warehousing tools, intensive training on data warehousing concepts and Oracle helped working in various DDW projects for Pfizer Inc. like Global Medical Data Warehouse (GMDW) which integrates 6 different data sources into a single DW, Quality Data Acquisition Management (QDAM) which is the process to measure the quality of data in DIF coming from different source systems. Power 2 Learn (P2L) etc.is to track training activities within the company to satisfy regulatory requirements, identify training gaps, and justify training expenses within Life Science Domain

Involved in developing ETL process using Informatica, Oracle, creating mappings, maplets, transformations, workflows, job scheduling etc.

Generalized the mapping by creating mapping templates as TYPE I, TYPE II and TYPE III for typical slowly changing dimensions

Very comfortable with Onsite Offshore model and acted as a point of contact to report on the bugs and customer issues

Worked in BO Report testing and was involved in Test Case design and query generation

Automated quite many manual process using PL/SQL scripts

Submitted a white paper on Survey of various Agile methodologies in Cognizant Technical Conference

Awarded as Best performer and Quality Champion in Pfizer Team

Contact this candidate