Business Analyst

Experience Summary

Over ** years of experience as a Business Analyst/ Director of Process Optimization/ Reporting Analyst with solid understanding of evaluating business processes and data sources behind them

Strong working experience in Data Analysis, Data Validation, Data Verification and identifying data mismatch

Strong Knowledge and Experience in mapping existing process models, adding functionality, and integrating multiple Information systems to create a Management Information System

Experience using SMART IT tailored business case methodology and well versed in analyzing an organization or business domain (real or hypothetical), documenting its processes and systems, and assessing the business model’s integration with technology creating distinct deliverables to a solution interviewing process users to validate requirements

Experience eliciting/extracting detailed business requirements from customer/project stakeholders and system artifacts

Experience working with statistical reporting systems

Experience in developing monthly, weekly, quarterly reports by using MS Office suite, VBA Macros, SQL and UNIX

Innovating using automated System Dynamics testing tailored to client needs using Vim Sim modeling to create and test process simulations finding counter intuitive solutions in real-time with stakeholders

Generating various process models from constituent groups to integrate disparate systems

Extensive use of Excel and MS Access to dump data and analyze based on business needs

Excellent knowledge in preparing required project documentation and tracking and reporting regularly on status of projects to all project stakeholders

QA of process automation iteratively implementing based on SME feedback to create and continuously improve test cases until automation is put into production

Involved in project meetings and collaborates with Project Managers, team members, associates, business analysts, statisticians, and end users on various projects

Team player with ability to adapt to various environments with excellent communication and interpersonal skills

Education Details:

Post Graduate Studies in Divinity, Buddhism Research Institute, NY, LA, Hong Kong, Beijing

70+ hours of Master’s course work in Decision And Policy Science and Information Strategy & Management – Application Focus, Rockefeller College of Public Affairs and Policy, Albany, NY

Bachelor’s in Economics with minor in Business, UAlbany, Albany, NY

Technical Skills

Environment/Platforms:

Unix, Windows2003 /2000/ XP/7/2010, Mainframes

Languages:

SQL, Shell Scripting, Batch Scripting, Lindo, Apple and IBM basic, MS DOS

Databases:

UNIX, SQL Server, Oracle, MS Access, Statistical Packages, proprietary relational databases such as NYS DMV D.R.E.A.M.S.

Tools:

SQL Developer, STATA, Vin Sim, HP Quality Center

BI Tools:

GUI:

Power BI, Tableau, ORACLE BI, Custom modeling of data submissions in Excel and MS Access

MS Office Suite

PROFESSIONAL EXPERIENCE:

Cosmic-Halo Oct 2010 – Present

Director of Process Optimization (Volunteer)

Responsibilities

Performing business case analysis using Smart IT methodology

Responsible for facilitating JAD sessions with 10 – 1000 stakeholders’ groups to assess as is systems, desired functionality, gaps, and funding requirements for solution options

Responsible for discovery of hidden stakeholders

Responsible for analysis of business needs to develop business metrics and recommendations for reporting that will support business metrics using existing system data

Responsible for analyzing solutions to address discovered gaps in systems

Responsible for mapping data from source to destination

Responsible for designing and executing QA for system enhancements to address gaps to reach desired service levels by interviewing, testing, tracking, and addressing defects in implementation

Responsible for gathering detailed business requirements based on project needs

Responsible for interviewing system users to gain an understanding of existing business processes and reviewing existing process documentation (AKA artifacts)

Involved in reviewing business requirements and analyzing data from source to target

Involved with end users to understand Information and data concepts behind business processes

Provides support for technical teams analyzing data

Conducting real-time global JAD sessions using tools including Realtime Board, Skype, and WhatsApp to communicate on multiple continents

Environment: World Wide Web, Various client enterprise systems, Vensim, Microsoft Office, Microsoft Excel, Realtime Board, Skype, WhatsApp, Various client BI systems

Maximus - CCO Analytics Dec 2019 – March 2022

Analyst - Reporting

Responsibilities

Loaded data daily for hierarchy updates used for performance reporting

Monitored data feeds and escalated issues that would delay reporting for team

Trained report users to assist in their use and gain valuable improvement feedback

Trained new team members to assume ownership of reports

Solicited feedback from users and stakeholders to meeting changing business reporting needs

Monitored enterprise electronic communications identifying barriers to overcome

Reviewed reports transitioned to newer Analysts for data accuracy and formatting consistency

Extracted ad hock Information from data sources using SQL scripting code libraries

Extracted, formatted, and presented Information for key business decisions

Responsible for identifying, analyzing, and interpreting trends or patterns in complex datasets

Added in Work from Home (WFH) reporting due to pandemic comparing WFH performance to on site

Transitioned existing report load to new SQL server as part of AWS migration

Apart from this, I helped the team with daily ongoing issues to meet business needs & leadership requirements

Environment: MS 365 E5 license. 11 sites in 11 States and 2 contractor run sites. Each Maximus run site is both the Federal Marketplace and Medicare. Working with multiple data vendors to obtain system data for performance reporting. Data vendors include Verizon, Leidos, High Point, AdHoc, National Government Services (NGS), and many others. Coast-to-Coast operations from Pacific to Eastern time zones. Full remote position from Albany, New York.

Maximus – New York State of Health Nov 2015 – Dec 2019

Senior Coordinator

Responsibilities

Documented and communicated of thousands of agent log activities to support agent management

Supported management in daily Contact Center staff scheduling

Continual gap assessments of multiple overlapping systems to monitor changing business needs increasing data quality for better decision-making support

Conducted user acceptance testing with external automation team in India

Created reports using charts and statistical analysis that best demonstrated insights from data

Created managerial Information from log data

Participated in daily standup meetings

Created custom BI reports for management 4 times a day building a statistical repository for short-term and long-term reporting needs

Extracted ad hock Information from data sources using SQL scripting code libraries

Extracted, formatted, and presented Information for key business decisions

Identified, analyzed, and interpreted trends or patterns in complex datasets

Apart from this, I helped the team with daily ongoing issues to meet business needs & leadership requirements

Environment: Blended local and international cloud enterprise with1500+ logged users, SQL Server, Oracle BI, MS Access database, SharePoint, Microsoft Visio, Microsoft Excel, Microsoft Office, custom Siebel interface, Contact Center Management Application, Pipkins

New York State DMV Bureau of Driver Training Programs Aug 2007 – Feb 2010

Certification and Oversight Unit, Albany NY

Business Process Analyst (Student Assistant)

Responsibilities

Consolidated custom relational database, Microsoft Access database, and data submissions from external systems to create a Management Information System aiding regulatory enforcement

Facilitated JAD sessions, conducted interviews and mapped existing workflows to enable system integration as part of an Office reorganization plan

Gained understanding of software development from design and architecture to production, DREAMS

Facilitated JAD sessions to align DMV IT Project prioritization more closely with their strategic plan using SMART IT methodology

Designed, Tested, and Validated logged process defects iteratively implementing using HP Quality Center and web PIRP learning automated testing for Unit quality team

Apart from this, I helped the team with daily ongoing issues to meet business needs & leadership requirements

Environment: Windows cloud environment where proprietary systems process over 5 million transactions per day Microsoft Office, Microsoft Excel, Microsoft Visio, Microsoft Access, NYS DMV relational databases, HP Quality Center, in house QA team for automated testing

Contact this candidate