documentbi

Business Intelligence Consultant

EDUCATION

Bachelor's Degree in Computer Science and Engineering (4 Years), Government College of Technology, Coimbatore – 641 030

CERTIFICATIONS

Certified Project Management Professional by PMI (exp) Certified Six Sigma Green Belt with DFSS by Bank of America Certified Software Quality Analyst (CSQA) by QAI,FL (exp) Sun Certified Java Programmer (SCJP) by Sun Microsystems Certified Software Tester (CSTE) by QAI, FL Certified Winrunner ( basics) by Mercury Certified Estimator by TCS - E2 Internal certification on SAP BI – E2

EXPERIENCE SUMMARY

3 years of IT experience in open systems in the areas of design analysis, development & migration of applications, production support, maintenance and system testing.

3 years of IT experience in Quality assurance and process consulting 2 years of IT experience in managing Testing projects and Testing automation 3.5 years of IT experience in Project/Program management-PMO and PEG management for

a center 1.5 years of SAP BI experience in an implementation project & .25 years in enhancement

project.

Application Development and Maintenance

Requirement Analysis/System Design /Development Regression and System Integration testing Implementation /Maintenance Testing automation using Rational Functional Tester and Manual Tester Package Implementation SAP BI 7.0 Implementation/Fast Forward Deployment

Domain

Banking/Managed services/Trading-Orders processing Project/Program Management office (PMO)/Process/Testing

Technology

Client Server Model – Application Development and Maintenance SAP BI/BO ERP package implementation

PROGRAMMING LANGUAGES, SPECIAL SOFTWARE

of 15TCS Internal

Languages Java, C, C++, Pascal, SQL, ProC, Motif, ABAPTools / Workbench VB 5.0, OracleOperating System Windows 98, Windows 95, Windows NT, UnixSpecial Software IPMS, IRIS, Ultimatix, MQSeries, Formatter, FIX Protocol,

Oracle 7.1, Adex (Unified Modeling language), Robohelp, Rational testing tools – Functional Tester, Manual Tester, Test Manager, ClearQuest, TQAS, EQPortal, iEST, Impact, CMS, CRM, HP Test Manager

ERP Package Data Warehouse: SAP BI 7.0, BW 3.5ERP Applications: SAP ECC 6.0, SAP R/3Reporting Tools: SAP BEx Suite, Xcelsius (E1), Crystal (E1)

of 15TCS Internal

CAREER PROFILE

Aug 2012 to Till Date: Tata Consultancy Services Limited, Chennai

Project Enterprise Solutions – Delivery Support/COEClient TCS Internal

Period Aug 2012 - Till DatePosition Tools Deployment and Project SupportResponsibilities Fast Forward Testing Tool:

Deployment Support- ProjectsSAP BI:

HANA Basic training - E0 Project support – Process compliance and improvements ( Nielsen),

ABN Amro Proposals Support

The Project

Fast Forward is a TCS Internal tool for SAP testing. Support provided for deployment of tool across projects.

Also focuses on supporting the projects - mentoring on process compliance and improvements of delivery aspects.

Special Software Fast ForwardProject Location Siruseri - Chennai

May 2012 to Jul 2012: Tata Consultancy Services Limited, Chennai

Project The Home Depot Ranch Development Offshore - EnhancementClient The Home Depot Canada

Period May 2012 - Jul 2012Position SAP BI – Ranch Developer at OffshoreResponsibilities SAP BI:

Understanding Business requirement and feasibility in SAP BI Prepared Functional Specifications and Technical Specifications for

the enhancements – data flows/ report requirements, Development and Testing of the solution.

Enhancing the existing reports/data flows to the requirement

The ProjectThe Home Depot is a Retail customer; Had the implementation of SAP Retail, BI/BW/HANA; Ranch Project focused on enhancements of the existing dataflow and reports and small developments of BI reports/dataflows.

Languages ABAP (E1)Special Software ERP – SAP BIProject Location Digital Zone, Chennai; Toronto, Canada; Atlanta, US

of 15TCS Internal

Nov 2010 to Apr 2012 : Tata Consultancy Services Limited, Chennai

