Post Job Free

Resume

Sign in

Scrum Master Database Administrator

Location:
Des Plaines, IL
Posted:
May 10, 2023

Contact this candidate

Resume:

AMMAR AHMED

Sr. Scrum Master Consultant

adw1f5@r.postjobfree.com, 317-***-****

Professional Summary:

12+ Years of Experience in the IT industry as a Scrum Master, System Analyst, Oracle Database Administrator and Pantaho Engineer on UNIX / NT Environments.

Guides the team’s operations by facilitating ceremonies (e.g. daily standup, sprint planning) and instilling Agile principles into daily activities to ensure smooth functioning of the delivery

Planned, managed and facilitated SAFeAgile Release Train Program Increment (PI).

Tracks and removes the obstacles and barriers that may prevent progress to ensure smooth delivery.

Conducted daily stand up call, refinement call, sprint planning and retrospective according to Agile methodology.

Strong Knowledge of Scrum theory, rules and practice.

Excellent technical command to work with Agile project management tool like JIRA, Rally and Azure DevOps (ADO).

Determined the team capacity (velocity) from historical data. Created Work Break down structure (user stories) and corresponding activities (tasks).

Communicated the progress to senior management thru 'burndown charts'. Monitored the Quality thru metrics and mentored team thru the project management processes.

Protected team from internal and external distractions to help them focus on daily activities to be productive and growing in ability.

Good knowledge of Kanban and Scrum.

Mentored and trained jr. scrum master and different scrum teams

Worked with Business executive leadership to gather objective of the project

Works with business partners to identify and implement complex technical systems and/or products

Ensure team is well-informed on internal and external initiatives and activities.

Build effective partnership with different groups in a cross-functional and geographically distributed teams.

Collaborate with Business and IT scrum team in Release planning, Sprint planning, Testing and demo a working software to all stakeholders’ end of each sprint.

Facilitate sprint planning, daily scrums, retrospective, grooming, stakeholder meeting and software demonstration.

Lead scrum team working on designing and building cloud service models for Software as a Service and Infrastructure as a Serve (Amazon Web Services).

Lead and facilitate the team working on migrating SQL servers to Azure Cloud using Data Migration Assistance (DMA Tool).

Lead and facilitate the team working on building primary and secondary region on Azure cloud

Facilitates internal and external communications (e.g. task coordination, progress tracking/reporting, dependency management).

Direct and lead development team and SIT from project initiation through the delivery of final product

Gathered requirements from market members and health plans to ensure requirement completeness.

Lead and support team working on Master Data Management (MDM)

Analyze client’s business requirements and processes through document analysis, interviews, workshops, and workflow analysis.

Support and organize team working on data center migration.

Good knowledge on the Facets data model and batch processing.

Perform high level testing/SA validation to validate if all the functionalities meet the business.

Experience in Installation, Configuration, Upgrades, Patches, Backup & Recovery, Performance Tuning, Cloning, Database Security, Space Management.

Experience in integrating external web systems with Salesforce using REST and SOAP web services.

Interacted with various business user groups for gathering the requirements for Salesforce.com CRM implementation.

Experienced in working with Administration and Development of Salesforce.com.

Actively worked with Salesforce Sales Cloud and Service CloudImplementation.

Have knowledge on MSBI tools (MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS) and MS SQL Server Reporting Services (SSRS)).

Good understanding and knowledge of .Net, C# and Java based applications.

Worked with the team in migrating infrastructure, data, and applications out of legacy data centers into cloud.

Installation, configuration and administrating Oracle RAC databases.

Experience in HP-UX, AIX, SUN SOLARIS, RED HAT LINUX and WINDOWS environments.

Good experience with MS SQL Server, Oracle, Java and Windows.

Have great Knowledge of Oracle architecture.

Prioritized outstanding Strategy stories to remain on-time and under-budget obtaining highest ROI possible.

Experience on Data Replication using Snapshot, Materialized views, import/export and Streams.

Serve as point person for inquiries on system issues and enhancements from Business stakeholders, field support personnel and IT personnel.

