SUMMARY:

• Motivated, goal - focused, self-starter, detailed-oriented and results-driven Business Systems Analyst with demonstrated success in analyzing business requirements and data analysis with over 7 years of healthcare industry experience.
• Excellent analytical and problem-solving skills in designing, developing, and implementing innovative business process and providing system solutions using new approaches & technologies for Finance and Insurance applications.
• Experienced with all phases of software development life cycle with in-depth knowledge of Waterfall, RUP and AGILE methodologies.
• Extensive experience in Data Analysis and creating Data Mapping specification documents.
• Experience in data modeling concepts & creating data models.
• Experience in building Data Mart with Normalized and De-normalized schemas.
• Understanding of the Database schemas like Star Schema and Snowflake Schema used in relational and dimensional modeling.
• Familiar with different analysis techniques; GAP Analysis, Root-Cause Analysis, Object Oriented Analysis, Feasibility Analysis, Risk Analysis, Impact Analysis.
• Assisted and mentored several new Data Analysts in the team.
• Experience in HIPPA Compliance.
• Experience with ETL and BI platforms in creating requirements and providing solutions to manage Master Data.
• Experience in MDM projects and concepts, performed Data quality analysis and data profiling.
• Experienced in ServiceNow, including Project Charters & Incident Management requests, analysis and implementation.
• Experience in SCRUM and maintaining TFS backlogs and SPRINTS.
• Hands-on experience building and analyzing of Web Portals.
• Extensive experience in gathering and analyzing User, Business and Functional requirements, through interviews, seminars, surveys and questionnaires, drafting vision and scope documents, creating the BRD and FRD.
• Proficiency in UML - Use Case diagrams, Activity Diagrams, functional Diagram, Sequence Diagrams, and Analysis & Design with Interaction diagrams.
• Excellent interpersonal communication and conflict resolving skills with expertise in moderating team meetings.
• Strong expertise in analyzing and documenting existing business processes, developing work flow diagrams and process flow diagrams, working with requirements traceability matrix and re-engineering business processes.
• Experience in integration of data sources like MS SQL Server, Teradata, DB2, Oracle, Flat Files and XML files.
• Highly motivated team player with attention to detail and always willing to work in challenging and cross-platform environment.

TECHNICAL SKILLS:

Business Modeling Tools: Microsoft Visio, Snag It, Front Page, Power Designer.

Databases: SQL server, IBM DB2, MS Access, Teradata

Methodologies: AGILE, Waterfall

Languages: Fundamentals - SQL, HTML, Visual Basic

Operating Systems: LINUX/UNIX, MS DOS, All Windows platforms

Processes/Technologies: SDLC, SCRUM

Software/Applications: MS SQL Server, Informatica, SSRS, SSIS, SAS, MS Office, MS Project, Quality Centre, IBM Rational Rose, Informatica Analyst, SoapUI, WinSql, SqlDBX, RedGate, Altova XML Spy, Adobe Photoshop, Power Designer Viewer, Micro Strategy, TFS, Trello, ServiceNow, Tableau, MS Power BI, Micro Strategy, Teradata, Erwin, Power Center

PROFESSIONAL EXPERIENCE:

Business Systems Analyst

Confidential, Aliso Viejo, CA

Responsibilities:

• Extensively worked on eliciting requirements from Business users and other stakeholders.
• Experience in Healthcare concepts like Managed care, understanding of Claims, Provider, Pharmacy, HEDIS, HCC etc.
• Coordinated with inter-teams to facilitate the impediments on dependencies.
• Worked on Ad-Hoc reporting requested by business users and provided support on critical reporting asks.
• Performed data analysis based on requirement and provided feedback to stakeholders if requested data was available and useable for reporting.
• Created Source to Target Mappings for developers to be able to complete the development when data was available in several different data sources.
• Created Tech Specs for developers based on requirement and data source.
• Worked very closely with developers to translate the business requirement into functional requirements.
• Performed analysis for Data Mart build outs based on available data elements and normalized and de-normalized approaches.
• Performed data warehouse table level analysis and solution Data modeling diagrams for Data Marts
• Documented BRDs based on requirement gathered from business users via different elicitation techniques such as brainstorming, Interviews/meetings, use cases, document analysis, sequence diagrams etc.
• Conducted SCRUM meetings for the team to get daily status updates and discussed and facilitate any roadblocks.
• Reviewed new project charters and provided approval based on available requirements submitted.
• Discussed project charters with the team and provided detailed insight about the request during backlog grooming and estimated the effort.
• Created User Stories in TFS and allocated in SPRINTS based on prioritized requirements with Product Owner.
• Assigned user stories to the developers and story points in Sprint Planning sessions.
• Extensively worked on IT bugs, analyzed and provided information to the developers and facilitated in current sprints cycles based on priority and complexity.
• Handled offshore team of developers and prioritized assignment, supported development activities and provided necessary documentation and requirements to compete the tasks.
• Performed QA on reports after development was completed and validated it with business requirements.
• Assisted in UAT session to business users and provided necessary insights regarding data captured and availability on applications.

