Saksham Nirula

ad0gh3@r.postjobfree.com 469-***-****

SUMMARY:

Business analyst with 7+ years of experience in the Information Technology, logistics, Health Care and Banking domain.

Expert in writing, reviewing, and executing Test cases and have exposure to all stages of SDLC and Agile/Scrum Methodology.

Key strengths include requirements gathering, process analysis, project planning, tracking, and delivery; estimation; issue and risk management; documentation; and setting up robust reporting, measurement, escalation, and communication mechanisms.

Successful in translating business requirements and user expectations into detailed specifications employing Unified Modelling Language (UML) using Rational Rose & MS Vision.

Proficient in creating various documents like Business Requirements Documents (BRD), Functional Requirement Documents (FRD), Functional Specification Documents (FSD), and Systems Requirements Specifications (SRS)

Defining security architecture for APIs to prevent unauthorized access.

Progressive IT experience focused on requirement gathering, documentation of current & future state, Test Planning, leading & execute UAT with business users, documenting and tracking issues, root cause analysis, data analysis, reporting, and post implementation.

Integrated and managed several customer interaction technologies from multiple vendors like Avaya, Cisco, Genesys, Confidential, Nortel Mitel, NEC, Salesforce.com, Pindrop, Goldmine, Blue Pumpkin, LivePerson, Nice, Verint, 24/7, etc.

Hands on experience in implementing new metrics using snowflake for Confidential

Responsible for implementation of Data Driven Test Automation Framework build using Selenium.

Worked with the QA Manager to research, investigate, implement and train other QA Testing Resources in the areas of Agile Testing Practices, Test Driven Development, Testing Automation and managing Testing Metrics for publication to Upper Management. Accountable for project/product based testing efforts across multiple applications

Deep understanding of Genesys platform and Avaya Aura framework and architecture. Thorough understanding of Cisco UC platforms: CUCM,CVP/ICM,UCCE, etc.

Experience developing enterprise applications using Java/J2EE and Machine learning (ML), Artificial Intelligence (AI) technologies in Banking, Insurance.

Hands on design and implementation of AI, machine learning (ML) algorithms using Python and R.

Proficient in SQL querying with Databases. Have a clear understanding of Business Intelligence and Data Warehousing concepts and knowledge of ETL tools.

Experience in customer segmentation and customer behavior analysis.

Coordinated with team members for testing activities, participating in Requirements Ambiguity, & Use Case / User Story Reviews, and conduct QA analysis & test support activities

Writing SQL Queries for data mining and data analysis Power BI of the data to validate the data used for testing.

Have a clear vision of Media Analytics with data analysis in R, SQL, and Python.

Gather requirements and configure the SAP system with other external interfaces (Ariba, Service channel and intellimatch)

Responsible for documentation of Project scope, BRD, and FRD.

Good knowledge in developing Restful web services.

Working knowledge of database such as Oracle 8i/9i/10g, Microsoft SQL Server, DB2.

Strong experience in database design, writing complex SQL Queries and Stored Procedures.

Experience in Building, Deploying and Integrating with Ant, Maven

TECHNOLOGIES: Business Intelligence, R Programming, Azure, Administrator

SDLC METHODOLOGIES: Waterfall, Waterfall-Scrum Hybrid, Scrum.

BI/Reporting/Visualization Tools: Tableau (Certified), Microsoft Power BI, MS Office Suite (Advance Excel, Word, PowerPoint), Data Visualization, Qlik Sense.

Project Management Tools: Jira, MS Project, MS SharePoint, PeopleSoft, Zscaler, Agile Methodology

Data Base Management: SQL, Microsoft SQL server, AWS S3, Oracle, Toad, Data Analysis

DATA MONDELLING: Conceptual, Logical, dimensional Data Models and Snowflake

Datawarehousing: Data Marts, ETL, OLTP, OLAP, HIVE, drill down/Roll Up

Web analytics: Adobe Analytics, Google analytics