Project Spotless Springboard ImplementationClient Spotless Group Ltd

Period Nov 2010 to Apr 2012Position SAP BI Implementation Release 1 Project Lead - Offshore

Responsibilities Project Management: Project leader at offshore for managing the deliveries Transport control Test management and control of deliveries SIT and UAT support Planning, Tracking and reporting

SAP BI: Understanding Business requirement and feasibility testing in sap bw i.e.

Gap analysis Analyzing the SAP business content and activating its components to our

required fields Prepared Functional Specifications and Technical Specifications for the

report requirements Data Extraction (ETL): Expertise in OLTP extractions from SAP R/3 using

LO Cockpit. Also extracted data from flat files. Created Views, Data Sources in SAP R/3 for Generic Extractors. Data Source Enhancements.

Data Modeling: SAP Net Weaver BI architecture and BI Data Models. Customized metadata objects viz., InfoObjects, InfoCubes, DSOs (Standard/Direct Update/Write Optimized), DataSources, Transformations, Routines, InfoPackages, DTPs, and MultiProviders for designing BI Data Models.

Monitoring and Administration: Designed data load model based on dependencies and automated BI jobs using Process chains. Scheduling of data loads with Full/Initialization//Delta upload methods. Coordinated transport from Dev to QA to prod

Reporting and Analytical Processes: BEx Query Designer, BEx Analyzer, Conditions, Structures, Calculated and Restricted Key Figures, Character Variables, Formula Variables and Text Variables.

Reporting tools: Exposure on WAD template, Crystal report and Xcelsius published to portal

Performance Optimization: InfoCube management using database statistics, Compression, Partitioning

BW ABAP: Enhancements /Start/End Routines Functional (OLTP): General Functional knowledge of ECC system (SD,CS,

PS) and CRM Prepared Operational document for Golive and performed cutover tasks

SAP BO: Exposure on Xcelsius and Crystal Reports with SAP integration

The Project

Spotless is an Australian company providing various managed services such as Cleaning, Catering/Food, Facility Management,Laundry, etc. The Springboard program involves an end-to-end ownership of TCS for SAP transformation program in an industry that includes Program Management, Blueprint, Realization, Data Migration, Testing, and Implementation in Australia and New Zealand. The SAP modules implemented are CRM, SD, FICO, FSCM, MM, PS, CS, HCM, SRM, BPC, PI, Enterprise Portal and BI/BO

Languages ABAP (E0)Special Software ERP – SAP BIProject Location Siruseri, Chennai; Melbourne, Australia

of 15TCS Internal

Jul 2010 – Oct 2010 : Tata Consultancy Services Limited, Chennai

Project BFS2 PEG – CMMI Support Client TCS - Internal

Period Jul 2010 – Sep 2010Position CMMI Assessment Support and Process Improvement Initiatives

Responsibilities PA Gap analysis and Support projects for CMMI compliance for facing the SCAMPI assessment

Assist in PI activities with statistical models

The Project TCS is undergoing Enterprise assessment in Oct 2010. To provide support to the project teams with health checks

Process Improvement initiatives with statistical toolsHardware Windows 2007Languages NoneDatabase ExcelSpecial Software Minitab, TCS Statistical toolsProject Location Siruseri, Chennai

Jul 2009 – Jun 2010: Tata Consultancy Services Limited, Chennai

Project TCS Ecuador – Program Management Office (PMO)Client TCS Ecuador- Internal

Period Jul 2009 – Jun 2010Position PMO

Responsibilities Contract Management Supporto SOWs/Contracts/Change requests tracking

(contractual/Financial terms), Review of contractso Ensuring contracts are mapping the current projects and also to

income/cost center of financeo Follow with the sales team for the signing of contract and Ensure

BRMs/GLs upload the signed contacts ( CRM, CMS tool usage), Periodically Publish contract compliance dashboard

Organization Structure control and communication Support for Ultimatix Implementation: Organization of WONs with

mapping to contracts, WON creation, support in project value definition, Tracking of Ultimatix implementation plan

PAC Internal control - Approving/tracking SOWs and CRs, Coordination with customer PMO, in case of project management issues