Data Analyst

Confidential, Dayton, OH

Responsibilities:

• Supported Finance and Member Enrollment Business department and areas. Prepared several ad-hoc, periodic reports and dashboards.
• Also, worked extensively on two separate state’s Regulatory Reports. Acted as ‘Point of Contact’ in the IT department for the regulatory reports and generated several reports that were due to the respective state’s Department of Medicaid in accordance with compliance.
• Extensively worked on Ad-Hoc Business and State Regulatory reporting.
• Extensive experience in Relational Databases and BI reports tools using Micro Strategy, SSRS etc.
• Worked on several reporting requirements with focus on Finance, Member Enrollment in Medicaid, Medicare Advantage and MyCare Business areas for reporting requirements for the respective Business Owners.
• Gathered and analyzed requirements as per business needs and documented into reporting specification documents.
• Performed detailed data discovery and Data source analysis in Data Warehouse to ensure the availability of the required data.
• Worked closely with BI developers to help them understand the requirement to create the dashboard.
• Understand the requirement and create any required logics/algorithms or computation for the desired output data field.
• Create SQL queries for data profiling, logics and to get the final outputs values for the reports.
• Engaged business and stakeholders in the User Acceptance Testing.
• Key point of contact and acted as a bridge from Business to the Analytics and to the IT developers for clarification, any escalation and facilitation.
• Performed Testing on Business Intelligence reports and dashboards.
• Provided detailed walk-through of SQL queries to the team and reporting output to the stakeholders.
• Completed Technical Reviews, validated and Approved Data mappings and reports completed by other Data Analysts.
• Conducted and lead meetingswhen dashboards development was completed and available for Business/Users review.
• Produced reports that involved HEDIS codes analysis and strong dependency on HEDIS codes.
• Created Source to Target Data Mapping documents and formulated the transformation/Business rules and write SQL queries to support the data transformation and documentation purposes.
• Collaborate with data architect to document functional requirements describing the ETL workflow process.
• Created temp. Tables and used other methods during Data analysis when all the data in not available on the same server and databases.
• Wrote complex SQL queries with Analytical functions to get desired results as per the requirements.
• Joined several tables and databases as a part of the logic and wrote complex SQL queries.
• Performed gap analysis between current and future state of the Data Warehouse.
• Created several Data mapping and Data design documents when Data warehouse was moving from Legacy to Future state and all the existing tables were moved from different servers such as SQL Server, Teradata etc.
• Communicated clearly new findings, issues or predicted possible challenges during meetings.

Confidential, Dayton, OH

Responsibilities:

• Actively participated in requirements gathering sessions and provided insightful perspective from technical standpoint.
• Drafted technical specification document and reviewed with the team.
• Based on requirement analyzed the data warehouse and performed the data discovery.
• Conducted gap analysis for the requirements and data available in the EDW.
• Performed detailed data analysis on Medical claims, Member, provider and Pharmacy data sets.
• Created outbound and inbound source to target mapping documents between different stages in the project and walkthrough the team and developers
• Completed Data Mapping documents for Medical Claims, Member and Provider etc. subject areas.
• Worked closely with ETL developers and provided assistance with pseudo codes.
• Created mappings for incoming files from FICO and provided logic on how to store the files.
• Provided analytical support for business operations for Business areas such as Claims Data, Members Data, Provider Data, HEDIS data set, and Pharmacy data.
• Actively worked with FICO on validating the outbound data.
• Assisted with UAT for inbound files and incoming provider data.

Confidential, Dayton, OH

Responsibilities:

• InitiallyWaterfall method were used and later on transitioned into the AGILE methodology in this project.
• Gathered business and technical requirements from Business and the vendor ’Milliman’ and documented in the functional requirement document.
• Drafted process and data flow diagrams for the team.
• Performed Data Analysis for the claims/member/provider and Pharmacy data sets.
• Created Source to Target Data Mapping documents for medical and pharmacy claims, Member and Provider data sets.
• Extract, Load and Transformed large amounts of Claims, Members, Provider, and Pharmacy Data, and assisted in Data models on how to structure the tables in the enterprise warehouse.
• Actively involved and provide assistance to Data modeler in creating the data model, views and new tables as required
• Conducted several walkthrough sessions during the analysis and development phase to Data modelers, Developers and testing teams.
• Provided support to ETL developers in understanding the transformation logic and business rules applied in the source to target mapping document.
• Worked with Quality Assurance Analysts (QAs) during testing, data validation and helped understanding the business requirements.
• Provided solutions and fixed any defects that were raised during the testing or while ETL development.

