SUMMARY:

• Over 6 years’ IT experience in the field of Business Requirement Analysis, System Analysis, Software Development & Testing with strong understanding and diversified experience in various industries. Proficient in SDLC methodologies such as Waterfall, and Agile including analysis, design, development and testing of software. Understanding of ITIL (Information Technology Infrastructure Library), SDLC (Software Development Lifecycle), and project management fundamentals.
• Experienced in conducting GAP Analysis between the "AS - IS" and the "TO-BE" system. Performed SWOT Analysis and Cost-Benefit Analysis during project inception phase. Effectively articulated project documentations including functional requirement documents (FRD), AS-IS and TO-BE Process flows, use cases, test scenarios, test cases etc.
• Worked closely with manager to analyze & understand Business requirements; gathered User, Functional (FR) and Non-Functional requirements (NFR) & translated the requirements into User Stories for Scrum process using Rally.
• Generated Business Requirement documents (BRD), Functional Specification design documents (FSD) and Functional Requirement Documents (FRD).
• Led various Scrum meetings with development team to review Functional specification& design the system.
• Developed Process Flow Diagram/Activity Diagrams, Test Cases, Use Cases and performed Functionality testing & Regression testing. Experienced in preparing Use-Case documents and system requirement documents based on client requirements and in-depth System diagrams.
• Expertise in conducting Joint Application Development (JAD) sessions, holding interviews and document analysis for user requirement gathering.
• Outstanding organizational skills in capturing all the Business Flows and presenting them as meaningful artifacts at Inception and Elaboration phase.
• Adept at reducing development costs and providing traceability of projects.
• In-depth knowledge of Rational Unified Process (RUP); risk engineering; data modeling and mapping; and design using UML, Rational Rose, and Visio.
• Supported sales function by designing pre-sales solutions; gathered specifications and requirements, created demos, and developed workflow designs. Lead initiatives to improve processes in business, organizational, and operational areas.
• Facilitated optimal internal communications by serving as liaison between services organization and product development, product management, and technical teams.
• Proactively contributed to several implementation projects; leveraged communications skills to establish and maintain successful client relationships.
• Worked closely with engineering and business teams to scope projects and estimate / maximize utilization of human resources.
• Skilled in team building, conflict resolution & escalation awareness
• Worked with the User Interface (UI) team to gather requirements for the GUI for the application.
• Design and implement basic SQL queries for QA testing and report / data validation.
• Good understanding of Business process flow modelling using UML tools, Use case modelling and Entity Relationship Modelling. Advanced knowledge of reporting tools such as Crystal reports, and Business Objects
• Excellent Interpersonal Skills, Effective Writing & Oral Communication and Presentation skills.

TECHNICAL SKILLS:

Insurance, U.S.: Healthcare, banking

Methodologies: Agile, Agile/Scrum, Waterfall

Requirement management tools: Blueprints, Rational Requisite Pro, DOORS

Business Modeling tools: MS Visio, Enterprise Architecture, Pencil, Rational Rose

Testing Tools: Selenium Web Driver, TESTNG

Bug Tracking Tools: Jira, HP Quality Center/ALM, Rally, Bugzilla, Clear Quest

MS Office: Word, Excel, Outlook, PowerPoint, MS Project

CRM: Salesforce, AWS, Oracle EBS CRM

MS: Share Point

BI/Reporting Tools: Crystal reports, Business Objects

Data Modeling Tools: CA ERWIN Data Modeler

Database: Oracle, MySQL, DB2, SQL

Language: Java, C,C++, SQL, XML, HTML, CSS, JAVA SCRIPT

MS: DOS, Windows 95/98/NT/2000/XP/Vista/WIN7/Win8,MAC

PROFESSIONAL EXPERIENCE:

Confidential, CA

Business Analyst

Responsibilities:

• Track events, tasks, internal dependencies and progress at the lowest level within the plan.
• Defined the process flow of member enrollment from the online web portal to the FACETS system.
• Identify issues that impact the effort, quality or timeliness of project deliverables.
• Communicate status of project to business heads and cross-functional leadership team.
• Ran SCRUM sprints as a part of the business reports development. Maintained backlogs and assured process flow.
• Performing data management projects and fulfilling ad-hoc requests according to user specifications by utilizing data management software programs and tools like Toad, MS Access, Excel and SQL.
• Ensured that existing plans & procedure codes are used.
• Experience in managing Daily Scrum meeting, Scrum of Scrums meeting, Sprint retrospective meeting, Sprint review meeting, Sprint planning meeting.
• Manage the application lifecycle from requirements through readiness for delivery from a single repository in HP ALM.
• Understood and articulated business requirements by having sessions with different teams. Understanding the AS IS' system and conducted GAP and impact analysis.
• Gathered business rules and prepared requirement documentations.
• Performed User stories and maintained sprint burn down chat to display the status of the sprint cycle.
• Interacted with Product Owners, Scrum Master and gathered requirements as per the business needs.
• Communicated with Business Partners on status of issues, action plans, and timeframe for resolution throughout development cycle.
• Handled requirement tractability matrix doc to maintain change control and version control.
• Worked on Agile Scrum methodology of SDLC and involved in release, eliciting user stories and supported the design, development and testing team on daily basis.
• Used SQL to analyze the data and check the validation and internal data from end to end systems.

