PROFESSIONAL SUMMARY:

• 9 years of industry experience as a Senior Business and Systems Analyst handling complex IT projects in multiple domains including Banking, Insurance, Retail, Point of Sale Solutions, Cloud Technology, E - commerce and CRM
• Expert in System Analysis, Requirement Gathering, Analysis and Documentation, Business Process Flow, Solution Assessment and Validation, Software Design, Business Process Re-engineering, Project Management and Enterprise-wide System Implementation
• Excellent knowledge of various System Development Life Cycle (SDLC) methodologies including Waterfall, Rational Unified Process, Service Oriented Architecture and Agile Iterative methodologies
• Possess excellent business writing skills required for documenting Business Requirements Document (BRD), Functional Requirements Document (FRD), Non-Functional Requirements Document (NFRD), System Requirements Specification(SRS),  Statement of Work (SOW) and Use Cases.
• Deep expertise in writing Epics, User Stories and Acceptance Criteria in an Agile environment.
• Proficient in using MS Visio, Rational Rose and UML for generating Data Flow Diagrams, Class Diagrams, Sequence Diagrams, Activity Diagrams and Collaboration Diagrams using Rational Rose and MS Visio
• Conducted GAP analysis, Risk Analysis, SWOT analysis, Cost benefit analysis and ROI analysis.
• Expertise in Test Planning, Test Preparation, Test Execution, Defect Tracking, Issue Resolution and Report Generation to assure all project deliverables are in compliance with the Business Requirements
• Experience in conducting Joint Application Development (JAD) sessions, walkthroughs and interviews with End Users, Subject Matter Experts (SME), Developers, Business Partners and Stakeholders and QA Team
• Expertise in developing artifacts such as Use Cases, User Stories, Risk Management Plan, Prototypes, Requirements Traceability Matrix (RTM), Wireframes, Mockups, and Workflow and State Models.
• Highly proficient in developing and managing MS Access and SQL Server database for Data Entry, Storage and generation of Reports to facilitate management decision making processes
• Accomplished at User Acceptance Testing (UAT), Functionality Testing, Unit testing, System Testing, Integration Testing and Regression Testing.
• Extensive experience in conducting Risk, SWOT, PESTLE, Impact, GAP, Feasibility, and Cost-Benefit Analyses.
• Expertise in designing visual models such as Activity, Business Process, Cause-and-Effect, Class, Pareto, Data Flow, Sequence, and State-Machine diagrams, using Unified Modelling Language (UML).
• Extensive experience with Data Warehousing, Extraction, Transformation and Loading (ETL) and Business Intelligence (BI) tools such as TIBCO Spotfire, Microsoft BI Suite and IBM Cognos
• Expert in Data Maniuplation using MS Excel Macros and Pivot Tables, Data Mapping, Data Mining, Data Profiling, Data Migration, Entity Relationship Diagrams (ERD) and Dimension Modelling
• Expertise in generating advanced SQL queries and developing database objects such as Views, User Defined Functions, Triggers, Indexes, Cursors, and Stored Procedures using SQL.
• Strong project management skills as Planning, Scheduling, Monitoring, Effort Estimation and Budgeting
• Dedicated and self- motivated, proven leadership capabilities and time management skills.
• Excellent Analytical, Problem Solving, Communication and Documentation and good Process Management skills

TECHNICAL SKILLS:

Microsoft: MS Excel, MS Word, MS Power Point, MS Outlook, MS Project (w/ Gantt Charts), MS Visio, MS SharePoint 2007/10/13

HP Tools: HP ALM (QC), HP Exstream Command Center

Business Intelligence/ ETL: Cognos 10 BI Package, SSIS, SSRS, SSAS, Tableau Desktop 8.2, QlikView, TIBCO Spotfire, SAS, SPSS, MiniTab

Databases: MS SQL Server 2005/2008/R2/ 2012, Oracle PL/SQL 9g/10g

Programming: Visual Basic 6.0, C, C++, HTML, XML, Python, Java, Javascript, PHP, ASP.NET

