SUMMARY

• Professional with 8+ years of extensive experience as a Business Analyst and Data Analyst, working with the technical staff to implement management and staff's business requirements into the software application.
• 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.
• 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.
• Expert in the field of Business Requirement Analysis, System Analysis, Software Development & Testing with strong understanding and diversified experience in various industries.
• In-depth experience in project management, financial management, business administration, information technology applications, customer service and strategic planning working with the Finance Private Banking, Asset Management and Content Management
• 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.
• Proficiency in MS Word, Power point, Access, Visio, share point, and Change control to produce Documents, Process flow Diagrams and good experience in developing and designing reports throughSSRSandExcel.
• Determining task dependencies, identifying milestones & monitoring critical paths using Burn-down Charts, Defect Heat Maps (Schedule & Allocation), and Requirements Traceability Matrix (RTM).
• Proven track record of successful delivery of application engineering within Business Intelligence and MDM projects with personal accountability for the functional and non-functional application engineering design and execution within large, complex programs/projects.
• Strong Experience in Business and Data Analysis, Data Profiling, Data Modeling, Data Migration and Integration. Experience with various ETL, Data warehousing tools like SSIS, SAS.
• Expertise in conducting Joint Application Development (JAD) sessions, holding interviews and document analysis for user requirement gathering.
• Generated Business Requirement documents (BRD), Functional Specification design documents (FSD) and Functional Requirement Documents (FRD).
• Created business process workflow diagrams using Business Process Modeling Notation (BPMN).
• Outstanding organizational skills in capturing all the Business Flows and presenting them as meaningful artifacts at Inception and Elaboration phase.
• In-depth knowledge of Rational Unified Process (RUP); risk engineering; data modeling and mapping and design using UML, Rational Rose, and Visio.
• Facilitated optimal internal communications by serving as liaison between services organization and product development, product management, and technical teams.
• Knowledge and good understanding of various instruments of the capital markets, especially derivative instruments.
• Built a Project Management Office by creating a standard framework, processes and procedures to follow for all enterprise projects.
• Oversaw all projects in the PMO including business, IT, audit & compliance, and strategic initiatives.
• Worked on Salesforce.com Production, Test and Dev environments during Prod releases. Worked on SOQL and SOSL and performed various DML operations on Salesforce records.
• Experienced in analyzing reporting application using ETL (Informatica Power center and IDQ), Cognos & Qlikview Business Intelligence Suite with multiple data sources like Oracle, SQL Server and MS Access.
• Worked on Configuration of benefits and enrollment system with FACETS by setting up the functionalities.
• Provided consultative and technical support of the ERP system, interfaces, and integrations with other financial applications.
• Has a very good knowledge of FACETS tool and Healthcare domain, Worked on the various modules like Subscriber/Member, Groups, Enrollment, Claims, Billing, Accounting, Provider, MTM Utilization Management. Good knowledge of the claims process and how that process is related to the FACETS system.
• Worked with the User Interface (UI) team to gather requirements for the GUI for the application.
• Created metrics reports using KPI Dashboards, Pivot Tables, Expertise with MS Office Products.
• 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.
• 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.
• Extensive experience working on MS Visio, Excel, Power point, Word, Project, Access and Outlook.
• Problem Solving skills, Multi-tasking skills, ability to meet deadlines, ability to work under pressure and deal with ambiguity.

TECHNICAL SKILLS

Languages: C, C++, Java, SQL.

Data Base: MS Access, Oracle (SQL Series), DB2

Methodologies: Agile, Waterfall, Scrum, RUP, SDLC

Reporting Tools: Crystal Reports

Operating Systems: Windows95/98/2000/XP/Vista/7Software

MS Office Suite: (Word, Excel, Access, Project, PowerPoint & Outlook), MS Visio, Rational Rose, Rational Requisite Pro, Adobe Acrobat, MS Office FrontPage

Performance Testing Tools: Virtual User Generator, Load Runner

Processes/Technologies: Rational Unified Process (RUP), Waterfall, UML & Microsoft SharePoint 2007

Automation Tools: DOORS, Requisite Pro, Win runner, QTP, Quality Center

BI Tools: Tableau Desktop 10.x/9.x/8.x, Business Objects

PROFESSIONAL EXPERIENCE

Confidential