Migrating and upgrading the databases to higher versions.

Excellent knowledge in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS Net Backup, IBM TSM & LEGATO Storage Manager

Upgraded and migrated RAC and non RAC databases from 10gr2 to 11gr2 and 10gr2 to 12cr1.

Excellent experience in Database cloning (single instance), RAC database to non-RAC database cloning and RAC-RAC database cloning

Extensively used Database Administrative tools like Oracle Enterprise manager (OEM) Grid control, DBA Studio, SQL*PLUS, TOAD, DBA Artisan.

Technical Competencies:

Operating Systems

HP-UX 10.x,11.x,Sun Solaris 2.5,2.6,8,9,10, AIX 5.1,5.2,Red Hat Linux2.1,3.x,4.x,5.x,6.xSco-unix and windows 95/98/ME/NT/2000/XP

RDBMS

Oracle 11g/10g/9i/8i, Oracle 10g Real Application Cluster (RAC), Oracle Golden Gate replication technology.

Tools and Utilities

RMAN, OEM, TOAD, Oracle Management Server, SQL*Loader,Export/Import, Data pump, Query builder, Net Backup, OneNote, SSMS, SSRS,MS Access, Tableau, Power BI, Data Guard, Pega, Facet, Jira, Confluence, CoSort, Workday, FACT, CA Clarity and MS Visio and Pentaho Data Integration (PD/Kettle).

Languages

C, C++, C#, SQL, PL/SQL, VB.NET, UNIX/NT Shell and pearl Scripting

Tuning Tools

TKPROF, EXPLAIN PLAN, STATSPACK, Data Modeling ERWIN,

Web Technology

HTML, DHTML, XML, JSP, Servers, JDBC, EJB, Java, .Net

Hardware Platform

Sun Solaris M5000/M3000 servers, Sun Fire E25K, Sun Fire 6800, Sun V480, V240, Sun Enterprise 6500 / 450, HP XP256 / XP512, IBM X series Server, and various PC desktop and servers.

PROFESSIONAL EXPERIENCE:

Premera,Washington March'20 – Till now

Sr. Scrum Master/ Sr. Consultant

Project Scope:To enhance the current provider match logic and toautomate manual processing of corrected claims using Facets.

Responsibilities:

Educated and reinforced the Agile Methodology and scrum framework to Team and Stakeholders.

Facilitated all scrum events - daily scrum, sprint planning, retrospective, review and backlog grooming.

Create and maintain dashboard in ADO (Azure DevOps)

Resolve impediments using internal or external resources.

Planned, managed and facilitated SAFe Agile Release Train Program Increment (PI).

Create and communicate the annual Iteration and PI calendars.

Communicated the progress to senior management thru burndown Charts.

Lead and facilitate cross-functional team working in Kanban on migrating SQL servers to Azure Cloud.

Lead and facilitate cross-functional team working in Scrum on building primary and secondary region on Azure cloud.

Helped product Owner/Manager in developing 3 months’ iteration plans SAFe Agile Release Train Program Increment (PI)

Keeps external stakeholders and other interested parties well-informed on team progress and activities

Worked with security team to mapped and implement security policies used within Azure cloud.

Educated team on the difference between the traditional waterfall versus the scrum framework.

Worked with customers and product manager to prioritize and validate requirements in ADO (Azure DevOps).

Mentored scrum team in understanding and enforcing their different roles within the team.

Resolved impediments using internal or external resources.

Tracked scrum metrics such as burndown chart, velocity, and capacity to maintain transparency in ADO (Azure DevOps).

Monitored the project progress and radiated the information to stake holders. Identified and mitigated team risks and impediments (Blocking Issues, Critical Defects) on daily basis

Built relationship with Product owner and other stake holders to support requirements process

Created a positive and transparent communication channel between team members

Serves as a servant leader for cross-functional team working on data center migration.

Created a detailed delivery planning and release planning for each sprint and act as primary point of contact for the Delivery Team.

