Satish Sankapal

Experience

• 

  Infosys

  May 2017 - Jul 2020

  Senior Process Executive

  • Transitioning reports and ensuring their operation, preparing standard operating procedures (SOP), and creating a checklist• Preparation of various simple/medium and complex reports on a weekly, monthly, and quarterly basis.• Setup (create new report formats based on requirement gathering) and providing ad-hoc reports based on the requirements of clients• Developing complex formulas and conditions to convert raw data into business information from various data sets for data analysis and reporting • Assistance coworkers by understanding their needs and guiding them through the use of MS Excel.• Created and maintained extensive reports in Spredsheets using advanced macros and database capabilities.• Prepared user guides by documenting the steps involved in the generation of various reports. provided snapshots and explained the calculations with examples identify the scope of improvement in report quality• Automate reports using macro• Maintain SLA - Timeliness and accuracy of reports generated in accordance with the agreement. Show less

• 

  WebDev Inc.

  Feb 2022 - now

  Data Analyst

  • I was responsible for wrangling financial data and building reporting.• Wrote advanced store procedures and views in SQL to enable more accessible data for reporting puroses.• Responsible for delivering business reports by retrieving data from SQL databases using T-SQL scripts and exporting analysed data to flat files and excel files.• Knowledge of analysing raw data, drawing conclusions, and developing recommendations, as well as writing T- SQL scripts to manipulate data for data loads and extracts.• Created automated excel documents for extensive data cleansing and analysis ,using data validation formulas , pivot tables.• Troubleshooting Stakeholders and the production team raised and requested issues with delivered visual reports, as well as other escalations.• Coordination with business teams for data integration, breaking down requirements into manageable chunks.• VBA macros development with SQL database functionality store procedures and views .• Designing, developing and implementing new functionality in excel VBA.• Whenever necessary, adding and modifying Store procedures, triggers, and functions.• Requirement gathering from client and system analysis.• involved in the software manual testing process before deliver to end user. Show less