Sr.Business Analyst Data

PROFESSIONAL SUMMARY:

Overall *+ Years of IT experience that involves Data Analyst, Business Analyst, Data Warehouse.

Data-driven, goal-oriented and customer focused business analyst with over 4+ years of experience conducting analysis and research to come up with solutions to common business problems.

Facilitated Joint Application Development (JAD) Sessions involving Subject Matter Experts (SME), Business Requirement Documents (BRD), Software Requirement Specification (SRS), and Functional Requirement Document (FRD) and maintained Requirement Traceability Matrix.

Acted as “voice of business”, with primary liaison between stakeholders and the team

Proven track record in leveraging data analytics and business intelligence tools to uncover insights, streamline operations, and boost profitability.

Highly proficient in strategic thinking, backlog tracking, and proactive coordinator with excellent communication skills.

Exceptional problem-solving and successful leading of cross-functional teams, with commitment to fostering innovation and achieving organizational goals.

Utilized structured tools for analysis and presentation of concepts and models to enhance the Business Requirement Document (BRD).

Strong experience in Business and Data Governance, Data Integration, MDM, NoSQL, and Metadata Management Services and Configuration Management.

Good experience in Data Modelling and Data Cleansing with expertise in creating Star & Snow-Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modelling using Erwin.

Conducted system analysis and data analysis between data dictionaries of Legacy systems and Actimize.

Experience with technical expertise in Data analyst, Data modelling, Business Intelligence, Data analytics, Python and its Data Analyst libraries, big data, Hadoop, QlikView/ Qlik sense, Power BI, DB2, SQL, DAX, Data stage, Congo’s.

Gathered requirements through various mediums such as workshops, sessions, interviews, document analysis, job shadowing, etc.

Experience in Lean Agile/ SCRUM model experience.

Expertise in Use case preparation, Functional requirements specification/ Business system Design, UML, MS Visio, Rational Requisite Pro, JAD sessions, Requirements Traceability Matrix, Mapping documents, Safe Agile and Gap Analysis.

Excellent experience with Progressive responsibilities in data analysis with a focus on financial reporting, and Data Warehouse DW, Business Intelligence BI, Enterprise Data Warehousing, ETL, Safe Agile, SCRUM, Client Server, and applications.

Good knowledge of web services with protocols SOAP, REST.

Hands-on experience in the areas Teradata, Informatica, DataStage, SAS, DB2, and Servlets.

Strong in analytical reporting using Advanced Excel features like VBA Macros, VLOOKUP, Pivot tables, Charts, Conditional formatting, Data Validation, formulating formulas, and other reporting tools like Crystal reports.

Analysed business requirements and documented them appropriately in the form of user stories in Jira and/or Azure DevOps.

Experience in writing Sub Queries, Stored Procedures, Triggers, Cursors, and Functions on MySQL and PostgreSQL database.

Able to write SQL scripts for analysis and reporting (Oracle /SQL server).

Working experience in Java.

WORK EXPERIENCE:

Client: Office of State Board of Education From: Oct 2024 - Present

Role: Sr. Business Analyst

Roles and Responsibilities:

Prepared Business Requirements Documents(BRD), Functional Requirements Documents(FRD) and Software Requirement Specifications(SRS) to define project objectives and align with stakeholder needs.

Wrote detailed user stories and acceptance criteria to guide development teams and ensure deliverables met business expectations.

Facilitated meetings, including requirement gathering sessions and review discussions, to ensure alignment and progress across teams.

Acted as liaison between stakeholders and technical temas to clarify requirements,address queries and resolve issues effectively.

Client: Covenant Healthcare, Knoxville, TN. From: Dec 2022- April 2023

Role: Data Analyst/ BI Business Analyst

Roles and Responsibilities:

Conducted data Mapping and data base change sessions, Identified the existing data fields in SharePoint data mart which is the centralized database for Aventis applications and required data fields for application.

Extensive experience in the Data Analysis, Data Quality, Data Integrity, Design, Development, Implementation and Testing of Business Intelligence applications using ETL and ELT methodology.

Hands on experience of SQL-Data Manipulation Language DML, Data Definition Language DDL and

Data control language dcl.

Led multiple cross-functional projects, resulting in a 20% reduction in operational costs through process optimization.

Participated in requirement gathering sessions with stakeholders to define business needs and project objectives.

Gathered and documented comprehensive business requirements, translating them into detailed technical specifications.

Conducted in-depth analysis of business processes, identifying inefficiencies and recommending improvements.

Utilize data modeling and analysis techniques to identify trends, opportunities, and areas for improvement.

Analyzed and interpreted data to provide actionable insights and recommendations to management.

Collaborated with cross-functional teams to gather, analyze, and document business requirements for healthcare applications, ensuring compliance with HIPAA and other healthcare regulations.

Conducted end-to-end data mapping for electronic health record (EHR) systems, identifying critical data fields for patient information, billing, and clinical management.

Led the integration of healthcare data from various legacy systems into a centralized SharePoint-based data mart, ensuring seamless data flow and improved reporting capabilities.

Developed and maintained interactive dashboards in Tableau and Power BI, providing real-time insights into patient admission trends, operational efficiency, and resource allocation.

Identified and resolved data discrepancies related to patient demographics and clinical records by performing root cause analysis and implementing data quality improvement measures.

Facilitated JAD sessions with healthcare stakeholders to streamline the claims management process and reduce operational bottlenecks.

