PRABU RAGUNATHAN
**************@*******.*** / 510-***-****
PROFILE SUMMARY
A seasoned Data-driven Analytics professional with overall experience of 17+ years in Business Intelligence, ETL, Data Visualization & Analytics, Solution Architecture and Project Management for major clients in Financial, Healthcare, Retail and Networking industries
Specialized on Business Intelligence, ETL and Reporting Technologies with extensive experience in all phases of Software Development Lifecycle (SDLC)
Hands-on experience with Tableau Dashboard, Data Exploration & Analysis, SAP HANA, Base SAS, Product Testing, Technical Support, Escalation Management, and Engineering/Professional Services
Over 6 years of experience in leading on-site projects on BI & Data at client locations for the global clients like Cisco, WellPoint Inc., Charles Schwab and BT Fleet
Adept at managing severe customer escalations and handling high pressure situations.
Extensive experience in requirements gathering, modeling, visualization, communication, and attainment of information technology initiatives for solutions development.
Excellent communication and interpersonal skills with a proven ability to build and maintain strong working relationships with various stakeholders and all levels of organization
Record of success in performing various roles such as BI and Tableau Analytics Consultant, Project Manager, Technical Lead, Individual Contributor, Mentor and Team Player
CERTIFICATIONS & TRAININGS
SAS Certified Advanced Programmer
Anaplan Certified Modeler
SAP HANA Development Studio Training
SAP Predictive Analytics Training by SAP
A Crash Course in Data Science - By Johns Hopkins University on Coursera
Introduction to Big Data and Cloud Computing Concepts – Coursera
Talend 6.2 Big Data Sandbox – Retail Recommendation and Sports Stats Demo projects
TECHNICAL & FUNCTIONAL SKILLS
SQL Server
Advanced SQL
ETL
MS BI
Oracle
Agile Methodology
Base SAS Programming
DataStage
SAP HANA
Requirements Gathering & Analysis
Tableau Design & Development
Software Development Life Cycle
Project Co-Ordination
Product Support & Testing
Team Leadership
Project Management
Reporting
Data Warehousing
Data Modeling
Data Visualization
Predictive Analysis
Application Development & Analysis
Project Costing
Technical Project Management
PROFESSIONAL EXPERIENCE
Client: CISCO SYSTEMS, San Jose 2013 - Present
Role: Sr. Data Analyst
Responsibilities:
Providing business analysis reports with key business insights to Business Leaders of WW Sales Strategy and Planning team, Global Collaboration Sales team.
My end-to-end responsibilities involve gathering requirements from the business stakeholders, suggesting the right solution, doing POC, procuring data from different source teams, data preparation, and visualization and presenting the solution.
Current project environment is using Tableau and SQL Server to address the requirements.
As part of presentation, my responsibilities include design and create Tableau reports and dashboards, design SQL queries and views, testing and publishing to production.
In my previous project, used SAP HANA to create Attribute Views, Analytics Views and Calculation Views, as well as Base SAS.
Overall my role involves both hands-on technical as well as co-ordination skills to
address the expectations of stakeholders.
Working with various business entity sales driving projects that provide key business inputs to business leaders.
Recently created dashboards that provide key business insights to collaboration related products like - YOY analysis, historic trend of bookings, and pipeline to bookings conversion ratio monitoring, customer analysis.
INFOSYS LTD. 2005 - 2013
Project Manager / Technical Lead
Client: Charles Schwab, San Francisco, CA, USA Oct 2012 to Nov 2013
Project Manager
$5M Marketing Solutions and Analytics project
Responsible for training the team on legacy application created using Base SAS, interfacing with Schwab teams to gather business requirements and translating to technical specifications, planning and tracking the new enhancement deliverables, customer support and handling escalations.
Client: WellPoint Inc., Richmond, VA, USA August 2011 to July 2012
Project Manager
Project: $10M Comprehensive Healthcare project
Responsibilities:
Organized and translated project and enterprise requirements into technical requirements that aligned with strategic corporate IT initiatives.
Managed project functions including project planning, control, resource allocation, costing, profitability, reporting, and day-to-day work allocation.
Designed Business Objects universe, ETL mappings and test plans for user acceptance.
Technologies used in this project are Base SAS, Business Objects and Informatica.
Client: BNP Paribas Cardiff, France, from Bangalore, India.
SAS Technical Lead of $15M Actuarial Profit and Loss Elaboration project
Responsibilities:
Along with managing the SAS development team, also involved in using Base SAS, owned coding of key modules, code review of team members, testing, release plan, maintenance of version, documentation, delivery to customer and resolution of customer issues.
Managed all phases of SDLC phases of development and maintenance projects.
Well experienced in performing POC, estimation, project plan, maintaining customer relationship, handling support requests and escalations.
Efficiently handled and mentored a team of nearly 10 in various projects
Hands-on experience with Base SAS, SAP Business Objects, DataStage, Oracle, SQL Server, MS BI.
Achieved CMMI Level 5 compliance in development projects.
Achieved Best Project Delivery Team Award
Attended internal trainings in technical and project management
NESS TECHNOLOGIES LTD., Bangalore, India 2003 - 2005
Senior Software Engineer
Worked in SAP Business Objects Development Center in various roles providing client support expertise to Business Objects, Inc. provided escalation management, case tracking and resolution, and overall client support across locations in India and France.
Customization of Business Object Application Foundation and Enterprise Performance Management solution.
Support migration for clients using Import Wizard from BO Classic version to BO XI.
Prepared product release plans, execution strategy, and pre-deployment testing across all environments
PSI DATA SYSTEMS, Bangalore, India 2000 – 2003
Senior Software Engineer
Involved in development and support of banking product Total Branch Automation for various Indian Financial institutions like United Bank of India, Central Bank Of India, Vijaya Bank and many Co-Operative Banks.
Individually went for implementation of the banking product in various parts of India for many branches of the banks.
Handled on-site customer support and escalations from the Head Office and Branches.
Developed key modules on deposit and loan modules using ESQL-C and Informix.
EDUCATION
Master of Computer Applications (MCA) – Bharathidasan University, India
Master of Business Administration (MBA) – Bharathidasan University, India