SUMMARY

• Close to 15+ years of working experience in various industries like financial, banking software, healthcare insurance and hi-tech.
• Ability to simultaneously handle multiple tasks and skills in the areas of: Financial Analysis, Quality Assurance Analysis, Assessing Client Needs, Effective Presentations and Financial tools.
• Highly Proficient in different types of testing like Functional and Regression Testing, System Testing, Integration Testing, User Acceptance Testing & Performance Testing,
• Extensive knowledge of Object Oriented Analysis and Design using UML, Rational Unified Process (RUP) and MS Visio.
• Data warehouse analyst, implementing data warehouse solutions and supporting data warehouse processes. Thorough understanding of extraction, Transformation and load (ETL) process and understanding of logic database design, modeling and data-mart processes, understanding of OLTP vs DSS systems.
• Key role in data warehouse project development and enhancement; Working with vendor (EDS/HP Switzerland) in participating, defining standard work process and document IM-OI data warehouse project upgrades, deployment steps to meet SOX compliance.
• Lead analyst for the Financial Regulatory Authority’s enterprise data warehouse; responsible for gathering and analyzing enhancement requests from users, initiating change requests in Star Team, maintaining and expanding logical and physical data models in Erwin, and developing and documenting ETL specifications in DOORS
• Experience in carrying out Software Development Life Cycle (SDLC) life cycle in Relational and Object Methodologies.
• Well versed with SDLC methodologies like AGILE Scrum, RUP and Water fall
• Initiated Requirements Gathering, prepared the Software Requirement Specifications (SRS) document and used Rational RequisitePro to maintain the requirements.
• Experience in interacting with business users to identify the requirements, analyzing and documenting user requirements into Use Case Model using Business Modeling tools like MS Visio and Rational Rose.
• Proficient in developing Use Case Diagrams, Analysis Model, Design Model, Behavior Diagrams(Sequence diagrams, Collaboration diagrams, Activity Diagrams), and Class Diagrams based on UML methodology using Rational Rose.
• Experience in design and development of test case scenarios, developing test plans. Excellent knowledge of Black Box Testing, User Acceptance Testing (UAT), Unit, Integration, Functional, Load, Regression and Interoperability testing.
• Facilitated and participated in Joint Application Development (JAD) sessions, user workshops, interviews, conference calls and white board sessions to keep executive staff and the team members apprised of goals, project status, and resolving issues.
• Experience performing the Gap Analysis to determine the existing system, documenting, and approving the variance between business requirements and system capabilities.
• Experience in the documentation of system and business requirements and specifications, technical and user manuals.
• Experience with training and mentoring team members with product knowledge and business processes.
• Excellent organizational and interpersonal skills with a strong facility for acquiring new knowledge very rapidly.

EDUCATION & CERTIFICATIONS
BS, Accounting

TECHNICAL SKILLS

Rational Requisite Pro, UML 2.0, EA

Microsoft Tools

MS Project, MS Visio, MS Office, MS Outlook, MS FrontPage

Databases & Languages

PL/SQL, HTML, XML, SQL, UNIX, JAVA, .NET, C++, ABAP, Oracle 8i/9i, MS SQL Server, MS-Access 2.0

Testing Tools

Quality Center, QTP, TFS, MS Test Manager

Methodologies & Standards

SEI - CMMI, ISO 9001:2000, RUP, Six Sigma, SDLC Agile, QA

Operating System

Windows 95/98/NT/2000/XP, UNIX, Linux

Tools

Adobe Acrobat, Business Explorer, Toad

Skills

OOAD, UML, RUP, SDLC, JAD

Financial

SAP/FICO, Quick Books

PROFESSIONAL EXPERIENCE

Sr. Business Analyst, Danville PA Apr 2012 – Present

Geisinger Health Plan, a not-for-profit health maintenance organization (HMO), serves the health-care needs of members in 43 counties throughout central and northeastern Pennsylvania. Begun in 1985, the Health Plan has steadily evolved into one of the nation\\\'s largest rural HMOs by providing high quality, affordable health-care benefits.

As a Business Analyst in Geisigner, I performed pivotal role in multiple projects & handling three releases at the same time. Release was web-based service application developed for streamlining office workflow processes involved in Electronic Data Interchange (EDI) transactions and benefits in claims management cycle based on HIPAA Guidelines. Release three was based on reporting the policy premium. There were seven reports, which were generated in Brio portal.