Environment: MS Visio, Microsoft Word, Excel, Share-point, HP ALM.

Confidential, RI

Business Analyst

Responsibilities:

• Gathered analyzed, documented business and technical requirements from both formal and informal sessions and validate the needs of the business stakeholders.
• Performed Data mapping on the extracted data, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
• Designed and developed Use Cases and Use Case scenarios, Activity Diagrams, High Level and Low-Level Process Flow Diagrams.
• Conducted surveys, interviews and JAD sessions and translated them into system Requirements.
• Responsible for preparing a Business Requirement Document (BRD), Functional Requirement Document (FRD) and then translating it to functional specifications and test plans.
• Performed Gap Analysis in every phase and stages to check the compatibility of the existing system infrastructure with the new business requirements.
• Interacted with DBA for the process of data extraction, data transformation, data load, data integration and conversion processes using business intelligence tools on the Benefit Plan functionality.
• Worked with PM to prepare Project charter, Project plans, daily, weekly and monthly team deliverables for each phase, drafting WBS and RBS systematically using MS Project.
• Served as a Peer review member to verify, validate and modify necessary changes made considering technical and business aspects, in the deliverable documents and thereby uploading it on SharePoint. Consolidated individual Statistical Summary from the team deliverables, various reports, jobs, files and Inventory documents to present it in weekly status meetings.

Confidential, IL

Business Analyst

Responsibilities:

• Gathering, blueprinting and analyzing requirements using Requisite Pro and Requisite Web
• Extensively used Agile Methodology in the process of the project management based on SDLC.
• Mapped high-level to-be designs using Business Process Modelling Notation (BPMN) on MS Visio.
• Extensively involved in data modelling
• Data mapping, logical data modelling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Gathered and documented Business Requirements created Functional specifications and translated them into Software Requirement Specifications.
• Conducted analysis of HIPAA compliance and took part in discussions for designing the healthcare transactions to be HIPAA 5010 compliant.
• Involved in understanding of Business Processes, grain identification, identification of dimensions and measures for OLAP applications.
• Designed and developed Use Cases using UML and Business Process Modelling.
• Conducted analysis, assessments and cost/benefit analysis using facets
• Responsible for configuring Facets system.
• Consulted with healthcare insurance company to develop conversion specifications for other insurance Coordination of Benefits (including Medicare).
• Used gap analysis framework to identify AS-IS processes of claims transactions of HIPAA X 12 4010/4010 A standard and TO-BE processes (ICD-10-CM and ICD-10-PCS compliance requirements) of 5010 standard
• Involved in creating sample mappings for the conversion of EDI X12 transactions code sets version and translation of ICD 9 codes into ICD 10 codes.
• Developed data conversion programs for membership, claims, and benefit accumulator data - converted thirteen corporate acquisitions. Developed data field mappings. Provided programming and support for claims processing functions and auto-adjudication.
• Validated the following: 837 (Health Care Claims or Encounters), 835 (Health Care Claims payment/ Remittance), 270/271 (Eligibility request/Response), 834 (Enrolment/Dis-enrolment to a health plan)
• Documented Requirements for Management Reporting out of Clear Quest using Crystal Reports.

Environment: MS Excel, MS Word, MS PowerPoint, Six Sigma, Lean, .NET, C#, Visual Studio 2010 & Oracle 10g

Confidential, Schaumburg, IL

Business Analyst/System Analyst

Responsibilities:

• Worked on different RDBMS modern database like SQL Server, Oracle and MS Access. nvolved in a migration project of moving data from SQL Server 2008 to SQL Server 2012.
• Designed and developed BI initiatives on several large modernization and integration projects intended to position ur organization as a SaaS provider.
• Developed custom SQL queries and performed testing and data analysis in an Oracle DB environment.
• SPOC for writing the migration requirements document.
• Directed team of seven data ware house developers in daily operations of data ware house. Tasks such as collaborating with system designers, providing support to end users, analyzing data, designing databases, and modeling and migrating data.
• Experience in data migration Masterworks via FTP to Amazon cloud (AWS).
• Experience in working on data migration and integration for legacy applications and designing Integration and migration chart.
• Created KPI Dashboard to show the progress of the project to management.
• SPOC for drafting validation rules and business rules for legacy applications.
• Streaming the process for creating data dictionaries for ETL developers.
• Support the execution of business process reengineering & business process improvement.
• Facilitate the change management due to strategic business process improvement.
• Using MS project designed and introduced new schedule delays and summary reports.
• Created, monitored and analyzed project schedules in accordance with project Best Practices. Communicated and promoted the use of Project Schedules and reports to project managers.
• Improved time to delivery on complex projects by writing a class generator for VBA to serialize Excel ranges to VBA bjects and deserialize objects to Excel ranges.
• Executed test cases and test scripts for manual and automation testing. Defects are raised in the HP Quality
• Center/HP ALM for logging, tracking and reporting bugs in the application.
• Dealing with various database objects to write SQL queries on multiple databases like MS SQL Server, MS Access and Oracle databases.
• Created user stories to understand the functionality of the business process.
• Using HP ALM, create project planning, tracking and reported bugs.
• Created conceptual and physical diagrams for data modeling in Erwin and ER studio.
• Created business process workflow diagrams using Business Process Modeling Notation (BPMN).
• Hands on experience with Erwin to do reverse engineering with multiple database sources.
• Hands on experience with Team Foundation Server to track system requests, request statuses, test plans, and test results.
• Wrote multiple DML statements using Joins, Average functions, Aggregate functions and scalar functions.
• Created simple reports, Adhoc reports, cached report and burst reporting using SSRS.
• Experience with Scrum framework as part of software deliverables.

