PRAKASH PATIL

408-***-**** ● meygvo@r.postjobfree.com

*** ***** **** *** # **, Sunnyvale, CA 94087

SUMMARY

• Niche experience implementing Data Warehousing framework, Reporting/Business Intelligence with focus on constant process improvements.

• Excellent background in implementing IT systems from ground-up to go-live and stabilization.

• Specialize in unification of reporting framework to perform predictive and quantitative analysis, data mining and information discovery.

• Managed data warehouse/BI implementations in heterogeneous landscapes in ERP/non-ERP environment.

• Managed proof of concepts along with benchmarks for new technology solutions.

• Ability to partner with business and engineering teams to solve complex challenges, while at the same time focusing on the strategic goals and direction of the company.

• Promoter of Self-service analytics and sustainable support model with direct user involvement.

• Qualified recruitment and employee developments along with resource load estimations.

• Provided 360 degree view of business visibility by standardizing and consolidation of key business dimensions with initiative of centralizing and simplifying reporting landscape.

• Experience preparing Business cases, managing strategic programs and projects across geographically distributed teams.

• Experience preparing multi-year BI strategy with emphasis on best and next practices.

PROFESSIONAL EXPERIENCE

Trident Microsystems Inc., Sunnyvale CA

IT Applications Manager – Business Intelligence, EIS 2010 to present

Managed Enterprise Reporting/BI, Data Management, Executive Information systems (EIS), Security, ERP conversions, Project management, Staffing and project deliverable at Trident Microsystems Inc.

• Enterprise BI/Reporting roadmap: Preparation of enterprise reporting roadmap and proposal for physical implementations of unified reporting platform for company wide reporting needs. Includes user segregation by tools, Classification of reporting functions as per decision tree.

• Oracle OBIEE 10.1.3 POC implementation [BI Apps 7.9.6.2, ODI 10.1.3.2, Informatica PC 8.1.1]: Planned and successfully implemented Oracle reporting environment using OBIEE in minimal time with optimal resources. Oracle BI technology demonstration to VP of Operations and respective stakeholders.

• BBBR project: Outlined detail scope and analysis of BBB and revenue reporting for better business visibility. Includes project estimation, time line by project phase, resources requirements by skill set and final tangible deliverable.

• Trident Oracle ERP implementation project: As Track-lead on global Oracle implementation project, executed following visible sub-projects:

o Data Conversion, security and data masking, change management

o Corp master data management and cleansing

# ATMEL Corp. San Jose CA

IT Project Manager – Senior Business Intelligence Analyst 03/2007 – 08/2010

Managed SAP data warehouse and BI platform at ATMEL Corp. Significantly automated reporting infrastructure globally. Drastically reduced legacy reports for various application areas (45+) and migrated users to single reporting platform. Managed project budgeting, vendor management, project staffing, hardware/software infrastructure and project deliverable. Accomplishments listed as below,

• Data Warehousing – BBB: Accurate revenue estimation and segmentation: Successfully managed strategic BBB project with sole objective to standardize company wide BBB, revenue and margin reporting along with preparation of glossary of terms. Project included standardization of reporting business process and preparation of data warehouse objects to provide accurate revenue estimation and segmentation. Existing process involved manual steps in preparing revenue estimation with greater possibility of mistakes. Complex data and object level security is implemented based on agreement with security owners and C level decision makes. Project involved configuration of 9+ cubes along with 20+ KPIs. Object level security is designed based on geography, products and strategic accounts.

• ASIA Ship & Debit: Revenue Reserve implementation: Objective of the project was to move from traditional direct business (OEM) to channel business (distribution) in Asia region. Analysis included rationalizing key Asian distributors that add most value to the business and switch them to ship and debit process.

• SAP BI 7.0 Implementation Project: As part of SAP BI7 implementation and migration project, responsible for managing all techno-functional aspects of project, Incl. preparing project plan, activities, resource & time line planning etc. Specific activities included, pre-implementation study, sizing of infrastructure, evaluation of implementation approach, closely worked with SAP Basis team on installation of SAP BI product.

• Atmel CRM Quotations Analytics (P1): Designed and implemented Quotations analytics from Model-N CRM to staged schema in Oracle. Initiated project with Response Time analytics that involved tracking of delta response points in the quote life cycle from creation to closure.

• Atmel: SAP BI- Business Objects POC: Managed and implemented Business Objects proof of concept in Atmel BI landscape. Within a week time frame managed to build BO server, prepare meta data layer and implement key reporting using BO tools. Successfully delegated activities with Atmel, SAP and System Integrator resources and managed to produce key reports in tool Incl. BO Universe, Xcelsuis dashboard, WebI, Crystal etc.

# Synopsys Inc. Mountain View CA

SAP BI Lead (WWAS, HR, Fin) & SAP Technical Analyst 04/2001- 03/2007

Managed Data warehouse/Enterprise reporting infrastructure for three departments (WWAS, HR, Fin) at Synopsys Inc. Participated and lead many IT projects including fresh implementations and upgrades. Technology implementation includes Cognos suite, SAP BW, SAP CRM, Human resources BI etc. Managed to reduce many legacy systems and standardized on few. Simplified reporting landscape and provided greater visibility into corporate information.

• CRM-BW Engagement (pre-sales) tracking:

