Summary

• An accomplished Sr. Business Analyst with over seven years of IT experience involving the financial industry.
• Comprehensive experience in Project Management, cost/benefit analysis, testing, development of business requirements specifications, and project planning working with project managers and business sponsors.
• Experience with designing and verifying databases on Oracle and SQL Server RDBMS using Entity-Relationship Diagrams ERD .
• Strong experience in Futures and Options Strategies for hedging investments across global market.
• Extensive experience in managing Bank Accounts and Transfer Accounts.
• Excellent understanding of EFT system such as ACH, Fed Wire, BACS, CHIPS, FIX, SMAC, Automated Cash management and Prime Brokerage .Knowledge of Online Banking and the whole Fund Transfer process.
• Extensive knowledge and experienced on contract maintenance.
• Extensive knowledge of IBM and Tandem Mainframe, AS400, and ASP/Client Server
• Designed changes for Mainframe Systems and Web Based Systems
• Expertise in using SAS output delivery system ODS functionality for reporting.
• Expertise with Base SAS procedures such as Proc Contents, Format, Import, Print, Plot, Gplot, Printto, Report, Tabulate, SQL, Summary, Transpose.
• Advanced and exceptional MS Excel skills is the first and foremost Understanding of Microsoft Office applications.
• Advanced in Excel higher level functions and principles, IE: vlookups, at-if, match, data consolidation and qc, graphing
• Fundamentals of Finance accounting, IE: tying out two sets of data, reconciliation to a control number
• Power Point skills at building slides from data
• Familiar with use of share point.
• Extensive experience in building applications to support derivative businesses, e.g. automation in Request for Quote process RFQ , middle office trade booking/capturing, auto-generation of term-sheets/contracts, position keeping, Straight Through Processing.
• Worked with Rational Suite of tools to create requirements documents Requisite Pro , visual data models Rose , manage and track defects Clear Quest .
• Extensive knowledge of standard SDLC methodologies, including RUP, MSF, Prototype and Spiral.
• Solid Experience in developing Scope/Vision Documentation and Project Plan.
• Strong Knowledge of SDLC, RUP methodology, and Project life cycles.
• Solid understanding of Rational Unified Process RUP using Rational Rose, Requisite Pro, Unified Modeling Language UML , Object Modeling Technique OMT , Extreme Programming XP , and Object Oriented Analysis OOA .

TECHNICAL SKILLS:

• Languages and Tools: UML, Rational Rose, RequisitePro, Rational SoDA, Rational Clear Case, Rational Clear Quest, Mercury Test Director, MS Project, MS Visio, MS Office 97 / 2000-3, Outlook 2000, Bloomberg,VBA for Excel, SQL, PL/SQL, Java, J2EE, C , .NET, C /CLI, Adobe Acrobat, PhotoShop, AutoCAD, 3D MAX
• Databases: Oracle 8i/9i, MS SQL Server, MS Access
• Environments: Windows 9x/NT/2000/XP, UNIX Sun Solaris, AIX, HP-UX , Linux
• MainFrame: COBOL, DB2, JCL, CICS, MVS

Professional Experience:

Confidential

Sr. Business Analyst

Fidelity Investments is a group of privately held companies in the financial services industry. Fidelity Investments includes a large family of mutual funds, their distributors and investment advisors, and a retail brokerage, as well as unrelated business. Fidelity Investments is the leader in the 401 K business. The Small Business Sector SBS of Fidelity Investments wanted to start a new Competitive Intelligence CI unit to analyze and strategize the competitors by creating a knowledge base internally in a Microsoft Share Point Intranet My job was to help design the entire Competitive Intelligence Infrastructure for the SBS in Kentucky. I was designated as the Systems Project Manager for the Competitive Intelligence Infrastructure. I had the administrative rights for the development of the Competitive Intelligence Knowledge Base which was designed in the internal Fidelity intranet known as Microsoft Share Point and linked to an existing Knowledge Base

Responsibilities:

• Worked with Project Manager and high-level management team to identify Project Scope, arrange Time Schedule and Budget Estimation
• Experience of working with very large datasets from multiple sources
• Good experience of writing and auditing macros
• Good experience of troubleshooting spreadsheets
• Provide analytical support in designing/creating/developing client deliverables ie: automate a linked Excel / PowerPoint report that include graphs/charts/tables, design creative presentations, proposals using the advanced features of Excel, PowerPoint
• Proofreading and correcting the excel documents and power point slides.
• Need to maintain an ease of use front end on the Excel models for end users in the Partner Line.
• Ability to manage within the monthly cycle and meet timelines o Monthly collect and compile an outgoing portfolio from Portfolio Solutions group.
• Prepare the file to send to the Partner Lines for data collection, post to share point, etc.
• Knowledge microsoft Office applications Fundamentals of Finance accounting
• Conducted User Interviews and Work Shops to gather accurate Business Requirements
• Served as a liaison between the business team and the technical team by identifying, understanding, and documenting their needs
• Worked in mainframe environment and used SQL to query various reporting databases.
• Interacted with line of business managers and coordinated the transition into the security database to assure business compliance with SOX.
• Expertise in development of High level design, Conceptual design, Logical and Physical design for Database, Data warehousing and many Distributed IT systems
• Project Manager in development and documentation of Project Plan
• Comprehensive knowledge of and solid experience in SDLC Methodologies, MSF,RUP, Waterfall, RAD, and XP
• Created .NET Reports which are used to present the data in different views and are effectively consumed using Crystal Reports.
• Tested and verified coverage/s including Rental Reimbursement, Towing, Medical limits, Medical coverage premiums, bodily injuries etc.
• Was involved in meetings with all the stakeholders of Redcats and HP to demonstrate the pros and cons of the HP tool for Redcats application.
• Functionality to include transaction management, position management, realized/unrealized P L, tax lot accounting. System will handle financial instruments traded by hedge funds, including all derivatives.
• Guided development team in the Oracle 9i based database
• Conducted market research and analysis in Capital Markets consisting of Stock Market and Bond Market
• Prepared for GAP Analysis identified and documented improving areas to meet capital requirement regulations.
• Acted as liaison between IT and Business and gathered requirements for Portfolio accounting Security movement and asset control, trade processing free receipts and deliveries Involved in creating Data Flow Diagrams for Database of the Investment Portfolios
• Conducted Data Modeling like Conceptual Design, Logical Design and Physical Design
• Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping
• Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin.

Environment: Rational Suite Rose, Requisite Pro , Dreamweaver, Rational Unified Process RUP , VB.NET, Windows NT/XP/2000, UML, Oracle9i ,UNIX, MS-Project, MS-Office 2000, MS Visio, Casewise Corporate Modeller , WinRunner, Test Director

Confidential

Business Analyst/Data Analysis

Confidential is one of the largest insurance and financial services companies in the world, focusing on domestic property and casualty insurance, life insurance and retirement savings, asset management, and strategic investments. Nationwide currently has about 35,000 employees, and is ranked 98 in the most recent Fortune 100. The Data Warehouse was developed to integrate nationwide operational systems into one central database structure. They can see the product information, usage, and price and reimbursement policy from the application content. Informational queries can be obtained from the Data Warehouse that identifies customer behavior patterns. This customer data helps Nationwide to better understand and respond to customer's needs.

Responsibilities:

• Reviewed and analyzed the business environment and identified process improvements.
• Interacted with Business Users to conduct thorough Requirements Analysis.
• Assisted Project Manager and User managers to conduct Market Research and Feasibility Studies, and to develop Scope/Vision Documents.
• Involved in interactions with the Subject Matter Expert, Project Manager, Developers, and the End-Users.
• Coordinated activities with project manager and various other teams using MS Project.
• Established traceability matrix using Rational Requisite Pro to trace completeness of requirements in different SDLC stages.
• Configured the Data mapping between Oracle and SQL Server
• Designed and developed Project document templates based on SDLC methodology
• Interacted with other Business Analysts for designing and implementation of Use Cases and Test Plans.
• Conducted workflow, process diagram and gap analyses to derive requirements for existing systems enhancements using UML.
• Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin.
• Planned, coordinated, and directed research and facilitated the computer-related activities of the firm using .Net technologies
• Assisted in on-going process improvement efforts to ensure Test Planning, Execution, and Reporting is effective, efficient, standardized, coordinated, and integrated.
• Followed solely RUP methodologies during the course of the project.
• Assisted the Senior Business Analyst in writing Functional Requirement Specifications FRS and User Requirement Specification URS .
• Developed Test Plans and Test Cases according to Business Requirements.
• Provided clear and concise documentation regarding requirements management plans, Functional Requirements, supplemental Requirements, Test Plans and Test Cases.
• Acted as User Acceptance Testing coordinator and monitored business testing and interfaced with the development team regarding defect status and fixes on a daily basis.
• Involved in generation and execution of SQL queries.

Environment: Microsoft Office Suite, MS Visio, Java, C,.NET, Windows NT, JavaScript, UNIX, HTML, Oracle, SQL, Mercury TestDirector, Mercury LoadRunner

Confidential

Business Analyst