Responsibilities:

• Analyzed, developed and evaluated data mining in a data warehouse environment.
• Developed and evaluated data design, and repository creation.
• Used data extracting, BI and data analysis tools.
• Reviewed and validated data loaded into the data warehouse for accuracy.
• Interacted effectively with user community to produce analysis results and analytics requirements.
• Responsible for prototyping solutions and conducting tests.
• Performed data replication, extraction, loading, cleansing, and data modeling for data warehouses.
• Performed and created database design, development, and maintenance.
• Analyzed, designed, and developed data modeling solutions.
• Effectively identified of end-user requirements.
• Manned for in-depth source system analysis and ensured Data Quality.
• Gathered and assessed business information needs and prepared system requirements.
• Ensured data integrity and timely output of daily, weekly, and monthly scheduled jobs.
• Documented and tested all queries used to pull data for reporting purposes.
• Helped in defining Change Management Process for Release Management Team.
• Mapped process flows; assessed as-is processes through user interviews, data collection and analysis, design and evaluation of to-be process solutions.
• Prepared Business Object / Business Process Models that included modeling of all the activities of business from conceptual to procedural level.
• Consulted with healthcare insurance company to develop conversion specifications for other insurance Coordination of Benefits (including Medicare).
• Experience in integrating claims, eligibility, provider and data information using facets
• Conducted analysis, assessments and cost/benefit analysis using facets
• Experience in Facilitating organizational change strategy development and objective setting with a cross-functional group ofBusiness/Statestakeholders
• Responsible for analyzing the impacts of performance analysis, optimization and testing.
• Responsible for creating Customized Transaction set using ECMAP tool
• 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.
• Analyze business requirements and segregated them into Use Case Diagrams, Activity Diagrams, Sequence Diagrams, and OOD using Borland Together according to UML methodology thus defining the Data Process Models.

Environment: Windows 2000/XP, Toad, Agile, MS Project, MS Access, HP Quality Center, Business Process, Rational Clear Quest, Rational Clear Case, Rational Requisite Pro, Crystal Reports, Rational Rose, UML,RUP, Informatica, MS Office, MS Visio

Sr. Data warehouse Analyst Wilmington, DE Nov 2011 – Apr 2012
Confidential,
My project with MetLife is about their acquisition of Alico. Alico sells life insurance products outside of US. I am dealing with their operations in few European countries. Metlife is standardizing the valuation for the life insurance policies in these countries so that it meets their local regulation requirements. The process will be automated from both ends that is between US and the country. As a BA I am working with various groups such as KPMG Analyst, Actuarial consultants, developers and testers from MetLife to coordinate about the whole process and if there are any gaps in there. We are helping the company in doing some analytical work and communicating with each group regarding the work, bringing up any issues that might arise and tracking the progress of each country.
Responsibilities:

• Key member of company’s 3 data warehouse development projects. Project goal included DW database implementation, business reporting solution and implementation.
• Participated in planning, designing and implementing data warehouse and data marts solution. Implemented Logical and physical data modeling for the data warehouse.
• Data Warehouse consultant tasked with providing consulting in business unit data and information needs, liaison between Legal Compliance and IT business units.
• Maintain a detailed knowledge of the SQL Server and Oracle data warehouse contents and the business rules underlying the data warehouse data and schema.
• Performed GAP Analysis to define gaps between AS-IS and TO-BE processes.
• Acted as a facilitator in JAD sessions to analyze and prioritize competing business needs.
• Determined traceability and dependability between the requirements using Rational RequisitePro.
• Assured that all RUP artifacts are in compliance with corporate SDLC policies and guidelines.
• Created Use Case Diagrams, Activity Diagrams, Data Flow Diagrams, and Sequence Diagrams.
• Created BRD, Vision, scope, wire frames and Functional Spec.
• Developed test plan, test conditions and test cases to be used in testing based on business requirements, technical specifications and product knowledge.
• Used Test Director to manage testing and defect life cycles, and map requirements to test cases. Performed role of administrator for Test Director.
• Liaison with customer’s business unit managers, stakeholders and functional subject matter experts (SME). Created project charter, scope and schedule.
• Performed change management system during change requirement.

