Ammar Ahmed Mubashir

Scrum Master/ System Analyst

ac859b@r.postjobfree.com 773-***-****

Professional Summary:

9+ 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 three SAFeAgile Release Train Program Increment (PI).

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

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.

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

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

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

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

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 leading and managing small to medium size project with fluency in managing methodologies, tools like CA Clarity.

Have knowledge on Public Cloud technologies like AWS, Azure, and Rackspace Cloud.

Have knowledge of Big data tools like MongoDB, Apache Spark.

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

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

Experience in using CA Clarity, a project managing tools

Installation, configuration and administrating Oracle RAC databases.

Converting single instance into multiple instances (RAC).

Worked as a team member to provide 24x7 on-call production database support.

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

Excellent experience in installation and configuration of Oracle 8i, 9i, 10g,11i,11g and 12c in UNIX/LINUX and Windows environment.

Have great Knowledge of Oracle architecture.

Good experience in SQL, PL/SQL, Shell Scripting, Parallelism, Partitioning, Data modeling, OLAP, Logical and Physical data model using ERWIN, Backup and Recovery procedures.

Expertise in maintaining Database Security using security compliance auditing, expertise in loading data using external tables and SQL*LOADER.

Management of schemas, objects & Partitioning of tables & indexes.

SQL*Loader, Export, Import, data pump, PL/SQL, SQL*Plus, SQL*Net, BMC-SQL, Server Manager.

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.

Installation, Configuration of Oracle Data Guard for Physical and Logical mode.

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.

Involved in designing and execution of User Acceptance Testing (UAT) with Business team.

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

Support & Maintenance of Production, Development and Test Databases on various servers with sizes ranging from 100GB-12TB.

Upgraded 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.

Installed CoSort and FACT.

Planned, defined and tested Use Cases.

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

Upgrade and downgrade CoSort and FACT.

Tuning the application, memory, and disk using Oracle and third party utilities and initialization parameters including explain plans, tkprof and Stats pack.

EDUCATIONAL QUALIFICATIONS:

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

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

Pursuing EMBA (Executive MBA) from University of Cumberland, Kentucky

CERTIFICATION:

Certified Scrum Master (CSM)

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, Data Guard, Pega, Facet, Jira, Confluence, CoSort, FACT, CA Clarity and MS Visio and Pentaho Data Integration (PDI/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

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:

Client: Anthem, Norfolk VA November 16 – Till now

Role: Scrum Master/ System Analyst

Responsibilities:

Worked closely with the developers and the reporting teams, to ensure the timely delivery of the test data and test results.

Resolved impediments using internal or external resources.

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

Shields the team from interruptions and removes obstacles that may impact the delivery of the product.

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 SAFeAgile Release Train Program Increment (PI).

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

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

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

Coordinates requirements, schedules implementation and post-implement activities.

Protect development team from outside impediments, distraction and maintain focus on project backlog and project timeline.

Helped Product Owner/product Managers in developing 3 months’ iteration plans SAFeAgile Release Train Program Increment (PI).

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

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

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

Work with DevOps on deployment

Validated reports, using SQL queries, generated during the process.

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

Created and maintain tracker items in SharePoint.

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

Gathered requirements for Authorizations Appeal and Grievance for NextGen application, coordinate and test corresponding code.

Build and design process flow for Commercial Grievance and Inquiry.

Build and design process flow for GBD Grievance, PQI and Inquiry.

Communicated with various business units about project progress, usage statistics, and enhancement recommendations.

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

Used SQL statements for data validation and reporting.

Migrated User Stories from SharePoint to Jira.

Addressed problems through risk management and contingency planning.

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

Conducted meeting with end users and presented BRDs and created RDDs based on the requirement.

Documented all the fixed issues and stored in share drive and in One Confluence

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

Role: Scrum Master/ Pentaho Support Engineer

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 Delivery Team.

Co-ordinate product Demos for client team.

Monitor all aspects of organizational business engagements, both internal as well external, to ensure that the interfaces are developed and delivered to meet ETL standards and best practices

Use Microsoft Project to create and track project schedules, major milestones, risks and supporting project artifacts to store in Clarity.

Managed allocated projects according to timelines and quality standard

Actively participated as in team to gather requirements to develop DI project and also participated in designing Physical and Logical of Data warehouse.

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

Spent time working with business users on getting specifications for reports and build prototypes developed for implementation on Pentaho Enterprise Server for User Acceptance Testing(UAT). This would involve constant analysis, regression testing, and iterative solutions before published it on Pentaho Enterprise Server production environment.

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

Build new ETL server, installed Pentaho 4.2.4

Interacted with IRI to get licenses and fix issues of CoSort and FACT.

Client: State of North Dakota, Bismarck, ND June’ 15- December'15

Role: Sr Oracle Database Administrator/Scrum Master

Responsibilities:

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.

Regular monitoring of all database using OEM.

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

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

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

Resolved impediments using internal or external resources.

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

Documented all the fixed issues and stored in share drive

Work with UNIX administrator in installation of Red Hat Linux.

Client: CHS/LPS Integration, Nashville, TN November’ 14- May’15

Role: Sr Oracle Database Administrator/ Pentaho Administrator

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 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

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

Role: Oracle Database Administrator

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.

Be instrumental to State of Tennessee’s disaster recovery plans and procedures as well as implementing dual centers migration and redundancy and implementing new projects at the State.

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 using optach utility whenever required on Linux.

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

Role: Oracle Database Administrator

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.

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

Role: Oracle Database Administrator

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.

Contact this candidate