SUMMARY

• Over 6+ years of experience as a Business System Analyst with the ability to understand and analyze complex business requirements. Have a detailed and thorough understanding of various domains like Mortgage, Banking (BFSI), Finance, and Insurance.
• Experience on both Agile and Waterfall Software development methodology.
• Experience in working with SAS ENTERPRISE GUIDE SOFTWARE for reporting and analytical tasks
• Experienced in requirements gathering, authoring functional and interface specifications documentation, testing, workflow configuration and trade blotter.
• Strong Knowledge of Software Development Life Cycle (SDLC) and project life cycle.
• Wide ranging experience working on IT projects within Investment Banks, Financial services, Insurance, data migration, integrations, separations, upgrades & outsourcing.
• Finance (Investment/Asset/Cash management) experience in trade settlement (foreign & domestic equities, fixed income, term loans, repos and corporate actions), wire transfers, foreign exchange settlement, derivatives, and income relating to dividends & interest.
• Strong subject matter expertise in fixed income asset markets, bond pricing, equities, derivatives, and emerging markets product knowledge across life cycle, trading cycles, money markets, mortgage - backed securities, risk management (interest rate, credit & liquidity risk), portfolio management & corporate action and also good experience in standard treasury instruments (Bills, Notes and Bonds) and have a clear understanding on Debts, Derivatives, Investments and Collateral concepts.
• Accounting experience, reconciliation, GL, amortization, cash flow, control reporting, match funding, financial statement analysis and budgeting.
• Proficient in creating use cases, sequence diagrams, collaboration diagrams, activity diagrams & class diagrams.
• Proven experience working with Technical Teams and Project teams on Microsoft SharePoint (MOSS) 2010 Platform
• Knowledge of industry practices and regulatory expectations as they relate to commissioning, qualification, and validation programs.
• Excellent team player to work in conjunction with testers, developers and other team members in validating and testing complex scenarios in projects and in the maintenance of quality standards in projects.
• Experienced in manual and automated testing for both front-end and backend. Extensively used automated test tools of Mercury like Quality Center, Quick Test Pro, Win Runner, Test Director, Performance and Load Runner Testing.
• Create business requirement documents (BRD), System requirement specification (SRS), use cases, functional requirement documents (FRD), test cases, test reports and other documents requires in software development life cycle (SDLC) and software testing life cycle (STLC).
• Strong knowledge of business intelligence, data warehousing and business architecture.
• Proficient in corporate data confidentiality, release management, requirements gathering and preparing business as well as technical requirements.
• Extensive experience in domains like Mortgage Originations, Capital Markets, Pricing, Investor Delivery, Automated Underwriting Solutions, Third Party Mortgage Oversight Reporting, Mortgage-Backed Securities, Freight - Logistics and Insurance.

TECHNICAL SKILLS

Languages: C, C++, Java, J2EE, SQL, PL/SQL, VBScript

Web Technologies: HTML, CSS, JSP, JavaScript, XML

Database: SQL Server 2008, Oracle 9/10g/11g, DB2

Database Management: SQL Server Management Studio Express 2008, SQL Developer, TOAD, Informatica, Abinto, Teradata

Operating Systems: Windows 2000/XP/Vista/7, UNIX, Linux, Solaris

Productivity Tools: Microsoft Office Suite (Excel - Pivot Tables, Vlookup & Macros, Project, PowerPoint, Word, Visio, FrontPage and Outlook), Microsoft SharePoint 2010, Lotus Notes 6.5, Adobe Acrobat, Bloomberg

Test Management Tools: HP Quality Center 10.0, JIRA, RALLY, MTM, IBM DOORS, Visual Studio Test Manager, TFS, Experitest

Functional Test Tools: QTP 11.0/10.0/9.5 HP Service Test, SOAP UI

Defect Tracking Tools: Quality Center, JIRA, Test Director, Rational Rose