Engagement tracking (ET) project involved re-engineering and simplification of pre-sales business processes in SAP CRM and Data warehouse. System is configured to track client engagements, product benchmarks, defining master plans (internal & external). Apart from that, tracking the time spent on customer facing pre-sales activities and linking them to calls and bugs associated. Objectives covered part BW-Analytics includes providing Engagements and PLL (Product Line Lead) dashboard based on security profile, color coding in association of various pre-sales attributes, includes statuses (sales and technical), time spent on engagement & trends (winning/losing) etc. Another analytics initiative includes, providing time spent dashboard which has roll up and drill down capability to show time spent by customer activities (pro-active, reactive, pre-sales and consulting etc), by region, time spent on products etc.

• Managers Self Service (MSS) Analytics: MSS project involved implementation of reporting dashboard in SAP Business warehouse where managers and HRMs can see predefined employee metrics summarized based on SAP Info types for direct and indirect reporting employees.

• CRM Combined Time Analytics: Project provided true integration of time elements from SAP CRM (Part of engagements) for their customer focused activities, with human resources hierarchy in data warehouse. It helped compensation analyst save two week of works every fiscal quarter.

• CRM Skills Matrix and Availability Analytics: Skills and Availability matrix product project is developed for Synopsys global customer support center. Comprehensive dashboard is produced to display support engineer skills level along with future availability along with other key attributes.

• SAP CRM 4.0 & BW upgrade: Managed techno-functional upgrade. Responsibilities included feasibility study, fit gap and impact analysis on complete CRM-BW Configurations. Managed team of technical developers; implemented new CRM Service reports.

• Training and Events (TEM): Project included reporting of revenue generated from product training, evaluation of trainer, satisfaction surveys in corporate data warehouse.

• Financial Planning (Expense, PCP-Headcount, Capital): Project includes implementation of planning applications in SAP BW 3.1. Configured extractors in SAP R3 OLTP and SAP BW systems to populate the multilevel ODS (operational data stores) and Info Cubes.

• License Renewals: Managed implementation of installed base and license renewal applications in SAP BW 2.1C and Cognos suite. Data sources used to populate license renewal data mart are custom Installed base, Sales orders data, Price book information.

Avis-Cendant Corp, Long Island NY (Client of Integration Specialist Inc)

Cognos-Data Warehousing Consultant 02/2001 – 04/2001

Avis-Cendant Data warehouse reporting: Project includes multidimensional reporting and analysis of financial planning data. Budget and forecasting datasets from mainframe computers are used as source for data warehousing reporting project. Cognos macros are set to cut the cubes into regions and sub-regions. All the processes are automated using Geac Scheduler to execute and monitor the jobs.

Environment: Geac Smartstream 6.0 (Scheduler, Structures), Cognos (Impromptu 5.0, Powerplay 6.0), Sybase Sql Server, Windows NT 4.0, Sun Solaris CDE 1.2

eLance Inc (Client of Integration Specialist Inc)

Data Warehousing Consultant 07/2000 – 01/2001

eLance Web Traffic Analysis implementation: Project includes Web Traffic Analysis and Multidimensional reporting system for marketing, business development and Mgmt. team. Developed various reports for Campaign Tracking, Bid Analysis, Referral activity programs, Project tracking, Category Mgmt., Buyer and Seller information and User Acquisition channel reporting.

Environment: Oracle 8i, NetGenesis 4.6, Oracle Discoverer Suite 3.1.36.06 (Client server environment - Admin, User and Viewer editions and Web environment - User and Viewer editions), PHP3, Apache web server, Windows NT 4.0, Sun Solaris

EDUCATION

• M.S. (Computer Applications) - NM University

• B.Sc. (Bachelor of Science - Electronics) - NM University

PRAKASH PATIL

979 Pinto Palm Ter # 33-408-***-****

Sunnyvale, CA 94087 meygvo@r.postjobfree.com

Technology Exposure:

ERP, CRM, OLAP:

Oracle OBIEE 10.1.3.4 & 11g (BI Apps 7.9.6), SAP 7.1, SAP BW/BI 7.1, Oracle Apps EBS R12, SAP ERP ECC 5.0, SAP CRM 5, Business Objects, MS BI (MSIS, SSRS, MSAS), SAP SCM 5.1 (DP, SNP), Cognos suite (Impromptu, Power play, IWR), Informatica powercenter, Oracle Discoverer, Model-N 5, Peoplesoft SQR

Databases, Front end Tools:

Oracle 8.0, 9i, MS SQL Server 2008, Sybase, MS-Access, MySql, Mercury Quality Center 9.0 and Erwin 3.5, MS-Word, MS-Powerpoint, MS-Visio, MS-Excel, MS-Sharepoint, VB 5.0, Developer 2000

Operating Systems:

Windows 7.0, RedHat Linux, Windows NT 4.0, Sun Solaris CDE 1.2, Novell Netware 3.

Languages:

PL/SQL, ABAP/4, BSP, Turbo Pascal, Turbo C, Cobol, Lisp, Prolog, Occam, HTML, PHP4

Enterprise Applications exposure:

CRM (Pre-Sales & Service): Quote, Contracts, Design Registration/Opportunities, Ship & Debit

Sales/OM (Bookings, Billings, Backlog & Revenue), Distribution, POS, Margin analysis

Financials: Cost center, Expense Planning, Fixed Assets, GL, AP, AR

Supply Chain (SCM) Demand Planning & Supplier Network Planning

Human resources Personnel Administration, Org Management, MSS, ESS

Web traffic and click stream along with customer –product behavior analytics

Contact this candidate