• Founded in 1969, Countrywide Financial Corporation is a leading provider of consumer and business-to-business financial services. Countrywide is one of the nation's leading retail mortgage banking companies. They are in the business of making, servicing and selling non-prime loans.
• The client objective was up gradation and maintenance of its Mortgage Application System. The Mortgage product is fully integrated, Web-centric, real-time mortgage servicing solution that automates all mortgage servicing processes from loan origination, credit appraisal, credit enhancement, Escrow management, Foreclosure and payment processing. Our team worked with all the concerned business areas and was responsible for successfully provisioning the project from inception until transition to the bank.

Responsibilities:

• Extensive experience in Conducting Market Research, Feasibility Studies, Data Analyses, System Analyses, Gap Analyses, and Risks Analyses.
• Gathering market data including real time and historical price data, financial data, and trading news using financial data source named Bloomberg.
• Operating SWIFT messaging service for financial messages, such as letters of credits, payments, and securities transactions, between member banks worldwide.
• Responsible for gathering requirements from users in operations group and performing data mapping for the application, confirm and vacillating the requirement at time of BA testing.
• Solid Experience in developing Scope/Vision Documentation and Project Plan, as well as tracking Project Process, and manage resources to ensure successful delivery
• Deep understanding the Business Flow of Investment Banking, and extensively involved in Portfolio management and analyses, Mutual Funds, Securities trading.
• Developed test plans with QA team and helped test every scenario using Mercury TestDirector Tool for system testing
• Evaluation of vendor components for acccounting engine Geneva accounting engine for position management tax lots, also exposure to FTI accounting engine/database data repository Eagle Pace financial data warehouse to ensure technical fit with targeted application and enterprise standards. Deep understanding of Structured System Development Methodologies
• Collaborated with External Auditors and documented SOX compliance requirements
• Assisted Project Management in developing Scope/ Vision Documentation and Project Plan, tracking project process, and developed Risk Mitigation Plan
• Led the development of a training program to train users on a custom web application and a Cognos ad-hoc reporting environment.
• Worked extensively in Data Analysis, Data Reconciliation and Data Mapping for ETL process
• Gained in-depth knowledge and experience in pricing, inventory, procurement, time attendance, barcode, EFT, credit cards, proxy solicitation and handheld wireless technology in mainframe, client/server and web based environments.
• Used SoftTest software with pseudo code to ensure test cases covered all branches of project's code impacting the system. The system is an IBM mainframe based system that contains the master set of customer information used to bill customers.
• Established a RUP Rational Unified Process centric business analysis methodology.
• Solid Experience in Collection, analyses, and documentation of User Requirements, as well as Organizing interviews, User meetings, workshops, JAD sessions and requirement elicitation sessions
• Proficient in creating Use Cases, Use Case Diagrams, Activity Diagrams etc.
• Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models
• Designed and developed Project document templates based on SDLC methodology
• Helped with data modeling and defining the conceptual and logical model of the data warehouse.
• Expertise in development of High level design, Conceptual design, Logical and Physical design for Database, Data warehousing and many Distributed IT systems
• Assisted business users in identifying functional gaps, and developed detailed FSD for the gap
• Developed test plans with QA team and helped to develop test cases for system testing, integration testing and performance testing.
• Conducted UAT to confirm that all derivative products can successfully processed during the trade life cycle

Environment: Windows XP Professional, Oracle9i, SQL, MS Access 2000, MS Excel, Internet Explorer, MS Outlook, RUP, Oracle, UML, Rational Rose, Requisite Pro, Clear Case 2002, Rational Clear Quest 2002, MS Office 2000, MS Visio 2003.

Confidential

Business Analyst/Data Analysis

The task of this project was to build a central repository of historic data warehouse that could support the bank's various reporting and information needs. Data was spread out in multiple and diverse sources in databases located in different regions. The requirement demanded an integrated, unified data pool that was truly subject-oriented, time-variant and nonvolatile.

Responsibilities:

• Extensively worked with SMEs in Formalizing and analyzing Trading Tools and Functions, including Market Order, Limit Order and Daily Trading Volumes
• Worked with SMEs in the analyses of Efficient Frontier, Risk Factors, Alternative Returns and CAPM and P/E Asset Valuation Method.
• Coordinated activities with project manager and various other teams using MS Project
• Reported and analyzed all application defects, user issues and resolution status to the higher manager using Mercury Test Director
• Involved in interactions with the Subject Matter Expert, Project Manager, Developers, and the End-Users.
• Assisted client in development of business requirements, including identification of opportunities for Improvement and Optimization of Business Processes.
• Documenting business requirements for re-engineering the Customer Profile System to accommodate the new employee benefit trust account infrastructure.
• Identifying and establishing retirement plan account identifiers for the Customer Profile System.
• Created Data Stage jobs to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files etc
• Worked with Cognos and micro strategy reporting systems to extract the data for analysis using filters based on the analysis.
• Wrote detailed specifications for various reports generated using Cognos
• Developed and maintained programs in SAS for UNIX in a user support environment.
• Extensive experience with the SAS programming and in data step and with various SAS Procedures in Base SAS and SAS/Stat, including thorough knowledge of SAS Macro.
• Worked extensively with VB.NET, Source Safe, MS SQL in design, re-design, analysis and implementation of a variety of custom programs.
• Maintained on-going technical assistance and provided help desk support to customer's mainframe systems software that included problem determination and resolution
• Identifying and designing new account opening screens to be used for a re-designed front- end system..
• Assisted PM in Developing Project plan and tracking project Process, Scheduling and organizing group meeting, as well as developed Risk Management Plan
• Maintained a close and strong working relationship with teammates, developers, testers and management staff by conducted regular one-to-one sessions and group meetings.
• Prepared High Level Logical Data Models and BRD's Business Requirement Documents supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements.
• Gathered and Documented Business requirements for the Risk/Return Analysis, and Portfolio Optimization and Diversification.
• Developed Business Requirement Documentation, Functional Specification Documentation and High Level Testing Plan.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOAD using UML and Business Process Modeling.
• Conducted and Documented High level System Design
• Prepared both simple and detailed User manuals and assisted training session of the new and improved system.

Environment: Rational Suite Rose, Requisite Pro , Rational Unified Process RUP , Windows NT/XP/2000, UML, UNIX, VB.NET, MS-Project, MS-Office 2000, MS Outlook, MS Access, MS Excel, MS Word, MS Visio, Test Director

Confidential

Business Analyst/Data Analyst

Confidential . provides brokerage and asset management services to its clients. It has over a dozen subsidiaries offering asset management, private client and capital markets and products, including investment banking, broker-dealer and investment advisory services, annuities and insurance. The company manages its own line of Mutual Funds and acts as a market maker for municipal bonds and NASDAQ listed securities.

Responsibilities:

• Analyzed and developed requirements and use cases for account opening maintenance and reporting for New Accounts on Comerica's private banking and trust application, platform service, Integration and Implementation.
• Liaison for Portfolio accounting Security movement and asset control SMAC responsible for trade processing, Free receipts and deliveries.
• Responsible for creating the Business Process Model for the Global New Account Opening utilizing the BPM methodology and notations.
• Responsible for creating the Roles and Responsibilities as part of the New Account Opening project and mapping them to the appropriate business unit that would enable the system to have in built entitlements on routing the appropriate product forms to the appropriate groups and displaying the forms for Approval in their work queues. e.g. Routing the Managed accounts forms to the Managed accounts team, IRA forms to the IRA team and whenever the forms needs to sent to the compliance depending upon the business those would be routed to the appropriate group .
• Prepared Logical Data Models that contains set of Entity Relationship Diagrams and Data Flow Diagrams and supporting documents and descriptions of the Relationships between the data elements to analyze and document the Business Data Requirements.
• Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
• Designed the business requirement collection approach based on the project scope and SDLC methodology.
• Strong knowledge of Centralized data management or Knowledge Management System, scrubbing process components supporting all asset data need on the Comerica's GWM platform involving securities data load from multiple vendors.
• Developed business process models in RUP to document existing and future business processes.
• Collaborated with External Auditors in auditing SOX Accounting Compliance requirements
• Responsible for developing and supporting requirements for service flow of Corporate Actions, Corporate actions response, Currency, Free movement, Mutual Fund Order and execution, Non financial transactions and trading operational processing in Comerica's global wealth management platform.
• Reviewed test results and reported bugs/issues using Mercury Test Director.
• Integrating functionality for multiple components for achieving the ability to send and receive currency/ cash via various EFT electronic funds transfer systems e.g. ACH, Wire, CHAPS.
• Documented Requirements for Activity management, Fixed Income, Asset Management Services, Client portfolio management, Order management system, Performance, Equities, Reconciliation, Transaction capture/Execution and reporting requirements for the user interface.
• Strong knowledge activities involving corporate actions data integration, Entitlement calculation, notification and reconciliations with custodian through SWIFT, management of Tax/ Market claims to be paid or redeemed.
• Developing workflows for system entities, parameter driven processing, data and functional entitlements.
• Responsible for user training and developing documentation for raining guides.

Environment: SQL, MS Outlook, MS Access, MS Excel, MS Word, MS Access 2000, MS Excel, RUP, Oracle, UML, Rational Rose, Requisite Pro, Clear Case 2002, Rational Clear Quest 2002, MS Office 2000, MS Visio 2003.