SUMMARY:

• Highly motivated and well diversified progressive Involvement professional with 6+ years of Incredible experienced as a Business Analyst by handling with all phases of the project Life Cycle, by holding various domain experiences, highly collaborative team player with extensive customer relation skills, also possess excellent facilitation and mentoring skills and ability to handle multi projects per priority tasks. Strong Interpersonal Communication skills and actively looking for New opportunity.
• Experienced in Various Project life cycle process adaptive Agile/Scrum, RUP (Rational Unified Process) on the other hand experienced in Iterative, Change driven Projects.
• All phases of project the Software Development Life Cycle, experienced in requirement, analysis, design, data modeling, business process modeling, implementation and deployment.
• Worked closely with Internal and external project stakeholder for project selection and Re - engineering the Existing Project Process, by employing various approaches’ Benefit Measurements and constrained optimization method’s.
• Experienced and interacted various requirement by Categorized Business, Functional, Stakeholder, Solutions, Transition, Project, Quality and Technical by employing various technique’s, (Facilitated Work shop’s, Mind Maps, Affinity diagrams (database Schema and system design), JAD, Focus Groups, Questionnaire’s and surveys, Observation, Prototypes, Benchmarking, Context Diagrams, Group decision and Delphi Technique’s.
• Expert in Tracking and Managing the Requirements using Requirement Traceability Matrix (RTM) that controls numerous artifacts produced by the teams across the deliverables for a project.
• Highly proficient in writing User stories, creating Use Cases, Use case diagrams, Workflow Diagrams, Sequence Diagrams, and Class Diagrams etc. Extensively used Rational Rose and MS Visio for UML.
• Expert in working with product backlog , and coordinated team Epic break down, (poker game).
• Proficient in using Agile Scrum methodologies, performed roles of Scrum Master follow up sprint/standup sessions and used various tools and technique’s extensively to write User stories, analyzed the Iteration Burn Down charts and reviewed defects.
• Strong hands-on knowledge of various ERP business applications, business processes, and system processes
• Extensive experience in creating Screen Mockups and Wireframes, conducting GAP Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis.
• Expert in Creating in ad-hoc, reporting and maintain process.
• Extensive experienced in Data Normalization, De Normalization & Data modeling, techniques in RDBMS.
• Created and performed various Operations by using standard SQL Commands (DDL, DML, DCL, and DQL).
• Experienced and handled various complexes joins by writing, (SQL, T/SQL, Oracle/SQL command’s)
• Created Indexes, Views, Triggers, Functions, and appropriate Stored Procedures to facilitate efficient data manipulation and Data Usage during ETL process.
• Expertise knowledge in Creating Complex Stored Procedures, DTS packages, triggers, tables, views and other SQL joins and statements for applications using SQL Server 2008/2012.
• Strong Knowledge on Data Ware housing and Business Architecture, Data services, Data ETL using SQL query tools.
• Extensive experience in the development, implementation and integration strategies within a team oriented environment, utilizing quantitative and qualitative analytical skills.
• Strong Knowledge to understand technical component’s XML and JASON Data Components.
• Experience in developing GUI, working together with developers and end-users to perfect the end-user’s requirements.
• Expert in Conducting User Acceptance Testing (UAT) and verifying performance, reliability and fault tolerance issues.
• Strong Experience in conducting Manual Testing, User Acceptance Testing (UAT) and documentation of Test Cases and Involved in training of end users and Documenting Training Manuals.
• Strong Exposure and working Knowledge in NASCO, NPS system (benefit Enrollment &Claims).
• Strong experience with TSO/ISPF , JCL , COBOL, CICS, DB2 and Web Service technologies and protocols (SAML etc..)
• Excellent Working knowledge on HIPAA (Health Insurance Portability and Accountability Act ) transaction codes such as 270/271 (inquire/response health care benefits), 276/277 (claim status), 470 (benefit codes), 835 (payment or remittance advice), 837 (health care claim) and 834 (benefit enrollment).
• Knowledge of project management principles, practices, techniques and tools (Waterfall & Agile) according to PMI-PMP/PMI-ACP standard’s.
• Ability to Interact with all level of management in written and verbal form and in a team environment.

TECHNICAL SKILLS:

• Micro soft Suite Excel
• Power point
• MS Access
• MS Project
• Share Point
• Rational Requisite Pro
• JIRA
• Kanban board Rational Clear Quest balsamic ALM
• Rational Team
• Rational Rose
• MS Visio professional 2016
• PL/SQL
• .NET and HTML
• SQL Server Reporting Services
• Pivot Tabular
• SharePoint
• MS SQL Server/Oracle (2008R2
• 2012
• 2014)
• NASCO
• Oxygen XML and JASON
• Rational Unified Process (RUP)
• IBM Web Sphere
• WebLogic MS Office
• Azure Cloud Software PowerPoint presentation
• SSIS
• SSRS
• Crystal Reports
• Studio (BIDS)
• Pivotal cloud Foundry
• Agile rally tracking soft.

PROFESSIONAL EXPERIENCE:

Confidential, Dearborn, MI

Sr. Business Analyst

Responsibilities:

• Worked extensively through Agile development methodology by dividing the application into iterations.
• Successfully Implemented Agile/Scrum Method for gathering requirements and facilitated user stories workshop. Documented User Stories and facilitated Story Point discussions to analyze the level of effort on project specifications.
• Involved and Coordinated Sprint meeting, sprint review and Sprint Retrospective meeting.
• Conducted and coordinated various team building activities, Poker game (EPIC break down) and Story points.
• Developed flow diagrams for Business process of the company, UI Wireframes and Mockups using Microsoft Visio.
• Worked closely with project stakeholders, for new applications along with re-engineering the existing application.
• Conducted and Facilitated Joint Application Development (JAD) to gather, synthesize and prioritize requirements using interviews, focus groups, and building Prototype, document analysis, requirements workshop, site visits, and surveys.
• Collected Requirements from product owner, other stakeholders and Worked Closely with Project architecture created Prominent level project BIM Business Integrations Model.
• Fully understood of Rational Unified Process (RUP) using Rational Rose Modeler, Rational Requisite Pro, Unified Modeling Language (UML) in the context of Agile Methodology - SCRUM.
• Conducted Business Case Research and Performed GAP analysis, SWOT analysis, Risk analysis and Cost/Benefit analysis.
• Created and analyzed various Project Management Documents Scope, Requirement documentation, Cost and Quality.
• Involved product owner decision meetings project manager and product manager, Technical lead .
• Tracked and coordinated Spirent with the help of JIRA and Created and helped Scrum Master in the process of Burndown chart and Burn up chart in order in too finish the sprint work.
• Identified Various Data Components throw XML/Jason and CSV Data files
• Experienced in developing GUI, working together with developers and end-users to perfect the end-user’s requirements.
• Hands on experience in design and developed test plans and test scripts.
• Identified the database memory per the project req. resolved with memory setup in too the cloud working space .
• QA through designing and executing test plans on the web porta
• Involved in Project environment setup process PCF Pivotal cloudify foundry.

Environment: Windows, Microsoft Suite 2016(Excel, Power Point, Word, MS accesses) MS Visio 2016 professional, Rational Clear Quest, Rational Test Manager, MS project Management, JIIRA, AZURE cloud and Pivotal could foundry PCF, MS SQL and. Net, Share point, and Data ware house SSRS tools. Share point, CSV, Oxygen XML and Automation testing tool Cucumber.

Confidential, Columbia, MD

Sr; Business Analyst

Responsibilities:

• Involved in Full Project life cycle and worked under the agile methodology used scrum.
• Provided Support to project manager during planning phase and exacting phase.
• Responsible for analyzed Health care data flow and business requirements to create elevated level design document.
• Involved in Technical decisions for Business requirement, Interaction with Client team, Development team, Capacity planning and Up gradation of System Configuration.
• Co-Ordination and Communication Between Off shore and Onsite team’s.
• Manage the online Master Data Management request tool for new requests ensuring proper decision-making on master data creation, data standardization, duplication checks, data field accuracy and completeness while meeting acceptable turnaround time. Complete large database clean-up projects to insure data integrity .
• Worked under Mini Released based Project every 3 month and 6 months based .
• Involved in writing efficient and effective Test Plans, Test Strategy, System testing, End-to-End Testing and UAT.
• Participating in the planning, development, coordination and presentation of specific testing needs as appropriate to the quality assurance needs of the end user.
• Worked Under Special Circumspectness, and Co-ordination between various development team, per dead line.
• Assisting business users in defining UAT test cases and plans; Established and maintained test cases and test data in Quality Center.
• Coordinated with the QA Team for testing activities across multiple systems and managed Conversion test execution.
• Helps in conducting Gap Analysis (GAP), User Acceptance Testing (UAT), System Integration testing and SWOT.
• Uploaded Benefits data into NASCO Claims System
• Worked with TSO/ISPF, JCL, COBOL, DB2 and ENDEVOR
• Used MS Visio for creating use cases, workflows and sequence diagrams according to UML methodology.
• Developed Test Grid using Microsoft Excel and executed test plans.
• Involved in implementation of HIPAA EDI Transactions (835,837 and Facilitated Electronic Data Interchange.
• Performed GAP Analysis for HIPAA 4010 and 5010 transactions, and Used EDI tools to verify mapping to X12 format.
• Recommend changes for system design, methods, procedures, policies and workflows affecting Medicare/Medicaid claims processing in compliance with government compliant processes like HIPAA/ EDI accredited standards ANSI.
• Analyze HIPAA EDI transactions in X12 responses and of 837, 835, 277CA and 999 and looked-for defects.
• Do data analysis for various version changes of EDI messages on different sub-systems.
• Wrote SQL Queries in MS Access to sort data and analyze the large set of data during project life cycle.
• In depth knowledge of Medicare/Medicaid Claims processes from Admin/Provider/Payer side which were later part of the training program to vendors.
• Providing the required test data for the developers to fix the defects and QA team meeting and bug tracking.
• Identified bugs during the test phase and reported them using HP Quality Center and Maintained Traceability Matrix throughout the project. Used the Rational Unified Process (RUP) to build the distinct phases of Software Development Life Cycle (SDLC).

Environment: User Acceptance Testing (UAT), HIPPA rag body, SQL 2012, Rational Clear Quest, IBM Mainframe, Cobol, TOAD. MS Access, Windows, Rational Test Manager, MS Office’s 2008/2012, SQL and JAVA 64-bit, Net and Data ware house, Agile rally SSIS and SSRS tools. MS word EXCEL, CSV files other various Data Source’s

Confidential, Baltimore, MD.

Business Analyst

Responsibilities:

• Experienced with Agile Project Tools and worked with Six Sigma methodology.
• Implemented the SDLC for the developing life cycle and followed the standards process in the application.
• Involved in Project WBC and Cost management Work break down Structure, actual cost, Cost variance
• Assisted the project managers with the development of project schedules using MS Project 2010.
• Acted as a liaison for projects with other corporate departments, including Executive, Legal and Information Services as well as vendor relationships
• Worked on Data Analysis to build Strategy Web application for Health care database integration.
• Elicited requirements for development of the users’ GUI, interfacing with various systems.
• Prepared Business Process Models that depicted modeling of all the activities of the business from the conceptual and procedural level.
• Analyzed the existing reports of the reporting system in the database. Checked the consistency of the data after ETL process using SQL queries.
• Documented project artifacts such as Stakeholders Analysis, Business Requirement Document (BRD), Functional Requirement Document (FRD), Test cases and Test Plans.
• Reviewed and analyzed data mapping using Informatic Power center 8.6.
• Maintained and updated version control of the documentation using Rational Clear Case.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams and Business Process using MS Visio or Rational Rose Modeler.
• Conducted user interviews, JAD sessions, brain storming and surveys. Gathered and analyzed the requirements using Rational Requisite pro.
• Extensively worked in Data Requirement Analysis and Data Mapping for ETL process, and prepared various Reports by Using Visual Studio SSRS 2012 .
• Developed the test plan, test conditions and test cases to be used in UAT testing based on business requirements, technical specifications and/or product knowledge.

Environment: MS Visio 2010, Rational Requisite 7.0.x, Rational Rose Modeler, Share Point, Rational Clear Case, MS Project 2010, MS Office suite 2010, Oracle, SQL server2008/2012lth Cilility: ed On call support and Stake Holde, SSRS reports SQL queries, MS word, EXCEL Power pivot chart reporting.

Confidential, San Antonio, TX

Business System Analyst

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Worked with project stake holders and Developers in identifying requirements, designing and implementing Database Schema.
• Developed Physical data models and created SQL/DML scripts database schema and database objects.
• Conducted user interviews at both in-house and client locations, gathering and analyzing requirements deliver the BRD.
• Prepared screenshot GUI using Photoshop and Visio.
• Participated in functional design sessions, creates and executes SQL test scripts, and aids in the solution of data issues.
• Worked with SMEs and Developers to develop and design the GUI of the system.
• Designed and developed Use Cases, Activity Diagrams, and Sequence Diagrams using UML methodology.
• Identified, researched, investigated, analyzed, defined and documented business processes and Use Case Scenarios.
• Coordinated in database changes needed for the front-end development team, explained and guided them on the database architecture and objects for effectively accessing the database.
• Documented Application Support Guide (ASG) and User Manuals.
• Assisted with user testing of systems User Acceptance Testing (UAT), developing and maintaining quality procedures, and ensuring that appropriate documentation is in place
• Worked with development and testing teams to accomplish timely release objectives.
• Acted as a resource in understanding how IS carry out business functions and assists in ensuring the timely and implementation
• Developed timelines for project delivery, and managed projects and resources to successful completion.

Environment: Micro soft Suite, Rational Suite, Photoshop, MS Project 2007, MS Visio 2007, MS Office suite 2007, SQL, DB2.

Confidential, Fairfax, VA

Business Analyst

Responsibilities:

• Involved in Technical decisions for Business requirement, Interaction with Stake holder, Client team, Development team, Capacity planning and Up gradation of System Configuration.
• Coordinated the decommissioning of a vendor application which resulted in cost savings of nearly 1 Million US Dollars for the bank.
• Coordinated the external data vendor (SNL ) integration with the bank's Analysis tool which assisted Analysts from Europe to risk rate the European banks without having to input the financials manually. Coordinated the decommissioning and migration of various Debt Rating Models and Scorecards from a legacy system to the bank's analytical tool and Assisted the production support team in fixing user issues
• Analyses, create and maintain enterprise master data supporting quote to cash process. Communicate with internal & external customers to address issues and provide support on data quality and integrity improvements
• Assisted the Quality Assurance team in testing the functionalities before a release.
• Conduct frequent meetings with the business teams for better understanding of the requirements Document the current default definitions by analyzing all the definitions of default used within the Basel systems area, the rules governing the process and the sources of the data utilized to a granular level.
• Documented the current definitions of non-performing loans by analyzing all the NPL definitions used by the credit divisions within PBB, whether the process is automated or performed manually.
• Established what changes are to be made and the impact on any source systems and associated costs.
• Understood the various feeds coming to the Basel 2 Data Mart and the impact on the new solution Prepare the Functional System Specifications (FSS) which includes the as-is and to-be price
• Involved in Implementation and delivery of MSBI platform solutions to develop and deploy ETL, analytical, reporting and scorecard dashboards on SQL Server 2008
• Planned, Configured, Installed, Maintained SQL Server in environment of Multi-Node Cluster.
• Performed Regular Database Maintenance process, checking the disk Defrag procedures in different environments.

Environment: MS Visio 2000, MS Office, SQL Servers 2008 studio, Data ware house Concepts ETL, and SSRS reporting’s, And Java Scripts MS Access, MS Project 2000, Window OS, Linux OS