Shamli A Patil

Data Analyst

Summary

A self-motivated, detail-oriented Data Analyst, with above four & half years of experience in Data analysis and Database development, ready to leverage my skills & experience to become a positive asset to the organization. Experience

Associate Consultant - Data Analyst / Developer

Capgemini Technology Services, Pune, India 10/2019 - 06/2020 Responsibilities:

Analyzed business requirements, collected, cleaned & analyzed source data using optimized T-SQL procedure that reduced 30% of time, to generate business regulatory reports, & presented it with an interactive Power BI dashboard.

Developed automated report generation script using Python, that reduced 40% of time and manual efforts, required for extracting desired data and generating and formatting regulatory reports.

Automated sorting and resolving 200+ backend database connection files for incorrect connection details, by developing a custom UNIX Shell script that resulted in 70% time reduction for the task and published it on the confluence page for future reference.

Led end-to-end application deployment, during production activities, in an agile environment collaborating Q.A. and B.A. teams. Sr. Application Developer - Database Developer / Analyst BNY Mellon Technology, Pune, India 07/2017 - 09/2019 Responsibilities:

Collaborated with clients and program team, to understand business requirements, redefine goals, and estimate project timeline.

Collected and cleaned the data from multiple source system files using Python Pandas, and statistically analyzed business data to present useful KPIs through a compelling Tableau dashboard, which helped to avoid the loss of 15% of net credit exposure.

Developed and optimized ETL data pipelines for Data Quality checks & transformation. Extracted data using T-SQL Procedures & analyzed it using Advanced Excel Power Query for business reports.

Designed logical and physical data models, using ERWIN, to optimize the existing data model to improve accessibility by 20%.

Improved performance of a PL SQL package, by approximately 40%, by tuning the queries, using filters, indexes, Materialized Views & partitions on source tables, avoiding extra time required for full table scans of large data, to fetch data & generate reports.

Application Developer - Database Developer

BNY Mellon Technology, Pune, India 11/2015 - 06/2017 Responsibilities:

Introduced multiple functionalities for making required enhancements in traditional ETL process and fixing production issues, using PL SQL Procedures, Functions, Triggers, Cursors and UNIX Shell scripts and mentored 5 new joiners to team for the same.

Developed Python script to implement date check functionality used before 60% of file processing task of all the ETL workflow.

Automated the process to copy and deploy the file from source to target server region using Python functions, which reduced the time by 30%, to migrate and execute all the program files and documented the same for future reference on the confluence page.

Created Procedures & data pipelines to maintain built-in governance & metadata storing the important ETL process and error logs.

Coordinated with front-end design team, providing PL SQL Procedures to monitor the batch execution status of 250+ ETL jobs.

Helped another team to investigate & resolve a backend issue before production deployment, in a monthly data archival process. Contact number: 480-***-****

Email Id: adxj7b@r.postjobfree.com

LinkedIn: www.linkedin.com/in/shamlikale169a95

Skills

SQL (Oracle, MS SQL,

MYSQL)

MS Power BI

Python (Pandas,

Matplotlib, Numpy)

Tableau

Data Modeling &

Designing

Advanced Excel (Pivot tables,

Index match, Power Query)

Data Pipeline designing

& scheduling

ETL / DWH

Statistical analysis

(Descriptive, EDA)

Data wrangling & Data story

telling

Performance Tuning MS Power Point

Volunteering

Content Creator

Women Who Code 01/2023 - Present

Business domain knowledge

Article on best partner channel building techniques. Data Analyst Volunteer

Volunteer Match 03/2023 - Present

Gathered, cleaned and statistically analyzed the advertising agencies data using advanced excel to

predict profitable agencies.

Assisted the business management to predict the

profitable future investments through insightful

Power Bi dashboard.

Projects

Project: Sales Data Analysis to track, predict and improve future product sales 07/2021 - 09/2021

Link: (https://github.com/ASP-06/Data_Analysis)

Collected and cleaned a large dataset of yearly sales using Python Pandas and did Exploratory Data

Analysis to draw useful data statistics and predict sales of different products & their combination as per customer preferences.

Analyzed data using Matplotlib, to track the sales trend and provide business recommendations

resulted in 30% sales improvement.

Certifications

Data Visualization and Communication in Tableau

Coursera - 2022

Complete Python Bootcamp

Udemy - 2019

PL SQL Developer, Oracle Certified Associate (OCA) Oracle - 2018

Education

Bachelor’s of Engineering in Electronics &

Communications

Shri Ramdeobaba College of Engineering &

Management, India 07/2012 - 06/2015

Contact this candidate