Other Technologies: ERP, CRM, Crystal Reports, OBIEE, Cognos, SAP, SAS, WebSphere

PROFESSIONAL EXPERIENCE

Confidential, Cincinnati, OH

Senior Business System Analyst

Responsibilities:

• Acted as a liaison among the working partners of the project to agree and document global posting business standards (GPS).
• Created multiple Global Posting Rules detailed business requirements documentation as business standards information became available.
• Interviewed Subject Matter Expert’s to record requirements that could be reviewed and understood by management and all other stakeholders.
• Responsible for the mapping of the data from global and domestic platform by using various functions in Excel.
• Carried out regular meetings and walk-throughs with development team members, Project Managers and Quality analysts to better understand the system functionality in order to improve quality.
• Created and managed project templates, use case project templates, requirement types and traceability relationships on SharePoint 2010.
• Facilitated changes to the SharePoint governance policies, procedures and processes.
• Maintained burn down charts, sprint backlog and product backlog sheets; used all SCRUM rituals such as stand-up meeting, sprint planning, sprint review and sprint retrospect.
• Implemented and monitored AML (anti-money laundering) data and information and also created data integrity to enforce data consistency by working with data governance team and data stewards.
• Assisted in the maintenance of corporate data dictionary.
• Contributed to the implementation of Dodd-Frank regulation related enhancement testing.
• Prepare quarterly and semi-annual disclosures for regulatory reporting purposes.
• Reviewed Stored Procedures for reports and wrote test queries against the source system (SQL Server) to match the results with the actual report against the Data mart (Oracle).
• Facilitated with JAD sessions with the management groups, vendors, users and the IT Group for open and pending issues to develop specifications.
• Developed Requirements Traceability Matrix (RTM) to trace each software requirement to test case.

Environment: Windows Server 2008 / Windows 7, IIS, ASP.Net 2.0 and 3.5, JIRA, QC, GUI, UAT WSE 3.0, Web Services, SQL Server 2008, Oracle 11g, MS SharePoint 2010, HP Quality Center, JIRA, Microsoft Test, Experitest, Crystal Reports, Visual Studio, Team foundation Server (TFS).

Confidential, Morristown, NJ

Senior Business System Analyst

Responsibilities:

• Lead a small team for the Legacy system replacement covering end-to-end Mortgage LOS (Loan Origination System) solution framework for all channels ofOrigination involving various business groups.
• Responsible for Business requirements gathering and helping the IT with functional specs.
• Coordinated with systems partners to finalize designs and confirm requirements with Agile methodology.
• Reviewed the Business requirement specification (BRS) documents and prepared the system requirement specification (SRS).
• Comprehensively worked on ETL mapping, analysis and created RFD for technical design.
• Extensively use trillium for data cleansing activities by using different SQL queries.
• Developed SQL scripts and stored procedures to test ETL and data quality as well as correct any data issue (duplicates, transforms, clean data etc.)
• Managed and maintained the coding and configuration requirements on ALM (Application Lifecycle Management).
• Prepared Test Plans in MS Word for Manual Testing, System Testing, Integration Testing, Performance Testing, Regression Testing & reviewed their consistency with the business requirements for EMPOWER LOS a web based application.
• Ensure clients are in compliance with Internal Revenue Service regulatory standards.
• Prepared inter-company reports for regulatory purposes.
• Prepared ad-hoc schedules for regulatory reporting purposes.
• MaintainSharePoint2010 intranet portal for the department. Create custom lists, shared folders, picture libraries, document libraries, and dynamic InfoPath forms.
• UseSharePointDesigner 2010 to make upgrades and enhancements to the intranet portal.ImplementSharePointworkflows to run simple automated tasks. Create InfoPath 2010 forms.
• Generated high quality reports in the form of listing, HTML, RTF and PDF formats using SAS ODS
• Generated Information Maps using Information Map Studio and created Ad-Hoc reports on need basis using SAS Web Report Studio
• Responsible for importing, manipulating and generating weekly and monthly list reports using SAS Enterprise Guide
• Preparation of Requirements Document, AGILE Story cards.
• Using Agile Methodology, the entire project was broken into sub tasks which were performed in parallel.
• Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
• Worked with QA team for designing Test Plan and Test Cases for User Acceptance Testing (UAT) and verified reliability, performance, and fault tolerance issues
• Acted as an internal advocate by taking a ownership of implementation project, worked with the testers and fulfill the commitment to meet the deadlines.
• Defined program and project goals, objectives, products, services, constraints, assumptions, risks and facilitated processes by working with the project team, sponsor, and stakeholders to baseline the scope of the work and enable development of the plan.
• Coordinated with Project Management to make sure all the constraints and goals are achieved right from the initiation phase to closing, also performed risk evaluation, reviewed design and program development, made reports, and make sure that product meet work plan.

