PROFESSIONAL SUMMARY

• 8+ Years of strong experience as Business Analyst, Data Analyst and Assistant Manager, including 4+ Years of experience in working in the biggest bank in the world as a banker that enabled gaining real time knowledge of customer skills and a penchant for customer delight.
• A Professional with Cross Functional understanding and domain expertise of Capital Markets developed through work experience in Equities, Derivatives, Commodities and Forex markets.
• Strong knowledge of financial products including, but not limited to Investment products, loan products, insurance products and Financial Market products from practical exposure and professional education.
• Experience working with Banking, Capital Markets, Insurance, Healthcare and Financial Services.
• Experienced in Business Process Reengineering, new product development, product cross selling and upselling strategies.
• An accomplished liaison among Management, Development team and Business Users for gathering requirements and prioritizing them.
• Had handled gathering and reporting of the KPIs (key process indicators) of the bank branch and relevant products, business and growth at the branch level and regional level, encompassing 65 business units and 6 business verticals.
• Efficient in elicitation techniques like interviewing, questionnaires, brainstorming, focus groups etc.
• Strong Analytical skills to understand the Business process, functionality and requirements and to translate them in to system requirements.
• Experience in walkthroughs with stakeholders and end - users.
• Experienced in writing user manuals/help documents.
• Impeccable work ethics and outstanding organization skills for Strategic Planning, Prioritization and Execution.
• Highly motivated, team player, willing for challenges and oriented towards achieving project quality goals.
• Project Reporting,Project Solution Scope,Feasibility Analysis, Cost &Benefitanalysis, Project Plan and Schedule Preparation.
• Project Coordination,Work Packages and Initial Cost Estimation,Project portfolio maintenance.
• Orientation to customer satisfaction, customer retention and customer delight.
• Identified complex problems and review related information to develop and evaluate options and implement solutions.
• Excellent Knowledge of IIBA BABOK, actively implemented in routine work.
• Working knowledge of Pension and Annuityproducts, Retirementsolutions.
• Proficient with HIPAAclaims validation and verification processes.
• Experience in creating project plans,business processes, BusinessRequirements Documents (BRD’s), Functional Requirement Documents (FRD’s), Business Process Modelling (BPM).
• Working knowledge of ITILService Delivery and Service Support.
• Experience in facilitating and conducting Joint Application Development (JAD) and JAR, interviews, workshops, and requirement elicitation sessions with end-users, clients, stakeholders and development team.
• Managed the release design and deployment within schedule/budget
• Worked with deployment/release methodologies and educate other work stream project managers
• Expertise in conducting User Acceptance Tests (UAT), GAP analysis and Impact analysis to aid in the calculation of the Critical Success Factor (CSF) of the project.
• Experienced in IT project budget analysis, outsourcing strategies, and contract management.
• Expertise using MS Visio, Rational Requisite Pro for modeling and capturingbusiness requirements.
• Experienced in developing project plans using MS Project and MS Share Point, identifying documents, and validating requirements and reengineering process.
• Experienced in writing SQL queries / joins using MS SQL Server and Oracle databases.
• ISA (Information Systems Auditor) certified by the Confidential ltd.
• Certifications in Anti money laundering and stock markets.

TECHNICAL SKILLS

Business Skills: Business Requirement Document (BRD), Business Process Analysis & Design, UML, GAP Analysis, Workflow, Dataflow, Data Modeling, Entity-Relationship Diagrams (ERD), Gap Analysis, Impact Analysis, Strong knowledge in Marketing, JAD session.

Software Packages: MS Office (Word/Excel/Access, PowerPoint), MS Project, MS Outlook, MS Publisher, MS Visio, MS SharePoint 2010, Dream Weaver, MS Visual Studio, Adobe Photoshop, Oracle BPM.

Bug tracking and testing tools: Track-It, Rational ClearQuest 7.0/7.1, Rational Requisite Pro 7.1, Rational Robot 7.0, Bugzilla, JIRA, Win Runner, Load Runner.

Databases: SQL Server 2008, MySQL, MS Access 2000, Oracle.