Coached teams, Scrum Masters, BA and Managers on Agile values and principle to promote continues improvement in practices.

Mentored and lead teams to be self-directed with accountability, decision making, transparency and conflict resolutions.

Prioritize the backlog and create release plans based on product road map and business needs

Co-ordinate product Demos for client team.

Worked with customers and product manager to prioritize and validate requirements.

Identified and mitigated team risks and impediments (Blocking Issues, Critical Defects) on daily basis.

Protected team from internal and external distractions to help them focus on daily activities and productive.

Assisted internal and external communication, improving transparency, and radiating information

Partnered with the Product Owner, especially with respect to grooming and maintaining the product backlog.

Identified and understand system issues based on Java and helped developers in fixing it.

Supported the Product Owner to ensure the backlog has sufficient prioritized user stories at a ready status to stay ahead of the Team.

Environment: SQL server 2012, SAFe, Miro, Rally, Teams, SQL developer, Azure Cloud, Azure DevOps (ADO), Facets, Workday, MS Office Suite (Microsoft Word, Microsoft PowerPoint, Microsoft OneNote, Microsoft Excel) and SFMC

Client: Anthem, Norfolk VA November 16 – February 20

Role: Sr. Scrum Master/ SrSystem Consultant

Project Scope:To create, maintain and update Grievance and Appeals user friendly application for 4 LOBs (Medicaid, Medicare, FEP and Commercial) in PEGA and .Net. To digitalize Medicaid/ Medicare member communication.

Responsibilities:

Educated and reinforced the Agile Methodology and scrum framework to Team and Stakeholders.

Mentored scrum team in understanding and enforcing their different roles within the team.

Resolved impediments using internal or external resources

Built relationship with Product owner and other stake holders to support requirements process

Created a positive and transparent communication channel between team members.

Lead the team working on the UI/UX to create selection rules and dynamic layout.

Mentored and lead teams to be self-directed with accountability, decision making, transparency and conflict resolutions.

Facilitated all scrum events - daily scrum/ Kanban meeting, sprint planning, retrospective, review and backlog grooming.

Serves as a servant leader for the team working on data center migration.

Created a detailed delivery planning and release planning for each sprint and act as primary point of contact for the cross-functional scrum team.

Coached teams, Scrum Masters, BA and Managers on Agile values and principle to promote continues improvement in practices.

Created a positive and transparent communication channel between team members.

Prioritize the backlog and create release plans based on product road map and business needs

Worked with the team to create data pages to load values in UI.

Worked with customers and product manager to prioritize and validate requirements.

Coordinated and participated in weekly estimation meetings to provide high-level estimates (Story Points) for backlog items

Monitored the project progress and radiated the information to stake holders.

Identified and mitigated team risks and impediments (Blocking Issues, Critical Defects) on daily basis.

Protected team from internal and external distractions to help them focus on daily QA activities to be productive and growing in ability.

Assisted internal and external communication, improving transparency, and radiating information

Partnered with the Product Owner, especially with respect to grooming and maintaining the product backlog.

Developed and implement Java based system test scripts for debugging and testing new system and software release.

Identified and understand system issues based on Java and helped developers in fixing it.

Facilitate and participate in Voice of the Customer (VOC) research for the UX team.

Supported the Product Owner to ensure the backlog has sufficient prioritized user stories at a ready status to stay ahead of the Team.

Coordinates requirements, schedules implementation and post-implement activities for application build on PEGA and Java.

Created User Stories in Jira and monitor and manage cross-functional team work.

Acts as a buffer between the team and process overhead, so each team member can focus on the timely delivery of software.

Planned, managed and facilitated SAFe Agile Release Train Program Increment (PI).

Create and communicate the annual Iteration and PI calendars.

Communicated the progress to senior management thru burndown Charts.

Ensured and tested the applications are according to the design and compliance for seamless migration.

Helped product Owner/Manager in developing 3 months’ iteration plans SAFe Agile Release Train Program Increment (PI)

Keeps external stakeholders and other interested parties well-informed on team progress and activities

