SUMMARY

• Possesses Seven years of Analytical experience wif in - depth knowledge of Web, Database and Data Warehouse/BI applications.
• Experience in working wif applications for Healthcare, Mortgage, Financial and Investment Domains.
• Involved in supporting teh overall stages of SDLC (Analysis, Design, Development, Test and Deployment) of various applications.
• Experience in working wif post productions defects.
• Proficient in Requirement Management including gathering, analyzing, detailing and tracking requirements.
• Expert at creating various documents like Business Requirements Document (BRD), Systems Requirements Document (SRD), Design Documents (HLD/LLD), Application Interface Document (AID), Mapping Document and Test Plan Document.
• Proficient in creating various Unified Modeling Language (UML) diagrams like Process Flow, Activity Diagrams, and Sequence Diagram using tools such as Visio.
• Experienced in maintaining all design documentation workflow activity diagrams, data mapping and technical integration documentation.
• Working knowledge of BI concepts like Star Schema, Snow Flake Schema, ETL, Data Warehouses and Data Marts.
• Experienced in writing SQL queries against Microsoft SQL Server, Oracle and Teradata databases.
• Experienced in developing, reviewing, and Executing Test Strategy, Test Plans, Test Scenarios, and Test Cases/Script.
• Expert in reviewing/reporting, tracking, & maintaining Defects wif high level of detail, accuracy and informative recreation steps.
• Experienced working in Waterfall and Agile Environment.
• Knowledge of various ETL and BI tools like MicroStrategy, SSRS, SSIS, Informatica
• Extensive experience in testing applications implemented in Visual Basic, HTML, SOAP, SQL Server and Oracle.
• Excellent interpersonal, problem solving skills, and recognized for being a valued team player.
• Adept at facilitating walkthrough and training sessions.
• Holds Bachelors in Business Administration degree in Finance.

TECHNICAL SKILLS

Databases: SQL Server 2012/2008 R2, Oracle 11G/10G, Teradata, Microsoft Access

BI/ETL Tools: MicroStrategy, SSRS, Informatica, SSIS, BO

Languages: SQL, PL/SQL, UML, VBA

Methodologies: Agile, Waterfall, RUP

Web Development: HTML

Testing Tools: Jira, Bugzilla, QTP,QC

Operating Systems: Windows, Linux, Unix

Modeling Tools: Visio, Erwin

Client Tools: Toad, SQL Assistant, SSMS, SQL Server

PROFESSIONAL EXPERIENCE

Confidential, Southfield, MI

Business Data Analyst

RESPONSIBILITIES:

• Assist wif teh development of measurement systems and track progress toward corporate performance goals. Assist line management wif teh identification and research of best in class performance measures.
• Conduct research and analysis to assist wif teh identification of benchmarks.
• Develop High-level business requirements, detail level business requirement and functional design documents.
• Develop and Document AS-IS and TO-BE processes.
• Develop TEMPeffective working relationships wif internal and external customers to drive timely solutions to organizational improvement needs.
• Support project management resources to ensure changes to processes and responsibilities are set up to succeed and aligned wif corporate goals.
• Assist teh reengineering of existing business processes to improve internal efficiency and business relationships.
• Work wif IT and project teams to identify and support operational and technology projects. Use teh results of organizational analyses to make process design and development recommendations.
• Participate and lead teh gathering and documenting of functional, non-functional and user requirements to support projects and initiatives.
• Implemented teh project using theWaterfall Methodologyto produce artifacts in teh different phases of theSoftware Development Life Cycle (SDLC).
• Work wif business, IT and Testing Center of Excellence to ensure requirements support design, build and testing activities.
• Perform other job-related duties as assigned.

Environment: Facets 5.2, MS VISIO, 5.2, Kanban, MS-Office Suite including Visio, Oracle Finance MS-Outlook, SNOW, PEGA CRM, Waterfall Methodology, SharePoint

Confidential, Virginia Beach, VA

Business Data Analyst

Responsibilities:

• Worked as a transcriber and also as a facilitator during teh requirement gathering session.
• Functioned as teh primary liaison between teh upper level management, business line, operations, customers and IT department.
• Involved extensively in SIT Testing and created test scenarios for User Acceptance Testing (UAT).
• Responsible to create a Data mapping document between source and target.
• Use SQl queries to test data and update teh queries as required.
• Involved in various
• Facilitated different scrum ceremonies such as teh daily standup, backlog sizing and grooming.
• Defined functional, usability, reliability, and performance and support requirements of a system.
• Conducted user interviews, gathered requirements to help create Business Requirement Documentation, using MS Word and MS Visio.
• Designed and developed Use cases, Activity Diagrams, Process Flow Diagrams and Data Flow Diagrams by using MS Visio.
• Identified and documented issues, risks, gaps and their impact to teh project life cycle. Provided recommendations and alternatives.
• Provided periodic status reports to teh Manager to serve as teh team’s assessment of teh project and its schedule.
• Provided key input in working wif users in defining project and system requirements.
• Involved in developing Test plan and Test cases based on Use cases and Functional Specification

Environment: Facets 5.2, MS-Office Suite including Visio, TOAD, Oracle SQL Developer, MS SQL Server, MS-Outlook, JIRA,SNOW, Teradata SQL-Assistant, PSGl, SSIS, Tidal, Agile(Scrum)/Waterfall, SharePoint

Confidential, Tampa, FL

Business System Analyst

Responsibilities:

• Facilitated/Participated in JAD sessions to gather requirements from teh Business users.
• Performed gap analysis of current system to desired system and document requirements for control gaps identified.
• Conducted review sessions wif Business and IT teams to baseline teh BRD (Business Requirement Document).
• Created a Systems Requirement Document (SRD) based on teh BRD.
• Extensively coordinated wif teh source application team to created/Update a Data Dictionary listing all teh source system data elements.
• Responsible to create a Data mapping document between source and target.
• Involved in working on Medicaid and Medicare claim process.
• Used Visio to create various Environment diagrams and Data Flow Diagrams(DFD).
• Responsible to maintain teh Requirement Traceability Matrix (RTM).
• Conducted Requirements walkthrough wifin teh Testing team.
• Assisted testing team to create test data to cover all teh scenarios.
• Wrote SQL queries/scripts to test teh data.
• Worked wif teh testing team to log and track teh defects.
• Coordinated Regression Testing and created test scenarios for User Acceptance Testing (UAT).
• Created user manual and training materials for users to Create/Execute reports.
• Tested MicroStrategy reports Report layout, Attributes/Metrics, positions,Totals& GrandTotals,Drilling options.
• Assisted teh support team by reaching out to teh source systems to resolve data issues.
• Maintained documents for change request and implemented procedures for testing changes.

Environment: MS Visio, UML, HTML, Agile, Kanban, Bugzilla, SSIS,Oracle 10G,SQL Server 2012, MicroStrategy,MS Office (Word, Excel, PowerPoint), Sharepoint

Confidential, Tallahassee, FL

Business System Analyst

Responsibilities:

• Attended teh review meetings wif SME’s and Business analyst to understand teh requirements.
• Worked on various salesforce.com standard objects like Accounts, Contacts, Leads, Opportunities, Reports and Dashboards.
• Created, reviewed and baselined teh SRD(System Requirement Document) based on teh BRD.
• Assisted in teh creation of teh High Level Design document (HLD) which included mapping document.
• Performed data profiling against teh source systems to understand teh data elements.
• Reverse Engineered teh current application wif teh help of report and ETL developers to resolve issues to understand current data model.
• Provided input in teh creation of Test Strategies and Test plan documents.
• Created test to cover all teh all teh mapping rules to test teh ETL process.
• Responsible for creating test cases for ETL to compare source and target systems.
• Wrote/Executed test scripts against teh staging and data warehouse.
• Provided guidance in solving many production issues.
• Performed manual test by writing queries against teh Warehouse to test teh reports.
• Created training manuals for teh end users.
• Created a document listing teh definitions of teh source systems.

Environment: SQL Server 2008R2, Oracle, Teradata, Informatica, Business Objects, SQL Assistant, Jira, MS Access/Excel/Visio, Salesforce CRM

Confidential, Iselin, NJ

BI Analyst

Responsibilities:

• Worked closely wif SMEs to identify and analyze teh core requirements and key features of teh ongoing project.
• Facilitated user interviews, workshops to gather requirements and analyzed teh requirements.
• Created teh Business Requirements Document(BRD).
• Co-authored teh SRD(System Requirement Document) by interacting wif development teams.
• In conjunction wif teh Project Manager and Solutions Architect prepared implementation document and present progress reports to clients in order to keep them current on teh project status
• Functioned as teh primary liaison between teh business line, operations, and teh technical areas throughout teh project cycle.
• Used Toad to write SQL queries to test teh data.
• Participated in documenting User manuals.
• Conducted User Acceptance Testing (UAT)
• Assisted in development of training materials for new technology and process improvements.
• Provided training to users and user managers.

Environment: UML, SQL, PL/SQL, Waterfall, MS Office, MS-Project,SQL Server 2008, Oracle 10G, Cognos,Informatica

Confidential, New York, NY

Business Systems Analyst

Responsibilities:

• Gathered business requirements through interviews, surveys, prototyping and observing from account managers and UI (User Interface) of teh existing Applied RUP methodology wif its various workflows, artifacts and activities to manage life cycle from Inception to Transition phase.
• Identified source systems, their connectivity, related tables and fields and ensure data suitably for mapping.
• Conducted JAD sessions wif management, vendors, users and other stakeholders for open and pending issues to develop specifications
• Involved in teh design of teh data model.
• Acted as liaison between external clients and SMEs to generate and standardize product requirements specification documents such as URS/FRS/Use Cases.
• Employed UML methodology in creating UML Diagrams such as Use Cases, Sequence Diagrams, State Diagrams, Activity Diagrams and business process and workflows.
• Involved in designing determined 3-tier architecture for teh claim processing system. Assisted team lead in developing Requirements Traceability Matrix (RTM) to trace teh relationship between business and functional requirements to test cases. Prepared and executed different Test Cases and Test Scripts.
• Used aggregate functions in SQL to test teh data.
• Conducted User Acceptance Testing on teh application - resolved issues from teh participants, prepared and submitted Test Analysis Reports and participated in Product Readiness Review.

Environment: MS SQL Server, Oracle, Waterfall, RUP, Data Stage, UML, MS Office Tools, MS Outlook, Java.

Confidential, New York, NY

Business Analyst

Responsibilities:

• Acted as a liaison between teh Corporate Finance clients and Technology department of Confidential Financials.
• Involved in Requirements Gathering and business analysis through PLC of an online portal to provide visibility to corporate customers on their Equity and investment positions, FX, integration wif market data and analyzed teh traders fixed income business requirements.
• Responsible to pull a team of analysts from all our extended financial departments to guide teh direct teh overall EQFD strategy for forecasting and budgeting, Risk Management and fixed income and derivatives.
• Wrote functional specifications dat included UML Diagrams and Use Case using Rational Rose.
• Involved in preparing Business Documents (BRD).
• Responsible for documenting and developing business rules for our metrics based on teh business needs, Financial Requirements and process used to track our work.
• Conducted JAD/RAD sessions/weekly meeting/ walkthroughs to monitor teh project progress.
• TEMPEffectively communicated corporate objective for BCP/DR to international locations, enabling them to coordinate efforts remotely provide.
• Created, Verified and managed teh BCP/DR documents, such as BCP and DR plans, first responders list, and IT call list.
• Made presentation to senior management to outline our project process and phases whose end result will help them to reduce their cost significantly.

Environment: MS Office Tools, MS Outlook, UML, SQL Mgmt Studio, RUP

Confidential, Philadelphia, PA

Business Analyst

Responsibilities:

• Created and reviewed business requirements and functional specifications.
• Interacted wif key business users to collect requirement and business process information.
• Developed Requirements Traceability Matrix (RTM) using Rational Rose to trace each software requirement to test case.
• Performed extensive requirement analysis including data analysis and gap analysis.
• Designed and developed Use Cases and UML models using Rational and developed Sequence Diagrams.
• Worked on developing strategic partnerships wif teh business unit to build a sound knowledge base of teh business line, including teh business plan, and process and revenue streams.
• Partnered wif teh technical team in teh research and resolution of system and process problems.
• Worked wif teh QA team in testing teh upgraded system for data retrieval, using complex SQL queries.
• Analyzed operational procedures and methods and recommended changes for improvement wif an emphasis on automation and efficiency.
• Performed activities supporting teh roll out e.g. teh UAT template for Business User for QA.

Environment: Rational Rose Enterprise,Agile/Scrum, Rational Requisite Pro,MS Office, QTP, MS SQL Server