SUMMARY:

• Business Analyst with more 16 years of proven ability in Information Technology (IT) and business management experience with key emphasis on Investment Banking and Retail Banking, Marketing(CRM), vendor management and Learning Management System. I have proven ability in Data and Business Analysis, ETL, Data Modeling Design & Development, User Acceptance Testing, Management & Implementation of Software Applications using Agile, Waterfall, CMMI and various Development Methodologies. I have 5+ years working in the Agile/Iterative methodology including participation in SCRUM teams and daily SCRUM meetings and have been recognized as a certified SCRUM Master.
• Experience in handling Joint Application Development (JAD) sessions and one - on-one interactions with business to gather business requirements.
• Experience in leading Release breakdown / Fusion sessions for project kick-offs.
• Extensive experience in preparation of User Stories, Functional and Systems Design Specifications (SFS / SDS) documents, across various methodologies.
• Experience in tracking requirements and issues in Rational Requisite Pro and HP Open View.
• Expertise in Investment Banking, Retail Banking, ATM Applications, Internet Banking (Web-Portal) and Insurance sectors.
• Experience in Marketing (CRM) Database using Business Intelligence applications (BI).
• Experience in preparing Data modeling, Data gathering, Data Research & Data Analysis.
• Experience in handling the ETL mapping interfaces using Informatica.
• Proven experience in business interactions and to understand the issues and data challenges.
• Extensive experience in working with off-shore teams and on-site clients.
• Expertise in all phases of Software Development Life Cycle (SDLC) with Agile, Waterfall and CMMI methodologies.
• Experience in Quality Assurance / Performance Testing, Configuration Management with standard system development methodologies.
• Maximize productivity by setting clear expectations and proactively communicating project status, issues and risks to internal stakeholders and top management.
• Draft and distribute project objectives and tasks to the solutions team.
• Negotiate successfully with clients, staff and outside vendors.
• Nurture relationships with project sponsors as well as business and IT executives.
• Craft and disseminate a clear vision by linking projects to the company’s objectives and results.
• Direct and oversee multiple teams on complex projects.
• Ensure integrity and delivery of multiple projects with respect to time, budget, scope, change, risk and resources.
• Assess project issues and identify solutions to meet productivity, quality and customer goals.
• Manage resource allocation across multiple projects including tracking resource bandwidth and forecasting future availability for scheduling new projects.
• Guarantee the attainment of key milestones by proactively tracking metrics and project outputs.
• Apply effective project management methodologies and control techniques.
• Mitigate risk by identifying, escalating and resolving issues across multiple delivery groups and/or projects.
• Conduct planning and operational readiness assessments to provide an effective transition into production.
• Identify, maintain and coordinate the elements that lead to financial success.
• Collaborate with finance team to determine impact and implications of various options and recommend the best course for project delivery.
• Accountable for management of financial risk and opportunities across multiple project phases and delivery groups.
• Facilitate the development of a Cost Benefit Analysis (CBA)
• Worked with project team and key stakeholders to devise best practices and continuous improvement of project delivery across the enterprise.
• Synchronize the efforts of major initiatives involving multiple groups and departments.
• Coach, mentor and motivate junior level PMs and leads.
• Escalate issues and concerns appropriately.
• Offer input and feedback on growth and development opportunities for team members.
• Consider, prioritize and balance the competing needs of diverse stakeholders
• Manage matrix resources and related relationships within each functional area.
• Project Planning and management with Work Based Structure (WBS),
• Project Management sickies on Kanban board and regular Sprint techniques.

TECHNICAL SKILLS:

Business & Data Analysis: Facilitate Joint Application Development (JAD) sessions, create System Functional Specifications (SFS), Use Cases, Gap analysis, Root Cause analysis, design the business rules to handle the data and the functionality, research on production data issues, query database in Data Warehouse, assist in prepare Data Models, develop data capture tools and Data Mapping, code and ETL mapping analysis.

Banking Solutions: Business knowledge of Investment (FPCMS and PWI), and Retail Banking (ATM Solutions and Internet Banking) Solutions, Cards, Solve SE (Point of Sale - POS). Experience in handling Insurance contracts and as well as Marketing and Brokerage data warehouse and BI solutions.

Quality Assurance: Preparation of test cases based on user story boards. Generate the acceptance criteria for each UAT release. Hands on experience in Automated and Manual testing.

Defect Tracking Tools: JIRA, HP Open View, Quality Center, PCTS, Test Director, and Remedy

