SUMMARY:

• Business Analyst 8+ years of experience in health domain with a wide - ranging knowledge of all aspects of Software Development Life Cycle (SDLC) Extensive knowledge, expertise and involvement in various phases of Software Development Life Cycle (SDLC) in Waterfall, Agile, SAFE, Agile-Extreme Programming methodologies.
• Experience working in the Safe Agile environment and using HEDIS to measure performance
• HealthCare domain experience in projects involving the customization, design, development, implementation, and testing of automated systems to support the Automated Claims Processing as well as day-to-day business operations.
• Business analysis, project management, testing and UAT management for the data warehouse SSRS and Tableau reporting and analytics portion of the company-wide migration from Great Plains to the Workday ERP system.
• Adept in writing SQL queries for data extraction, manipulation, analysis, and validation, generating user reports and proficient knowledge of Relational Database Management Systems (RDBMS), and Data Warehousing.
• Involved in research and preparing a presentation for the Analytics project which included Risk Stratification, Simulation and Provider Mapping.
• Experience in payer domain System Integration with Health plans eligibility and claim information.
• Involved in Creating prototypes forms in MS PowerPoint for better visualization and understanding of the software solution.
• Our Entitlement for the project is to provide Care for the maximum number of members through Case and Disease Management. IBC migrating its Membership, Claims, Encounters and Lab Results data to External vendors to perform the members Risk Stratification.
• Experience in conducting GAP analysis, SWOT analysis, User Acceptance Testing (UAT), Impact analysis, Risk analysis and mitigation plan, depth in writing SQL queries for data extraction, manipulation, analysis, and validation, generating user reports and proficient knowledge of Relational Database Management Systems (RDBMS), and Data Warehousing.
• Strong knowledge in Health Administration - Claims processing (auto adjudication), Claims pricing, HIPAA, enrollment, EDI, Medicare and Medicaid Systems, CDHP (consumer driven health plans), FACETS Systems at Payer Side.
• Worked in software like Argus, Facets and its modules such as Claim, Member/Subscriber, Billing, Payer, Provider, Medicare, and Medicaid and experienced with several Batches.
• Cooperated with the Project Manager to create Project Charter, Work Breakdown Structures and Project Plans and acted as a bridge between the business and IT, translating customer needs into a vision of a fully functional product.
• BSA role implementing new Twiage application at Hunterdon Medical Center for EMS workers and Hospital staff to accelerate life-saving care for Patients and to alert the ED for efficient preparation for staff.
• Facilitating Change Management and Impact Analysis at various stages of the project Life Cycle by streamlining communication among the project stakeholders and interacting with Change Control Board. Also experienced in documenting, managing, facilitating the Requirement Changes in the Scrum environments using tools like Rally, JIRA.
• Well acquainted with Business Process Management and Unified Modeling Language (UML) diagrams including Use Cases, Activity Charts, Sequence Diagrams, Data Flow Diagrams, and ER Diagrams using the tools like MS Visio.
• Used Agile Workbench to directly capture user stories and used JIRA for issue tracking and generated reports to analyze the performance of the project/team.
• Participated in user meetings to understand requirements for Clients. Designed physical and logical data maps for handling operational and analytical databases.
• Excellent analytical skills for understanding and gathering the requirements, business rules/processes, generating use case models and analyzing Data Flow Diagrams.
• Involved in production support by monitoring log files on a daily basis and assisting teams
• Experience in creating Test Plan and Test Cases for Functional and Nonfunctional requirements.
• Assisted Project Managers in preparing Project Plans and status reports in MS Project.
• Energetic, positive, and self-motivated. Ability to adapt quickly to challenges and changing environments. Adept at multitasking various projects at one time, while maintaining high attention to detail.
• Excellent verbal/written communication skills and strong analytical abilities. Can perform well both independently and as a team player.
• Great presentation and leadership skills, with a strong ability to engage technical and non-technical audiences when describing complex business processes.
• Exceptional people skills when interacting with business professionals; from the highest echelons to the lowest possible echelons within an organization.

TECHNICAL SKILLS:

Operating Systems: Windows XP/Vista/7/8/10, Linux, Unix, Macintosh / iOS

