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.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Sr. Business Analyst

Confidential

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 of Business/State stakeholders
• 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

Confidential

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

Confidential

• 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
• Confidential 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.

Confidential

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 reports and 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

Confidential

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

Confidential

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.

Confidential

Senior Business Analyst

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

Confidential

Senior QA Analyst

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.

Confidential

Financial Analyst

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

Confidential

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