Participated in UAT for new healthcare system enhancements, ensuring alignment with user expectations and clinical workflows.

Used rally to update stories, deliverables, features, test cases, defects etc.

Used Splunk logger for the application to analyze and track all the requests and response loggers.

Manage project timelines, risks, and deliverables, ensuring successful project execution and delivery.

Responsible for functional testing and participate in user acceptance testing (UAT) to ensure new systems and enhancements met business needs.

Achieved a 25% increase in customer satisfaction by implementing a new CRM system.

Mentored junior analysts, providing guidance on best practices in business analysis and project management, fostering a culture of continuous learning and development.

Client: CVS Pharmacy, Chicago, IL. From: Sep 2019- Nov 2022

Role: Data Analyst/ BI Business Analyst

Roles and Responsibilities:

Development and support of the key data integration and migration initiative for the conversion, integration and migration of data from different legacy systems to the central database system, from where it will be consumed for further business decisions.

Spearhead comprehensive business analysis initiatives for high-impact projects, ensuring alignment with organizational strategy and objectives.

Facilitate strategic planning sessions with senior leadership to identify business opportunities and define project scope.

Conducted comprehensive business analysis to support key initiatives and strategic goals.

Performed Gap analysis to analyze and evaluate both current and proposed business processes by identifying existing technologies and documenting the enhancements to meet the end-state requirements.

Analyzed and interpreted complex data sets to provide actionable insights and recommendations.

Collaborated with vendor software developers, resulting in faster implementation of critical features and ensured shared understanding of the business model and detailed function requirement.

Oversee the development of detailed business requirements, process maps, and functional specifications.

Utilize advanced data analysis techniques to identify key trends, inform decision-making, and drive business improvements.

Managed end-to-end project lifecycles, ensuring timely delivery of key milestones and objectives.

Achieved a great increase in incident resolution speed by identifying and implementing improvement opportunities.

Manage a backlog of user stories, prioritizing releases and improving project timelines.

Create end-user training materials based on project requirements.

Client: Morgan Stanley, New York, NY. From: Sep 2017- Aug 2019

Role: Data Analyst/ Business Analyst

Roles and Responsibilities:

Reviewed and analyzed the business environment and identified process improvements.

Interacted with Business Users to conduct thorough Requirements Analysis.

Created and scheduled Sessions based on demand, run on time, and run only once using Informatica Server Manager.

Document all data mapping and transformation processes in the Functional Design documents based on the business requirements.

Worked with any one or more reporting tools like Cognos, PowerBI, Tableau, Alteryx, and Oracle Financials.

Conducted JAD sessions to identify Business Requirements and then documented them into technical Requirements for the technical team

Analysed business requirements and documented them appropriately in the form of user stories in Jira and/or Azure DevOps.

Provided continued maintenance and development of bug fixes for the existing and new Power BI Reports.

Created and maintained product backlog items, bugs, features, etc. in JIRA and TFS / Azure DevOps for story tracking and documentation.

Created a Source-to-target Data mapping document of input /output attributes with the proper transformations which would help for the easy development of SSIS Bridge.

Extensive exposure to Microsoft Azure cloud computing concepts & fundamentals.

Expertise and hands-on experience in SQL and RDBMS for Analysis, Reporting, and testing purposes.

Performed data mining using PL/SQL on Oracle, RDBMS, SQL on Sybase, and MS Excel and Access that included data comparison, ad hoc reports, and statistic reports.

Assisted in facilitating Scrum Ceremonies like Sprint Planning, Daily Scrum/Stand Up meetings, Sprint Review, and Retrospective meetings.

Responsible for data mapping and data mediation between the source data table and WMO data tables using MS Access and MS Excel.

Coordinated with other Scrum masters to synchronize cross-team dependencies.

Merged Excel files into SharePoint.

Extensive use of JIRA to create user stories.

Actively participated in the UAT transition, retested UAT defects, and updated comments in JIRA

Performed Data mapping, and logical data modelling, created class diagrams and ER diagrams, and used SQL queries to filter data.

Act as timely contact for UAT issues and production issues

Reviewed and analyzed the use cases and came up with system design and test plan templates.

Client: Jade Global Software Pvt Ltd, India. From: Apr 2016- Aug 2017

Role: Data Analyst

Roles and Responsibilities:

Demonstrated expertise in optimizing Databricks clusters and tuning performance parameters, ensuring efficient and scalable data processing for enhanced system performance.

Implemented robust data governance practices within Databricks, ensuring compliance with industry regulations and maintaining data integrity throughout the analytics lifecycle.

Devised UML diagrams (Use Cases, Activity, Sequence and Class Diagrams) to capture the dynamic behavior of different applications.

Used SQL queries to extract data for report generation and minus queries to narrow down data to only key components.

Worked on development of data warehouse, Data Lake and ETL systems using relational and non-relational tools like SQL, NoSQL.

Implemented Selenium to automate transactions as part of the Proof of Concept (POC).

Performed testing over various testing cycles such as system, functional, and regression testing.

Actively participated in test plan, test cases review.

Responsible for System Testing, Regression Testing.

Bug validation, timely reporting, handling DCR (Design Change Requests).

Worked closely with Scrum Master and other project stakeholders and attended daily sprints.

Promoted requirements traceability back to business objectives with an integration with design, development, and testing teams.

Education:

Bachelor of Technology in Computer Science and Information Technology, JNTU University

Contact this candidate