Summary
Overview
Work History
Education
Skills
Certification
Experience Summary
Timeline
Generic
Ananth Palanivel

Ananth Palanivel

Program Manager
Bangalore

Summary

Ananth has over 24 years of experience with SAS, IBM, Dataiku, Dremio and Microsoft technologies. His main areas of expertise include Enterprise Data Warehousing, SAS Grid Computing, and Business Intelligence. He is also highly skilled in converting SAS programs to open-source technologies.

Overview

25
25
years of professional experience
2
2
Certifications

Work History

SAS Practice Lead

10.2022 - Current
  • Involved in all SAS Proposals
  • Providing Solution to the critical project team issues
  • Deep analysis of new project requirement and provide the necessary financial inputs
  • Organizing the entire SAS team
  • Identifying the SAS opportunities and provide the necessary guidelines.

Program Manager

Capgemini Technology Services India Limited
10.2005 - Current

Engagement Manager

10.2020 - 09.2022
  • SAS to Pyspark Conversion
  • Expertise in managing larger team size
  • Responsible for Metrics and Reporting - Weekly/Monthly Reporting
  • Responsible for an Engagement Manager and provide updates to finance and senior management
  • Providing Status updated to all the relevant stakeholders.

Engagement Manager

10.2020 - 06.2022
  • Building the AI/ML practice and Solutioning for Analytics estate modernization and AI/ML solutions for Customer First and Intelligence Industry
  • Leading several SAS Migration Initiatives across multiple Clients which includes:
  • Assessment of SAS Analytics estates including detailed inventory analysis for obsolescence and redundancy
  • Assessment of storage
  • Migration to target environments such as Python/Pyspark, Python Dremio, Dataiku, Python Big Query
  • Support for Production cutover
  • Support for decommissioning of on-prem servers
  • Responsible for Metrics and Reporting - Weekly/Monthly Reporting
  • Responsible for an Engagement Manager and provide updates to finance and senior management
  • Providing Status updated to all the relevant stakeholders.

Technical Manager

11.2017 - 09.2020
  • Ownership of the engagement for Open Platform Operations division
  • Delivers the resources required by the project team and monitors status of work streams.
  • Responsible for Metrics and Reporting - Weekly/Monthly Reporting
  • Manage the delivery of the work packets
  • Providing Status updated to all the relevant stakeholders
  • Capgemini team's shift plan, leave plan, training plan
  • Monitoring SAS Servers activity and administer logging platform for SAS Business Analytics
  • Manage SAS Servers and address it's up and running without issues
  • Regular Metadata Backups and maintaining Metadata Security
  • Responsible for monitoring CPU Usage, Disk Usage and System resources.

Technical Manager

08.2016 - 12.2017
  • Understand functional requirements and develop conceptual data model to map with business processes.
  • Prepared end to end bus matrix to link KPIs & PIs v/s. Subject Areas & Sourcing systems to gain complete traceability
  • Prepared logical data model for the subject areas in the scope
  • Prepared presentations for information architecture for client IT / Business reviews and confirmation
  • Interact with the Data Integration team to gain common understanding for data provisioning requirements for data store.
  • Prepared detail metadata and data dictionary for the logical data model for the ease of knowledge transfer to Data Management & Data Integration team.
  • Work closely with business / Sr. Database Architect / Sr.Data scientists to share common understanding and progress.

Data Migration Analyst

02.2017 - 07.2017
  • Scheduling the Rfuel Jobs in Active MQ and monitor the data load.
  • Data validation and reconcile the data as expected.
  • Assesses the source data quality and Identifies, documents and validates target data requirements.
  • Data preparation and cleansing the data as per the business requirement.
  • Development of SSIS package to provide the CSV files to business.
  • Involved in end to end testing of the migrated data.

Team Lead

10.2013 - 06.2016
  • Monitoring the SAS servers and SAS Environment for the stability of tool
  • Monitoring the disk usage for SAS servers.
  • Administering the different SAS applications like SAS EG, WRS using SAS Management Console.
  • Handled issues with SAS Metadata server, Object Spawner Workspace Server, Stored process server, Content server and Mid-tier components
  • Recovering the SAS metadata from backups in case of any unexpected failovers in the systems
  • Supported during the SAS Client installation during renewal of the SAS software.
  • Involved in SAS Server and Client License key Installation and patches/upgrades on users machine.
  • Tracking the incident management by incident category provided the necessary solution to the recurring incidents.
  • Created SOP and Operational run book document for performing regular and routine activity.
  • Managed the Maintenance Team and prepared and submitted the weekly status report and monthly decision governance reports to the stakeholders.

