SUMMARY:

• Over 9+ years of industry experience as a Business Analyst. Experience in working with SDLC methodology and project life cycle. Strong Knowledge of UML, Rational Suite including, Requisite Pro.Strong communicator and creative problem - solver skilled at analyzing business needs and transforming them into technical designs, applying technical skills and business knowledge to achieve sound results. working with data processes, documentation, working in SQL queries, workflow, and reviewing reports. Experience in using SQL queries against databases for data retrieval, data validation, and data quality testing

TECHNICAL SKILLS:

Cloud Technologies: Microsoft Azure, MS Office 365, AWS - Amazon Web Services .Methodologies: Waterfall, Agile Scrum, Kanban.

Scheduling: Control-M, Tivoli, Autosys.

ETL: Talend, SSIS, Azure Data Factory, DataStage, Informatica, Ab Initio.

Jira Test Management Plugins: Golive, Zephyr, Xray and TestFLO, QMetry, QAlity.

Business Intelligence: Microsoft Power BI, Alteryx, Tableau.

Databases: SQL Server, Oracle, DB2, MySQL, Teradata.

Testing Tools: Rational Enterprise Suite, Test Director, WinRunner, LoadRunner

Change Management Tools: Rational Clear Quest, Test DirectorBusiness Modeling Tools, Microsoft Visio.

EXPERIENCE:

Sr. Business Analyst

Confidential, McLean, VA

Responsibilities:

• Create test plans, test cases, tracked defects, and conduct a session for UAT.
• Perform production verification for release.
• Participated and facilitated in the sprint sessions to add/modify/change any requirements based on the customer request as per the SDLC process.
• Maintained the protocols of SharePoint architecture, permissions, and hierarchies for each contributor.
• Designed a new augmented data warehouse utilizing the Informatica suite and Oracle database software.
• Used JIRA, an issue/bug/project tracking tool to maintain different system builds.
• Elicit business requirements from subject matter experts (SME) representing different lines of business.
• Conducted JAD and facilitated brainstorming sessions with a diverse global group of SAP Users and Consultants to understand users' requirements.
• Performed Requirement Analysis and developed UML Use Cases, Activity Diagrams to understand the requirements.
• Maintain requirement specifications, test plans, test executions, and test results within the Test Management suite.
• Created Process Workflow, Activity diagrams, and Sequence diagrams.
• Performed gap analysis and developed a spreadsheet identifying the changes
• Automated the test scripts for the GUI, functional, performance, and regression testing using Win Runner on the Windows NT platform.
• Traced test cases and functional specifications to software system requirements and Business Process Requirements using Rational Requisite - pro.
• Experience in designing prototypes for different in-house built modules of applications from scratch for User Interface Framework.
• Assisted Lead QA in preparing a detailed test plan as well as Test scenarios and Test Cases, test execution plan.
• Analyze data in Oracle by using SQL and data in flat files and in other formats for integration purposes.
• Experience as Business Analyst, Data analytics, VBA developer
• Good command over MS Visio, MS Access, MS Excel, VBA, SQL
• Understanding existing pricing engine which is developed using Ms Excel and Ms Access database (VBA coding)
• Extracting business logic from existing application.
• Used the waterfall methodology for software development.
• Developed Use Case Diagrams, Activity diagrams, Sequence Diagrams, Class Diagrams, and Collaboration Diagrams using Visio.
• Participated in key agile ceremonies, worked on a Scrum team delivering working software in a two-week sprint.
• Experienced in data analysis and debugging.
• Perform data analysis to validate Detailed Accounting Ledger (Opera/DAL/SPEL) Key Processing Enrichment function specifications.
• Provide requirements and design and support the implementation of a SQL database.
• Skilled in performing gap analysis and impact analysis by identifying existing technologies, documenting the enhancements to meet the end-state requirements.
• Develop and maintain an MS SharePoint site for project management documentation.
• Create data quality engine to let accurate and correct data into PIMS data warehouse through ETL process and inaccurate data.
• Created design documents from gathered requirements.
• Analyzed trading partners' specifications and created EDI mapping guidelines.

Sr. Business Analyst

Confidential, Bloomfield, CT

Responsibilities:

• Gathered, captured, and documented requirements from business and created use cases, test scenarios, and test scripts from them.
• Acted as a liaison between the business and technology teams in the planning phase of the Software Development Life Cycle (SDLC).
• Prepared activity diagrams and flow charts for repeatable child elements identified in ONIX 2.1 using MS Visio 2010.
• Involved in Agile development and participated in everyday Scrum meetings.
• Prepare Use Case scenarios using MS Word, PowerPoint for better presentation and understanding of the application.
• Document defects in JIRA. Use Rally issue tracking systems and interfaced project management and development team to expedite resolution.
• Standardize test scripts composed and submitted process improvement guidelines to management and mentored incoming associates.
• Conducted analysis and successfully documented multiple business processes of several applications to improve efficiency and productivity.
• Created UML - based use case models and activity diagrams, and usability analysis/user interface.
• Participated in Waterfall to Agile transition projects including Scrum meetings, pair programming, and Interactions development.
• Perform detailed data analysis to propose efficient logic that meets the internal customer's business needs as per data warehouse standards.
• Facilitate the daily operations as they relate to SDLC processes and documentation of multiple large in-house developed applications.
• Conducted interviews and user meetings with key users to collect Business Requirements and business process information.
• Interacted with Interface Design Specialist to get the suggestion/approval for the user interface developed in the application.
• Present and discuss the test results with the Business Users in order to obtain the UAT approvals and QA Sign off.
• Used SQL and Access to data-mine information increasing the software asset management catalog and analyzing and reconcile discrepancies.
• Provide additional hands-on in technologies like JIRA, Confluence, and SharePoint.
• Performed analysis on Data warehouse, and Metadata for FROI/SROI to identify errors in transactions to state jurisdictions.
• Adopted and used JIRA to administer ticket resolution and project stability.
• Provided ongoing assistance and guidance to SME's and updates to senior stakeholders.
• Participated in the JAD sessions to gather, analyze, and document requirements for the mobile application for the Safety Measurement System.
• Performed UML modeling and created UML specifications such as Use Cases, Activity Diagrams, and Sequence Diagrams.
• Assisted informational needs in the mapping of Test Cases and maintaining Test Matrix with the test results obtained.
• Prepared Activity diagrams as part of the requirements gathering process.
• Researched and wrote requirements/design documents.
• Created RACI/Matrix and Project plan for daily EDI processes.

