SUMMARY:

• A functional Business/ Data Analyst with over 7 years of experience in Requirement Gathering, Data Remediation, Data analysis, Quality Assurance, Testing and Reporting.
• Strong skills to create Functional and Nonfunctional Requirements Document (FRD), Business Requirement Document (BRD) and Use Cases Specification
• Experienced in all phases of the Software Development Life Cycle (SDLC), Waterfall, Rational unified process (RUP), Agile Methodology (Scrum and Kanban methods)
• Professional experience in SQL modification, backend analysis and remediation process
• In - depth knowledge of Data Modeling, Data Mapping, and design using UML and MS Visio.
• Proficient knowledge with BI Tools and reporting packages (e.g. Tableau, BI Power, Qlikview, Pivot Tables, eazyBI, etc.)
• Advance experience in query databases, validate data; programing language: MS-SQL and Python.
• Experience in creating Product Backlog, sprint backlog and managed and updated Issues (Epics, Stories, and Tasks) onto Jira. Participated in Sprint Planning, Daily Scrum Stand up and Sprint Retrospective meetings
• Excellent skills with project management tools such as Jira and Confluence
• Great experience in creating Test Plans, Test Scripts and Test Cases for Functional, System, Integration and UAT
• Solid understanding of SDLC and STLC methodologies in both Waterfall and Agile environments.
• Extensive experience in conducting JAD sessions and workshops for requirement analysis.
• Strong process modeling using UML Methodology and MS Visio (Use Case diagrams, Activity diagrams, Data Flow Diagrams (DFD), Sequence diagrams and Business process flow diagrams)
• Experience in Requirement/Change Management, Impact and GAP Analysis
• Excellent written and verbal communication skills
• Innovative and Analytical Thinker who brings new ideas to the team

TECHNICAL SKILLS:

Databases: MS-Access, MySQL, SQL Server

Tools: MS Visio, Rational Rose, Rational Clear Case, Rational Requisite Pro,

Project Management and Tracking Tools: Jira, HP Quality Center, Rational Clear Quest, Rally

Content Management Tools: Confluence, SharePoint

Utility Tools: MS Office Suite, MS Project

Methodologies: SDLC, Agile, Waterfall, Scrum, Kanban, RUP

PROFESSIONAL EXPERIENCE:

Business System Analyst

Confidential

Responsibilities:

• Created and maintained Business and Functional Requirement Documents for the CARA application during SDLC lifecycle.
• Performed on-going process of data remediation, root cause analysis, UI validation, false positive/true failures identifications in Oracle BI (OBIEE UI) and backend Teradata
• Converted ER diagram to the Relational Data Model for Encore project using MS Visio
• Presented Monthly reports and dashboards for stakeholders via excel, eazyBI tool and Jira for Management Reporting
• Led the team in transition from Waterfall to Agile as an Agile Coach
• Developed, enhanced and monitored data quality within the Customer Due Diligence Application and its business rules
• Worked with Product Owner to define project scope/objectives and managed all Scrum Boards
• Prepared and presented Tableau dashboards to replace the classic Excel reports for monthly Ad-Hoc requests
• Captured and analyzed DQE failures and perform true failure/false positive analysis, root cause analysis using SQL Server to identify remediation/modification/enhancement game plan Demonstrated strong leadership and consulting skills with advanced communications skills level for composing and writing original business documentation and presentations for management
• Developed the business process workflows and technology project requirement document.
• Led and performed the full range of testing activities for in-house developed and third-party systems.
• Designed CARA Test Plan and Test Scripts for 4 different UAT and End User Pilot cycles using ALM Software
• Performed weekly demos for stakeholders and functional teams, conducting UAT defect Triage meetings
• Test lead and UAT Coordinator worked with multiple onshore and offshore testers
• Actively engaged in Agile environment and act as SME to implement the process into project

Sr. Business Analyst

Confidential, Lexington, SC

Responsibilities:

• Prepared Mapping document, data flow diagram, Process flow diagram using MS Visio.
• Built dashboards (using Tableau) that illustrate how key performance indicators (KPIs) and metrics are changing over time.
• Worked with source system developers, SMEs, Data administrators, Data integration team members to determine the data transformation method and required ETL tools for data transfer
• Designed and prepared daily, weekly and monthly reports using MS Excel, Pivot Table and Tableau)
• Created and maintained the Project plan on daily basis in MS Project.
• Ensured post go-live support plan is developed, validated, and implemented.
• Developed ad-hoc analysis in a clear manner and presenting results to the team.
• Developed and executed test scripts using SQL.
• Collected and analyzed data for established customers using SQL.
• Using SQL runtime engine to schedule nightly process running the server jobs, monitoring schedules and validating its components.
• Created user stories for Kanban Boards and sprint meetings.
• Analyzed sales big data after structuring, cleaning, enriching and validating processes using Wrangler software(Data Quality Analysis and Reporting).
• Performed Functional, Regression, Integration, Smoke and Sanity testing using Manual and Automated testing tools - selenium WebDriver.
• Successfully facilitated Project testing in multiple phases.
• Prepared Test Plan for M1 test environment and documented defects using Quality center and JIRA
• Provided technical and procedural support for User Acceptance Testing (UAT)
• Involved in SCRUM Framework using Agile Methodology and Iterative Software Development Life Cycle Process(SDLC)

Business Analyst II/Tester

Confidential, Hartford, CT

Responsibilities:

• Developed, enhanced and monitored data quality within CIRTS system and its business rules.
• Worked closely with SMEs and stockholders to gather business requirement documents needed to enhance current business rule, create business rule and sign off on remediation game plan.
• Captured and analyzed business rule failures and perform true failure/false positive and root cause analysis to remove false positive by enhancing the query and remediating true hits.
• Worked with scrum team and product owner in business side by analyzing immunization data with SQL queries during the agile transition..
• Working closely with QA team to support them in system, integrating, production and regression testing
• Created Gantt Chart for onboarding project to monitor project progress.
• Prepared Demos of Immunization Registry for CT vendors.
• Conducted interviews with the business team to help the state to run the AFIX Project.
• Created Process and Use Case diagrams for IIS project in each sprint in agile environment.
• Participated in root cause analysis and provided solutions for day-to-day process challenges.
• Prepared Requirement Traceability Matrix for UAT for CIRTS. developed Test Plan and test scripts using DPH Test Tracker Tool for the State of CT Immunization Registry.
• Performed Data Quality Analysis to make sure about Data Accuracy and Consistency of the HER data in the CT Data Warehouse
• Performed Immunization data profiling by using ETL tools like SSRS
• Maintained positive communications and working relationships with all team members.
• Involved in full SDLC(designing, debugging, testing, documentation, maintenance and enhancement).

Business Analyst(Digital Consultant

Confidential, Hartford, CT

Responsibilities:

• Prepared the complete data mapping for all the migrated jobs.
• Executed the technical testing strategy and plan for performing QA functions for the Enterprise Data Warehouse Platform.
• Analyzed, gathered, documented testing requirements at an appropriate level of detail suitable for use by data warehouse architects and developers.
• Worked closely with Agile product owner in each sprint daily basis.
• Collaborated closely with other Software Testers, Designers, and Developers in daily scrum meetings in agile environment.
• Developed process flows, charts and graphs for data analysis purposes using MS Excel.
• Engaged with Teradata platform as day to day bases for data manipulation.
• Actively participated for user story planning, to create and update data model.
• Created and manipulated tables in Oracle database based on changes in Business Requirements using SQL queries.
• Ensured that key standards, quality requirements & best practices are followed in all testing efforts.
• Preformed business acceptance testing (BAT, UAT) such as business source data consistency, critical data elements validation, sample data validation, count and column check.
• Developed dashboard from data warehouse in Tableau for reporting and analytic purposes.
• Maintained and proactively update the data warehouse dictionary based on new release.
• Preformed Gap analysis and data mapping analysis in process of data migration.
• Conducted Stress, integration and regression testing.
• Developed and Performed execution of Test Scripts for UI Validation