Testing tools: Selenium, Git, QA Testing

PROFESSIONAL EXPERIENCE:

Micro A.I., Irving, TX November 2022 to Present

Project Manager BA

PROJECT DESCRIPTION:

The Micro A.I project aims to develop a cutting-edge artificial intelligence platform that leverages microservices architecture to provide scalable and efficient AI solutions across various industries. The platform will incorporate advanced machine learning algorithms, natural language processing, and computer vision capabilities to deliver intelligent automation, predictive analytics, and personalized user experiences. The goal is to empower businesses to harness the power of AI in their operations, enhance decision-making, and drive innovation.

Responsibilities:

oPerformed end-to-end Data analysis, Data integration, Database designing & Data transformations which involved bringing in Data from D2A and create D2B metrics in snowflake.

oIdentified key stakeholders and helped synthesize the requirements through various elicitation techniques like Interviews, JAD sessions and Document Analysis.

oAs a Business Analyst used Adobe Experience Manager (AEM) to update website content and implement enchantments requested by business owners

oConstant and proactive communication with the facility's management staff

oLead role in sourcing, procurement and program management for multiple high-profile clients.

oDeveloped python scripts to compare data across Teradata and Snowflake.

oDeveloped the Business Requirements Documents by conducting regular requirement sessions with Product Life Cycle Managers, Self Service Channel leaders and Corporate Communications.

oCreating all necessary documents including User Stories, PIF, Project Plans, Progress Report, FRDs

oInvolved in daily meetings to deliver documents and understand client needs and to make changes to project plan accordingly.

oEffective managed all facets of sourcing manufacturing procurement production

oHandled a team of 8 members. Coordinating and brain-storming project ideas including integrations, UI/UX designs, fixing defects and managing CRs. Worked on creating and getting approval for PIFs and CRs

oAdapted to constant challenges and changes undergone within the remote support service channel during its infancy, helping pioneer the required remote technician standards and scope of work for employees and services which were later implemented

oProject manager and SME for migrating Avaya Experience Platform to Genesys GVP, SIP Server, Resource Manager, Media Server and other Genesys Platform components.

oConsult with the various web teams to help with the migration from their legacy Content Management System to the AEM platform

oQA Analyst for Operations Portal, an In house application developed by the Information Technology solutions unit of Confidential.

oDeveloping and implementing QC functions across the division to ensure compliance with set QA standards by Confidential.

oDeveloped Snowflake Schemas by normalizing the dimension tables as appropriate.

oConducting UAT and triage with clients to explain system in depth to determine changes and record defects.

oUsed python packages (Pandas,Numpy,) for feature engineering and machine learning(ML) models

oUsed machine learning(ML) algorithms to analyze the user demographics and trends

oWorked closely with internal and external stakeholders to discuss requirements and project plans.

oOversaw regional facilities build-out, facility operations management, and implementation of logistics of product manufacturing and distribution.

oGathered requirements and created Workflows and Business Model from scratch. Worked with clients to model and document requirements. Developed plan and deadlines for projects.

oWorking with management to drive change in the organization, to adopt best practices of a Project Management Office. while also meeting the overall software and hardware procurement needs.

oProject manager and technical lead for Integration of customer service technologies from Avaya, Genesys, Verint, Verizon, IBM, IVR with speech recognition, enhanced functionality, Work-force management, reporting, etc.

oExecuted Data Wrangling (Discovery, Transformation, Validation, and Publishing) procedures to prepare legacy systems for successful import into the new system.

oDeveloped automated end-to-end solution connecting mBrace Customer to Customer service channels included Call Center, Chat Phone and WR Digital

oReviewed and created documents for implementation of AEM content management system for product catalog and Checkouts.

oPlanned and managed end-to-end data migration, data modeling and conversion from database, flat files and performed data loading from load files to target database.

oPerformed SQL queries and used stored procedures involving Data Query Language (DQL) statements to retrieve the information from the database.

