SUMMARY:

• Certified Scrum Master and Six Sigma professional with over 12+ years of IT experience in Business & Data Analysis
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration and Metadata Management
• Experience in various phases of Software Development life cycle (Analysis, Requirements gathering, Designing) with expertise in documenting various requirement specifications, functional specifications, Test Plans, Source to Target mappings.
• Experienced with full Software Life cycle from requirement analysis through user acceptance testing to production deployment and support.
• Distinct skills in Business Analysis, Business Modeling, Requirement and Gap Analysis, Risk Analysis, Quality Assurance, Quality Control, which are in line with the Industry Standard Best Practices.
• Responsible for all business team activities associated with each project's product deliverable, including client interaction and coordination of implementation deadlines.
• Extensive experience in writing POC (Proof of Concept), Technical design document, Data Modeling, test plans and test cases/scenarios
• Proficient in MS Excel using features like VLOOKUP, Pivot Tables, Formulas etc.
• Excellent knowledge and usage of SAS, Tableau and SQL

TECHNICAL SKILLS:

Agile, Project Management: Off Shore Team Management, Data Analysis, Business Analysis, Quality Assurance, SQL, PL/SQL, Oracle, Technical/Functional Design and Development, Share Point, Google Analytics, CMMI, Team Mentoring, Data Mapping and Requirements Analysis

File Transfers: SFTP

Languages: XML, SQL, PL SQL

Data Modeling: Erwin, Microsoft Visio

Database: Teradata, Oracle and SQL Server

Reporting: SAS, Tableau, Business objects and Crystal reports

Integration Tools: Jenkins

Operating Systems: Windows, UNIX

Testing Tools: Quick Test Professional, JIRA, Version One, DOORS, IBM Requisite Pro, HP Application lifecycle management (ALM), SOAP UI, Cucumber, Clear quest, Selenium

PROFESSIONAL EXPERIENCE:

Confidential, Mclean VA

Lead Business System Analyst

Responsibilities:

• Lead the requirements gathering meeting with the end users.
• Participated in the daily status meeting
• Used Excel’s advanced features like VLOOKUP’s, Pivot Table etc. for data analysis
• Responsible for analyzing the data and preparing the system requirement specification
• Performed data analysis to determine the completeness and accuracy of the data and checked if new data needs to be pulled up/ requested.
• Participated in defect resolution with the developers and testers.
• Tracked and maintained the requirements in Doors.
• Performed data analysis, GAP analysis, data mapping and documentation.
• Worked closely with the testers and developers on the requirements.
• Worked with the ETL developers in implementing the requirements.
• Wrote queries to verify the requirements from the back end.
• Maintained the requirements and test case synchronization between DOORS and ALM
• Assisted the testers with test cases and test plan

Environment: Java, DB2, DOORS, HP ALM, Microsoft Office Suite and SharePoint.

Confidential

Lead Business System Analyst

Responsibilities:

• Prepared the user stories for the HVE application
• Responsible for creating the feature file in cucumber
• Lead the requirements gathering meeting with the end users.
• Participated in the daily status meeting
• Assisted the developers with defect resolution.
• Responsible for preparing the RTM
• Responsible for mapping the data elements in XML
• Performed Gap Analysis on the requirements
• Assisted the developers in understanding the functionality of the application
• Worked closely with the testers in preparing the test cases and test plan for the HVE application

Environment: Agile, Web methods, Java, XML, DB2, DOORS, Cucumber, HP ALM, Microsoft Office Suite and SharePoint.

Confidential

Lead Business Data Analyst

Responsibilities:

