SUMMARY:

• More than 9 years of comprehensive experience in the field of Information Technology as Business Analyst, Quality Analyst& Data Analyst covering areas like Project Management, Business Process Design, Object Oriented Analysis and Design, System verification and validation in diverse fields such as Finance, Trading, Insurance, Retail Banking and Investment Management. Strong understanding of capital market instruments.
• Skillful in New Product Development (NPD) and its process involving Product Design and Market Research.
• Proficient in authoring Requirement Documents (BRD) (FRD) (SRD), Requirement Traceability Matrix (RTM), System Requirement Specifications (SRS) and identifying interfaces and business process specifications.
• Experienced in creating Use Case Diagrams, Activity Diagrams, Business Process Models, Work Flow Diagrams, Data Flow Diagrams, Flow Diagrams (Business and Navigation), Sequence Diagrams, Process Flows (Business and System) using Unified Modeling Language (UML) and Rational Unified Process (RUP) and UML modeling tools such as MS Visio and Rational Rose.
• Sound understanding of Object Oriented Analysis and Design OOAD and proficient in documentation of As - is and To-be business processes.
• Worked on numerous cross platform applications and organized Joint Application Developments (JAD) and Joint Requirement Planning sessions (JRP), Interviews and Workshops, Rapid Application Development (RAD) sessions with end-user/clients/stake holders and the IT group. Also, carried out Project Feasibility Study, Gap Analysis and Risk Analysis.
• Strong experience in working with all phases of SDLC throughout the project life cycle in Rational Unified Process (RUP) environment. Mature understanding of Quality Assurance Methodology relative to SDLC. Also worked towards Sarbanes Oxley Compliance (SOX).
• Knowledge of Commercial Of The Shelf Products (COTS).
• Knowledge in Data warehousing concepts. Experience in implementation of Data warehouse using Star Schema.
• Participated in Data Analysis, Data Conversion, Data Integration and Data Migration.
• Experience in working with Multiple Relational Databases like Oracle, SQL Server, MS Access, XML and Flat Files.
• Advanced experience using SQL server, SQL server management studio, SQL server profiler.
• System/Integration/Load/Regression/User Acceptance Testing (UAT) and Manual testing (GUI Testing, Field Validation Testing, Functionality Testing) of UI and Web Applications. Extensively worked in creating Test Procedures, Test plans,Test cases and reviewing them for quality assurance. Tracking defects and interacting with team members in fixing errors. Worked on both Black box and White box Testing.
• Extensive knowledge of Disaster Recovery Plan and Business Continuity Plan.
• Excellent interpersonal and customer relational Skills. Enthusiastic and a self-starter with a need of minimal inputs.

TECHNICAL SKILLS:

Operating Systems: Windows 95/98/00/XP/NT/Vista, MS Dos, UNIX, OS X

Languages: C, C++, Java, HTML, SQL

Tools: MS Office Suite, MS Project, MS FrontPage, MS PowerPoint, MS Word, MS Excel, MS Visio, Rational Rose, RequisitePro, ClearQuest, MS Outlook, ClearCase, iRise, DOORS, Hummingbird, DataFlux, MS Access, SAP Business Objects 4.0

Testing Tools: QTP, Quality Center, LoadRunner, WinRunner, Test Manager

Reporting Tools: Hyperion, Crystal Reports, Business Objects, Micro Strategy

RDBMS: TOAD, DB2, Oracle, SQL Server, SQL*PLUS

PROFESSIONAL EXPERIENCE:

Confidential, MD

Sr. Business Analyst

Responsibilities:

