SUMMARY

• A professional Business Analyst wi th 7+ years of IT and Management experience in business understanding change needs, assessing the impact of those changes, capturing, analyzing , documenting requirements and then supporting the communication and delivery of those requirements with relevant parties.
• Expertise in Software Development Life Cycle (SDLC) of Projects - System study, Analysis, Physical and Logical design, Resource Planning, Coding and implementing business applications.
• Experience with Conceptual, Logical and Physical data modeling.
• Conducted Joint Application Development (JAD) , Joint Requirement Planning (JRP) sessions between the business users, Developers, testers & Subject Matter Experts for gathering requirements.
• Experience in domains like banking, insurance, health, Retail Merchandising and buying , business analysis and data analysis .
• Good background in handling EDI transactions 837,835, 834, 270, 271, 276, 277, 278.
• Coordinated with the application team and Quality Analyst in the creation of test plans , User Acceptance Test scripts and Regression test cases (for upgrade).
• Excellent communication skills which helps to communicate effectively with venders regarding implementation of technology to achieve organizational goals.
• Worked with Business Intelligence (BI) Tools like DataStage and Informatica.
• Expertise in various technologies, including business process tools such as MS Excel, MS Visio , Data modeling and Design .
• Worked with the top management team to help develop business process and procedures for different departments, identified the areas of improvement and proposed and monitored solutions.
• Studied business processes and Workflow diagrams and also worked extensively on Gap Analysis.
• Track project schedule at every stage, identify and address project risks, ensure smooth project delivery.
• Performed Feasibility, Risk, and GAP Analysis to identify the business critical and high-risk areas of the application.
• Experience in various Data Management and Reporting technologies, worked on relational databases like MS SQL Server, Oracle DB and IBM DB2 , created logical data models and possess significant expertise on SQL programming.
• Expertise in creating test documentation, establishing project schedules and scope, and risk evaluation.
• Strong understanding of data warehousing concepts, OLTP, OLAP, Normalization, Star and Snow Flake data models .
• Worked with PMO department to ensure that projects stay on track, the staff works efficiently
• Expertise in creating Use case documents, Functional requirement documents (FRD) and Business Requirement document (BRD), Software Specification Document (SRS) across the deliverables of project.
• Hands on experience in writing SQL queries for data extraction and mapping.
• Experience in MS Project for scheduling deadlines, resources and facilities, Rational Clear Quest for Change Management (CM ) and Defect Tracking, Rational ClearCase for configuration & software asset management.
• Created questionnaire and interviews for SME s and business users to gather business requirement.

TECHNICAL SKILLS

Operating systems: Windows NT/XP/2000/Vista/7, Macintosh, Linux

Languages: C, C++, Java, SQL, UML, HTML, C#

Testing tools: Mercury (HP) Load Runner, Test director, Quick Test Pro (QTP), Win Runner, Clear Case

Business Modeling tools: MS Visio, MS Project, Rational Rose

Change management tools: Rational Clear Quest, Rational Rose

Documentation tools: MS Word, MS Excel, MS PowerPoint

Requirement analysis tools: Rational Requisite Pro, Quality center

Project Methodologies: Rational Unified Process (RUP), Agile, Scrum, Waterfall, Spiral

Database: My SQL, MS Access

PROFESSIONAL EXPERIENCE

Confidential, Plymouth, PA

Senior Business Analyst

Responsibilities:

• Gathered Business Requirements. Interacted with the Users, Designers and Developers, Project Manager to get a better understanding of the Business Processes.
• Responsible for the full HIPAA compliance lifecycle from gap analysis, mapping, implementation and testing for Teen Care processing of Medicaid Claims.
• Liaison between the Business needs (business users and sponsor) and the Technical solutions (development and testing staff), ensuring technical solutions satisfied business requirements.
• Performed Web Page Mock-Ups using MS Visio and thus defining the Business Process Model and Data Process Model.
• Experienced in RUP software development cycle methodology with four consecutive phases - Inception, Elaboration, Construction and Transition.
• Developed gap analysis document, logical and physical design and remediation plan for State.
• Responsible for mapping documents, creation of test plan, test scenarios, test cases for unit, system and system integration testing.
• Worked with business owners, content staff, IT and other stakeholders in creating a content management solution for managing the information in the supplier portal using Web Sphere Application Server.
• Used the Rational Unified Process (RUP) to build the different phases of software development life cycle.
• Created Project management plans for managing on time delivery using MS Project along with writing test cases, unit and systems integration test plans in Win Runner and used Load Runner to check if application works fine with loads.

Environment: Modeling, Rational Requisite Pro, Rational Rose, RUP, UML, Load Runner, MS-Project, MS Visio, Java, MS Office, Windows XP