oFrequent use of Microsoft PowerPoint, PowerBi, SharePoint, Excel, and Word.

oLiaison between Sales, Engineering, Facility Management, Accounting, Product Management and Service Delivery members to understand and ensure telecommunication services are implemented from point of sales to final billing

oCreated various summary reports, matrix reports, pie charts, dashboards, and graphics to assist managers to better utilize the application and configured various Reports for different user profile

Environment: Waterfall-scrum Hybrid, MS Visio, MS-PROJECT, MS Office Suite,Python, Advance Excel, SharePoint, Informatica PowerCenter, MS SQL Server, Toad Data Point 5.1, Skype, QA,Symphony,Snowflake, SOA, MYSQL DB, HP ALM, Tableau.

Spedition, Charlotte, NC May 2021 to October 2022

Business system analyst

Project Description:

Spedition Logistics Optimization is a comprehensive project aimed at streamlining and enhancing the logistics operations of a leading transportation company, Spedition Logistics. The project's primary objective is to maximize efficiency, reduce costs, and improve customer satisfaction through the implementation of cuttingedge technologies and process improvements.

Responsibilities:

oDesigned and developed Use Cases, Activity Diagrams and Sequence Diagrams using UML.

oWorked on multiple Pilot projects involving Artificial Intelligence and Machine Learning technology.

oWorked on Chatbot (AIML using NLU)

oDocumented, identified, organized, and tracked the requirements using Rational Requisite Pro.

oCreated Data Flow Diagrams (DFDs), ER diagrams for data modeling and Web-page mock-ups using MS Visio for acceptance from end users.

oTraveled 3 of 5 days to work with clients, observing business processes and documenting practices (traveled to major cities in the United States including Chicago, Atlanta, California, New York, and Houston)

oConducted research analyzed business operations and problem-solved operating inefficiencies, saving companies a combined 5 million in net profit, and reducing operations time by 15%.

oDevelop creative solutions to complex problems, validate requirements with stakeholders, and provide the optimal IT solution using JIRA.

oTest and implement Adobe Experience Manager (AEM)components and report defects to developers

oWorked with stakeholders and clients to model and document goals, communicating transparently to meet 98% of deadlines.

oInvolved in QA team meetings and gave updates to the QA lead/Project Manager on a weekly basis.

oLearned new cloud-based services like snowflake and AWS components and involved in knowledge transition sessions.

oProvide technical support on the various vendors using JIRA

oDevelop testing procedures, test plans, review them with Project Manager and implement them with QA team members.

oLead Collaboration meetings with Program Managers, Confidential and various other counterparts to help guide them through our process of JIRA and Confluence Methodologies.

oWorking with Business/UX Producers/AEM architects/Experience Leads/APO’s on component decomposition for various experiences

oWorked on creating a chatbot application for customer call center using Google dialogflow.

oDevelop Business architecture using requirements such as scope, processes, alternatives, and risks.

oUse Workfront to track, update, and create tasks for the current sprint and future sprints.

oDesigned the (AI) artificial intelligence, (ML) Machine learning data pipeline for regular monitoring and performance evaluation of the deployed ML models.

oBuilt codebase for a natural language processing and (AI) artificial intelligence, (ML) machine learning framework.

oWorked with cross-functional teams to structure problems, identify appropriate data sources, extract data, and develop integrated information delivery solutions.

oCreated a comprehensive user guide for the chatbot, a user script guide for the user/tester to check the accomplishing desired task.

oDesigned both 3NF data models for ODS, OLTP systems and dimensional datamodels using Star and Snowflake Schemas

oDeveloped and maintained an enterprise data architecture roadmap to improve the maturity and effectiveness of enterprise data management.

oProvide feedback and suggestions for improving the QA procedures to project and QA Lead.

oProficient in creating status reports to update Clients/Users periodically.

oResponsible for coreating Use case diagrams, Context diagrams, Swim Lane diagrams, Data Flow (DFD) diagrams.