Testing/Automation: QTP, LoadRunner, Rational RequisitePro, Test Director

Business Analysis: UML, Enterprise Architect, Rational Rose, Rational ClearCase, EMC Documentum

Domain Tools: Eagle PACE, Oracle Essbase, Hyperion, SAP CRM, Peoplesoft HR, Salesforce

Operating System: Windows 1998/ 2000/ 2007/ XP/ 7/ 8, UNIX (Solaris, Linux)

PROFESSIONAL EXPERIENCE:

Confidential, Seattle, WA/Atlanta, GA

Sr. Business Analyst

Responsibilities:

• Gathered Business Requirements, interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Developed UML diagrams, including Use Case Diagrams, Activity Diagrams, Class Diagrams, Data Flow Diagrams, Business   Process Diagrams, Wireframes, Sequence Diagrams, using MS Visio and Rational Rose.  
• Created Requirement Traceability Matrix (RTM) to keep stakeholders informed of the project status.
• Created Problem Statement Matrix and conducted GAP Analysis to identify business opportunities and problems.
• Reviewed current Service Level Agreements (SLAs) to develop Interim Business Impact Analysis (BIA), Feasibility Analysis, and To-Be Use-Case diagrams.
• Conducted User Interviews and Joint Application Design (JAD) sessions to understand client business processes.
• Gathered high-level requirements through brainstorming and requirements workshops. Developed Business Requirements Documents (BRD) and Functional Specifications Documents (FSD) for third-party integration.
• Assisted Product and Channel Managers, Development and Operations teams to build efficient roll-out strategies
• Adopted Agile (Scrum Framework) methodology of System Development Life Cycle (SDLC) to collect and document requirements and facilitate project planning and meetings.
• Facilitated Daily Scrum Meetings to improve the efficiency of each sprint and assisted Scrum Product Owner in creating and updating Sprint Burndown Chart.
• Developed Work Breakdown Structure (WBS) using MS Project to allocate resources and estimate project schedule.
• Developed Test Cases, Test Plans, and Test Scenarios and performed Unit Testing and User Acceptance Testing (UAT) for cloud-computing business requirements and technical specifications.
• Conducted value chain analysis to determine Critical Success Factors (CSFs) and interacted with Business Process Owners to ensure that requirements support the attainment of CSFs.
• Developed Business and Process Flow Diagrams to analyze the As-Is and To-Be models of business processes.
• Created different reports such as Cross Tab and Parameterized reports, using SSRS and delivered the reports to concerned business users and internal stakeholders.
• Performed Systems Study and developed Entity Relationship Diagrams and Table Structures.
• Developed User Manuals & Training Guides for User Acceptance Testing (UAT) and deployment for end clients with step-by-step instructions and appropriate UI screenshots. 
• Developed Tables, User-Defined Functions, Triggers, Views, Indexes, and Stored Procedures to perform different computations on the integrated data using T-SQL.
• Created Project Charter defining project objectives, business needs, critical to quality (CTQs), scope, impacts, constraints, assumptions and dependencies.
• Created Logical Data Models, Business Requirement Document and Functional Specifications Documents.
• Designed and analyzed OLAP cubes in SSAS using Snowflake and Star Schema designs.
• Created SSRS and MS SharePoint 2010/2013 reports including, Drill Through, Tabular, and Ad Hoc Reports.
• Analyzed and executed various reporting objects, including Facts, Attributes, Hierarchies, Filters, Prompts, Groups, Transformations, and Parameters in Tableau.

Environment: Windows 7.0, Mockup Screens, MS SQL Server 2012, T-SQL, IBM Requisite Pro, IBM Rational Rose, SSRS,MS Visio, MS SharePoint 2010, MS Access, MS Excel, MS Project, SQL Profiler, MS Visual Studio 2010, QTP, UML, Agile Methodology, Visual Basic 6.0, HP Service Desk, Tableau, Teradata Database.

Confidential, Seattle, WA

Sr. Business Systems Analyst

Responsibilities:

• Highly expertized in tracing requirements throughout the development process and verifying adherence to Requirement Traceability Matrix (RTM).
• Developed Work Breakdown Structure (WBS) using MS Project to allocate resources and estimate project schedule.
• Developed Test Cases, Test Plans, and Test Scenarios and performed Unit Testing and User Acceptance Testing (UAT) for cloud-computing business requirements and technical specifications.
• Developed Business and Process Flow Diagrams to analyze the As-Is and To-Be models of business processes.
• Facilitated Joint Application Development (JAD) sessions and structured walkthroughs with technical and regulatory teams to ensure the functional and non-functional requirements are met.
• Developed UML diagrams, including Use Case Diagrams, Activity Diagrams, Class Diagrams, Data Flow Diagrams, Business   Process Diagrams, Wireframes, Sequence Diagrams and GUI elements, using MS Visio .
• Created Requirement Traceability Matrix (RTM) to keep stakeholders informed of the project status.
• Created Problem Statement Matrix to identify business opportunities and problems.
• Prepared and analyzed AS IS and TO BE in the existing architecture and performed GAP Analysis.
• Reviewed current Service Level Agreements (SLAs) to develop Business Impact Analysis (BIA), Feasibility Study, and To-Be Use Case diagrams.
• Actively participated in gathering of User Requirements and System Specifications
• Developed Business Flow diagrams, Entity Relationship diagrams and Sequence diagrams using MS Visio environment so development team and other stakeholders can understand business process.
• Incorporated Rational Unified Process (RUP) to create Business Requirement Specifications using MS Visio.
• Analyzed and mapped the As-Is business processes, compared them to the To-Be state to define the Gap, and then created new Process Flow Diagrams.
• Assisted the Programs Manager in organizing meetings with Developers and Quality Analysts to discuss business requirements, test planning sessions, resource allocation, project sizing, business approvals and release dates.
• Gathered functional requirements and created vision, scope, and other artifacts during the inception phase.
• Participated in Business Requirement Definition (BRD) workshops along with clients and Subject Matter Experts.
• Created Test Plan and executed Test Cases to test the major functionalities of the system using HP ALM.
• Developed Test Cases, Test Plans, and Test Scenarios and performed Unit Testing and User Acceptance Testing (UAT) for cloud-computing business requirements and technical specifications.
• Generated database monitering and data validation reports in SQL Server Reporting Service (SSRS)
• Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc. on various database objects to obtain the required results by using T-SQL.
• Actively involved in writing T-SQL Programming for implementing Stored Procedures and Functions and views for different tasks.
• Conducted UAT(user accaptence testing) with business users and provided dummy data for the UAT.
• Developed Business Flow diagrams, Entity Relationship diagrams and Sequence diagrams using MS Visio environment so development team and other stakeholders can understand business process.

Environment: MS SQL Server 2012, IBM Requisite Pro, Rational Rose, SSRS, SSAS, SSIS, MS Visio, MS SharePoint 2010/ 13, MS Project, Visual Studio 2010, QTP, HP ALM (QC), Tableau, Teradata, TIBCO Spotfire.

Confidential, Philadelphia, PA

Sr.Business Systems Consultant/ Data Analyst

Responsibilities:

• Collected and documented business processes as well as business rules. Participated in the identification, understanding, and documentation of business requirements, including the applications capable of supporting those requirements.
• Reviewed and analyzed the business requirements document to derive the functional specifications document and assisted in the preparation of System Requirement Specifications.
• Facilitated business requirements gathering sessions with the client, and overlooked the creation of Use Cases/Activity Diagrams, Functional Specifications using UML/Visio
• Designed and developed Use Cases and UML models using Rational and developed Sequence Diagrams using UML.
• Participated and facilitated different levels of discussions through User Interviews, Structured Walkthroughs and JAD sessions, conference calls and business workshops held to plan business strategy.
• Attend weekly change request meetings to document changes and implement procedures to test changes upon completion.
• Designed Mockup Screens and Use case diagrams using MS Visio to present a better view of the system and enable the technical team to identify the key processes
• Created project execution roadmap identifying project structure, outlining project phases, project prioritization and project kick off.
• Supported Architects in the creation of Rough Order of Magnitude (ROM), developed the Project Requirement Documents (PRD), Functional Specification Document (FSD) and Non-Functional Requirement Documents .
• Developed Interaction diagrams, Communication diagrams, and Process Flow diagrams using MS Visio and conducted Focus Groups of users to elicit user requirements for enhancement of the billing monitoring application.
• Created Project Functional Specifications (PFS) detailing software requirements using Context diagram, System Use Cases, and detailed featured requirements.
• Created Use Cases and Business Use-Case Models and analyzed project scope and business processes.
• Established Requirements Traceability Matrix (RTM) using Rational Requisite Pro to trace the completeness of requirements in different SDLC stages.
• Assessed risks and opportunities associated with product life cycle, using Porter’s 5 forces, SWOT analysis, TOWS Matrix, and BCG Industry Attractiveness Matrix.
• Coordinated the execution of Unit Testing, System Integration Testing (SIT), Performance & Service level testing and User Acceptance Testing (UAT).
• Utilized Unified Change Management tool to track changes to multiple artifacts by versioning artifacts, associating requirements to specific change request/defects and to streamline the defect/change tracking process.
• Used various SQL commands like Create, Delete, Update, and Inner, Outer, Left, and Right Joins to update the database and retrieve data for data analysis and validation.
• Reviewed the application with Branding and Legal teams to ensure adherence to set corporate guidelines.
• Created Dashboards and Scorecard reports involving KPIs using SSRS and MS SharePoint.
• Developed SSIS packages using Fuzzy Lookup, Pivot Transformation, and Derived Column to cleanse data.
• Worked with the QA team to create Test Plan and Test Cases and conduct Unit, Integration, and System testing. 
• Documented Test Plans, Test Scripts, Log Defects, and Requirements and uploaded to HP Quality Center for future follow up and bug fixing purposes.
• Participated in weekly Conference Room Pilot (CRP) sessions, to identify software workarounds.
• Prepared Business Process Models that includes modeling of all the activities of the business from the conceptual to procedural level. Involved in creating various documents such as Use case, Business Requirements and Functional requirement specifications.
• Conducted UAT (User Acceptance) Testing. Provide end user training and extensive go-live assistance. Provide solutions to users via phone/email by providing them with screen shots of the different screens, which helped them in understanding the process at a much faster pace.

Environment: Mockup Screens, MS SQL Server 2012, IBM Requisite Pro, Rational Rose, SSRS, SSAS, SSIS, MS Visio, MS SharePoint 2010/ 13, MS Project, Visual Studio 2010, QTP, HP ALM (QC), Tableau, Teradata

Confidential, Jersey City, NJ

Sr. Business Analyst

Responsibilities:

• Created and updating Merchandising Reports and Price file database .
• Actively involved in writing T-SQL Programming for implementing Stored Procedures and Functions and views for different tasks.
• Gathered Business and Functional requirements for integration of POS System with Retail Supply Chain system and developed Functional Requirements Document (FRD), Systems Specifications Document (SSD) and Statement of Work (SOW) to document capture requirements.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Developed UML diagrams, including Use Case Diagrams, Activity Diagrams, Class Diagrams, Data Flow Diagrams, Business   Process Diagrams, Wireframes, Sequence Diagrams and GUI elements, using MS Visio .
• Created Requirement Traceability Matrix (RTM) to keep stakeholders informed of the project status.
• Created Problem Statement Matrix to identify business opportunities and problems.
• Prepared and analyzed AS IS and TO BE in the existing architecture and performed GAP Analysis.
• Reviewed current Service Level Agreements (SLAs) to develop Business Impact Analysis (BIA), Feasibility Study, and To-Be Use Case diagrams.
• Developed Test Cases, Test Plans, and Test Scenarios and performed Unit Testing and User Acceptance Testing (UAT) for cloud-computing business requirements and technical specifications.
• Developed Business and Process Flow Diagrams to analyze the As-Is and To-Be models of business processes.
• Designed and analyzed OLAP cubes in SSAS using Snowflake and Star Schema designs.
• Prepared Logical Data Models that contained set of Entity Relationship Diagrams and Data Flow Diagrams and supporting documents and descriptions of the Relationships between the data elements to analyze and document the Business Data Requirements. 
• Created SSRS and Cognos to create reports including, Drill Through, Tabular, and Ad Hoc Reports and deployed them to MS Sharepoint Server 2013.
• Analyzed and executed various reporting objects, including Facts, Attributes, Hierarchies, Filters, Prompts, Groups, Transformations, and Parameters in Tableau.
• Adopted RUP and Agile/ Scrum as the hybrid methodology for system development focusing on best practices; iteration, requirement management, uses component-based structure, quality verification and change control.
• Created the following types of required documentation: Validation Specifications & Plans, Functional Requirements Specifications, Installation Qualification Specifications, Installation Qualification Summary, Functional Test Summary, Validation Summary, SOPs, Change Control Documentation.
• Designed Technical Documentation as per Six Sigma Standards and release review decks for the evolving application.
• Created and updated User Interface (UI) wireframes and prototypes and UI specification documents.