Team Lead

10.2012 - 10.2013
  • Requirement Gathering from client for the Churn, Cross Sell, CLTV and Segmentation data preparation.
  • Prepared Churn, Cross Sell, CLTV datamart.
  • Applied many transformations as per statistician’s request.
  • Base SAS, SAS EG, SAS/MACROS, SAS/STAT, SAS/ACCESS, SQL coding development.
  • Involved in Performance testing and optimized the code.
  • Prepared the PRD and Unit test Case documents.
  • Involved in Unit testing and peer to peer review.
  • Scheduling the reports and Models through Management Console.

Technical Manager

09.2011 - 09.2012
  • Development of Framework model and packages.
  • Developed various kinds of reports like List, Cross Tab, Chart and Drill through canned reports.
  • Applied necessary Filters, Prompts, Calculations, Summaries and Functions.
  • Created Prototype Reports.
  • Involved in Portal design and development.
  • Involved in Adhoc Report development through Query Studio.
  • Involved in the requirement gathering from functional users.
  • Prepared the FDD,TDD and Unit test Case documents.
  • Involved in Unit testing and peer to peer review.
  • Scheduling and bursting the reports through Event Studio.

Project Lead

06.2011 - 07.2011
  • Ownership of the engagement for Open Platform Operations division
  • Delivers the resources required by the project team and monitors status of work streams.
  • Responsible for Metrics and Reporting - Weekly/Monthly Reporting
  • Manage the delivery of the work packets
  • Providing Status updated to all the relevant stakeholders
  • Capgemini team's shift plan, leave plan, training plan
  • Monitoring SAS Servers activity and administer logging platform for SAS Business Analytics
  • Manage SAS Servers and address it's up and running without issues
  • Regular Metadata Backups and maintaining Metadata Security
  • Responsible for monitoring CPU Usage, Disk Usage and System resources.

Team Lead

11.2010 - 05.2011
  • Ownership of the engagement for Open Platform Operations division
  • Delivers the resources required by the project team and monitors status of work streams.
  • Responsible for Metrics and Reporting - Weekly/Monthly Reporting
  • Manage the delivery of the work packets
  • Providing Status updated to all the relevant stakeholders
  • Capgemini team's shift plan, leave plan, training plan
  • Monitoring SAS Servers activity and administer logging platform for SAS Business Analytics
  • Manage SAS Servers and address it's up and running without issues
  • Regular Metadata Backups and maintaining Metadata Security
  • Responsible for monitoring CPU Usage, Disk Usage and System resources.

Team Lead

10.2008 - 09.2010
  • The developed views based on the technical specification document provided by the DB team
  • Modified FM models and deployed client specific packages, using determinants, embedded filters, calculation query subject, star schema grouping and resolved loops.
  • Developed benefits specific generic reports.
  • Developed List, Crosstab, Master Detail and drill through reports.
  • Developed prompt pages using Search and Select, Value, cascading, date and reprompt.
  • Developed classes to in order to save time of the report development.
  • Performance tuning at Sybase, FM and report studio level.
  • Carried out Unit Test and peer to peer review.
  • Resolved SIT and UAT issues logged in JIRA (issue tracking tool).
  • Carried out change requests.

Team Lead

07.2008 - 07.2008
  • Gathered requirement based on the given KPI.
  • Supported during SAS Installation.
  • Building the Ad-hoc, Statistical Reports and Cubes.
  • Created three dimensional color maps to show data value variations with respect of an Indonesia area by using PROC GMAP procedure.
  • Distributed SAS reports via Email.
  • Creation of Stored process by using EG.
  • Creation of Cubes, Reports, Information Maps and Dashboard.
  • Publishing of the Reports on SAS Web Report Studio.
  • Designing the SAS IDP and Dashboard.
  • System and functional testing.

Developer

06.2005 - 08.2005
  • Requirement Gathering from the users.
  • Combine the data from different datasets into one main dataset.
  • Extracting the data from main dataset and filter the data on the basis of client and will be loaded in to the CDCI oracle table.

Software Engineer

Satyam Computer Services Ltd
11.2004 - 08.2005

Developer

05.2005 - 06.2005
  • Requirement Gathering from the users.
  • Analysis of the specifications provided by the clients.
  • Coding using SAS.
  • Testing- Integration and Unit testing.
  • Prepared Reconciliation report.

