SUMMARY

• Around 6+ years of Business Analyst experience with a solid understanding of business process analysis in a web - based and client-server environment.
• Experienced with all phases of the SDLC utilizing Agile and Waterfall methodologies within various industries.
• Experience in the adoption process of a Lean-Agile mindset within the organization.
• Experience in supporting and executing PI Planning events and coordinating multiple Agile Release Trains (ARTs).
• Expertise in Data-warehouse and Data-mart, including noledge OLAP.Extensive experience in Databases like SQL Server, Oracle.
• Experience in writing SQL queries and optimizing the queries in Sybase IQ and SQL Server.
• Experience in client requirement Analysis, Physical, Logical design, Development, Resource Planning.
• Extensive experience in gathering business requirements, business processes, identifying risks, GAP analysis, and UML modeling including Use Cases, Sequence, State, and Activity Diagrams using tools such as Microsoft Visio.
• Testing, Development, Support, and Maintenance of Business applications.
• Extensive experience in conducting Market Research, Feasibility Studies, Data Analysis, Data Mapping Gap Analyses, Risk Identification, Risk Assessment, Risks Analyses, and Risk management
• Excellent working experience on JIRA, ALM, and Confluence.
• Understanding ofWebservice, HTTP, XSD,andJSON.
• Experienced in full life cycle MDM development including data analysis, database design, data mapping, and data load in batch.
• Experience in analysis, design of API in API Connect, and API Manager.
• Experience with data lake work streams implementations and data ingestion.
• Extensive experience in Strategic development of a Data Warehouse and Performing Data Analysis and Data Mapping from an Operational Data Store to an Enterprise Data Warehouse.
• Good experience in whole Life Insurance, Term life insurance, and Voluntary Insurance, on the different Policy administration system, Rating Engine, Form Storage, Rating databases, Pricing, Underwriting process, Claims Process, Billing, etc.
• Experience in Property & Casualty, Life Insurance, Annuities, pension- and retirement-related investments, Mutual Funds, Group Insurance, Retirement Services, Investment Management.
• Experienced in working with Data Resource Management team (DRM), Enterprise Metadata Repository team (EMR), Corporate Data Dictionary team (CDD), data Integration of enterprise data assets.
• Extensive experience in developing Use Cases, creating Screen Mockups, conducting Gap Analysis and Impact Analysis, Cost-Benefit Analysis, Risk Analysis.
• Analytical, methodical, and resourceful approach to Problem Solving, Root - Cause Analysis, Conflict Resolution, Negotiation Strategies, and providing corrective actions to meet business requirements.
• Expertise in providing end to end ETL (Extraction Transformation and Load) solutions using Trifecta.
• Expertise in creating prototypes and mockups for user interface designs.
• Proficient in all phases of Requirement Management, including gathering, analyzing, detailing, and tracking requirements.
• Well versed with ANSI X12, HIPAA, and HL7 standards.
• Facet's support systems were used to enable inbound/outbound HIPAA EDI transactions in support of HIPAA 834, 835 /271 transactions.
• Extensive experience in Healthcare/Claimsadjudication with noledge of industry compliance standards like HIPAA and EDI X12 transactions (834, 837, 835,274, 270/271, 276/277,278)
• Experienced in full life cycle MDM development including data analysis, database design, data mapping, and data load in batch.
• Knowledgeable in Data Warehousing such as MS SQL Server, Oracle, Postgre SQL, Mongo DB.

TECHNICAL SKILLS

Microsoft Technologies: MS Project, Visio, Excel, Word, Outlook, PowerPoint

Requirements Management: Rational RequisitePro, AHA, JIRA

Business Modeling: Rational Rose, MS Visio, Lucid Charts

Defect Tracking Tools: HP Quality Center, Rational ClearQuest

Languages/Standards: SQL, XML, JSON, HTTP, Java, HIPPA, ANSIX12,Rest API

Methodologies: Agile, Waterfall, Kanban, Scrum, Agile, SAFE Agile

PROFESSIONAL EXPERIENCE

Confidential, Fort Worth, TX

Senior Business Data Analyst

Responsibilities:

• Involved in Business requirement gathering, Technical Design Documents, Business use Cases, and data mapping.
• Design of Mapping Sheets for the Complex Views and Business Views for a build of Business views.
• Involved in performed analysis on static and dynamic reports and views for county District Clerk, County Clerk, Sherriff office.
• Worked independently to elicit and prioritize requirements from business users by using interviews, document analysis, requirements workshops, business process descriptions, etc.
• Developed sample screens and when required worked closely with an Information architect/designer to develop an application prototype.
• Involved in designing system architecture understanding of request, and response flow. Understanding appropriate technologies for business requirements (SOAP, REST, AJAX, JSON, and XML). Gathered requirements for Client-Side Validation, and Server-Side Validation. Experience in API documentation.
• Worked with third-party vendors to clarify the requirements.
• Worked on Data Analysis, Data Profiling, Mapping, Identify Data Quality issues, Data Cleaning, Data validation, and Loading.
• Developed Complex Weekly and Monthly reports using advanced SQL and properly documented the scripts based on company standards.
• Frequently used different Aggregate and OLAP functions often with multiple derived tables.
• Created graphical representation of reports such as Bar charts, Line Charts as per Business requirements.
• Create &Perform Unit & Integration Test Cases, UAT Test Case Review, and Turn over to Production.
• Active interaction with business users, participating in onshore-offshore conferences with the client, downstream business users, and other vendors under consideration.
• Work closely with business users, OR-Analyst, and engineers to gather multiple data source requirements, and developed complex Tableau dashboards.
• Prepare and conduct Unit Testing and User Acceptance Testing scripts and Bug Tracking.
• Wrote complex SQL queries in support of ad hoc data requests, and to validate report data to requirements.
• Excellent understanding of BI Best Practices/Methodologies, relational structures, dimensional data modeling, SQL, data warehouse. ETL mapping and reporting techniques.
• Manage large/medium size projects as a team member or lead to implement new functionalities and enhance existing functionalities including articulating, analyzing requirements, and translating them into TEMPeffective solutions.
• Managed project portfolio for SDO project planning, and resource allocation using HP PPM and advanced Excel skills for project planning and scheduling.
• Work with cross-functional teams to prioritize work and drive system solutions by clearly articulating business needs.

Environment: Microsoft Azure, SharePoint 2007, JSON, XML, JIRA, Oracle, Quality Center, Rest API, Soap UI, Main-Frame, MS SQL, SOA, Postman, Mulesoft

Confidential, Dallas, TX

Senior Business Data Analyst

Responsibilities:

• Performed Requirement Gathering by interacting with Business users and documented the requirements
• Performed Data Mapping to map the EDI 834 data to ELDM.
• Performed Gap Analysis to review the existing XML XSD and make necessary changes.
• Worked with XML files and suggested changes to the XSD.
• Work on EDI X12 transactions, HIPAA standard transaction codes including 837, 834, 835, 270, 271, 276, 277 and perform analysis of such transactions.
• Collaborate withUI/UX, API, and System teamsto support development initiatives Knowledge ofJSONinvolved.
• Defined user stories in JIRA by creating tickets and elaborated stories to offsite development and QA teams.
• Conducted JAD Sessions, Peer Review sessions with the SMEs, Solution Engineers, developers, Business users.
• Analyzed the scope of the project to review it with the customers for different review sessions of the application.
• Analytical, methodical, and resourceful approach to Problem Solving, Root - Cause Analysis, Conflict Resolution, Negotiation Strategies, and providing corrective actions to meet business requirements.
• Working with the business operations, applications teams, and data management team to resolve problems, perform root-cause-analysis (RCA), and implement RCA finding to prevent repeat problems.
• Intensively involved in project testing efforts by doing System Integration Testing, Regression Testing, and by halping the UAT team in User Acceptance Testing.
• Perform UAT for each user story ticket created in JIRA during each sprint release.
• Created and maintained the Data Model repository as per company standards.
• Used to execute test cases for several transactions such as 837, 835, 874, 834, 277, 278, 270/271
• Create SQL queries to read data from databases.
• Worked with the Testing team to test the system extensively and log defects.
• Data mapping for the X12 820, 834, 835, 270, 271, 274 EDI membership enrollment files, and member records.
• Involved in Source Data Analysis and Designing Mappings for data extraction also responsible for Design and
• Recognized subject matter expert in interoperability standards: HL7, CDA (Clinical Document Architecture).
• Extensively used JIRA for maintaining User Story Hierarchy, Backlog Grooming, Updating Tasks.
• Performed gap analysis between standard Microsoft Dynamics NAV functionality and business requirements.
• Responsible for identifying and documenting business rules and creating detailed Use Cases
• Participated in the process of internal and external auditing activities and developed timelines for project delivery, and managed projects and resources to successful completion.
• Analyzed the existing reports of the reporting system in the database. Checked the consistency of the data after the ETL process using SQL queries.
• Created ETL documentation such as EDI X12 837(P, I, D), 834 and 835 Data Mapping, Transformation logic for Main Frame Layout, Updating Metadata documents for new Platform.
• Worked with ANSI X12 HIPAA EDI Transactions 270, 271, 276, 277, 837, 835,274.
• Created and maintained data mapping document(s) in reference to the HIPAA transactions: 270/271, 276/277, 837, and 835.
• Involved in data dictionary management, extraction, transformation, and loading (ETL) of data from various sources. Participated in ETL requirements process during data transition from source systems to target systems
• Involved in Data Analysis & Mapping to track all data elements used in the application from the user interface through different interfaces to the target databases in which they are stored.
• Writing Complex SQL queries and optimizing SQL Queries.
• Conducted GAP analysis against regulatory requirements and prepared remediation plans.
• Used JIRA and AHA to create requirement stories, task tickets, and bug tickets to manage and track project releases.
• Participated in creating logical and physical data models, their enhancement. Based on the data models, working with the business architect, to create the software solution models.
• Helped in creating Data-Mapping best practices document including visual processes and trained team members on Data Mapping process and tools.