• Gathered detailed business requirements and identified users’ needs through client meetings and system users’ interview sessions.
• Responsible for the creation of business requirements document and business design documents. As needed, reviewed documentation with stakeholders in a group setting to obtain sign-off and approval.
• Logged all the requirements in Rational Requisite Pro tool for tracing purposes and also prepared Requirement Traceability Matrix document.
• Participated in the Analysis, Design and Development Phases of report development, performance tuning and production rollout for every Web Intelligence (WEBi) report.
• Performed Data Analysis and wrote Data Requirements for Data Warehousing of current and historic data to create the Data Model for the Universe designed for the users to be able to do ad hoc reports.
• Participated in writing requirements for Data Migration from DB2 database to SQL Server for designing the Data Universe on Business Objects.
• Identify data elements from the source systems, performed Data Analysis to come up with Data Cleansing and Integration rules for ETL process.
• Created test plans, test cases, and test scripts for system testing of all the WEBi reports and Data Universe on Rational RQM tool.
• Executed tests by testing all the reports on Business Objects and comparing them to the reports on all the agencies source applications for data comparison.
• Logged defects in Rational RTC tool and conducted weekly status meeting to discuss the defects and status within the team.
• Provided training to the UAT team for the Business Objects tool and helped them in testing the WEBi reports and universe in UAT environment.
• Conducted regression testing by creating ad hoc queries on data universe and comparing its data with source database using SQL queries, to make sure that universe business logic is not affecting the hard coded business logic used behind developing the Web Intelligence reports.
• Participated in gathering the users’ security level of access information for tool access level for different users with different responsibilities.
• Conducted users’ response meeting after the production roll out to gather feedback from users’ of all the agencies on their experience accessing reports on Business Objects tool.
• Created test plans, test cases, and test scripts for system testing of AVS system on Rational RQM tool.
• Executed tests by testing all the functions of the AVS system and comparing them to the requirements document against each requirement.
• Logged defects in Rational RTC tool and conducted weekly status meeting to discuss the defects and status within the team.

Confidential, VA

Business Analyst III

Responsibilities:

• Worked with Project Managers, Senior Management, and other stakeholders to define project goals, scope and define requirements.
• Facilitated and managed meeting sessions with users and SMEs to review business requirement.
• Conducted detailed and comprehensive business analysis by working with other BA’s, IT developers, financial analysts and end-users, in order to identify system and operational requirements and improvements.
• Performed Data Analysis and prepared Data Grid, Data Dictionary and Calculation Catalog documents as supporting documents to the Requirements document.
• Led and guided team to write requirements for future releases of the project as well as requirements management.
• Key liaison between the development team and the business team to churn out any technical issues with respect to requirements as well as technical specifications of the project.
• Used DOORS to document requirements, associated change requests with requirements and connected requirements with Use cases.
• Run Requirements Traceability Matrix (RTM) within DOORS to trace requirements and scope items.
• Analyzed and documented Business Requirements, Functional Requirement and Business Process Models for better understanding of the business process.
• Create the business process model using Microsoft Visio and present it to the SME for validation and getting the sign-offs.
• Track, maintain and update Stakeholders requested enhancements and changes using Rational Clear Quest.
• Wrote Use Cases for the Development team based on the business requirements so that the development team gained a clear understanding of how to implement the system.
• Developed test scenarios and expected results based on the business requirements to completely test the system.
• Helped System Test team to prepare Test Data for testing the system.

Confidential, Hopewell, NJ

Sr. Business Analyst / Data Analyst

Responsibilities:

• Assisted manager with the development of project schedules, project planning and estimating LOE (Level Of Effort).
• Facilitated work sessions, interfaced with clients and assisted them in defining business processes, requirements and possible risks and analyzed the possible technical solutions with team members.
• Facilitated analysis and user needs (use case surveys) with project teams and authored Use Case document (UCD), Technical Specifications and Requirements Traceability Matrix (RTM) with project teams.
• Developed and implemented processes and tools for requirements gathering, analyzing, planning, tracking and delivery using requisite pro.
• Designed and developed project document templates based on system development life cycle.
• Served as a liaison between business users and IT team and Implemented business process analysis, business process modeling and businessprocess re-engineering techniques.
• Performed JRP sessions and developed detailed requirements and preliminary design such as conceptual design for the application and created UML diagrams to clarify the requirements.
• Involved in event management and worked with all levels of client staff in solution definition and coordinated meetings with vendors, application managers, support leads, stakeholders and fixed emergency defects through escalation process.
• Wrote requirements for Data warehousing of all the historic data using Star Schema.
• Created data mapping document for ETL process to merge tables and worked with data modelers in the creation of logical and physical data models and database design using Erwin based on the business rules produced.
• Performed Gap Analysis (“AS IS” - “TO BE”) to derive requirements for existing system enhancements.
• Assisted DBA and developers to identify bottleneck and performance issues and maintained metadata repository.
• Provided technical assistance in identifying, evaluating and developing systems and procedures that are cost effective and met business requirements.
• Performed a major role in the establishment of SOA environment, SOA vision and strategy and successful implementation of applications using SOA.
• Leveraged SOA design principles, web services and best practices in developing the framework.
• Implemented SOA road map that encompasses assessment, governance, design, implementation, testing and monitoring.
• Identified and mapped new data sources for the enterprise data ware house and integrated into existing production batch schedule, identified appropriate dependencies and load/ refresh frequency.
• Executed SQL queries, PL/SQL stored procedures, triggers on back end as a part of data analysis and data validation.
• Involved in uploading and downloading of flat files through FTP.
• Reviewed and created test cases to perform Functional Testing, Security AccessTesting, End-to-End Testing and Regression testing.
• Wrote test plan, organized and conducted User Acceptance Testing with clients and worked as a part of support team.
• Attended change request meetings to document and implement procedures as per changes.
• Created release notes and business continuity plan.

Confidential, McLean, VA

Business Analyst

Responsibilities:

• Reviewed the existing requirements for the current controls and the ERL (BRS).
• Rewrote data movement controls and developed new data movement controls for some of the data elements that impacted the financials.
• Used business analysis skills, to work with others to understand the context of data quality issues.
• Analyzed and communicated the results to business team members in business meaningful and actionable terms
• Provided detailed reports to support cleanup of the data by the business
• Implemented monitoring and notification processes to proactively identify and resolve data quality issues
• Developed summary data quality reports and metrics for management.
• Completed the Business Rule Spreadsheets (BRS) based on input from the business users of the data.
• Responsible for conducting a walkthrough of the business rules when the spreadsheet was completed.
• Verified that the changes to the Business Rules had been reflected in the revised Data Model, and that the model, DDL, and Business Rules were in sync prior to sending the revised DDL (and model) to the DA for implementation in Development.
• Performed data profiling of data from different source data systems to standardize data and understand its content, quality and latent dimensional structure, ideally, using data profiling tools such as DataFlux.
• Involved in metadata management and data analysis using data profiling for the completeness and accuracy of corporate data.
• Developed logical source-to-target data mappings that document the business rules to be executed in the development of ETL data transformation jobs
• Involved in reviewing design documents prepared by the developers and notified the additional details to be added to the document.
• Responsible for developing test cases and unit testing. Used the Rational Suite (ClearQuest, RequisitePro, ClearCase) to trace defects, requirements and test cases.
• Responsible for verifying the User Acceptance Test data and worked with the business users to obtain sign-off of the testing prior to implementation.
• Conducted an overview of the data, conducting any additional training, and providing any necessary mapping documents to the business users.
• Designed and developed DataFlux jobs aimed at comparing data from source and target in order to identify and report data exceptions at the data’s business keys and then at each critical data element when the business key is matching.
• Involved in discussions with the Mainframe technical team regarding extraction of data from mainframes to the DataFlux.

Confidential, New York, NY

Business Analyst

Responsibilities:

• Assisted stakeholders and PMO to create functional requirement documents by identifying functional and non-functional requirements.
• Acted as an interface between Project Managers, Subject Matter Expert’s (SMEs), Developers and QA Team on requirement gathering and change requests for current state legacy application to the future state application.
• Involved in creating and analyzing current state flow diagrams of processes using MS Visio. Thereby, depicting the future state flow diagrams using MS Visio by interviewing various SMEs and feedback from IT solution architects.
• Conducted Requirement gathering sessions with various SMEs located at the different company locations across US related to assigned tasks.
• Managed clients contact management including monitoring and recording interactions and communications through CRM (Customer Relationship Management).
• Involved in documenting Functional Requirements in Functional Requirements Definition Documents (FRD) for Vendor selection, Appraisal, skip tracer and Recovery processes.
• Depicted User Requirements, Change Management, and Dependencies between other assignments within the project as well as other applications interacting with the assigned application and other possible risks.
• Created the future state screen shots in Power Point to represent to the business for final validation and signoff.
• Actively involved in walkthroughs and meetings with Project Team members including other Business analysts assigned within the same application and team lead to discuss related issues.