• Participated in the daily scrum, sprint review and retrospective meetings.
• Prepared the user manual for new users to understand the functionality of the application.
• Analyzed and Validated the data before loading into the application
• Used Excel’s advanced features like VLOOKUP’s, Pivot Table etc. for data analysis.
• Performed Database testing and testing as per the requirement with understanding the data workflow
• Performed Smoke test to do the primary checks like record counts, Column matching for database and Dashboard testing.
• Developed test cases, established traceability between requirements and test cases.
• Performed data analysis to determine the completeness and accuracy of the data and checked if new data needs to be pulled up/ requested.
• Executed test cases & log results, performed data validation testing as appropriate, tracked defects and participated in defect resolution.
• Performed regression testing on the World RePORT site after each build
• Involved in writing user stories.
• Document epics, user stories, issues, defects using JIRA
• Assigned, and maintained tickets in JIRA for bugs and defects.
• Tracked and maintained all the artifacts related to data analysis and requirements in SharePoint.
• Involved in production deployment and validation.
• Created User Acceptance Test Scripts and acceptance criteria.
• Performed Release Validation testing for core functionality during launch of the application.
• Involved in the data load process.
• Performed data analysis, GAP analysis, data mapping, documentation and implementation.
• Responsible for providing the performance report using New Relic and Google Analytics.
• Responsible for providing the weekly status report to the management on the testing activities.
• Work collaboratively with statisticians and clinical data managers in analyzing the clinical data and generating reports.
• Expertise in designing and creating various analytical reports and Dashboards. Particularly adept in identifying technology solutions for business problems and implementing them.
• Created complex and reusable Macros in making code more efficient and building modular systems.
• Identify and recommend analytics opportunities and new modeling.

Environment: Agile - Scrum, Asp.Net, Angular JS, SQL Server, JIRA, Version One, New Relic, Google Analytics, Microsoft Office Suite and SharePoint.

Confidential

Lead Business Data Analyst

Responsibilities:

• Provided inputs to the test lead for documentation and reporting purposes. Identified, documented and updated testing dependencies and participants.
• Prepared the test plan for the Federal Reporter Project
• Wrote SQL queries to verify the data
• Responsible for providing the client the analytics on the usage of the Federal Reporter and the API site on monthly basis
• Responsible for keeping the artifacts updated in SharePoint
• Reported status on test execution including risks/issues and targets. Updated latest information in regular testing status meetings to ensure smooth test execution and timely issue resolution.
• Manipulates, cleansed & processed data using Excel and SQL.
• Responsible for loading, extracting and validation of the data provided by the client.
• Responsible for all the sprint tasks and keeping the Sprint activities updated in JIRA
• Performed regression test after every build
• Created ad-hoc SQL reports and queries for end-users
• Responsible for preparing the release notes for every release
• Supported production deployment and validation
• Involved in the analysis of the data and other data cleanup activities.
• Developed macros, templates and utilities for data cleaning and reporting.
• Interpret data, analyze results using statistical techniques and provide ongoing reports.
• Analyzed massive and highly complex data sets, performing ad-hoc analysis and data manipulation.

Environment: Agile - Scrum, Asp.Net, Angular JS, SQL Server, JIRA, Version One, New Relic, Google Analytics, Microsoft Office Suite and SharePoint.

Confidential, Rockville, MD

Lead Business Data Analyst

Responsibilities:

• Performed sprint review at the end of each sprint and maintained the backlogs and managed them.
• Prepared User Stories and flow diagrams to assist the developers with the requirements.
• Performed the data analysis and identified the gaps between the as Is and to Be environments.
• Involved the data modeling and used ERWIN to update the changes.
• Conducted bi-weekly backlog grooming sessions with the team.
• Analyzed the PGA XML message sets using Oxygen XML.
• Performed Gap analysis between the as Is and to Be transactions
• Wrote SQL queries using Toad to analyze the table structures.
• Tracked and Managed the requirements in Requisite Pro and generated a report for RTM.
• Assisted the testers in preparing the test cases.
• Tracked and maintained the defects in JIRA.
• Managed the QA team provided guidance on the requirements clarification.
• Involved in User acceptance testing and assisted the users with test scenarios to be tested.
• Prepared the data flows charts as how the interaction occurs between the two agencies.
• Extensively used MS Excel (VLOOKUP’s, Formulas etc.) for data analysis.
• Assisted the PM with project management plan, Project schedule, Communications management plan and Risk management plan.
• Identified and provided mitigation plan for Issues and Risks found.
• Prepared the risk management log and tracked the issues/risks as the project progressed.
• Interacted with CBP and FDA stakeholders and communicated the requirements.
• Analyzed and prepared the Proof of concept documents for the testing approach.

