SQL in Data Warehouses & RDBMS
Ankur Agrawalla
Product Specialist At Saviynt
Summary
- Cyber security professional having about 8+ Years of experience bringing abilities in Identity Access Management (IAM), Intelligence Development, Competitor Analysis and Data Trend Assessment.
- Had opportunity to work with #1 IGA Product Saviynt & Market Leading Agribusiness.
- Proactive and energetic in achieving targets by leveraging Business data and producing well planned recommendations & reports.
- Advanced Knowledge of Saviynt EIC, SailPointIQ, SQL, SAP BW on Hana and Apache Impala of Hadoop Ecosystem.
- Product Management of Scrum Development Team in Analytics.
- Career Aspiration to become Data & Security Architect.
- Completed Masters in Data Science from BITS, Pilani.
Overview
8
8
years of professional experience
7
7
years of post-secondary education
5
5
Certificates
2
2
Languages
Work History
Manager
KPMG India
Bengaluru
06.2023 - Current
- Handling RFP response, Resource Planning, Project execution, IAM Maturity assessment & strategizing business goals to enhance their maturity, solution designing & implementation.
- Performed the integration of SailPoint IdentityIQ with various systems, including DB (JDBC), Flat File and Webservice (API) based applications.
- Engaged with multiple stakeholders to gather and understand requirements.
- Managed and Mentored Teams on IGA Principles, Providing Guidance and Technical Leadership throughout the Project Lifecycle.
Product Specialist
Saviynt India Pvt. Ltd
Bengaluru
12.2021 - 06.2023
- Hands-on Experience with a Leading Identity Access Management Product.
- Responsible for "Intelligence"/"Analytics" module in Saviynt.
- Researched product's technical specifications and accurately communicated information.
- Worked with Engineering Leads on Development.
- Assisted with demonstrations for Product to showcase functionality.
- Liaised between customers and engineering to design new enhancements.
- Helped streamline repair processes and update procedures for support action consistency.
- Experienced with Jira for Ticket Management, Confluence for Documentation & Freshdesk for Customer Bugs.
Data Analyst Team Lead
Accenture Solutions Pvt. Ltd
Bengaluru
01.2021 - 12.2021
- Led many Development & Research based projects for Market Leading Agribusiness on Agile Methodology
- Created Complex SQL Queries
- Developed & Reviewed SAP Hana Views and SQLs for Errors & Improvements.
- Created Multiple Dashboards & Reports in Power BI & Tableau.
- Trained Data Analysts For Developments & Analyzing Skills.
- Built Path Flow for Archived Data From ERP to Hana & Hadoop Ecosystem. Created Sample Trend Based Reports on Top of Archived Records.
- Showcased Strong Domain Knowledge on many Business Process Like Trading {Contracts, Orders, Delivery, Billing}.
- Identified and Corrected Data and System Issues to Resolve Data Discrepancies.
- Optimized Many Data Flows For Faster Report Runtimes & Minimal Space Consumptions.
- Managed team of 15 employees, overseeing hiring, training, and professional growth of employees
Senior Data Analyst
Accenture Solutions Pvt. Ltd
Bengaluru
01.2018 - 12.2020
- Designed & Created Effective & Optimized SAP Hana Calculation Views in SAP BW on Hana.
- Configured SAP SLT Systems to Replicate ERP Tables to Hana.
- Written Multiple SQL statements within SAP BW on Hana & Impala Hue in Hadoop Ecosystem
- Automated Business Metrics Reporting Through Power BI & Tableau.
- Researched and Resolved Issues Regarding Integrity of Data Flow into SAP Business Object Reports
Data Analyst
Accenture Solutions Pvt. Ltd
Bengaluru
01.2017 - 12.2017
- Analyzed & Corrected SAP ABAP Based Custom Programs.
- Developed Smooth and Effective Flow of Data through SAP Data Warehouses for Better Reporting.
- Mapped Current Business and Operational Processes and Provided Recommendations to Clients for Improvement.
- Examined SAP ERP (Enterprise Resource Planning), SCP (Supply Chain Planning) & TM (Transport Management) Data Flows for Issues & Improvements.
- Provided Operational Support for High-Volume Data in 24/7 Uptime Environment.
Associate Data Analyst
Accenture Solutions Pvt. Ltd
Bengaluru
10.2015 - 12.2016
- Fixed over 100+ Defects & Incidents by Analyzing workflows of SAP Data Warehouse
- Created reports in SAP Business Objects.
- Improved operations by implementing change management process
Education
Masters of Tehnology - Data Science & Engineering
Birla Institute of Technology And Science
Pilani 10.2020 - 10.2022
Bachelor of Technology - Computer Science & Engg.
Kalinga Institute of Industrial Technology
Bhubaneswar 05.2011 - 05.2015
Senior Secondary School (CBSE) -
Guru Nanak Public School
Sambalpur 05.2010 - 05.2011
Skills
Data Intelligence & Reporting, Identity Lifecycle Management, Access Certification, Access Request & Identity Management, Policies, Roles for RBAC & Task Management in Saviynt EIC SailPointIQ
Workflow Development and Analysis, Data Collection and Transformation in SAP Data Warehouse Big Data
Data Reporting in Tools like Power BI, Tableau, SAP Web-i
Advanced SQL Developer
Understand, Assess & Improvement of Business Process & Reporting
Team Collaboration & Leadership
Product Demonstrations & Management
Certification
Saviynt L100, L200 & Sailpoint IQ Esstentials
Software
SAP BW on Hana & Hana Modelling (SAP Data Warehouse)
SAP Business Objects (SAP Reporting Tool)
SAP Landscape Transformation Replication
Big Data Warehouse (Hadoop)
Power BI & Tableau Reportings
SAP ABAP
SAP ERP, SAP SCM, SAP TM & Others
Timeline
Manager
KPMG India
06.2023 - Current
Product Specialist
Saviynt India Pvt. Ltd
12.2021 - 06.2023
Data Analyst Team Lead
Accenture Solutions Pvt. Ltd
01.2021 - 12.2021
Masters of Tehnology - Data Science & Engineering
Birla Institute of Technology And Science
10.2020 - 10.2022
Senior Data Analyst
Accenture Solutions Pvt. Ltd
01.2018 - 12.2020
Data Analyst
Accenture Solutions Pvt. Ltd
01.2017 - 12.2017
Associate Data Analyst
Accenture Solutions Pvt. Ltd
10.2015 - 12.2016
Bachelor of Technology - Computer Science & Engg.
Kalinga Institute of Industrial Technology
05.2011 - 05.2015
Senior Secondary School (CBSE) -
Guru Nanak Public School
05.2010 - 05.2011