Project Accounting: Ensure timely creation of WON’s. (Primary responsibility of PM’s), Work with the concerned PM/GL for defining correct manpower loading for the projects. (Primary responsibility of PM’s), Exceptional reporting

Finance: Track the billing and revenue projections.(Quarterly and yearly projections), Ensure timely billing by the PMs and GLs, Monitor that the projects are being executed within approved cost, Monitor and report the

of 15TCS Internal

profitability of the projects, Maintain and report delivery dashboard for all projects, Pre-empt the issue with proper tracking and monitoring, Monitor manpower utilization, Maintain receivables dashboard & reduce collection time, Own implementation of TCS tools and processes in delivery area

Management: Ensuring compliance to Corporate processes, SPOC for implementing all Corporate initiative, Interface between unit head and his/her direct reportees, Define PMO processes/website/Training material ( additionally added, as we don’t have now)

PreSales Support Formation and Coordination - Pre Sales Support coordination and Impact analysis coordination/Support

The Project The objective of project is to form PMO for TCS Ecuador, and establish controls on contracts, billing and supporting ultimatix implementation

Hardware Windows 2007Languages VB, iQMSWiki scriptsDatabase ExcelSpecial Software TQAS, Qportal, Impact, IPMS, IdeaMax, iEST, Ultimatix-CRM,

Finance Project AccountingProject Location Quito, Ecuador

May 2008 – Jun 2009: Tata Consultancy Services Limited, Chennai

Project TCS Ecuador – Process Excellence Group (PEG)Client TCS Ecuador- Internal

Period May 2008 – Jun 2009Position Process Excellence Lead – PEL – TCS EcuadorResponsibilities Formation of PEG, Definition of responsibilities and alignment to

Corporate Planning process deployment (iQMS) across the center and defined the

objectives Process definition and tailoring for the organization (as it is a special

scenario of running the whole Bank backend including IT, BPO and IS) Supported customer related processes for BPO and customer

meetings/coordination for deployment Process deployment support for all areas of

o IT Development, Maintenance, production support and consulting projects

o Support groups of Infrastructure, Security, Architecture, QA/Testing and Business SLA groups, other groups of HR, PEG, RMG, Admin, Sales Support, Supplier Agreement Management, RAG

o BPO areas of Factory and Call Center Process training for all areas Initiated Internal audits, PMRs and Final Inspections Supporting External audits Developed Knowmax website and iQMS Wiki Site for TCS Ecuador Process Assets Library management for all assets of TCS Ecuador Process deployment and coordination for preparation for ISO audit Usage of tools of TQAS, QPortal, IPMS, Impact, Ideamax, iEST Implementation of toolset

of 15TCS Internal

Defining BSC for the group and contributed for center – Implementing LeGo Processes

Tracking process deployment and reporting to corporate Act as a change manager for the acquired center

The Project The objective of project is to form PEG for TCS Ecuador, and deploy

iQMS processes across the center, aligned to corporate processes of TCS

Prepare for ISO audit for the center Move towards continuous improvement following TCS iQMS processes

Hardware Windows 2007Languages VB, iQMSWiki scriptsDatabase ExcelSpecial Software TQAS, Qportal, Impact, IPMS, IdeaMax, iESTProject Location Quito, Ecuador

Jan 2007 – Apr 2008: Tata Consultancy Services Limited, Chennai

Project Banco Pichinhca – Core BANCS ImplementationClient Banco Pichincha, Quito, Ecuador

Period Jan 2007 to Apr 2008Position Project Manager – Core BANCS

Responsibilities Planning for implementation and tracking the progress, issue resolution Intergroup coordination for requirements analysis – for system study and

functional specifications Conducting sessions on Project Management and implementation

lifecycle Offshore Coordination for development and technical specification Resource Management and Management of team (Peak Size of 10) Managing work allocation Planning training and Coordination for training

The Project

The objective of project is to implement BANCS as Core Banking Solution for Banco Pichincha and replacing the old Core Banking Solution, integrating with new tools of IBM-Portal, Middleware and BPM and existing Legacy interfaces

Focused on project coordination and support for training of new application for TCS Ecuador

