Data Analyst

Abhishek Jain

Business System Analyst, Irving TX 75038, ********.*****************@*****.***, 804-***-**** Profile Summary:

• Tableau and SQL Certified Business System Analyst with 4+ years of System Analysis and Reporting experience.

• Expertise in the Healthcare and Insurance data management, Data Analysis, Business System Analysis, Predictive analytics, SAS, and Master Data Management domains.

• Experience with ETL (Data Extraction, Transformation and Loading) mappings using Tableau to extract the data from multiple source systems that comprise databases like Teradata, Oracle, SQL Server, flat files to the Staging area, EDW and then to the Data Marts.

• Experience with gathering and documenting functional and non-functional requirements for both agile and waterfall IT projects.

• Hands on experience on creating Business Cases, Business Requirements Documents (BRDs) and writing detailed User Stories in JIRA.

• Experience with JIRA and Alsatian family of project management and Issue management tools.

• Excellent facilitation skills and adept at managing the interaction between end-users, stakeholders, developers and testers during the different phases of Agile and SDLC.

• Utilize SQL for querying and performing various data analysis in the Oracle, Postgre SQL, MS Access databases.

• Experience in creating integrated process flow and data flow diagrams for migration of local data centers to a centralized data warehouse.

• Conducting end-user training and providing system troubleshooting services as needed as well as providing documentation of work conducted

Technical Skills:

,

BI Reporting Tools Tableau Desktop 7.0/8.2, Power BI 2.35 Databases Oracle, SQL Server, Teradata, Mainframe COBOL Ticket System ServiceNow, Footprints, Lotus Notes Ticket application Project Management Tools JIRA, Confluence, MS SharePoint, PWA Documentation Tools Office 365 (Word, Excel, One Note), MS Visio Environment worked on Dev, Test and prod

Work Experience:

Business System Analyst – Christus Health

Irving, Texas

Mar 2020 – Present

• Gathering and documenting functional and non-functional requirements for implementing SAS based ERP solutions MD Staff and Delta Pathology Labs and their further integration with Backoffice financial, billing and EPIC Systems.

• Responsible for identifying stakeholders across various operational divisions at Christus Health network, creating stakeholder’s registry and doing subsequent analysis for improving stakeholder’s collaboration and engagement.

• Creating Data Mapping documents for aggregating and transforming various HL7 Billing codes and ADT feeds between Delta Pathology Labs and Christus Backoffice financial systems.

• Using MS Visio for mapping out the as –is and to- be provider credentialing process across the organization and identifying the key areas of improvement.

• Using JIRA to manage and creating detailed user stories for business as well as the development teams.

• Creating detailed test plans for managing Regression and User Acceptance Testing (UAT).

• Experience conducting and managing various agile ceremonies such sprint planning, reviews and retros.

• Conduct end user training webinars to demonstrate all the features for MD Staff and provider-built training for EPIC EMR system

• Use MS Office suite tools for documentation, design tools like MS Visio for process flows, analyze data using SQL, MS Excel etc.

System Analyst – Omtech LLC.

Client – OneAmerica Financial Partners, Indianapolis, Indiana Apr 2019 – Feb 2020

• Gathering and documenting functional and non-functional requirements for a cloud-based claims processing system and its integration through to the Claims ODS and into One America’s existing mainframe financial systems (general ledger, disbursements, billing and taxes).

• Documenting and implementing the business rules oriented around how to get the data aggregated or translated between the Finoes claims system and the mainframe financial systems.

• Doing data analysis involving legacy mainframe finance systems and file formats. Reading a COBOL copybook and understanding the differences vs. distributed file structures.

• Ensured data is clean, consistent and synchronized across source platforms.

• Creating workflows and process flows to demonstrate the end- to-end data flow between claim processing platform and the financial systems using MS Visio.

• Understanding the business and system needs and clearly documenting it in the Functional/Business Requirements Documents (FRDs/BRDs).

• Using JIRA for writing Epics and User Stories and managing issue log.

• Created visual dashboards using Tableau to provide insights for supporting various departments such as G/L Accounting, Treasury, Compliance, Taxation and Actuarial.

• Use MS Office suite tools for documentation, design tools like, MS Visio for prototyping and process flows

Sr Business System Analyst - Genius Minds LLC

Client – SCDHEC, Columbia, South Carolina

Jun 2017 – Apr 2019

• Gathering functional and non-functional requirements for implementing ServiceNow- help desk and asset management solution at South Carolina Department of Health and Environment Control.

• Using MS Visio for mapping out the existing help desk and asset management processes across the agency and identifying the areas of improvement.

• Creating service catalog for various IT program areas and performing data profiling for various IT asset types across the agency.

• Using JIRA for managing the requirements received from stakeholders. Ensure requirements are accurate. Communicate with Stakeholder on requirement related activities.

• Worked with the QA personnel in performing data validations and automated testing as required.

• Using Power BI tool to pull IT assets data from the agency’s MS Access database and creating business intelligence dashboards for operations department to track asset loss.

• Designed, developed, tested, and maintained Power BI functional reports based on operations user requirements.

Market Research Intern – International Data Corporation Bengaluru, India

Feb 2016 - May 2016

• Work closely with Asia Pacific Marketing Research Team ensuring the team is up to date with the functional and operation requirements of smart city IT solutions.

• Creating various Business and Use cases for understanding the business need and documenting it the Business Requirements Document (BRD).

• Creating workflows and process flows for each of the process and activities in MS Visio.

• Formulates testing plan and successful testing criteria and identifies appropriate resources for testing the requirements in quality management systems.

• Establish communication plans with the Project Manager and team during different stages of the development life cycle for both agile and waterfall projects. Education:

• M.S (Business) from Virginia Commonwealth University, Richmond, VA - 2017

• M.B.A – Christ University, Bengaluru, India -2016

• B.B.A – Guru Govind Singh Indraprastha University, Delhi, India - 2015 Certifications:

• Tableau for Data Science -Udemy

• SQL for Data Analysis- Udemy

Contact this candidate