Prudential Financial, Iselin, NJ

Business Analyst

Responsibilities:

• Interacted with Subject Matter Experts such as Prudential’s Investment Managers, Loan originating Managers, and Process Analysts to gather requirements and goals through interviews, surveys to understand the business process. Conducted a controlled brainstorming sessions with project focus groups.
• Involved in gathering and synthesizing business requirements and translated into functional and non-functional requirements to be used as input to the functional design specifications.
• Designed Use cases, Use case diagrams to present a better view of the system as a whole to the technical team for them to identify the key processes.
• Interacted with technical Architects to identify and analyze the given information, procedures and decision flows and evaluated existing procedures.
• Acted as liaison between the SME’s and the technical teams, handled all scheduling, resource planning and allocation matters, ran all status meetings and compiled reports.
• Extensively worked on Creating User requirement Specifications (URS), Functional Requirement Specifications (FRS), and Business Process Documents and also developed System Requirements.
• Prepared Use Cases, Use Case Scenarios and elaborated those using UML diagrams like Use Case Diagrams, Activity Diagrams, Data Flow Diagrams, Business Process and Data Process Model using MS Visio.
• Facilitated Joint Application Development (JAD) sessions for communicating and managing expectations with SME’s and to understand thoroughly the business process and the interface requirements, which need to be incorporated in the application.
• Performed lot of Customizations, Enhancements, Updates and changing functionalities of web page.
• Created and executed various the Test Cases.
• Worked as a team with Developers and Process Analysts in preparing the requirements, writing workflows, process flows, and Interacted with system developers to resolve questions and discrepancies in BRD.

Confidential, Jersey City, NJ

Business Analyst

Responsibilities:

• Worked as a Senior Business Analyst to support the design and implementation of the financial custom reporting, portfolio accounting, securities lending and corporate actions systems.
• Contributed to the definition of scope, preparation of work plans and definition of business requirements.
• Worked with major business areas, reviewed and assessed information gathered, defined key facts and issues, identified potential problems and facilitated problem resolution for external client reporting.
• Identify data elements from the source systems, performed data analysis to come up with data cleansing and integration rules for the ETL process.
• Extensive experience with SQL Server 2000 and Oracle in analyzing triggers, stored procedures, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Extensively used TOAD and SQL for analysis and mapping of data from EAGLE-STAR for Portfolio accounting at different stages of the ETL process.
• Facilitated and managed meeting sessions with committee of SMEs from various business areas.
• Conducted interviews with key business users to collect requirements and business process information for client reports.
• Prepared the Business Workflow using MS-Visio with input, output, pre/post conditions.
• Performed extensive requirement analysis including data analysis and gap analysis.
• Designed and developed project document templates based on SDLC methodology.
• Comprehensively performed requirement gathering for enterprise reporting system-using RequisitePro.
• Established a business analysis methodology around the RUP (Rational Unified Process).
• Designed, developed and executed Test Cases / Plan for various portfolio accounting & infrastructure upgrade projects.
• Helped the testing team document the system requirements and tested the system developed.
• Designed and executed SQL queries for QA testing and report / data validation.
• Set up definitions and process for test phases including Product test, integration test, system test and user acceptance test (UAT).
• Trained various users, which enabled them to submit, review and approve changes within the document.
• Functioned as the primary liaison between the business line, operations, and technical areas throughout the project cycle.
• Prepared project reports for management and others, assisted project managers in the development of weekly and monthly status reports, documented process flows, policies and procedures.