Hardware Windows 2007Languages Unix CobolDatabase OracleSpecial Software BANCSProject Location Quito, Ecuador

of 15TCS Internal

Apr 2005 – Dec 2006: Tata Consultancy Services Limited, Chennai

Project Citi Cards TestingClient Citi Cards, Jacksonville

Period Apr 2005 to Dec 2006Position Internet Testing and Automation IT Manager

Responsibilities Onsite Coordination Conducting sessions on six sigma and Project Management Resource Management Issue resolution Management of Internet testing and rational automation team (Team size

– 32) Managing the server for Rational tools and database Implementing process improvements with reusables and lessons learnt Managing the work allocation and involved in system testing, regression

testing and UAT

The Project

The objective of project is to provide support for Citi Cards on testing their websites and the related systems. It is a card business domain involving testing on acquisitions, Bankcards and Private Labels, using Manual tester and Test Manager

And also focused on automating the manual testing using Functional tester

Hardware Pentium, HP –UX, Windows 98, Windows 95, or Windows NTLanguages VBDatabase SybaseSpecial Software Rational tools – Functional Tester, Manual Tester, ClearQuest, Test

ManagerProject Location Chennai, SNR/Ambattur , India

October 2004 – March 2005: Tata Consultancy Services Limited, Chennai

Project Software Process Improvement – Multiple Technology Process and Product Independent Verification (Multitech PPIV) – Bank of America

Client Bank of America, Charlotte, NC

Period Oct 2004 to Mar 2005Position Software Quality Assurance Manager

Responsibilities Onsite Coordination Process definition Performing support activities for SQA deployment/verification

activities Performing reviews Improving the six sigma awareness of the TCS team Conducting sessions on six sigma and Project Management Resource Management Issue resolution

The Project The objective of project is to provide process deployment and verification support for Bank of America from offshore

This includes process definition for the execution of the onsite offshore communication, execution of the activities, addressing

of 15TCS Internal

issues, offshore coordination, and deployment and conducting process verification activities. The project also includes the responsibilities of managing the SPI/SQA related resources in Bank of America relationship

Hardware Pentium, HP –UX, Windows 98, Windows 95, or Windows NTLanguages VBDatabase Access DatabaseSpecial Software Ultimatix, IRIS, IPMS, NIKUProject Location Bank Of America, Charlotte, NC, US

December 2002 – September 2004: Tata Consultancy Services Limited, Chennai

Project Software Process Improvement – Bank of AmericaClient Bank of America, Charlotte, NC

Period Dec 2002 to Sep 2004Position Software Process Improvement Process Champion

Responsibilities Process definition Performing support activities for SQA deployment Performing reviews, audits and writing reports Preparing and reviewing training material, Providing process

training Part of DFSS project for defining the estimation process Writing up requirements for SEPG Issue log,Development of

prototype for Issue log Voice of the customer for process tools Current environment assessment for SQA tool Participating in process strategy meetings Gap analysis and as-is analysis Process consultancy for piloting Caliber and Seer tools Defining processes using Design for Six Sigma Approach (DFSS) Performing CMM assessments as a Assessment Team member

(ATM) Defining scorecard and data collection Improving the six sigma awareness of the TCS team Conducting sessions on six sigma and Project Management

The Project

The objective of project is to provide Quality and process consultancy to Technology and Operations (T&O) group of Bank of America so as to get process maturity to SEI CMM Level 3.

This includes process definition and integration with Six-sigma change process, deployment and conducting process verification activities. The project also includes facilitating SEPG and SQA activities, mentoring and conducting process related trainings

Hardware Pentium, HP –UXLanguages Windows 98, Windows 95, or Windows NTDatabase VB, MS AccessSpecial Software Ultimatix, IRIS, IPMS, NIKUProject Location Bank Of America, Charlotte, NC, US

of 15TCS Internal

February 2001 – October 2002: Tata Consultancy Services Limited, Chennai

Project Financial Information Exchange (FIX) – Pershing Technologies

Client Pershing Technologies, New Jersey

Period Feb 2001 to Oct 2002Position Team Member – Developer/Analyst