Methodologies and Processes/Technologies: Agile/Scrum, Rational Unified Process (RUP), SDLC, Waterfall, Storyboards

PROFESSIONAL EXPERIENCE

Confidential

Senior Integration Analyst

Responsibilities:

• The Confidential of Des Moines had acquired the Confidential of Seattle. The project involved the transfer of the balance sheet items from Seattle to Des Moines. The process required the ETL of the items from the SEA native system to the Des Moines native system.
• Interfaced with the Business team, Development team and the testing team to co ordinate the integration process in the various phases from requirements gathering till completion of the integration process.
• Scheduled and participated in meetings for the FHLB Seattle business and technology teams, FHLB Des Moines business and technology teams, the development team and the testing team.
• Raised tickets in JIRA and Track-It for issues and constantly tracking them.
• Co ordinate with testing team in execution of test cases and co ordinating test execution by scheduling the testing during off business hours.
• Creating test cases and follow up with the testing team and the business team to schedule and assign testing scenarios to various counterparts in business and the testing team.
• Validation and testing tracking of scenarios during the mock integration sessions and the Go Live timelines.
• Created SRS for the Accounting process that involved 7 workgroups across Advances, Stocks, Member DDA, Investments, Borrowings, Derivatives, MPPs, MPF - Extra, Cash, Fixed assets, CDs and LOCs.
• Tracking test scenarios for Advances, Stocks, Member DDA, Cash, Fixed Assets, CDs and LOCs.
• Documenting test scenario results as per the requirements laid out by the FHLB Des Moines for the workgroups led by me.
• Creation and maintenance of Conversion checklist items in MS Access db to monitor progress of conversion/migration over the various mocks and the Go Live event.
• Coordinated with the business heads and participated in the scheduling of the Mock and live event timelines crucial to the integration process.
• Performed User Acceptance Testing (UAT).

Environment: JIRA, MS SharePoint, MS Office (MS Word, MS PowerPoint, MS Excel, MS Access), MS Visio, Track-it, Bank Mate, Calypso, SQL, Snagit.

Confidential, IL

Sr. Business Analyst

Responsibilities:

• Interacted with business owners to identify business system needs, proposed solutions for business problems and evaluated alternate methods to increase efficiency of the overall process.
• Analyzed and documented business system requirements and the corresponding impact on business processes.
• Responsible for defining the scope and implementing business rules of the project, as well as gathering business requirements and documentation.
• Responsible for maintaining the minutes of all the requirement gathering sessions.
• Worked as a team with other business analysts to make an object oriented model of the application and create use cases.
• Supported the test team to check the weekly status and report the same to the project manager.
• Extracting the business requirements from the end users by several Requirement Gathering Sessions (RGS) keeping in mind their need for the application, and documenting it for the developers.
• Was Responsible for the creation and approval of the functional specification. Worked as a technical writer working on technical specifications, converting business specifications into technical specifications, quality control, information security, customer manuals and online documentation.
• Translated Business requirements to functional and technical language with the help of Use cases and UML diagrams for developers.
• Worked on server check, reporting and maintaining the smooth functioning of the online project. Worked on complex graphical user interface (GUI) and Web-Based user interface (WUI).
• Carried out forward and backward tracing for verification and validation purposes.
• Provided support to the QA team in User Acceptance Testing.
• Created reports for business analysis purposes using Crystal Reports and Microsoft Excel.

Environment: Rational Requisite Pro, Rational Rose, RUP, UML, SQL, MS Office (MS Word, MS PowerPoint, MS Excel, MS Access)

Confidential, IA

Sr. Business Analyst

Roles and Responsibilities:

• Created Work Breakdown Structure (WBS) using QuickBase Apps.
• Requirement Elicitation.
• Created FRD Functional Requirement Document.
• Created Guideline, Instruction and FAQ document for RC Tool.
• Conducted Focus Groups for Teachers and gathered feedback.
• Conducted Working Sessions for Teachers/Educators.
• Provided Live Support during Live Run of the RC/CC.
• Analyzed Mathematica MPR data Requirements for Roster Confirmation.
• Analyzed previous lesson learned and other artefacts.
• After Live Run analyzed data and created Reports as per customer need.
• Conducted System Testing, Regression Testing and UAT.
• Created Test Plan, Test Cases and executed Testing.
• Provided Production support during live run.

