Nov 2020 – Jul 2022 · 1 yr 8 mos · Hyderabad, Telangana, India

• Financial analysis of Worldwide Selling Partner Support trends using SQL.
• Creating Automated solution for daily/weekly/monthly/quarterly analysis of company spends vs budget
• initiated on third party resources. (Saved 20 hrs of manual work)
• Identifying areas of errors and creating automated measures to track and rectify errors in the most
• efficient way using Python, SQL, Crontab, R and Datanet. It helped to resolve the errors before it went to
• reporting and providing 100% accurate information to the users.
• Meeting with clients and collaborating with other teams to get deep level information about the business
• and creating elaborated and granular level information to the customer which helped in making critical
• decisions Worldwide.
• Created web-scraping code to reduce the manual work of downloading the latest data uploaded to the
• portal and creating automated reporting channel to Excel feed. (Saved 16 hrs job done by 2 analyst and
• with accuracy)
• Created one single report out of multiple reports and from multiple sources which has decreased the
• manual effort as well as tracking of multiple emails, web-portals, shared drives etc. Now customer has all
• data in most clean format with accuracy and with no manual effort involved to perform the analysis.
• Created checks in place with automated alert emails in case any of the data from all sources is missing or
• not updated. (Decreased 20+ hours of manual work per month to 2-3 hours per month)

Jul 2019 – Jul 2020 · 1 yr · Gurugram, Haryana, India

• Customer analysis of Global Commercial Services (GCS) of corporate credit card customer trends using Python, HIVE, SQL.
• Analyzed business requirements and provided end to end solution design of data metric about Risk initiated accounts using Python and HIVE. (Received recognition from Director and VP for transformation and automation)
• Growth and Loss Analysis of corporate cards expenditure using Hive, SQL and Python. (Achieved 100% accuracy by automating report using Python and reduced 30 working hrs to 2 hrs per month)
• In-depth analysis of incentive calculation, Target attainment and Scorecard (Performance analysis) of sales boosting attainment by 11% (Accelerated delivery of reports by automation and increased accuracy)
• Automation of monthly and daily reports using Python (80% reports automated, reduced time from 80 hrs to only 6 hrs per month)
• Working on Yellowbrick like new tools to make statistical calculation easier and faster.
• Meeting with Business for understanding business perspective and developing use cases for delivering useful insights which can help in deciding about what products are needed to be shut and deciding new approaches.

Oct 2018 – Jun 2019 · 8 mos · India

• Projects worked on and accomplishments:
• 1. Analysis of market areas with high/low customer-merchant involvement using Hadoop cluster data via Hive queries and developing new strategic plan. (Increased customer involvement by 5%)
• 2. Creating and running daily Hive queries for new campaigns launched and analysing current as well as future trend in segmented market areas.(Increased transaction by 25% for new campaigns)
• 3. Fraud check analysis- Deciding the logic to find Merchants doing fraud transaction only for getting cashbacks checked and blocking them. (Reduced cost burn by 30%)
• 4. Insurance Sale Analysis- Analysing sale of insurance for FTD as well as MTD. Checking sale growth, GMV growth, Executive level effort calculation etc.. Deciding and calculating incentives for the Executives. (Increased sale by 8% as per YTD and new products launched)
• 5. Automating daily data analysis reports using python as programming language and HIVE as Query language.
• 6. Creating AWS S3 buckets for bulk data analysis and loading data using Hive queries.
• 7. Automating Hive queries using Ooziee workflow scheduler.
• 8. Automating email attachment of dynamic data request using DEHLEEZ.
• 9. Working closely with marketing team to understand the business and then preparing fragments of queries for data which can help in deciding day to day business Cascades.

Nov 2016 – Oct 2018 · 1 yr 11 mos · India

• Working with MySQL and Hadoop for below mentioned daily dynamic tasks on Telecom sector (National and International) Data (BIG DATA) :
• 1. Successful interpretation of data to draw conclusions for managerial action and strategy.
• 2.Developing Stored procedure in MYSQL for data fetching and performing calculation as per Business Requirements.
• 3. Handling data in GB and TB sizes.
• 4. Optimization and archive, MYIsam
• 5. Using HIVE for data storage,loading,fetching,calculation and manipulation from Hadoop cluster
• 6. Using Excel functions to generate spreadsheets and pivot tables.
• 7.Working ETL of data from circle servers to our central servers and then final loading at Hadoop cluster.
• 8. Data maintenance and Root cause analysis
• 9. Writing SHELL scripting for automation
• 10. PYTHON programing for various Data requirements and their presentation.
• 11. Using SAP business object for MIS purposes
• 12. Business analytics using data

Dec 2015 – Aug 2016 · 8 mos · Greater Noida

• Below are the tasks performed during 8 months of Internship:
• 1. Update of running software using C# .Net
• 2. Successful Development and deployment of Live Web application named "Minutes of Meeting" from scratch for HR department in C# .Net and SQL Server.
• 3. Performing Testing and Validation from all aspects in order to deliver a bug free software.
• 4. Successful development and deployment of Live Web application named "Part Master" in C# .Net for tracking of Parts generated at the firm.
• 5. Working closely with respective teams in order to deliver a software which covers all aspects of requirement from the user.

Jun 2015 – Nov 2015 · 5 mos