Methodologies: Extensive experience in Spiral, Waterfall, Agile (Story board), UML, RAD and RUP Methodologies.

Database: Oracle, Teradata, MS-Access and MS-SQL

Languages: C, C++, Java, XML, HTML, Shell Scripts, ASP, CSS, JavaScript, and VBScript.

Software & Tools: Hyperion Intelligence Designer, SAS Enterprise Guide, Informatica, Sybase Power Designer, Oracle SQL Developer, HP Project and Portfolio Management Center, DAG MetaCenter, Rational Rose, Rational Requirements Compose, MS-Office, MS-Visio, Visual Basic 6.0., Dreamweaver 6.0, Lotus Notes, Director 7.0 and Photoshop 6.0.

Configuration Management Tools: Rational Requisite Pro, MS SharePoint, Rational Clear Case and Microsoft Visual Source Safe.

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Data Analyst Lead

Responsibilities:

• Perform the gap analysis of the existing customer identification process.
• Suggest the best and effective way to normalize the customer base, by modifying the summarized database views.
• Ability to work both in Teradata and Oracle environments
• Ability to analyze the data and generate reports using SAS Enterprise Guide
• Ability to learn and use in-house campaign management tool, EZ Target
• Continuous discussions with third party vendors, Epsilon, Acxiom and Creative.
• Weekly dashboard meetings
• Monthly customer forecasts
• Prepare the use cases and Business Requirements Documents and handover the IT development team.

Environment: Oracle, Teradata, SQL Assistant, SAS Enterprise Guide, EZ Target, MS-Visio, MS-Office and Lync

Confidential, Westlake, TX

Senior Business Analyst

Responsibilities:

• Interview the business users of all the 28 systems in gathering the requirements.
• Interaction with the third party vendor (SunGuard) to discuss on the tools (InvestOne)
• Analyze the existing Questionnaires, used by the systems in creating the funds.
• Analysis the gaps between the systems at the lowest data element level.
• Discussion with the development and data modeling teams for the data mining purpose.
• Data modeling and normalization of data for OLTP and OLAP purpose.
• Generate ETL rules for the Informatica development team.
• Informatica ETL design document reviews
• Generate the weekly status reports.
• Prepare the use cases.
• Wire-frame diagrams (proto-type) of the Fund handling (Add, Modify or Delete) screens, which run on the database.
• Prepare User Acceptance Test (UAT) cases and perform UAT.
• Review the requirements and participate in acceptance criteria for all the Development and UAT builds.
• Participate in preparation and review of Test Cases based on data analysis, user case or workflow
• Assist and perform regression testing of all the test cases.
• Raise and track the defects in the tracking system (JIRA)
• Perform both Java UI and Oracle DB quality assurance testing
• Participate in design discussions to provide the QA estimation.

Environment: Java UI, Oracle, PL/SQL Developer, MS-SharePoint, MS-Visio, MS-Office, MS-Project Plan and Lotus Sametime.

Confidential, Dorchester, MA

Senior Business Analyst

Responsibilities:

• Participate in discussion with Originations, Marketing and Analytical team in acquiring their requirements.
• Actively involved in Joint Application Development (JAD) sessions as a Subject Matter Expert, related to Credit Cards.
• Discussion with external vendors like Claritas for Socio-demographic data, Credit Bureaus for Risk Analysis and document the observations.
• Perform the Root Cause Analysis for the requirements and negotiate on the requirements based on the efficiency and the cost involvement for the project, for the given phase.
• Preparing the Systems Design Document involving the details about the proposed systems.
• Preparing the Database Design Document with Logical and Physical data models.
• Participated in discussion related to downstream data mart for Analytical and Campaign Management purpose.
• Connect with the transactional system (OLTP) to acquire the regular feed to provide it to back-office for P & L analytics.
• Participate in video and phone conferences to discuss with systems and development teams which are located in Madrid, Spain.
• Lead and participate in various workshops giving the requirements consolidations and the system designs, to the end users.

Environment: DB2, MS-Office, MS Project Plan, SAS Enterprise Guide, IBM communicator and Mercury Quality Center.

Confidential, Richmond, VA

Senior Data Analyst

Responsibilities:

• Interaction with business in gathering the requirements and preparing the business requirements documentation for the data warehouse changes.
• Creation of ETL (transformation) rules and conditions for the data from various systems into Cards Data Warehouse
• Working in Agile environment and actively participate in daily Scrums for multiple projects (Matrix environment).
• Day-to-day analysis of data using PL/SQL on Teradata analytical (OLAP) and Transactional (OLTP) databases.
• Review requirements, specifications, business processes and recommendations related to proposed solution.
• Interaction with external vendors / applications like TellMe for Interactive Voice Response (IVR) interactions for Credit Card Account Management, TSYS processor for Account Maintenance / Rewards & Balance Transfers (BT) / Core Billing / Transactional data.
• Review and approval of System Requirements, Logical and Physical Data Models.
• Assist the data modeling team and database administrators in implementing the database changes in the data warehouse.
• Maintain the traceability of all the business requirements and work flow the tasks assigned to the team.
• Prepare User Acceptance Testing (UAT) Test Plan, Test Cases and perform UAT for business approval.
• Assist the Data Stewards in updating Data Dictionary / Metadata for the implemented changes in Data Warehouse.
• Assistance in preparing end-user communication for the upcoming changes to the data warehouse.
• Answering business and data questions, providing impact analysis as well as production support for the data warehouse and its data marts.

Environment: Teradata R12, SQL Assistance and MS-Office.

Confidential, Smithfield, RI

ETL Data Analyst / Senior Data Analyst

Responsibilities:

• Liaison between business users and the developers to facilitate the customer relationship and marketing campaigns, which are to be programmed and made available for the usage in Unica and Hyperion Brio Intelligence Designer applications.
• Represent Data analyst team in Joint Application Development (JAD) sessions.
• Communicates with the business to identify needs and evaluate alternative business solutions with project management.
• Interaction with external vendors like Acxiom, IXI for the data which is used for marketing purpose.
• Day-to-day analysis of equities / derivatives trading data using PL/SQL on Oracle database.
• Understand Business Requirements (BRD) and define Data Requirements (DR).
• Develops Functional Specifications (FS) and System Design Specifications (SDS) for client engagements.
• Prepare Process Decomposition Diagrams and Conceptual Data Models using UML.
• Prepare Data models using Sybase Power Designer.
• Preparation of Context Data Flow Diagrams and Normalized Entity Relationship (ER) Diagrams
• Prepare relational and dimensional data models (Data Modeling) with Third Normal Form (3NF) for technical documentation purpose.
• Data mapping and data transformation logic for ETL purposes.
• Maintain the requirements using Rational Requisite Pro.
• Create templates and raise change and incidents using HP Open View (Service Center)
• Project management and time tracking using HP Project and Portfolio Management Center (PPMC)
• Identify and prepare Story Boards and coordinate with development team to follow up till implementation, for the projects which follow Agile (Scrum) methodology.
• Review and edit requirements, specifications, business processes and recommendations related to proposed solution.
• Review and approve Test Plans and Test cases for System Integration Testing.
• Participate in Test Driven Development environment, performing UAT as acceptance criteria for the rapid releases in Agile environment.
• Coordinate with business users in User Acceptance Test Cases for business .
• Maintaining the documentation and version controlling using MS SharePoint.
• Update Data Dictionary in Data Advantage Group’s MetaCenter tool.
• Assistance in the creation of Change / Incident Management tickets for the new/existing applications.
• Coordinated with testing and development teams to ascertain personnel used and work performed both on newly developed application and on various support and research requests.
• Supported business and data questions, maintaining website documentation, providing impact and Root Causal Analysis as well as production support for the data warehouse and its data-marts.

Environment: Hyperion (Brio) Intelligence Designer, UML Sybase Power Designer, Informatica, Oracle SQL Developer, Rational Requisite Pro, HP PPMC, HP Open View, DAG MetaCenter, MS-SharePoint MS-Visio and MS-Office.

Confidential

Senior Data Analyst

Responsibilities:

• Data-mining of the complete legacy applications to under the existing behavior.
• Reverse engineer the existing system which was developed using COBOL and also some modules using C++ (Object Oriented Programming Language)
• Designed the interface inventory-capturing tool for both AS-IS and TO-BE system.
• Database query using PL/SQL and analyze the existing data.
• Preparation of Data Dictionary and Data Requirements Document.
• Preparation of data mapping and transformation logic.
• Analyze the Business Process Model (BPM) diagrams.
• Preparation of Data Dictionary and Data Requirements Document.
• Support the design of Extract Transform and Load (ETL) data hub.
• Review and sign-off the System Requirements Specifications documents.
• Worked in Waterfall lifecycle methodology

Environment: MS-Visio, MS-Office, ASP, MS-Project, COBOL, Teradata and Rational Requisite Pro

Confidential