Responsibilities Analysis of the Requirements Design – High Level and Low Level Coding and Implementation Testing – Unit and System Providing UAT Support Providing Production Support Enhancements and Redesign

The Project

Fix Link: It is a conversion of the Order messages from the correspondents in the FIX Format to PERSHING LINK format or ATOMS Format and vice versa resolving the problems faced in the existing system. Some preprocess and post processes are involved with the message received from either side. It uses MQSeries for the messages to be passed back and forth.

Hardware Pentium, HP –UXLanguages Windows 98, Windows 95, or Windows NT, UnixDatabase C, C++, Pro CSpecial Software MQSeries, Formatter, Rules, FIX Protocol, IPMSProject Location Pershing Technologies, NJ, US

of 15TCS Internal

November 2000 – February 2001: Tata Consultancy Services Limited, Chennai

Project Proprietary Trading System (PTS) – Pershing Technologies

Client Pershing Technologies, New Jersey

Period Nov 2000 to Feb 2001Position Team Member – Developer/Analyst

Responsibilities Enhancement Request for the compliance changes: Compliance Fix-Impact analysis, Analysis, Design, Coding, and Testing

Analysis of the existing code to understanding the logic Coordination with the UAT team for moving the changes to UAT

and UAT support Installation and understanding of Serena, Change management

tool Learning Motif and making some changes in the Front End

The Project

PTS Rewrite: Proprietary Trading System helps the traders in trading efficiently with a set of listed equities on the Cincinnati Stock Exchange (CSE). Rewrite is the Enhancement and Re-engineering of the existing PTS System to meet the customer additional requirements and enhancements, to improve the performance of the system and to provide good user interface.

Hardware Pentium, HP –UX, Windows 98, Windows 95, or Windows NT, Unix

Languages C, C++, Pro C, Motif, SerenaDatabase Oracle, PL SQLSpecial Software MQSeriesProject Location Pershing Technologies, NJ, US

of 15TCS Internal

March 2000 – November 2000: Tata Consultancy Services Limited, Chennai

Project Quality Assurance Group (QAG) Client TCS SNR Chennai

Period March 1999 – November 2000Position Quality Coordinator and IPMS Support

Responsibilities IPMS Support: To solve user’s problems with quick response

o IPMS Installationso IPMS Problemso Conducting IPMS Training when necessary.

Addressing SPARK Problems and Queries in IPMS Issues Database.

Oracle DBA Administration for IPMS. Support for IPMS Reports. Support for BIS. IPMS Presentation to the Clients

SEPG: Consolidating data from all the Projects at the center and Drawing

SPC charts, and trends. Analysis of the Outliers and viewing it on the Specification Limits.

Process Capability and Process Stability Analysis. DP Primes Training

QAG: Preparing QAG Status Reports and Deployment Reports. Attending Project Initiation and Project Closure Meetings. Project Plan Reviews. Facilitation to the Projects at the center. Logistics coordinator for the Quality Conference. PMR Scheduling Project Management Reviewer as a part of QAG. CBT Development for the CMM Awareness / SPC Awareness. Deployment of the CBT in the center. PRISM/CMMC Presentation Mentoring in estimation process

BAG: Auditing the Projects and raising Non Conformance reports.

The ProjectQuality Assurance Group aims at the deployment of the QMS Processes and Procedures across the Center. And it also aims in improving the Processes and Procedures to improve the productivity.

Hardware Pentium, Windows 98, Windows 95, or Windows NTLanguages Visual BasicDatabase SQL, OracleSpecial Software APT, Ultimatix, IPMS, BIS, IPMS Reports, IRISProject Location TCS, SNR, Chennai

of 15TCS Internal

August 1999 – February 2000: Tata Consultancy Services Limited, Chennai

Project Integrated Project Management System (IPMS) (Visual Basic 5.0, Oracle 7.1)

Client TCS Kolkatta

Period August 1999 – February 2000Position Team Member Responsibilities Designing Activities

Bug Fixing Documentation Activities Regression Testing IQA Developing help for the IPMS application

The Project The project aims at the development of an automated tool that automates the TCS Procedures, Processes and adheres to the TCS QMS.

