Shreyansh Ajit Kumar
Richmond,Virginia
Summary
Lead Business System Analyst Highly motivated, results-driven business analyst professional with nearly 6 years of experience in Project Management and Business Analysis. Demonstrated ability in data analysis and profiling using SQL, data warehousing concepts. Delivered presentations to decision-makers with suggestions on project benefits, cost estimations, and financial information.
Overview
8
8
years of professional experience
Work History
LEAD BUSINESS SYSTEM ANALYST
Deloitte Consulting LLP
Richmond, Virginia
01.2017 - Current
- Currently System Lead for Medicaid Eligibility Determination System for State of Tennessee and State of Arkansas Business Intelligence and Analytics Project
- Project involves creating Tableau and Power BI dashboards and reports on top of data warehouse created on eligibility determination database using Informatica
- Integrates forecasting models to generate revenue and expenditure forecasts, and provides single consolidated version of across Department of Human Services as enterprise
- Build new data mart that will store all financial data and train forecasting models to forecast revenue and expenditures based on variables specific to each division
- Developed series of dashboards to report on financial metrics for Department of Human Services overall as well as detailed metrics pertaining to each division
- These reports are meant for internal reporting and forecasting as well as federal reporting
- Spearheaded initiative to leverage Python in automating manual processes which have improved team’s efficiency and reduced time to pull multiple ad-hoc reports from 3 hours to 30 minutes by leveraging Python packages
- Built dependable client relationships with alacrity to understand their problems
- Key role in identifying application issues and target areas for backlog.
- Investigated and addressed system issues to enhance usability and improve functionality.
Intern
KPMG
Chennai, TamilNadu
01.2015 - 01.2015
- Analyzed data and synthesized findings into reports and presentations using SAP; QWAAS; BIWS; dashboards; BEX query designer; BEX analyze and browser; and SAP.
- Facilitated 20 requirements and design workshops, design real-time interface, and lead development and testing.
- Produced high-quality documents, spreadsheets and presentations for internal and customer-facing needs
IT BUSINESS ANALYST
Life Insurance Corporation of India
Chennai, TamilNadu
01.2013 - 01.2015
- Conducted market research on behalf of Insurance companies to identify trends and purchasing behavior of consumers
- Administered online surveys using Qualtrics platform and performed quantitative analysis of responses in SPSS
- Collected 20 system requirements, updated Requirement Traceability Matrix, generated 10 functional design artifacts
- Provided ad-hoc analytics and reporting solutions for managing workload effectively and developed key skills in Master Data Management, Data Quality, Requirements Management, and Waterfall SDLC methodology.
- Conducted interviews with key business users to collect information on business processes and user requirements
- Led cross-functional teams to analyze and understand enterprise-wide operational impacts and opportunities of technology changes
- Drafted quarterly and yearly reports on company financial metrics to assess successes and account for deficiencies
- Identified process inefficiencies through gap analysis and outlined sensible solutions
IT FINANCIAL ANALYST
Standard Charted Bank
Chennai, India, TamilNadu
01.2012 - 01.2013
- Collected data and developed detailed spreadsheets to identify trends and create revenue, profitability, and expense forecasts
- Managed monthly sundry and suspense account reconciliations (250 cost centers), recurring monthly and quarterly cost re-allocation process, and maintained control and governance costs for Global monthly.
- Developed forecasting tools to analyze revenue variance, business pipeline, and industry trends
- Reviewed financial reports and streamlined operations to increase productivity and company profits
- Delivered financial oversight and advice to corporate stakeholders to improve strategic planning
- Led meetings with directors to analyze spending and provide financial recommendations
- Used PeopleSoft financial software to create reports and recommended courses of action to upper management
- Participated in Revenue and Cost forecasting processes for entity; coordinated MIS and reporting activities between Central and Regional teams and delivered up to 50 daily ad hoc data requests in line with SLA timelines.
Education
Master of Science - Business, Business Analytics & Project Management
Texas A&M University - Commerce
Commerce, TX12.2016
Master of Science - Marketing Management And Research
Loyola Institute of Business Administration
Chennai06.2013
Bachelor of Science - Statistics And Computer Application
Loyola College
Chennai06.2012
Skills
- SQL, Reporting, and Business/Financial Analysis
- Sprint Planning
- Process Improvements
- Client and Partner Relations
- SIT, UAT, and Release Management
- PMO and DevOps
- Excel; Power BI; SQL; SPSS; Jira; SAP; Google Ads; DevOps
- Agile expertise
- Data migration
- Requirements gathering
- Technologically-savvy
- Report preparation
- Solution testing and implementation
- Financial leadership
- Juvenile justice system expert
Timeline
LEAD BUSINESS SYSTEM ANALYST
Deloitte Consulting LLP
01.2017 - Current
Intern
KPMG
01.2015 - 01.2015
IT BUSINESS ANALYST
Life Insurance Corporation of India
01.2013 - 01.2015
IT FINANCIAL ANALYST
Standard Charted Bank
01.2012 - 01.2013
Master of Science - Business, Business Analytics & Project Management
Texas A&M University - Commerce
Master of Science - Marketing Management And Research
Loyola Institute of Business Administration
Bachelor of Science - Statistics And Computer Application
Loyola College
Similar Profiles
Santosh VaidyaSantosh Vaidya
Sr. Consultant - Engagement Financial Advisor at Deloitte Consulting LLPSr. Consultant - Engagement Financial Advisor at Deloitte Consulting LLP
Devon WilliamsDevon Williams
DC Project Delivery Analyst, NE at Deloitte Consulting LLPDC Project Delivery Analyst, NE at Deloitte Consulting LLP
Sandeep Kumar DashSandeep Kumar Dash
Solution Manager at Deloitte Consulting LLPSolution Manager at Deloitte Consulting LLP