Piyush Khare
SQL Specialist
Somerset,NJ
Summary
An experienced professional with expertise in Data Management, Analytics and Finance Domain. Currently associated with ICS Corporation as a SQL Specialist, performing statistics and methodical analysis of Data using SQL, Tableau, Python and Machine Learning algorithms. Accomplished 99% team productivity and 79% fail trade prediction during my association with previous organization. Consistently employs statistical methods and designs to yield real gains from model changes.
Overview
8
8
years of professional experience
6
6
years of post-secondary education
3
3
Languages
Work History
SQL Specialist
ICS Corporation
West Deptoford , New Jersey
2020.08 - Current
- Writing and optimization of SQL Codes to implement database logic and database maintenance.
- Implemented system enhancements to design and develop solutions to address problem reports.
- Performed Statistical and methodical analysis of Data to fulfill client requirements.
- Execution of Data Cleaning techniques to present data in the most structural and tools friendly way for the application of Visualizations and Machine Learning techniques.
- Incorporated quantitative and qualitative data to understand and translate complex business problems into machine learning problems.
- Application of tools including SQL, Python, Tableau, BCC Mail Management, Red Point data management and Inspired Designer.
Associate Process Manager
EClerx Services Limited
Pune , Maharashtra
2012.12 - 2018.07
- Conducted fail trade settlement analysis by utilizing historical trade settlement data and underlying fail causes
- Achieved 79% accuracy in fail trade forecasting by building machine learning model resulting fail trade rate of 0.3% from 0.9%.
- Accomplished 99.2% team productivity by eliminating waste (non essential processes) and analyzing core business requirements.
- Liaised with downstream and upstream teams for technical requirement gathering for testing and production deployment.
- Performed and managed the analysis of 4 business and 9 financial metrics as well as performance measures.
- Prepared MIS reports, monthly review dashboards and key performance indicators aligned with business strategies and initiatives by utilizing Tableau and Excel.
- Monitored static set up done by the team on top-day for client accounts, proprietary accounts and third party give-up accounts in Clear Vision application.
Education
Master of Science - Data Science
New Jersey Institute of Technology
Newark, NJ 2018.09 - 2020.05
Post Graduate Diploma in Management - Finance, Banking And Insurance
Siva Sivani Institute of Management
Secunderabad, Telangana, India 2008.05 - 2010.01
Bachelor of Science - Statistics, Mathematics And Physics
University of Lucknow
Lucknow, UP, India 2004.06 - 2007.07
Skills
SQL
Timeline
SQL Specialist
ICS Corporation
2020.08 - Current
Master of Science - Data Science
New Jersey Institute of Technology
2018.09 - 2020.05
Associate Process Manager
EClerx Services Limited
2012.12 - 2018.07
Post Graduate Diploma in Management - Finance, Banking And Insurance
Siva Sivani Institute of Management
2008.05 - 2010.01
Bachelor of Science - Statistics, Mathematics And Physics
University of Lucknow
2004.06 - 2007.07
Similar Profiles
Amiel Medrik MacatangayAmiel Medrik Macatangay
Material Handler at ICS CorporationMaterial Handler at ICS Corporation
Anthony JohnsonAnthony Johnson
Insert Machine Operator at ICS CorporationInsert Machine Operator at ICS Corporation
Cesar De La GarzaCesar De La Garza
Senior Service Project at ICS CorporationSenior Service Project at ICS Corporation