Environment: UML, Agile (SCRUM), Labware LIMS, LabManager LIMS, Use Case Analysis, MS Project, Ms Word, MS Power Point, MS Excel, MS SQL server, MS Outlook, MS Visio, MS Project, Quality Center, Informatica Power Center, and IDQ

Confidential . Hazelwood, MO

Business Analyst

Responsibilities:

• Used Visio model process and created use case diagrams, activity diagrams, data flow diagrams, sequence diagrams and collaboration diagrams, generated reports for executive management using crystal reports so that they can make a sound decision based on the reports
• Played a substantial role in the process identification and definition and functional requirements gathering, in an effort to develop a practical technology solution for automating the system.
• Designed new process modeling and documented the business process and various business scenarios and activities.
• Played an important role in Microsoft business intelligence (MSBI) in the process of design, retrieve, analyze and report data the tools generally read all the data that have been previously stored, often, though not necessarily, in a data mart.
• Participated in user acceptance testing (UAT) and created a user manual for easy transition of business users from every day manual processing to the newly established automated system.
• Meet and discuss requested changes with business client ensuring a thorough understanding of specifications.
• Reviewed with technical team to ensure understanding of project requirements.
• Created Feature Requirement Specifications including use cases, flow/business process diagrams, and UI mockups.
• Documented both functional and non-functional requirements identifying product impact, assessing complexity and prioritizing.
• Lead scope clarification for R&D providing guidance beyond the requirements phase and throughout the development process.
• Reviewed other Software Product Lifecycle documents including Design Documents and Test Use Cases.
• Supported User Testing in the context of requirements validation
• Experience with Web integration and web scripting languages like ASP.NET
• Participated in design discussions and assure functional specifications are delivered.

Environment: MS Excel, MS Word, MS PowerPoint, Six Sigma, Lean, .NET, C#, Visual Studio 2010 & Oracle 10g

Confidential

Business Analyst

Responsibilities:

• Responsible for capturing and managing business requirements for the release along with business process and developing the functional requirements specifications document.
• Educate and reinforce scrum methodology and agile framework to team members and key stakeholders.
• Conducted sprint retrospective and followed up on action items for continuous improvement as a part of scrum implementation.
• Responsible for defining scope, creating work breakdown structure (WBS).
• Organized regular meetings with Off-shore development team, capture meetings / documentation & sharing of MOM (Minutes of Meeting) with the team.
• Collaborate with cross-functional teams to gather business requirements related to ongoing development using agile estimating and applied user stories.
• Responsible for keeping abreast of all payroll and related tax law working closely with HR, Legal and Payroll Systems Analysts.
• Responsible to ensure that the team maintains systems in compliance with the requirements specified within bargaining unit contracts.
• Directs and coordinates timely and accurate recording of employee Human Resource information as well as payroll processing, including the collection and validation of time and attendance data.
• Assigned to special projects.

Environment: Java, Oracle, MS Visio, UML, Microsoft Word, Excel, Confluence, JIRA, Balsamiq, Selenium, Microsoft Visual Studio, Share-point.

Confidential

Business Analyst

Responsibilities:

• Plan and organizes the payroll processing team.
• Pay attention to internal and external customer requirements and focus behavior toward improvement.
• Coordinate periodic internal and external audits.
• Coordinate special analysis or projects as needs.
• Recognize and communicate potential issues/risks with entire team.
• Assist with the training of new team members.
• Manage and review payroll process including earning, deduction codes, setup, and taxability.
• Ensure compliance with payroll laws and regulations.
• Validate and run various payroll reports to ensure payroll is complete, accurate and timely.
• Monitor departmental metrics and SOX compliance and report on status to team and Manage Employee Services.

Environment: Java, Oracle, MS Visio, UML, Microsoft Word, Excel, Selenium, Microsoft Visual Studio.