Sri

Ph: 470-***-****

aczqwl@r.postjobfree.com

PROFESSIONAL SUMMARY:

Eight years of experience as business and data analyst in Health, Education, and Banking domains.

Experience as Business Intelligence/Systems/Data/Business Analyst with expertise in Insurance, Healthcare processes, Business Process Engineering, Systems/ Solutions Engineering, Strategic Planning, and Systems Analysis.

Experience with healthcare system, Medicaid and with prime focus on claims adjudication, provider, eligibility, and prior authorization.

Knowledge in the Informatica / ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).

Excellent understanding of the Software Development Life Cycle (SDLC) with involvement in requirements gathering, analysis, functional design, and testing phases.

Excellent skills in translating user requirements into functional specifications, business process modeling and use case development.

Designed and developed number of reusable IVR application modules that lead to accelerated delivery

Developed Disaster Recovery plan/Documentation.

Excellent skills in analysis, design, development, and implementation of ETL and reporting components like Informatica, Teradata and SSIS.

Well versed with various protocols related to web-services and SOA (Service Oriented Architecture) like SOAP, REST and the Internet Protocol Suite like HTTP, TCP, FTP, etc.

Experience in writing Business Requirements Document (BRD), Functional Requirements Document (FRD), Request for Proposals (RFP), Statement of Work (SOW).

Results-oriented Joint Application Development (JAD) Facilitator and meetings coordinator with excellent interpersonal skills.

Customized order entry screens/programs using RPG IV, RLU, SDA and SQL to interface with company's packaged ERP software

Coordinating multiple teams for the SAFe for Agile practice

Extensive experience in all phases of RUP and SDLC processes

Analytical, methodical, and resourceful approach to problem solving, identifying, and documenting root causes and corrective actions.

In-depth experience in data analysis with a strong statistical background with hands on experience in SAS and SPSS.

Process changes in Agile PLM database and clean-up projects.

Expertise in assisting the Testing Team in creating the Test Plans, Test Cases and Test Scripts and efficiently prioritize and manage the defects using the Defect Tracking system.

Excellent meetings facilitator with excellent inter-personal and conflict resolving skills.

Excellent leadership skills motivating the team to perform the desired result, analytical and problem solving and on optimizing the costs, besides adherence to the timelines, which is a win-win proposition.

TECHNICAL SKILLS:

Operating Systems

Windows, Linux

Office Applications

MS Word, MS Excel, MS PowerPoint, MS Visio and MS Outlook.

BI Reporting Tools

Tableau, SSIS, SSRS

Webpage Applications

HTML, XML, Dreamweaver, Flash, Photoshop, Ajax, JavaScript, CSS, Angular, Java Script, JQuery, SOAP, Restful, XML, C, C++,RPG.

Statistical Packages

Minitab, SPSS, SAS, R, XL Miner

ETL Tools

Informatica, Teradata

WORK EXPERIENCE:

Project 1:

Business Analyst

Cabinet for Family and Health Services, Frankfort, KY Sep 2015 to Till Date

Responsibilities:

Played key role in System Development Life Cycle Process consisting of: Design and Gap Analysis, Business Requirements, Systems Requirements, Test Criteria, and Implementation to have the outputs of project dealt with the automation of correspondence directed to Insurance policy owners.

Extensively used Informatica client tools. The objective is to extract data stored in Oracle database, flat files to load finally into a single data warehouse repository, which is in Oracle.

Led the development of a training program to train users on a custom web application and a Congo’s ad-hoc reporting environment.

Used knowledge of Health Care Information Systems EMR model to develop proposed workflow in MS Visio.

Owned the entire reporting process. Interacted with the ETL team, developer(s), management, and account holders to get the requirements, document them, design templates, and write specifications.

Responsible for integrating with Facets. Designing test scripts for testing of Claims in Development, Integration, and production environment.

Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOAD using UML and Business Process Modeling.

Created, managed and executed test cases, and testing for processing of Medicaid Claims.

Excellent in Developing and evaluating business process Models.

Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.

Extensively involved in data modeling.

Perform Gap Analysis of the processes to identify and validate requirements.

Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.

Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.

Implemented data access, storage and validation routines on the database server using Procedural Language/Structured Query Language (PL/SQL).

Involved in the testing phase right from the Unit testing to the User Acceptance testing.

Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.

Use Cases and other Process Flow Models were designed using Visio and Rational Rose.

Involved in jobs and analyzing scope of application, defining relationship within & between groups of data, Star Schema etc.

Followed the UML based methods using Rational Software Modeler/MS Visio to create: Use Cases, Activity Diagrams / State Chart Diagrams, Sequence Diagrams, and Collaboration Diagrams.

Tuned the batch programs and online transactions to alleviate performance problems.

Developed & executed several Optimized queries in SQL on this data.

Environment: RUP, UAT, GAD (Gap Analysis Document), Microsoft Office 2003 Professional (Outlook, Word, Excel, Visio, Access), Microsoft SharePoint 2003, ERWIN, SQL, PL/SQL.

Project 2:

Business Analyst

AT&T, Atlanta, GA July 2014 to August 2015

Responsibilities:

Interacted with project team to define system objectives and scope, and identify constraints and the measures of success for the system to be developed.

Coordinated JAD sessions to understand the user requirements and their system's implementation.

Worked extensively through agile methodology by dividing the application into iterations and acted as the Scrum Master in the iteration throughout the SDLC.