Environment: MS SQL Server 2012, IBM Requisite Pro, Rational Rose, SSRS, SSAS, SSIS, MS Visio, MS SharePoint 2010/ 13, MS Project, Visual Studio 2010, QTP, HP ALM (QC), Tableau, Teradata, TIBCO Spotfire.

Confidential, Santa Clara, CA

Sr. Business Analyst

Responsibilities:

• Designed Mockup Screens and Use case diagrams using MS Visio to present a better view of the system and enable the technical team to identify the key processes
• Developed Data Flow diagrams, Communication diagrams, and Process Flow diagrams using MS Visio.
• software requirements using Context diagram, System Use Cases, and detailed featured requirements.
• Created Use Cases and Business Use-Case Models after analyzing the project scope and the business processes.
• Established Requirements Traceability Matrix (RTM) using Rational Requisite Pro to trace the completeness of requirements in different SDLC stages.
• Responsible for development, implementation and Support of various RDBMS (oracle) based IT projects related to ETL, Data warehousing, and Data marts.
• Assessed risks and opportunities associated with product life cycle, using Porter’s 5 forces and SWOT analysis.
• Coordinated the execution of Unit Testing, System Integration Testing (SIT), Performance & Service level testing and User Acceptance Testing (UAT).
• Gathered business requirements through review of existing artifacts, user interviews, prototyping, job shadowing of Account Agents and served as a liaison between Claims Approval and IT team in analyzing business needs.
• Assisted testers in planning test strategies and performing defect tracking, using Rational ClearQuest.
• Developed Risk Register/ Risk Log to perform project risk assessment by capturing and prioritizing risks, and supported the Program Manager in developing effective risk management plans.
• Designed Business Use-Case diagrams to identify the business processes and actors impacted by the web system.
• Reviewed and analyzed the Business Requirements Document (BRD) to derive the Functional Specifications Document (FSD) and System Requirement Specification (SRS).
• End-to-end experience in designing and deploying data visualizations using Tableau and TIBCO Spotfire.
• Developed SSIS packages using Fuzzy Lookup, Pivot Transformation, and Derived Column to cleanse data.
• Worked with the QA team to create Test Plan and Test Cases and conduct Unit, Integration, and System testing. 
• Designed and deployed rich graphic visualizations with Drill Down options and prepared Dashboards, using Parameters and Calculations in Tableau.

Environment: MS Excel, MS Project, MS SharePoint 2010, Tableau, MS Access, MS Visio, Rational Rose, MS Visual Studio 2010, HP Quality Center 9.2, IBM Requisite Pro, Rational ClearQuest, Cognos BI Suite, Tableau

Confidential, Chicago, IL

Business Systems Consultant

Responsibilities:

• End-to-end experience in designing and deploying data visualizations using Tableau and TIBCO Spotfire.
• Designed Project Scope & Need Analysis documents from requirements gathered through JAD and observations.
• Performed Change Request Management by preparing System Change Request (SCR) and developing Change Schedule, and conducted steering meetings with Change Advisory Board (CAB) to obtain their approval.
• Enterprise reports using SQL Server Reporting Services (SSRS) and Excel pivot tables which make use of multiple value section in parameters pick list, cascading prompts, matrix dynamic reports.
• Created Data Stage jobs to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files etc.
• Integrated RequisitePro with ClearQuest and Rose to provide all teams visibility and maintain tractability among requirements, use cases and change requests
• Develop and deliver dynamic reporting solutions using SQL Server 2005 Reporting Services (SSRS)
• Extensively used Report Wizard, Report Builder and Report Manager for developing reports and deploying reports in SSRS and Crystal Reports.
• Wrote complex SQL statements using joins, sub queries and correlated sub queries.
• Created SSIS Packages using Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel
• Extensively used SSIS transformations such as lookup, merge, derived column, data conversion and aggregate etc.Reviewed Design Documents, Requirements Analysis Specifications with Project Lead, Business Process Owners and Cross-functional Team Leads.
• Creation of tables, views, Indexes and establishing the relationships between the tables and design the star schema using SQL Server 2012.
• Involved in creating complex table, matrix, sub reports and chart reports using SSRS.
• Mentored offshore team for any technical aspects and test offshore deliverables on both SSIS packages and SSRS reports and published SSIS packages and SSRS reports in testing and production.
• Involved in requirements analysis and attended requirements review meetings.
• Designed Meeting Work Plan and facilitated virtual project meetings to validate requirements with the concerned Subject Matter Experts (SMEs) and IT Team during the entire project.

Environment: MS SQL Server 2008/R2, Oracle 10g, MS Project, MS SharePoint 2010, HP Quality Center, Crystal Reports, SSRS, SSIS, Windows XP, QTP, MS Visio, UML, RUP, Rational ClearCase, PL/SQL, Tableau, QlikView, Teradata, IBM Cognos, Rational ClearQuest

Confidential

Business Analyst/ Jr. Finance Manager

Responsibilities:

• Created SSIS packages to load data into Sql Server using various transformations in SSIS.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into Database and Billing Systems.
• Extract the data from various sources like SQL Server, Text files, and access into Data Warehouse.
• Works with SQL Server, SSIS technologies and has a good Data Warehouse knowledge and tools.
• Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Worked on Performance tuning of ETL transformations, data validations and Stored Procedures.
• Facilitated Sprint Planning as Scrum Master for multiple Scrum teams to ensure successful completion of sprints.
• Identified and documented Functional and Data Requirements, and User Stories as per the Scrum framework.

Environment: MS SharePoint 2007, MS Visio, MS Project, Rational Rose, Rational Requisite Pro, Windows 2000/XP, MS Visual Studio 2008, MS SQL Server R2, UML, Oracle 10g, LoadRunner 9.10, MS Project, MS Excel.

Confidential

Data Analyst

Responsibilities:

• Prepared SWOT, Cost Benefit analysis and Problem Statement Matrix to identify the business risks.
• Created and documented deliverables including requirements definitions, hosting and maintenance agreements, RFPs, engagement contracts, strategy decks, style guides, creative briefs, wireframes and project post-mortems.
• Created Drill Down, Cross-Tab, and Bar Diagram reports using SSRS and deployed reports to MS SharePoint 2007.
• Filtered data using complex T-SQL statements, and implemented various constraint and triggers for data consistency
• Created Table, Stored procedures and defined functions. Created SQL scripts for Tuning and scheduling.
• Developed, modified, and optimized complex stored procedures, triggers to handle complex business rules, history data and audit analysis.

Environment: SQL Server 2005, SSIS, T-SQL, SSRS, SSAS, MS Visual Studio 2005, Windows 2000/XP, MS Excel, MS Access, Cognos BI 8.0 (Report and Metric Studio), Java, RUP, Crystal Reports, HP Quality Center 9.2, C++