SUMMARY

• Over 6+ years of experience as a Business System Analyst with teh ability to understand and analyze complex business requirements. Has a detailed and thorough understanding of various domains like Mortgage, Banking (BFSI), Finance, Insuranceand HealthCare.
• 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 InvestmentBanks, 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 has 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.
• Knowledge of industry practices and regulatory expectations(DOD-Frank) 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 teh 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

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, Cognos, QuickBooks, Empower, SPSS regression analysis, Oracle, Teradata, Informatica, HP Quality Center.

Java/JEE: C, C++, PL/SQL, HTML, XML & VB.

PL/SQL: Microsoft SQL server, MS Access, SQL.Win XP; Win Vista, 2000, Windows 7, UNIX

Software Development: Life Cycle.

Waterfall,: RUP, Agile (Scrum).

HPQC: (HP Quality center), Ab into, Informatica, Cognos and SAP BW, SAS, Oracle SCM, axiom

PROFESSIONAL EXPERIENCE

Business System Analyst

Confidential, NJ

Responsibilities:

• Responsible for owning complete requirements related activities on Dodd Frank Reform Program and related deliverables.
• Reviewed models and studied in detail teh functionality of multiple regulatory reporting models of various departments.
• Developed a complete business test strategy for teh implementation of teh program.
• 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 teh Data Process Models.
• Extensively worked on teh 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 teh ER diagrams and data flow diagrams.
• Undertook back end testing using SQL and wrote queries.
• Held regular JAD meetings with teh system architects, developers, database developers, and quality testers during teh entire project to assure that teh critical as well as teh minute details of teh project were discussed and issues were resolved beforehand.
• Facilitated smooth transition of teh project from teh project environment to teh live environment.
• Interacted closely with developers and stakeholders to make sure that all teh milestones of teh different phases of project are accomplished and teh project dead line is met.

Environment:RUP, UML, Oracle, SQL-PL/SQL, Java, Unix Red-Hat, MS-Office, MS Project, MS Visio. ETL Extract, Axiom.

Senior Business System Analyst

Confidential, MI

Responsibilities:

• Acted as a liaison among teh working partners of teh 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 teh mapping of teh 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 teh system functionality in order to improve quality.
• Created and managed projecttemplates, usecaseprojecttemplates, requirementtypes and traceabilityrelationships on SharePoint2010.
• Facilitated changes to teh 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 teh maintenance of corporate data dictionary.
• Reviewed Stored Procedures for reports and wrote test queries against teh source system (SQL Server) to match teh results with teh actual report against teh Data mart (Oracle).
• Facilitated withJAD sessions with teh management groups, vendors, users and teh IT Group for open and pending issues to develop specifications.
• Developed Requirements Traceability Matrix (RTM) to trace each software requirement to test case.

Environment:MS SharePoint2010, MS Excel, MS Access, MS Visio, MS SharePoint, UML, Oracle, ALM, Windows 7

Senior Business System Analyst

Confidential, VA

Responsibilities:

• Lead a small team for teh 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 halping teh IT with functional specs.
• Coordinated with systems partners to finalize designs and confirm requirements with Agile methodology.
• Reviewed teh Business requirement specification (BRS) documents and prepared teh 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 teh 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 teh business requirements for EMPOWER LOS a web based application.
• MaintainSharePoint2010 intranet portal for teh department. Create custom lists,shared folders, picture libraries,documentlibraries, and dynamicInfoPathforms.
• UseSharePointDesigner2010 to make upgrades and enhancements to teh intranet portal.ImplementSharePointworkflows to run simple automated tasks. Create InfoPath 2010 forms.
• Generated high quality reports in teh 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, teh entire project was broken into sub tasks which were performed in parallel.
• Used Agile Test Methods to provide rapid feedback to teh developers significantly halping 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 teh testers and fulfill teh commitment to meet teh deadlines.
• Defined program and project goals, objectives, products, services, constraints, assumptions, risks and facilitated processes by working with teh project team, sponsor, and stakeholders to baseline teh scope of teh work and enable development of teh plan.
• Coordinated with Project Management to make sure all teh constraints and goals are achieved right from teh initiation phase to closing, also performed risk evaluation, reviewed design and program development, made reports, and make sure that product meet work plan.

Environment:EMPOWER, STMP, MEDB,XML, Workflow Manager, ALM,Informatica, Data warehouse, MS SharePoint2010, Rational Rose, Visio, Windows,Oracle, Toad and Microsoft Excel

Senior Business Analyst

Confidential, MD

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.
• Conducted routing Internal inspections of regulated systems (GMP, GCP, GLP) to assure validation procedures has been followed in compliance with company, divisional and departmental policies and predicated rules.
• Responsible for testing teh Quote & Online Purchase for both Auto and Home Property Insurance and Business Owners of teh customers.
• Reviewed with teh QA team to ensure adequate testing is done on teh 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 teh client and also for Property and casualty modules.
• Created teh Web Publishing configuration using Documented Administrator for publishing content to teh website by using Web Cache.
• Created/Reviewed data flow diagram to illustrate where data originates and how data flows within teh Enterprise Data warehouse (EDW).

Environment:MS Office, Visio, Oracle, RUP, UML, Win Runner, SQL

Business Analyst

Confidential, WI

Responsibilities:

• Documented High Level Logical Data Models and BRD supporting documents containing teh essential business elements, detailed definitions, and descriptions of teh relationships between teh actors to analyze and document business data requirements.
• Created Use-Case diagram, Sequence Diagram and Activity Diagram after accessing teh scope of teh Project and understanding teh business processes.
• Create tasks and update tasks in teh MS Project and Project Management Directory for teh senior management reviews.
• Involved in project management, developing project plans, setting project schedules and milestones, scheduling tasks and activities using MS Project.
• Involved working in Medicare and Medicaid projects.
• Tested different functionality of teh application like Medicaid eligibility data, state available funds program, Medicaid claim processing etc.
• Responsible for testing Medicaid Claims using MMIS.
• Conduct high level requirement walkthrough with Tech Managers to come up with Preliminary Estimates
• Involved in teh full HIPAA compliance lifecycle from GAP analysis, mapping, implementation, and testing for processing of Medicaid Claims. Worked on EDI transactions: 270, 271, 834, 835, and 837 (P.me.D) to identify key data set elements for designated record set. Interacted with Claims, Payments and Enrollment hence analyzing and documenting related business processes.
• Coordinated teh process for users, which analyzed their current business practices, user, needs, and tan used that information to define functional requirements and Request for Proposal (RFP) for a new system.

Environment: MS Office, MS Visio