Data Analyst Manager

Rutweek Sawant

Business Data Analyst

Location: CA Mobile: 650-***-**** Email: **************@*****.***

LinkedIn: linkedin.com/in/rutweek/ GitHub: github.com/rutweek Acclaim: linkAnalystCA 5-1930 *************@*****.***

3+ years of experience in the field of Business Analysis and Requirements gathering.

Experience working with different Software Development Life Cycle (SDLC) involving both traditional methodology such as Waterfall and Agile methodologies such as Scrum.

Efficiently collaborated with Business Owners, Business Users and senior stakeholders.

Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Conversion, Data Quality, Data Integration and Metadata Management Services and Configuration Management.

Familiarity in writing Business Requirement Document (BRD), Functional Requirement Document (FRD), System Requirement Specification (SRS), Requirement Traceability Matrix (RTM) as per company requirement.

Worked with creating databases and structuring of Big Data on SQL servers and Sybase and in applications, using data generated from live and static feeds in a variety of formats.

Knowledge of creating UML diagrams like Use Cases, Activity, Sequence, and Class diagrams using MS Visio and worked on both High Fidelity and Low Fidelity Mock-up Screens and wireframes using Lucid Chart& Balsamiq.

Experience in defect tracking, defect analysis & ability to organize, document & track changes using Jira.

Experience in Retail Analytics, Growth, Brand & various Customer Segmentation and Acquisition methodologies.

Business Analysis Skills: SDLC, Agile, Waterfall, Scrum, JAD Session, Interview sessions, Document analysis, Focus Groups, Requirement workshops, RTM, RACI Matrix, MS Visio, Gap Analysis, KPI Dashboards

Business Analysis/PM Tools: Balsamiq, Rational Requisite Pro, Lucid Chart, Draw.io, COGNOS, MS Visio, SharePoint, Jira / Confluence, Microsoft 365, MS Project

Data Analysis Skills: KPI Analysis, Customer Segmentation & Acquisition, Funnel Analysis, DAX, A/B testing, Statistical Modeling, ROI/ROAS Tracking, Revenue Attribution, Multi-Channel Dashboard

Data Analysis/Visualization Tools: MS Excel (Advanced), Python, R script, Power BI, Tableau, DAX, Metabase(SQL), Google Analytics, Google Data Studio

Databases/ RDBMS: AWS, MYSQL,T-SQL, PLSQL, SQL, SQL Server, Postgre SQL

BNY Mellon CA July 2020 - Current

Business Data Analyst

Working with Agile (Scrum) SDLC methodology for development.

Conducted one-to-one meetings & web-Conferences as well as JAD sessions with different stakeholders; analyzed and assisted in creating a Business Analysis Process Model using Rational Rose and MS Visio.

Designed, coded, and tested complex SQL and VBA scripts to create an interface between the SQL Server and Excel.

Converted the requirements and was responsible for creating the Business Requirements Document (BRD).

Assisted Project Manager in creating Project Charter and Task Breakdown Document (TBD) using MS Project.

Responsible for writing Functional Requirement Specifications (FRS) and User Requirement Specification (URS).

Involved in Scrum Sprint Planning Sessions, Backlog Grooming, Sizing, Sprint Retrospectives & Reviews, Daily Stand-ups, User Stories and Acceptance Criteria, also created a Business Requirement Document for management.

Designed reports and data sets for COGNOS reporting.

Created Report Mockups for SSRS based data and Sample Data Mapping documents for ETL process.

Worked with the DBA to define the dimension modeling requirements.

Created SharePoint workflow diagrams describing how to use the new system.

Participated and conducted daily standup meetings and owned daily milestones to gather and create reporting specifications.

Created UAT plans and several other types of test cases for each project to ensure that the system runs smoothly after the proposed enhancements.

Created T-SQL statements, stored procedures to query the custom claims OLAP database.

Proactively identified opportunities and made recommendations to improve the system's effectiveness via data mining and analysis.

California State University (CalFresh Dept.) Hayward, CA Jun 2019-May 2020

Business Data Analyst (Intern)

Responsible for writing Functional Requirement Specifications (FRS) and User Requirement Specification (URS) of various CalFresh programs implemented at two Cal State East Bay Campuses.

Analyzed and reviewed project elements involved in traceability including testing artifacts, end-user support documentation and training materials to provide tractability across various cross functional projects.

Involved in writing Use Cases and Functional Requirement Documents as well as for creating Use Case diagrams, Activity diagrams, State diagrams based on UML Methodology and business object modeling flow diagrams using Rational Rose.

Collaborated with various cross functional teams to implement migration of in person CalFresh application procedure to a virtual approach thereby optimizing application conversion rate by additional 35%

Acted as a Liaison between California Dept. of Social Services (CDSS) and CalFresh dept. to implement various basic need development, student outreach, Acceptance rate enhancement campaigns at both Cal State East Bay campuses

Deliver to ad-hoc requests made by Program Manager with interactive, Intraday Report, Overnight Report and other financial reports as well as monitor all the designed KPI’s to deliver real-time demographics using Excel and Tableau.

Conduct seminars on various CalFresh outreach and impact strategies at various basic needs conferences and meetups.

Future Group Mumbai, IN Jun 2016-June 2018

Customer Insights Analyst

Managed MS SQL Server -> MS Excel enabled reporting for key festive / cross-sell (F2F) /customer win-back campaigns.

Optimized advanced SQL queries to reduce the execution time by 26%, which delivered quick insights to cross-functional teams by measuring and evaluating business KPI’s.

Communicated between FG Data Warehouse implementation partner and the BI team to design ETL processes and perform detailed profiling for data quality assessment.

Performed customer segmentation, market basket analysis and calculate lift on retail data using various techniques such as clustering and RFM analysis.

Supported marketing functions such as campaign planning, road maps, competitor business intelligence as well as pre- and post-analysis of campaign deployment.

Shadowed campaign managers to plan campaigns, omni-channel selection, lapser management programs as well as identify KPI & cross-shopping opportunities.

M.S in Business Analytics California State University (East Bay), CA May-2020

Bachelor’s in Computer Engineering University of Mumbai, Mumbai May-2017

Agile with Jira Atlassian

Google Analytics (GAIQ) Google

Data Science Pro-Degree Genpact

Tableau Desktop Specialist Tableau

Software Product Management Uni. of Alberta (Coursera)

Summary

Skills

Experience

Education

Certifications

Contact this candidate