Rakesh Sharma Email & Phone Number

Bengaluru, Karnataka, India

Bengaluru Area, India

• Drive data engineering projects to enable informed business decisions for the Services organization. Impactful contribution to Customer experience group and executive management of the company with business insights.
• End to End development/Maintenance of Customer Survey Dashboard for CE Team and Executive Management. This includes Extraction of Survey data from IT Hub, Transformation, Logic building in Greenplum database.
• Resource availability and utilization dashboard for Customer Service partners to manage resources. Developed Alteryx workflow for ETL from SQL Server to Greenplum database, analysis & visualization of Tableau Dashboard.
• Work on Extraction of end-to-end services data from Greenplum/Teradata/SQL Server/Salesforce Cloud to Celonis Cloud, Transformation and building Celonis model for analysis.
• Involved in requirement gathering, development, testing and production movement of ETL pipelines to perform real time large scale of data processing using Python, PyCelonis, PySpark. Perform optimization while handling.
• Create/maintain objects (tables, views, functions) in Greenplum database for 20+ Analysts in team, building POC, analytics methodologies for development of analysis reporting. Assist/Train Analysts for analysis.

Bengaluru Area, India

• Provide analytical and statistical support within functional organization requiring interfacing with a broad range of cross-functional positions.
• Prepare reports for use in business planning and analysis for assigned area.
• Work on a variety of issues and may exercise independent judgment and recommendations in selecting optimum reporting and analysis techniques.
• Develop report specifications of data requirements and provide analysis to resolve business-related problems. Improve reporting processes whenever possible.
• Compile and prepare statistical data used in the analysis of operational performance of designated functional area.
• Assist in managing projects through completion including project tracking, monitoring, reporting and administration. Communicate project status through publishing high quality project reports and presentations.

• Provide analytical and statistical support within functional organization requiring interfacing with a broad range of cross-functional positions.
• Prepare reports for use in business planning and analysis for assigned area.
• Work on a variety of issues and may exercise independent judgment and recommendations in selecting optimum reporting and analysis techniques.
• Develop report specifications of data requirements and provide analysis to resolve business-related problems. Improve reporting processes whenever possible.
• Compile and prepare statistical data used in the analysis of operational performance of designated functional area.
• Assist in managing projects through completion including project tracking, monitoring, reporting and administration. Communicate project status through publishing high quality project reports and presentations.

• Reports Automation using VBA & Advance Excel Features.
• Manage and analyze recruitment, Attrition and current employee data.
• Develop database, tools to generate various MIS reports effectively in Access, Excel, and VBA.
• Generate Dashboards using advanced features of Excel and Power Point.
• Head Counts, Head Counts forecast and Attrition forecast analysis.
• Generating Hiring Metrics (Monthly, quarterly and yearly).

• Automation of all possible reports which are being processed manually using VBA & Advance Excel Features.
• Maintaining Global Database of Customer Information.
• Update and Uploads on database using SQL Loader.
• Weekly Report to all Managers and VP’s of Update and Upload statistics.
• Compiling & analyzing various excel templates which has to be uploaded to Database with advanced excel features and VBA Tools.
• Generating Reports using SIEBEL Answers.

• Update information and correspondents to Head Office.
• Exporting data from FoxPro and generating various MIS Reports for UPPER management.
• Maintaining (Fabric Export) data in M. S. Excel with Pivot Table, Macros and Advanced Features.
• Maintaining the fabric stocks and taking care of Inward & Outward through Inventory Control System.
• Coordinating with Branches as well as with customers.
• Filing of all ITM’s (Internal transfer memos) for auditing purpose.

Pg Diploma In Data Science, Information Technology

Bachelor Of Science - Bs, Information Technology

10+2, Mathematics