Environment: Agile - Scrum, SAS, Oracle 11g, Oxygen XML, HP ALM, JIRA, Requisite Pro, Toad, Soap UI, ERWIN, Microsoft office suite and SharePoint.

Confidential, New York, NY.

Senior Business Data Analyst

Responsibilities:

• Worked with Cross Functional Teams and interacting with all levels of management for requirements, resources and project status.
• Involved in writing test plan, test cases and test scripts for end-to-end testing.
• Served as the primary contact for developers and other team members for Functional/Technical requirements specifications throughout the project cycle.
• Developed test cases, established traceability between requirements and test cases.
• Responsible for keeping the artifacts update to date
• Assisted the developers in bug fixing and understanding the business rules of the application.
• Verified the requirements from stakeholders and conducted UAT to validate the results.
• Identified and resolved Quality Control issues and communicated to respective team for resolution.
• Conducted walkthroughs with the testing team to clarify the requirements and reviewed the test plans and test cases.
• Assisted the QA team to facilitate the testing of changing requirements test cases.

Environment: MySQL, ASP.net, Unix, HP Quality Center 10.0, Windows NT, Windows 2010, DB2, WebSphere, MS Office, Excel, Visio and MS Project

Confidential, New York, NY

Senior Business Data Analyst

Responsibilities:

• Wrote the complete functional requirement document and technical design document.
• Interacted with the business user in analyzing the data and the required attributes to be fetched.
• Assisted the data modeler with the logical data modeling and Physical data modeling.
• Involved in the complete analysis of the data and the mapping process.
• Coordinated meetings with the API and the web services team.
• Assisted the developers with the coding, stored procedures and in the table loading process.
• Performed the analysis using Teradata 13.
• Used Teradata SQL assistant to execute the queries from the tables.
• Tested the application both from the API and web services side.
• Captured all the test scenarios and tested the data end-to-end.
• Involved in performing all the testing types - Ad-hoc, Smoke, Unit, Regression, UAT and Prod Testing.
• Created and maintained the Change management tickets in the IT Service Manager.
• Prepared the project plan and kept track of the RAG status in the Share Point to report to the senior management on the project status.
• Extensively used various SAS report generating procedures such as PROC FORMAT, PROC GPLOT,
• PROC
• Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS tools.
• Responsible for querying and fetching the Test data from the table to the testing team on a daily basis.
• Facilitated the communication between the business users and the offshore team for any question related to the requirements.

Environment: Teradata 13, SAS, Web services Studio, Unix, HP Quality Center 10.0, Windows NT, Windows 2010, DB2 V8.1.1, WebSphere V6, Business Objects, MS Office and MS Project.

Confidential - Boston, MA

Quality Analyst

Responsibilities:

• Created test documentation and test cycles.
• Involved in the functional walk through meetings and discussed QA environment requirements.
• Involved in designing the Test Strategy and Test Plan in Test Director by analyzing the requirements document.
• Developed functional test procedures to validate features as end user perspective, accordingly to the application needs.
• Developed various Test Cases based on the Test Plan, covering the requirements.
• Performed functional and regression testing based on business requirements.
• Performed Integration testing to validate integration between sub modules of the application.
• Used CVS Tracker effectively to manage and track issues.
• Performed Release Validation testing for core functionality during launch of the application.
• Tracked the defects in Test Director. Organized meetings to prioritize the issues with the development teams.
• Developed Test Scripts in Quick Test Pro for Functional Testing of the application.
• Participated in the building of quality control plans, strategic directions, standards, processes and procedures

Environment: ASP.Net, C#, Win Runner 7.0, TestDirector7.2, Informatica, Cognos Report net, Windows NT, Windows 2003, Microsoft Access, Oracle, SQL Server. ASP.NET and C#.