Prepared detailed design documentation including ETL/Informatica data mapping documents and report specifications.

Work with DevOps on deployment

Closely work with business user, gather requirement and assign to team.

Analyzing complex end user needs to determine optimal means of meeting those needs.

Gathered requirements for Authorizations Appeal and Grievance for NextGen (application build on Pega), coordinate and test corresponding code.

Advocate user needs and influence UI/UX design based on real time scenarios.

Build and design process flow for Commercial Grievance and Inquiry in Pega.

Manage Project scope to ensure product delivery was complaint with scope commitment.

Helped in developing user facing reports using Tableau and Power BI

Addressed problems through risk management and contingency planning.

Environment: SQL server 2012, SSMS, SSRS, Windows NT / 2000, SQL, FACETS, SharePoint, Jira, Confluence, SQL developer, MS Office Suite (Microsoft Word, Microsoft PowerPoint, Microsoft OneNote, Microsoft Excel), FACETS 5.4 and 5.5 and PEGA,

Client: Comcast, Eaglewood, CO January'16-September’16

Role: Scrum Master/System Consultant

Project Scope: To setup completely new environment for the call center application and old data center to New data center

Responsibilities:

Facilitated Release Planning, Sprint Planning, Backlog Grooming, and Retrospective meetings.

Mentored scrum team in understanding and enforcing their different roles within the team.

Prioritize the backlog and create release plans based on product road map and business needs

Co-ordinate product Demos for client team.

Contribute and facilitate continuous improvement of Release management

Created a detailed delivery planning for each sprint and act as primary point of contact for the cross-functional team.

Facilitated the removal of impediments for the team by targeting the issue internally in the team or escalating to the right company personnel.

Co-ordinate product Demos for client team.

Lead and guide Informatica/Pentaho team as per Agile principles.

Worked with Product Owner and Dev team to ensure Informatica code is migrated to new servers.

Facilitate and participate in Voice of the Customer (VOC) research for the UX team.

Interacted with various business team members to clarify/ remove impediments in setting up Salesforce.com application activities and its customization to match functional needs of the organization.

Worked with the team to create data pages to load values in UI.

Lead scrum team working in customizing the Dashboards to track usage for productivity and performance of business centers and their sales teams.

Facilitate and lead cross-functional team working on creating Comcast mobile app using Adobe Enterprise Manager (AEM).

Worked with developers in creating custom reports and enhanced Salesforce.com environment as per user needs using Apex and Visualforce pages

Act as POC for Performing Salesforce.com configuration activities creating Users, Roles, Profiles, Organization Wide Defaults, Permission Sets, Public Groups and Queues.

Lead the team working on integrating salesforce.com platform with SAP to check the availability of the service in that region by passing zip code using lightning connect.

Tracked and manage product backlog, burndown metrics, velocity and task breakdown.

Acted as a liaison between the business and developers/testers.

Ensured and tested the applications are according to the design and compliance for seamless migration.

Coordinates requirements, schedules implementation and post-implement

Closely work with business user, gather requirement and assign to team.

Analyzing complex end user needs to determine optimal means of meeting those needs.

Created User Stories in Jira and monitor and manage team work.

Acts as a buffer between the team and process overhead, so each team member can focus on the timely delivery of software.

Prepared detailed design documentation including ETL/ Informatica data mapping documents and report specifications.

Worked closely with the developers and tester to ensure design and requirements are understood.

Defines the functional, usability, reliability, performance and support requirements of a system serves as a business SME.

Environment: Pentaho Data Integration (PDI/Kettle), Pentaho Mondrian OLAP Server, Pentaho Metadata Editor, Pentaho Design Studio, Pentaho Report Designer, Adobe AEM,MS SQL Server 2005/2008, CoSort, FACT, Oracle 11g, MS Access 2003/200, Enterprise Management Studio, UC4, MS Query Analyzer, SQL profiler, SOAP UI Jira and Confluence.

Client State of North Dakota, Bismarck, ND June’15 – December’15

