SUMMARY

• Over 8+ years of experience in roles such as Business Analyst/Data Analyst/Business Systems Analyst with solid understanding of Business Requirement gathering, Business Process flow, Business Process Modeling and Business Analysis.
• Demonstrated Project management skills to ensure on - time and cost effective project completion.
• Extensive experience in conducting Gap Analysis, SWOT analysis, Cost - Benefit, TCO, ROI, and Businesses Processes Re-engineering.
• Strong understanding of Service Oriented Architecture (SOA), Web Services, Object Oriented Analysis (OOA), Use Case and UML Concepts.
• Extensive experience in Data warehouse concepts and technologies like ETL, OLTP, OLAP, Normalization/Denormalization, Data Models (Star/ Snow Flake Schemas), Datamarts (Dimensions and Facts), Stored Procedures, Web services, Dashboards and Reporting.
• Strong Database/Datawarehouse knowledge with strong SQL and analytical skills.
• Expertise in developingSQL scripts using variousjoins, procedures, functionsin Oracle/SQL Server.
• Adept at gathering requirements by organizing Joint Application developments (JAD) and Joint Requirement Planning sessions (JRP), Brain Storming Sessions, Interviews, workshops and Requirement Elicitation sessions, sessions with end-user/clients/stake holders and the development group.
• Well experienced using Requirements Management tools such as Rational DOORS, Caliber.
• Experience working with RDBMS technologies like Oracle, SQL Server, Teradata, DB2, Netezza and with BigData systems like HDFS, MapReduce.
• Strong understanding of Software Development Life-cycle (SDLC): Analysis, Design, Development, Testing and Implementation and the methodologies including Rational Unified Processing (RUP), Agile and Waterfall methods
• Good experience interacting with the development and testing teams, familiarizing them with the requirements, and demonstrate the same with the Business users and Senior Management.
• Good hands on experience testing of inquiry screens to support EDI transactions.
• Highly motivated, organized and target oriented team player who enjoys working with multi-functional team towards a common goal.
• Excellent problem solving, analytical, interpersonal, and communication skills and a quick learner with the ability to work independently or in a group with minimal supervision.
• Excellent documentation skills including writing Business Requirements Documents (BRD) and Functional Requirement Document (FRD), as well as designing business models, Entity-Relation Diagrams, and process flows based on UML methodology.
• Adept at creating Use Case Diagrams, Activity Diagrams, Business Process Models, Work Flow Diagrams, Data Flow Diagrams, Flow Diagrams (Business and Navigation), Sequence Diagrams, Process Flows (Business and System) using UML modeling tools such as MS Visio and Rational Rose.
• Very good knowledge on testing techniques like black box, white box, UAT and report testing using SQL.
• Good knowledge in Analysis of Bug Severity, Bug tracking system and Bug Reporting.
• Strong business acumen, strategic thinking, communication, interpersonal and presentation skills, adept at creating, editing, and coordinating extensive communication networks.
• Well experienced in conducting knowledge sessions for business users on using various BI reporting tools for creating Ad-hoc reports.
• Experience in developing Test Plan, Test Strategy, Test Cases and Traceability Matrix as per the business process requirements to match the functionality requirements and UML diagrams.
• Experience in facilitating and conducting UAT as well as users on new system functionality
• Well familiar with the AS-IS and TO-BE system, ability to relate requirements to the existing functionality, all the while, exploring chances for scope of improvement for the application within the budget.
• Proficient in MS Office Suite (Word, Excel, Outlook, Access, OneNote, Power Point) and MS Visio.
• Exceptional ability to maintain and build client relationships, ability to comfortably converse with all facets in the client’s organization for requirements and validation, and demonstrated commitment to delivery.
• Strong leadership skills and team work ability; leading technical and sales teams in functionality and performance.
• Good working knowledge of HIPAA Regulations, and Claims and Benefits Processing.
• Well experienced inClaims data analysis, lab claim data analysis, CMS claims data analysis, RxClaim Analysis.

