Leo Martial A
Senior Analyst
Puducherry
Overview
1
1
Certification
2
2
years of post-secondary education
2
2
years of professional experience
Work History
Senior Analyst
Capgemini india services pvt ltd
Bangalore, Karnataka
05.2020 - Current
- I am working on various applications of Michelin Organization which is leading tyre based company located in France.
- Goal of this project is to forecast the data once in two months.
- Involved in brainstorming sessions to understand the business requirements.
- Hyperion Essbase, Hyperion Planning, Planning workspace, Smartview, Datastage and Oracle SQL are the major tools and languages used to achieve the goal.
- Back tracking of the data flow using sql tables in-order to find the schema where the issue has arisen.
- Worked with alias input files, Business Rules and creation of MaxL scripting for user access filters in cube and deletion of user from security file in very rare case if the user id got corrupted.
- Involved in creation of groups and adding filter to it in Hyperion Planning shared services and also maintaining the access users to it.
Analyst
Capgemini india services pvt ltd
Bangalore, Karnataka
05.2019 - 03.2020
- I had worked on development of RPCE application for PSA organization in France. It is used for forecasting the data related to production.
- Goal of the project is to deliver the project at end of each sprint as it is based on agile methodology.
- In order to achieve the goal, I have utilized Hyperion Essbase which is one of the modules in Hyperion EPM.
- Took lead in performing loading of rule files, alias tables and altering the structure of Accounts and Product dimensions.
- Involved in modifications related to calculation scripts and MaxL scripts.
- Debugging of critical issues under various difficult scenario's.
Analyst Intern
Capgemini india services pvt ltd
Bangalore, Karnataka
10.2018 - 02.2019
- Ability to understand the business requirements and Data models.
- Vast Experience in Oracle advance SQL Programming Using Analytical functions, Sub Queries, indexes and Set Operators.
- Proficient in creation, modification and effectively use of database objects like Tables, Constraint, Sequences, Indexes, Group Functions, and Views.
- Experience and Excellent Exposure in Query tuning using Materialized Views & Indexes.
- Involved in understanding the basics of PL/SQL Stored Procedures, Functions, Cursors, Triggers and Package.
- Troubleshoot and debug system and/or data errors.
- Trained in ETL tool(Informatica) and reporting tool(Tableau). Also good with basics of Python.
Education
10th Standard -
Petit Seminaire Higher Secondary School
Puducherry 06.2011 - 04.2012
12th Standard - Physics, Chemistry, Biology & Maths
Petit Seminaire Higher Secondary School
Puducherry 06.2013 - 04.2014
Skills
SQL
Certification
Oracle Essbase 11 Essentials
Timeline
Senior Analyst
Capgemini india services pvt ltd
05.2020 - Current
Oracle Essbase 11 Essentials
07-2019
Analyst
Capgemini india services pvt ltd
05.2019 - 03.2020
Analyst Intern
Capgemini india services pvt ltd
10.2018 - 02.2019
12th Standard - Physics, Chemistry, Biology & Maths
Petit Seminaire Higher Secondary School
06.2013 - 04.2014
10th Standard -
Petit Seminaire Higher Secondary School
06.2011 - 04.2012
Similar Profiles
VIKAS SHARMAVIKAS SHARMA
Success Consultant at Salesforce India Pvt. Ltd.Success Consultant at Salesforce India Pvt. Ltd.
Sundhara Vadivel Sundhara Vadivel null
Senior Technical Writer | at Digital.ai Software Pvt LtdSenior Technical Writer | at Digital.ai Software Pvt Ltd
ANUP KULKARNIANUP KULKARNI
Consultant(Sr. Test Automation Engineer) at Capgemini Technology Services India Pvt LtdConsultant(Sr. Test Automation Engineer) at Capgemini Technology Services India Pvt Ltd
JANSI RANIansi JEYAKUMARJANSI RANIansi JEYAKUMAR
SENIOR REGISTRED NURSE-ACUTE AND TRAUMA CARE-ER at GOVERMENT MEDICAL HOSPITAL AND COLLEGESENIOR REGISTRED NURSE-ACUTE AND TRAUMA CARE-ER at GOVERMENT MEDICAL HOSPITAL AND COLLEGE
Divakar C SDivakar C S
IOT Intern at SSP Engineering ServicesIOT Intern at SSP Engineering Services