Environment: Windows Vista, Linux, AS400, Java, Web Sphere, Web Services, XML, HTML, CVS, ORACLE, SQL Server, TOAD, Putty, Microsoft Test Manager, Visual Studio VMware, HPQC 10, SOAP UI, Cognos, team Foundation Server (TFS), EMPOWER, STMP, MEDB, XML, Workflow Manager, ALM, Informatica, MS SharePoint 2010, Rational Rose, Visio

Confidential, New York, NY

Business System Analyst

Responsibilities:

• Conducted user interviews, gathered requirements and analyzed the requirements using Rational Rose, Requisite Pro - RUP.
• Analyzed Business Requirements performed gap analysis 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.
• Extensively worked on the ETL mappings, analysis and documentation of reports requirements
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
• Interacted with database developers for formulating the ER diagrams and data flow diagrams.
• Undertook back end testing using SQL and wrote queries.
• Held regular JAD meetings with the system architects, developers, database developers, and quality testers during the entire project to assure that the critical as well as the minute details of the project were discussed and issues were resolved beforehand.
• Facilitated smooth transition of the project from the project environment to the live environment.
• Interacted closely with developers and stakeholders to make sure that all the milestones of the different phases of project are accomplished and the project dead line is met.

Environment: Agile Development, Quality Center 10.0, IBM WebSphere, IBM DOORS, DB2, MS-Office, MS-Visio, RUP, UML, UAT, QuickTestPro 8.2, SDLC, Windows XP, OS, SAP, JIRA & SAP, SOAP UI.

Confidential, Mayfield, OH

QA Analyst

Responsibilities:

• Created Source to target data mapping documents identifying key data elements and prepared Data Flow Diagrams
• Involved in generating Test cases for property and casualty Insurances for Different Levels of Business.
• Participated in UAT and worked with Mercury Quality Center for bug and defect tracking.
• Designed and implemented basic SQL queries for QA testing and report / data validation, Streamlining Data Warehouse and ETL models.
• UAT testing performed along with call center managers to make sure that application meets their requirements.
• Responsible for testing the Quote & Online Purchase for both Auto and Home Property Insurance and Business Owners of the customers.
• Reviewed with the QA team to ensure adequate testing is done on the application.
• Authored OQ and PQ test scripts to challenge all regulatory and security requirements.
• Performed workflow analysis toward automated disability claims process. Detailed comparison of two competing proposals, including HR interfaces.
• Analysis of business requirements and system requirements of the client and also for Property and casualty modules.
• Created the Web Publishing configuration using Documented Administrator for publishing content to the website by using Web Cache.
• Created/Reviewed data flow diagram to illustrate where data originates and how data flows within the Enterprise Data warehouse (EDW).

Environment: Quality Center 10.0, MS Office, Visio, RUP, UML, Win Runner, Windows NT, UNIX, J2EE, Java, JSP, EJB, Web sphere. SOAP UI, Oracle, OBIEE, Siebel (CRM).