Developer

02.2005 - 04.2005
  • Understanding the business and its requirements.
  • Preparation Extraction, Transformations and loading the data into target table.
  • Developing the data mart by using SAS.
  • Testing –Integration and UAT.
  • Production Support.

Developer

11.2004 - 01.2005
  • Gathering project requirements from users.
  • Extracting the data and converted into flat files.
  • Testing –Integration and UAT.
  • Production Support.

SAS Analyst

Logik Systems
08.2002 - 10.2004

Developer

01.2004 - 09.2004
  • Conversion of raw data in to a SAS dataset.
  • Involved in regression analysis.
  • Used EFI to import the data.

Developer

08.2002 - 12.2003
  • Data preparation for analysis and Reporting.
  • Data Validation.
  • Used Proc freq, Proc Print, Proc Report, Proc append to identify the potential customer.

Software Engineer

Palpap Ichinichi Software International Limited
12.2000 - 06.2002

Developer

12.2000 - 06.2002
  • Designing and Coding in Security System Handling.
  • Designing and Coding in Library Management.
  • Dynamic Report Generation for the Exam Cell, Staff Management.

Education

Post Graduate Certificate in Senior Manager Program -

Indian Institute of Management

Bachelor of Mechanical Engineering - undefined

Bapuji Institute of Engineering and Technology
Davangere, Karnataka

Skills

Project Management

Certification

SAS Certified Base Programmer for SAS9

Experience Summary

  • Provided expert SAS solutions.
  • Led SAS BI practice for various clients.
  • Managed and mentored 165+ team members.
  • Expert in BI solutions and pre-sales activities.
  • Managed RFI, RFP, and RFQ life cycles.
  • Negotiated with third-party vendors.
  • Handled project budgeting and financials.
  • Specialized in SAS Migration Programs.
  • Expert in migrating SAS to PySpark, Dremio, Dataiku.
  • Worked on assessments, T&M, Fixed Price, and managed services.
  • Handled pricing and commercials in proposals.
  • Led SAS to cloud migrations (Python/PySpark, Dremio, Dataiku, BigQuery, Snowflake, SAS Viya).
  • Rationalized SAS inventory and datasets.
  • Strong BI tools, database design, and enterprise architecture knowledge.
  • Managed programs and projects (change, governance, risk, stakeholder, people).
  • Led SAS program modernization and sunset.
  • Managed 45-member team and executed two projects in parallel.
  • Developed reports using SAS, Cognos, Power BI, and Tableau.
  • Oversaw project management and finance forecasts.
  • Coordinated onsite/offsite resources for SAS, Power BI, RStudio.
  • Ensured service expectations were met.
  • Provided input for management reviews.
  • Presented improvement opportunities in reviews.
  • Managed contractual obligations and changes.
  • Performed quarterly project compliance audits.
  • Created and shared monthly project status reports.
  • Tracked and resolved recurring incidents.
  • Maintained SOPs and operational run books.

Timeline

SAS Practice Lead

10.2022 - Current

Engagement Manager

10.2020 - 09.2022

Engagement Manager

10.2020 - 06.2022

Technical Manager

11.2017 - 09.2020

Data Migration Analyst

02.2017 - 07.2017

Technical Manager

08.2016 - 12.2017

Team Lead

10.2013 - 06.2016

Team Lead

10.2012 - 10.2013

Technical Manager

09.2011 - 09.2012

Project Lead

06.2011 - 07.2011

Team Lead

11.2010 - 05.2011

Team Lead

10.2008 - 09.2010

Team Lead

07.2008 - 07.2008

Program Manager

Capgemini Technology Services India Limited
10.2005 - Current

Developer

06.2005 - 08.2005

Developer

05.2005 - 06.2005

Developer

02.2005 - 04.2005

Software Engineer

Satyam Computer Services Ltd
11.2004 - 08.2005

Developer

11.2004 - 01.2005

Developer

01.2004 - 09.2004

SAS Analyst

Logik Systems
08.2002 - 10.2004

Developer

08.2002 - 12.2003

Software Engineer

Palpap Ichinichi Software International Limited
12.2000 - 06.2002

Developer

12.2000 - 06.2002

Bachelor of Mechanical Engineering - undefined

Bapuji Institute of Engineering and Technology

Post Graduate Certificate in Senior Manager Program -

Indian Institute of Management
Ananth PalanivelProgram Manager