PROFESSIONAL SUMMARY:

• Experience and expertise in Project Management Standards with certification course in Project Management Standards (PMBOKÒ),
• Full Software Development Life Cycle (SDLC) Implementations, are testimony to the experience and expertise in System Analysis and Design on Web Technology and Client Server Technology following RUP (Rational Unified Process) Methodologies and ICONIX.
• Hands on Expertise on Requirement Gathering, systematic analysis of the requirements, Joint Application Development (JAD) sessions and use of Rational Requisite pro for requirement Management.
• Intensive use of Rational Rose & Visio for UML Diagrams for the Projects Implemented with FrontPage, Visual Interdev, Dreamweaver, flash, Javascript and Mark up languages - HTML, DHTML, XML for Designing Web Based Applications. Requirement gathering and documentation with the help of Activity Diagrams, Deployment Diagrams and Package Diagrams for B2B Portals, which are interactive, Database driven Web Applications.
• Analysis of Business requirements with Use Case Diagrams, Class Diagrams, State Diagrams, Sequence and Collaboration diagrams for Intranet Based Applications Development using backends Oracle, MS Access and MS SQL Server. Writing Test Scripts to make sure the end product is actually according to the requirement of the Clients for Web Based Applications as well as Intranet based applications.
• Experience in Analysis, Design and Implementation of applications based on Risk Assessment of business with Composite Resilience Rating and TVA Ratings of all business locations across the globe. Risk Mitigation by identifying the GAP and implementing the Corrective Action Plan (CAP).
• Familiarity with recommendations from Basel Committee on Banking supervision on IT projects for Credit Risk, Operational Risk and Market Risk in line with Basel I/II and Basel III accords.
• Understanding of Wealth Management, portfolio management, trade automation, compliance monitoring, data aggregation, performance measurement and client reporting.
• Financial Domain Knowledge with different types of investments including bonds/stocks/mutual funds diversified Investment portfolios, structured products and fixed income securities. Understanding of processes in Product Control and Financial Accounting.
• Exposure to regulatory and compliance for IFRS (International Financial Reporting Standards), US GAAP (Generally Accepted Accounting Principals) and SOX Compliance.
• Familiarity with different Financial Markets like Capital Market, Derivative Market, FX Market with financial instruments like Cash Instruments, Derivative instruments, Securities Instruments. Financial Market risk management including Credit Risk/ Probability of Default Risk, Risk Weighted Assets and Value at Risk.
• Implementation of e-Commerce on B2B and B2C web based projects. Familiarity with various advanced payments methods in e-business like e-cash, Digital Cash using Smart Cards and Digital Certificate. Expertise in ERS (E commerce Requirements Specification) Methodology.
• Expertise in requirement gathering and documentation for applications associated with CRM (Customer Relation management), Retail Business Management and collection of Business intelligence for business domains associated with Finance, Healthcare, Insurance, mortgage, Billing, ATM and Banking.
• Experience with Data warehousing concepts of Data Extraction (ETL/ELT), Table Management, Query Management and Data Integrity. Familiarity with Business Intelligence (BI) tools like Crystal Reports.
• Experience in requirements documentation for financial institution with knowledge of Front Office including Sales and Corporate finance, Middle Office for Risk management and Back Office including administration and support.
• Familiarity with Consumer Lending Processes. Experience of billing systems for healthcare with ICD Codes. Knowledge of Prime Brokerage for Hedge Fund. Experience with travel and hospitality industry.
• Expertise in Client On-Boarding processes used before the clients are authorized to use the applications
• Hands on experience with S/W development Methodologies like spiral/ Iterative/ waterfall and Agile Methodology. Worked on RUP Methodology (Rational Unified Process ) and ICONIX including traditional S/W development process.
• Good experience in creation of Business Case, Business Use Case and System Analysis Use Cases for Functional Requirement Specifications and System Design Use cases. Excellent understanding of Change Management Process and Automated Requirement Management application softwares.
• Coordination and active participation in UAT (User Acceptance Testing) for the application including meetings with business for the walkthrough of defects rose during UAT. Expertise in the use of eRooms for discussions on documented test results, screen shots, test steps and update comments.
• Assisting Project Manager in Production Support of multiple applications by addressing the bugs and enhancements raised by business with the help of applications like Virtual Tech Ticket and eTools.
• Experience in Data Migrations from old systems to new systems by performing various data migration activities including Analysis of Source Data Structure, Analysis of Target Data Structure, Field Mapping between Source and Target Data structure, Data Cleansing Activity, Documenting Data Migration Process and Strategy and Data Migration Validation.
• Analysis of existing data of old system for data mapping and to find data elements, data segments and transaction sets for Electronic Data Interchange between systems. Analysis of different file formats and identification of delimiters and positional to extract data elements from the file formats. Support the team for upload of existing data to new system.
• Conducted Load Test of the application by coordinating with Load Test Team to prepare test scripts for automated testing for concurrent users as specified in approved requirements.
• Experience and expertise in Project Management activities starting from Request for Proposals, Vendor evaluation, Vendor Contract and then entire SDLC till application is in production.