Role: Sr Oracle Database Administrator/Scrum Master

Project Scope: Deloitte consulting is the second largest professional services network in the world by revenue and largest by the number of professionals. For the state of North Dakota Deloitte was implementing Obama care project.

Responsibilities:

Facilitated all scrum events - daily scrum, sprint planning, retrospective, review and backlog grooming.

Educated and reinforced the Agile Methodology and scrum framework to Team and Stakeholders.

Resolve impediments using internal or external resources

Educated team on the difference between the traditional waterfall versus the scrum framework.

Worked with customers and product manager to prioritize and validate requirements.

Mentored scrum team in understanding and enforcing their different roles within the team.

Lead the team working on the UI/UX to create selection rules and dynamic layout.

Worked with the team to create data pages to load values in UI.

Resolved impediments using internal or external resources.

Tracked scrum metrics such as burndown chart, velocity, and capacity to maintain transparency

Monitored the project progress and radiated the information to stake holders. Identified and mitigated team risks and impediments (Blocking Issues, Critical Defects) on daily basis

Installation of OEM Grid Control by installing OMA agents on all different database servers.

Conducted meeting with end users and presented DRDs

Setup and maintenance of all user access; ensuring that access is granted in accordance with all security requirements and upgrade RAC and non RAC databases from 10gr2 to 11gr2.

Involved in creating SSIS package to get data from different sources, consolidate and cleanse the data and merge it into one single source.

Work with the team to developed SSIS packages to transfer data from heterogeneous database (Oracle) & different files format (Text File, CSV, Spread Sheet) to SQL Server and vice versa.

Worked with team in deploying SSRS reports using Report Manager and scheduled the reports to generate all daily, weekly, monthly and quarterly Reports including current status.

Assisted team member in generating reports using SSRS that could be used to send information to different managers of Different Branch.

Environment Oracle 11g/10g, RAC, Data guard with physical and logical standby databases, Red Hat Linux, Windows NT/2000,OEM, Jira, Confluence SOAP UI, SQL, AWR, ASH, ASM, SQL developer, ADDM, TOAD, RMAN, TPROF, Explain plan and Golden Gate

Client: CHS (Community Health Systems) Nashville, TN November’ 14- May’15

Role: Sr Oracle Database Administrator/ Pentaho Administrator

Project Scope: CHS/Community Health Systems, Inc. is one of the largest hospitalorganizations in the states based in Franklin TN, was founded with the first purchase of ahospital in May 1985. It owns, leases, and operates delicate care hospitals in non-urban andurban areas in 29 states of the United States. To maintain and upgrade databases and all jobs.

Responsibilities:

Installation of Oracle RAC 11gr2 Grid Infrastructure with ASM.

Installation of Oracle Stand Alone 11gr2 Grid Infrastructure with ASM.

Manage multiple Oracle 10gR2 and 11gR2, RAC RDBMS system.

Migrated data files from one table space to another

Stamp ASM disk and added to database.

Downgraded database from Enterprise edition to standard edition.

Migrated ETL/Informatica jobs from production to new environment.

Interacted with FACT Korea team to fix issue in latest release (FACT v3)

Extensively worked with the business and data analysts in requirements gathering and to translate business requirements into technical specifications

Environment Oracle 11g/10g, RAC, Data guard with physical and logical standby databases, Red Hat Linux, Windows NT/2000, Oracle Enterprise Manager, Pentaho Data Integration (PDI/Kettle), Pentaho Metadata Editor, Pentaho Design Studio SQL, AWR, ASH, ASM, SQL developer, ADDM, TOAD, RMAN, TPROF, Explain plan and Golden Gate

Client: OIR State of Tennessee, Nashville, TN July’13- September’14

Role: Oracle Database Administrator

Project Scope: OIR is a division within the Department of Finance &Administration (F&A), provides direction, planning, resources, execution and coordination in managing the informationsystems need of the State of Tennessee. OIR serves as staff to the Information Systems Council(ISC), and under the guidance, provides technical direction, services, and infrastructure tothe State of Tennessee.

