SUMMARY:

• 6 + years of experience as a Business Analyst/Business System Analyst in industry domains including Banking, Financial, Pharmaceuticals, Health/Life Insurance, Retirement, Annuities, and Mortgages .
• Strong understanding of financial valuation concepts and various capital market instruments and processes including Equities, Fixed Income, Foreign Exchange, Derivative (OTC) & Back - Office operations.
• K nowledge of Comprehensive Capital Analysis and Review (CCAR), BASEL II, BASEL III, and Dodd-Frank Act.
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration and Metadata Management Services.
• 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.
• Experience in creating database tables, writing stored triggers, select statements, joins, views.
• Ability to collaborate with peers in both, business, and technical areas, to deliver optimal business process solutions, in line with corporate priorities.
• Knowledge of Mortgage Backed Securities (MBS), Mortgage Loan Origination, Servicing, Closing, Loss Mitigation, Loan Modification, Appraisal, Credit, Income, and Title functionalities.
• Captured and tracked Business and Functional requirements including 401(k) and 403(b) data flows, developed Use Cases, wireframes, Process Flows, Data Modeling and Flow Diagrams, and documented Systems Specifications using RUP methodology.
• Experience in understanding Stored Procedures, Stored Functions, Database Triggers, and Packages using PL/SQL.
• Good Data Warehousing concepts including Meta data and Data Marts.
• Strong understanding of dimensional modeling of Star Schemas, Snow-Flake Schemas Methodologies for building enterprise data warehouses.
• Experienced in developing Dashboards Reports in Cognos 8 and 10.
• Strong Data Quality Management background performing analysis, monitoring and tuning to maintain data integrity.
• Knowledge in Planning, Designing, developing and deploying Datawarehouses / Data Marts with experience of both relational & multidimensional database design using Data Modeling tool ERwin (Physical and Logical data models)
• 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.
• Ability to understand current business processes and implement efficient business process.
• Expertise in defining scope of projects based on gathered Business Requirements including documentation of constraints, assumptions, business impacts & project risks.
• Analysis and review of Software and Business Requirement Documents (BRD).
• Conducting requirement gathering sessions, feasibility studies and organizing the software requirements in a structured way.
• 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.
• Having application testing experience with working knowledge of automatic testing tools like Mercury Quick test Professional and Load Runner.
• Experience with re-engineering, implementation and Data Governance projects.
• 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 Modeling, Analysis, Verification, Cleansing, Transformation, Integration, Mapping, Extraction, Load Process from multiple Data Sources.
• 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 Stories

QA/Testing: Rational Clear Quest, Team Foundation Server, HP Quality Center 11, QTP, LoadRunner

Project Management: MS Project (PERT, Gantt charts), Excel spread sheets

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, Informatica MDM,Cognos 10.x/Cognos 8.x Suite (Report Studio, Query Studio, Analysis studio, Workspace, Workspace Adv), Power play Transformer, Tableau, IBM SPSS

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

PROFESSIONAL EXPERIENCE:

Confidential- Sacramento, CA

Business Analyst/Data Analyst

Responsibilities:

• Involved in gathering requirements and documenting the gathered requirements /Involved in meetings with the Team members to discuss the requirements.
• 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.
• Prepared Test Plan from the Business Requirements and Functional Specification .
• Lead Sprint Planning & Estimation sessions, Sprint Retrospectives and Reviews.
• Develop detailed level process maps to facilitate requirements gathering for projects and trainings.
• Developed Logical and Physical Data Model using Erwin, followed Star Schema to build the Data warehouse .
• Tested different detail, summary reports and on demand reports.
• Communicated discrepancies determined in testing to impacted areas and monitored resolution .
• Wrote the test scripts for manual testing.
• Extensively Used SQL and PL/SQL Scripts and worked in the both UNIX and Windows Environment .
• Assisted in the process of preparation of the document Informatica Transformation Development Standards . This document describes the general guidelines for Informatica developers, the naming conventions to be used in the Transformations and also development and production environment structures.
• Used Debugger to troubleshoot the mappings.
• Implemented Slowly Changing Dimensions Type 1, Type 2.
• Troubleshoot post production defects. Analyze the existing flow and prepare BRD documents for the defects and Change requests.
• Involved in Code fixes and migration of code from Dev to SIT and Production .
• Used SQL query to analyze the Pfizer source systems and existing data warehouse data. Prepared data mapping documents to build the new data mart and Tableau reporting .
• Prepared Visualization Reports for quarterly and yearly reports for Supply chain higher management.
• Supported SIT and UAT testing and documenting user acceptance criteria.
• Monitoring SIT cycles and involved in Production support.
• Handled change requests from the client.

