Abhishek Sati

Worked on Audit & Assurance engagements to process large datasets, analyze unusual patterns in financial data provide insights using tools like SAS, Trifacta and internal tools developed by Deloitte.Worked on delivering Standard Tableau analytics to audit engagement teams.Lead number of Audit and Assurance engagements and worked with multiple teams to complete Audit and Assurance engagements.Creating documents for each Audit and Assurance engagements to capture results and insights from procedures performed using various tools and techniques.

Worked on Banking Client in Migration Project(TSM To PCO Migration).

Using advance SAS .EGP Project Changing Tactical View to Strategic view.

Maintaining three Different Set of code for Migration of each Schema Such as ASITIS ,TSM and final PCO.

Client Name : Google India Pvt Ltd (2017-Present)

• Wrote clean, clear and well-tested code for various projects such as Parent- Child Chain (Hotels), Partner Joining Match, Banking Credit Analysis, Customer segmentation, Customer classification, Geo-Map Analysis.
• Wrote Macro codes for daily maintenance activities and database Analyses.
• Tested troubleshooting methods, Macro debugging methods like Symbolgen, Macrogen, Mprint,Devised innovative solutions, and documented resolutions for inclusion in knowledge base for support team use.
• Rapidly prototyped new data processing capabilities to confirm integration feasibility into existing systems.
• Using Panda Library for Sanity Checks and Code Validation
• Developed SAS programs to generate analysis outputs as specified in the statistical analysis.
• Performed data and programmed validation to ensure the quality of deliverable meet internal standards.
• Provided training for using standard software and followed statistical programming standards.
• Provided technical assistance in solving problems related to the functioning of statistical software and other security-related system.
• Manipulated complex data sets using SQL and related techniques to develop efficient SAS code.
• Generated analysis data sets and conducted required study analyses.
• Presented analysis results in tabular and graphic formats appropriate for client presentation and publication.
• Assisted in creating project reports, documents and presentations.
• Performed quality assurance procedures on work performed by others.
• Deep knowledge of proc import,proc export,proc means,proc transpose,proc format,proc summary,proc tabulate,proc print,

proc compare,proc sql,proc append.

• Expert in base SAS programming,SQL and Macro's scripting for automation.
• Basic knowledge of python jupyter notebook and tableau.
• Worked on various project like Parent-child relationship(Hotels),Credit analysis(Booking.com),Google geo map,Star rating

analysis and development.

• Generation of day to day report, on monthly and yearly Basis by using ODS file system.
• Presented statistical programming expertise in SAS for the production of analyses, graphics and tabulations from travels

data.

• 1. GOOGLE HOTEL-ADS
  Project Objective – To make the Dashboard of the hotels present on the Google Search
  Engine with the filters as per the client requirement and Ad-hoc weekly and monthly
  reports .
  Insight – Google LLC is an American multinational technology company that
  specializes in Internet-related services and products, which include online
  advertising, search engine and hardware etc. And It always aims to enhance the user
  experience of its search results.
  And particularly this project Google Hotel-Ads is related to the analysis of hotels ads
  business. And through this business, Google charge its customer (advertisers) by
  posting their product, service or event ads on different hotels clusters as a per the
  geographical area . This project also helps in improving user experience in search
  results related to Hotels.
  Different Reports:
  -Hotels with maximum number of visits on their Google-ClusterID.
  -Current Status (Permanently Closed, Opening Soon, Opened Recently) of a Hotel.
  -Categorization of properties on the basis of their type.
  - Categorization of Hotels on the basis of Parent Chain and Child Chain
• 2. GOOGLE BAH-BEAUTY ADS HIGHLIGHTS
  Project Objective – To make the bi-weekly and monthly reports of Google –Beauty -Ads.
  Insight – Google Ads, formerly known as Google AdWords, turns the largest search
  engine on the internet into a marketplace for business owners to sell their goods to
  customers who are looking to make a purchase. Their main goal is to connect
  consumers with the best option based on what they are searching for.
  And this project caters only one Brand - L’Oréal .And it is the world's
  largest cosmetics company and has developed activities in the field concentrating
  on hair colour, skin care, sun protection, make-up, perfume, hair care and men's
  skincare .Through this project we help L’Oréal to plan, forecast and make decisions
  concerning their business. And this analysis can be done by evaluating the
  popularity of a particular product on the web