SUMMARY:

• Seasoned Business/Systems Analyst with 10 years of experience in Business, Data analysis/modeling, business requirements gathering, database design and development of Web Based, and Client/Server applications, Data Warehousing concepts and web design and development.
• Good Business Knowledge in Life insurance and retirement services (401k, 403b, IRA).
• Expertise in managing Technical Product Managers, Information Architects, UX Designers, Mid - Tier Dev, UI Dev, QA Analysts and other BA’s) on the web redesign of a post-trade matching and settlement application.
• Proficient in using Pivot Tables for analysing a large data. Productive and creative in using Microsoft Excel and Power BI for Business and reporting.
• Proficient in creating Power Point Deck
• Worked cross-functionally to ensure UI design guidelines and best practices are followed and the design and performance can be achieved despite the technical constraints associated with applications requiring interactions around large amounts of data..
• Experienced Business Analysis/Business Process trainer.
• Worked closely with various levels of users, from external customers to internal marketing and operations units to help ensure that systems meet user needs.
• Performed in an analyst role, planning the activities required to implement large-scale open systems business development.
• Excellent working knowledge in Software development methodologies such as Agile, Waterfall.
• Expertise in business process modeling, documentation, and testing using technical assessment tools such as Rational Suite (Rational Rose, Requisite Pro, SoDA, Clear Quest, Robot) as well as MS Visio and MS Project in combination with UML 2.0 diagramming techniques, Primavera, MS Access, Lotus Notes etc.
• Created Use Case, activity, logical, component and deployment views with rational tools to extract business process flows and workflows thereby helping development and quality assurance teams in understanding the requirements.
• Change Management Process (Identify, Analyze, Evaluate, Plan, Implement, Review and Close).
• Worked on ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence, WEBI reports and Domains - Security, Universe, Document etc.).
• Determined the project tasks schedules and resource needs for full cycle development and Worked closely with the development group and lead analysts to help ensure that the project is on track and on time
• Prepared work-plans and project status reports
• Identified testing requirements based on business and technical specifications and Worked with management and business groups in developing test plans
• Provided logical and innovative solutions to complex problems
• Identifying options for potential solutions and assessing them for both technical and business suitability.
• Excellent customer service skills and the ability to successfully and consistently satisfy client expectations when working in a solution center environment.

TECHNICAL SKILLS:

Programming Languages: C, C++, Java, SQL

Databases: MS-Access, MySQL, SQL Server, Oracle, Teradata, DB2s

Automation Tools: MS Visio, Rational Rose, Rational Clear Case, Rational Requisite Pro.

Bug Tracking Tools: Mercury Test Director, Rational Clear Quest

Utility Tools: MS Office Suite, MS Project, TOAD, Adobe Photoshop

Reporting Tools: Crystal Reports

Data warehousing Tools: Informatica

Testing Tools: Quick Test Pro (QTP), Test Director, Win Runner, Load Runner

SDLC Methodoligies: Agile, Waterfall

Agile Tools: Jira,Rally

Quality Tools: Mercury, HP ALM

PROFESSIONAL EXPERIENCE:

Confidential, Bloomfield, CT

Product Owner/Business Analyst

Responsibilities:

• Conducted business analysis, acted as a liaison between project manager, business users, & IT team.
• Thoroughly understood the Business/Customer needs.
• Written User Stories and acceptace criteria to communicate the needs of the business and customers.
• Developed Strategy and direction for the Project and set long and short term goals.
• Gathered,Priortized and managed product requirements-
• Worked with the development team on daily basis to answer questions and make decisions.
• Conducted Sprint Planning, Backlog Refinement(Grooming), Sprint Demo, Sprint Retrospective.
• Lead the scrum team in Program Incremental (PI) Planning and Priortized User Stories per business needs.
• Managed well with the product dashboard and Communications to internal teams.
• Coordinated with Product Manager to understand the features and changes in Product requriements and supported the release planning and sprint planning activities.
• Collected and evaluated business requirements, functional specifications, project schedules, documentation and test plans.
• Created Mapping Documents, Report Mock-ups and modified existing report mock-ups and finalized for development.
• Prepared Business Context Diagram, Use Case diagrams and corresponding Activity Diagrams.
• Helped Scum Master to maintain continuous velocity stream and ensured quality, and eliminated escaped defects.
• Worked with the testing team to create the testing scenarios, Queries and helped them to understand the logic.
• Actively worked on Process Improvements.