Sr. 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.
• Write business requirements document for installation of Actimize AML WLF (Watch List Filtering) and Actimize AML CDD (Customer Due Diligence).
• Maintain a current understanding and knowledge of KYC, AML Due Diligence, and financing issues, policies, and procedures.
• Was involved in managing the Daily Standup meetings and ensured that quality standards were enforced as per the build-release schedule.
• Worked extensively with Subject Matter Experts (SME's) in understanding, extracting the User & Business Requirements pertaining to clients & wrote functional specification documents & non-functional documents.
• Worked with SharePoint user base to understand business needs and build solutions to address them.
• Create High Level Design Document, Test Plan & Test Case Document, UAT testing and Release Plan.
• Create and prioritize the Back Log in JIRA, coordinate Planning Sessions and maintained User Stories and Acceptance Criteria. 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.
• Partner with our IT Team to provide support, maintenance, plan for future growth and development, and manage the SharePoint environment.
• Responsible for identifying and documenting business rules, created detailed Use Cases and conducted Credit card Derivatives User Acceptance Testing.
• Used MS-Visio for flow-charting, Use- Case process model and architectural design of the application.
• Proficient in working in Manual testing environment as well as automated testing tools like Quick Test Professional and Quality Center.
• Maintained and tested reports with MicroStrategy and other programs.
• Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge.

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

Confidential, CA

Business System Analyst

Responsibilities:

• Interacted with Business Owners, Users, and Stakeholders to identifyBusinessSystemNeeds, evaluated solutions forbusinessproblems and followed Agile Methodology to prepare User Stories.
• Worked with client to gather Business/Technical Requirements, Approval of CR (Change request), Design and Implementations for State MMIS.
• Responsible for designing future state processes for new MCO and transaction between MMIS and MCO.
• 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).
• Collaborate with cross-functional teams to gather business requirements related to ongoing development using agile estimating and applied user stories.
• 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.
• Designed Use Case Diagrams, Activity Diagrams, and Data Flow Diagrams to define the Business Process.
• Tracing requirements throughout the development process and verifying adherence using the Requirements Traceability Matrix (RTM).
• Involved in Salesforce.com application setup and customization activities to match the functional needs of the organization.
• Prepared the Gap Analysis Document & Feasibility Study though extensive use of SharePoint Analytics, various Elicitation techniques like Meetings, Group Discussion, Surveys and JAD Sessions.
• Provided online support to users for various applications such as IPCS (Internet Professional Claims Submission).
• Worked with business owners (SME) in creating legacy data in MDM through IDD (Interface data dictionary). Acted as Meta data owner in updating and maintaining the Legacy hierarchy.

Environment: SDLC, MMIS, Sales Force, MS Project, MS Visio, Quick Test Pro. SAP, Microsoft Office Suite, Track Wise, Oracle, Informatica, Agile.

Confidential, IL

Touch Point Teller Business Analyst

Responsibilities:

• Documented project artifacts such as Business Requirement Document (BRD), Functional Requirement Document (FRD), Test cases and Test Plans.
• 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, to develop a practical technology solution for automating the system.
• 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.
• Created Feature Requirement Specifications including use cases, flow/business process diagram and UI mock.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
• Provide recommendations and experience in using and/or developing various Extract Transform Load (ETL) products and other automated data integration tools.
• Designed and developed BI initiatives on several large modernization and integration projects intended to position our organization as a SaaS provider.
• Worked closely with Risk Assessment department reporting team for deploying Tableau reports and publishing them on the Tableau and Share point server.
• Defect logging in QC/JIRA, retesting and closure of defects in QC-ALM.And writing User Stories in Jira based on the new requirement for each Sprint.
• Developed a quick and thorough understanding of MS SharePoint 2010. Performed quality assurance testing on developed SharePoint sites and web parts.
• Develop, optimize and support Informatica PowerCenter components to provide MDM ETL processes for data extraction, transformations and loading of data.
• Analyzes and defines detailed MDM processes, tasks, data flows, and dependencies.
• Ability to clearly articulate problems and proposed options and solutions and apply judgment in implementing application engineering methodologies, processes and practices to ensure security, resilience, maintainability and quality of MDM solutions.
• Create and prioritize the Back Log in JIRA, coordinate Planning Sessions and maintained User Stories and Acceptance Criteria.
• Provided SharePoint best practices & advice regarding site set-up, site security, maintenance, future needs.
• 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: SDLC, Oracle, Rational Tools Suite (Rose, Requisite Pro), UML, SQL, MS Project, MSOffice.

Confidential

Business Analyst

Responsibilities:

• Coordinating with stakeholders to define the scope of the project.
• Coordinating the requirement gathering sessions with business teams and cross commits.
• Created Feature Requirement Specifications including use cases, flow/business process diagrams.
• Documented both functional and non-functional requirements identifying product impact, assessing complexity and prioritizing.
• Review defect/reports and assign valid defects to the relevant developer/ development manager using HP Quality Centre, Jira and follow the defect life cycle.
• This project software development life cycle was based on the Agile methodology and CRM System.
• Extensively worked in Data Requirement Analysis and Data Mapping for ETL process.
• Responsible for Data Extraction, Data Compilation, Data Analysis, Data Manipulation and Data Validation using SQL queries in a MS SQL Server 2005 environment.
• Provide guidance for system process flow template development & data filtering criteria within CRM system.
• 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.
• Design and implement basic SQL queries for QA testing and report / data validation.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Experience in performing statistical analysis for data cleansing, data indexing and data profiling.
• Created business process workflow diagrams using Business Process Modeling Notation (BPMN).
• Communicating the requirements to onshore and offshore development teams.
• Create content publishing workflow based on Business requirements and discussion with users.
• Defining web service format and requirements.
• Creating Requirement Traceability Matrix using HP Quality Center.
• Coordinating with Test Team to develop Test Plans, Test Cases and Test scripts.
• Coordinating with business team to develop User Acceptance Testing plan and test-cases.

Environment: MS Office Suite, Sales force, MS Visio, Microsoft Word, Excel, JIRA, Balsamiq, Selenium, Microsoft Visual Studio, Share-point.