Abi P. Email and Phone Number

Worked on defined objectives, while considering constraints on budget, time, resources, and technology.Gathered User Requirements, created requirement specification documents and Use Case models.Gathered budget and schedules from various groups to develop initial budget and project schedule to develop project business case and Cost-functionality documents.Met with various product Owners to determine the business need and goals.Attended Change request meetings to document changes and implemented procedures to test changes and documented using Azure devops.Used Visio to create business processes, business flow diagrams and workflow diagrams.Prepared a schedule and workflow for the development team using MS Project.Tasked with developing complex SQL queries for reporting needs.Followed standard methodology for planning, monitoring, and controlling a series of Extensively Facilitated meetings/conference calls with stakeholders, Project managers, developers, QA analysts and other end users based onsite/offshore to deal with business and technical issues and resolving the issues.Worked on Requirements traceability to analyze the impact before the change is made and determine the components being affected.Created Test cases and Test scripts for System Integration Testing (SIT), User Acceptance Testing (UAT) and Unit Integration Testing performed Unit Testing at various stages by checking the data manually.

Captured and managed business requirements for the release along with the business process and developing the functional requirements specifications document.Arranged and attended meetings with Business Owners, Project Sponsor and other Business Stakeholders.Prepared workflow and analyzed AS IS and TO BE scenarios, designed new process flows and documented the business process and various business scenarios using MS Visio.Collaborated with cross-functional teams to gather business requirements related to ongoing development using Agile Estimating and creating user stories.Analyzed business requirement documents and created use cases, use case diagrams, Sequence diagrams, and activity diagrams using MS Visio. Interacted with the Users, Technology teams, Functional and Quality assurance reviews. Prepare and maintain the Traceability matrix to continuously track progress.Worked very closely with Customers, End users and powered users collect requirements and document future state processes for Incident Management, Change Management, Knowledge Management and Service Request Management.Coordinated with Data Architects and enterprise architects regarding the analysis and design for application development to ensure optional operational performance that meets business needs. Led daily stand-up meetings, story card estimation, sprint planning, and project prioritization with Business Application Owners. Created Sprint Backlog and managed User stories in JIRA and MS Azure.Document ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.Worked on source to target mapping documents and used SQL Server to run queries.Documented requirements for MS Power BI reporting to help the business make informed decisions.Involved with developing Project Status Matrix for weekly evaluation of project status.

Involved in business stakeholder interviews for gathering and documenting data related pain points and requirements for Master data management project and conducted data profiling and data mining to gather factual data for data anomalies listed during interviews.Participated in Daily Scrum Meetings as well as other Scrum ceremonies like Sprint Planning and Sprint Review Meeting. Identified and executed robust and continuous improvement opportunities within the data management processes in the applicable systems.Assisted the Business stakeholders with their day-to-day information and data needs.Collaborated with quality assurance (QA) team, ITSME (IT subject matter expert), Cloud data architects, ETL integration specialists, Project Management team and BI dashboard development team.Created standard templates for requirement traceability matrix, technical design documentation and source to target mappings consumed by ETL and reporting developers.Resolved service now tickets in given SLA opened by business related to data analysis.Performed data integrity checks, report anomalies, and work with development teams for resolution.Prepared and presented visualizations, action reports, open risks and open issues reports, active project and project status reports using PowerPoint, Excel (Pivots, charts), SQL and Tableau.Integrated data from multiple sources to data warehouse from different system of records/source system includes relational data base, API data, IOT data, file base data.Created complex SQL logic to extract data in necessary structure to create data sets for quick reporting needs.Responsible in creating XML, JSON, sample data schema files for MuleSoft integration architect to consume in their IDS and utilize them during application integration.Document ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling.

Implemented and followed a Scrum Agile development methodology within the cross functional team and functioned as a liaison between the business user group and the technical team.Worked with the Scrum Team and product owner to negotiate the minimum viable product for delivery.Gathered business requirements using Joint Requirement Planning (JRP), Joint Application Deployment (JAD) sessions and JAR sessions with Business Process Owners, SME (Subject Matter Experts) and end users for Requirement gathering in various project stages.Coordinated with the stakeholders and project key personnel to gather functional and non-functional requirements during Design Sprint sessions. Studied the existing business process and created AS-IS and TO-BE workflow to illustrate the existing system. Designed current state and future state conceptual and logical data model for existing and new application.Work as a liaison between the Business team and IT team to translate business requirements and set project expectations.Coordinated and participated in estimation meetings to provide high-level estimates (story points) for Backlog stories.Work with the Scrum master in Iteration planning and backlog grooming activities to manage project priorities and deliverables. Help in deciding the MVP (most viable product) for the release. Designed and developed SQL database tables, views, indexes with proper privileges and maintained and updated the database by deleting and removing old data.Involved in Data flow analysis, Data modeling, Physical database design, forms design and development, data conversion, performance analysis and tuning.Coordinate with internal, divisional, and outside organizations to facilitate data management.Developed SQL queries for modifying (insert, update & delete) records, experience developing SQL scripts on multiple tables for data extraction.

Captured and managed business requirements for the release along with business process and developing the functional requirements specifications document in both Agile Scrum and waterfall environments.Mediated between stakeholders, development teams and management for solution assessment and validation requirementsConducted analyses to identify business use cases, capability requirements, and digital, technology & data dependencies to support the team’s key strategic initiativesPerformed various financial/quantitative analyses including the complex data research, data mining, data exploration, statistical reporting, and data analysis methodologies to identify trends in large data setsInterpreted business feedback and results to succinctly create compelling recommendations and solutions for senior leadership sponsorship and buy-in.Interacted with the software development team and executive team to liaison the business requirements to ensure that the application under development confines to the business requirement.Developed queries to retrieve data from multiple sources, charts, tables, and crosstabs using SQL.Collaborated closely with teams, project stakeholders, SME to map the expectations to the delivery capabilities and maintain the traceability matrix to track the progress.Created traceability metric based on requirements and documented various procedures on SharePoint regarding requirements from the technical and business side.Analyzed existing scripts and determine business rules, conducting JAD sessions, One on One interview, Questionnaire with the business users.Created Mapping Policy Line of business mapping template, Established Data base Objects from LOB's TablesIdentified the entities and relationships between the entities to develop a logical model and later translated the model into a physical model.Worked closely with the business and development team to deliver the models and mapping document and loading strategy.