Environment: Workflow Manager, Workflow Monitor, Repository Manager, Metadata Exchange, HP-UNIX, FTP, Oracle 11g, Erwin, SQL, PL/SQL, Unix Shell Scripting, Tableau, Quality Center.

Confidential- Pittsburgh, PA

Business Analyst/Data Analyst

Responsibilities:

• Review, manage and analyze data CFG's Comprehensive Capital Analysis and Review (CCAR) submission to FED.
• Acted as a liaison between system users, client managers and software development team to gather requirements based on the CCAR Regulation for Financial Statements, Interest Rate, Credit Ratings and Investment Securities. Create document work flow and result of business analysis in to Business Requirement Document (BRD) .
• Analysis and design of CCAR (FRY 14Q and FRY 14M - all schedules), FRY 9C (few schedules), FFIEC102, etc. report requirements in AXIOM .
• Ensure data integrity and accuracy with other regulatory submissions (FRY 9C, FRY 14A, FRY 14M) .
• Participated in various CCAR workgroups and steering committee meetings; emphasis and execution on process efficiencies and automation efforts.
• Entailed mapping and reconciliations, data gapping analysis and documenting data sourcing from various business units for inclusion in PPNR Schedule
• Working closely with stakeholders to assess current state, perform gap analysis, and develop requirements for business process, capability and technology infrastructure enhancements to support the creation and management of stress testing scenarios.
• Adept at Business /System Analysis including experience in gathering user requirements documenting requirement technical writing, business analysis, system analysis, testing and implementation of projects.
• Oversee Design approach and undertake implementation of the Axiom Controller View for the reports in scope and perform unit test.
• Leading identification and resolution of issue / risk / dependency by promoting collaboration with SMEs and other stakeholders.
• Sharing best practices, collaborating with Risk Project Management to maximize transparency and influence program delivery.
• Was assigned the task of working in the environment project management team in implementing ETL process for pulling data from various databases relevant to model input data
• Prepared project plan for building ORACLE database and implementing ETL and constantly updated SharePoint site
• Prepared the groundwork for ETL process and provided the blueprint for this process to the ETL developer by coordinating with database architect and ETL developer .

Environment: SQL, MS Access, MS Project, MS Visio, MS Office Suite, Adobe Acrobat Suite, Jira, AXIOM, Informatica, SharePoint, Confluence, Oracle toad, ALM Quality Center

Confidential- Walnut Creek, CA

Business Analyst/Data Analyst

Responsibilities:

• Involved in Inception Phase and prepared vision statement and initial data models that contain Business Requirement Documents and supporting a document that contains the essential business elements and detailed definitions.
• Gathered and understood business requirements and transformed them into data warehousing solutions for Group Health Insurance Customer data .
• Worked alongside Users/SMEs (Subject Matter Experts) to recommend and gather low-level business processes and convert them into technical requirements for the development team, at various stages of the SDLC (System Development Life Cycle) .
• Analyzed Business Requirements 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 .
• Designed and developed, Use Cases, Activity Diagrams, Sequence Diagrams, OOAD, Visio and Business Process Modeling .
• Collaborated with Quality Assurance Analyst in Automated and Manual Black box testing.
• Responsible for architecting integrated HIPAA, Medicare solutions, and having sound Knowledge of data architecture concepts, data warehouse and datamarts and having strong experience in Strong skills at SPSS, Microsoft SQL server and Excel .
• Wrote SQL queries for each Test case and executed in SQL Plus to validate the data between Enterprise Data Warehousing and Data Mart Staging Tables .
• Coordinated data mapping, testing and validation strategies of 837 and 277 transactions to ensure adherence to HIPPA and State regulations .
• Created/Reviewed data flow diagram to illustrate where data originates and how data flows within the Enterprise Data warehouse (EDW).
• Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team.
• Worked on HIPAA compliance, Electronic Data Interchange (EDI), Medicare, ANSI x12 formats and implementation of HIPAA code sets, ICD-9, ICD 10.
• Wrote Test cases for Enterprise Data Warehousing (EDW) Tables and Data Mart Staging Tables .
• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.

Environment: Oracle, PL/SQL, Mainframes, .NET Java, J2EE, MS-Project, MS-Office Suite, MS Visio, Rational Requisite Pro, Clear Case, Clear Quest, MS Visual Source Safe, HPQC.

