SUMMARY:

• Result oriented, customer service - focused Business Analyst, with 7+ years of experience. Organized professional with ability to conceptualize, analyze, and bridge the gap between business and technology. A Business Analyst Professional repeatedly taking new challenges and delivering creditable and impressive results to senior leadership. Committed to excellence, extending to relationship building, inspiring team members and gaining respect of others.
• Technical Writing-Documented information technology specifications capturing the views of organization resources, stakeholders as well as end users.
• Expertise in Business Modeling using MS Visio/ Enterprise Architect/ Rational Rose and proficient in creating Wireframes/ Mock-up Screens for designing prototypes.
• Hands on experience with BABOK and Business Intelligence and Reporting Tools (BIRT).
• Used Project Management Support; Work Breakdown Structures, Task Prioritization & Estimation.
• Extensive experience in UML diagrams like Activity Diagrams, Sequence Diagrams, Use Case Diagrams, Process Work Flow Diagrams, Interaction Diagrams and Class Diagrams.
• Experience in creating High level artefacts like Business Requirements Documents (BRD), Functional Requirement Specifications (FRS), Software Requirement Specifications (SRS) and low level documents.
• Working knowledge of Amazon Web Services (AWS) and Cloud Data Management.
• Developed Test Cases & Test Plans with extensive use of HP ALM & Clear Quest.
• Conducted testing along with the Quality Assurance team and conducted UA Testing.
• Expertise in generating DDL, DML and DRL queries in SQL to retrieve, insert and modify data from target database.
• Experience in designing schemas, creating databases and executing queries using SQL
• Experience in providing ER diagrams (conceptual, logical and physical) and implementing Data Mapping targeting the source and destination.
• Involvement in Data Dimensional Modelling, Data Extraction Transformation Loading (ETL)

TECHNICAL SKILLS:

Methodologies: SDLC, Waterfall, Rational Unified Process (RUP), Agile, SWOT, Change Management.

Modeling & Design Tools: Microsoft Visio, UML, Rational Rose Magic Draw.

Application Packages: BALSAMIC, Visual Source Safe for Documentation Control, MS Visio, CVS, Clear case and Share point (Document Repository).

Defect Tracking Tool: Rational Clear Quest, Bugzilla.

Version Control Tool: Rational Clear Case.

Operating Systems: Windows XP/ Net/ 2000/ 2003, UNIX and MS DOS.Bankware.net

Languages: C++, SQL, PL/SQL, XML, HTML, C++ & JSP.

MSSuite: MS-Office, MS-Excel, MS-Visio, MS-Access, MS Outlook, MS Power-point, MS- Project, Magic Draw.

Testing Tools: Test Director, Quality Center 9.0/ 8.2, Win Runner.

Project Management: Microsoft Project, Microsoft Office Suite, MS SharePoint.

Web Development: XML, HTML, JavaScript, Drupal, Ektron.

Financial Tools: Hyperion Essbase, SAS Enterprise Miner, Bloomberg Terminal, SAP

Other Tools: Advance MS Excel (Pivots, VLOOKUP, VBA and Macros), MS PowerPoint, Tableau, HP ALM.

Reporting tools: JIRA, IBM Cognos, Crystal Reports, Rally.

Statistical Tools: SAS, SPSS, R-Programming.

PROFESSIONAL EXPERIENCE:

Confidential, NYC, NY

Business Analyst

Responsibilities:

• Gained insight about the structure, business model by conducting planning, review and retrospective meetings. Interviewed SME’s from the asset and investment departments and conducted JAR sessions to get a good understanding of the requirements.
• Conducted AS-IS and To-be analysis based of the requirements of the business and developed reports to track KPI’s, identify trends, and monitorthe business and implemented OCR technology.
• Teamed with the DB team, Middle Service team and GUI team on a daily basis throughout the SDLC.
• Provided FRD, BRD, NFRD and developed business rules, use cases, UML diagram and activity diagrams, mock ups and wire frames.
• Provided user stories, acceptance criteria, tracked sprints and velocity of burn down.
• Executed SQL Queries for data analysis, system verification and validation.
• Managed change request and did impact analysis and feasibility study.
• Provided Responsibility traceability matrix and traceabilitymatrix.
• Involved in Alpha and Beta phases of testing in writing test cases and test scenarios with the QA team and developers.

Environment: Java, Agile/scrum, MS Office, Visio, Agile, UML, ETL, Mockup Screens, HP ALM, SQL Server Services and Informatica.