Environment: AWS, S3 Data lake, PostgreSQL, SharePoint 2007, X-12 transactions, JSON, XML, HL-7, Privacy analytics, Genrocket, Alteryx, Trifacta, JIRA, Oracle, Quality Center, Amazon Redshift

Confidential, Boston, MA

Business Data Analyst

Responsibilities:

• Create a project plan to discuss with the business the current process and future process and send out the minutes of the meeting to update the team.
• Organized participated, documented, and provided feedback and suggestions in the sessions and performed process improvement. Worked with XML files, which form the intermediate, stage outputs, and which form the intermediate input for the next stages.
• Analyzed life insurance processes and procedures to conceptualize the New Business Enrolment process, Commissions Process, and Claims process.
• Write SQL queries and do data analysis based on the requirement.
• Directly Support client testing and onboarding of DTCC standards.
• Analyzing query results in Excel, creating pivot table/chart reports, etc., and sharing them with Master data management team members.
• Developed Test Plans, Test Cases, and Test Script and worked with MDM systems.
• Liaise with process stakeholders on an ongoing basis to ensure process adherence and controls
• Provide business requirements, coordinate UAT, and post Go-Live activities, and Prod issue investigation.
• Responsible for writing Functional Requirement Specifications (FRS) and User Requirement Specification (URS).
• Used Rational Requisite Pro to manage the requirements document and trace them back against the functionalities or features included in the BRs and the application.
• Developed various UML diagrams like Activity diagrams, Class diagrams.
• Communicated progress and gathered more information about the requirements during the JAD sessions with the Module leads, Managers and Test Leads.
• Participated in managing the change requests, prioritizing, estimating, and delivering the same.
• Assisted in design review meetings making sure all the requirements are covered in the development project scope.
• Provide production support and solution to the business/stakeholders for their daily problems.
• Write SQL queries and do data analysis based on the requirement.

Environment: Java, RequisitePro, Rational Rose, SharePoint, Hadoop File system, Dbeaver, JIRA, Service Now

Confidential, Kentucky, KY

Business Analyst

Responsibilities:

• Performed Requirement Gathering by interacting with Business users and documented the requirements
• Performed Data Mapping to map the EDI 834 data to XML.
• Performed Gap Analysis to review the existing XML XSD and make necessary changes.
• Worked with XML files and suggested changes to the XSD.
• Created requirements and mapping for 834 Enrollment, 835 Claim Payments, 274 Provider, NPPES, and 278 Referrals.
• Conducted a thorough analysis of the Business Requirements and created design specifications to accomplish and achieve business needs related to Healthcare EDI X12 transactions such as 278 for authorization and referrals.
• Defined user stories in JIRA by creating tickets and elaborated stories to offsite development and QA teams.
• Conducted JAD Sessions, Peer Review sessions with the SMEs, Solution Engineers, developers, Business users.
• Analyzed the scope of the project to review it with the customers for different review sessions of the application.
• Intensively involved in project testing efforts by doing System Integration Testing, Regression Testing, and by halping the UAT team in User Acceptance Testing.
• Perform UAT for each user story ticket created in JIRA during each sprint release.
• Created and maintained the Data Model repository as per company standards.
• Used to execute test cases for several transactions such as 837, 835, 820, 834, 277, 278, 270/271
• Create SQL queries to read data from databases.
• Worked with the Testing team to test the system extensively and log defects.
• Streamlined Claims (837 EDI X12) Migration project by gathering functional specifications inEDIFECS.

Environment: MS Office Tools, SharePoint 2007, X-12, MS-PowerPoint, JIRA, SQL Server 2005, XML, Quality Center, HL-7