Confidential- San Francisco, CA

Business Analyst/Data Analyst

Responsibilities:

• Gathering requirements from Business Line Mangers and SME’s for the redesigned Principal’s Client Portal, Client Database and to Digitize the Transactions.
• Developed Process Model and detailed Business Policies and documenting the same in Business Requirement Document.
• Prepared High Level Process Flow Diagrams and Business Process Flow diagrams for Great West Client Portal functionalities in Visio.
• Developed Use Case diagrams, Use case Narratives and User Stories.
• Prepare Wireframes, Prototypes and Mock up screens for different web pages.
• Participated in Backlog Grooming sessions, identified obstacles, planned releases and managed sprints, also created a Business Requirement Document for management.
• Created and Managed User Stories in Epics, Themes and Sprints; also calculated velocity and Story-points in TFS.
• Coordinate with offshore team in documenting the gathered Requirements in to BRDs and FRDs.
• Extensively involved in Data Governance process. Assisted in data grouping and defined relationship among the different tables.
• Participate in User Acceptance Testing (UAT) and developed Training Manuals.
• Applied Master Data Management (MDM) concepts for data alignment, maximizing analytics and business intelligence promoting corporate objectives and initiatives.
• Developed Multidimensional Models in Power-Play Transformer and generated Power Cubes for OLAP comprising of dimensions, hierarchies, levels, categories, and measures in Cognos.
• Modified Power Cubes by adding new Dimensions, Levels, Categories and Measures.
• Created different Dashboards in report studio using combination of List, Crosstab, and Graph and Map reports.
• Scheduled various reports using Cognos Connection and Report Studio.
• Created Score Cards and Dashboards to present critical company data in a Single Report.
• Designed and recommended modifications to existing data governance processes.
• Conceptualized and implemented MDM Strategy for the organization.
• As part of MDM implementation, involved with validating and testing user accounts; validating the suspect and collapsed data; created dummy accounts to validate against the back-end and the front-end data.
• Reviewed requests to load/extract from the MDM platform and evaluated/reported the impact to the data model and use cases.
• Participated in Data Mapping, Data Conversion, creation of the Data model and used SQL and Toad to extract, filter and validate data.
• Created T-SQL objects such as tables, views, joins and store procedures to meet client requirements.
• Perform data validation using SQL queries and run ad-hoc queries to show data to the business users.

Environment: Cognos 8.4, Rational Requisite, Rational Rose, Rational Clear Case, UML 2.0, MS Project 2000, MS Office, Oracle 10g, XML, Informatica Master Data Management (MDM)

Confidential - San Francisco, CA

Business Analyst/Data Analyst

Responsibilities:

• Conducted a walk through session of the scope document to ensure that the project sponsors and stakeholders understand the project scope and any associated constraints, risks, and issues as early as possible.
• Utilized Rational Unified Process (RUP) to configure and develop process, standards, and procedures and created a business use case .
• Performed data analysis and data validation by writing SQL queries using TOAD against ORACLE database .
• Analyzed business requirements and segregated them in high level and low level use cases.
• Derived functional and technical requirements specifications based on user requirement Specification (URS) .
• Understood and articulated business requirements from user interviews and then converts requirements into technical specifications.
• Wrote clear, concise detailed system requirement specification (SRS) documents and user documentation in accordance to guidelines and standard of a level where developers can interpret design and develop the application with minimum guidance.
• Designed use case diagrams and wrote their specifications in the use case specifications documents based on the requirements gathered.
• Documented requirement traceability matrix in Requisite Pro for traceability of requirements through test cases .
• Conducted highly interactive JAD sessions with projects stakeholders such as users, QA analyst, and project management team, identifying and resolving issues.
• Involved in categorizing mortgage prepayment risk, risk analytics for Mortgage-backed Securities (MBS), loan origination, loan servicing, MBS, SMBS, Secondary mortgage insurance, escrow and reserve administration, escrow processing, non-escrow loans collateral inspection and monitoring, income and expense statement review and inspection report.
• Worked on integration of various modules related to securities like MBS and mutual Funds with the mortgage and loan application servicing system.
• Assisted Quality assurance team in preparing test strategies and test plans to verify the functionality, security, fault- tolerability, performance and successful system integration.

Environment: Rational Rose, Rational Clear Case, MS Project 2000, MS Office, Oracle 10g, Java