Senior Business Analyst Resume Samples in Word Format Free Download

Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download

SOFIA SANDIPAM

309 N Maple Avenue, #225 Marlton NJ 08001          l  (781)708-9876           l  sofia@gmail.com                                               

Results-driven, detail-oriented, adaptable and well-qualified Senior Business Analyst with over 8 years experience in areas of business requirements analysis, capital markets, system integration, data mapping, financial modelling, equity and fixed income analysis, securities & capital markets, regulatory reporting, management consulting, corporate banking, retail  banking, documenting functional & system specifications, providing liaison to QA support, test case preparation and strong SQL skills

EXPERIENCE SUMMARY

• Strong subject matter expertise and experience in the domains of Banking, Global Custody, Payables, Receivables, Data metrics, Equity Analysis, Financial Modeling (LBO,DCF Modeling), Trade Finance (Letter of Credit, Bank Guarantee), Securities and Capital Markets, Foreign Exchange, Record Keeping Systems, Corporate Actions, Investment Banking, front, middle and back office banking software.
• Strong banking experience with deep understanding of bank products (FLEXCUBE, B@ncs24 and FINACLE) and processes
• Expertise in Credit Analysis (corporate & retail), analysis of financial statements, performance ratios.
• Strong experience in full System Development Life Cycle (SDLC) - requirements gathering, analysis, design, testing, configuration & change management, and project management.
• Extensive experience in developing Business Requirement Documents (BRD), Functional Requirements Document (FRD), Software Requirements Specification (SRS), Use Case Specification Documents, Product Definition Document (PDD) and Requirements Traceability Matrix (RTM).
• Experience in writing advanced SQL, Test Cases and Test Scenarios, engaged in functional testing process, executing User Acceptance Tests (UAT), and compiling test completion reports
• Monitored project planning and management by documenting and maintaining plans, managing issue logs, developing Project Plan, Work Breakdown Structure using MS Project. Familiar with the Rational Unified Process (RUP) and Agile methodologies.
• Strong communication skills in engaging Project Sponsors, Business stakeholders, subject matter experts and Business Users in gathering the intricate workings of business processes.
• UML Modelling and Analysis: Created Use Case, Activity, Sequence, Data Flow, Business process modelling (BPM) diagrams using Rational Rose, Enterprise Architect and MS Visio.
• Performed Feasibility Analysis, Impact Analysis, Cost/Benefit Analysis, Gap Analysis, Data Analysis/conversion using Oracle e-Business Suite and Risk Analysis for Financial Institutions.
• Facilitated walkthroughs, knowledge transfer and Joint Requirements Planning & JAD sessions.
• Expertise in bid analysis and management, RFI/RFP solutions, pro-active pitches.
• Research oriented (primary and secondary) and has an eye for detailed client requirements.
• Strong SQL skills for data analysis.

PROFESSIONAL EXPERIENCE

Senior Business Analyst (Wipro Technologies) - citi group, nj                                 May 2011-Present

Projects Description:

 De-duplication Logic: Flag duplicate positions by identifying mirror and omnibus accounts of Global Custody accounts to reduce Positions inflation at the Global level by billions of dollars.  The project also classifies accounts as either Global Custody/Global Custody Domestic/ Direct Custody to be used by downstream applications for analytics.

History Reclamation: To migrate Positions data from Jan’09 till date from an archived to an EDW server.

Data Governance Portal: Develop metrics to identify correctness of Warehouse Customer information in the using identifiers using agile methodology.

Client Cube : Develop metrics to gauge drivers ( payables, receivables, assets, liabilities, credit information) and service performance ( transmission rates, surveys, major incidents) for clients

·         Collaborated closely with business owners, cross functional groups, stakeholders of all geographies about the sub-accounts of the Global Custody accounts

·         Gathered, analysed and documented Business and Functional Requirements (BRD and FRD).

·         Data mapping from Source systems and Data Ware House to Data Mart to onboard the data

·         Facilitated sessions for volume requirements, design reviews and periodic sessions for on-going progress.

·         Performed and documented Gap Analysis to determine deltas between existing and proposed systems.

·         Primary interface between the Data Modeler and the DBA teams to create ERDs and database prototypes to be used by the system for data storage and processing.

·         Created process workflow and interaction diagrams, Use Case Diagrams, Activity Diagrams, and Business Process diagram using WUP methodology and modeling tools such as Enterprise Architect and MS Visio        to include all impacted business processes and downstream applications.

