SUMMARY:

• 8 + years of experience as a Business Analyst/Business System Analyst in industry domains including Mortgage, Financial, Brokerage Accounts, Healthcare, Insurance, Retail Banking, e - Commerce, and Supply Chain.
• Strong understanding of Online Banking, including Credit Card, Mortgage, Account Transactions, Wire Transfers, Bill Payment.
• Strong understanding of financial valuation concepts and various capital market instruments and processes including Equities, Fixed Income, Foreign Exchange, Derivative (OTC) & Back-Office operations.
• Knowledge of Anti-Money Laundering (AML), Bank Secrecy Act (BSA), Comprehensive Capital Analysis and Review (CCAR) and Dodd-Frank Act. Working knowledge and understanding of Suspicious Activity Reporting (SAR), and OFAC reports.
• Experienced in creating Business Requirement Documents, User Requirement Specification, and Functional Requirement Specifications. Experienced in creating Data Flow Diagrams, Use Cases, State Diagrams, Sequence Diagrams, Component Diagrams, Use Case Diagrams & Activity diagrams.
• Good experience in Data Modeling with expertise in creating Star & Snow-Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling using ER/Studio.
• Strong Data Quality Management background performing analysis, monitoring, and tuning to maintain data integrity.
• Experience in creating database tables, writing stored triggers, select statements, joins, views.
• Knowledge of Mortgage Loan Origination, Servicing, Closing, Loss Mitigation, Loan Modification, Appraisal, Credit, Income, and Title functionalities
• Experience in understanding Stored Procedures, Stored Functions, Database Triggers, and Packages using PL/SQL.
• Good Data Warehousing concepts including Metadata and Data Marts.
• Experience in conducting Joint Application Development (JAD) sessions with end-users, Subject Matter Experts (SME's), Development and QA teams.
• Extensive experience in project management best practices, processes, & methodologies including Waterfall, Agile, SCRUM, and Rational Unified Process (RUP).
• Software Development Life Cycle (SDLC) experience including Requirements, Specifications Analysis/Design and Testing as per the Software Development Life Cycle.
• Analysis and review of Software and Business Requirement Documents (BRD).
• Gathering business and Technical requirements that would best suit the needs of the technical architectural development process.
• Team lead skills encompassing user interviews, coordination with Tech Lead, DBA's, Developers, QA/QC Analysts during the design phase.
• Interviewing Subject Matter Experts, asking detailed questions and carefully recording the requirements in a format that can be reviewed and understood by both business and technical people.
• Worked in various technologies such as XSLT, XPATH, CSS, XML, and HTML.
• Well versed in Process Narratives, Flow charting Techniques using UML, and Good Documentation Practices. Prepared documents to conduct user acceptance testing. Good working experience in all the sprints of the project in SCRUM.
• Strong SQL knowledge for querying the database and proficient in developing External Tables, Joins, Indexes, Data
• Proficient in executing Test Plans, providing Test Data, conducting unit test, documenting test cases and in Manual Testing - Functional, Database, Black Box, Positive-Negative, and Regression testing.
• Experience in writing User manual, conducting functional walkthroughs, and in performing extensive User Acceptance Testing (UAT).

TECHNICAL SKILLS:

Web Technologies: HTML, DHTML, XML, CSS, XSLT, JavaScript

Software Applications: MS Office, MS Project, MS Visio, MS FrontPage, Dreamweaver, Adobe PhotoShop

SDLC Methodologies: Waterfall, RUP (Rational Unified Process), AGILE (Scrum)

Requirements Management: Rational ClearCase, Requisite Pro, Use Cases, User StoriesQA/Testing: Rational Clear Quest, Team Foundation Server, HP Quality Center 11, QTP, LoadRunner

Project Management: MS Project (PERT, Gantt charts), Excel spreadsheets

Operating System: Windows 95 & 2007, NT/2000/XP, LINUX, UNIX, DOS

Design Tools: Rational Rose, MS Visio (UML)

Database/Tools: Microsoft SQL Server, Oracle 10g & 11g, PeopleSoft, TOAD, Lotus Notes, MS Access, NORKOM

BI/ETL Tools: Informatica PowerCenter 9.1, IBM Cognos 10.2, IBM SPSS

Change Management: Stakeholder Analysis, Change Classification, Prioritization, & Implementation

IT Service Management: ServiceNow ITSM Suite

PROFESSIONAL EXPERIENCE:

Confidential, Providence, RI

Business System Analyst / Data Analyst

Responsibilities:

• Gather requirements through users interviews, teleconferences, document analyses, use case analyses and UML diagrams for user stories creation and obtain timely sign-off by all respective parties.
• Help prepare for CCAR reporting schedules (ex. FRY 14A/Q/M & 9C).
• Meet with financial analysis team and financial reporting team to gather their requirements on data.
• Participate in data modeling, data analysis and requirement documentation.
• Lead Sprint Planning & Estimation sessions, Sprint Retrospectives and Reviews .
• Develop detailed level process maps to facilitate requirements gathering for projects and trainings .
• Conduct data verification on projection data warehouse .
• Design logical models using Star schema. Constructed a credit Fact which could be sliced and diced by various dimensions like Product, GL, Asset Class, Geography .
• Define, documented and translated high-level business requirements into detail system specifications.
• Identify and analyze business problems and defined the scope of activities required to address issues, including requirement definition, process review, impact assessment and operational streamlining where necessary.
• Prepare FRDs that help drive the design of the infrastructure necessary for the organization to meet new CCAR reporting requirements.
• Help with the remediation and mapping of data going into reporting systems.
• Conduct data verification on reporting data warehouse .
• Extensively involved in Data Governance process . Assisted in data grouping and defined relationship among the different tables.
• Participate in configuration of IHC Reporting System and other in-house reporting software /systems .
• Support the Project manager in planning, executing, controlling and closing phases of projects.
• Work with the development team to define system specifications based on the business requirements gathered by Prototyping and JAD sessions.
• Design and implement basic SQL JOIN queries for QA testing and validate reports generated in Axiom .
• Performed System Integration testing, User Acceptance Testing and created test cases and test scripts .
• Use SharePoint to store, organize, share, and access information from almost any device.

Environment: Oracle 11g, Microsoft Project 2000, Axiom SL DDW/IC, Axiom SL Oracle, Informatica 9.5.1, Erwin, MS Excel, SharePoint 2010, PowerPoint, MS Visio and MS Outlook.

Confidential, Louisville, KY

Business System Analyst

Responsibilities:

• As part of the huge scope of the project, I have worked in E820 Health plan 4010 to 5010 conversion project that focuses on 820 (Payroll Deducted and Other Group Premium Payment for Insurance Products) and 834 (Benefit Enrollment and Maintenance) transaction sets.
• Tracking and addressing the problems on timely manner encountered by the providers, billers as well as vendor companies, health plan groups while generating 837 Professional, Institutional, and Dental claims, Acknowledgement 997, Claim Status Inquiry/Response 276/277, Remittance Advice 835, Eligibility Inquiry/Response 270/271, Prior Authorization 278, Drug/Pharmacy rebates and reimbursements, etc.
• Performed Rapid Assessment for over 20 applications such as CBM, DUR, Order processing etc for the MEDICARE -D and commercial business and conducted a SWOT analysis.
• Participated in numerous Healthcare presales initiative for EHR applications, HIPAA 4010-HIPAA 5010 and ICD9 - ICD10 conversions.
• Researched and comprehended the claims adjudication and reimbursement systems based on HIPAA X12 4010 standards.
• Helped the organization go through the HIPAA 4010 to 50 10 transition smoothly by using different Change Management methodologies.
• Proficient in using Agile methodology, performed roles of Scrum Master following sprint/ standup sessions and used Rally software extensively to write user stories, assign tasks to individual team members, analyzing the Iteration Burn Down charts and Cumulative flow charts, logging and reviewing defects.
• Specified in EDI 837/835 transactions, which EDI 837 transaction was used either as a one-way transaction, or as a two-way "inquiry/response" type of transaction.
• Created business use-cases, flow diagrams and validated business rules and data elements for EOB and adjustments application.
• Took part in developing test plan, test scripts, and developed UAT test cases associated with the functional requirements.
• Created Business Information Rules Matrix for Claims regression automation capturing various products and capabilities for the MEDICARE-D business.
• Designed End-to-End scenarios and process flows for testing Medicare-D business.
• Created Healthcare and Medicare - D training material for onshore and offshore teams.
• Presented approach for Model-driven testing to the client.
• Participated in developing test plan, test scripts, and developed UAT test cases associated with the functional requirements.
• Used extensively of Quality Center for Test scripts, Test plans and defects management.
• Created business use-cases, flow diagrams, and business process modeling and validated business rules and data elements for EOB and Adjustments application .

Environment: MS Office Suite, MS Visio, Agile - Scrum, Oracle, SQL, PL/SQL, Quality Center, Windows Server 2003, Java, Java Script, Business Objects, QTP, Rational Clear Quest, Rational Clear Case .

Confidential, Flanders, NJ

Business Analyst

Responsibilities:

• Involved understanding the current business process, defining scope of the project along with position statement.
• Met with users and stakeholders to understand the problem domain, gathered customer requirements through surveys, interviews (group and one-on-one) along with JAD sessions.
• Created business use case, functional (FRS) and technical specifications for trading system.
• Applied Unified Modeling Language (UML) methodology to create use case diagrams and sequence diagrams in Rational Rose .
• Created use-case scenarios and storyboards in MS Word and MS PowerPoint for better visualization of the application.
• Designed the UI (web interface) of the application, along with prototyping.
• Resolved issues and improvised the process to ensure a stable and accurate solution.
• Performed cost-benefit analysis, generated reports for analyzing various investments and their profitability and also for analyzing various lost opportunities due to time delay in investing.
• Worked with financial services as part of support for the application.
• Validated business rules and all artifacts with users, approval and sign off.
• Provided technical and business knowledge to clients.
• Working with the architect, developers on business and technical issues, helping in designing of the system; and testers to ensure all requirements are correctly translated.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database .
• Worked with the team on security features: web, encryption, authentication and SSO possibilities.
• Updated and modified progress and resources allocation in MS project for the team.
• Suggested process and product improvements for the application.
• Created test plans, scripts, and facilitated user acceptance testing.
• Performed manual front-end testing to check all functionalities of different modules.
• Helped in deployment of portal a venue for the on-line trading application a collaboration bundle solution.
• Identified areas of risks, assessment, monitoring, having security and audit controls in place.
• Ensured that the application met user and management expectations.

Environment: MS Visio, MS Project, UML, SQL Server, PL/SQL, .NET, Clear Case.

Confidential, Detroit, MI

Business Analyst

Responsibilities:

• Gathered, analyzed, refined, and interpreted business requirements Business and converted them into functional requirement specifications.
• Documented business rules, understood the business need, added new Customer experience features (Update Content for Enrollment, Add Payees) and provided Screen Layout Specifications for the SRS document .
• Selected the appropriate elicitation technique to efficiently identify critical requirements and prioritized requirements by conducting brainstorming sessions with the back office portfolio management and sign-offs on requirement artifacts from project managers.
• Determined the level of formality required and considered options for documenting and packaging requirements based on project type, priorities, and risks .
• Coordinated and conducted meeting sessions with the business users, captured the equity derivatives requirements and gained an understanding of the business rules & constraints.
• Analyzed trading/sales and Credit risk requirements according to FDIC and FSA standards and identified functional and non-functional requirements.
• Worked extensively on NORKOM, the enhanced Anti - Money Laundering (AML) analysis and risk detection/management system, which enables to fight crime and create reports on the flagged transactions.
• Successfully conducted Joint Application Development (JAD) sessions with cross-functional team members for discussing various shared issues to ensure that the business objectives are met with and requirements are understood clearly at all levels.
• Investigated breaks in the reconciliation reports concerning trade population, MTM, and Counterparty data .
• Prepared requirement traceability matrices and managed all components of the business requirements & UAT testing phase of the development lifecycle.
• Maintained current, detailed knowledge of anti-money laundering and anti-terrorist financing matters.
• Utilized in-depth understanding of BSA/AML and OFAC regulatory requirements and best practices to guide decision making in execution of enterprise-wide AML objectives.
• Developed and maintained a high level of expertise in BSA, OFAC, USA PATRIOT Act and related regulations, directives and guidance.
• Identified possible enhancements to AML monitoring tools and processes and communicate them to the Financial Intelligence Manager.
• Properly reviewed the file from the AML/Compliance folder ensuring all documents are available and meet the Financial Institutions standards.
• Developed SQL Scripts for the Online Editing Application for the Client interface.
• Retrieved and analyzed data using T-SQL, Excel, SSRS .
• Facilitated group meetings, one-on-one interviews, and correspondence through emails to manage change control process and to discuss the impact of change request on the project.
• Initiated and exercised various strategies involved in web site Usability, Functionality, and Compatibility testing.
• Closely interacted with developers and System Architect to understand customer site navigational flow, to identify bottlenecks, enhance site navigation, and increase customer satisfaction.
• Created Test Plan document, test cases, test scripts and expected results for UAT .

Environment: RUP SDLC, Risk Management, Enterprise System, Core Banking, NORKOM, MS Project, MS Access, Dreamweaver, Mobile Application, MySQL database, IBM Requisite Pro.

Confidential

Business Analyst

Responsibilities:

• Involved in planning of development work using Agile Software Development .
• Gathered Business requirements from the stakeholders, SME's and documented the requirements in the BRD .
• Developed FRD (Functional requirement Document) for data architecture and communicated with the SME's .
• Designed Mapping document, which is a guideline to ETL Coding .
• Created artifacts such as Use Cases, Activity Diagrams, Swim lanes Diagrams and Sequence Diagrams using UML/Visio .
• Created Use case and Activity diagrams using MS Visio to give web developers a better idea of the application design.
• Managed change requests from business users and web developers and conducted JAD sessions to resolve conflicts between keys users and web developers.
• Created several stored procedures for data profiling purposes to get a good understanding of duplications and anomalies already exist in the source databases.
• Created roles and file groups to authorize customers to access certain resources of the database .
• Generated reports weekly and monthly to an online management interface using SRS .
• Created UAT testing status reports to present to upper management.

Environment: Scrum and Waterfall Methodologies, Rally software, JIRA, MS Visio, MS Excel, Oracle database, UNIX & SQL Database Server, Rational Rose.