Business Analyst Scrum Master
Resume:
MUKESH VERMA
Certified Scrum Master (CSM) - SCRUM ALLIANCE
Certified SQL Sybase Adaptive Server SQL Developer
Certified SQL Sybase Adaptive Server Enterprise 15 Administrator
Certified SQL Sybase PowerBuilder Professional
******.*.*****@*****.***
Elk Grove CA 95758
PROFESSIONAL SUMMARY
Experienced Agile Professional with an emphasis on servant leadership and Scrum to generate company value and continuously improve. Possesses team building expertise and can contribute to the development of the Agile SDLC environment from its early stage of the project. 18+ years of expertise as an IT programmer analyst, system analyst, business analyst, project manager, and consultant delivering complex, high-impact software projects that optimize profits, cut expenses, and produce the intended outcomes. proficiency in creating, putting into practice, refining, and managing best practices for management and IT projects across the entire company.
HIGHLIGHTS
Using Agile Scrum SDLC methodologies throughout the software development life cycle process, from requirements analysis to software design, prototyping, programming, testing, debugging, and installation to system software and application deployment. And management and Maintaining the business application.
Having strong process and procedure execution skills, good AGILE process skills, and strong team building abilities.
Technical specialty in Database administration, specifically Oracle, Sybase, SQL Server,DB2 and PowerBuilder version 6.5,7,8,9,10 and 12. Wide industry knowledge covering Finance, Energy, Communications, Insurance, Sales and Retail sector.
15+ Years experience in Contributing to design and development of the Sybase Database and PowerBuilder application, application enhancements, Bug fixing, maintenance and Sybase supporting the application.
Lead projects to ensure correct requirements are being communicated to the developers and quality code is being developed to build a solution that solves the customers problem
Diagnose and Debugging the PowerBuilder application and Sybase Database identifying and resolving complex application issues.
Design and development of the user interface, Sybase, PowerBuilder Front-end coding and design using power script language, preparing reports.
Prepared Unit Test Plans, Coding and Testing in PowerBuilder Application and Sybase Stored Procedures and Triggers.
Ensure scrum teams are practicing the core agile principles of collaboration, prioritization, team accountability and transparency by facilitating scrum processes and ceremonies, and soliciting support from management when necessary to achieve team and sprint goals.
Lead and assist scrum teams through the agile process: backlog grooming, Epic and Story Estimation, sprint planning, daily standup meetings, retrospectives, sprint reviews and Demo.
Knowledge of developing and deploying software projects through best practices, policies, procedures, and processes.
Create a variety of Scrum reporting metrics and dashboards for the team and organization.
Responsible for multi-project rollout management targeting all upgrades for end-to-end software applications
Knowledge of installation and deployment of software upgrades/releases to “go live” as well as post production support by event monitoring of software.
Lead and participate in code reviews and work on development tasks as needed
Known for excellent troubleshooting skills – able to analyze code and engineer well-researched, cost-effective and responsive solutions.
Performance analysis, technical integration, and information technology assessment including computer hardware and software, operating systems, middleware
Technologies Used:
Requirements Management Tools: Remedy, ServiceNow, JIRA ticket management, Wiki, Quality Control, SnagIt, MS Office Suite; Word, Excel, Access PowerPoint, SharePoint, Visio, MS Project.
Database Administration: DB2, Sybase 11.5 and 12.5; Oracle 9i and 10G; SQL Server 7 and 2000
Applications: Power Builder Version 6, 7, 8, 9, 10 and 12.5. Visual Basic, .NET
Cloud /AI : Microsoft AWS (Amazon Web Services), MS Azure,
Oracle Cloud Infrastructure (OCI), GitHub
Source Control Management Tool: Tortoise SVN, VSS and PVCS
Extract Transform Load (ETL): Informatica Power Center 5.1.2 (Logical data models)
Programming Languages: SQL, C, C++, C#, Unix, Shell Script, Fundamentals of Java Script
Automation Tool QTP (Quick Test Professional)
Operating System: Window 98, NT, 2000, XP, 7, 10 and UNIX
Other: DB Artisan 8.6.1, SQL DBX Toad and Rapid SQL PB Delta and PrdDiff. Understanding of Algorithms and Object-oriented concepts.
EDUCATION
Master of Science in Information Technology, 2007
Bachelors of Science in Information Technology, 2005
PROFESSIONAL EXPERIENCE
CA Department of Technology - Rancho Cordova CA: Feb 2018 –March 2025 Role: Information Technology Specialist / Lead System Business Analyst
Responsibilities:
Working with a team of highly trained professionals in support of managed client/server computing environments.
Liaison between the customer and development team for requirement gathering for the Cloud /AI project using Microsoft AWS (Amazon Web Services), MS Azure, Oracle Cloud Infrastructure (OCI), GitHub
Conduct Scrum Meetings, Daily Stand-up, Sprint Planning, Backlog Grooming, Epic, and Story Estimation, Sprint Review, Demo, Retrospective session
Lead technical staff responsible for complex IT services that require high online availability and/or performance
Installing the latest release of the server, backing up the database, coding and bugs fixing
Contributing to design and development of the Application, Application enhancements, Bug fixing, Debugging,maintenance and supporting Database
Resolving issues and Incidents using ServiceNow.
Reviewing customer invoices and client billing at the end of each month and updating management
Prepared Unit Test Plans and Testing the Application
Lead and assist scrum teams through the agile process: backlog grooming, Epic, and Story Estimation, sprint planning, daily standup meetings, retrospectives, sprint reviews, and demos.
The incumbent provides a variety of software support services for customer departments; independently, and/or as a member of a team, installs, maintains, tests, monitors, and tunes Database Management System (DBMS). The incumbent will efficiently and effectively troubleshoot and resolve customer problems, in addition to proactively identifying possible future problems.
Working as an advanced technical specialist on database and system software products in support of CDT managed services including system management, new system development, or re-engineering of current systems
Develop automated processes to improve efficiencies in checking and controlling production environments.
Review data for obsolesces and purging. supported software for space allocations for resource optimization
Farmers & Merchants Bank (F&M Bank) - Lodi CA: June 2014 – August 2016 Role: Lead System Business Analyst / Vice President
Farmers & Merchants Bank of Central California (F&M Bank) is a community bank has provided financial services to individuals, families and businesses in California since 1916. Uses Jack Henry's for core banking platform
F&M Bank is financially strong, with over $2.6 billion in assets, and is consistently recognized as one of the nation's safest banks by national bank rating firms. Locally owned and operated, F&M Bank is headquartered in Lodi, California and proudly serves more than 25 locations throughout the Central Valley and East Bay.
Responsibilities:
Primary person in charge of upgrading Jack Henry's use for core banking platform and ensuring that all improvements and enhancement to loans, deposits, and ATMs are put into practice and adequately tested
Responsible for resolving issue related to Jack Henry core banking platform and all the issues related to IT project and Primary responsible for all Bank upgrades
Acted as a skilled liaison for the Silverlake core banking platform by Jack Henry. Work with bank staff to understand problem and lead vendor efforts to resolve technical difficulties impacting the core banking application. expertise in Jack Henry Core Banking Systems
Use agile approaches to enhance responsiveness, flexibility, and teamwork. Divide the work into shorter iterations or sprints, to enable continuous delivery and feedback
Promote collaboration between employees and vendors to guarantee optimal data mapping and system integration. obtaining reports from the database and overseeing the daily reposts distributed to bank branches and executives
Collaborate closely with stakeholders to comprehend banking products, with a particular emphasis on loans and deposits Department to resolve issue
Examine current banking procedures and suggest ways to improve them in order to increase operational effectiveness. Assist project teams with banking solution development, testing, and deployment.
Create and manage requirement documentation, user stories, and process flow diagrams.
Resolving Tickets, enhancements and Incidents using ServiceNow.
Examining and informing management on client billing and invoices at the end of each month
As required, provide assistance with data analysis, reporting, and validation.
Lead and effectively carried out the bank branches' ATM installation project.
Successfully Implemented the project of replacing the old Diebold ATM with the new NCR ATM, including generating the keys for encryption, Keeping track of the local port ID, remote port ID, network port ID, and sub mask address Arrange the delivery timetable with the IT Team and ATM vendor. The ATM's physical installation includes training and branch support in addition to software installation and configuration. Unit and system Testing the ATM with various bill denominations (both US and foreign), check, withdrawal and set up the foreign ATM fees in the new ATM Machine
capacity to convert commercial/Business requirements into precise technological specifications. Have a strong analytical, detail-oriented, and problem-solving abilities.
Leading and implementing the Annual Jack Henry Release upgrade and coordinating all the upgrades and features Testing with the different department Leads (Loan, Deposit, ATM)
To guarantee code quality, coding standards compliance, and knowledge sharing, perform code reviews on a regular basis. To find problems early, use automated testing (unit testing, system testing and integration testing ).
Design and development of the user interface, Front-end coding and design using power script language, preparing reports.
Conduct Scrum Meetings, Daily Stand-up, Sprint Planning, Backlog Grooming, Epic and Story Estimation, Sprint Review, Demo, Retrospective session.
Created quality design and documenting the Business Requirements Design (BRD), Functional Requirements Design (FRD), Entity Relationship (ER) Diagrams, User stories and System Architectural Diagrams including Current and Future state of the Database.
Manage Agile Process end to end software development life cycle.
Scrum methodology: Manage and coordinate cross functional global teams to ensure timely resolution of defects with high business impact in best practice with Scrum
Liaison between Business stakeholders and technology groups to understand complex business problems. facilitating JAD sessions and provide creative solutions.
Creation of detailed user stories, acceptance criteria in JIRA, an Agile methodology specific requirements management tool.
Planning, scheduling and executing all stages of enterprise software, hardware and system implementations. Expert ability to assess business implications for each project phase and monitor progress to meet deadlines, standards and cost targets.
Facilitating scrum events and providing servant leadership to help ensure that the team has what they need to be successful. Implementing the Agile environment
Lead regular team meetings, assign workload helpdesk tickets to employees and review for accuracy.
Manage and approve the change control process of the team.
Conduct performance review and set up goals for team, approve time sheets.
Communicate professionally on critical issues with stakeholder, management, Department Heads, supervisors and bank personnel.
Surewest Communication /Consolidated Communication) - Roseville CA: Sep 2011 –May 2014
Role: Business System Analyst / DB Administrator.
Responsibilities:
Contributing to design and development of the PowerBuilder 12 application, application enhancements, Bug fixing, maintenance and supporting the Genesis application.
Diagnose and Debugging the PowerBuilder application and identifying and resolving complex application issues.
Design and development of the user interface, PB Front-end coding and design using power script language, preparing reports.
Creating new and enhancing the Sybase Database objects i.e. Stored Procedures, Triggers, Cursors, Indexes and Transactions. Performance Tuning and SQL query optimize.
Diagnose and Debugging the PB application and identifying and resolving complex application issues. Importing the data from the XML File.
Prepared Coding and Testing in Power Builder Application and Sybase Stored Procedures and Triggers.
Create a variety of Scrum reporting metrics and dashboards for the team and organization
Work as system analyst and liaison between Business stakeholders and technology groups to understand complex business problems and analyze complex business requirements, design and write technical specifications to redesign complex computer platforms and application.
Ensure scrum teams are practicing the core agile principles of collaboration, prioritization, team accountability and transparency by facilitating scrum processes and ceremonies, and soliciting support from management when necessary to achieve team and sprint goals.
Lead and assist scrum teams through the agile process and ceremonies: backlog grooming, Epic and Story Estimation, sprint planning, daily standup meetings, retrospectives, sprint reviews and Demo.
Manage and coordinate cross functional global teams to ensure timely resolution of defects with high business impact in best practice with Scrum
Work with project managers and end-users to define systems requirements and business goals.
Created quality design and documenting the Business Requirements Design (BRD), Functional Requirements Design (FRD), Entity Relationship (ER) Diagrams, User stories and System Architectural Diagrams including Current and Future state.
Track and communicate team velocity and sprint/release progress; Generate process reports indicating velocity, burn-down, etc. Maintain relevant metrics that will allow teams and management to evaluate how scrum teams are progressing.
Ensure that the team works collaboratively; demonstrated by a self-organizing team collaborating with product owner and toward achieving the overall sprint goal of delivering a potentially shippable product. Partner with the product owner for release planning and backlog maintenance.
Ensure requirements are in sync with development by preparing valuable technical documentation; Unit Acceptance plans, Automate Scripts for Unit and System Testing
Managing QA Test activities; developing test cases, performing Integration testing and User Acceptance Testing to ensure user requested requirements were met.
Serve as senior level PowerBuilder programmer working on multiple concurrent projects to enhance the application aspects and serve multiple business units.
Analyze enhancement requirements, interacting with business users, write requirement specifications, functional specifications, low level design, test plan, impact analysis, estimations and project plans.
Done Application Reviews, perform Unit, System, Functional, Regression and End-to-End Testing for Order Entry application
Analyze complex problems through research and Proof of Concept and create in-depth impact analysis documentation
Converting all the Genesys application to Consolidation of Time zone/UTC. Previously the Genesys database has all date-time fields stored in Pacific Time. This has been modified such that all date-time fields will be converted and stored as UTC (Coordinated Universal Time). This will allow all applications across time-zones to have a base starting point in determining the appropriate time to display in Kansas City and California customers in the Genesys Database.
Solving dynamic problems and 24X7 Production Support (midnight/early morning/weekends).
The San Onofre Nuclear Generating Station (SONGS) Dec 2010 – Sep 2011
Southern California Edison San Onofre –CA:
Role: Sr. Business System Analyst
Responsibilities:
Diagnose and Debugging the PB application and Identify and resolve complex application issues and bugs fixing within scope.
Guide development effort changes through PB code comparison showing present and previous build changes using PB Delta
Coordinate efforts for launching changes in Production Environment using Power Gen through organized Change Requests
Extensive experience in Business Analysis, interacting with business users, writing requirement specifications, functional specifications, low level design, test plan, impact analysis, estimations, creation of project plans.
Create new and enhancing the Oracle PL/SQL Database objects i.e. Table, Store Procedure and Indexes etc.
Coordinate with the desktop engineer to deploy the PB build in Development and Production environment.
Worked as a liaison between Business stakeholders and technology groups to understand complex business problems.
Partner with scrum team members and functional manager to resolve issues and mitigate risks.
Planning, scheduling and executing all stages of enterprise software and system implementations. Expert ability to assess business implications for each project phase and monitor progress to meet deadlines, standards and cost targets.
Ensure team goes through sprints including scrum ceremonies with the objective of producing a potentially shippable product, and establishes achievable goals with necessary acceptance criteria. Facilitate getting the work done without coercion, assigning, or dictating the work.
Partner with the product owner for release planning and backlog maintenance. Support and educate the Product Owner, especially with respect to grooming and maintaining the product backlog.
Extensive experience in producing quality design and documenting the Business Requirements Design and Functional Requirements Design Documents
Guide Development effort through PowerBuilder code comparison showing present and previous build changes using PowerBuilder Delta
Oversea multiple high impact concurrent projects and serve as senior level Technical Lead to enhance enterprise development.
Ensure requirements are in sync with development by preparing valuable technical documentation and guidance; Unit Acceptance plans, Automate Scripts for Unit and System Testing
Established functional and system configuration requirements for enhancement
Perform peer check operation.
Conduct thorough impact analysis, using SDLC Agile methodology document detailed designs, write code, and develop test plans.
Prepare schedules and maintaining status updates on development and testing efforts to ensure timelines are met
Analyze highly complex business requirements, designs and writes technical specifications to design or redesign complex computer platforms and applications.
Lead a team to designing complex reports in Power Builder 10 and implementation of application enhancements, maintenance and supporting the existing PB application.
Contributing to design and development efforts to application enhancements and PB interface.
Cognizant : Sep 2010– Dec 2010
Client: Arrowpoint Capital
Role: Sr. Business System Analyst
Project: EMIS: Enterprise Management Information System
Provide technical leadership and planning to ensure the continuity of computer services for Casualty Insurance, Billing and Liability users
Meet with business users, writing system functional specifications test plan and impact analysis.
Liaison between Business uses and technology groups.
Executing all stages of enterprise software and system implementations. Expert ability to assess business implications for each project phase
Design and develop quality design and documenting the Business Requirements Design and Functional Requirements Design Documents
Cognizant - (Client: JPM Chase)
Project: Credit center
Responsibilities:
Lead team offshore and onsite to implement business requirements in Informatica Power Center 5.1.2 Client (Extract Transform Load)
Coordinate efforts to decommission the main frame application into the oracle table
Create mappings, transformation and executing the session in the server manager and Monitoring the Job schedule in corn in the Unix server
Logical data models for Healthcare data.
Maintaining the existing Healthcare Project and data transfer.
Assigning the new request and coordinating with the offshore team for resolve the client request.
Creating and enhancing the DB Oracle objects.
Managing team efforts to enhance Oracle/Sybase Database objects; Stored Procedures, Triggers, Cursors, Indexes and Transactions. Monitor and resolve performance/load issues and code Optimization.
Perform Unit testing and System Testing and deploying the Session in the production
IFF - NJ, USA
Allentown PA CRI (Comprehensive Resources): Feb 2010 – Sep 2010
Role: Project Lead – Senior Programmer (PB and Oracle) Analyst
Responsibilities:
Design and development of the user interface, PB Front-end coding and design using power script language, preparing reports.
Prepared Unit Test Plans and Testing in Power Builder Application.
Writing business requirement specifications, system functional specifications, low level design, test plan, impact analysis, estimations, creation of project plans, allocation of tasks to team members, code review, demonstration and user training, along with designing and developing applications.
Worked as a liaison between Business stakeholders and technology groups to understand complex business problems.
Extensive experience in producing quality design and documenting the Business Requirements Design and Functional Requirements Design Documents
Ensure requirements are in sync with development by preparing valuable technical documentation; Unit Acceptance plans, Automate Scripts for Unit and System Testing
Taking care of Performance issue: Performance Tuning and optimize the query and make it code efficient.
Bug fixing and maintenance activities depending on the severity of the tickets (using Remedy as a tool). Implementation of application enhancements and handle Sales/ Insurance claims.
Unilever - New York Nov 2008 – Jan 2010
Role: System Analyst Manager / Project Lead
Responsibilities:
Providing the Inputs to the AMPS .NET team (offshore) for migrating the exaction AMPS application to .NET and Oracle from the Legacy Power Builder 9.0 and Sybase SQL Anywhere Studio 9.
Created quality design and documenting the Business Requirements Design (BRD), Functional Requirements Design (FRD), Entity Relationship (ER) Diagrams, User stories and System Architectural Diagrams including Current and Future state
Analyzing in-depth functionality of store procedure and trigger of legacy application
Analyze highly complex business requirements, design and write technical specifications to redesign complex computer platforms and applications and work as system analyst and bridge between Business stakeholders and technology groups to understand complex business problems.
Preparing the AMPS Technical Spec and In-depth Functionality documents, this includes the Scripting of PowerBuilder AMPS Application and the Reports SQL and composites fields.
Create new and enhancing the Oracle 10G PL/SQL Database Objects Table, Store Procedure using Toad 9.
Preparing Test Scripts and Test Cases to perform Unit testing and System Testing.
Done Application Reviews, Prepared Unit Test Plans, Execute test scripts, Functional, Regression and End-to-End Testing in QA using Quick Test Pro for AMPS .NET application
Implementation of application enhancements in .NET
Done bug fixing and maintenance activities.
AVIS – Budget: Parsippany- NJ May 2007 – October 2008
Role: Team Lead
Responsibilities:
Prepared Unit Test Plans, Coding and Testing in Power Builder Application and Sybase Stored Procedures and Triggers.
Migrating the PB application to Java web base.
Designing complex reports in Power Builder 6.5/ Visual Basic and interaction with Power Builder Front-end
Enhancing the PB/VB application as part of constraints relief and altering the require table
End to end involvement in all phases of Software Development Life Cycle (SDLC) from inception to end including Requirement specifications, Analysis, Design, Development, Testing, Implementation, Debugging and Maintenance/Support in the Agile, Waterfall and Spiral methodologies.
End to end experience in SDLC from requirements documentation, hands on application development, testing and support.
Develop Test Plans, execute test scripts, perform Unit, System, Functional, Regression and End-to-End Testing (using QTP); Black/White box testing
Developed and enhancing the Sybase 12.5 Database objects i.e. Stored Procedures, Triggers, Table and BCP the records in tables
Maintaining and production support of Batch Jobs Define in the UNIX Server. (running the shell script manually which is defend in the corn whenever the process fail and FTP the require file from other system and BCP the records etc)
Upgrading Sybase 11.5 to Sybase 12.5 and enhancing the entire environment variable in the UNIX environment.
System testing and Implementation of application enhancements
Production support in UNIX, Shell Script (Batch Process)
Sony Pictures: LA- CA – Offshore May 2006 – Dec 2006
Role: Senior Programmer Analyst
Responsibilities:
Enhancing the DB Oracle object such as Table and Store Procedure and PL/SQL
Prepared Unit Test Plans, Coding and Testing in Power Builder Application.
Experience on Business Objects {Modifying and enhancing}
End to end involvement in all phases of Software Development Life Cycle (SDLC) from inception to end including Requirement specifications, Analysis, Design, Development, Testing, Implementation, Debugging and Maintenance/Support in the Agile, Waterfall and Spiral methodologies.
Design and development of the user interface, Front-end coding using power script language, preparing reports.
Implementation of application enhancements, Preparation of back end and front-end coding.
Developed Database objects i.e. Procedures, Triggers, Table and necessary activates and front-end design and preparing the documentation
Bug fixing and maintenance activities.
Contact this candidate