Sr. Business /data Integration Analyst Resume
3.00/5 (Submit Your Rating)
Dallas, TX
SUMMARY
- Sr. Business Analyst with around 8 years of experience in Event Management, E - commerce, Banking, Retail, Healthcare and Insurance domains.
- Hands-on expertise in all phases of Software Development Life Cycle (SDLC) using Waterfall, Iterative, Agile/Scrum and other internal SDLCs and technology delivery frameworks.
- Excellent skills in Business Analysis, Data Analysis, Requirement Analysis, Business Modeling and Use Case development using UML Methodology.
- Highly proficient in creating Use Cases, Sequence Diagrams, Collaboration Diagrams, Activity Diagrams, Class Diagrams, etc. using MS Visio.
- Created Data Flow Diagrams and Entity Relationship (ER) Diagrams using MS Visio.
- Extensive experience in gathering Business and Functional Requirements (BRD & FRD); creating User Stories; conducting GAP Analysis, Impact Analysis, Cost Benefit Analysis and SWOT Analysis.
- Proficiency in modeling businesses processes and preparing SOPs, training manuals & knowledge transfer manuals.
- Worked extensively on Business Requirements Elicitation, Process Modeling, Risk Analysis and development of Functional Specifications.
- Conducted Joint Application Development/Design (JAD) sessions, interviews, brainstorming sessions and Joint Requirement Planning sessions (JRP) with end-user, clients, stakeholders, development group and Subject Matter Experts (SMEs).
- Expertise in defining and documenting Business Process Flows and AS-IS and TO-BE processes.
- Created technical documentations such as Requirements Documents, Design Document, Test Plans, User Acceptance Test Plans (UAT).
- Experience in Agile/Scrum methodology and Scrum Ceremonies like Sprint Planning, Backlog Grooming, User Story Estimation, User Story Prioritization, Daily Scrum, Sprint Review, and Retrospective Events.
- Strong working experience on tracking and process management tools like JIRA and TFS/VSTS/ADO.
- Facilitated tracking of Sprint and Release by using Burn-down charts.
- Extensively used VSTS and JIRA for maintaining User Story Hierarchy, Backlog Grooming and Updating Tasks.
- Assisted with internal and external communication, improved transparency, and radiated information with prioritization and resolution of software defects.
- Assisted team to remove impediments by having an understanding the control and release processes.
- Knowledge on creating and documenting RFI/RFP documents, technical questionnaires.
- Knowledge on Front End UI technologies like HTML5, CSS3 and Bootstrap and IDE tools like Eclipse and also writing SQL queries.
- Highly motivated, organized and detail oriented with excellent interpersonal, communication and presentation skills.
- Ability to think quantitatively with problem solving approach and prioritize requirements.
TECHNICAL SKILLS
- Agile/Scrum, Waterfall, UML, HIPAA, MS Word, MS Excel, MS PowerPoint
- MS Project, MS Visio, MS Outlook, SharePoint, MS SQL, Quality Center, Oracle
- HP Quality Center, XML, JAVA/J2EE, HTML, CSS, Oracle 8i, HTML, SAP Hybris, Salesforce, ServiceNow, Postman
- Rational Clear Case, SQL Server, Eclipse, JIRA, TFS/VSTS/ADO, Qlik, Brightpod, Wrike, Profisee
PROFESSIONAL EXPERIENCE
Sr. Business /Data Integration Analyst
Confidential, Dallas, TX
Responsibilities:
- Conducted Brainstorming and Focus Group sessions for eliciting requirements from the business.
- Created Epics, Features and User Stories in ADO (Azure DevOps) with Acceptance Criteria based on the requirement gathered and linked it to Parent stories in WIP backlog and moved to the stories to Solution based on priorities provided by the business.
- Conducted Scrum ceremonies like Daily Stand Up, Backlog Refinement, Sprint Planning, Sprint Retrospective and Sprint Demo/Review.
- Troubleshooted production and UAT issues/defects by analyzing the issue and conducting research in FastApp, remote server, SQL DB, Profisee Portal and Desktop.
- Documented data artifacts such as Data Flow Diagram using MS Visio, Source to Target Mapping and documented Business Rules for SFDC project and Profisee 7x.
- Performed data validation using SQL server and FastApp Profisee and resolved data quality issues with the Business team.
- Also supported the business users in creating User Acceptance test plans and scenarios and prepared Go Live checklist.
- Worked with Salesforce (CRM) team and documented requirements, data flow diagrams, data mapping and integration testing for the ‘Look Up Before Create’.
- Performed QA testing as part of the sprint and raised defects in ADO if the functionality was not met as per the Acceptance Criteria.
- Performed exploratory, smoke, regression and integration testing to ensure end to end scenarios meet overall business requirements.
- Worked with the development team in testing the various pipelines and making sure that the file received from D&B via SFTP has the required data.
- Executed SLQ queries to validate the data being populated in the application.
- Provided metrics to the management by using Burn down chart, Scrum board, Sprint Overview, Release Features and Stories, Velocity, Control Charts, etc.
- Elicited requirements from the Product Owner for Stewardship and reporting dashboards based on D&B IDR call that can be viewed by Application & Enterprise Stewards.
- Assisted the IT Team Lead in preparing the release calendar and cadence for the Data Management team projects.
Sr. Business Analyst/Project Manager
Confidential, Richardson, TX
Responsibilities:
- Captured and documented business requirements and process workflow diagrams for system enhancements from global marketing team, engineering team Product Owners and Business stakeholders.
- Prepared BRDs, FSDs and Business Case and created User Stories in VSTS with Acceptance Criteria for various project including SSO Integration using oAuth, Dealer Lead Form, Service Bench Integration (API Integration) for desktop and mobile.
- Collaborated with IT and/or outside vendors to brainstorm and evaluate solutions that meet current and future business objectives.
- Conducted JAD session and brainstorming session with various departments and development team.
- Evaluated business processes and uncovered areas for improvement for the ecommerce department and lead ongoing reviews of business processes and developed optimization strategies.
- As a Project Manager, held daily stand ups with the development and business team and took the project via different phases of reviews and gates ( ADR, SAR and Gate 3) and ensured timely delivery of the project.
- Performed Quantitative Analysis and Root Cause Analysis of customer & transactional data sets to get meaningful insights and improve clients’ marketing strategy.
- Conducted meetings and presentations to share ideas and findings and provided demos to the customers.
- Assisted Senior Manager with MVP planning and preparing presentations for the senior management and also prepared the timeline using MS Project.
- Created reports and performed post pricing analytics to identify profit opportunities for the products that were sold.
- Reviewed price variance charts and metrics to identify new opportunities that can be implemented via new pricing initiatives to management.
- Worked with SAP IT Quality Assurance and SAP team and performed UAT with the customers to test the Order Search and Order Placing API and checking the shipment status, tracking the shipment and availability of the stock.
- Worked with GIS team for SAP integration with Field Management System and helped in analyzing the issues being raised due to web service calls.
- Worked on the User Access Review (UAR) workflow and defined the roles and the responsibilities compliant to company’s internal control policy.
- Assisted the QA team in testing the access controls and performed UAT.
- Interacted with Salesforce and MDM team to gather requirements on the PII data and the format of the data that needs to be displayed to the CSR team and to determine features that need to go into the release and performed UAT for the project by using TouchPoint tool.
- Used Postman tool to test JSON data attributes like Address, Zip code, First Name, Last Name and validate on Proposal tool UI for accurate updates.
- Gathered critical information from meetings with various stakeholders and produced useful reports and designed marketing metrics reports and management dashboards for multiple client accounts using data visualization.
- Documented BRD for credit card payment processing project.
- Worked on Brightpod to make sure that the marketing strategies are being targeted to the right audience with correct messaging.
- Worked on InVision with the UI/UX manager and developers on the wireframes required for the promoting the iframe to the vendors and registration page of the iframe.
- Worked with QA team and assisted them in Test Scripts and overall testing of the form and the iFrame embed and ensuring that the data was stored properly in Azure (Lennox.com cloud server).
- Performed regression testing and smoke testing for Lennox POS.
- Executed SQL Queries for database and end to end testing in the Hybris platform along with Redshift database to test dashboards.
- Extensively performed mobile testing for all the mobile based functionalities like barcode scanning, image upload, add to cart.
- Performed UAT testing and monitored deliverables and ensured timely completion of projects.
- Worked on Wrike to ensure that the training manuals and videos are consistent and resolved issues with the team.
- Used Qlik and Google Analytics to retrieve information about the products used by the customers and get detailed information about the leads coming in, the rate of conversion, views per page and customer drop outs.
- Created Standard Operating Procedures ( SOP), training manuals and How to Guide which included the onboarding process to be followed by the customers.
- Participated in Sprint Planning, Backlog Grooming, Daily Stand Up, Sprint Review and Sprint Retrospective.
- Created Epics, Features and User Stories in VSTS and ensured that the stories are linked properly with the Parent, Child stories and other related stories.
- Used Salesforce as a reporting tool to communicate employees about the latest tools and trends to executive management.
- Served as a liaison between IT and customers and made sure that the onboarding was smooth and helped in troubleshooting.
- Experienced in planning and executing data for online and offline marketing campaigns, including list acquisition, test design, audience selections, and model score applications.
- Constantly communicated with the Manager, client project leaders, and other analysts to thoroughly understand client’s needs, analyze data appropriately and deliver the work products to client’s satisfaction and r aised tickets and incidents in ServiceNow.
Business Systems Analyst/Product Owner
Confidential
Responsibilities:
- Gathered business requirements by working with the customers and coordinated with onsite and offshore implementation teams to build and execute.
- Gathered requirements, business needs and project objectives via feedback sessions and customer meetings in collaboration with all stakeholders.
- Assisted Project Manager in managing project progress, estimating delivery schedule and supporting implementation and application using MS Project.
- Elicited, recorded and analyzed requirements to enable traceability to a desired customer outcome.
- Created as-is and to-be Mortgage process that also included Engagement Indicator Logic, short Sale, Super Letter Projects.
- Used LIBOR as a reference and created stored procedures based on them for calculating the interest rates for the mortgage.
- Analyzed SOFR historical data needs for valuation, pricing system and model updates.
- Conducted product exposure analysis to determine the LIBOR linked exposures for each line of business including off-balance sheet exposure such as Line of Credit.
- Developed test plans with QA team and helped to develop test scenarios according to different report needs for system testing and performance testing and used qTest to manage test cases.
- Reviewed test cases, maintained the Requirement Traceability Matrix (RTM) to ensure appropriate documentation is in place.
- Documented functional design specifications using UML models including Use Case Diagram, Activity Diagram and Sequence Diagram, and collaborated with software architects and developers to ensure that the applications conform to the requirements.
- Performed detailed data validation prior to reporting data to higher management and resolved data quality issues with the Business team.
- Prepared data mapping documents as per the FDX standards to support ETL process and involved in building data models to construct staging warehouse for dictionary entries and reporting purposes using Informatica.
- Performed detailed data validation prior to reporting data to higher management and resolved data quality issues with the Business team.
- Facilitated aggregation of stress forecasts under the Baseline, Adverse and Severely Adverse scenarios.
- Maintained Traceability Matrix for the current business processes and proposed changes.
- Coordinated with Project Manager to define project scope, major features, risks, developed project time lines and did business process management.
- Analyzed and researched on the paper documents about investing reports requirements.
- Conducted UAT, documented and reported user feedbacks to management team, and created user manuals included the explanation of different reports and how to execute.
- Participated in all the scrum ceremonies like Sprint Planning, Backlog Grooming, Daily Scrum, Sprint Review, and Retrospective Events.
- Stored the requirements documents and other project artifacts in SharePoint