Senior Business Analyst

Responsibilities:

• Citibank ATM migration project has moved the Legacy (UNIX based) applications to Visual Basic based applications. Migration and Enhancements to the existing internal transfer, external transfer and bill payment applications including bill payments using barcode at ATMs and Check-21 applications.
• Analyze gaps between the AS-IS legacy system and TO-BE system.
• Prepare Business Process Models (BPM) to fit into the Visual Basic 6 designs.
• Participate in & Facilitate Joint Application Development (JAD) meetings.
• Proto-typing the requirements to identify high-level user interface (UI) requirements.
• Preparation and delivery of Functional Requirements Specifications (FRS) using Use Cases.
• Prepare System Requirements Specifications (SRS).
• Process models using UML.
• Data mapping using Business Rules.
• Partner with Business Process / Client Manager to ensure the certified product covers all requirements
• Advise the Project Managers of possible solution alternatives
• Partner with Business Manager to manage test environment and test data.
• Partner with Business Process / Client Manager for ensuring testing fully covers all requirements.
• Verifying system certified products to reflect full coverage from business (client) signed off requirements.
• Ensuring all defects found in the User Acceptance Testing are reported and tracked to the completions by the Product Support Team.

Environment: Rational Clear Case, MS-VISIO, MS-Office, MS-Project, Visual Basic 6.0, SQL Server, XML, UML, Use Cases, Test Director and Dreamweaver 6.0.

Confidential .

Project Lead/ Business System Analyst

Responsibilities:

• Maintenance and enhancement of Legacy ATM applications covering all the modules of financial transactions (Transfer and Bill payments)
• Managed a 7 member development team.
• Handled the quick releases using Rapid Application Development (RAD) methodology.
• Handled traceability of all the requirements till the end.
• Facilitated weekly teleconferences with the client.
• Identified the critical paths using PERT/CPM.
• Work flow analysis of the assigned tasks.
• Review and approve the Test Plans.
• Coordinated with Product Test team till the end of the project.
• Prepared and presented weekly Project Status reports and monthly Quality Facilitator reports.
• Prepared and presented monthly Project Management Review (PMR) to the Delivery Head.
• Code walk-thru of server-side simulation script.

Environment: Windows NT, SUN Solaris, Citi corp proprietary software, Rational Clear Case, Lotus Notes, MS-Office, MS-Project, Visual Basic 6.0 and PCTS.

Confidential .

Product Tester / Quality Analyst

Environment: Windows NT, Test Director, PCTS, Lotus Notes, DIT Tracking System, Visual Basic 6.0 and MS-Access.

Responsibilities:

• Initial launch of Citibank Retail banking applications (Accounts Summary, Internal and External Transfer and Bill Payments) on Internet for Central Eastern Europe and Middle countries.
• Build & Integrate of the modules.
• Sanity Test of software releases.
• Deployed UAT and Production Server for Internet Banking.
• Tracked the software upgrade.
• Track the resources on the project.
• Work flow analysis and traceability of the business requirement.
• Trouble shooting of issues from System Integration Server & UAT Server located at Singapore.
• Provided personnel support and consultation to the development team.
• Involved in batch processing and in backup management.
• End-to-End coordination of the problems reported by business in their Live Environment
• TCP/IP & X.25 GRN connectivity coordination with Firewall team in New York.

Environment: Windows NT, Rational Clear Case, Python Scripts, Lotus Notes, MS-Office, MS-

Confidential

Developer/ Requirements Analyst

Responsibilities:

• Maintenance and enhancement of Legacy ATM applications covering all the modules of financial transactions (Transfer and Bill payments)
• Analyzed and Designed Euro-Currency Table.
• Analyzed and fixed the issues raised by Product Testing Team.
• Worked in Waterfall methodology lifecycle.
• Designed and Developed transition screens and logic for validations.
• Implementation of Y2K patch in Citibank ATMs.
• Internal Auditing of all the modules and client interactivity.

Environment: Windows NT, SUN Solaris, AGS, Visual Basic 5.0., Lotus Notes, and PCTS.

Confidential

Developer/ Requirements Analyst

Responsibilities:

• Gather the requirements and developed Computer Based Tutorials (CBT)
• Developed various multimedia interactive cartoons, programs and games.

Environment: Windows NT, Macromedia-Director, and Adobe Photoshop.

Confidential

Developer

Responsibilities:

• Designed and developed the employee data tracking.
• Developed a few logical headers in Material Management System module.

Environment: SCO-Unix and C.