Suresh Rajappa
**** ******* **** 972-***-**** H
Irving, Texas 75063 sureshvg@gmailcom √ 214-***-**** C
Seasoned, results-oriented professional. Broad background in complex inter-related project management in software development, data warehousing and on-site-offshore projects. Ideal balance between business and technology strategy. Committed to on-time, on-budget project delivery.
EXPERIENCE
PricewaterhouseCoopers LLC 2007 -- Current
Big 4 Management Consulting firm
Sr. Director – National Business Intelligence, Data Management (IM), CPM and Strategy Advisory Practice
- Multiple fortune 100 clients in Telecom (AT&T, Verizon) ,Energy(Exxon, PG&E), Healthcare (BCBS, Tenant Healthcare, VHA and Benefitmall ), Manufacturing (Trinity Industries) and High-Tech (Adobe, Autodesk, Microsoft)
• Responsible overall practice P&L and operations of 25 million per year
• Consulted as an interim CTO for a 200 people organization
• Managed delivery of multiple 3 + million dollar programs (from initiation. planning , execution, control and closure of the data management programs
• Developed data Management Intellectual Property for solution offerings, best practices and user conferences
• Developed relationships with vendors and corporate leadership
• Lead team in sales cycles, presented RFP and presented orals to win multiple projects in ERP, CRM, BI and Data management area
• Accountable for the scope, schedule, budget and delivery for data management technology investments in managing and leveraging Business Intelligence, CDI , MDM and EPM Projects
• Created and managed BI Strategy, BI Competency Center (BICC) and PMO
• Championed design sessions on Enterprise-wide BI architecture
• Created unique value proposition to the clients
• Developed a roadmap for successful implementation of Business / IT Strategy, Business Intelligence Strategy
• Designed and implemented VLDB Data Warehouse (~1.0 TB) from Strategy to Implementation
• Implemented Planning, Forecasting, Budgeting, IC Elimination, ForEx Translation. Minority Interest, SOX Compliance and Consolidation modules in OutlookSoft CPM / SAP BPC Solution suite and Hyperion Suite
• Hands on implementation on SAP, Hyperion and other leading BI, CDI, MDM tools
• In an advisory role, analyzed existing EPM System to do performance improvement, adding newer functionality and consolidate operations
• Used the Industry data and public data created a pricing strategy for utility organization for smart pricing for peak periods
• Used the customer data and marketing data, created a strategy for effective marketing whih eliminated 2 million USD for redundant marketing spending for a Consumer Products client
• Led the valuation analysis for a health care provider client during acqusion of a hospital chain in Portland,OR (Valuation methods used Cost Approach – Cost of Capital, Discounted Cashflow - pre and post acqusion, Sales Comparison Approach- EBIDTA, Income Capitalization Approach etc).
• Implemented Resource workflow thro’ portfolio management
• Directed staffing and budgeting projections
• Hired, mentored and managed project managers and technical team members
• Catalyst for cultural change, creating templates, policies, procedures and training
• Success milestones: Repeatable monthly estimating and on-going work tracking practices were implemented to monitor project progress and to meet significant delivery timeline changes. Manage Offshore/ Onsite / Offsite Resources of appx. 100
• Technical Platforms: Informatica, Data Stage, Hyperion planning and HFM and Essbase, Oracle, SQL Server and Crystal Reports, OutlookSoft CPM (SAP BPC including 5.1,7.0),SAP Strategy Management, Business Objects, Cognos Planning, ReportNet, transformer, SAP BW, Cognos and more
Accenture 2006 -- 2007
Industry leader in implementing Data Warehousing, CPM projects at Fortune 500 Clients
Practice Director (CPM /BI Practice)
Business Intelligence, Business Performance Management, MDM & CDI Projects:
- - JM Family Enterprises, BP, Microsoft, Trinity Industries, Verizon, ABN AMRO, Excellus BCBS, Taylor Woodrow Homes and others
• Managed, defined and created a Corporate Performance Measurement tool to build a data warehousing solution for finance and forecasting applications
• Interacted and managed expectations of C-level executives
• Responsible for defining the appropriate modeling approach as it relates to customer data
• Accountable for the scope, schedule and budget for technology investments in managing and leveraging Strategy, BI and CDI Projects
• Championed design sessions on Enterprise-wide BI architecture
• Designed and implemented VLDB Data Warehouse (>1.5 TB) from Strategy to Implementation
• Implemented Planning, Forecasting, Budgeting, IC Elimination, ForEx Translation. Minority Interest, SOX Compliance and Consolidation modules in Outlooksoft CPM Solution suite
• Initiated and implemented a project change management system, which was based within Rational Clear Quest. System was used to account for efficient project events (issues, changes, and risks) handling.
• Responsible for defining the appropriate modeling approach as it relates to customer data
• Created and Managed PMO from inception.
• Led the implementation of the Enterprise Information Management strategy for the corporate IT of BCBS.
• Directed business process improvement initiatives.
• Implemented Resource workflow thro Primavera portfolio management software.
• Developed relationships with vendors and corporate leadership
• Managed IT-related purchasing and budget usage; worked closely with accounting to develop budgets
• Directed IT staffing and budgeting projections.
• Hired, mentored and managed Project Managers and technical team members
• Catalyst for cultural change, creating templates, policies, procedures and training.
• Success milestones: Repeatable monthly estimating and on-going work tracking practices were implemented to monitor project progress and to meet significant delivery timeline changes.
• Technical Platforms: Informatica, Hyperion planning, Oracle, SQL Server and Crystal Reports, Cognos Planning and OutlookSoft CPM (SAP BPC)
Group Manager - Database Consolidation: VHA Inc, Dallas, TX ( Consulting position)
• Developed and managed a cross-functional (matrix) for implementing a standard for servicing the internal / external clients of mission critical databases mandates across multiple, integrated systems. Relevant project statistics: Costs $1.2M, Team Members 20+, Affected Systems 32+, and Impacted Users 12,000+.
• Enforced higher software development / DBA best practices quality standards to realize improved product definitions and requirements. Resulted in cleaner design, coding, testing, and implementation results.
• Success milestones: Monthly project budget to actual variance comparisons repeatedly met client required variance threshold of 2.00% (+/-). Comparisons regularly reported below 0.50%.
• Technical Platforms: Converted SQL Server 2000, Sybase Sys 11, Oracle81, 9i to Oracle 10g and Analysis Services Cubes to Cognos Power Cubes, Sybase Power Designer, Crystal reports, Brio Reports (Hyperion Intelligence) to Cognos Impromptu Reports
Outlooksoft Corp, Inc. 2003 -- 2006
Industry leader in Corporate Performance Management Software
Sr. Engagement Manager for Corporate Performance Management (CPM / BPM)
ExxonMobil, Bank of America, BCBS of North Dakota, Grande Communications, , GlobalEQ and other clients
• Managed, defined and created a Business Performance Measurement tool to build a data warehousing solution for finance and forecasting applications.
• Involved in creating detailed solution design and system development enterprise wide corporate performance management (CPM) initiatives.
• Set goals, establish priorities, manage resources, and develop concepts and approaches
• Implemented Planning, Forecasting, Budgeting, IC Elimination, ForEx Translation. Minority Interest and Consolidation modules.
• Worked as a Solution Architect and designed the overall BPM/ CPM solution. Actively participated in Architectural and Design meetings as SME / Technical Architect
• Customized Minority Interest using advanced logic to the needs of the customers.
• Created the implementation methodology (Summit methodology) for OutlookSoft.
• Success milestones: Repeatable monthly estimating and on-going work tracking practices were implemented to monitor project progress and to meet significant delivery timeline changes.
• Technical Platforms: OutlookSoft Everest / CPM (renamed to SAP BPC), SAP BW, Informatica, DTS(multiple clients), SQL Server and Oracle
CGI Management Consultants 1996 -- 2003
Liaison between technology and business for clients such as WebMD, Deloitte & Touche and Target
Project Manager / HIPAA Conversion: WebMD, Nashville, TN
• Mastered the usage of the client’s mainframe-based, existing Claims Processing System and migrated to HIPAA standards. Directed cross-functional, multi-year project plan for implementing government regulatory compliance reporting policy mandates across multiple, integrated systems. Relevant project statistics: Costs $2.2M, Team Members 40+, Affected Systems 5+, and Impacted Users 15,000+.
• Authored Project Management Office (PMO) to facilitate consistent project progress and unified tracking between multiple projects and separated software development groups.
• Led the team which helped make strategic decisions in releasing time-sensitive, business and end-user driven implementations which would ultimately determine the revenue of the company.
• Success milestones: Repeatedly met client required budget variance threshold, regularly reported below 0.50% and with one ranked at 0.00%.
Project Manager / Vendor Management System: Deloitte & Touche, Nashville, TN
• Excelled in a multi-year large VB.NET / SQL Server 2000 / XML / Crystal Reports software development project to manage vendors, consultants and partners.
• Emphasized Project Management Office (PMO) based practices, approaches, and standards to facilitate consistent project progress and tracking between multiple sites, separated software development groups.
• Relevant project statistics: Costs $2.6M, Team Members 24 on-site / 19 offshore, and Impacted Users 900+.
• Enhanced, senior management and managers’ ability to handle changes needed to migrate from a long-time software maintenance workflow environment into a “new” product software development environment.
• Success milestones: Completed with a cost savings of USD $90,000 and on-time delivery. Enforced, repeatable monthly estimating and on-going work tracking practices to monitor project progress and to substantiate significant delivery timeline change.
Project Manager / SalesMax: Target Corporation, Minneapolis, MN
• Completed a data warehousing effort to analyze and increase the sales of the target group’s retail stores. Relevant project statistics: Costs $3M, Team Members 31 offshore / 12 on-site, and Impacted Users 900+ and retail stores
• Performed approach and practice viability assessment of the existing project management efforts and applied work definition and flow changes to resolve long-term inertia and rework conditions
• Mentored vendors, offshore managers, end users and retail managers on the new platform. Architected the technical aspects of the database and data warehouse
• Success milestones: On budget delivery with a savings of 1.5 months.
Project Manager - Partnersonline.com / RMS: Target Corporation, Minneapolis, MN
• Completed a successful project effort to analyze and increase the productivity of the Target Technology Services, a subsidiary of Target Corp. Relevant project statistics: Costs $1.25M, Team Members 15 on-site / 30 offshore, and Impacted Users 360+ vendors.
• Redesigned work definition and flow changes to resolve obsolete methodologies.
• Initiated and implemented a project change management system to account for efficient project events (issues, changes, and risks) handling.
Tata Unisys 1993 -- 1996
Industry leader in implementing technology solutions to global Fortune 1000 clients
Senior Systems Analyst / Ford Motor, Detroit, MI
• Global Online Dealer DB - VB, SQL Server, Crystal Reports.
Systems Analyst / Unisys, Atlanta, GA
• Advanced Customer Enhancement and Financial Business App Customer View - VB, SQL Server, and Crystal Reports.
ADVANCED DEGREES & CERTIFICATIONS
Southern Methodist University, Dallas, TX
Executive MBA 2007
Kennedy Western University, Thousand Oaks, CA
PhD. in Computer Science (invented a new concept/ algorithm in Data Mining) 2002
OutlookSoft CPM (SAP BPC) Certified (version 4.1, 4.2 and 5) 2003, 2004, 2006
Project Management Professional, PMP Certification 2004
Six Sigma Green Belt Certification, Villanova University 2004
Microsoft Certified Professional Visual Basic, SQL Server 2000 / 2005 and Advanced Excel 2002
TECHNICAL SKILLS
Business Perf. Mgmt Tools (BPM): OutlookSoft CPM (4.0 /4.1/ 4.2 and 5), SAP BPC, SAP SM, Hyperion Planning, Cognos Planning and MS Performance Point
Project Mgmt Tools: Microsoft project 98, 2000, 2003 and 2007 Microsoft Project 2000 / 2003 Server
DW Tools: Cognos power play, MS analysis Services, Business Objects
Languages: ASP,.NET, VB.NET, XML 1.0, VBScript, JavaScript, HTML, Java, JHTML, COBOL, RPG
GUI: Visual Basic 6.0 / 5.0, Visual Interdev 6.0
Internet: COM/DCOM, MTS 2.0, ADO 2.5 / 2.1 ADO.NET, .Net Framework, ATG Dynamo
Tools: Visual Source Safe, ATG Dynamo 5.5 / 5.0, PVCS, Informatica 7.2 / 6.2 / 5.1
RDBMS: SQL Server 2005 / 2000 / 7.0 / 6.5, Sybase Sys 11, SQL / 400, Oracle 8i, Informix
Report Writer: Crystal Rpts. 10 /9 / 8. to 4.6, Crystal Enterprise 10 / 9, Brio, Cognos Impromptu
Servers: Windows NT / 2000 / 98 / 95,OS / 400 / IIS 5.0 / 4.0, PWS
Modeling Tools: Erwin 4.1 / 4 / 3.51, Visio