Badges
Certifications
Work Experience
Analyst
JP Morgan Chase & Co.• November 2016 - November 2020
● Business Intelligence: Analysed data based on user requests to generate actionable insights highlighting customer pain-points and developed remedial strategies (Tableau, SQL and Excel) ● Created interactive dashboards in Tableau with actionable metrics for higher management which resulted in 80% reduction in manual reporting time. ● ETL Design: Designed workflows to implement business logic and streamline end to end data flow to load from varied sources into Oracle tables preserving data integrity. ● Automations: Reduced user tickets by 30% by automating critical job status reports in Python. ● Process Improvements: Drove process improvements to reduce P1 incidents by 50 % for Home Lending Team using SQL, Teradata SQL, shell scripting, Python and Control M. ● Subject Matter Expert (SME)- Trained new resources with technical and functional KT .
Senior Software Engineer
Wipro Technologies• August 2013 - October 2016
● Team Lead: Led a team for a data warehousing application. Conducted biweekly calls with Service Delivery Manager to review the operating model. ● Created Power BI reports to highlight the data quality issues. Performed Data cleaning, manipulation and querying using SQL which reduced data related job failures by 40%. ● Data warehousing: Performed analysis, design, and debugging multiple applications built on PL/SQL and Informatica. Enhanced existing codes as per changing Business scenarios or ad-hoc requirements using PL/SQL procedures, functions, triggers, Unix, Informatica.
Education
University of Cincinnati
Information Systems, MS• January 2021 - Present
Pursuing Masters in Information Systems with a concentration on Data Analytics. • Data Analysis • Data Mining • Data Visualization • Statistical Computing • Data Warehousing and Business Intelligence • Data Analysis Methods (using R) • Database Design • Systems Analysis and Design • Big Data Integration • Web Dev W/.Net • XML & Web Services • Financial Accounting Foundation • ERP
Links
Skills
imayushiyadav has not updated skills details yet.