SUMMARY

• Eight years of Analytical experience wif in - depth knowledge of Web, Database and Data Warehouse/BI applications.
• Involved in Analysis, Design, Development, Test and Deployment (SDLC) of various applications using Waterfall, Agile/Scrum and RUP.
• 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, 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.
• Strong knowledge of Ralph & Kimball Methodology.
• 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 Agile Environment.
• Knowledge of various ETL and BI tools like MicroStrategy, SSRS, SSIS, Informatica
• In depth Knowledge and experience in preparation of Financial statements.
• 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

PROFESSIONAL EXPERIENCE

Confidential, Virginia Beach, VA

Business System Analyst

Responsibilities:

• Worked as a transcriber and also as a facilitator during the requirement gathering session.
• Functioned as the primary liaison between the upper level management, business line, operations, customers and IT department.
• Involved in weekly meetings wif the development team to resolve technical issue.
• 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 the queries as required.
• Involved in various
• Facilitated different scrum ceremonies such as the daily standup, backlog sizing and grooming.
• Defined functional, usability, reliability, performance and support requirements of a system.
• Conducted user interviews, gatheird requirements to halp 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 the project life cycle, provided recommendations and alternatives.
• Provided periodic status reports to the Manager to serve as the team’s assessment of the 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
• Involved in on call support for production defects.

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

Confidential, Tampa, FL

Business System Analyst

Responsibilities:

• Facilitated/Participated in JAD sessions to gather requirements from the 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 the BRD (Business Requirement Document).
• Created a Systems Requirement Document (SRD) based on the BRD.
• Extensively coordinated wif the source application team to created/Update a Data Dictionary listing all the 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 the Requirement Traceability Matrix (RTM).
• Conducted Requirements walkthrough wifin the Testing team.
• Assisted testing team to create test data to cover all the scenarios.
• Wrote SQL queries/scripts to test the data.
• Worked wif the testing team to log and track the 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 the support team by reaching out to the source systems to resolve data issues.
• Maintained documents for change request and implemented procedures for testing changes.

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

Confidential, Tallahassee, FL

Business System Analyst

Responsibilities:

• Attended the review meetings wif SME’s and Business analyst to understand the requirements.
• Worked on various salesforce.com standard objects like Accounts, Contacts, Leads, Opportunities, Reports and Dashboards.
• Created, reviewed and baselined the SRD(System Requirement Document) based on the BRD.
• Assisted in the creation of the High Level Design document (HLD) which included mapping document.
• Performed data profiling against the source systems to understand the data elements.
• Reverse Engineered the current application wif the halp of report and ETL developers to resolve issues to understand current data model.
• Provided input in the creation of Test Strategies and Test plan documents.
• Created test to cover all the all the mapping rules to test the ETL process.
• Responsible for creating test cases for ETL to compare source and target systems.
• Wrote/Executed test scripts against the staging and data warehouse.
• Provided guidance in solving many production issues.
• Performed manual test by writing queries against the Warehouse to test the reports.
• Created training manuals for the end users.
• Created a document listing the definitions of the 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 the core requirements and key features of the ongoing project.
• Facilitated user interviews, workshops to gather requirements and analyzed the requirements.
• Created the Business Requirements Document(BRD).
• Co-authored the SRD(System Requirement Document) by interacting wif development teams.
• In conjunction wif the Project Manager and Solutions Architect prepared implementation document and present progress reports to clients in order to keep them current on the project status
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle.
• Used Toad to write SQL queries to test the 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, Agile, MS Office, MS-Project,SQL Server 2008, Oracle 10G, Cognos,Informatica

Confidential, New York, NY

Business Systems Analyst

Responsibilities:

• Gatheird business requirements through interviews, surveys, prototyping and observing from account managers and UI (User Interface) of the 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 the design of the 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 the claim processing system. Assisted team lead in developing Requirements Traceability Matrix (RTM) to trace the 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 the data.
• Conducted User Acceptance Testing on the application - resolved issues from the participants, prepared and submitted Test Analysis Reports and participated in Product Readiness Review.

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

Confidential, New York, NY

Business Analyst

Responsibilities:

• Acted as a liaison between the 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 the traders fixed income business requirements.
• Responsible to pull a team of analysts from all our extended financial departments to guide the direct the overall EQFD strategy for forecasting and budgeting, Risk Management and fixed income and derivatives.
• Wrote functional specifications that 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 the business needs, Financial Requirements and process used to track our work.
• Conducted JAD/RAD sessions/weekly meeting/ walkthroughs to monitor the project progress.
• Effectively communicated corporate objective for BCP/DR to international locations, enabling them to coordinate efforts remotely provide.
• Created, Verified and managed the 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 halp 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 the business unit to build a sound knowledge base of the business line, including the business plan, and process and revenue streams.
• Partnered wif the technical team in the research and resolution of system and process problems.
• Worked wif the QA team in testing the 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 the roll out e.g. the UAT template for Business User for QA.

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

Confidential

Business Analyst

Responsibilities:

• Created and reviewed business requirements and functional specifications. .
• Performed extensive requirement analysis including data analysis and gap analysis.
• Designed and developed Use Cases and UML models using Visio and developed Sequence Diagrams.
• Worked on developing strategic partnerships wif the business unit to build a sound knowledge base of the business line, including the business plan, and process and revenue streams.
• Partnered wif the technical team in the research and resolution of system and process problems.
• Worked wif the QA team in testing the 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 the roll out e.g. the UAT template for Business User for QA.

Environment: MS-Office Suite including Visio, MS SQL Server, MS-Outlook, SSMS