Hardware Pentium, Windows 98, Windows 95, or Windows NTLanguages Visual Basic 5.0Database Oracle, SQLSpecial Software Visual Source Safe, MSOffice, IPMS,

Oracle 7.1, Adex (Unified Modeling language), RoboHelpProject Location TCS, Calcutta

of 15TCS Internal

COURSES/WORKSHOPS/PRESENTATIONS CONDUCTED

Year Title Presented to Location Organized By2000 DP Primes Training DP Primes SNR TCS, SNR2000 IPMS Training IPMS Users SNR TCS, SNR2000 Review, walkthroughs,

inspectionITP members Trivandrum Training group, TVM

2001 Financial Information Exchange Protocol

FIX Project members

Pershing, NJ Fix project

2003 SSP Detailed training Bank associates Bank of America, NC

Bank of America, NC

2003 Software configuration management training

Bank associates Bank of America, NC

Bank of America, NC

2003-2004

PMP training TCS associates Bank of America, NC

TCS-Onsite team

2004 Six Sigma awareness sessions

TCS associates Bank of America, NC

TCS, Bank of America account

2004 Bank of America Quality Conference

Bank associates Bank of America, FL

Bank of America, NC

2005 Quality workshop TCS associates SNR TCS, Citicards2006 Rational COE Workshop TCS associates SNR TCS, Citicards2007 Implementation Lifecycle-

BANCS TCs Ecuador Quito, Ecuador TCSEcuador

2008-09

iQMS – Detailed, Introduction session

TCS Ecuador Quito, Ecuador TCS Ecuador

2009 iPMS – Tool usage TCS Ecuador Quito, Ecuador TCS Ecuador2011 SAP BI TCS Chennai Chennai TCS

of 15TCS Internal

COURSES/WORKSHOPS/PRESENTATIONS ATTENDED

Year Title Location Organized By1999 ITP Trivandrum TCS, Trivandrum1999 SEI-CMM Calcutta TCS, Calcutta1999 VB 5.0 Calcutta TCS, Calcutta1999 Oracle (Enhancement in

Oracle 8) Calcutta TCS, Calcutta

1999 SQL Calcutta TCS, Calcutta2000 CMM SPC Awareness SNR TCS, SNR2000 Auditors Training SNR TCS, SNR2000 Six Thinking Hats SNR TCS, SNR2000 People CMM SNR TCS, SNR2001 VSS Pershing, NJ Pershing, NJ2002 SSP Detailed training Bank of America, NC Bank of America, NC2003 PMP Training Charlotte, NC TCS, BOA2003 Caliber RM Training Bank of America, NC Bank of America, NC2003 Seer estimation training Bank of America, NC Bank of America, NC2003 Six Sigma DFSS training Bank Of America, NC Bank of America2003 Assessment Team Member

(ATM) trainingBank of America, NC Bank of America

2003 Six Sigma – Green Belt training

Bank of America, NC Bank of America

2004 IQMS training Bank of America, NC TCS, BOA2004 Propel sessions Bank of America, NC TCS, BOA2004 Continuous Capability

Improvement (CCI)Bank of America, NC TCS, BOA

2004 SEI-CMMI Training SEI, Pittsburg, PA SEI, CMU2004-05 Java gym Charlotte, NC TCS Charlotte2005-06 Rational testing tools Chennai Chennai2006 IBM Rational conference Bangalore IBM, Bangalore2006 IBM Automation training Calcutta TCS, Kolkata2007-08 Spanish Language Training Quito, Ecuador TCS Ecuador2007 BANCS Quito, Ecuador TCS FS2008-09 ISO auditors training Quito, Ecuador Latam PEG2009 Estimation Training-iEST Quito, Ecuador Corporate Estimation

Group2009 ITIL training Quito, Ecuador Corporate IS2010 Advanced Statistics Training TCS Chennai BFS2 PEG2011 SAP BI/Xcelsius TCS Ahmedabad EntSol2012 Risk Management TCS Chennai TCS Chennai2012 Human Capital Mgmt/

Culture SensitizationTCS Chennai TCS Chennai

2012 HANA HA 300 TCS Bangalore Entsol-SAP

of 15TCS Internal

documentbi

Documents