Summary
Overview
Work History
Education
Skills
Timeline
GeneralManager

Prerak Bhagat

Data Analyst
Los Angeles,CA

Summary

Dedicated and motivated data analyst with proven ability to drive process efficiency and data integrity. Over 5+ years of experience leading teams in data mining and data warehousing solutions. Exceptional skill in SQL-based environments. Business and data analyst with 5 years of experience across diverse industries. Expertise in analysis and testing of business requirements to drive deployment of applications, business processes and system solutions. Highly analytical and detailed with documented track record in full software development life cycle (SDLC) methodologies and Agile techniques.

Motivated and results-driven Analyst with proven track record in data analytics and process mapping. Proven ability to identify business needs and develop valuable solutions to drive accuracy and process efficiency. Drives business effectiveness through making recommendations based on data findings.

Industry experience in complex data analysis, experimentation, and product metrics for consumer facing products. Strong statistical background, Strong verbal and written communication, and presentation skills. Highly detailed oriented with Excellent judgment, critical-thinking, and decision-making skills also able can balance attention to detail with swift execution.

Overview

5
5
years of post-secondary education
5
5
years of professional experience

Work History

Data Engineer

City National Bank
Los Angeles, CA
09.2018 - Current
  • Performed as leading data analysis and design tasks in multiple upgrade project with tight timeline.
  • Developed database models, database processes and functional analysis across oracle database methodologies specific to Business Intelligence
  • Took responsibility to write SQL and ETL data flows to support existing legacy processes and provide input to new platform conversion efforts.
  • Creating complex SQL queries and scripts to extract and aggregate data to validate the accuracy of the data.
  • Work with users to identify the most appropriate source of record required to define the asset data for financing.
  • Determined where issues pertaining to system, data, or process are, and how to resolve issues.
  • Facilitated and representing the Business Requirements in Design Reviews, Code Reviews and QA Reviews meetings at all levels.
  • Provided business intelligence by engineering requirements and developing quality test plans.
  • Skillful and strong at communicating complex quantitative analysis in a clear, detailed, and actionable manner to senior executives
  • Created comprehensive business requirements and project plans
  • Coordinate with the business users in providing appropriate, effective and efficient way to design the new reporting needs based on the user with the existing functionality.
  • Prepared documentation, analytic reports and Entity Relationship Diagram effectively and efficiently delivering summarized results, analysis, functions and conclusions to stakeholders.
  • Mapped process activities to identify shortfalls and propose options to rectify operational inefficiencies.
  • Well versed communication skills and empathy to understand and discover business pain points and build solutions to improve the user experience at all levels of the global trade process

Data Analyst

Citizens Bank
Burlington, VT
02.2017 - 09.2018
  • Analyzed mortgage Data and uploaded critical documents needed for quality control assurance and audit purposes.
  • Prepare high level & qualitative analysis to observe patterns/relationships in data and produce reports with metrics and indicators using with Excel and Tableau data visualization including ad hoc reports.
  • Provide support in full systems life cycle for multiple applications with time management and organizational skills to ensure the goal is reached on time and within budget.
  • Performed Feasibility Analysis, Ad Hoc Analysis and Risk Analysis on the application.
  • Used Data Warehousing for Data profiling & marts to examine the data available in different sources.
  • Recommended data standardization and usage for protection of data integrity.

Business Analyst Intern

Convergys
Mumbai, India
05.2015 - 07.2016
  • Documented business and functional requirements.
  • Documenting various requirement specifications, functional specifications, Test Plans, Source to Target mappings, SQL Joins.
  • Provided business intelligence by engineering requirements and developing quality test plans.
  • Developed intelligence-sharing dashboards, providing company-wide access to collected data.
  • Directed implementation of new business intelligence tools, selecting appropriate solutions and aiding in corresponding onboarding processes.
  • Integrated BI assets into strong customer relationship management (CRM) tasks, improving service personnel's available intelligence.

Education

Master of Science - Management Information Systems

Pace University, Seidenberg School Of Computer Science And Information Systems
New York, NY
01.2017 - 05.2018

Bachelor of Science - Information Technology

Mumbai University
Mumbai, India
06.2010 - 08.2014

Skills

Data Analytics

undefined

Timeline

Data Engineer

City National Bank
09.2018 - Current

Data Analyst

Citizens Bank
02.2017 - 09.2018

Master of Science - Management Information Systems

Pace University, Seidenberg School Of Computer Science And Information Systems
01.2017 - 05.2018

Business Analyst Intern

Convergys
05.2015 - 07.2016

Bachelor of Science - Information Technology

Mumbai University
06.2010 - 08.2014
Prerak BhagatData Analyst