Environment: Microsoft Office 2010 Professional (Outlook, Word, Excel, Visio, Access, etc.), Microsoft SharePoint 2010, MS Visio, Microsoft SQLServer, SQL, Rally, Teradata(V5.3.3), Toad (3.8), Tableau(9.0), HP ALM

Confidential, Denver, CO

Lead Business Systems analyst

Responsibilities:

• Gathered, analyzed, documented business and technical requirements from both formal and informal sessions and validate the needs of the business stakeholders.
• Facilitated JAD sessions with SMEs and business analysts from other feeder systems for a detailed analysis and a better understanding of impact of various projects on each other.
• Extensively worked on Facets Modules such as Membership, Claims processing, Eligibility and Capitation.
• Worked on user interface design processes, standards, and best practices for web distributed applications.
• Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
• Extensively interacted with the stakeholders and the IT Department in finalizing the requirements according to the Compliances/Regulations and HIPAA Regulations.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOAD using UML and Business Process Modeling.
• Created Mapping Documents, Report Mock-ups and modified existing report mock-ups and finalized for development.
• Acted as a mentor and provided coaching and guidance to Stage-I and Stage-II SAs on work related issues.
• Supported major projects involving configuration changes to Facets (4.8V-5.01V)
• Worked on ensuring the configured TriZetto products and services are functioning as expected and will meet end user requirements.
• Participated in interdepartmental workgroup sessions designed to facilitate effective solutions to ongoing systematic transaction processing problems.
• Created job aids such as; training materials and workflows for configuration and related tasks.
• Demonstrated good judgement in defining methods & techniques for obtaining solutions and worked on advanced problems of diverse scope and complexity where analysis of situation and data requires a review of a variety of factors.
• Used SQL to test various reports and ETL load jobs in development, QA and production environment
• Worked with testing team to create the testing scenarios, Queries and helping them to understand the logic.
• Provided recommendations for improving testing approaches, processes and procedures
• Acted as a peer leader for the testing efforts of Facets and QNXT configured solutions for projects

Environment: Windows XP (SP-3), Caliber,HL7, Toad-11,Toad-Data Modeler, HP Quality Center, MS Project Plan, MS Visio, Microsoft SQL Server, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), TSQL, Oracle 10g,MS Office Suite, DB2, SharePoint 2010.

Confidential, Bloomington, IL

Lead Business Analyst

Responsibilities:

• Interacting with the stakeholders to get a better understanding of client business processes and gather business requirements.
• Collected and evaluated business requirements, functional specifications, project schedules, documentation and test plans for the Online Account Management system to ensure the registered customers had online web based access to their accounts and investment portfolios.
• Created SSMS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Conducted CR “Change Request” walk-thru and approved FSD, BRD, Artifacts, & CR Sign-offs.
• Met with Business Users, Project Manager and SMEs, discussed the project scope and main end-to-end pipelines in the present system.
• Analyzed and translated business requirements into system specifications utilizing UML and Agile methodology.
• Worked cross-functionally to ensure UI design guidelines and best practices are followed and the design and performance can be achieved despite the technical constraints associated with applications requiring interactions around large amounts of data
• Identified Use cases from the requirements and wrote Use Case Specifications
• Created business process workflow diagrams (Activity diagrams) in Rational Rose
• Worked in development front-end production entry screen and batch interfaces between remote AS/400s and the corporate mainframe
• Worked with developers and designers of BPM System to make sure development understands business process and detailed technical requirements.
• Integrated Requisite Pro with Clear Quest and Rose to provide all teams visibility and maintain tractability among requirements, use cases and change requests
• Designed Data Flow Diagrams (DFD’s), Entity Relationship Diagrams (ERD’s), and web page mock ups using modeling tools.
• Planned and documented procedures for data processing and prepared data flow modeling for the application.
• Created test plan and test cases for user acceptance testing. Used Rational testing tools.
• Utilize SharePoint Designer to build workflows and processes. Work with development team for back end custom code, etc.
• Developed detailed Test plan, Test Cases, Test scripts for testing the functionality, GUI and security testing.
• Used the Unified Change Management from Rational to track changes to multiple artifacts by versioning artifacts, associating requirements to specific change request/defects to streamline the defect/change tracking process.
• Assured that all Artifacts are in compliance with corporate SDLC Policies and guidelines.

