Banking Data Analyst

• Nov 2020 - Present

Data Analyst

• May 2019 - Aug 2020

• Quantitative and qualitative analysis on huge data (TB), built financial models from transactional and shipment data provided key insights and recommendations • Automated model development by generating XMLs from Excel VBA-Macro, along with querying and fetching values from Oracle database, generating batch and PowerShell files through VBA saved 30% of development time • Developed complex SQL queries and stored procedures to perform data aggregation • Shadowed data scientist in data cleaning (MS Excel – Lookups, Pivot, Formulas), data preparation (SQL joins & functions), master data management (oracle), data integration, ETL, exploratory data analysis (EDA), data visualizations (Python & SAS) • Built Predictive Machine Learning and Forecasting models • Proficient in various technologies like SAS, Python, and R and integrating them • Prototyping new ideas or technology to prove efficacy Show less

Business Analyst

• Feb 2016 - May 2018

• Communicated with business and technical team for requirements gathering, assessing, and analyzing its technical impact, created user stories on JIRA, performed UAT • Worked with cross-functional teams, developer, and QA, built models, query database, performed UAT, and supported production releases • Created: Tableau dashboard for reporting, requirement traceability matrix, automated regression test cycle in selenium, JIRA dashboards to track development lifecycle • Introduced Agile methodology in the team, resulting in better processes, scheduled deliveries, and bug reduction by 33% • Knowledge and Experience of Software Development Life Cycle (SDLC) - Waterfall Show less