Project Manager
Resume:
Kamini Ravinanthanan
Home Address
***, ********* **, ******, ** 08837
Phone: 732-***-**** . E-mail: ******.*************@*****.***
Education
B.Tech Electronics and Communication
Pondicherry Engineering College, Pondicherry, India, 2002
Work Experience
Worked with Cognizant Technology Services (CTS) as Senior Associate since
December 2002 till January 2011.
Skills Profile
. Operating Systems : Windows (NT, 9x, 2000, XP)
. Databases : Oracle 9i,10g
. Languages : Oracle PL/SQL
. Scripting Languages : HTML, XML
. ETL Tools : Cognos Decision Stream, IBM Data stage
. Reporting Tools : : Cognos 7 - Impromptu, Powerplay,
Transformer, Cognos ReportNet, Cognos
8.3 Suite (Framework manager, Report
Studio, Analysis Studio, Query Studio) and Hyperion 8.3 IR
Key Achievements
. DW DON of the Year (2009) for the outstanding contribution in DW space
. Three time award winner of DW Scope Appreciation award in 2004, 2006 and
2007
. Academy Appreciation Awardee for the Contribution to the Cognos
Courseware material for Entry level trainees
. Onsite Team Member of Schwan's RSG project which was awarded Project of
the year -Runner up in the year 2006
Projects/Business Areas
End to End execution and control of BO R2 to XI3 migration project for
PepsiCo USA(Oct 2010 -Jan 2011).
Provide Production Support and implement enhancement Hyperion 8.3 projects
for Toyota Motor Sales (Feb 2009 -Sept 2010)
Design, develop and implement Cognos 8.3 reports for Case New Holland, USA
(Aug 2007 - Jan 2009)
Design and migrate Impromptu 7.3 reports to Cognos 8.2 for Wallenius
Wilhelmsen Lines,USA (Mar 2006 - Jan 2007)
End to End Implementation of Data Mart solution for Network Appliances, USA
(Sept 2005 - Mar 2006)
Design, develop and implement web-based reporting solution using Cognos
Reportnet for Schwans Food Company,USA (Aug 2004 - Aug 2005)
Re Architect databases and reports in Impromptu 7.3 to centralized
databases for Wallenius Wilhelmsen Lines,USA (Aug 2003 - July 2004)
TPE IQ Media System for Saatchi and Saatchi,USA (Apr 2003 - July 2003)
See Appendix for project details
APPENDIX
1. End to End execution and control of BO R2 to XI3 migration project for
PepsiCo USA
(Oct 2010 - Jan 2011)
PepsiCo, Incorporated (NYSE: PEP) is a Fortune 500, American global
corporation headquartered in Purchase, Harrison, New York, with interests
in the manufacturing, marketing and distribution of grain-based snack
foods, beverages, and other products.
PepsiCo is a world leader in convenient snacks, foods and beverages with
revenues of more than $60 billion and over 285,000 employees. The primary
identifier of companies' main brands within the food and beverage industry
are those which generate annual sales exceeding $1 billion, and 19 of
PepsiCo's brands met this description as of 2009: Pepsi-Cola, Mountain Dew,
Lay's, Gatorade, Tropicana, 7Up, Doritos, Lipton Teas, Quaker Foods,
Cheetos, Mirinda, Ruffles, Aquafina, Pepsi Max, Tostitos, Sierra Mist,
Fritos, and Walker's.
PepsiCo BO Migration Projects involves 4000 odd reports to be migrated from
R2 to XI 3 in four phase manner in 6 months. The offshore development team
is in charge of conversion, migration and testing of the reports. Various
metrics and score carding like Effort turnover, Project scheduling,
Resource loading, % of Project completion by Application, % of UAT
completion and revised project plan needs to generated and shared with
Senior Management and Clients biweekly.
Roles and Responsibilities: Assistant Project Manager, responsible for
. Leading an Offshore team of 60 associates across 2 offshore
location (Chennai and Kochi)
. Providing single point of contact between Onsite and Offshore
teams.
. Resource training plan, QA setup and metrics planning.
. Document and share the best practice and Lessons learnt in
interactive mode.
. Score carding and Project planning.
. Tracking and Ensuring Quality reports by timely delivery.
. Forecasting overall resourcing and work projections
Team Size: Onsite - 5 & Offshore -60
Technologies: Microsoft Project Plan, BO R2, BO XI3, Oracle 10g
Work Location: Chennai, India
2. Provide Production Support and Implement Enhancement projects for Toyota
Motor Sales (from Feb 2009 - Oct 2010)
Toyota Motor Sales, U.S.A., Inc. (TMS) is the Toyota sales, marketing, and
distribution subsidiary devoted to the U.S. market. Founded in 1957 in
California, TMS currently employs more than 6,500 people. Its current
headquarters in Torrance, California supervises 14 regional offices.
TMS oversees sales in 50 states of Toyota, Lexus, and Scion products
through a network of over 1,200 Toyota dealers (of whom more than 900 also
sell Scion vehicles) and over 200 Lexus dealers.
TMS Production support project is an Application Maintenance project across
3 lines of business. Each Application has different business representation
and technology. As part of the engagement, we are supporting the
applications and resolving the tickets raised within the stipulated SLAs.
In addition to support, 6 new development projects are also undertaken and
executed successfully.
Roles and Responsibilities: Project Leader, responsible for
. Leading an Offshore team of 25 associates across 3 verticals
. Providing single point of contact between Onsite and Offshore teams
. Designing, Developing, Reviewing and Supporting project in Hyperion
reporting
. Forecasting overall resourcing and work projections
. Working on new proposals (Solution Approach, Staff Planning, and
Profitability Sheet) for Toyota
. Participating in Account Level initiatives like Innovation
Campaign, Process Audit and Recruitment
Team Size: Onsite - 11 & Offshore -25
Technologies: Hyperion 8.3 Intelligent Reporting, Oracle 10g
Work Location: Chennai, India
3. Design, develop and implement Cognos 8.3 reports for Case New Holland,
USA (Aug 2007 - Jan 2009)
CNH Case New Holland is a world leader in the agricultural and construction
equipment business.
Created in 1999 through the merger of New Holland N.V. and Case
Corporation, CNH is a global company, supported by 39 manufacturing
facilities in Europe, North America, Latin America, China, India and
Uzbekistan; 25,000 employees and about 11,500 dealers in 160 countries.
CNH brings together the knowledge and heritage of its four Case and New
Holland brand families, all backed by the strength and resources of its
worldwide commercial, industrial, product support and finance organizations
while offering customers the choice and specialization they expect from
each brand.
Performance Profile Management: It's a migration project from Mainframe
reports to Cognos 8. The requirements were complex as all the program
driven functionality has to be achieved using Tool based reporting.
Response time SLAs were aggressive and had to equal Mainframe SLAs already
in place. Complex functionalities and Performance considerations were met
by using Stored Procedures along with Java Scripts.
Roles and Responsibilities: Project Leader, responsible for
. Performing single point of contact for Offshore and Client
. Migrating Legacy Mainframe reports to Cognos 8, Web based reporting
. Building model using Framework manager and publishing the package
. Providing Value added functionalities to the reports
. Tuning the Cognos 8 reports for Performance SLAs
. Performing Regression Testing on Reports
Team Size: Onsite - 3 & Offshore - 11
Technologies: Cognos 8 Report studio, Cognos 8 Framework manager and Oracle
10g
Work Location: Chennai, India
Achievements:
. Won SCOPE Award (Internal Award to recognize Associates) for the
successful implementation of the project
. Nominated for the "Cognizant Business Intelligence Bond of the Year"
award. Result awaited
4. Design and migrate Impromptu 7.3 reports to Cognos 8.2 for Wallenius
Wilhelmsen Lines,USA (Mar 2006 - Jan 2007)
Founded in July 1999, Wallenius Wilhelmsen is the result of a merger of the
operating activities of Wallenius Lines of Sweden with Wilhelmsen Lines of
Norway. Both are well-established, family owned transportation companies,
known throughout the world for their reliability, quality, innovation and
personal service. Wallenius Lines began operations in 1934, and built the
world s first automobile-carrying vessel. In the 1960 s, the company
pioneered the Ro-Ro concept and became the first independent shipping line
to work with Japan s automobile manufacturing industry. Today, Wallenius
Lines major activities are the ownership and management of vessels. The
company is also part owner of a crewing and short-sea shipping company.
Wilhelmsen was founded in Tonsberg, Norway in 1861. The company, whose
roots date back to the 19th century ship-owning business, is a specialist
in Ro-Ro transportation. International liner activities comprise its core
business; however, it is also active in ship agency activities, heavy
transport and bunkering.
Headquartered in Oslo, Norway and Stockholm, Sweden, Wallenius Wilhelmsen
(WWL) is a market leader in ocean and inland transportation solutions. WWL
has a fleet of over 60 modern vessels and 600 transporters that ship over
two million vehicles shipped by sea and 1.5 million vehicles by road each
year
SAGA BI: It's a migration project from Impromptu to Cognos 8. Complete
analysis of the existing reports & requirements gathering were done from
offshore. A proposal for removing redundant reports, merging of reports and
building of new reports were provided. With the transactional database,
building of generic data model was challenging and we designed a robust
framework with all the best practices of Cognos 8.
Roles and Responsibilities: Team Leader, responsible for
. Analyzing the existing reports and preparing new design document
. Building model using Framework manager from the transactional
system and publishing the package
. Providing proof of concepts in Cognos 8 for Client Review & Signoff
. Resolving technical and business issues
. Migrating the Reports from Impromptu to Cognos 8 platform
. Performing Data Testing and System testing of the entire set of
Reports in the new platform
Team Size: Onsite - 1 & Offshore - 5
Technologies: Cognos 8 Report studio, Cognos 8 Framework manager and Oracle
10g
Work Location: Chennai, India
Achievements: Won SCOPE Award for the successful execution of the project
5. End to End Implementation of Data Mart solution for Network Appliances,
USA (Sept 2005 - Mar 2006)
Network Appliance (NetApp) is a leading vendor of innovative storage and
data management solutions that help organizations around the world store,
manage, protect, and retain their data. Headquartered in Sunnyvale,
California, NetApp is a member of the NASDAQ-100 and ranks on Fortune 1000.
CE Reporting: The Project has to integrate the Pre Order Data from Siebel
Application and Order Data from Oracle for Key Performance Indicator
calculation and build a new Data mart. The project was executed end to end
including Data Extraction, building Business Rules, Data Loading and Report
Generation.
Roles and Responsibilities: Onsite Team Leader, responsible for
. Gathering detailed requirements from the business users
. Analyzing the complete data flow for building a Data mart from the
Siebel system to Oracle
. Developing HLDs & LLDs for the Reports, ETL jobs and Data mart.
. Developing Framework model for the reports
. Providing support for Data Testing and System testing
. Resolving UAT issues
. Deploying the solution successfully in Production
Team Size: Onsite - 1 & Offshore - 5
Technologies: Cognos Framework Manager, Cognos Reportnet 1.1, IBM
Datastage and Oracle 9i
Work Location: Sunnyvale, California, USA
6. Design, develop and implement web-based reporting solution using Cognos
Reportnet for Schwans Food Company,USA (Aug 2004 - Aug 2005)
The Schwan Food Company (previously Schwan's Sales Enterprises Inc.) is a
leading foodservice supplier of multiple food categories. It has an annual
turnover of over 3 billion USD and has over 550 branches across 48 states
in the US. It employs around 6000 people and is the #2 frozen pizza maker
in the US (after Kraft foods).
The Schwan Food Company - founded in 1952 by Marvin Schwan is one of its
kinds where customers could get a variety of high-quality frozen foods and
dairy products. The scope of their services range from consulting in the
strategic uses of information technology, to system design, development and
integration, to outsourcing.
Ready, Set and Grow: It's a migration project from Mainframe reports to
Cognos Reportnet. We provided Proof of Concepts to the Client for
feasibility study and for the new functionalities available in Reportnet.
We prepared business extraction rules, designed the new reports and data
load processes.
Roles and Responsibilities: Onsite Coordinator, responsible for
. Gathering requirements and creating the Business Extraction rules
. Analyzing the existing Mainframe reports to design and develop the
reports in Cognos ReportNet
. Becoming an expert in the new tool and providing technical solution
to the offshore team
. Reviewing the reports and testing reports in test environment.
Team Size: Onsite - 8 & Offshore - 35
Technologies: Cognos Framework Manager, Cognos ReportNet, Cognos Impromptu,
Oracle 10g
Work Location: Marshall, Minnesota, USA
Achievements
. Won SCOPE Award for the successful execution of the project
. Got the "Runner Up" Award for the Project of the Year 2006 across all
projects in Cognizant
7. Re Architect databases and reports in Impromptu 7.3 to centralized
databases for Wallenius Wilhelmsen Lines, USA (Aug 2003 - July 2004)
Same as #4.
SAGA BI: The project was executed to centralize all the report servers
which were distributed worldwide. We were involved in analyzing the table
structure across different databases and proposed a consolidated database
schema. We were also involved in migration of reports to new schema and
testing the reports for functionality and performance.
Roles and Responsibilities: Team Member, responsible for
. Analyzing the existing reports and catalogs
. Creating a revised schema and testing the reports in the new
Schema.
. Adding Regional filters and prompts to certain reports identified
by the client
. Performing Data Testing and System testing of the entire set of
Reports that were migrated
Team Size: Onsite - 1 & Offshore - 5
Technologies: Cognos Impromptu, Powerplay and Oracle 10g
Work Location: Chennai, India
8. TPE IQ Media System for Saatchi and Saatchi,USA (Apr 2003 - July 2003)
Saatchi and Saatchi is one of the world's leading creative organizations.
There are over 7,000 Saatchi and Saatchi people in 138 offices in 82
countries. Annual billings are more than USD 7 billion. And they currently
work for 60's world's top 100 advertisers with a mission to be reversed as
the hothouse for world changing creative ideas that transform their
client's business, brands and reputations.
The TPE IQ Media System is intended for use by agencies that buy sports, on
TV for advertisements, to plan, package and manage advertisements
campaigns. A campaign may target specific may target specific 'Metro Survey
Areas (MSAs)' and specific demographic areas. The System helps to packaging
the campaign based on availability of spots, specific guidelines such as
day parts, programs and program types, program ratings and the budget .Once
the campaign is in flight the system allows for changes and prints various
reports that help in monitoring the campaign. The system also allows for
entry of invoices for reconciliation purposes.
TPE IQ Media System: This is an application maintenance project with issues
resolution and minor enhancements. The purpose is to rate the programs
telecasted and based on the ratings advertisement slots will be fixed.
Being a fresher to the account and technology, I scaled up to the
requirement and successfully developed a module in the application.
Roles and Responsibilities: Team Member, responsible for
. Performing Requirement study for specific modules
. Developing Stored Procedure in Sybase & developing UI in
PowerBuilder
. Preparing test cases and functional document
. Supporting System Testing
Team Size: Onsite - 2 & Offshore - 11
Technologies: Sybase, Powerbuilder
Work Location: Chennai, India
Contact this candidate