Data Analyst

Confidential, Buffalo, NY

Responsibilities:

• Followed AGILE methodology throughout and provided daily status report to the implementation leads.
• Been actively involved in Daily SCRUM meetings with key roles and inputs.
• Prepared Business Glossary and Data Dictionary documents.
• Captured Data Quality Rules and Business rules related with data.
• Conducted Data quality analysis and checks by data profiling in MDM data.
• Gathered user and business requirements through open-ended discussions, brainstorming sessions and other requirement gathering strategies.
• Developed detailed Data Mapping documents from several stages in the data flow and provided walkthrough to the ETL developers along with rest of the team.
• Involved actively with Data Modelers and assisted them with Data Modeling related requirements.
• Conducted walkthroughs with the end users and Product owners to gather the modification requests from the user to upgrade or change the business specification for the product.
• Performed Data testing by writing SQL queries to the database.

Data Analyst

Confidential, Buffalo, NY

Responsibilities:

• Worked with system owners to translate business requirements into business rules.
• Worked with Data Architects to support standard data handling rules
• Gathered requirements from System owners to resolve data issues and refine business and transformation rules
• Performed source-to-target data analysis for various HealthNow vendors.
• Created Mapping specification from various sources to HN databases.
• Documented business, data handling, and transformation rules in Source-to-Target Mapping
• Supported developer efforts to design Data Integration Workflows
• Ensured adherence to locally defined data standards for all developed components
• Participated in design and development reviews
• Assisted Data Modelers with data modeling requirements and data mapping to create new tables/views.

Data Analyst

Confidential, Buffalo, NY

Responsibilities:

• Performed detailed analysis of the entire payment process flow.
• Gathered requirements from business and users requirement in one to one discussions.
• Documented the technical details and data requirements.
• Performed detailed exercise to translate the business requirements into technical specifications and generated transformation rules.
• Developed details use cases for better understanding for the entire flow of transactions
• Created Mapping documents with in-depth details of the process flow, business rules and structure of the data flow for ETL.
• Given walkthrough to developers and other team members.

Data Analyst

Confidential, Buffalo, NY

Responsibilities:

• Gathered user and business requirements through open-ended discussions, brainstorming sessions and other requirement gathering strategies.
• Worked with a cross functional and diverse team of business users and developers to enable accurate communication of requirements and ensure consensus.
• Created ETL Requirements to migrate data from Legacy system to Current system with proper validations.
• Conducted walkthroughs with the end users and stakeholders to gather the modification requests from the user to upgrade or change the business specification for the product.
• Followed AGILE methodology and provided daily status report to the implementation leads.
• Performed GAP Analysis by identifying existing requirements and end state requirements and documented the gap.
• Developed detailed Data Mapping documents and provided walkthrough to the ETL developers.
• Conducted meetings with business SMEs to gather requirements, to get the documents reviewed.
• Performed detailed Data Profiling using the Informatica Analytics profiling tool.
• Tested Data by writing SQL queries to the database and with the help of profiling tool.

Data Analyst

Confidential, Buffalo, NY

Responsibilities:

• Worked with the core team to gather businessrequirements from multiple stakeholders, SMEs and management groups - and reconciled conflicts by conducting Joint Application Development (JAD) sessions based on the project scope.
• Analyzed Business Requirements and segregated them into high and low level Use Cases and Activity Diagrams using MS Visio.
• Performed GAP analysis involving the current state and proposed future state.
• Worked closely with other BAs and ETL Leads/Managers and was responsible to perform detailed data requirements analysis and create design specifications and operational documentation.
• Created Data mapping documents analyzed the requirements and put them in a business rules in mapping documents.
• Provided and walkthrough the ETL team with the Data mapping document and assisted them to create the mappings.
• Worked closely with the architects, database administrators and technical team during Data Mapping and Data Integration
• Analyzed and presented the Business with information on data anomalies, issues, input errors, field value ranges, data patterns, referential integrity gaps and the level of record incompleteness that is in the source systems.
• Participated in various sessions with Business to understand the business rules and to come up with naming conventions to standardize the data.