SASIKALA RANGANATHAN
E-Mail: / Contact No.: 95000 86065
PROFILE SNAPSHOT
Offering over 15yearsof software experience in Software Design & Development, Data Warehouse Projects, Database Solutions, Implementation & Support and Client Relationship Management
Lastly associated with Verizon Data Services as FRPA Technical Manager.
Was previously with Tech Mahindra, Chennai as Senior Project Manager.
Adept in using IBM Mainframe, Oracle, Data Modelling, Data Warehousing, ETL and OLAP tools.
Well conversantwith the end-to-end development of software products from requirement analysis to system study, designing, coding, testing, debugging, documentation and implementation.
Expertise in working in the entire Data Warehouse Life Cycle Implementation. Possesses good understanding of various computer technologies, software/web development, databases, programming, client-server architecture, operating systems, etc.
Extensively worked on OLAP tools such as Oracle Express, Oracle Financial Analyzer, Oracle Sales Analyzer and Discoverer, OBIEE 10g/11g,Informatica 5.x/7.1.2/8.x/9.x,Tableau,MSBI
Was leading the Oracle BI competency providing RFP support, solution architecting and estimation.
Experience inOBIEE Application(OBIA)Implementation.Well versed with Data Warehouse Maintenanceand Testing procedures.
Worked in the Center of Excellence (BI COE) and worked on various proposals, managed Oracle BI COE.
Familiar with CMM and ISO 9001 quality procedures and followed these processes.
Trained in ITIL process
Certified Scrum master (CSM)
Acquired skills in managing IT operations with key focus on optimal utilisation of resources.
Possesses excellent technical, communication, interpersonal, people management, relationship management and analytical skills.
Key skills include:
Strategic PlanningProject ManagementSoftware Development
Data WarehousingDate ModellingQuality Assurance
Technical Support/ TroubleshootingClient Relationship ManagementTeam Management
Delivery ManagementPeople Management
PROFESSIONAL CERTIFICATIONS
Completed Certified Scrum Master in 2016.
Six Sigma Green Belt Certified.
Completed Satyam’s Project Management Certification in 2009.
Completed QMS Certification in 2009.
Completed Project Management for Practitioners Certification in 2014.
IT SKILLS
Operating SystemsWindows 95/98/NT/2000, HP 3000, IBM mainframe (MVS)
Databases /ToolsOracle 8i/10g/11g, Sybase system 10, Sql Server 7/2000, VSAM
Data warehousing OLAP ToolsInformatica 7.1.2/8.x, Oracle Express Objects, Oracle Express Analyzer, Oracle Sales Analyzer, Oracle Express Server, Oracle Discoverer, SAS,OBIEE, OBIA
Domain KnowledgeInsurance, Banking, Manufacturing, Telecom
Organisational Scan
Feb 2016 till Jan 2017 Verizon Data Services India Ltd, ChennaiTechnical Manager
May 2004/Feb 2016 Tech Mahindra, ChennaiSr Project Manager
From May/ 2004 Mahindra Satyam, ChennaiProject Manager
Apr/ 2003 to Apr/ 2004IGATE Global Solutions, ChennaiConsultant
Oct/ 2000 to Apr/ 2002Satyam Computer Services, ChennaiSenior Systems Analyst
Key Deliverables:
Provide solutions/responses to RFPs.
Participate in Proposal discussions with Pre Sales team.
Managed BI account in NISSAN
Provide estimates and plan.
Provide DW architecture and design solutions.
Support IBGs in selection/recruitment of right candidates for projects (internal/external).
Support Training in BI.
Reviewing the functional requirement documents.
Handling unit & integration testing, debugging and troubleshooting of the application.
Coordinating in smooth implementation of the project; extending post-implementation and application maintenance support to the client.
Engaging proactively in research for analysing and recommending improvements to existing systems.
Carrying out data processing in developing, implementing & testing Data Warehousing applications.
Managing frontline/ backline customer service by interacting with clients and concerned teams for problem resolution.
Designing and developing the jobs for extracting, cleansing, transforming, integrating and loading data.
Managing all the stages of Software Development Life Cycle.
Troubleshooting Data Warehousing tasks as well as addressing production issues like performance tuning and enhancement.
Significant Highlights:
Received Best Performance Awardfrom GE and IGATE together (Cash Award of $1000) for the year 2003-2004.
Received appreciation from IFC (World Bank subsidiary) Client for outstanding performance.
Received appreciation from GE Medical Systems Client for providing support to other Vendors (TCS) and helped them on resolving critical production issues.
Received appreciation from Oman Insurance Client and Mahindra Satyam – Account Manager for successfully completing the OBIA Implementation on time overcoming the Challenges and implementing till production.
Received award from NISSAN Client for managing the BI Center of Excellence team effectively.
ACADEMIC CREDENTIALS
BE (Computer Science) Bharathiar University
TRAINING PROGRAMMES ATTENDED
IBM Mainframe training in Tata Consultancy Services.
Attended Data Warehousing and Data Modelling training in Satyam Computer Services Ltd. in 2000.
Completed DW Tools Training in Satyam Computer Services Ltd. in 2000.
Six Sigma Green Belt Training Program in 2003.
Participated in Cognos Training in 2009.
Satyam’s PMP Trainedand Certified in 2009.
Trainedin ETL tools like Informatica, Oracle Warehouse Builder and self trained in ODI
Completed internal training in OLAP tools like SAS/Business Objects and Cognos in 2004
Coaching for Optimal Performance in Verizon in 2016
Giving and Receiving Feedbacks in Verizon in 2016
Performance Reviews/Assessment in Verizon in 2016
Assertiveness skills in Verizon in 2016
Global Respectful Workplace in Verizon in 2016
PMP training for 4 days in 2017 conducted by IT Tech Gurus.
TRAINING PROGRAMMES CONDUCTED
2 days training program in Data Warehousing – Architecture and Implementation/ Oracle DW tools
1 day training program in Internal reviews and testing
Half a days’ training program in Data Warehouse Testing
Informatica training for Laterals
OBIA training for OIC team
PERSONAL DOSSIER
Languages KnownEnglish,Tamil,Kannada
Passport NumberA2926416 (to be given for renewal)
ReferencesAvailable on request
Projects handled attached in the annexure:
ANNEXURE
Major Projects Handled
Project NameCFO - Financial Reporting & Planning Analytics
CompanyVerizon
RoleFRPA - Technical Manager
Periodfrom Feb 2016 till date
TechnologyOBIEE 11g/ODI,Tableau, OracleDatabase,Hyperion Essbase/Planning
Description Provide Oracle Financial Datawarehouse solution to the FPnA users and created reporting/Dashboard with headcount, spend reporting/ Financial consolidated view for Income / Cash flow and Balance sheet statement.
The CPM dashboard system has been designed to assists management and corporate finance users to understand the performance of Verizon on selected period. It has different financial dashboards, like Income statement, Balance sheet, Headcount,.. etc for different line of business (Corp, WLS, VES and CMB).
FPnA transformation
Establishing a "Single version of the truth" for performance management reporting
Bringing all business unit data together for executive reporting.
Driving down long term operational costs by standardizing processes, workflows and internal controls.
DRG Implementation
Highlights:
Provide Technical solutions as per Business User requirements
Guided on the reverse engineering of CPM to implement BIAPPS
Managed the maintenance releases
Managed the Mobile enablement of CPM Dashboards project
Managed BIApps POC
Managed Scorecards POC
Managed FRPA Team and onshore co-ordination
People Management
Performance reviews and coaching
Team Mentoring
Project NameNISSAN – AMO and Enhancements/Development Projects
ClientNISSAN North America
RoleSenior Project Manager – Operations and Delivery
Periodfrom Mar 2014 till Feb 2016
TechnologyInformatica 8.x/9.x, SAP BO 4.0/4.1, Hyperion Essbase/Planning
Description Nissan North America is a leading auto Major and scope of BI includes maintaining the BIDW / EDW for all upstream and downstream systems like TREAD, CRM, Dealer Portal, Owner Portal and VIMS. There are others subsystems that source data into BIDW like GEARS, GCARS and ALERT systems which form as sources and pick data as well. Informatica is used as ETL to bring in data from host systems like Mainframe, SFDC etc. and loads data into the warehouse. Reporting is done to measure various KPIs and Dashboards are provided with security setup enabled.
Highlights:
Manage the BI Team – planning for resource forecasting/team ramp up
Manage COE Operations for AMO/Enhancements
Participate in Account Mining along with the Business Area Leads
Manage Enhancements and Projects
Team grooming, mentoring, resource management, onsite co-ordination\
Attend Client Meetings for Weekly status reviews for AMO and Projects
Project NameBI DW – Oracle BI Competency
ClientEBS BI Competency
RoleSolution Architect
Periodfrom Dec 2010 till Feb 2014
TechnologyOBIEE, ODI, OBIA (DAC/Informatica 8.1)
Description BI DW – Oracle Bi Competency support aims at providing Oracle BI solutions for the Customers. The work includes addressing RFPs, work closely with the presales team for responding to RFPs and work on any specific POCs as requested internally/client, create reusable templates and guidelines for use by other project teams.
Highlights:
Worked on RFPs and address technical queries for Presales team/Client.
Provided initial estimation.
Participated in Client presentations.
Carried out POCs and internal tool development.
Co-ordinate trainings in Oracle BI
Project NameOman Insurance –OBIEE Implementation
ClientOman Insurance, Dubai
RoleTechnical Lead Consultant
PeriodJuly 2010 – Nov 2010
TechnologyWindows Platform, OBIEE, DAC, Informatica 8.1
Description This project aims at performing Siebel Analytics/OBIEE implementation for the following subject areas: Marketing, Forecasting, Sales and Service. End Marketing users wish to analyze the reports for Activities & Service Requests, Service Requests Trends and New opportunities/ Details of accepted & rejected leads. The project also focuses on doing customization of the vanilla reports and providing policy sales and service related reports as requested by the customer.
Highlights:
Provided initial estimate for OBIEE implementation.
Worked in UAT and production installation of OBIEE, Informatica and DAC Configuration.
Implemented Informatica vanilla mappings for Siebel Sales/Service/Marketing and Forecasting modules.
Worked in establishing DAC and Informatica Connectivity.
Tested the data in Warehouse tables and Reports.
Mentored the team on troubleshooting.
ProvidedProject Statusreporting to Satyam Management/Client.
Gave UAT Demo and resolved issues along with the team.
Managed the development team and handled day-to-day status calls and work assignment.
Obtained UAT Sign-off.
Project NameBI DW – EDW Strategy,Production Support & Testing
ClientEBS BI Competency
RoleSO Leader
PeriodNov 2009 to June 2010
Description BI DW – Production Support and Testing Service Offering addresses the support and testing need of the Customers. The work includes addressing RFPs, work closely with the presales team for responding to RFPs and work on any specific POCs as requested internally/client, create reusable templates and guidelines for use by other project teams.
Highlights:
Worked on RFPs and address technical queries for Presales team/Client.
Provided initial estimation.
Participated in Client presentations.
Carried out POCs and internal tool development.
Conducted training in BI DW testing which includes ETL and OLAP testing.
Project NameGM LFO (Lead Fulfillment Operations)
ClientGeneral Motors, USA
RoleProject Manager - Offshore
PeriodJune 2008 to Oct 2009
TechnologyOracle, PL/SQL, SQL Loader, Java, Unix, Cognos, Quick Rules
Description Lead management operations including the business processes and systems involved in sensing and responding to consumers who indicate an interest in GM products and services, in order to maximize sales opportunities. The vision is a Lead Management environment capable of responding to consumers with timely and highly personalized product information, in order to maximize sales opportunities. The Lead Management Data Processing solution maintains a high level of service, data integrity, and reporting.
Highlights:
Involved in Offshore Project Management.
Provided technical guidance to the team.
Addressed issues related to SLAs as well as conducted Project review meetings.
Inducted new team members and provided training.
Reviewed QA / Testing and deployed process.
Involved in CR Design/Implementation.
Project NameIFC - Informatica Support - Offshore
ClientWorld Bank – IFC,USA
RoleETL Offshore Lead/Manager
PeriodFeb 2005 to Apr 2008
TechnologyOracle, UNIX, Informatica 7.x, 8.x, Cognos
DescriptionInformatica ETL tool is used by many interfaces like ACBS, ICASE, MFA, CRR etc. to bring the data from many different sources like flat files, Sybase database and Oracle database. ODS uses Informatica tool to load data till the Staging area called ODSUPLOAD
Highlights:
Coordinated within the clients/teams.
Participated in ETL design/development/design and implementation.
Provide estimation for each module and monitored project status by tracking.
Prepared WBS for each module.
Provided Quality Assurance for DW and ODS team before client sign-off.
Provided training for peer vendors.
Provided delivery ownership fortwo modules from design till implementation and user acceptance.
Coordinated with the testing teams and successfully managed team.
Project NameSourcing Enterprise Data Warehouse (SEDW) Project
ClientDupont, USA
RoleETL ProjectLead/Data Quality Analyst
PeriodMay 2004 to Jan 2005
TechnologyOracle, Informatica 7.x, SAP BW
Description The purpose of the SEDW project is to extract vendor sourcing data at regular intervals from 26 disparate and heterogeneous order and invoicing systems scattered across the Global Dupont technical landscape. It also intends to cleanse, transform, consolidate and summarize data and to deliver meaningful and value-added reports to the users.
Highlights:
Reviewed technical documents such as Score Cards, L2 Specs and Test Cases.
Prepared design documents and error handling strategy.
Established communication with onsite team and led the conference calls.
Team Co-ordination and resolved conflicts.
Performed Change management.
Reviewed and testedthe mappings as well as coordinated within the team.
Project NameNBC Bano Showpay
ClientGE NBC, USA (in IGATE Global Solutions)
RoleProject Lead (Informatica)
PeriodJan 2004 to Apr 2004
TechnologyOracle, Informatica 7.x
Project description NBC wanted to find out the cost for various shows that are broadcasted to analyse the profits and also to analyse the difference in the payroll for permanent staffs and contractors as the data was coming from different sources partially showed some differences.
Highlights:
Preparedproject detailed plan and monitored the progress as per plan.
Participated in the design along with the onsite team.
Took part in the development of ETL (Informatica) mappings.
Prepared the UTP template and test cases.
Provided onsite-offshore coordination.
Involved in metrics collection, analysis and usage.
Project NameGEMS
ClientGE Medical Systems, USA (in IGATE Global Solutions)
RoleProject Lead
PeriodApril 2003 to Dec 2003
TechnologyOracle, Informatica
Description GE Medical Systems is involved in the manufacturing of medical equipments and installation of the same at various client sites in America, Asia and Europe. For GEMS, to know the medical equipments installed, their performance and to analyze the productivity measures, few analysis tools were developed. DFR – Design for Reliability is a tool developed to identify certain measures like MFR, IFR and RIS. This tool helps in reducing Engineers time spent compiling & analyzing data for monthly reporting of DFR Metrics (Mission Failure Rate, Infantile Failure Rate, and Repetitive Issues). It also provides faster correlation of DFR Metrics with Service cost data to identify high benefit productivity opportunities. SPAT – Service Productivity Tools Analysis was an existing tool, which was used basically to analyze measures like Labor Cost, FE Cost, Travel Cost and Hours, Install & Warranty Credits. This tool was enhanced to be used globally. Additional measures and reporting features were added to make the tool effective.
Highlights:
Worked extensively in Informatica and involved in analysis of the requirements.
Provided estimation and prepared project plan.
Involved in creating transformations, mappings and loading the DW tables.
Preparedtest cases and documented test results.
Monitoredproject status and updated the onsite PM about the progress.
Led the SPAT offshore team.
Project NameEDM
ClientVision Compass - Satyam Computer Services Limited
RoleProject Lead
PeriodJan 2002 – Mar 2002
Description Vision Compass is a Collaborative Enterprise Management (CEM) software system that aligns employee effort with organizational objectives. The user have to manually feed VC with data, which is a tedious process as the volume increases. This project aimed at building an automated system that would capture bulks of data from existing source systems, build a KPI data mart and feed VC. EDM has inbuilt generic KPI libraries for various industries. EDM KPI data mart aids in viewing the performance with a multi dimensional perspective. The various modules involved in EDM are KPI Library, Building MDDB Cubes, EDM – Mapping and Integration with VC
Highlights:
Prepared high and detail level design documents.
Coordinated within the team and conducted the reviews and testing.
Project NameSIFY
ClientSatyam Infoway Limited, Chennai
RoleTechnical Consultant
PeriodDecember 2001 - January 2002
TechnologyOracle Financial Analyzer
Description The Project aims at implementing OFA tool to pick up data from the GL module and provide the front-end reports for analysis.
Highlights:
Involved in the initial study including user requirement analysis prepared templates for data capturing.
Extracted data from Oracle Applications and created dimensions cubes hierarchies.
Carried out prototype development.
Project NameGECS
ClientGE Card Services, Ohio
RoleETL Consultant
PeriodAugust 2001 to Nov 2001
TechnologyUnix.Oracle,PL/SQL,SAS
Description The Project aims at populating the time of event dimension tables, dimensions and fact tables from the feed files on a regular basis using the client supplied SAS ETL software. The jobs are scheduled using the client-supplied tool called AutoSys need to monitor on a daily basis. The entire ETL process is completely metadata driven.The source feed file structure is studied and the metadata information is recorded in the oracle tables. The SAS ETL application utilities for extract, audit, transform, etc. are used to do the ETL process. The loading of data into the warehouse is done usingSQL Loader.
Highlights:
Involved in analysis of the specifications and requirements gathering.