Environment: Agile/Scrum, QuickBase, QuickBase Project Management Tool, MS Office tools (Word, Excel, PowerPoint and Visio), iRise, Wireframe, Google Docs, Ruby on Rails.

Confidential, Rockville, MD

Sr. Business Analyst/Tester

Responsibilities:

• Conducted JAD sessions to identify the future requirements.
• Documented the requirements for the project.
• Prepared SQL queries to identify the lookup data and various fields in the system.
• Worked with the SMEs to identify the key business requirements.
• Provided valuable suggestions during Critical Design Meetings to make application more user friendly for better clinical trials.
• Developed Requirement Traceability Matrix.
• Participated in Critical Application Review meetings in order to ensure that changes requested by the client were incorporated into the product.
• Met with project team weekly to monitor the deadlines of the release and given status updates on the ongoing requirements.
• Created Test Scenario, Test Cases and Test Data to conduct Testing.
• As part of CMMI process regularly updated SharePoint Portal Server.
• HIPAA and HL7 compliance.
• Used IBM Rational RequisitePro for Requirements and defects.
• Used IBM Rational ClearCase as Repository tool.
• Used IBM Rational ClearQuest as Version Control/Change Management Tools.

Environment: Java 1.4, J2EE 1.4, EJB, JSP, Java Swing, PL/SQL, Open Office.org 2.3, Oracle 10g, Documentum, SharePoint Portal Server 2003, SQL Navigator 3, OC4J, MS Office, Windows XP/2003, IBM Rational RequisitePro, IBM Rational ClearQuest, IBM Rational ClearCase.

Confidential, Salem, OR

Sr. Business Analyst

Responsibilities:

• Gathered requirements from stakeholders for provider management and member management.
• Identified and validated business rules and data elements.
• Developed the stakeholder list and created stakeholder assessment matrix to prioritize them. Also worked as a BSA to maintain the relationship between business people and the Programmers
• Developed and maintained a requirements work plan and assessed the performance metrics of the team members.
• Modeled the ‘as-is’ process flow and the ‘to-be’ process flow and analyzed the gap and developed the action steps to fill the gaps.
• Conducted Risk analysis and developed mitigation plans.
• Conducted Impact analysis when there is any change in the requirements and updated the Business Requirements Document (BRD) and Systems Requirements Specification (SRS).
• Worked on Microfocuscobol as an intermediate.
• Propose strategies to implement HIPAA 5010 in the new MMIS system.
• Developed the User Interface (UI) prototypes to capture and validate requirements and spike solutions to the current problem.
• Designing Functional Specifications for the target physical database.
• Facilitated JAD sessions for Requirement Validation with Dept. of Health & Human Services (DHHS) to gather requirements for the new MMIS.
• Developed UAT test cases associated with the functional requirements.
• Maintained a bi-weekly status report for the requirements team and incorporated the same to the PMO status reports send to CMS.
• Analyze different data cross-walks, complicated logic & look ups required by different fields for the source to target transformations.
• Analyze EDI - X12 data elements captured by the existing system to validate it against the data elements required for new system.
• Participated in developing test plan, test scripts, and test scenarios and designed user documentation.
• Worked with legacy team in developing BRD for multiple system change requests and participated in system testing.
• Used Microsoft SharePoint as the version tracking tool for managing the requirements documentation.
• Create monthly/weekly status reports to update the project schedules & deliverable plan.
• Examine the system design deliverables & validating it against the Request for Proposal (RFP).

Environment: MS Office, Windows 2000, .NET, MS Visio, MS SharePoint, TFS, MS Project, MS Visio, SQL, Oracle, SOA, HTML.

Confidential

Business Analyst

Roles & Responsibilities:

• Responsible for preparing Business Requirement Document and then translating into functional specifications.
• Conducted logical data analysis, data modeling and communicated data-related standards.
• Created workflow scenarios, designed new process flows, documented the Business Processes, Various Business Scenarios and activities of the Business from conceptual to procedural level.
• Used the guidelines of the RUP in different iterations and phases of the product life.
• Followed a structured approach to organize Requirements into logical groupings of essential Business Processes, Business Rules, and Information needs that insures any Critical Requirements are not missed
• Conducted JAD sessions with team for understanding and documenting requirements for further additions.
• Followed the UML based methods using Microsoft Visio to create: Use Cases Diagrams, Activity Diagrams, State Chart Diagrams, Sequence Diagrams and Collaboration Diagrams.
• 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.
• Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance Testing.
• Responsible for defect and change management
• Responsible for providing analytical support in the Design, Development and Implementation of Project.

Environment: Rational Enterprise Suite (Rose, RequisitePro, Clear Case, ClearQuest), Visual Basic, SQL, SQL Server, Oracle, C#.Net, WebLogic, DOORS, J2EE, Java, HTML, Windows Forms, Web Forms, Load Runner, Win Runner.

Confidential

Business Analyst/Technical officer

Responsibilities:

• Interacted with the users, designers, developers and project manager to get a better understanding of the business processes and gathered business requirements and documented it for financial services of every day banking activities.
• Analyzed functional requirements, incorporated development and business objectives, and used the information to develop detailed comprehensive test strategies to verify system changes that met the needs of the client
• Performed system and workflow analysis.
• Documented the existing system and verified it with follow-up meetings.
• Business impact analysis of Requirements and Functionality Changes in Capital market solutions Trading (Stocks, Commodities, Forex and Equity derivatives)
• Expertise in capital markets with extensive experience in Equities, Fixed Income Instruments, OTC Credit Derivatives (CDO, CDS, SWAP’s), Interest Rate SWAP, Currency Forwards, ETF’s, Futures, Options, Mutual fund, Forex transactions
• Responsible for product parameter changes for loans & deposits, loan syndication modules.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using MS Visio.
• Wrote test plans, test scripts, test cases and test procedures.
• Performed Manual Testing and UAT
• Conducted JAD sessions with end-users/clients to gather business requirements and translating the same to the development teams.
• Participated in functional walk-through to validate the application design against the test cases written.
• Responsible for setting up the various stored attributes by interacting with the DB admins.
• Gathered data, analyzed and Fulfill the Gap between ERP and Business Rules
• Wrote SQL validation scripts to validate the outputs
• Used Toad to check the database updates of the scripts.
• A separate bug tracking process using HP Quality Center is being used to track bugs periodically. scheduled conference calls with different regions to review the testing status
• Reconciled financial reports.
• Responsible for providing training of different application to user groups
• Used the RUP/SSUP methodology

Environment: SunGard Intellimatch, TOAD, SQL, Mercury Suites, HP Quality Center, ERP- SAP Business Objects XI Rich Client and Web Intelligence, Oracle, MS Share Point, Java, SQL Server, SYBASE, Microsoft Dynamics CRM, MS Visio.

Confidential

Assistant Manager

Responsibilities:

• Spearheaded the Non-performing asset recovery by educating the customers about financial credit history and recovered 35% of the bad loans which were with the top 10 defaulters and also cross sold other products
• Marketed stock market products of the bank like mutual funds and other investment products
• Introduced the usage of macros in the process of retrieving customer information from the core banking platform, that was functional even during off business hours and aided retrieval of an average of around 50 entries per hour compared to the approximate 5 entries in the traditional method
• Handled housing loans for the HNI (High Net worth Individuals, Niche customers) in which the average loan sanctions was around $ 330000 (on 4 proposals) compared to the national average of just $ 50000 (on 3 proposals).
• Fastest processing times and lowest Turnaround time of less than 2 days compared to average ranging 2 weeks to 2 months
• Innovated a standard appraisal technique that reduced processing time across the region drastically
• Averaged 20 minutes for creating loan proposals in the Banking tool compared to peer average of approximate 90 minutes.
• Headed a team to educate customers about the bank’s mobile banking platform that reduced costs per transaction by 99.85% in the new delivery channel (compared to the traditional banking cost for the bank), which was imminent for the bank to offload transaction costs to customers with thinning operating margins.