AgileScrum, Waterfall, Waterfall: Scrum Hybrid and Rational Unified Process

Project Management: MS Project, MS SharePoint Server

Office Tools: MS Word, MS Excel, MS PowerPoint, MS Project, MS BI

Databases: MySQL, SQL server, MS Access

Modeling Languages: UML, SQL, PL/SQL

Modeling Tools: MS Visio, MySQL, Visual Studio, Rational Rose, Rational Requisite Pro, Azure

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, Texas.

Business/Data Analyst

Responsibilities:

• Work directly with government financial systems to plan, forecast, budget, and manage programs and projects
• Provide support to program personnel who require CCaR technical and subject matter assistance
• Provide one-on-one and group on-site Web CCaR training for Financial and Program managers
• Provide CCaR Administrator support with granting access, authorities and privileges; unlocking accounts; processing maximum access requests; creating and maintaining accounts and databases.
• Worked with 14M Schedule - Domestic First Lien Closed-End 1-4 Family Residential Mortgage.
• Created Business rules for the Critical Data Elements.
• Involved in QA - Data Quality validated the Data Quality Business Rules for Completeness, Accuracy and Validity.
• Worked on Data Lineage: mapping the Critical Data Elements from Source Systems data to Target Systems.
• Interacted with the SME's - Application Owners and Data owners to get the Data Lineage (Source System Details, Server Details, Table, Column names) which would be entered into Collibra.
• Ensured that requirements are developed appropriately by technical teams and user requirements are met.
• Made presentations regarding project direction and recommendations to senior managers. . Serve as subject matter expert (SME) for internal clients performing analyses and creating visual reporting
• Worked directly with business users - CFO team, Regional finance and IT development team throughout the various phases of the project, to support reporting needs
• Performed gap analysis between regulatory expectations 14-M requirements and business financials to ensure accurate translation of Business results into reporting templates
• Undertake data assessment, reconciliation, and system sourcing and remediation efforts for the AXIOM system.
• Conducted moderately complex data analysis and identify sources and relationships of corporate data; make recommendations/decisions regarding analysis.
• Performed System Testing to ensure development is in line with functional specification.
• Planned and managed User Acceptance Testing (UAT) and migration testing up to successful delivery of end product.
• Raised the defects on ALM and ensure the defects are fixed on time.
• Used SQL queries and tools to optimize customizations of database operations
• Strong written and interpersonal communication skills Proven business analysis skills, including business and functional specification development Experience in database skills.
• Involved in conducting Joint Application Development (JAD) sessions for gathering the requirement.
• Understanding and articulating business requirements from user interviews and then convert the requirements into technical specifications
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, using UML
• Identified test execution method: Manual/Automated. Read and Understood Test Cases Worked closely with the UI team to model the screens, which met user defined requirements and also company standards.
• After successful development and testing of the product, participated in product release and deployment to end-user.
• Assisted various teams in the use of ALM (HP Application Lifecycle Management - formerly HPQC) for the management of UAT test cases. Wrote guidelines for formal UAT.
• Supported requirements decomposition into user stories in an Agile Development lifecycle.
• Worked closely with the Product Owner to prioritize the user requirements during and after each sprint.
• Served as a liaison with corporate departments such as planning, decision support/ business analytics, finance, and others to improve regional and service line reports.
• Reviewed test cases with the QA team and ensured that the test cases covered all scenarios of the requirements.

Environment: Axiom, Jira, SharePoint, Microsoft Office, MS Visio, SQL, Quality Center.

Confidential, Tampa, Florida.

Business/Data Analyst

Responsibilities:

• Gather requirements for the listed options risk management system, specifically for index options risk management spreadsheet. Defining requirements for product control and risk management end of day feeds.
• Conducted JAD (Joint Application Development) Sessions and RAD (Rapid Application Development) Sessions with stakeholders.
• Identified internal and external system requirements, design and configuration set-up also created User Documentation and conducted a training class.
• Performed Data Profiling of the current state of data in the Data Warehouse by doing Data Analysis using SQL Queries and Microsoft Excel, finding Gaps in Data and formulating solutions for the same.
• Worked in conjunction with other team members, technical architects and developers to understand system integration and interface requirements.
• A motivating Scrum Master who helps the team to inculcate the Agile culture and help them to follow the Agile best practices to achieve the best quality of deliverables within fixed time
• Collects requirements from department managers and users for enhancements. Acts as liaison between clients and development.
• Conducted internal training sessions for business users on Salesforce technology functionalities, especially with respect to reports and dashboards.
• Experience as Business Intelligence/Systems/ Data/ Business Analyst with expertise in Pharmaceutical processes, Business Process Engineering, Systems/ Solutions Engineering, Strategic Planning, and Systems Analysis.
• Helped to resolve critical control and operational weaknesses, identified problems, recommended improvements and worked in collaboration with middle office, Risk and Finance to implement issue resolutions.
• As a Scrum Master, trying to implement a Collaborative culture in the project, for a successful delivery. Tried to maintain a perfect link between the Product Owner and all project teams, to understand the Customer's requirement and to achieve the goal as per client expectation
• Worked on time-critical efforts to develop improved reporting infrastructure and enhanced communications with support partners.
• Implemented numerous business optimization projects and reporting tools that improved efficiency, reduced expenses, labour costs, and maximized profit by automating outdated manual processes.
• Forecasted company's expense accounts and assist in vendor contract renewals and invoicing.
• Created slide presentations for quarterly business reviews for corporate-level management documenting business status, performance, and pending business initiations.
• Worked with production managers to design and implement tools and controls to achieve performance goals and compiled and presented chart presentations to them on a regular basis comparing performance and quality trends against set goals.
• Implemented Agile Scrum methodology guidelines to build artifacts in different sprints and phases of the application development process.
• Collaborated with stakeholder groups across the organization to ensure business and technology alignment.
• Involved in requirement gathering by conducting formal interviews, surveys and questionnaires sessions with the subject matter experts (SME's) and stakeholders of the projects.
• Aided business with profit predictions by evaluating and analyzing business models and platforms based on current trends in technological development.
• Optimized business performance by designed/ implemented business algorithm to evaluate efficiencies of operations.
• Project execution Methodologies and Frameworks like SAFe, SCRUM, WATERFALL
• Extracted the business requirements from the stakeholders keeping in mind their need for the application and documented them using Rational Req Pro.
• Implemented the entire Rational Unified Process (RUP) Methodology of application development with its various workflows, artifacts, and activities.
• Reported to business and reporting manager as necessary with status. Assisted Management Team with necessary updates on projects.
• Created PowerPoint presentations incorporating MS Office Suite, Excel, Word and Access
• Co-authored a detailed Business Requirements Document and Functional Specification Document.
• Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin and Data Stage, Data Warehousing, Web sphere and Cognos.
• Led the development of a training program to train users on a custom web application and a Cognos ad-hoc reporting environment.
• Conducted user interviews, gathered requirements, and analyzed the requirements using-Rally.
• Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, Data Stage, Data Warehousing, Web Sphere and Cognos
• Designed the Data Warehousing ETL procedures for extracting the data from all source systems to the target system.
• Worked throughout the SDLC, which included requirements, specifications, design, analysis and testing utilizing AGILE methodology.
• Analyzed Siebel interfaces with other systems like Expense systems, Third Party Vendor systems and with other applications and identified interface requirements and gaps and provided solutions.
• Clinical trial management system the system maintains and manages the planning, performing and reporting functions, along with participant contact information.

Environment: Rational Suite (Rose, Requisite Pro), Rational Unified Process (RUP), HIPAA, ETL, Informatics, Rally, Jira, Agile, Windows XP/2000, Oracle, PL/SQL, MySQL, Java/J2EE, MS-Project, MS-Office Suite, MS Visio, MS Word, MS Excel.

Confidential, Chicago, IL.

Business Analyst

Responsibilities:

• Working with the Claims Operations (Medical and Pharmacy) teams to understand the claim adjudication process and gathering requirements from them
• Conducting meetings with the Business - VP Sales & Ancillary Sales Team to understand requirements from a business perspective
• Being the liaison between the Business and IT teams of the project and communicating requirement updates
• Responsible for preparing RSDs (Requirement Specification Document), comprising of functional and non- functional Business and Technical requirements
• Documenting requirements on the requirement management tool - Blueprint, base lining requirements, acquiring sign-offs and maintaining RTM
• Coordinating with the project IT team (PA, SA, QA & ETL developers) and conducting requirement walkthroughs to validate IT requirements
• Responsible for documenting end-to-end project process flows on Visio
• Working with the QA Team and providing test scenarios for Integration and UAT testing
• Creating Data Mapping documents for corresponding Data Extracts
• Working with the Project Manager in creating Change Requests during scope creeps in the project
• Project 2 - Project Manager/Sr. Business Analyst
• Identifying the project team & resources after the prioritization of the PIF (Project Intake Form)
• Making sure all the necessary documentation is in place (BAA, HIPAA contracts, etc.) prior to project kick-off
• Obtaining necessary permissions from the IRO (Internal Risk Officer), making sure PHI (Protected Health Information) is not passed on
• Setting up the SFTP site with the vendor to facilitate secure file transfer
• Coordinating with the Business and IT teams and preparing project plan and resource allocation, total cost ownership, ROI documents
• Creating a SharePoint site for the project and updating the site with weekly status updates of the project and uploading all project related documents
• Conducting weekly project core team meetings, updating meeting agendas and notes on the project SharePoint site
• Scheduling weekly technical calls/meetings with the Vendor's IT/project team
• Conducting requirement gathering sessions with the project stakeholders and documenting requirements on Blueprint
• Acting as a liaison between the core project team and the Vendor
• Preparing RSDs (BRD/FRD/FSD) and obtaining sign-offs from the Business Owner
• Preparing the RAID (Risks, Actions, Issues, Decisions) documents
• Project 3 - Sr. IT Business Analyst/Vendor Coordinator
• Meeting with the Business and IT teams to discuss data changes and impacts across various projects
• Conducting Impact Analysis and reviewing the changes with the ECSO(Enterprise Core Systems Organization) team
• Validating changes with the ETL team and meeting with the SEAL team(Lead PA, Lead SA, Lead QA, Lead BA) to work on the PIF(Project Intake Form) once the project is prioritized and approved
• Identifying projects that would be impacted as a part of government mandated changes
• Gathering Vendor information for Commercial and Self-funded business processes and reaching out to them
• Providing information to the vendors about changes that might impact their data extracts
• Coordinating with the vendors and organizing meetings with their project teams and the IH project team
• Gathering vendor requirements, conducting IT and Business requirement reviews and obtaining vendor sign-offs
• Documenting changes in requirements for IH and obtaining business sign-offs from various responsible departments
• Updating existing BRDs/FRDs and data mapping documents, creating User stories

Environment: Waterfall, Agile/Scrum, Blueprint, MS Project, SharePoint, Data Mapping, MS Visio, MS Word, MS Excel, ETL, MS Access, PL/SQL

Confidential - Atlanta, GA

Business Analyst

Responsibilities:

• Involved in inception Phase and prepared vision statement and initial data models that contain Business Requirement Documents and supporting documents that contain the essential business elements and detailed definitions
• Worked with clients to better understand their needs and present solutions using structured SDLC approach
• Gathered user and business requirements through open-ended discussions, brainstorming sessions and role-playing
• Documented the user requirements, analyzed and prioritized them and converted them as system requirements that must be included while developing the software
• Worked with various vendor groups to gauge the effectiveness of their solution
• Analyzed data and created class diagrams and ER diagrams for designing databases
• Suggested web security using encryption and authentication technologies for reporting and complaint filing procedures
• Created wireframes and storyboards
• Planned and defined Use Cases created Use Case diagrams, Scenarios and Use Case Narratives using the UML methodologies
• Created Mock-up forms in MS word for better visualization and understanding of the software solution
• Tracked change requests and monitored workload and schedule
• Facilitated JAD sessions with management, development team, users and other stakeholders to refine functional requirements
• Used MS Visio for Process modeling, Process mapping and Business Process flow diagrams
• Expertise in development of High level design, Conceptual design, Logical and Physical design for Database, Data warehousing and many Distributed IT systems
• Created and managed project templates, use case templates, requirement types and tractability matrix in Requisite Pro.
• Managed workload, schedules and coordinated status review meetings with project managers, business managers and team members.
• Authored progress and completion reports which were then submitted to project management on a weekly basis in MS project.
• Upgraded e-commerce web site engine by managing resources and responsible for installing new software version to increase site uptime by 3%.
• Identified various frequently used modules within the application as well as the peak user volume for load testing purposes.
• Analyzed the test results from QA teams using Performance Studio Analysis to create various scenarios.
• Developed strategies with Quality Assurance group to implement Test Cases in Test manager for User Acceptance Testing.
• Collaborated with Quality Assurance Analyst in Automated and Manual Black box testing.
• Helped in creating end user manuals and procedure manuals

Environment: Java, J2EE technology, .NET, ASP.NET, SQL Server, Windows 2000 Advanced Server, UNIX / Oracle Platform, MS Visio, MS Dynamics, RUP, Rational Rose 2002, Rational Clear Quest, Rational ClearCase, Rational requisite pro, rational test manager, Rational Robot

Confidential

Data Analyst

Responsibilities:

• Created new reports based on requirements.
• Responsible for Generating Weekly ad-hoc Reports
• Planned, coordinated, and monitored project levels of performance and activities to ensure project completion in time.
• Automated and scheduled recurring reporting processes using UNIX shell scripting and Teradata utilities such as MLOAD, BTEQ, and Fast Load
• Experience with Perl.
• Worked in a Scrum Agile process & Writing Stories with two-week iterations delivering a product for each iteration
• Worked on transferring the data files to the vendor through sftp&Ftp process
• Involved in defining and Constructing the customer to customer relationships based on Association with an account & customer
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Experience in performing Tableau administering by using tableau admin commands.
• Worked with architects and, assisting in the development of current and target state enterprise-level data architectures
• Worked with project team representatives to ensure that logical and physical data models were developed in line with corporate standards and guidelines.
• Involved in defining the source to target data mappings, business rules, and data definitions.
• Responsible for defining the key identifiers for each mapping/interface.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
• Migrated three critical reporting systems to Business Objects and Web Intelligence on a Teradata platform
• Created Excel charts and pivot tables for the Adhoc data pull.

Environment: MS Office Suite, MS Visio, MS SharePoint, Test Management Tool, MS Project, Crystal report, HTML.

Confidential

Data Analyst

Responsibilities:

• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Created new reports based on requirements.
• Worked with Internal modeling team for data analysis and profiling.
• Designed and implemented basic SQL queries for testing and report/ data validation.
• Created SRD (System Requirements Doc) to facilitate the ETL team to develop their SDS (System Design Specification doc).
• Help to Design reporting solutions to meet business requirements.
• Involved in developing complex reports for various new projects and converted excel reports in to Business objects for ease of use and maintenance.
• Experience in using SSRS in creating and managing reports for an organization.
• Involved in performance testing of all the reports, which helped in analyzing its performance before moving into production.
• Facilitated UAT (User Acceptance Testing) for all the converted internal systems with business users, management group and team members.
• Experience in using SSIS in solving complex business problems.
• Used SSIS, SSRS for solving business problems and creating reports in organization.
• Involved in interacting with the end-user (client) to gather business requirements.
• Participated in analyzing and modeling the requirements for the logical and physical design of the database using star schema and normalization techniques.
• Developed complex mappings to load data from Source System (Oracle) and flat files.
• Created dashboards by extracting data from different sources using parameters, sets, groups and calculations. Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard. Involved in creating calculated fields, mapping and hierarchies.
• Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Responsible for translating business needs and rules into business requirements.
• Created database requirements through requirement elicitation for business needs, documentation and management.
• Read and reviewed design document of requirements for project needs.
• Assisted in writing test cases and test approached for requirements.
• Coordinated and lead walk through sessions.
• Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables/columns as part of data analysis responsibilities.
• Monitored the Data quality of the daily processes and ensure integrity of data was maintained to ensure effective functioning of the department.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel.
• Created views for reporting purpose which involves complex SQL queries with sub- queries, inline views, multi table joins, with clause and outer joins as per the functional needs in the Business Requirements Document (BRD).

Environment: Data Analysis, Oracle 9i,SQL,PLSQL,Ms Visio, Linux, UNIX, Windows XP,MS Project, MS Access, Pivot Tables, MS Excel, MS Word, SSRS, SSIS.