Confidential, NYC, NY

Business Analyst

Responsibilities:

• Worked closely with business units to develop a Business Requirement Document.
• Involved in all phases of the Software Development Life Cycle (SDLC) and acted as the main liaison between corporate business managers and IT division.
• Conducted GAP analysis around the identification of business rules, business and system process.
• Conducted Stakeholder Analysis, Data Analysis, Elicitation, Requirement Analysis, Solution Assessment and Validation.
• Worked on compiling the key elements of protecting any AML activity by keeping proper track of KYC and CIP steps for setting up accounts.
• Utilized the understanding of BCBS -239 concepts for better regulatory application.
• Worked with the test team to develop system integration test scripts and ensure that the testing is done according to a phased plan.
• Forecasted business costs and documenting present scenario budgets for client.
• Work with QA team and provide them details on the UAT and document them efficiently.

Environment: Windows, SQL Server, .NET, MS Visio, Rational Clear Case, Clear Quest, MS Visio and MS Office Suite (Word, Excel, PowerPoint).

Confidential, Charlotte, NC

Business Analyst

Responsibilities:

• Chaired Requirement Gathering Sessions (RGS), Joint Application Development (JAD) sessions and Joint Application Requirement (JAR) sessions.
• Involved in BA Plan, Requirement Scoping, Tracking, and Communicating.
• Conducted Stakeholder Analysis, Data Analysis, Elicitation, Requirement Analysis, Solution Assessment and Validation.
• Been focused on understanding strategic needs of business users to globalize the needs without silo solutions. Work with Risk Managers to understand their reporting needs and build customized reporting solutions for 14A and 14Q templates.
• Worked on Reconciliation Framework to reconciliation the CCAR data to FRY 9C and General Ledger.
• Business Process improvement for CCAR manual submission by automating the deliverable. Performed in depth process re- engineering to automate the solution. Developed process models which was highly appreciated and taken as a standard for all CCAR Work streams.
• Work with Developers and QA team and provide them details on the requirement and collaborate heavily for prototyping.

Environment: Agile, SharePoint, MS Visio, Azure, Informatica, Microsoft Project and Rational CQ.

Confidential, Boston, MA

Business Systems Analyst

Responsibilities:

• Worked with various business and providing them reporting solutions. E.g. Would be reports based on delinquency, write downs, credit exposure, probability of default, FICO. Also generated the Credit Quality Book which was a huge success as initial attempts did not provide end to end solutions.
• Utilized strong understanding in different credit products like Commercial Loans, Leases, Mortgage, Installment Loans, Credit Cards, Student Loans etc.
• Proficient deposit products like Savings and Checking Accounts, IRAs, of Deposits. Deep understanding of systems like COR and TDA.
• Accomplished in Capital Markets and Derivatives like Options, Swaps, Credit Default Swaps, Security. Competent with Source systems like Intrader, Aladin etc.
• Mastered relationship between customers and account, collateral, general Ledger. Able to draw Full circle around account. In depth understanding of Source Systems CIP, CIF etc.
• Designed Presentation Layer of OBIEE for Adhoc Reporting consumption based on subject areas- Credit, Deposit, Capital Market, Customers, etc. which made it easy for users to perform Adhoc Analysis. Strategic vision and design resulted in immense cost saving acclaimed by Management. Learnt to use OBIEE concept of eDim- Enterprise Dimensions.

Environment: Agile, Microsoft Project, Rational Clear Quest, UNIX, MS Excel, SQL Server.

Confidential

Business Analyst

Responsibilities:

• Conducted Group Discussion, Surveys & JAR Sessions within the customer service, marketing and sales, legal underwriting, finance departments to gather requirements.
• Eliciting and documenting requirements for this start up project. Worked with Java developers and other PL/SQL developers to design the solution.
• Written complex PL/SQL code to calculate daily pricing and indexes.
• Designed user friendly screens for a great user experience. These were acclaimed by the users.
• Quickly gained extensive knowledge of Mutual Funds business to recommend a scalable solution.
• Involved in UAT and preparing test cases with testers and created process flows for the end to end design.
• Smooth communicator which helped the business understand the technology and bridge the gap.

Environment: Java, scrum, MS Office Suite, MS Project, Visio, SharePoint 2010, Agile, ETL, Mockup Screens, HP ALM, Rational Requisite Pro, SQL Server Services.