Nishant Sharma
New York,NY
Summary
Proficient Analytics professional with a Computer Science background and over 5 years experience translating business requirements into robust and resilient data products
Overview
6
6
years of professional experience
1
1
Certification
Work History
Manager, Analytics & Innovation
Warner Bros Discovery
New York
06.2023 - Current
- Built an optimized datamarts within snowflake for effective data analytics and reporting on journal entry fraud detection.
- Utilized Power BI's data visualization capabilities to present complex financial data, resulting in a 15% reduction in financial reporting time and a 10% improvement in budget accuracy.
- Currently training and deploying a decision tree classifier to detect fraud in invoices data.
Sr Advisory Analytics Consultant
Deloitte
Washington DC
06.2022 - 05.2023
- Built Audit Risk assessment data product using Python and Power BI for large bank in california, this tool pulls applications and thier attributes from multiple data systems and ranks them as per auditor's criteria leading to 25% improvement in IT auditing time.
- Automated ETL from SAP ERP to Snowflake tables by using AWS S3 as staging layer and improved data ingestion time by 15%.
Analytics Engineer
Even Financial (Acquired by MoneyLion, Early 2022)
New York
08.2021 - 05.2022
- Built optimized OLAP data models in dbt that lead to improved looker dashboard load times by over 30%.
- Used Talend and Airflow to build ELT pipelines used for data ingestions in AWS redhsift.
- Deployed containers into AWS with CI/CD processes.
Data Analyst
Arch Capital Group
Washington DC
06.2019 - 08.2021
- Designed and developed Power BI based visualization solutions to analyze Credit risk transfer securities.
- Designed and Built a star schema model in Power BI to effectively analyze macro economics facts and dimensions.
- Optimized SQL Queries to generate computed insurance metrics used to analyze weekly mortgage performance.
- Improved performance of internal cashflow engine(used to analyze over 1B in securities) by using Pandas based vectorization techniques that increased the computation time by over 22%.
- Implemented a gradient boosting regressor package to improve the accuracy of macro economic forecasts by over 25%.
BI Developer
Amida Solutions
Mclean
02.2018 - 05.2019
- Calculated RFM scores for every customer using the e-commerce site and segmented them using K-means clustering, which lead to 15% increase in average order value during the last 4 months.
Skills
- Snowflake
- Power BI
- Python
- SQL
- R
- SAS
- Scikit-learn
- Pandas
- Numpy
- Matplotlib
- Seaborn
- Tableau
- MS SQL Server
- Airflow
- DBT
- AWS EC2, Glue & Redshift
- Google Cloud Platform
Education
- Master of Science : Business Information Systems, New Jersey Institute of Technology ( Cross-reg w Rutgers Business School)
- Bachelor of Science : Computer Science, Manipal Institute of Technology
Certification
- Microsoft Certified: Power BI Data Analyst Associate (PL300)
- DBT Fundamentals
- Udacity Machine Learning Engineer
- AI for everyone, Deeplearning.AI
Timeline
Manager, Analytics & Innovation
Warner Bros Discovery
06.2023 - Current
Sr Advisory Analytics Consultant
Deloitte
06.2022 - 05.2023
Analytics Engineer
Even Financial (Acquired by MoneyLion, Early 2022)
08.2021 - 05.2022
Data Analyst
Arch Capital Group
06.2019 - 08.2021
BI Developer
Amida Solutions
02.2018 - 05.2019
- Microsoft Certified: Power BI Data Analyst Associate (PL300)
- DBT Fundamentals
- Udacity Machine Learning Engineer
- AI for everyone, Deeplearning.AI
Similar Profiles
Andrew GourdieAndrew Gourdie
Sport Presenter - Newshub Live at 6 at Newshub/Warner Bros Discovery/Warner Bros DiscoverySport Presenter - Newshub Live at 6 at Newshub/Warner Bros Discovery/Warner Bros Discovery
ERIN R. (ROSA) MOODYERIN R. (ROSA) MOODY
NA at Warner Bros. Discovery, Warner BrosNA at Warner Bros. Discovery, Warner Bros
KEDAR WANIKEDAR WANI
Sr VMWare VDI Engineer at Warner Bros Discovery [WarnerMedia/Time Warner]Sr VMWare VDI Engineer at Warner Bros Discovery [WarnerMedia/Time Warner]
Norman Trotter IVNorman Trotter IV
Administrator, Participations and Special Projects at Warner Bros. Discovery: Finance, Contract, Reporting & Administration (FCRA)Administrator, Participations and Special Projects at Warner Bros. Discovery: Finance, Contract, Reporting & Administration (FCRA)
Joyce JohnsonJoyce Johnson
Office Aide at The Alex House ProjectOffice Aide at The Alex House Project