Business Analyst Sql Server
Resume:
Skill Sets / Career Highlights/ Specialization
Professional Summary
A Professional with excellent Business analysis and logical skills possesses rich 15+ years of experience as a Business Analyst in IT Industry primarily in Domains as Healthcare, Logistics, Liquor Licensing and educational industry K-12 to take a challenging role for understanding business change needs, assessing the impact of those changes, capturing, analysing and documenting requirements and then supporting the communication and delivery of those requirements with relevant Business Owners and Stakeholders.
Areas of Technology Expertise
Programming Languages MS SQL.
Databases MS Access, MySQL, SQL Server. Azure data studio
Software’s. Visual Studio, SQL server BI Development Studio, CRM Microsoft Dynamics 365, SAP, Microsoft Office Suite,
Team Foundation Server (TFS), JIRA, ServiceNow, SharePoint.
Healthcare Solution Products TriZetto FACETS, EAM (Enrollment Application Management)
Testing Tools HP QC / ALM
Methodology Skills & Proficiencies
Conceptualization, Critical Thinking, Problem Solving, Effective Verbal Communication, Process & Requirements Documentation, Visual Modelling, Business Analysis Tools, Testing Tools, Time Management, Change Management, Decision Making, Process Improvement.
Tools / Software’s / Product Proficiencies
MS Visio 2016, Citrix (SaaS), Application Lifecycle Management (ALM), Software Development Lifecycle (SDLC), MS Azure (PAAS), Rational Rose, Rational Clearquest, Rational ClearCase, Rational Requisite Pro, Power BI, Web Application API’S (JSON & XML) SharePoint, ServiceNow, JIRA, TFS, TIDAL, FACETS.
Project Management
MS Project, SmartSheet, JIRA work management, Service Now
Certifications
Diploma Certified in SAP Modules - FI (Finance) / CO (Controlling)
Diploma Certified SAP – Basis
IIBA – CBAP
ITIL – 4 Foundation Level
Trainings / Workshops
HIPAA, TCS Letters Training, Facets upgrade training, release management training, Devops Training
Industry Reach
Healthcare (Medicare, D-SNP, Payers, Providers, PBM), Transportation (Logistics), Educational (K-12) Liquor licensing (LL).
Career Highlights
Client Name: State of OH - Liquor Licensing (LL) Jan 2024 – Till Date
Location: Columbus OH (Hybrid) Role: Sr Business Analyst (IV)
Project’s brief Description: Ohio Department of Commerce has the current system used for liquor permitting and management includes Licence Issuance and Tracking System (LITS) and CICS. CICS is a mainframe system that can no longer support the needs of the department and its customers. LITS covered documents, printing, and other functions. This project is to replace LITS/CICS and its current functions and retire the mainframe system. Develop and implement a licensing request, approval, and management system along with the mobile app to process and report on all licensing applications received by the DOLC (Division of Liquor Control).
●Responsible for understanding the stakeholder's business culture and priorities.
●Effectively identified and Evaluated the business problems and proposed solutions.
●Performed requirements analysis, leveraging appropriate company, industry approaches and modelling techniques and Summarize the requirements to ensure Business and I are aligned before i formulate it to downstream teams.
●Performed cross functional collaboration to ensure effective communication between various teams, including business, technical, and operational stakeholders.
●Facilitated workshops, meetings, and presentations to ensure all parties have a clear understanding of the project's objectives, status, and requirements.
●Analysed the existing system and its functionality and prepared an analysis report that was reviewed and approved by business.
●Gathered requirements to revamp new external user facing portal that will allow applicants and permit holders to Apply for permits including.
Complete forms
Generate, download & upload documents
Make payments
Check permit and permit application status
Manage their permits and legal entity data
Cancel Permits
Update permit applications and supplemental data
Transfer permits
●Gathered requirements to Revamp a new internal portal that will allow business users to:
Manage permits including:
Accept/reject/update applications
Accept and process payments online and manually
Handle permit transfers and renewals
Vendor management in SAP.
●Generated Power BI reports for leadership to review the status on a daily basis on received applications and permits status.
●Facilitated the business approval process by providing stakeholders with detailed information about the requirements, its impact, and potential benefits.
●created multiple dashboards for leadership and business and simplified the decision making process.
●Highly involved in the data Versioning process and worked closely with the Dev Engineers and Architect team.
●Played a key role in the change request process, ensuring that the change is well-understood, aligned with business goals, feasible, and effectively implemented.
●Performed gap analysis by Comparing the current state with the desired future state, identifying any gaps that the change request will address to ensure the organization gets the most value out of any change request by managing communication, impact, and requirements efficiently.
●Performed Testing to ensure the tasks are accomplished and aligned as per the business ask. Also, collaborated closely with Test Engineers to ensure the testing is done thoroughly on the requirements prior to the Business UAT Approval.
●On high priority issue tickets Performed root cause analysis to identify, define the problem to business.
●support UAT by ensuring that the change meets business needs and helping users test the solution in a real-world context.
●Collaborated with the engineering team to provide an ETA on the fix. This error is fixed using the normal SDLC process - analysis/ design/ programming/ QA/ testing /release. The new version of the program is deployed and verified/validated and updated in the versioning system for record.
●Worked in a very fast paced environment and successfully accomplished the business set timelines.
●Conducted sessions to ensure that best practices, methodologies, and domain knowledge are passed down to less experienced team members to help in maintaining consistency and quality across projects.
Client Name: State of MA - CommonWealth of MA (CCA) Dec 2022 – Dec 2023
Location: Boston MA (Remote) Role: IT Product Owner (PO)
Project’s brief Description: CCA goal was to onboard multiple new vendors and transform from the SQL legacy system to EDP (Enhanced Data Platform) and stage the data so that downstream systems can consume the data. Do Member ID conversions for all the inbound and outbound files, create sFTP paths for all new onboarding vendors to transfer the files securely. All projects worked were purely on Project Management Approach (Agile Methodology)
●Performed requirement gathering working closely with business and created various FRD’s (Functional requirement documents)
●Accommodate change in requirements by creating a CR to meet the business needs.
●Created the scope creep document, performed impact analysis and presented it to business to seek their approval for the changes in requirements.
●Gave detailed walkthroughs to business and Vendors to ensure we all are on the same page and understand the business needs accurately.
●Worked closely with various vendors to standardise the file layouts and formats to meet the CCA standards.
●Transformed multiple vendor claims EDI files to standard 835 / 837 edi files.
●Seeking official sign off from Business and providing walkthrough sessions to Engineering teams to start the code build.
●Developing various Mapping documents to ensure we have the right tables and right data in place.
●Created in-bound and outbound sFTP path for new vendors to post or consume the files.
●Worked closely with the Engineering team to develop the automated jobs and schedules for the file transfers.
●Worked closely with ETL team to develop a plan to execute them in lower ENV to ensure they automatically trigger as per the schedule.
●Worked closely with the architect team to define a context diagram to understand the dependencies.
●Performed Member ID conversions for the data coming out from Facets system before sending it out to external vendors and vice versa.
●Ensuring to have a daily status call with Engineering and QA teams to see if there are any challenges so that I can help in expediting the process.
●Creating various JIRA tickets and assigned to respective teams so that I can track the progress as well as it helps for internal and external auditing purposes.
●Worked on big initiatives for AEP and CTP projects of CCA.
●Defines error report handling process in case of any errors in data files that we receive or send to Vendors.
●Defined acknowledgement reports for vendors upon sending and receiving the files via sFTP.
●Co-ordinated with testing leads to ensure a resources are assigned and involved at the beginning of the projects so that they are no last minutes challenges and to meet the project timelines
●Helped Engineering teams to create the technical mapping documents reviews and approved.
●Helped the QA team to build the test plans and ensured it covered all the scenarios reviewed and approved.
●Performed UAT with business upon completion seeking approval to move ahead with the CAB ( change management process) to create a ticket to move the code to PRD as per the release plans.
●Worked closely with the data team to ensure the tables are mapped accurately in the EDP system.
●Worked closely with the support team to explain the requirements and ensure we have the right jobs in place that trigger the PRD files to exchange via sFTP and notify the provided groups upon job completion and in case of errors the respective teams should be notified.
●Defined ETA to resolve the errors in any of the inbound or outbound files.
●Worked on very fast paced environment to meet the timelines.
●Successfully deployed 11 different projects of CCA on time.
●Got appreciation from senior leadership for being on top of all of those projects and coordinating with various teams to have smooth transitions.
Client Name: State of Ohio Jobs and Family Services JFS May 2021 – Nov 2022
Location: Columbus OH (Remote) Role: IT Business Analyst IV
●Performed and conducted and Facilitated Workshops for requirements analysis with external vendors.
●Worked closely with the Deloitte team for CI and work orders for JFS.
●Worked on developing Business Requirements - project initiation document, what the needed achievements will be,
●and the quality measures, test cases and test plans.
●Experience developing Functional requirements - describe what the system, process, or product/service must do to
●meet the business requirements.
●Experience developing Quality-of-service (non-functional) requirements - are requirements that do not perform a
●specific function for the business requirement but are needed to support the functionality. For example: performance,
●scalability, quality of service (QoS), security and usability
●Worked with external vendors on performing vendor testing on all the digital 7078 updates.
●Worked on digital 7078 enhancements gathering the requirements and understanding the scope and ensuring the
●requirements are also added in Jira for tracking.
●Experience creating workflows using formal notation such as the Business Process Modeling Notation (BPMN).
●Experience developing User (stakeholder) requirements – as it was an important part of the deliverables, the needs of
●the stakeholders have been correctly interpreted. This deliverable did also reflect how the product will be designed,
●developed, and defined how test cases must be formulated.
●Performed UAT for many of the program offices of state, added new roles and managed the role matrix for digital 7078 in collaboration with the Deloitte team.
●Involved in all the critical decision making of the process from CI perspective and ensuring we meet the deliverable timelines.
●Experience developing Report Specifications – defined the purpose of various reports from service now.
●justification, attributes and columns, owners and runtime parameters Build dashboards for business, leadership and CIO decision making.
●Involved and captured requirements in tabletop quarterly meetings with the entire state cybersecurity leadership including CIO.
●Experience developing Requirements Traceability Matrix - a cross matrix for recording the requirements through each stage of the requirements gathering process.
●Developed presentations for inter hirings for the state.
●Strong organisation and writing skills. Experienced developing graphic representations
Client Name: CareSource Apr 2018 – May 2021
Location: Dayton OH Role: Sr. IT Business Analyst
Project’s brief Description: After successful Implementations for MP2019, MA 2020, MA D-SNP 2020, Moved to QA team worked with MEDICARE IT team on testing EAM, FACETS MA 2021, MA D-SNP 2021 &MA & D-SNP 2022 tested end to end process. Worked on Project Management module and Used Agile methodology for all the above initiatives.
Projects overview – Medicare Advantage 2020 Implementation, Market Place 2019 implementation, Supplemental benefits 2019, LIS Rider 2019 and 2020, EOB 2019, DE & EDE Member Enrolment portal, IVR Replacement, Reports Automation for Supplemental benefits, 2019, Provider Preclusion mail merge.
involved in all the meetings and discussions with cognizant. Wrote user acceptance stories and test cases and test plans. Used HP QC-ALM as a source to load all the test cases and plans. Extensive knowledge on EAM (enrolment application management) and facets.
Role & Responsibilities
●Responsible for understanding the stakeholder's business culture and priorities.
●Effectively identified business problems and proposed solutions.
●Performed requirements analysis, leveraging appropriate company, industry approaches and modelling techniques to gather requirements along with project manager.
●I am also a Scrum Master and facilitate daily stand-up’s, by- weekly Grooming session and By-weekly Sprint Planning with the team.
●Facilitated requirement gathering sessions and requirements review sessions with business owners along with project manager, lead meetings toward stated goals of the Project.
●Prepared excellent documentation as per corporate standards, procedures and prioritised them for assigned business areas.
●Developed scope documents and performed PEER reviews for additional inputs and suggestions and then reviewed it with business owners to ensure the requirements are captured accurately and confirmed the understanding by all stakeholders and took sign-off.
●Created Agile EPIC’s on Team Foundation Server (TFS) and transformed the high-level requirements into features and decomposed the features into multiple user stories so that technical team and Development team can understand the requirements aptly.
●Created Requirement Traceability matrix to track the progress of the project/s throughout the project/s life cycle.
●Performed GAP analysis for complex processes and created documentation for business to understand.
●Worked closely with SQA lead in developing various test scenarios and test cases to perform End to End testing for projects.
●Developed and executed various test scenarios for User Acceptance Testing (UAT) and reported the daily success and failure percentage to stakeholders.
●Logged all failed test cases / scenarios in vendor JIRA application and coordinated with respective teams to ensure the development process is accurate.
●Worked closely with scrum masters to prioritise the requirements and ensure Tech BA is assigned to start the task in requested sprints.
●Worked closely with the Project manager updating him/her on project status and also assisted in developing the project plan (Requirements).
●Worked with project manager on change requests, documented the change and submitted in form of document to ensure business understands the impact on project timeline, resource effort and cost.
●Developed a very healthy working relationship with various teams, stakeholders, Business owners, Product owners, Scrum masters, SQA leads, tech BA’s, Developers etc.
●Mentored new team members.
●Performed Tracking and generate reports on MSLA compliance to markets and customer satisfaction
●Initiated and Implement plans and remedies with partners where services fail to meet MSLAs
●Reviewed and worked accordingly to KPI’s.
●Escalated alerts to Business on delays of supplies and Generated multiple statistical Reports on SpreadSheets for Management and Managed project Plan.
●Created Traceability Matrix Identifying and analysing bugs and creating test cases and Tracked bugs in JIRA.
●Created project schedules and timelines in Smart sheet & MS Project to track the weekly status.
●Projected, alerted and escalated the red flags to business owners well in advance Methodology Used was AGILE
●DB used was SQL, MySQL.
Client Name: Fulton County Schools (State Project) FEB 2015 – Mar 2018
Location: Atlanta, GA Role: Sr. Business Analyst
Project brief Description: This project goal was to expand the current administration Data warehouse and create Web Application for End Users. Worked with multiple departments and internal & External stakeholders understand the needs and the present data flow, drilled down detailed information from various departments documented in business templates and successfully collected the data and uploaded on to DW also recommended and upon approval created multiple department’s analytical Power BI dashboards to help leadership to make a strategically decisions Analytical Dashboards are also created with various data sources including statistical data from State and Federal agencies. Developed e- Commerce web application for students and parents. Extracted data from SAP and staged in new enhanced DB and provisioned access to various agencies and teams and built real time dashboards.
Role & Responsibilities
●Scheduled workshops and meetings with stakeholders to understand their needs and provide solutions.
●Managed working with multiple departments, Users parallel and successfully gathered requirements documented in business template, and effectively communicated with Business technical team.
●Prepared Business rules, Supplemental specification document.
●Optimise Project/Program Portfolio – align, value and balance, maintain logs.
●Authorise resources and reallocate to keep projects on deadline
●Manage databases, uses reporting tools, develops and updates schedules in Clarity
●Prepared Business rules, Supplemental specification document, BRD, Business Process Diagrams, Use Case Diagrams, and Status Reports.
●Conducted Deep Dives and Defined KPI’s.
●Define and track strategic metrics for project milestones.
●Worked closely with CFO on county budget and Finance allocations data that was stored in SAP System.
●Worked closely with the Financial team to understand the SAP system data integrations / Dependencies.
●Worked closely with the Architect team to identify the workflow and dependencies and identified the challenges and addressed them appropriately to have a seamless data migration from SAP to new DWH.
●Developed strategic reports and dashboards for the Finance department.
●Analysed finance data and created multiple trend charts for the steering committee.
●Documented minutes of meetings for all the meetings conducted.
●Developed EPIC stories.
●Performed and Met Acceptance criteria.
●Used UML diagrams and provided Users with ready to use expressive examples.
●Build very good relations with business stakeholders.
●Prepared BRD’s for multiple analytical dashboards.
●Prepared BRD’s for E-Commerce applications.
●Developed Web Application for county schools.
●Experienced working with Development team on multiple API’s and data extract. (JSON).
●Enhanced existing SharePoint Applications.
●Analysed data and prepared Mock-up’s for better understanding of dashboard view.
●Reviewed the BRD’s with business for signoff before development initiated and resolved the issues if any.
●Worked closely with development engineers constructing various decision-making dashboards for executives in Power BI and also Web Applications for Internals and End Users.
●Constructed UAT Test cases.
●Conducted UAT sessions with internal, External Stakeholders on Dashboards.
●Conducted UX Testing for Mobile, Desktop and Web applications for end users or customers.
●Prepared and maintained Traceability Matrix.
●Conducted and Participated in JAD sessions.
●Always ensure that the development team has enough information to start the development.
●Worked on REST API Architecture
●Experience with JIRA to track the progress of the project.
●Closely aligned with the technical development team to ensure the analytics were accurate.
●Experience working in a multilingual platform.
●Strong knowledge and experience in SDLC & ALM.
●Methodology used was AGILE
●Conducted Stand-ups
●Conducted Tests to ensure that requirements are met.
●Worked with the testing team and also performed unit testing, functional testing, acceptance testing etc.
●Performed Unit and functional testing.
●Conducted UAT across the district, leadership and Executives.
●Participated in functional design sessions and executes SQL test scripts, and aids in the solution of data issues
●Validated the test data in DB2 database on Mainframes using SQL queries
●Worked heavily on SQL Server database to extract data and build Business reports
●Strong Knowledge of Business Intelligence, Data Warehousing and Business Architecture.
●Excellent understanding of Data services, Data ETL using SQL query tools and applications
●Extensive experience in the development, implementation and integration strategies within a team-oriented environment, utilising quantitative and qualitative analytical skills
●Extensively worked in Data Requirement Analysis and Data Mapping for ETL process.
●Worked on UX Experience.
Client Name: UnitedHealth Group (OptumRx) JUNE 2012 – SEP 2013
Location: Remote Role: Sr. Business Analyst
Project brief Description: OptumRx Project was to Build and maintain the Pharma Benefits Manager for the customers who are associated with United Health Group and this project is partnered with more than 60k Pharmacies across USA which provides discounts to customers on their prescriptions. Also, it helps the members to order their Prescription drug online. Worked with various Companies, Agencies on negotiating rebates, Pharma Claims Process, Prior Authorization, Benefits Coordination, Managed Formularies based on health plans, Distribution management among network pharmacies. Also developed customers Web portal for Prescription Mail orders and Enhanced Secure online transactions between businesses for any B2B e-Commerce solution to Integrate with multiple payment gateways, ERP systems and other backend systems to track payments and the movement of goods.
Role & Responsibilities
●Served as a liaison between the Customer and offshore development team.
●Responsible for gathering business requirements and preparing BRD’s, communicating with development, QA.
●Communicating process changes, enhancements, and modifications to the team.
●Work on production issues as incidents.
●Developed Web Application for Mail orders.
●Performing User acceptance test immediately after every build.
●Serving as a liaison between the programmers and internal
●Business entities in designing and implementing functionalities.
●Collaborating in the planning of new product decisions and enhancements to existing applications.
●To take ownership of the implementation process with clients/customers.
●Assisting the DBA team, to produce right DB changes, and stored procedures in the right time in the right manner.
●Responding to RFPs (Request for Proposal) for the new lenders who look to adopt our products.
●Responsible for the implementation process to new clients, by setting up to go live.
●Performing research on implementing new enhancements, competitor and market analysis for higher management.
●Engaged with the business to identify and define scope for continuous improvement activities In Scope & Out of Scope
●Defined KPI’s to achieve strategic goals of the organisation.
●Solve issues by monitoring the issue Log and preparing the Trace matrix.
●Worked with business stakeholders in creating the requirements based on experience with the member issues and evaluated information from multiple teams to distinguish user requests and needs.
●Participated in project reviews, benefits realisations efforts in analysing expected, and actual benefits.
●Knowledge on ALM, ReST API.
●Performed root cause analysis, identified and followed up with all the necessary application teams involved in the Project.
●Analysed the existing reports of the reporting system in the database. Checked the consistency of the data after ETL process using SQL queries
●Documented project artefacts such as Stakeholders Analysis, Business Requirement Document (BRD), Functional Requirement Document (FRD), Test cases and Test Plans.
●Tracked Bugs efficiently in JIRA and updated the business.
●Managed MSLA’s for providers, payers and Pharmacies (Vendors)
●Managed data and retrieved data through SQL database system.
Client Name: The Most Group (Simplify Healthcare) MAY 2011 – MAR 2012
Location: Remote Role: Sr. Business Analyst
Project brief Description: Goal of the Project was to perform the GAP analysis on the Benefit Builder File cleansing the data and update the accurate information. Also performed GAP analysis and enhancement between 4010 to 5010 procedural codes and updated the data as per the HIPAA standards (CMS).
Role & Responsibilities
●Responsible for managing the project related to all the work.
●Coordinating with the clients and working accordingly.
●Collecting data from the clients.
●Deciding the team wise targets.
●Responsible for checking the daily achievements.
●Generating reports and sending to the clients as well as senior Management.
●According to analysis making the improvement plans.
●Engaged with the business to identify and define scope for continuous improvement activities.
●Coordinated with the onshore team to get the inputs.
●Validated the data as per the requirements.
●Prepared BRD and successfully accomplished the signoff.
●Solve issues by monitoring the issue Log.
●Created use cases and resolved all the requirements and gathered gaps.
●Identified bugs and updated in JIRA.
●Worked with a quality team on Integration testing, System testing, usability testing.
●Automated testing for UI.
●Participated in project reviews, benefits realisations efforts in analysing expected, and actual benefits.
●Performed root cause analysis, identified and followed up with all the necessary application teams involved in the Project.
●Methodology Used Agile
●Used SQL DB as database system.
Client Name: COVENTRY OCT 2008 – MAR 2011
Location: Remote Role: Business Analyst
Project brief Description: COVENTRY Insurance Project was to perform the GAP analysis and gather the information from the internal and external clients for participating and nonParticipating Providers information and the benefits and update the information in an internal application and post QC performed extract the data into CSV file and transfer through FTP. Also worked on high dollar claims (Medicare, Medicaid, Commercial insurances)
Role & Responsibilities
●Gathered Business Requirements through scheduling meetings with the business stakeholders.
●Mapped process flow; assess as-is a process through user interviews, data collection and analysis, design and evaluation of to-be process solutions.
●Led and conducted JAD sessions for requirements gathering.
●Prepared Business Object / Business Process Models that included modelling of all the activities of business from conceptual to procedural level.
●Assisted process owners in process training and implementation.
●Utilised SQL DB for data storage and retrieval process.
Client Name: HUMANA MAR 2006– SEP 2008
Location: Remote Role: Business Analyst
Project brief Description: Humana DCAV Project was to Gather the participating and nonParticipating Providers information and update the same in Provider Information Management System, which helps the claims to process in clearinghouse. Also, the demographic details help the customers to locate the participating provider with the location and phone numbers for scheduling the appointments. Also worked on Denial management for high dollar claims expertise in CMS knowledge.
Role & Responsibilities
●Gathered Business Requirements through brainstorming sessions on global calls.
●Led and conducted JAD sessions for requirements gathering.
●Mapped process flow: assess as-is a process through user interviews, data collection and analysis, design and evaluation of to-be process solutions.
●Prepared Business Object / Business Process Models that included modelling of all the activities of business from conceptual to procedural level.
●Worked with HL7, claims processing platforms like ClaimsXten
●Developed data conversion programs for membership, claims, and benefit accumulator data
●Provided programming and support for claims processing functions and auto-adjudication.
●Involved in Six Sigma process analysis.
●Assisted process owners in process training and implementation.
Contact this candidate