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 driven by analyzing Customer Survey responses, Products, Issues, Contracts, Cost of Sever and various other touchpoints. These business insights highlight the gaps between customer expectation and our fulfilment. It helps CE Team / Executives in creating action plans to improve the Total Customer Experience. Includes Data Extraction/Transformation/Modeling, Visualization / Development of Tableau publications, advanced analytics, presentation materials and development of business recommendations.• 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, Development/Visualization of Tableau publication with 5,000+ active users.• 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 with 1000+ active users.• 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 huge amount of data.• 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 techniques and visualization improvements.• Awarded Dell Champion Award for Consistent performance and playing key role.

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.• Evaluate business process implications of system requirements and assesse possible redesign recommendations.• Create documentation and ensure readiness for all projects. Document business case analysis and assist in translating business requirements into process/functional design/system solutions.• Assist in the development of project plans including the creation of detailed work plans and timelines using project management tools. Work with project manager(s) to ensure the integrity and completeness of the solutions delivery process.

• 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.• Evaluate business process implications of system requirements and assesse possible redesign recommendations.• Create documentation and ensure readiness for all projects. Document business case analysis and assist in translating business requirements into process/functional design/system solutions.• Assist in the development of project plans including the creation of detailed work plans and timelines using project management tools. Work with project manager(s) to ensure the integrity and completeness of the solutions delivery process.

• 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).• Cost per Hire analysis- Business wise, Level wise.• Compensation per ration analysis.• Weekly Report to Directors and VPs of Current Hiring, Head Counts, Attrition and Pipeline statistics.• Vendor Management.

• 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.• Verbal communication with various countries for collecting data.• Running various SQL statements to fetch data from Database.• Title Mapping, using excel and SIEBEL applications.• Training the team members on Excel and VBA.

• 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.• Maintenance of all fabric outward to outside jobbers i.e. Finishers, Weavers & Fabric suppliers.

Pg Diploma In Data Science, Information Technology

Bachelor Of Science - Bs, Information Technology

10+2, Mathematics