oParticipated in an agile style atmosphere and participated in daily Scrum/Stand-Up meetings using Agile Scrum standards.

oProgressive experience working in a healthcare setting specifically within a Medicare Risk Adjustment or Risk Adjustment Factor organization/environment.

Environment: : MS Visio, Jira, MS office suite, Agile, Data Flow Diagrams, Python, Machine learning (ML)

, Swim Lane Diagrams,QA, Context Diagrams, Case diagrams, Scrum, Medicare Risk Adjustment, Snowflake.

Tellabs, Dallas, TX Sep 2018 to April 2021

Business / Data Analyst

Responsibilities:

oGood domain knowledge and work experience in Banking, Investment Banking, and Hedge funds and trading

oFacilitate all Agile Ceremonies including Retrospectives, Daily Stand Ups, Story Grooming, Demo/Review and Sprint Planning.

oDeep understanding the Business Flow of Investment Banking, and extensively involved in Portfolio management and analyses, Mutual Funds, Securities trading.

oMicrosoft Chat Bot and AI search integration, refinement and testing for a new B2C recruitment website aim to compete with industry leaders CareerBuilder, Monster, Indeed and ZipRecruiter

oRecommended and implemented vendor procurement procedure and policy changes to increase cash flowPrepare Loan to value and DSCR calculation test cases, test scenarios and execute in ACBS and other satellites systems.

oPerformed business analysis on enterprise operations in commercial leasing industry.

oMaintained and kept track of stakeholder’s requests for enhancements and changes using Rational.

oClear Quest. Used Microsoft Team Foundation Server TFS to manage the team’s software. development lifecycle.

oPerform GAP analysis with Lean (FMEA) by identifying potential problems and their impact on existing technologies.

oProvide gap analysis between business requirements and ACBS upgrade Release Note.

oFollow a systematic approach to elicit, organize, and document requirements of the system.

oPrepare the Business Requirement Document (BRD) and review the BRD with the Cross functional team to analyze the high-level requirements.

oPerform the requirement analysis, impact analysis and documenting the requirements.

oCreate Use Cases, Use Case Diagrams, Process Flow diagram, Requirements Traceability Matrix, Behavior Diagrams (Activity diagrams) based on UML using MS Visio.

oWorked on all phases of the System Development Life Cycle (SDLC), necessary procedures for requesting, developing, implementing, and supporting the system development process.

oMaintaining and keeping track of the fields and preparing a proposed file layout (Field Name, data type, Details) that needs to find a house or transferred in ACBS and documenting it.

oMaking Process flows in Microsoft Visio of the ACBS processes in different BRDs to make the business Users better understanding of the new system.

oMaking test scripts and test scenarios to be input in ACBS for prototype testing and for conversion scoping.

oInvolved in primarily SQL work - main work was to navigate within the databases.

oConducted JAD sessions with business SMEs and developer.

oPerforming business process support reviewing user questions, software license, making data updates, providing one-onone user training, identifying process improvements.

o Worked with CRM software to link important functionalities like online enrolment, rating/underwriting, renewal processing, new business quoting and back-office integration to boost overall productivity and make organizational business easier.

oAnalyze patient accounts and clarify any information needed to correctly answer patient’s questions regarding their account.

oRedefined use cases, process flow, and activity diagrams using MS Visio for a clear understanding of the requirements.

Environment: SQL Server, AWS (Amazon Web Services), Business Requirement Document, ACBS,UML, CRM, MS Visio, Business Process Support, Agile methodology.

Infolob, Irving, TX May 2018 to Aug 2018

Database Tuning Analyst Intern

Project Description:

Infolob is an IT company that works with clients and provides them with Oracle products such as data warehouses, mitigation, and cloud services.

Responsibilities:

oEmployed Waterfall SDLC to monitor the project and followed the step-by-step procedure.

oExperienced in creating user stories and scheduled sprint meetings.

oAble to ensure quality and timeliness of the deliverables & reporting the project's progress and escalating issues.

