PROFESSIONAL SUMMARY

• Over 7 years of experience in Capital Markets, Banking, Financial, Analytics and IT domain.
• Knowledge of analytics and reporting using SAS.
• Experienced in conducting Joint Application Development (JAD) sessions, project meetings, reviews, walkthroughs, and customer interviews.
• Expertise in writing Business Requirements Document (BRD), Functional Specification Document (FSD), Non - Functional Specification Document, System Design Specification, System Use Cases, screen mockups, and training manuals.
• 7+ years of experience in implementing Iterative Software Development Life Cycle (SDLC) methodologies such as Rational Unified Process (RUP) and Agile.
• Expertise in feasibility requirements analysis, design, construction, testing, implementation, and UML methodology.
• Experienced in creating data dictionary having the business definitions of data mapping to map the logical data elements in use cases to physical data elements (record source).
• Proficient at coordinating various technical and managerial teams to develop process and verifying adherence using the Requirements Traceability Matrix (RTM).
• Extensive knowledge of GAAP, financial accounting, investment banking, fixed income products and financial statements.
• Well equipped with excellent communication and organizational skills to face clients.
• Expertise in change request management and developing configuration management documents.
• Experienced in developing test plans, cases, scenarios and strategies as per the business requirements to match the functional requirements and UML diagrams.
• Experienced in SQL queries to extract data from various databases for data analysis.
• Knowledge of capital markets including Fixed Income, OTC derivatives, MBS (Mortgage Back Securities).

TECHNICAL SKILLS

Project Management Tools: Microsoft Office tools - Access, Excel, Outlook, PowerPoint, SharePoint.

SDLC/Design Methodologies: Unified Modeling Language (UML), RUP, Agile, RAD and Waterfall.

Modeling and Design Tools: Microsoft Visio, Adobe CQ.

Languages: VBA, Python, SAS, MySQL, VB .Net, Java.

Other tools: Bloomberg, Crystal reports, Microsoft BI stack - SQL Server, SSAS, SSRS.

PROFESSIONAL EXPERIENCE

Confidential, Irvine, CA

Business Analyst

Responsibilities:

• Gathered Business requirements pertaining to Trade Settlement and Processing.
• Imparting knowledge on trade cycle, trade processing, derivatives.
• Creating and maintaining web content for the trade processing application.
• Translating those requirements into functional specifications and relative test cases.
• Database analytics ( Creating SQL Queries).

Environment/Tools: XML, Unix, JAVA, MS Excel, Microsoft Visio, Visual Studio 2008, SQL.

Confidential, Chicago IL

Senior Business System Analyst

Responsibilities:

• Gathered Business requirements pertaining to Trading, fixed income and derivatives, converted the same into functional requirements by implementing the RUP methodology and authored the same in Business Requirement Document.
• Produced requested reports and ran analytics using SAS.
• Prepared slides using Microsoft PowerPoint and presented them at quarterly quality meetings.
• Manage documents from start to finish, publish reports and share information with others using SharePoint.
• Created process flows and use case diagrams using Microsoft Visio.
• Successfully conducted JAD sessions to gather project requirements and help synchronize the different stakeholders on their objectives in order to provide the developers a clear-cut picture of the project.
• Analyzed Business ReICPquirements and segregated them into high level and low level Use Cases, Activity Diagrams / State Chart Diagrams using Rational Rose according to UML methodology thus defining the Data Process Models.
• Supervised the content design and development of a web portal for reporting, analysis and navigation of financial data.
• Proficient in using content management systems for site navigation and content management.
• Leading discussions with vendors to determine the best methodology for different work streams of the project.
• Developed test plans, test cases and test scripts based on the functional specifications.
• Coordinated and Developed QA activities with team members to support the methodology.

Environment/Tools: HTML, Windows 2003, 2008, XP, MS Excel, Microsoft Visio, Visual Studio 2008, SSAS.

Confidential, Bloomington, IL

Business System Analyst

Responsibilities:

• Understood the existing environment and created Process flow diagrams for the new system.
• Created Prototypes after collecting Report requirements and presented the Prototypes to the team. For example involved in creating reports like Marketing Effectiveness Report, Daily Activity Report.
• Involved in testing of reports, creation of report manuals.
• Analyzed the existing reports to remove redundancy.
• Understood the existing setup and created Data-Mapping documents for Data Migration.
• Worked with data analysts to ensure that the data was properly migrated.
• Assisted in creating Test Plans and Test Scripts and was involved in integration.
• Executed SQL Queries to test the Data Integrity using SSIS.
• Assisted in development of Test Plans and assisted QA team in System testing to ensure the new system satisfy all User requirements.
• Collaborated with project manager in tracking and managing project development process following RUP based SDLC methodologies.

Environment: MS SQL Management Studio, MS SQL Server 2008, Windows XP, Microsoft Visio, SSRS.

Confidential, Chicago, IL

Business System Analyst

Responsibilities:

• Created UseCase models using Rational Rose.
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle.
• Worked extensively through Agile development methodology by dividing the application into iterations.
• Participated and contributed in daily scrums, Sprint meeting and Sprint review meetings.
• Conducted JAD sessions to allow different stakeholders to communicate their perspectives, resolve issues, and reach agreements.
• Was responsible for creating the Requirement Traceability Matrix and scope matrices.
• Executed SQL queries for Data analysis, completeness and accuracy.
• Conducted monthly application review meetings with the operations groups to understand better the impact.
• Requirement gathering, Business Process flow development, and Business Analysis.
• Created Effective Use cases and Integrated High level Use case Scenarios in the Project and identification of Basic/Alternative flows.
• Involved in the UAT for the application process.
• Worked with PM to track projects' performance against baseline plan.
• Created customer training documentation.

Environment: MS-Office, JAD, UML, SSAS, Data Analysis, Credit Risk Management, RUP, SDLC, Use Cases, Quality Center.

Confidential, San Diego, CA

Business System Analyst

Responsibilities:

• Created Use-Cases and Requirements documents to organize the business needs.
• Requirements were gathered through interactions and meetings and periodic walkthroughs with loan analysts, credit analysts and other potential users of the application.
• Conducted Use-Case reviews and identified gaps, leading to improvements/enhancements in the same.
• Created and maintained the Requirements Traceability Matrix (RTM) and scope matrices.
• Ensured Use-Cases were consistent and covered all aspects of the Requirements document.
• Maintained documents and the effect of proposed changes on the project schedule and costs.
• Worked directly with software engineers to ensure clear communications on requirements and defect reports.
• Designed and developed scenarios based on business requirements.
• Followed the RUP methodology for the entire SDLC.

Confidential, Minneapolis, MN

Business/ Quant Analyst

Responsibilities:

• Involved in various application upgrade, modernization, and developed implementation project plans.
• Authored business requirements and functional specification documents utilizing Visio to develop test cases and screen mock-ups.
• Provided status updates, as needed, on existing robust systems within the business unit by tracking activity and maintain log of all events including new requests, upgrades, and any other changes.
• Ensured regulatory compliance and quality by testing new policies, procedures, and systems.
• Initiated effort to develop Python models that pulls data from the company database and Bloomberg using SSIS.
• Designed financial models using programming tools like VB .NET and Crystal reports.
• Maintaining good relations with clients and analyzing their requirements and suggesting proper methods to satisfy their requirements.
• Developing functional and system design specifications for the client understanding their needs.
• Using advanced techniques such as e-commerce and adapting other marketing strategies for the development of the company.
• Giving presentations on weekly basis and preparing documentation for further studies.

Confidential

Data and Quant Analyst

Responsibilities

• Manipulating, cleansing & processing data using Excel, Access and SQL and SAS
• Responsible for loading, extracting and validation of client data.
• Liaising with end-users and 3rd party suppliers.
• Writing MySQL scripts to manipulate data for data loads and extracts
• Performing Portfolio Analytics from complex financial source data.
• Advising on the suitability of methodologies and suggesting improvements.
• Carrying out specified data processing and statistical techniques.
• Supplying qualitative and quantitative data to colleagues & clients.
• Using SAS to extract, transform & load source data from system
• Best Business Analyst award in the year 2008 for implementing innovative ideas and playing a major role in the development of the company.
• Awarded as the best student in the bachelors' degree