SUMMARY

• Over 7 years of Experience in Data analysis, Data Modeling, Business Analysis, Quality Assurance and Testing in different customer environments and platforms
• Knowledge and experience in the SDLC using the iterative and incremental methodologies such as RUP, Agile Scrum, and Non - Iterative methodologies like Waterfall.
• Excellent Business Writing skills in developing BRD, Functional Requirement, Use Case SDS, Workflows and UML.
• Provided support to Data Architect and Data Modeler in Designing and Implementing Databases for MDM using ERWIN Data Modeler Tool and MS Access.
• Proficient in creating Use Case, Activity Diagram and BPMN Business Process Models and GAP Analysis.
• Experience in defining the UI, Screen Mocks for Web Interfaces and also define the positive flow and negative flow for each screen.
• Notify designated leads of conflicts and issues, risks, dependencies, overlap, gaps, and any other items that could impact the implementation dates
• Facilitated JRP sessions, JAD sessions with SMEs, Business User Groups, Top Management Groups and Technical Groups.
• Efficient in VBA for MS Excel for planning/status reporting and Adhoc reporting.
• Highly dependable Data Analyst successful at profiling and interpreting data. Supportive and enthusiastic team player dedicated to streamlining processes and efficiently reconciling data issues.
• Worked on Oracle 11g/10g/9i/8/7.3, MS SQL Server 2008/2005/2000/7.0/6.5 , IBM DB2 7.1/8.2/v9, Teradata V2R6/R5 databases
• Good knowledge about Agile Scrum which includes estimation and prioritization of requirements, where software development becomes “real” for project stakeholders; experience in working with Sr. Developer’s in Sprint Session in an Agile SDLC
• Experience in writing requirements for Agile Projects, such as User Stories, Product Backlog List, Sprint Backlog List, Acceptance Criteria, and Estimation & Prioritization.
• Knowledge of UML, MS VISIO, ENTERPRISE ARCHITECT, including REQUISITE PRO.
• Proficiency in elaborating the use-cases, writing test cases and preparing requirement Traceability Matrix (RTM)
• Experience in relational databases using oracle, SQL experience in development and testing database application of SQL Services.

TECHNICAL SKILLS

Business Tools: Rational Suite (Requisite Pro, Rose, Clear Case), UML, MS, Visio, Microsoft SQL Server

Business Skills: Business Definition Requirements, Business Process Analysis, Gap Analysis, Use Case Modeling & Analysis, Business

Methodologies: Water Fall, Agile/SCRUM, RUP, UML,JAD,RAD

Software Packages: MS Office Suite, MS Project, Primavera, MS SharePoint, MS, Visual Studio, Adobe Photoshop

Database: Oracle, MS SQL Server, Tera data V2R5.

Testing Tools: Rational Clear Quest, Quick Test Professional, Quality Center

Operating Systems: Windows XP/95/98/NT/2000/7/8, Mac OS X, DOS, UNIX, Linux, Ubuntu

Programming Languages: C, C++, Java

Web Technologies/Server: HTML, XML

PROFESSIONAL EXPERIENCE

Confidential, Dorchester, MA

Sr. Business Analyst /DATA Analyst

Responsibilities:

• Involved in business analysis and project management, coordinating between the team members and creating business requirements.
• Elicited and documented requirements through brainstorming sessions with business stakeholders
• Translated requirements into user stories and acceptance criteria
• Recommended data analytics solutions that facilitated better project monitoring and control
• Involved with business in requirement gathering and documenting the same in BRD
• Prepared technical specification of various data feeds that will be procured as part of the PNCLive project
• Created mockups in excel and performed large set data analysis using advance excel tools like vlookup, data imports
• Worked with developer to explain the requirement and validate the work in QAT
• Performed all the Quality Assurance functions, which involved creating the test plans, test strategies, test cases and test procedures
• Involved in complete Functional Testing, Regression Testing and User Acceptance Testing
• Identified critical areas of business risk, change in requirements needed, put them forth and assisted the Business Analyst in modifying and documenting the use cases accordingly
• Actively participated in Defect Review Meetings and analyzed the status of the discrepancies
• Extensively executed SQL Queries on Oracle tables to verify the data for Back-end testing
• Coordinated with offshore Team
• Analyzed the efficiency of existing platforms and developed improvisation strategies
• Performed data analysis on large datasets for trends, generated reports to drive business strategy
• Recommended and implemented predictive analytics through data manipulation using SQL queries and Amazon Web Services Machine Learning to increase the efficiency of transactions
• Error handling and performance tuning in Teradata queries and utilities.
• Data reconciliation in various source systems and in Teradata.
• Worked with the project manager for planning and organizing the project activities, and in communicating with other business center mangers and stakeholders of the project.
• Gap Analysis of client requirements, generated workflow process, flow charts and relevant artifacts.
• Defined and documented the scope of the project.
• Designed Use Cases using UML and managed the entire functional requirements life cycle using RUP.
• Documented Agile User Stories, Product Backlogs for the Reporting Application and ensured the Sprint’s outcome was in accordance with the business user’s needs.
• Identified commercial customers with multiple accounts, and enabled a single consolidated view of the accounts balances, services fee charging and history of the accounts.
• Gather requirements and build prototypes for the Commercial Account Analysis statements for either a single account or a group of accounts, showing the profitability of each account and of the group within a single statement. This statement displays balance information, itemized fees and earnings credits.
• Attended weekly meeting to discuss progress and modification to test plans due to change in business requirements.

Environment: Dashboards, MS Visio, MS Office, Agile, SQL Server, SSIS, SSRS, Toad for Data Analysts, Teradata V2R6 (Multi-LOAD, Fast-LOAD, FAST EXPORT, TPUMP, BTEQ), HP Quality Center, SQL, Axure Wireframe, MS Project.

Confidential, Charlotte, NC

Sr. Business/Data Analyst

Responsibilities:

• Assist the project manager in scope creation, project plan creation and resource allocation.
• Advises the QA Team on the validation of currency data elements including charge amount, paid amount, copays, deductibles, and coinsurance
• Performed requirement modeling, development, activity diagrams, data models, business process models, state diagram and use-case realizations using MS Visio.
• Works with the QA team to compile claim lines by carrier and validate method(s) of identifying highest version of each claim line
• Involved in Data Extraction from Teradata and Flat Files using SQL assistant Designed.
• Involved in backend testing for the front end of the application using SQL Queries in Teradata data base.
• Involved in Data Extraction from Teradata and Flat Files using SQL assistant.
• Conducted JAD sessions with Billing Manager and Customer Service Representatives, to identify business rules and Functional requirements.
• Participated in Brainstorming sessions in order to prepare the initial requirements draft for life insurance business to be used in JAD session.
• Prepare Business Requirements documents for the life insurance application based on the requirements gathered.
• Strives to validate and deliver the maximum amount of high quality data to stakeholders
• Documenting the extent to which data fails to meet threshold reporting requirements
• Performed source data validation and analysis to identify and consume the source data.
• Gathered requirements from the users and Underwriters for the life insurance application.
• Understood current billing processes through the process of Business Modeling.
• Participated in Daily Scrums to report the daily work status.
• Created User Stories, Product Backlog lists and Sprint Backlog lists in an Agile environment.
• Extensively created wireframes and activity Diagrams using MS VISIO for representing the ‘AS-IS’ and ‘To-Be’ systems to ease the differentiability of ‘To-Be” for the developing team and for validation from the user group and to outline the “To-Be” screens and “To-Be” process respectively. Thus championed in creating visually aiding artifacts for the development team and in keeping users satisfied about their To-Be enhanced system.
• Work closely with UI Engineers to develop high-fidelity mock-ups of the system.
• Defined UI, Mockups and the Positive flow, negative flow of each screen / web interface.
• Developed screen mockups for the reporting requirements. Micro strategy was used for enterprise reporting and dashboards
• Conducted Requirement walkthroughs with Developers and QA team to help them understand the requirements and identify feasibility issues, if any.