TECHNICAL SKILLS:

UML Diagram Tools: Visio and Rational Rose

Requirement Mgmt Tools: Rational Requisite Pro/ Doors/ Caliber RM/ Quality Center

Bug Tracking Tools: Test Director/ Clearquest / Clear case / eRooms

Languages: UML /SQL/PLSQL/ HTML/DHTML/XML/VBScript/ JavaScript

GUI: Visual basic 5.0/ Dev 2000(Forms 4.5& Rep 3.0)

Databases: Oracle 12/MS SQL Server 7.0/MS Access

Connectivity: VBScript & Active Server Pages (ASP) with ODBC

Others: FrontPage/Visual Interdev/Dream weaver/ Flash 5.0/ Advance Excel with Pivots and Vlookup

Reporting Tools: Crystal Reports/ Microtrategy / Axiom /PeopleSoft Reporting

Operating Systems: Windows NT/2000/ Sco UNIX /Novell Netware.

PROFESSIONAL EXPERIENCE:

Confidential, NYC, NY

Sr Business Analyst / Data Analyst

Responsibilities:

• Understand the requirements for various regulatory reports like Y9C/ 031/041/14M/14Q etc by discussions with Finance and Technology stakeholders so relevant information can be used in Data Analysis.
• Review BRDs and FRDs for IHC Reporting and help them to update by providing review comments. Create test cases based on the release and support Testing various Feeds to the IHC Reporting Database.
• Discussions with technology stakeholders to get the data flow within the database and Analyze it as it flows through multiple tables within the database.
• Load data to the playground environment using SQL Queries to be used by the DnA Group across multiple global locations and updated them from time to time using Inner Joins and Outer Joins.
• Intensive use of MS Excel Pivot Tables, Vlookup and SQL loader to create CSV files and load data to excel for the Data Analysis and creation of Analytics Packs.
• Compare balances between Financial Reporting database(SAP) and IHC Reporting database (FDW/AXIOM) and document the delta and reason for the delta on monthly and quarterly basis for each entity of Confidential DBSI, DBNY, DBCI and ASI
• Raise Issues related to Data Reconciliation, Data Granularity, Data Linkage, Data Desegregation and Timings within the Data Analysis Pack created for each entity with various products.
• Publish all the Analytical Pack on the DnA (Data and Architecture Group) Web Page and share it with all the Business and Technology stakeholders
• Track remediation of issues raised in Analytical Packs in each release and run them through the process of Issue closure after testing.
• Supported the full life cycle of the IHC reporting project starting from requirements to development, SIT,UAT and finally production

Environment: Oracle 12/ SQL Developer / Toad / Excel / Power point / VB Script

Confidential, NYC, NY

Lead Business Analyst / Data Analyst

Responsibilities:

