Baskaran Swamiappan
Consulting Manager
Have over 20+ years of experience across Management Consulting relating to Enterprise Performance Management projects, in the areas of Planning, Budgeting, Forecasting and Management Reporting by implementing Hyperion Suite of Products and Anaplan. Have extensive experience in Data warehousing, ETL,EPM and BI Technologies. Have exposure to RPA. Personal Info
Phone
adbo83@r.postjobfree.com
www.linkedin.com/in/baskis
Skills
Project
Management
Resource
planning
Proposal Writing
Client
Engagement
Team
Management
People
Development
Hyperion EPM
(Essbase,
Planning,
Reporting and
HFM)
Anaplan
Database - Oracle
PL/SQL, SQL
Data Integration
Process
Automation
Experience
2012-11 -
present
Consulting Manager
Accenture USA/India
Project Details :-
Markel, USA - A Fortune 500 holding company for insurance, reinsurance and investment operations globally
Verizon USA - Fortune 500 holding company for insurance, reinsurance and investment operations globally
Stanley Black and decker USA - Consumer Products and Security company End to End EPM Project Implementation - Analyse, Architect, Implement and deploy of EPM projects for Budgeting, Forecasting and Management reporting With Hyperion EPM Tools, Oracle and Anaplan
•
• Data Integration, Process automation
• Proposal Creation, Client Presentation of Proposal Project Resource Planning, Project Plan and Project Delivery and Implementation
•
• Conducting Client Workshops, Creating BRD
• Managing Development and implementation Teams
• Managed Teams of Size 50+ for various projects
Managed a Offshore team of 5 delivering a comprehensive cloud based enterprise performance management solution (EBPCS) With driver- based rolling forecast and management reporting enabling the client with:
•
A Global planning application for increased business insight and forecasting capabilities
•
Driver based forecasting model with both quarterly and rolling 18 month time horizon
•
• Enhanced technology to address operational gaps and inconsistencies
• Full Integration and Automation With EPM Automate Lead for a Product line profitability system, providing data analysis, Data collection, design.
•
Build & deploy Integration and automation from different data source to Anaplan platform
•
• Data Integration from various Data store Using Data staging and ETL Developed a Comprehensive strategy for Upgrade of current Hyperion system from 11.1.X to 11.2.3 To take advantage of new enhancements that will reduce the Monthly Budget and reporting process considerably.
•
Delivery manager for Integration and automation of Data From ERP, Data ware house to Hyperion Budgeting and Planning systems Automation Comprising of 1000 + automation scripts, 3000 + automation scripts to manage the Business process calendar for the enterprise running their entire monthly budgeting ad Forecasting
•
State of California, USA - State Government
Time Warner USA - Cable television and Internet provider process.
• • Over all solution architect and technical Lead for a Business transformation Program for the State of California (one of the top 10 economies in the world)
•
Lead a team of 30+ developers/lead delivering a Public sector Planning Application for the State Government comprising of Hyperion Planning and forecasting application, ODI Development for data integration, Client engagement, Client workshops, deployment,go-live maintenance and Infrastructure setup and installation
•
• • Design and Implementation of a Customer behaviour Based Forecasting solution Using Hyperion Essbase, Netezza and ETL
•
2008-03 -
2012-11
Hyperion Lead
Coherent Inc - IT, USA
• Design and Implement Hyperion System 9.3.2 For HFM, Planning, Essbase and EMPA.
• Maintenance and support for the System 9.3 and system 11.1.1.3
• Coordinate with Business with modification, development and implementation of EPMA,HFM and Planning system
• Migrated Hyperion system 8.3 Hspu to system 11.1.1.3
• Maintain the Hyperion System including backup and recovery
• Develop, Test and implement Reports in Hyperion Intelligent system/ Interactive Reporting
• Support Essbase, HFM, Planning and EPMA System 9.3/ 11.1.1.3, Hyperion Interactive Reporting System 11.1.1.3
• Completed upgrade from system 9.3 to system 11.1.1.3 (Essbase, Planning, HFM and EPMA)
2001-07 -
2008-03
Technical Team Lead And Staff Analyst Developer
EchoStar Communications Corp., Denver, USA
• Database logical and physical design from scratch.
• Upgrade BRIO 6.x Reports to Hyperion 8.x reports
• Develop Complex Multidimensional Cube in Essbase, Dash Board Development in Analyzer and Web Analysis
• Provided technical support for Hyperion Portal Server during production support.
• Involved in design and development of Hyperion Dashboards
• Complex reporting Via Hyperion Integrating Data Form Oracle, Teradata, SQL server,Access and Excel sheet
Projects Involved:
• Repeat Caller – Determine No. of repeat Calls a CSR(sales Agent) receives in 76 Hour window.
• Customer Churn - Determine the Customer Churn by 13 different Dimensions
• Subscriber Count Analysis – Analyse the Subscriber Count on Daily Basis, giving the management a single view on the company performance by Customer Base (new customer, Disconnects, Upgrades and downgrades)
• Monthly Reporting for accounting -Delivering the monthly Accounting reports to the Accounting (150 out of 195 reports) that help them close the books every month without delay. Out of this I produce about 90 reports
• IVR reporting system - Developing custom reports using IVR data for a group of business
• Day to day Business reporting and helped Various Groups from doing reporting on excel and Access to a Automation of those which saved the company on Money Resource and man hours sent on creating report than analysing data for better use
2000-05 -
2001-05
Database and BI Lead
Caritasoft Inc
• Database design and development of Extraction, Transformation and Load
(ETL) for the CVM Suite back-end
• Development of a batch scheduler using Oracle DBMS_JOB.
• Integration of third Party Tool : SQL Email Server(Kumaran Systems Inc.,) for Electronic Campaign Management System.
• Building of Connectors that do the data extraction from various billing system into the CVM Suite, the Billing system involved are CSG and Portal’s Infranet, DST Invosis DDP SQL and Intele Cable
•Junior DBA in maintaining the Databases for Development and testing.
• Maintained and supported the Portal Billing system For Development and Testing of the CVM suite Applications
• I started as a contractor and got hired by the company as a reward of excellent Performance on Sep 2000
• Used Brio for reporting data out of Oracle
1995-06 -
2000-05
Programmer and Lead
Kumaran Systems, Inc, USA/India
Stared as a Programmer promoted to Project lead during my Time at The company working on various client projects
•
Developed Projects using SQL, PLSQL, Oracle database, Developer 2000 and Oracle reporting Tool
•
Migration of Old Oracle systems to Developer 200 systems that can run in GUI And character based Unix systems
•
Education
1991-04 -
1995-04
Bharathiar University, Coimbatore, India (Kongu
Engineering College)
• Bachelors in Computer Science and Engineering
2011-07 -
2013-04
Keller School of management, San Jose CA
M.B.A Management of information system
3.7 GPA