We provide IT Staff Augmentation Services!

Lead Business System Analyst Resume

Mclean, VA

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#.

Hire Now