SUMMARY:

• Sr. Business Analyst with over 7+ years of experience in the field of Finance, Healthcare, Banking and Mortgage domains.
• Experience with Fixed Income and Interest Rate Derivatives, Syndicated Loans.
• Asset classes covered include Interest Rate Swaps, Credit Default Swaps, Foreign Exchange Swaps and Equity options.
• Excellent knowledge of HIPAA (Health Insurance Portability and Accountability Act) transaction codes such as 270/271 (inquire/response health care benefits), 276/277 (claim status), 470 (benefit codes), 835 (payment or remittance advice), 837 (health care claim) and 834 (benefit enrollment).
• Experience in gathering user requirements, preparing and analyzing bothBusiness Requirement Documents (BRD) and Functional Requirement Documents (FRD), and proposing changes for process improvement with use of the various internal and external requirements gathered.
• In - depth knowledge and experience in Software Development Life Cycle (SDLC) Methodologies for Waterfall, Spiral, Agile/SCRUM and Rational Unified Process (RUP).
• Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups and Conflict Management with Project team members.
• Extensive experience in developing Use Cases, creating Screen Mockups, conducting Gap Analysis and Impact Analysis, SWOT analysis, PESTLE, MOST, Cost Benefit Analysis, Risk Analysis.
• Technical hands on experience with Business Objects XI R3/R2/6.5 (BO), Central Management Console (CMC), Universe Designer, Web- Intelligence XI/6.0 (WebI), Crystal Reports XIR2/10/9/8 and Crystal Xcelsius.
• Extensive knowledge in RDBMS, Data Warehousing, OLAP and OLTP. Proficient in creation of source to target data mapping documents in a data warehouse environment and execution of SQL queries in a data warehouse environment.
• Experience with building reports-SSRS, Cognos, Crystal Reports, dashboards for analytics - Performance Point Services, Pentaho, Geo-analytics-ESRI and collaborative team sites (using Microsoft SharePoint Server 2010).
• Extensive experience developing SharePoint solutions customizing XSLT Web Parts, JQuery, JavaScript.
• Extensively used Rational Requisite Pro to gather and manage requirements. Created and managed project templates, use case templates, requirement types and tractability matrix in Requisite Pro.
• Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams.
• Involved in Test Planning, Test Preparation, Test Execution, Issue Resolution and Reports.
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases.
• Strong working experience of MS Visio, MS Projects and MS Office (Word, Excel, PowerPoint) tools.

TECHNICAL SKILLS:

Operating Systems: Microsoft Windows 8/7/XP/NT, Unix, Linux (Ubuntu), Windows Server 2003/2008

SDLC Methodologies: Agile, Waterfall, Spiral, RUP and Prototyping

Internet Languages/ Web Applications: UML, HTML, CSS, XML

Databases and Tools: SQL Server 2005/2008/2012 , Distributed DB, Oracle 9i/10/11g, MS Access, My SQL, PL/SQL, TOAD

Quality Management: IBM Rational Manual Tester, Quality Center, QTP, JIRA

Project Management: Microsoft Project Professional

Change Management: Rational Clear Quest 7.1, Requisite Pro v7.1

Languages: C/C++, Java, Shell Scripting, Python, VB.Net, JavaScript, PHP, Perl, ASP.NET, C#.NET, J2EE

Version Control: Rational Clear Case, Rational Rose, Rational Requisite Pro

Business Objects: BO EnterpriseXI 4.0/ XI 3.1 / XI R2, Universe Designer XI3.1

Business Intelligence / Reporting: SQL Server Reporting Services (SSRS), Performance Point Services, Doors.

Content Management System: Microsoft SharePoint Server 2007/2010/2013 , SharePoint 2013/2010, SharePoint Designer 2013/2010/2007

Others: MS Office Suite (Word, Excel, PowerPoint, Visio)

PROFESSIONAL EXPERIENCE:

Confidential, San Antonio, TX

Sr. Business Analyst

Responsibilities:

• Analyzed consumer surveys and gave technical inputs in Business meetings.
• Actively participated in the resolution of Production Report issues and also the gathering and analysis of ever changing Reporting Requirements of users
• Involved in the meeting with business and marketing team for requirements gathering in definition stage.
• Gathered the reporting requirements of the Trade Position Reporting for various Secured and Unsecured Financial Products including derivatives like Equity Swaps, FX Forwards, Currency Swaps, Interest Rate Options, and Forward Rate Agreements (FRA) and formulated the Business Rules for the same in the Oracle Data Warehouse with Crystal Reports as the front end reporting tool
• Ensured IT security and SOX Compliance requirements are implemented in New Systems, Enhancements and Upgrades
• Asset classes covered include Interest Rate Swaps, Credit Default Swaps, Foreign exchange swaps, and Equity options.
• Gathered the Requirements, Develop Process Model and detailed Business Policies and modified the business requirement document.
• Worked as a Liaison between Trading and Debt Capital markets to execute Syndicated loans
• Created narrative Risk Manuals and flow charts identifying internal risks to Investors Bank and Trust for Global Treasury/Global Treasury Operations.
• Monitored compliance of Global Treasury/Global Treasury Operations desks (Asset Liability Management, Broker/Dealer, Foreign Exchange, Investment Portfolio, Money Desk, Securities Lending and Wire Room Operations) with regulatory and internal requirements.
• Assisted with integration of former Investors Bank and Trust Institutional Custody Department into Wealth Management Services.
• As a SharePoint Analyst, Designed and implemented Data Grid Web parts to display data from SQL Server 2012 database utilizing Business Data Catalog features.
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Project.
• Assisted with preparation for internal audits, and Federal Reserve Board audits.
• Provided Anti-Money Laundering review of State Street/Investors Bank and Trust clients.
• Ability to organize, document and track changes and defects using the Rational Clear Quest and archive change request in Clear Case.
• Implemented complex views, procedures, functions, packages and triggers in PL/SQL.
• Performed Data Validation of the data flow from the front-end to the back-end using SQL to perform the Back-end testing on the database.
• Facilitated negotiations with clients (other arrangers) for the finalization of syndicated facilities (conditions, term sheet, covenants).
• Ensured that relevant UML diagrams and Tools (Rose, Requisite Pro) were used in all requirement documents e.g. Business Requirements, Functional Specifications.
• Facilitated the Customer in defining the high-level Functional Requirements and needs.
• Documented approved change controls to add them into business design.

Environment: RUP, Microsoft Windows 8, C#.NET, J2EE, Java, Oracle 11g, PL/SQL, MY SQL, SQL Server 2012, SQL Server Reporting Services (SSRS), Rational Clear Case, Rational Clear Quest, Rational Rose, Rational Requisite Pro, SharePoint 2013, SharePoint Designer 2013,UML, Microsoft Project Professional, MS Office Suite (Word, Excel, PowerPoint, Visio).

Confidential, Fort Myers, FL

Sr. Business Analyst

Responsibilities:

• Responsible for requirement and design documentation review, identification of Customer Management software anomalies and test results, customer interaction, and IT management.
• Worked intensively with project team to create an ongoing process flow for client data assessment during the migration of original legacy to new system.
• Requirement Document (BRD) and obtaining sign-off from the client on specifications.
• Involved in the Preparation of the Project plan and scope document by using MS Project to baseline deliverables, schedule tasks, duration and assign resources.
• Gathered requirements and met with state SME’s for current SharePoint sites to support Managed Health Care.
• Manageddaily aspects of multiple projects including, processes definition, goal documentation, facilitating meetings, gatheringbusiness requirements, issue management, user acceptance testing, vendor management and project team deliverables.
• Collaborated with Lead QA and BI developer to create tools for data analysis and data assessment, and to monitor and schedule routine jobs on server.
• Worked closely with the client to customize various workflow tools to streamline operations and management of various projects, improve performance and in corporate the variousphases of SDLC in to the workflow.
• Excellent knowledge ofHealth Insurance Portabilityand Accountability Act(HIPAA) transaction and code set rules such asEDI 837,270,271,276,277,834,835.
• Developed data standards, data exchange, XML data standard or data sharing model.
• Provide technical XML consulting services to the management and support staff.
• FacilitatedJADsessions with ResearchAnalystand SME's to identifybusinessrules and requirementsand documentthem in a format that can be reviewed and understood by bothbusinessand technical people.
• Created Out of the Box SharePoint Team sites, created Dashboard look for the home.aspx page.
• Interfaced with development team to draft Use Cases and define more detailed specifications.
• Assisted in Cost/Benefit analysis including the ROI,Management Reports usingBusinessObject XI.
• Conducted review meetings with the offshore development and testing teams to ensure that the functionality of the application meets the expected results and is in accord with the requirements.

Environment: Microsoft Windows 7, C#.NET, ASP.NET, J2EE, Java, Oracle 10g, PL/SQL, MY SQL, SQL Server 2008, SQL Server Reporting Services (SSRS), Rational Clear Case, Rational Clear Quest, Rational Rose, Rational Requisite Pro, SharePoint 2010, UML, Business Object XI, Microsoft Project Professional, MS Office Suite (Word, Excel, PowerPoint, Visio)

Confidential, Winter Park, FL

Sr. Business Analyst

Responsibilities:

• Responsible for defining and designing commercial lending loan approval process which resulted in data collection and analysis compliance.
• Excellent in Trade risk experience (Futures, Commodities, Currencies, Equity, and Stocks etc.)
• Created analytical models that estimate future credit risk and losses at the account level for all existing and prospective loan products.
• Coordinated team in bringing about Business Requirements, Architectural Specifications, Corporate Priorities, and Functional Specifications in order to maintain the Requirement Traceability Matrix.
• Created folders in SharePoint and appropriate access to team members and SME‘s to review the documents (FSD, BRD, TRD, and Process flow diagrams.)
• Used MS Project and assisted project manager in making a Project Plan with necessary modifications.
• Responsible for collaboration of the project documents including BRD, FSD, System Architecture, Power point presentations, and review meeting outcomes with the project team using MS Share Point Server 2010
• Processed mapping, data cleansing, data migration, and validation of data table structures in areas of sales, inventory, procurement, production, and distribution.
• Involved in GAP analysis around the identification of business rules, business and system process flows, user administration, requirements, and assumptions.
• Conducted highly interactive JAD sessions with project stakeholders, subject matter experts, users, QA analysts, and project management team for requirement gathering, and identifying and resolving issues.
• Involved in mentoring specific projects in application of the new SDLC based on the Agile, SCRUM, especially from the project management, requirements and architecture perspectives.
• Identified Use cases from the requirements and wrote Use Case Specification (UCS).
• Applied UML to design Use Case Diagrams, Activity Diagrams, and Sequence Diagram.
• Designed and implemented basic SQL queries for QA testing and Report / Data Validation.
• Used HP Quality Center for automated testing. Coordinated with the test team to check the weekly status and report the same to the project manager regarding State Flow Process.

Environment: Agile, SCRUM, Microsoft XP, Oracle 9, SQL, MY SQL, SSRS, SharePoint Server 2010, SQL Server 2008, PL/SQL, SharePoint 2010, C#.Net, Java, J2EE, Microsoft Project Professional, MS Office Suite (Word, Excel, PowerPoint, Visio), Quality Center, QTP, JIRA, UML.

Confidential, Baltimore, MD

Business Analyst

Responsibilities:

• Communicated and collaborated with diverse teamsto understand products and functionalities
• Partnered with key stakeholders (businesses, clients) for requirement gathering. Analyzed business requirements then transformed into functional requirements.
• Identified needs of Business users, Stakeholders and SME by gathering requirements and analyzing various documents.
• Completed result analysis and scope validation and conductedmeetings and presentationsto keep executives and team members apprised of goals and project status
• Saved time and cost incurred at later stages of the project by conducting Formal Technical Review to make sure that the requirements conveyed to developers were understood well before the actual development started.
• Conducted As-Is and To-Be analysis and documented them.
• Led weekly meetings with technical teams to discuss outstanding technical issues and deadlines that had to be met and produced Functional Specifications.
• Resolved open and pending issues by conducting JAD sessions with CRM SMEs, system architects, technical teams and other stakeholders on a regular basis.
• Developeduse case model, detailed use cases and related activity diagrams
• Performed gap analysis to identify enhancement requirements
• Managed change request register. Acted as member of Change Control Board
• Participated in deciding on the design of the enhancements to the website and createdWireframe
• Developed test plan, reviewed test results. Actively communicated with the Project Team intracking, maintaining, closing the defectsarranged and facilitated User Acceptance Tests (UAT)
• Reviewed technical specifications to develop test plans, test objectives, test cases and scripts.

Environment: RUP, Microsoft Windows XP, C#.NET, J2EE, Java, Oracle 11g, PL/SQL, MY SQL, SQL Server 2008, SQL Server Reporting Services (SSRS), Rational Clear Case, Rational Clear Quest, Rational Rose, Rational Requisite Pro, UML, Microsoft Project Professional, MS Office Suite (Word, Excel, PowerPoint, Visio).

Confidential, Mount Laurel, NJ

Business Analyst

Responsibilities:

• Derived Functional Requirement Specifications (FRS) based on User Requirement Specification URS. Understand and articulate business requirements from user interviews and then convert requirements into technical specification.
• Documented the use cases and prepared the use case and activity diagrams using MS Visio and Rational Rose for a clear understanding of the requirements by the development team.
• Liaised with the technology team to derive Functional Requirements.
• Compiled Vision and Scope documents to better define the rationale for the new process
• Created reports for process improvements and trend analysis.
• Conducted Risk Analysis to identify the risks associated with developing the new system, and formulated a Mitigation Plan to eliminate or reduce risks of high severity and major financial effects.
• Assisted in reviewing test plan based on requirements and defect tracking using Quality Center.
• Played a pivotal role in conducting Functional testing, Regression testing, Integration testing, Smoke testing and UAT.
• Managed change requests from stakeholders by conducting extensive Impact assessments to capture the expected consequence of such changes.
• Created bi-monthly Status Reports using MS Excel to keep the Business Lead informed about developments.
• Responsible for creating and updating all documentation for the project, which required interacting with all concerned departments on a regular basis.
• Conducted Defect Validation using Quality Center to screen the illegitimate defects raised by the QA and UAT teams before hitting Development.

Environment: Microsoft Windows XP, C#.NET, J2EE, Java, Oracle 11g, PL/SQL, MY SQL, SQL Server 2008, SQL Server Reporting Services (SSRS), Rational Clear Case, Rational Rose, Rational Requisite Pro, UML, Microsoft Project Professional, MS Office Suite (Word, Excel, PowerPoint, Visio).