·         Facilitated knowledge transfer and review sessions of the FRDs with all application development groups.

·         Developed and executed SQL queries for data verification and backend testing.

Senior Business Analyst (Wipro Technologies) - citi group, nj                            July 2010-Apr 2011

Project Description - Construction of a Pre-Processor to normalize, standardize and map incoming data from the source application to the respective data fields of a tool to calculate the Adjusted Cost basis. The 11 source systems recorded Corporate Actions, Fund accounting, Transactions, Positions etc. for various geographies.

·         Directed gathering and documentation of Business & functional requirements from the stakeholders and the business users for all 11 work streams by facilitating user meetings, researching and resolving issues.

·         Analyzed, rationalized and mapped the incoming corporate actions data from source applications to the Cost Basis calculation tool, in alignment to Economic Stabilization Act.

·         Contributed to the project plan, Work Breakdown Structure using MS Project and maintain RIAD logs.

·         Created and managed Change Control Requests (CCRs) and managed Traceability matrix.

·         Acted as a liaison between users, developers, testers, and implementation specialists; provided functional guidance to programmers to resolve issues.

·         Created and executed test plan, test scenarios and test cases based on the functional requirements.

Sqa lead, Onsite coordinator (Wipro Technologies) –state street, nj            Feb 2010-Jun 2010

Project Description - Record Keeping Systems is a complex portfolio asset management system that records and accounts for all investments in an investment portfolio and interfaces with other systems for data entry and data export.

·         Set up definitions and process for test phases including Product test, integration test, system test and UAT.

·         Led the integration testing, supported the upstream and downstream applications of RKS.

·         Formed detailed UAT and QA test plans, managed system testing and preserving testing documentation.

·         Helped QA analysts and technical heads with troubleshooting and fault resolution.

·         Test Case Preparation and execution of the test cases in advanced SQL with TOAD for Oracle.

Business Analyst (Wipro Technologies) – state street, INDIA                            May 2009-Feb 2010

Projects Description:

eHorizon: The project Multi Manager introduces multi managers to manage portfolios  in a Mutual Fund. It has a parent-child structure and a tree structure to calculate profitability of each manager.

Payables and Receivables: Reconciles Payables and Receivables data of legacy systems to Global module.

Wash Sales: Identifies Wash Sales among purchases & sales made by investors and calculates taxes.

·         Worked closely with business sponsors to gather requirements and conducted functional knowledge sharing sessions with developers and testers.

·         Developed Functional Specific Documents (FRD), project plans, traceability matrices and presentations.

·         Developed Use Cases for end-user requirements and created data for functional testing.

·         Led a team of 15 developers and testers as a part of 3 on-going projects.

·         Developed detailed Testing Framework, Test Scenarios, Test Cases, Testing Traceability Matrices.

·         Led functional testing, system testing, , integration testing and UAT testing

·         Helped QA analysts with functional clarifications and defect resolution.

Associate Consultant – Pre Sales, Wipro Technologies, INDIA                          May 2008-Apr 2009

·         Managed business analysts, business consultants, and technical architects to develop and design solutions for RFIs and RFPs stages of bid management.

·         Researched new developments, functional changes; developed new frameworks to implement projects.

·         Worked closely with and assisted Sales force to strategize client needs and developed effective marketing plans. Prepared and reviewed RFIs/RFPs that involved thorough brain storming sessions to propose a solution based on the Client's current infrastructure and requirements.

·         Developed road map for project delivery and devised risk & mitigation plans.

·         Created Solution Design portal to share knowledge on new technology initiatives, business analysis etc.

·         Designed case studies of projects for pro-active pitches to clients in RFI stages to reach RFP stage.

·         Performed root-cause analysis on earlier unsuccessful bids and developed a solution design framework.

·         Presented and demonstrated case studies to enhance brand awareness among clients of new geographies.

·         Developed mathematical models to identify bottle necks in sales process & performed bench mark analysis.

·         Conducted functional training sessions for developers and technical trainings for business analysts.

Manager, State Bank of India (India’s largest bank)                                       Aug 2005- June 2006

·         Evaluated credit proposals for corporate and personal credit by MPBF method and estimated the net worth.

·         Supervised bank operations, cross selling of products, annual and quarterly reporting, maintenance of ledgers/suspense accounts.