Sr. Business Analyst

Confidential, St.Louis, Missouri

Responsibilities:

• Created test scripts for clients to aid in UAT and scheduled and conducted UAT for clients in a controlled environment.
• Present business process improvement analysis reports to senior management weekly for review of findings and recommendations.
• Participated with leads to develop the prototypes and improvise the user interface with the system.
• Participated in QA and development meetings, requirements gathering, reviews, and client working sessions to understand requirements and system design.
• Developed & executed several Optimized queries in SQL on this data and created report template using SSRS reporting tool.
• Designed and executed quality test scenarios, test plans, and test scripts to verify reliability, accuracy, and compatibility of the application.
• Created the design of the data warehousing Snowflake schema logical database model.
• Established report specifications, cube and ETL by working with the Data Architects. Used Six Sigma and tools for profiling, data mapping and monitoring data by tracking and improving enterprise data.
• Ran SQL queries against SLX database using SQL Navigator for data retrieval, data validation, and data quality testing.
• Collaborated with clients to improve the business process, including opportunities for improvement and optimization of the business process.
• Provided input into user interface layouts and created screen mock - ups and user interface prototypes with SnagIt and MS Word.
• Execute the test plans and worked closely with the system developers using an agile software development method in a test environment.
• Generated analysis artifacts such as Business Specification Document, Use Cases, and Use case diagrams using MS Visio.
• Attended Daily Stand Up meeting for the project and worked with Scrum Board for updates/issues related to project.
• Worked in tandem with the data analysis team to generate the weekly, biweekly, and monthly reports from the SAS reporting tool.
• Worked throughout SDLC, including requirements, specifications, design, analysis
• Used MS SharePoint Services as a project document repository and document management tool.
• Key Responsibilities: Lead systems analyst for Anti Money Laundering and related Data Warehouse project.
• Consolidated issues to JIRA followed up and retested.
• Participated in all the phases of SDLC, starting from requirements gathering, design, development, testing, and implementation phase.
• Involved in Defect Tracking and Report generation using JIRA.
• Created detailed various UML models including Use Case Diagrams, Activity Diagrams, and Sequence Diagrams while working with software developers to ensure applications fit in to the requirements.
• Worked on the business flow and account relationships in accordance with the specific databases and tables involved in progress.
• Defined roles/security models for the portal application with help of SMEs and data architects.
• Gathered and analyzed business requirements by facilitating JAR/JAD Sessions.
• Developed functional requirements and specifications for the software development team.
• Created Use Case Diagrams, Data Flow Diagrams, Activity Diagrams and Sequence Diagrams in MS Visio.
• Gathered business requirements and documented requirements and design documents.
• Collected business requirements from project shareholders and Subject Matter Experts (SME).
• Coordinated and conducted JAD sessions with the technical development staff to scope the project and identify all affected system functionality.
• Translated requirements document into functional specifications and object models for the development group using UML.
• Reviewed and analyzed test results to confirm, establish, and communicate the cause of discrepancies.
• Designed Sequence diagrams for all the identified use cases.
• Reviewed design documents from multiple vendors by partnering with technical architects to assure that technical models are aligned with business models.

Business Analyst

Confidential, Bloomington, IL

Responsibilities:

• Create Business Requirement Documents, User Requirement Specification, Functional Requirement Specifications, Data Flow Diagrams, Use Cases, State Diagrams, Sequence Diagrams, Component Diagrams and Activity Diagrams.
• Perform production verification for release.
• Meet with business users helping to generate requirement documents, test plans and coordinate/conducted UAT.
• Involved in Agile development and participated in everyday Scrum meetings.
• Prepare Use Case scenarios using MS Word, PowerPoint for better presentation and understanding of the application.
• Document defects in JIRA. Use Rally issue tracking systems and interfaced project management and development team to expedite resolution.
• Standardize test scripts composed and submitted process improvement guidelines to management and mentored incoming associates.
• Conducted analysis and successfully documented multiple business processes of several applications to improve efficiency and productivity.
• Created UML-based use case models and activity diagrams, and usability analysis/user interface.
• Prepare documents to conduct User Acceptance Testing.
• Perform data analysis to validate Detailed Accounting Ledger (Opera/DAL/SPEL) Key Processing Enrichment function specifications.
• Provide requirements and design and support the implementation of a SQL database.
• Skilled in performing gap analysis and impact analysis by identifying existing technologies, documenting the enhancements to meet the end-state requirements.
• Develop and maintain an MS SharePoint site for project management documentation.
• Create data quality engine to let accurate and correct data into PIMS data warehouse through ETL process and inaccurate data.
• Create test plans, test cases, tracked defects, and conduct a session for UAT.