Responsibilities:

Maintain database code, database tuning and ensuring database are backed up and restored in a timely manner.

Deliver quality and accurate work; provide results, meeting or exceeding deadlines, communicate with stakeholders.

Interface with users, state agencies, project managers and management to ensure that implemented solutions satisfy business requirement.

Installation of Oracle 12cGrid Infrastructure with ASM.

Installation of Oracle RAC 11gr2 Grid Infrastructure with ASM.

Upgrade and migrate RAC and non RAC databases from 10gr2 and11gr2to 12cr1

Installation of OEM Grid Control by installing OMA agents on all different database servers.

Automation of job scheduling by crontab.

Data Refresh from Production to Test and Development environments using RMAN Duplicate Database &Data Pump.

Upgrade and Migration of Database from 10g to 11g using transportable table spaces and applying patches

Environment Oracle 11g/10g, RAC, Data guard with physical and logical standby databases, Red Hat Linux, Windows NT/2000, Oracle Enterprise Manager, Remedy, ServiceNow, SQL, AWR, ASH, ASM, SQL developer, ADDM, TOAD, RMAN, TPROF, Explain plan and Golden Gate

Client: Navigant consulting, Chicago, IL December’ 12- June’13

Role: Oracle Database Administrator

Project Scope: Navigant consulting is a specialized, global expert services firm dedicated to assisting clients in creating and protecting value in the face of critical business risks and opportunities. Through senior level engagement with clients, Navigant professionals combine technical expertise in Disputes and Investigations.

Responsibilities:

Installation of OEM Grid Control by installing OMA agents on all different database servers.

Installation of oracle Apex 4.1.

Developing PL/SQL procedures for automating loading of PDF files into database tables.

Implemented SQL*Loader scripting techniques to load data from flat files.

Daily Health Check Up and performance statistics of the Database using Statspack, AWR and ADDM.

Data Refresh from Production to Test and Development environments using RMAN Duplicate Database &Data Pump.

Supported Duck Creek Policy Administration system application

Implemented backup/recovery procedures using RMAN, Data Pump, and performed database recoveries.

Tuning Query performance by creating indexes to perform deep analysis to come up with a better execution plan.

Environment: Oracle 11g/10g, data guard with physical and logical standby databases, Sun Solaris 10, Red Hat Linux, Windows NT/2000, Oracle Enterprise Manager, SQL, AWR, ASH, ADDM, CDC, RMAN, TPROF, Explain plan

Client: Transunion, Chicago, IL March’10–November’12

Role: Oracle Database Administrator

Project Scope: Transunion is a global leader in credit information and information management services. For more than 40 years, they worked with businesses and consumers to gather, analyze and deliver the critical information needed to build strong economies throughout the world.

Responsibilities:

Created database objects such as tables, views, synonyms, indexes, sequences and database links

Creating and managing users with appropriate table spaces and Indexes, public and private database links.

Rebuilding Indexes and gather statistics on tables on different databases on a regular basis to gain database performance.

Supporting the Peoplesoft payroll process by backing up specific rows in tables using datapump and updating them as needed.

Tuned the redolog sizes based on the amount of redo generation during the payroll and time and labor jobs are running

Export and Import of database objects to copy from one database to another database.

Environment: Oracle 11g/10g, data guard with physical and logical standby databases, Sun Solaris 10, Red Hat Linux, Windows NT/2000, Oracle Enterprise Manager, SQL, AWR, ASH, ADDM, CDC, RMAN, TPROF, Explain plan.

EDUCATIONAL QUALIFICATIONS:

B-Tech (Bachelor of Technology) From JNTU, Hyderabad, India

MSIT (Master of Science in Information Technology) from Concordia University, Wisconsin

CERTIFICATION:

SAFe 5 Advanced Scrum Master (SASM)

Scrum Foundation Professional Certificate (SFPC)

Scrum Fundamental certified (SFC)

Certified Scrum Master (CSM)

Lifelong Learning (LLL)



Contact this candidate