·         Raised the deposits and loans in the rural branch and drove the financial inclusion initiative.

·         Encouraged the rural women to form Self Help Groups and extended credit to them.

·         Successfully migrated Branch data from branch-specific system to Core Banking System.

Manager, Oriental Bank of Commerce, India                                                  June 2002- July 2005

·         Performed credit risk analysis, credit limit & drawing power calculations for corporate clients based on stock statements and assessing the hypothecated stock with frequent visits to the warehouses.

·         Processed the complete lifecycle of Trade Finance -inland Letter of Credit, Bank Guarantee, Bank lien, clearing systems, bill collections and bill payments.

·         Performed checks and devised a process plan to prevent fraud in Letter of Credit, Bank Guarantee, Bills of Payment & Collection process.

·         Developed a comprehensive mathematical model for credit appraisals in niche segments based on financial statements, competitive factors, market research etc.

·         Credit appraisal of Small and Medium Scale Enterprises by analyzing balance sheets, cash flow statements, and key performance ratios.

·         Initiated and presented the idea to develop Credit Analysis – Knowledge acquiring portal to train the employees in effective credit appraisal and thereby reduce the potential defaults.

• Performed the roles of Functional specialist and Project Manager to manage a team of 8 developers and testers to design, implement solution, build, and test and deliver the intranet portal.
• Tracked and resolved issues throughout the development life cycle. Coordinated multiple development groups in order to satisfy client expectations and the project's ultimate goal of federal approval.
• Created both test plans and individual test cases from requirements.

·         Efficiently handled branch responsibilities and prepared quarterly performance statements of the branch.

Mba intern, Dell International Services, India                                                           May 2007- July 2007

·         Designed process mapping for prevention of Credit Card fraud in Australian geography. The process map was implemented successfully which mitigated the risk of processing of fraudulent transactions by 24%.

·         Developed training material for sales representatives to enhance customer experience.

EDUCATIONAL EXPERIENCE

Investment banking institute, ny( financial modeling and valuation training )        Dec 2010 – Jan 2011

·         Performed company valuations utilizing (i) comparable public company analysis, (ii) precedent transactions analysis and (iii) discounted cash flow (DCF) analysis

·         Built fully-integrated financial statements projection model, LBO model, accretion/dilution merger models, including ability to run operational and capital structure sensitivities within models and data tables for sensitivity analysis.

Indian institute of management Calcutta, Kolkata, India                                    June 2006-Apr 2008

·         Management consulting for Indian Railways for first phase of Dedicated Freight Corridors Project of $5Bn.

·         Analysed financial statements of BHEL, ICICI bank, Bajaj auto and calculated performance ratios.

·         Performed Qualitative Market Research through Focus Groups, Interviews, Observations to analyse mobile phone preferences for youth (18 – 30 yrs.).

·         Performed Quantitative Market Research through online questionnaires to assess motorcycle preferences of Hero Honda.

·         Conducted feasibility study to open a branch of Jet Airways in North Eastern part of India.

EDUCATIONAL QUALIFICATION

MBA, Indian Institute of Management Calcutta [Top B-School], India – 2008                                       [GPA 3.4]

B.E in Electronics & Communication, Osmania University, India – 2002                                           [GPA 3.2]

CFA Level 1 Candidate – June 2012

TECHNICAL SKILLS

BUSINESS MODELING TOOLS               :        Rational Rose, Enterprise Suit, Ms-Visio, Enterprise Architect

FAULT TRACKING TOOLS               :         Quality Center

METHODOLOGIES                             :        Rational Unified Process (RUP), Waterfall, Agile methodology

PROGRAMMING LANGUAGES       :        C++, HTML, SQL, UML 2.0

DATABASES                                            :        MS-Access, Oracle, Oracle e-Business Suite

WORKFLOW TOOLS                              :        MS-Project 2002, MS-Office

AWARDS AND ACTIVITIES

·         Member of MBA On-campus recruiting placement committee ( IIM, India)

·      Member of the Editorial Committee, campus annual magazine (Osmania University, India)

·         Volunteered in educating the rural school children, West Bengal, India.

·      University champions in the inter-college cricket championship.

·      Runners-up in the National Marketing Research contest conducted by IIM, Lucknow, INDIA

                              References will be furnished upon request

Download Resume Format