• Interaction with business stakeholders to understand the requirements and create formal requirements Deck/user stories in Quality Center
• Based on the priority and complexity of requirements/user stories listed in Quality Center plan for the release after discussion with technology stakeholders.
• Create new FRD or update current FRD based on the scope of release
• Obtain Sign off of final FRDs from business stakeholders after walkthrough of the requirements to the user group.
• Enable Technical Design Document creation by the technology with walkthrough of final FRDs to Technology stakeholders at offshore and on site based on the requirements for the release.
• Support the QA team to create test cases for the release after walkthrough to the team at onshore and offshore.
• Participation in review of Technical Design document to ensure that all the requirements are addressed in the design based on the scope of the release
• During development and SIT, support the technology team by providing clarity on requirements based on queries raised by the team.
• Managing the LOPR project as a Lead Business Analyst along with the team of three Business Analyst by allocating the work and taking updates from time to time to meet the deadlines from time to time for each release.
• Managing Business and Functional requirements for the projects for the complete lifecycle from initiation to implementation
• Conducting JAD sessions, drafting Business Requirements Documents, Functional Specifications and Test Scenarios.
• Creation of Process Flows and UML Use Cases along with textual use cases for Business Requirements and Functional Requirements where applicable.
• Managing the System Integration Testing of applications with testing team and manage the defect tracking till closure.
• Effort estimation and supporting the project managers in various project management activities.
• Supporting the business stakeholders in conducting User Acceptance Testing by helping then to create test scenarios and closure of the bugs during testing cycle.

Environment: SQL Developer, Big Data, Used Visio, Excel, Word, Mockup, Quality Center

Confidential, Philadelphia, PA

Sr. Business Analyst

Responsibilities:

• Interacted with business and technology stakeholders of International Products Group to initiate the project.
• Captured the requirements for enhancements with the help of the process recommended by International Portfolio and Program Management standards
• Created Business and Functional requirements for the International Product Group using recommended Project Initiation Documents and Project Definition Document.
• Conducted meetings with stakeholders for requirements elicitation for the enhancements of various sizes and functional complexity
• Interaction with stakeholders across the globe including senior project sponsors and project team members
• Complex requirements elicitation, analysis and management contribution to the development and implementation of strategic functional architecture
• Interacted with senior business unit managers and direct reports, understanding business needs/concerns and helping them liaise with teams across the firm using excellent written and verbal communication.
• Impact Analysis after understanding the functional and technical impact of any change.
• Conducting JAD sessions, drafting Business Requirements Documents, Functional Specifications and Test Scenarios.
• Creation of Process Flows and UML Use Cases along with textual use cases for Business Requirements and Functional Requirements.
• Walkthrough of Functional Specifications Documents (FSD) to all stakeholders to get sign off.
• Participation in data modeling and Design Specifications Document (DSD) to ensure all functionalities are included in design.
• Walkthrough of Functional Specifications to the QA team to ensure proper test cases and test scripts creation.
• Managing the System Integration Testing of applications with testing team and manage the defect tracking till closure.
• Effort estimation and supporting the project managers in various project management activities.
• Supporting the business stakeholders in conducting User Acceptance Testing by helping then to create test scenarios and closure of the bugs during testing cycle.

Environment: Used Visio, Excel, Word, Mockup, UML

Confidential, Jersey City, NJ

Sr. Business Analyst

Environment: Java, SQL sever, .Net2.2, Visio, MS Project, MS Office, Test Director, Caliber 2008, RDBMS, PL SQL.

Confidential, Warren, NJ

Sr Business Analyst

Environment: SQL sever, .Net2.2, Visio, MS Project, MS Office, eTools and eRooms, RDBMS, PL SQL.

Confidential, Chicago, Illinois

Business Analyst

Environment: Oracle, Java, Windows XP, Visio, MS Project, MS Office

Confidential, Boston, MA

Business Analyst

Environment: Windows NT 4.0, ASP, Visual Basic, XML, Oracle 8i, Rational Tools, MS Office