Developed custom score cards for all bank loan products after analyzing the risks involved.

Worked with data marts specific to loan parameters for analyzing the preliminary information and attribute classification.

Process Deviations in Agile PLM database,

Gathered primary requirements and modeled the processes in Context diagram using MS Visio.

Assessed the flaws in the existing as-is system and made clear recommendations for BPI and incorporated them in the future to-be system design.

Oncall 24 X 7 data refreshes, code and systems for all environments, disaster recovery .

Coordinated team in bringing about Business Requirements, Architectural Specifications, Corporate Priorities, and Functional Specifications Made Screen Mockups/Definitions using Excel.

Developed process flow charts and business requirements for the upgrading of ERP and PLMsystems .

Developed Use Case diagrams, business flow diagrams, Activity/State diagrams and Sequence Diagrams Using MS Visio so that developers and other stakeholders can understand the business process.

Used MS Project and assisted project manager in making Project Plan with necessary modifications.

Monitoring project progress and performance and providing Status Reports to the project sponsor.

Designed and implemented basic SQL queries for QA testing and Report / Data Validation.

Participated in User Acceptance Testing on the Business-to-Business Transaction testing.

Responsible for organizing the Quality Analyst (QA) walk through to explain proposed changes.

Used Test Director Application for automated testing. Coordinated with the test team to check the weekly status and report the same to the project manager and discussed project manager and other team regarding State Flow Process.

Environment: Agile/Scrum, MS Office, MS Visio, MS Project, HTML, SQL, Test Director.

Project 3:

QA Analyst

Baylor HealthCare, Dallas, TX Feb 2013 to June 2014

Responsibilities:

Developed and executed various manual testing scenarios and exceptionally documented the process to perform functional testing of the application.

Extensively worked on Test data preparation for all Medical, Professional, Dental claims including Medicare claims.

Extensively worked on reviewing requirement, functional and design specifications, developing Test strategies, Test plans and Test cases.

Preparation of test cases for Functional, Regression, Integration and System testing.

Proficient knowledge on ICD-10 for diagnosis, coding, and ICD-10 for inpatient procedure transition.

Tested the integration between Facets and Portals.

Tested the Registration process of common practitioner in Facets and validated the fields (Medicare or Medicaid billing number, License and DEA number.

Worked on preparation of test scenarios, test cases and data preparation for ICD-10 transition.

Performed UAT testing with Business users.

Coordinated test execution efforts for each build and support QA team with defect tracking and management, ensuring timely resolution of defects.

System Integration testing for Facets core modules with external systems.

Created Groups, plans and enrolled members in Facets.

Wrote simple and complex SQL queries to validate member data, claims data from Facets member and Claims files.

Involved in claims processing of different scenarios and tested the end to end scenarios from 837.

Interacted with the Business Requirement and Client Advocate teams to understand, test and compare old and new business rules.

Worked with team members, managers, developers and business in coordinating the efforts.

Environment: SQL Server 2005, SQL, TOAD, Oracle 9i/10g, HP Quality Center 8.2, HP, MS Visio, AS400, DB2, DBU, MS Access, MS Windows 2003.

Project 4:

Business Analyst

Kotak Mahindra Bank - Hyderabad, India April 2011 to Jan 2013

Responsibilities:

Prepared and analyzed 'As-Is' and 'To-Be' workflow scenarios, designed new process flows and documented the business process and various business scenarios and activities of the business from the conceptual to procedural level.

Identified gaps and failure points, performed root cause analysis.

Conducted interviews, JAD sessions and gathered requirements and analyzed the requirements represented in Requirement Traceability Matrix (RTM) using MS Excel.

Worked with production staff to identify and map detailed current processes.

Developed Business Requirement Document (BRD) that supported overall strategy, goals and objectives.

Documented and delivered Functional Specification Document (FSD) to the project team.

Involved in gathering and documenting the requirements that were critical to the business process and using those requirements to design application software using a Use Case approach. Authenticated technical designs created by IT developers and ensured if they tallied with the functional specifications.

Experienced in facilitating Testing team of the feeds for completeness and accuracy.

Assisted and coordinated integration and User Acceptance Testing (UAT) prior to the release of new data feeds into production.

Facilitated interviewing and brainstorming sessions with the stakeholders and SMEs in understanding the requirements pertaining to mortgage application process.

Implemented test plans to validate the market risk system output against market reference data feeds.

Provided technical assistance in identifying, evaluating, and developing systems and procedures that were cost effective and met business requirements.

Extracted email addresses and sent emails using SharePoint and document details from within a workflow.

Assisted in developing test scenarios and implemented test plan. Provided key input in working with users in defining project and system requirements. Conducted project related presentations.

Prepared change request form to provide details of the changes requests, and obtained approvals from the appropriate stakeholders.

Environment: Waterfall Methodology, Microsoft Office Suite, MS Visio, Mercury QC, MS SharePoint, JAVA, JSP, J2EE.

Project 5:

Program Review Analyst

SVRIT, Secunderabad, India Jan 2009 to March 2011

Responsibilities:

Responsible for planning research projects, coordinating the data gathering and research activities between various teams.

Responsible for compiling and analyzing high volume test data, presenting the results to the legislative committee.

Performed extensive research and analysis against data quality metrics and performed advanced statistical analysis including multivariate statistics using SPSS and SAS.

Defined and wrote reports and other related documents and present research findings to the legislative committee.

Ensured quality assurance standards and procedures in various research projects.

Contact this candidate