Environment: Quality Center, Rational Rose, Rational Requisite Pro, DB2, Rational Clear Quest, JAD, Rational manager, Rational Administrator, MS Project Plan, MS Visio, Microsoft SQL Server, SSMS, SSIS, TSQL, Oracle 10g,MS Office Suite, Java, J2EE, VB.Net, Oracle, HTML, UML.

Confidential, Jacksonville, FL

Systems Analyst

Responsibilities:

• Conducted business analysis, acted as a liaison between project manager, business users’, & IT team, and used MS Office for the documentation.
• Prepared documents for business requirements document (BRD), systems requirements specification (SRS), high level design documents (HLDD), and traceability mapping / matrix with the assistance from the business group, and the IT team members.
• Prepared Business Context Diagram, Use Case diagrams and corresponding Activity Diagrams using Rational Rose to depict the workflows to be incorporated into the development of Pega Business Process Management (BPM) tool.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Created Data Stage jobs to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files etc
• Performed data validation and massaging to ensure accuracy and quality of data
• Mainly worked on Claim processing system(Professional, Institutional, Pharmaceutical Claims)
• Analyzed the requirements of data marts. Worked with business users to understand their reporting requirements, worked with Reporting team to develop report prototypes, demonstrated report prototypes to the business users, came up with FRDs for the data
• Acted as a SME for key business functions within BCBS product Family.
• Monitored and resolved all customer invoice data issues and coordinate with various vendors and manage all previous balance.
• Delivered enhanced functionality, new data sources, provided integrated operational data and analytic tools and improved capabilities to provide better data to gain business insights for decision making.
• Identified the scope of business needs and metrics that will drive revenue, growth, determined customer profitability, increase productivity and improve efficiency.
• Held responsible for user training and change management business activities for implementation readiness.
• Designed and developed Use Cases using UML and Business Process Modeling. Applied Unified Modeling Language (UML) methodologies to design Use Case Diagrams, Activity Diagrams and Sequence Diagrams in Rational Rose.
• Created the SQL scripts for demonstrating the prototypes and for verifying the result sets
• Reviewed test results for any system modification
• Provided direction on key requirements for test plans.

Environment: Microsoft Office 2003 Professional (Outlook, Word, Excel, Visio, Access, etc.), Microsoft SharePoint 2003,UML, RUP, UAT, db2, HL7,Mercury Test Director, MS Project Plan, MS Visio, Microsoft SQLServer, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), TSQL, Oracle 10g,MS Office Suite, .NET, Clear Case.

Confidential, Greensboro, NC

Business Analyst

Responsibilities:

• Provided expertise in strategic planning, business process modeling, business process analysis, object-oriented analysis & design, use case modeling, use case analysis, component-based development, and quality assurance. Followed top down, levelled technique for building Business Process Models.
• Implemented an integrated Agile solution with complete line of traceability for all the artifacts of web development project. Created User Stories for all the existing user roles.
• Prepared business and functional requirements including 401(k) and 403 (b) data flows, developed Use Cases, Wireframes, Process Flows, Data Modelling and Flow Diagrams and documented System Specifications.
• Designed a module to rollover member refunds to qualified retirement plans such as 401(k), 403 (b), IRA.
• Used Quality Center to look up defects and issues raised by testing activities.
• Worked with the UI team to create the User Interface screenshots to be presented to the Business.
• Prepared graphical depictions of Use Cases, Use Case Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Component Based Diagrams, and Collateral Diagrams and creation of technical design (UI screen) using Microsoft Visio.
• Performed custom data conversions and developed custom software for risk management applications including commercial insurance, life insurance, etc, tracking. Perform all data field mappings.
• Performed Gap analysis for the modules in production, conducted feasibility study and performed impact analysis for proposed enhancements.
• Provided key input in working with System’s architect to baseline System Performance, identified expected Bottlenecks and set Load and Stress Targets.
• Performed in an analyst role, planning the activities required to implement large-scale open systems business development
• Coordinated with project management and the development group for review and approval of written specifications