Data Analyst with 12+ Years Experience

Ashutosh Sharma

Data analyst

F i n a n c i a l A n a l y s t

Skill

My Contact

Work Experience

Education

B.E. in Electronics and Communication

Engineering, Jaipur Engineering College,

Jaipur, Completed in 2010

Phone +91-958*******

Web

************@*****.***

linkedin.com/in/ashutosh-sharma-41675693

Oct 2021 Paytm First Games

The Best Employee of the Year

Awards

MY SQL (9 Yrs)

Hive (5 Yrs)

Presto (3 Yrs)

Excel (11 Yrs)

AWS (3 Yrs)

Power BI (1 Yr)

Python (1 Yrs)

Strong analytical skills and experience resolving day to day business challenges with around 12+ yeas of experience in IT and 8 years as Data Analyst, Reporting in business intelligence, Bigdata for one of the largest Banking, Retail, Fintech and Mobile Gaming organizations.

Having hands on experience in translating the requirements into Business Requirement Documents (BRD) and technical solutions. Mapping requirements for internal and external stakeholders, performing analysis, QC the extracted data, automation of the reports and analysis on migration of data. Used to look after Financial Crime Surveillance Operations. Interacting with team members to ensure smooth progress of work to be done within TAT

Pofile summary

Coforge Data Analyst

March’23 - May’24

Perform the analysis of ad hoc requirements from internal and external stakeholders.

Mining data from primary and secondary sources, then reorganize the said data in a format that can be read by downstream systems.

Prepare the design document that holds information for data modelers, SQL queries for engineering team and report builder team.

Creating appropriate documentation that allows stakeholders to understand the steps of the data analysis process.

Report promptly to management and business partners regarding critical outages until resolution.

Client Wamart (Retail & Auto Care Center)

Client SEI (Banking)

May’24 - Feb’25

Migration of existing Reporting Layer to new Reporting Layer, to get the data near to real time.

Analyse the Report, sync with BA to understand the client specific reports, it's data, it's source and to understand all the fields and to figure out and segregate which column should be the part of the fact table and which should be the part of dimension tables.

Create the SQL query and share it with downstream. TCS Sr. Data Analyst

March’25 - Present

Financial Crime Surveillance Operations (FCSO): Led the migration of legacy and strategic data to create robust Data Enrichment Layer (DEL) products, enhancing the efficiency of financial crime monitoring systems.

Data Analysis & Logic Development: Analyzed existing business logic and developed new logic for financial crime detection systems, updated Confluence pages, and created SQL queries for downstream teams to implement. Fraud & Money Laundering Transaction Analysis: Conducted in-depth analysis of fraud and money laundering transactions by segmenting data across multiple categories, including customer, transaction, and account segmentations, to identify suspicious patterns.

Metrics Development & Reporting: Collaborated with the reporting team to develop key metrics, ensuring accurate representation of financial crime data for management reviews and decision-making.

Client Standard Chartered Bank(Banking)

Assisting clients for their queries and solve different technical problems. Ensuring product's efficacy by installing and operating equipment at sites. Preparing daily report/work on excel

Support Engineer

From Aug'11 to Feb'12 and April'14 to Jan'16

Perform Back-end activities, configure and upload the details of EDC (POS devices), configuring the bank details on Pine server for smooth transactions. Use SQL and prepares reports on excel as daily activity to evaluate daily track progress work done by field engineers.

Analysis of performed work at the end of every month. Compile data, prepare and share monthly / quarterly updated reports on PAN India as per the requirement by Senior Management. Used MY SQL for collecting all the performed work of field engineers, prepare the report on daily basis to keep a track on the work done by engineers, and share it with mangers, coordinators and TLs on PAN India. Jan’16 - July’18

Pine Labs MIS Reporting (Payment solution)

Compile, analyze, and report on customer acquisition, retention, and reactivation data Perform Basket Analysis (write complex SQL queries) Track transactions, GMV, users and many more parameters on regular basis Handling automated reports (use AWS for automation, language used- Python and SQL) and dashboard (use Excel and Power BI) which provides meaningful business insights for the business heads Upload the list of users on hive via S3 (AWS), shared by any team member on which analysis is to be done on some targeted users.

Mine large amounts of data (use OLAP) and extract impactful insights that influence the strategy for operations Coordinate with Data Engg. team for creation of Online Analytical Processing (OLAP) for smooth running of SQL queries Translating numbers, analyze users’ life cycle and Bucket analysis and share all findings for business Accountable for KPI reports

Monitor data ingestion processes and get in touch with other teams (eg DWH, China team) Utilized Google Analytics to increase the performance to fetch the numbers Ad hoc Analysis required by other teams for the retention of users and get the idea about the business and take the discussion accordingly

Creating and following processes to keep data confidential July'18- May'22

Paytm First Games Data Analyst (Online gaming)

Mine and Analyse technical issues and incidents for POS devices and generate actionable insights. Work involves analyzing Merchants transaction data, identifying process bottlenecks, business performance analysis etc. (Use SQL to extract the data) Present reports and interactive dashboards on Power BI. Used to look after the complex technical issues of POS devices. Configure POS devices on UAT server for testing purpose. Handle Payment related cases of merchants’ payment re-initiation, unsuccessful UPI txns, wallet txns and coordinate escalations and resolve in given TAT.

Responsible for all P0, P1 level of escalations. Create ADD-On Programs (Instant Discount) and test it on UAT. May’22 – March’23

Pine Labs Sr. Engineer (Payment solution)

Contact this candidate