Environment: Rational Requisite Pro, Test Director, Ms Office, SQL, Visio, MS Excel

Sr. Business Analyst New York, NY Jun 2011 – Nov 2011
Project Details: Worked with the Project Rewind which was established in anticipation of the possibility that the Federal Reserve Board or Congress might eliminate the exemption from U.S. capital requirements currently enjoyed by Taunus Corporation (“Taunus”) and/or create new requirements emanating from a designation of Taunus or its subsidiaries as systemically important.
The Project rewind consisted of the following projects to overcome the potential of being subjected to heightened prudential standards including increased capital requirements (including Basel rules), supervision, etc. and so the decision was made to:

• De-bank Taunus
• The PRSC, based on analysis performed to date, concluded, as Phase 1, to spin-off Deutsche Bank Trust Corporation (“DBTC”) and its subsidiaries from Taunus to DBAG.
• The distribution of the shares of DBTC from Taunus to DBAG will terminate Taunus\\\' status as a bank holding company (“BHC”).
• Taunus, no longer a BHC, will not need to implement the U.S. Basel II standards and, absent any other actions; will not need to comply with the requirements of the Collins Amendment. Luna dependency - Implementation of New Tax Views
• The distribution of the shares of Deutsche Bank Trust Corporation (“DBTC”) from Taunus to DBAG will terminate Taunus’s status as a bank holding company (“de-banking of Taunus”). This will include the Regional Consolidation System Entity Structure Changes
• Project Luna Dependencies
• If the spin-off of DBTC and its subsidiaries were to occur before the completion of Project Luna, described more fully on the following pages, it would prevent the recombination, for U.S tax purposes, of DBTC and its subsidiaries into the Taunus Group for a five-year period.
• Alongside the de-banking of Taunus requirement, the one tax payer view should be implemented in the Regional Consolidation System, which will ensure one taxpayer structure is in effect prior to de-banking.
• Alternative Spot and Average Scenario Planning
• Even after a de-banking of Taunus a Systemically Important Financial Institution (SIFI) status could be assigned to any number of DB U.S. entities and/or a Systemically Significant Bank Holding Company (“SSBHC”) status assigned to DBAG which would result in heightened U.S. risk monitoring and capital standard requirements.

Responsibilities:

• Created Master data Info Sources for uploading attributes, texts, and hierarchies from SAP R-3 system.
• Extensively worked with SAP BCS experience on this project.
• Performed query unit testing and worked with end-users to schedule and perform UAT for the queries.
• Created settings and process chains used in Information Broadcasting to send Consolidation reportsand workbooks to multiple properties.
• Experienced with initial and delta loads from RCS systems, also scheduling and monitoring data loads.
• Participated in the requirements gathering of the client’s business and documented the business processes.
• Created BEx Reports using Reporting variables like Characteristics, Text, Formulas, Hierarchies and nodes.
• Understood various process plans, functionality and business in detail to prepare integration test plan.
• Performed flexi upload of data – data uploaded for consolidation of accounts
• Processing of system generated entries eg. Standardization entries, consolidation of investments, inter unit eliminations and equity investment eliminations.
• Validations of the data from a business and IT perspective
• Ran reports out of the SAP BCS system to troubleshoot issues found during testing by the user.

Environment: SAP BCS, MS Office, MS Visio, eRooms, Metadata, Data Warehouse, RCS System , BEx, SQL

Sr. Business Analyst / Project Manager Pasadena, CA Apr 2009 – May 2011
PeopleCert is an employee and individual performance-improvement company with many years of experience in the technology-based, self-paced training arena. We provide personalized learning and certification that supports organizational success. Our on-site, online learning and online testing tools cover topics ranging from technology to finance to enterprise business skills.

Project Successfully Delivered:

• PeopleCert Company Portal
• PeopleCertEducation Online Portal
• PeopleCertTesting Online Portal
• PeopleCert Member’s Portal

Responsibilities:

• Interacted with business owners to identify business system needs, evaluated solutions or business problems and proposed alternate methods to increase efficiency.
• Analyzed and documented information system requirements and the corresponding impact on business processes using Business Process Models.
• Responsible for defining the scope using project backlogs and sprint backlogs and implementing business rules of the project, gathering business requirements and documenting user stories and personas.
• Support cross functional global data warehouse users; diagnose data issues raised by function users, provided issue resolution in timely manner.
• Work across Oracle ERP R12 & EDW system to understand AR, AP, Order management, BOM etc module data flow, therefore to enhance data quality in the data warehouse.
• Responsible for writing Functional Requirement Specifications (FRS) and User Requirement Specification (URS)
• Analyzed Business Requirements and segregated them into high level and low level Use Cases, Activity Diagrams using Rational Rose according to UML methodology thus defining the Data Process Models.
• Successfully conducted JAD sessions, which helped synchronize the different stakeholders on their objectives and helped the developers to have a clear-cut picture of the project.
• Responsible for maintaining the minutes of all the requirement gathering sessions.
• Independently manage project scope, risks and manage project meetings as needed to drive projects to completion.
• Successfully implemented all tactical operational monthly releases. Eight releases to date with a 100% success rate ranging from 20 to 28 enhancements, 30 to 42 bug fixes and numerous emergency fixes.
• Managed a team of 8 developers, testers and analysts and performed all HR processes including performance and career growth.
• Provided people care for individual through career planning, training, compensation, and career advancement based on performance.
• Define the project strategy by evaluating alternative approaches to meet stakeholder regarding content management requirements, specifications, and/or expectations. Establish project controls by defining the required correct processes, measures, and controls to manage project change, communications, procurement, risk, quality, and human resources to facilitate project executing and controlling processes, and to ensure compliance with generally accepted industry standards.
• Formulated comprehensive test plan based on requirements and develop test scenarios based on use cases
• Performed regression, functional testing, stress testing, performance testing, user interface testing, User Acceptance and system testing.

Environment: .Net, XML, MS Office, MS Visio, AGILE Scrum, eRooms, Metadata, Data Warehouse , TFS, QC , QTP, SQL

Senior Business Analyst/ Sr. QA Analyst/ Financial Analyst Newark, NJ jan1998 –mar2009

For over 135 years, we have leveraged our life insurance and asset management expertise to help individual and institutional customers grow and protect wealth. Prudential Financial companies serve individual and institutional customers worldwide and include The Prudential Insurance Company of America, one of the largest life insurance companies in the U.S. These companies offer a variety of products and services, including life insurance, mutual funds, annuities, pension and retirement-related services and administration, asset management, banking and trust services, real estate brokerage franchises, and relocation services.

Prudential Financial
Senior Business Analyst (2005 – 2009)

Responsibilities:

• Business Analyst and Quality Analyst for multiple projects during the tenure
• Conducted JAD and facilitated brainstorming sessions with a diverse global group of SAP Users and Consultants to understand users\\\' requirements
• Analyzed and documented information system requirements and the corresponding impact on business processes using Business Process Models
• Responsible for defining the scope using project backlogs and sprint backlogs and implementing business rules of the project, gathering business requirements and documenting user stories and personas.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams using UML and Visio
• Handled many design change and requirement changes in various versions and service packs of the product
• Represented end user to the development group for product prototype validation
• Created Product Quality Management Plan in MS project in parallel with the Product Development Plan created by Development Managers to fit into overall Project Plan
• Convened SDLC deliverable reviews and planned all QA activities and created QM schedule
• Convened quality gate review meetings with higher management for logical transition of the product to the next phase of product life cycle and apprised them of the quality status of the product
• Assisted in the coordination of the operational and functional planning processes for the Fixed Income Management group.
• Prepared reconciliation reports for the GAAP and STAT accounts.
• Analyzed plans and other financial information and trends for significant changes. Researched causes compiled explanations and reported to management.
• Completed various reports by retrieving data from the database by writing SQL statements to add, modify, copy and delete data.
• Performed advanced problem solving and analytical analysis to reduce complex data to simple concepts for communication to team members and management.
• Acted as a liaison between the different departments and units and worked very closely with the Business managers of the different departments.
• Used programming capabilities and systems understanding to identify non-routine events, determine alternatives and recommended course of action to management.

Environment: AGILE Scrum, UML, MS Project, MS Visio, Rational Requisite Pro, MS Office, SQL, Java, Windows 2000/NT

Prudential Capital Group
Senior QA Analyst (2001 – 2005)

Responsibilities:

• Assisted in identifying and gathering requirements from Users/Business Partners to decide on the technical architecture and infrastructure to be used and come up with a design process.
• Analyzed the business process specifications, use cases, and user interface specification documents.
• Participated in Feature Design review meetings and presented test case review, strategy and feature functionality and documented test cases and conducted manual testing.
• Translated the information to test cases and test procedures, based on use cases.
• Created Test Cases from Functional Requirement document and maintained traceability matrix
• Prepared Test environment (installation and configuration of product builds)
• Followed a structured approach to organize requirements into logical groupings of essential business processes, business rules, information needs and insured that critical requirements are not missed
• Involved in planning, execution, coordination of entire testing (QA) life cycle
• Developed strategies for Test Planning, Test Case Designing, Test Scheduling, Test Estimation, Test Execution and Defect Tracking
• Assisted the QA team in SIT and Business in UAT
• Created test scripts and performed interface, system, functionality, user acceptance testing and regression testing.
• Prepared the Cause and Effect spreadsheet based on the functionality of the application for easy analysis.
• Created various user-defined functions for script enhancements and to verify business logic.
• Utilized Issues Tracking Database for communication with the production personnel, developers and team members.
• Worked closely with software developers to isolate, track, and troubleshoot defects.
• Attended reviews and walkthroughs to better understand the requirement documents.

Prudential Securities
Financial Analyst (1998 – 2001)

Responsibilities:

• Handled diversified Accounts Payable/Receivable and Expense Control procedures including bank and account reconciliations, cash receipts, disbursements and preparation of daily bank deposits.
• Performed accounting and reporting functions as well as weekly payroll processes for salaried employees and monitored payroll taxes for accuracy and on-time payments.
• Handled diversified finance charges, billings, invoicing, purchase order/inventory verification, charge-backs, rebates, and preparation of daily bank deposits.
• Collaborated extensively with external auditors, providing in-depth assistance with periodic corporate audits.
• Prepared, analyzed and communicated key expenses, headcount and production reports, as assigned.
• Performed thorough credit analysis, researched financial histories, and reviewed account status.
• Researched account transactions, demonstrated a keen ability to recognize and resolve discrepancies.
• Followed through on timely and accurate month-end closings and financial reporting activities.
• Prepared some financial statements utilizing the SAP Finance Module.
• Established and maintained Human Resources-related employee files reflecting salary increases, deductions, garnishments; benefits; payroll exceptions and W-2 withholdings exercising a high level of confidentiality.
• Responsible for billing and clearing various intercompany account balances.
• Determined the accounting procedures necessary to adopt new regulations or standards.
• Performed reconciliation and analysis for general ledger accounts with the help of pivot tables.

Environment: - SAP ERP, MS Office, MS Visio, SAP , eRooms, TFS, QC , QTP, SQL

Business System Analyst Blue Bell, PA July 1997 – Aug 1998
Aetna offers a broad range of traditional and consumer-directed health insurance products and related services, including medical, pharmacy, dental, behavioral health, voluntary plans, group life and disability plans and medical management capabilities and health care management services for Medicaid plans. Our customers include employer groups, individuals, college students, part-time and hourly workers, health plans, governmental units, government-sponsored plans, labor groups and expatriates.

Responsibilities:

• Developed the prototype for Security Access Tracking System(SATS)
• Developed Templates to gather the requirements for applications to be added in SATS
• Facilitated the meetings with Business to gather the requirements
• Prepare the on boarding documentation
• Coordinated the deployment of Applications in SATS
• Collected the queries from Access System On boarding (ASO) and resolved the tickets making necessary changes
• Created business process workflow diagrams (Activity diagrams) in MS Visio
• Developed prototype of new information processing application. Facilitated collection of functional requirements from system users
• Worked as an Interface between the users and the different teams involved in the application development for the better understanding of the business and IT processes
• Made sure that the Approval process in place when there is a deployment in SATS
• Followed a structured approach to organize requirements into logical groupings of essential business processes, business rules, information needs and insured that critical requirements are not missed
• Involved in planning, execution, coordination of entire testing (QA) life cycle
• Developed strategies for Test Planning, Test Case Designing, Test Scheduling, Test Estimation, Test Execution and Defect Tracking
• Assisted the QA team in SIT and Business in UAT

Environment: RUP, Java, SQL 2003, MS Visio, MS Office, Crystal Reports