oExtensive expertise in computer and IT systems including MS Excel (V lookup, H lookup, Filters, conditional formatting, Excel Functions, overview of macros etc.) and PowerPoint, SQL, and Tableau.

oUnderstanding Data warehouse, ETL and Big Data.

oPreparing, Analyzing & Monitoring data, Maintaining KPI (Key Performance Index) and delivering monthly performance presentations on the performance of the databases.

Environment: Waterfall SDLC, Sprint, MS Excel, PowerPoint, SQL, Tableau, Maintaining API

Apollo Health, India April 2016 to Mar 2018

Business System Analyst

Responsibilities:

oResponsible for the management, performance, and completion of IT Project implementations, which requires the creation of detailed work plans, project schedules, budget estimates, resource plans, communication plans, status reports and closeout documentation.

oProvided ongoing technical and leadership expertise for the delivery of business applications.

oDevelop and sustain strong relationships with all stakeholders: internal and external customers, vendors, other IT professionals.

oProactively manage capital spend processes, including monthly capital expense forecasts for responsible project.

oInteracted with business users and executives to identify their needs, gathered requirements and authored business Requirement Documents (BRD), Project Charter.

oConducted project kick-off meetings, defined project objectives and scope, tracked risks, assumptions, and managed detailed project schedules using Microsoft Project.

oProviding leadership in effective management of the project scope, budget, schedule and quality.

oEnsure the completion of complex implementations from initiation to delivery.

oProvides timely updates and conducts presentations to project stakeholders and sponsors.

oMaintain SharePoint site with project documentation such as Meeting Minutes, project Plans, Schedules, OneNote, and Status Updates for project.

oPlanning of all activities related to the project such like: identifying actual state-future state, process flows, key deliverables, action plans, and support work stream leads in development of Impact Assessments, track/monitor development of Impact Assessment for each impacted work streams, facilitate meetings to discuss progress of Phase planning.

oParticipated and lead PMO meetings, Functional Leadership Team meetings and Steering Committee meetings.

oEducated and reinforced scrum methodology and agile framework to team members and key stakeholders.

oParticipate in backlog grooming on weekly basis.

oConducted Scrum Review meeting and demonstrating the newly developed features in current. Sprint to product owner and key Stockholders.

oHandled Scrum team and Scrum at Project level. Facilitating release plans and worked closely with project owner to makes sure the product backlog is in good shape and ready for next sprint.

oExperienced in Agile techniques such as SPRINT planning, Product Backlog management, agile estimation, daily SCRUM, metrics such as Burn-down & Velocity charts, Sprint summary report, Sprint review/retro meetings etc.

oParticipating in Release Management project and documenting all processes Reporting

oPerformance metrics for Release Management updates daily to assist team in achieving goals and objectives set for project.

oPublished Project status report to required stakeholders.

oLead daily standup meetings while tracking status and maintain project documents in Rally, Jira, Quality Center, and SharePoint.

oConducted Defect prevention meeting, identified the root cause of the major issues and resolved them

oIdentified project risk and shared the mitigation plans with management.

oConducted review meetings and the get the documents signed off (design documents, test strategy documents, UAT test results documents.

Education:

Marketing degree- Amity University, Noida (2015) 87%

Business analytics degree-University of north Texas, Denton (2022)3.6 GPA

Certifications:

Cloud Machine Learning Engineering & MLOps

Managing Big Data with MySQL

Decentralized Finance (DeFi)

Mastering Data Analysis in Excel

Tableau: Order analysis

Microsoft Excel

Achievements

Extensive research and proposal for a UAE based Fintech on expansion in a new market (Egypt) for a capstone class

Developed a strategic short-term and long-term plan for Kohl’s including external, internal analysis, financial forecasting and recommendations.

President’s list of Scholars (for having a 4.0 GPA in Spring 2020, Fall 2020, Spring 2021, Fall 2021, and Spring 2022)

Distinction in Microeconomics UNT Excellence Scholarship

Contact this candidate