TECHNICAL SKILLS

Requirements Management Tools: IBM Rational DOORS, Borland CALIBER, Accompa.

Documenting/Testing Tools: HP Quality Center 10.0/9.2/8.0 , HP ALM 12.0/11.5, MTM/TFS 2005/2008/2010 , VersionOne, Test Track Pro, JIRA.

Databases: Oracle 9i/10g/11g, DB2 9.7/8.0, SQL Server 2005/2008/2012 , SAP BI, Teradata 14.0, Netezza 6.0

Utility Tools: TOAD 10.5/9.0/8.5 , AQT v8, SQL Server Management Studio, SQL Developer, SQL Assistant, QTPFTP Pro, SOAPUI, Corticon

Data Modeling Tools: MS Visio, Star UML, IBM Rational Rose

Process/methodologies: RUP, Agile, Water Fall, Scrum

ETL Tools: Informatica 7x/8x/9.0, SSIS 2008R2/2012, DataStage 8.7/8.0/7.1

Reporting Tools: OBIEE, Crystal Reports, MicroStrategy 7.0/8.0/9.0, SAP BO XI 3.1, Cognos 10.2

Operating Systems: Windows 2000/XP/Vista, Windows 7, Linux and UNIX.

Microsoft Office: Excel, Access, Outlook, Word, Visio, OneNote and Power Point.

Programming Languages: SQL, PL/SQL, T-SQL, C, Javascript, HTML and UNIX.

PROFESSIONAL EXPERIENCE

Confidential, OH

Sr.Business Analyst

Responsibilities:

• Involved in the SDLC phase of requirement analysis, design and migration of the current state CPS architecture to the new Agrium Insight architecture.
• Successfully used Agile/Scrum Methodology for gathering requirements and documenting User Stories.
• Used Borland CALIBER for creating and managing the requirements.
• Developed Business process, High level concept flows and detailed Interaction flows using Microsoft Visio.
• Functioned as the primary liaison between the business, operations, and technical groups throughout the project cycle
• Created complex SQL scripts to query the database for analysis and ad-hoc report validation
• Assisted the Business and QA teams in planning tests, writing test cases, executing test cases, tracking defects and conduct User Acceptance Testing (UAT).
• Participated in creating User manuals and the ServiceNow users.
• Followed up with the end users and developers for user satisfaction and change management where required.
• Conducted JAD sessions to allow different stakeholders to communicate their perspectives, resolve issues, and reach agreements.
• Facilitated user stories and Story Point discussions to analyze the level of effort on scope specifications for multiple iterations.
• Developed UML Use-Cases and Use-Case diagrams after accessing the status and scope of the project and understanding the business processes using IBM Rational Rose.
• Assisted the ETL Developers in creating stored procedures and automating ETL jobs.
• Assisted the Stake Holders and the product owner in the Sprint planning sessions to determine the scope, objectives, architectural vision of that respective iteration and with budget and resource planning.
• Worked with the design team during the conceptual design phase and conducted GAP analysis to derive requirements from existing systems for the proposed future stateenhancements and determine the risks..
• Created and owned the Requirements Traceability matrix which included all phases of SDLC.

Environment: Netezza 6.0, Aginity Query Analyzer 10.11, IBM Datastage 8.7, Caliber, IBM Rational Rose, HP ALM 11.5/12.0, Cognos 10.2, MS Project, ServiceNow, MS Visio, Sharepoint

Confidential, ST.PAUL, MN

Sr.Business Analyst

Responsibilities:

• Played an instrumental role in defining the initial common terminology to be used throughout the product lifecycle.
• Documented and reported the progress to the management on an ongoing basis.
• Defined roles and responsibilities of participants in the business process.
• Recommend system/process solution approaches to minimize risk and workflow impacts while capitalize strategic goals.
• Led and conducted JAD sessions for requirements gathering, analysis and design of the system.
• Created context and workflow models, information and business rule models, Use Case and Object Models during the analysis using Rational tools.
• Used IBM Rational DOORS to create and manage requirements gathered from the business.
• Automation of test scripts was done using QTP for test re-usability of different online transaction modules.
• Gathered requirements from users of the Clear Quest (CQ) tool for any Enhancements or change requests for any defects.
• Planned and defined system requirements to Wire Frame with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
• Facilitated user stories and Story Point discussions to analyze the level of effort on scope specifications for multiple iterations.
• Analyzed the client data and gathered requirements by conducting interviews with the clients.
• Acted as a liaison between the business users, stakeholders and the team to perform requirements, quality and risk analysis.
• Performed GAP analysis, conducted walkthroughs and set up internal/external status meetings and postmortem meetings.
• Designed and developed project document templates based on SDLC methodology.
• Assisted QA in Regression Test, System Test and UAT in creating complex SQL scripts for data validation.
• Facilitated Change Control Board and Governance Board meetings and acted as a liaison between parties impacted by the change requests.

Environment: Oracle RDBMS 10g/11g, SQL Server 2012, SSMS 11.0, SAP BO, Microstrategy 9.0, HP Quality Center 10.0/HP ALM 11.0, TFS 2010, Test Manager, Citrix, Mingle, IBM Clearquest 8.0, NEO, SSIS, Informatica, IBM Rational Rose, Rational DOORS, Visio 2003, MS Project.

Confidential, IRVING, TX

Business Analyst

Responsibilities:

• Performed requirements gathering from the business users of the system while adhering to SDLC (Software Development Life Cycle) industry best practices.
• Developed excel models to derive the amortization schedule for Whole loan products and Mortgage Backed Securities.
• Interacted with Software development team and Business users as a liaison in helping developers to understand the business requirements thereby ensuring the proposed applications comply with the business specifications.
• Analyzed information and requirements and documented them, reviewed the Business Requirement document and detailed the Systems Requirement document.
• Met with different business users to determine user requirements and goals
• Designed different document templates to gather Business Requirements, Change Requests and UAT.
• Implemented the entire Rational Unified Process (RUP) methodology of application development with its various workflows, artifacts and activities.
• Prepared project plan and defined milestones.
• The system fully supported fixed rate, ARM, GPM, GEM, interest only, deferred payment, home equity, reverse mortgage, second mortgage loan programs, etc.
• Discussed different functional requirements and defined high level design and Use Cases with project team.
• Developed process flow diagrams (flow charts) using MS Visio in an effort to identify and analyze process flows in the BOFA Safe Deposit Box system.
• Lead Validation/Verification, SIT (System Integration Testing), Mock conversion on the system to ensure data accuracy and BOFA Bank’s business needs.
• Wrote User Acceptance Test Plan based on business users requirements and reviewed Test Plan templates.
• Delivered and maintained extensive documentation for future extendibility of the system.
• Analyzed the system to be implemented for production to ensure that it handles complete and accurate data and performs default method of calculations for various mortgage products like Mortgage Backed Securities, Asset Backed Securities, and Megas & Tranches.
• Conducted presentations to make users understand about processes and functionality. .
• Used MS Excel and MS Word to create a field-to-field data map that was used as a main specification document for the conversion program.
• Used JIRA for creating issues brought up by business users and for defect resolution management.
• Developed traceability matrix for maintaining/updating system requirements using MS Excel.
• Prioritized outstanding defects and system problems, ensuring accuracy and deadlines were met. Identified and participated in resolution of business system issues.

Environment: Teradata 14.0, SQL Assistant, JIRA, Informatica, Sharepoint, Accompa, MS Office Suite.

Confidential, EAGAN, MN

Business Analyst

Responsibilities:

• Prepared the Business Requirement Document (BRD) and system requirement document (SRD) for the enhancement of the existing services.
• Serve as Communication Bridge between non-technical users and technical solution developers.
• Actively participated in review sessions for functional specifications and Use cases.
• Act as a liaison between business and IT team.
• Used JIRA for creating issues brought up by business users and for defect resolution management.
• Used HP Quality Center/ALM to prepare Test cases, procedures and Requirements Traceability Matrix.
• Generated Test Analysis Report and graphs using HP Quality Center/ALM.
• Developed Reports and Graphs to present the Stress Test results to the management.
• Helped QA create complex SQL scripts to validate data and worked with Developers to create stored procedures.
• Gathered business requirements through teleconference meetings with Offshore teams.
• Performed task estimations and documentation of procedures.
• Conducted JAD sessions with business units and stakeholders to define project scope, to identify the business flows and determine whether any current or proposed systems are impacted by the new development efforts.
• Maintained and safeguarded the member PHI in accordance with HIPAA and Prime regulations.
• Analyzed the root cause for batch job failures and online application failures and take the appropriate action to avoid the batch delays.
• Assisted in drafting scope document to facilitate communication gap and meet aggressive time lines.
• Tracked and assisted in determining needed resources for Cost Benefits Analysis with project manager and product owner.
• Lead the efforts of the client architecture team in defining the Business Intelligence/Data Warehouse end-to-end architecture
• Extracted patients Electronic Medical Records (EMR), Patients Medical Records, RxClaims information from the Medical Management system, for testing.
• Assessed new Business needs / initiatives and translated them into detailed business requirements specifications and process re-engineering using Rational DOORS.
• Successfully used Agile/Scrum Methodology for gathering requirements, documenting User Stories, and develop process, standards and procedures.
• Worked in tandem with the testing team during System and integration testing.
• Provided test input during the business analysis, system test, functional and UAT lifecycle.
• Identified project risks and issues and communicated them to project team to avoid any delays.

Environment: DB2 9.7, AQT 9.0, HP Quality Center 10.0/11.0, IE 8, Windows 7, SQL PL, Putty, SSIS, Business Objects, SAS Enterprise Guide 4.3, JIRA, MS Excel, MS Word, Lotus Notes, Lotus Sametime.

Confidential

Jr. Business Systems Analyst

Responsibilities:

• Identified the key stakeholders and gathered requirements and determined the scope of the projects.
• Analyzed existing website page-by-page and captured all the various functionalities and documented functional requirements with use cases and UI modeling.
• Used complex SQL to query the database for data analysis.
• Prepared High level system Requirements document and sizing the changes in consultation with the client team using Rational DOORS.
• Generated the High level development roadmap after estimating the development effort based on the requirements.
• Responsible for use cases generation, capturing existing functionality and field design for generating requirements for the new web pages.
• Implemented the entire Rational Unified Process (RUP) methodology of application development with its various workflows, artifacts and activities.
• Involved in discussions with stakeholders to understand the functional changes and change requests.
• Prepared Acceptance Criteria for the functional changes agreed for the documented TO-BE functional requirements.
• Created a new system change documentation template and prepared questionnaire for interview/discussions.
• Conducted multiple User interviews to clarify/understand requirements with users spread across geographical locations involving Europe, US and Asia.
• Written out requirements for consolidating European and North American investment websites and documented the changes for the TO-BE system (functional) with to the existing/AS-IS system.
• Actively coordinated with users across various geographies including North America, Europe and Asia, and conducted user interviews and documented user input to form the high level requirements for consolidation of two websites.
• Thoroughly knowledgeable on the AS-IS and TO-BE system and able to relate requirements to the existing functionality all the while exploring chances for scope of improvement for the application within the given budget.
• Translated business requirements into functional requirements for developers.
• Involved in up-grading HIPAA X12 4010 transactions to HIPAA X12 5010 and ICD 9-CM (Clinical modification) to ICD-10-CM/PCS (clinical modification/procedure coding system
• Worked with the users and different levels of management to identify requirements, use cases and to develop functional specifications.

Environment: SQL Server 2008, T-SQL, DTS/SSIS, Microstrategy 7.0 and 9.0, MS Office, SQL Prompt 5SQL Server Management Studio, Rational DOORS, Test Track Pro, eMagine.