Environment: ETL Informatica 9.x, Teradata V2R6,SQL Server 2008, Agile, MS Visio, Enterprise Architect, MS Project, MS Office Suite, Rational Tools, Micro strategy, HP Quality Center

Confidential - New York City

Business Analyst

Responsibilities:

• Proposed and developed a Regulatory Compliance Risk Assessment Tool for the bank, which is implemented in 90+ RAU’s (Risk Assessment Units) of the bank across the globe. This tool significantly detected the risk areas for bank & calibrated the quantum of risk on a 9 point scale across different LOB’s, regions and overall firm
• Gathered the business requirements from Global Compliance Risk team by interacting on a day to day basis and got an understanding of different compliance categories, risk assessment units, regional regulations etc.
• Designed Business Process Diagrams, Business Requirements document, Project Charter and other artifacts required at the initial phase of the project using RUP
• Delivered detailed Use Cases and business rules traceability matrix covering all the proposed functionalities of the new tool which helped bring a sound product deliver in production
• Created User Interface Designs using MS-Visio helping the UX design team to come up with artistic wireframes in a timely manner
• Coordinated between different stakeholders bridging the knowledge gaps by conducting regular JAD sessions
• Regularly apprised the senior management about project status by providing daily/ weekly status reports about the ongoing activities and achievements of the project

Confidential, Hartford, CT

Business/Data Analyst

Responsibilities:

• Proposed the project execution approach at the program level.
• Conducted GAP analysis & Impact Analysis while implementing Change management
• Analyzed business requirements and segregated them into high level and low level Use Cases, as well as activity diagrams / State Chart Diagrams and Robustness Diagrams using Rational Rose according to UML methodology, thus defining the Data Process Models.
• Used Rational Unified Process (RUP) for requirements gathering, Rational Rose for UML Modeling and Rational Clear Quest for Defect Tracking.
• Defining and creating prototypes, wireframes for entire project.
• Facilitated Change management across entire project process.
• Resource planning for user acceptance testing and test script creation. Liaise with the Middle office, technology and users for Risk System migrations
• Involved in gathering requirements and documentation of business requirements
• Participated in periodical Joint Application Development (JAD) sessions with the management and IT teams; technical design walk-through to gauge extent of compliance with Trading Partner’s expectations
• Attended JAD sessions and Test meetings to discuss and resolve issues and change requests.
• Led the solutions team to review, analyze, and recommend changes and improvements to gather requirements and develop solution requirements.
• Determined Project goals and priorities with management, program manager and/or project sponsors.
• Elicit, Capture and document functional and non-functional requirements from clients and write supplementary specifications documents for non-functional requirements for the web application.
• Managed and Monitored Provider Data for various clients
• Analyze and interpret benefit requirements from state contracts (Medicaid) and provider manuals and place information to existing templates
• Modeled the detailed design of the system using Use Case Diagrams
• Involved in life-cycle documentation from product requirements in the developmental stage to functional specifications for the completed modules of application components
• Submitted change requests and worked with change request records in Clear quest.
• Participated in entering, tracking system defects in Rational Clear quest
• Notify designated leads of conflicts and issues, risks, dependencies, overlap, gaps, and any other items that could impact the implementation dates
• Assisted in Regression Test, System Test and UAT.

Environment: Claims Processing, Health Care Billing System, Rational Rose, Rational Requisite Pro, Rational Clear Quest, Rational Clear Case, MS-Share Point, Micro strategy, MS-Office Suite, Mercury Win-Runner, Mercury Load Runner, AS/400,Java, J2EE, Oracle(SQL and PL/SQL), Informatica