Confidential, New York, NY

Business Intelligence Analyst

Responsibilities:

• Facilitate requirement gathering workshop with report users and report developers and prepared user interface mockups to verify with users.
• Also researching existing reports to extract underlying data and originating data source to determine Data Elements.
• Documenting data ware house requirement such as Data standards and quality rules.
• Data mapping - source to target - including of capturing data acquisitions and transformation rules by analyzing different data tables by writing SQL queries and creating mapping requirements.
• Conducted project related presentations and provided reports to the higher management and worked for Request for Proposal (RFP)
• Conducting workflow, process diagram and GAP analysis to derive requirements for existing system term considerations, the long term considerations and its benefits.
• Conducting process improvements, status meetings, monitored and tracked progress of project following agile methodology.
• Also Creating Use Cases and Test Cases for each of the allocated requirements and forwarding them to the Developers for the design and development of the system.
• Established and enforced enterprise data warehouse architecture standards, including table structures, naming conventions, key definition and generation, optimization etc.
• Worked with the business users to define business requirements, data requirements and analyze the possible technical solutions.
• Conducted user interviews, gathered requirements, analyzed, and documented business requirements based on the analysis of loan processing workflow model.
• Created workflow, process diagram and gap analyses documents to derive requirements for existing systems enhancements.
• Created workflow, process diagram and gap analyses documents to derive requirements for existing systems enhancements.
• Participated in data analysis and data dictionary and metadata management -Collaborating with business analysts, SMEs, ETL developers, data quality analysts and database administrator.
• Profiled large datasets and data files using SQL as primary language to check the quality of the source data.
• Developing technical data mapping documents and related functional specifications.
• Understanding and interpreting how data mapping choices affect business programs / reporting requirements.
• Supporting CR release at the time of deployment, coordinating with different technology teams for production data validation process.
• Designing the business requirement for the project scope, more efficient ETL process and Software Development Life Cycle methodology. Also helping in designing and developing database model.
• Performing data analysis and created and used complex SQL extensively for analysis and business logic validation.
• Assisting in creating a (MDM) Master Data Management Plan as a part of Production Readiness Review, played an active role in Production Support, Troubleshooting and maintenance of the application.

Environment: SCRUM - Agile methodologies, Waterfall, Axure, JIRA, Mantis Bug Tracker DocuMaker, GuideWire, MS Office, Visio 2010 Professional, Visual Studio, Project, MS Sharepoint, MS Outlook, Web-Applications, Windows 7.

Confidential, Daton,OH

Responsibilities:

• Involved in the analysis of the existing credit card processing system, mapping phase according to functionality and data conversion procedure with hands on experience with Double-entry Accounting System.
• Liaison to line of business departments, credit/debit department, and all participating testing applications and enterprise suites to ensure accurate communication and payment procedures.
• Worked closely with the Project Manager for Mortgage Verification Project with loan financing.
• Worked in a cross-functional finance and accounting team that reviewed information from the general ledger and prepared journal entries for posting.
• Installed Commercial Off The Shelve Applications on disturbed servers and was the application SME; using AFS VisionIP/xVision Image Capture
• Designed and developed use cases, activity diagrams, and sequence diagrams
• Conducted user interviews, gather requirements, and analyze the requirements using Rational Rose, Visio and Requisite pro
• Performed extensive GAP analysis, Impact Analysis, Data Analysis, Data Requirement Analysis and Data Mapping
• Assisted with User Acceptance Testing, develop and maintain quality procedures ensuring that appropriate documentation is in place
• Established appropriate security levels for processes, information exchange and system implementation.
• Created and managed reports and documents using Crystal Reports
• Worked with gathering information from the initial Change Requests, initial user stories, meeting notes and converting them into a User Story document; updated and created Process flows
• Worked with the users to finalize the user stories and gather their approval; participated in the grooming meetings to breakdown the work items into testable unit.
• Prototyped the application changes using Just in mind Proto typer providing mock-up screens and wireframes with focus on improving the user experience (UX)
• Provided walk-throughs of User Stories, Mock Ups and User Acceptance Criteria to Dev, QA and Stakeholders during the work item Kick-Off Meetings
• Provided Dev and QA support during the development and testing to define scope and communicate with the users in case of questions or scope creep
• Participated in the Project Retrospective to review the project and discuss learning and improvement areas; utilized detailed knowledge of application features, scope and impact of business needs throughout analysis

Environment: Rational Rose, Requisite Pro, Quality Center, AFS Vision IP Image Capture, JIRA, Microsoft Office (MS Word, MS Excel, MS Access), Crystal Reports, Java, Oracle tools, Windows 7