SUMMARY

• 7 years of experience in Business System Analyst in Healthcare and Pharma .
• Extensive experience in gathering Business and Functional Requirements, defining Business Scope.
• Vision Document, developing Business Requirement document, Functional specification document, communication plan, Use Cases, conducting Gap Analysis and Risk Analysis.
• Experience in SDLC, Agile, Waterfall and SCRUM software development methodologies.
• Experienced in creating Sequence Diagrams, Collaboration diagrams, Activity Diagrams, Class diagrams using Microsoft Visio.
• Experienced in Oracle 10g/11g, DB2, SQL/PLSQL and UNIX
• Expertise in writing SQL Queries and complex joins
• Skilled in visualizing, manipulating and analysing large datasets and also has ability of designing and developing effective reports.
• Proficient with MS Office Applicants, Excel (Pivot Table, Hlook UP, Vlook Up, CountIf, etc) and experienced with MS SQL Server .
• Proven success as a business analyst through the years, providing a well - balanced understanding of business relationships, business requirements, and technical solution.
• Profound knowledge of Data modeling including Star Schema and SnowFlake Dimensional Data Modeling.
• Strong Data profiling experience to derive statistical assessment of data values, evaluate structure and quality of data and identifying data anomalies & business rules exceptions.
• Ability to adapt in demanding, fast-paced environments requiring highly adaptive, flexible and resourceful technical skills.
• Sound understanding of Healthcare and Pharma domain and has excellent problem solving and communication skills.
• Adequate knowledge in Claims processing, COB, EOB/Drafts, HIPAA, enrolment, EDI, Medicare, and Medicaid
• Knowledge in OOPS concepts programming languages such as JAVA, python.

TECHNICAL SKILLS

SDLC Methodologies: Waterfall, Agile(Scrum, Kanaban)

Operating Systems (OS): Windows XP/8/10/Vista, Linux

Modeling Tools: MS Visio, Mock-up screen

Requirement Management Tools: JIRA, Confluence, ServiceNow for the tickets creation, SharePoint for document management

Languages: SQL, XML

Tools: / software: Putty, Splunk, IP Switch, Ultra Edit

ETL Tools: Informatica (Power Center), SQL Server Data Tools

Databases: MySQL, IBM DB2, Oracle

PROFESSIONAL EXPERIENCE

Confidential - Mason OH

Business System Analyst

Responsibilities:

• Worked with business stakeholders to define project scope, objectives, requirements, tasks, milestones, and measures of success and customer satisfaction.
• Utilized Agile, Scrum approaches for system development, testing, and implementation.
• Support the team at various points in the project, workflow assessment, Pre and Post production Check-out, Go-Live assistance.
• Preparing BRD and Mapping Document.
• Assist project manager in managing tasks.
• Elaborated high-level information into detailed plans throughout the project life cycle.
• Completed projects within budget, on time, and to the client’s satisfaction.
• Created swim-lane diagrams for depicting workflow.
• Worked with SQL queries for generating and pulling reports.
• Work with technical team to resolve client issues.
• Shared/Managed documents and other project elements through SharePoint.
• Defined project baselines, tracked project progress, and provided project status reports.
• Participated in developing and/or modifying requirements, business design specifications, user training and documentation.
• Translated business requirements to technical staff to ensure that requirements are incorporated into system design.
• Served as a liaison between users of the software and technical team.
• Assess business process and system inefficiencies, identify gaps between business requirements and application capabilities and recommend solutions using the fit-gap analysis.
• Manage requests/inquiries from product stakeholders of all levels across the organization.
• Participated in the quarterly PI planning sessions.
• Created a Team calendar to be used by team members to track important deliverable and Go-Live dates.

Environment: SharePoint, JIRA, Service-Now, MS Access, MS VISIO, Excel, IBM Data Studio, SQL Developer, Informatica, Splunk, Ultra Edit, IP Switch, Putty

Confidential - Owings Mills MD

Business System Analyst

Responsibilities:

• Analyse requirements, own and support the design, development, project management and implementation.
• Prepared documentation for all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, and glossary evolve and change during the project.
• Coordinated with DBA on database build and table normalizations and de-normalizations.
• Perform in-depth data analysis and load claims details from data warehousing to analyse, generate comprehensive reports to decision makers and other affected by the results.
• Used the Data Warehousing Life Cycle to identify data elements from the source systems, performed data analysis to come up with data cleansing and integration rules for the ETL process.
• Defined Functional Test Cases, documented, Executed test script in Facets system.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle.
• Worked on SQL queries in a dimensional data warehouse as well as a relational data warehouse.
• Recommend additional methods to analyse collect and manage data to improve data quality and efficiency of the data systems across the application.
• Involved in extensive data validation by writing several complexes SQL queries and involved in back-end testing and worked with data quality issues.
• Onsite and offshore coordination

Environment: Oracle, FACETS, Agile, Medicare, Medicaid, HIPAA-compliant patient information management and billing system and Microsoft Office package, SQL, MS Word, MS PowerPoint, MS Excel, MS Visio, Splunk

Confidential - Branchburg NJ

Business System Analyst

Responsibilities:

• Changing the existing URL configuration in the interface that point to the existing Tibco CIM application. The new URL will be pointed to the Upgraded environment configuration.
• Reimport the TIBCO CIM Schemas in the Interface code and rebuild executable.
• Change the database connections to point to the upgraded Environment.
• Change the Netrics server host name to point to the upgraded environment.
• Created Datasource, Repository, Input mapping, create and modify records in DEV environment.
• Consolidated UT and IT from old environment to new environment for data migration.
• Performing unit test and integrations test.
• Tracking and resolving moderate to complex defects.
• Created validation.xml file for data import.

Environment: Tibco MDM CIM (8.3.2), Tibco Business Studio (4.1.0), Oracle, Windows, Linux, MS Excel

Confidential

Business System Analyst

Responsibilities:

• Involved in all phases of Software Development lifecycle including requirement gathering, system design & development.
• Shared/Managed documents and other project elements through SharePoint.
• Fixed defects as needed during the QA phase, support QA testing, troubleshoot defects and analyse, identify the source of defects.
• Worked on SQL queries in a dimensional data warehouse as well as a relational data warehouse.
• Preparing BRD and Mapping Document.
• Interacted with multiple teams in understanding their business requirements for designing flexible and common component.
• Created complex SQL Queries to verify the provision changes for business requirements and perform Database testing.
• Recommend additional methods to analyse collect and manage data to improve data quality and efficiency of the data systems across the application.

Environment: SharePoint, JIRA, MS VISIO, Excel, My SQL, Splunk, Ultra Edit, IP Switch, Putty, Linux, Java and php.