Senior Project / Program Management Professional
Resume:
Rafat Waqar
Houston, TX **083
Email: *********@*****.***
Professional Summary
Experienced with Project Management, Program Management, Project Portfolio Management, Release Management and Change Management Process, Process Development, Meeting Facilitation
Experienced with writing Business Requirement Document (BRD) and Functional Specs Document (FSD)
Experienced with requirement & systems analysis
Experienced with front-end Web Portal Design, and designing of portal screen mock-ups
Experience with Business Intelligence Reports including Tableau and Power BI reports
Experienced with Report Creation, Data Modeling, data mapping and Data Extraction from external sources
Experienced with defining Test Cases and Test Scenarios for System Testing, and UAT
Experienced with UML, Use Cases and As-Is & To-Be Models
Experienced with Amazon Web Service (AWS) & Cloud Databases
Experienced with Snowflake Cloud Database
Experienced with Salesforce Lightning Platform that contains B2C, Sales Cloud & Marketing Cloud Environments
Experienced with MS SharePoint Systems and Document Content Management Software.
Experienced with Release Management
Experienced with Business Process Development and Business Process Improvement
Experienced with Data Migration Projects
Experienced with Master Data Management (MDM) and Data Governance
Experienced wit ETL Development
Experienced with Power BI, Tableau Reports
Experienced with Single Sign On projects
Education:
B. S Computer Information Systems, California State University, Los Angeles, CA December 1996
Diploma in Financial Accounting from Alison Online, Ireland
Technical Skills
JavaScript, Java, Visual Basic 2005 and 2008, VB.NET, C#.NET, ASP.NET, HTML, DHTML, XML
Operating Systems: Windows Administration, Windows NT/2000/XP/ Vista software installation, Android OS, Android Application Installation, Android Application Testing.
Oracle 11g & 12g, MS SQL server 2005, 2008, 2012, 2014 & 2016 with SSIS, SSAS, SSRS.
PL/SQL Developer for Oracle, Oracle OraHome92, Toad for Oracle and SQL Server, DB2 and AS400 iSeries, PeopleSoft, Report Builder 3.0 and MySQL
MS Office 2016 & Office 365 – Word, Excel, PowerPoint, MS Visio, MS Project, MS SharePoint, Informatica version 10,
MS Dynamics 365
Work Experience
Inoventive Ltd
Birmingham
United Kingdom
Remote Freelance Project Manager
June 2023 – June 2025
Responsibilities:
Project Management including project planning, effort estimation, test planning, deployment planning, tracking traceability of the project, project budgeting, analysis of estimated vs actual efforts
Define goals & objectives
Business Analysis
Impact Analysis
Gap Analysis
Risk Analysis
Requirement Gathering for Reporting and analytics
Analysis of Account Receivable/Accunt Payable and General Ledger, Balance Sheet, and Statement of Cashflow tables
Create Test Plans, write QA test scripts, lead the test efforts
Create UAT Test Plans, write UAT scripts, lead the UAT efforts
Create source to target data mapping
Create SQL Queries for reports using Snowflake that runs on AWS Cloud
Data Analysis
Create Tableau Report Visualizations
Upload SQL Queries on Tableau Server for Visual Reports
Salesforce Sales Cloud data migration to SAP HANA
Maintain Data Governance and Data Quality.
Manage Customer Information using MS Dynamics 365
Create Functional Specs Document
Create Technical Design Document
Use Excel VLookup and Pivot tables to analyze the data in the spreadsheet
Built Data Lakes on AWS Platform for analytical purpose
Performed rapid prototyping and screen Mock-up utilizing I Rise
Utilized Databricks for advanced analytics enabling efficient data processing and collaborative notebook development.
Design Alteryx ETL Workflow to be used as Data Source for Tableau/Power BI Reports, and run the workflow jobs in Alteryx Gallery
Using Jira for agile sprint management and Confluence for content management
Working with AWS cloud, and MS Azure Cloud environment
Charles Schwab Corporation – Remote
January 2023 – April 2023
Project Manager
Responsibilities:
Project Management including project planning, effort estimation, test planning, deployment planning, tracking traceability of the project, project budgeting, analysis of estimated vs actual efforts
Data Ingestion to one or more Azure Services - (Azure Data Lake, Azure Storage, Azure SQL, Azure DW) and processing the data in In Azure Databricks.
Leveraged rapid prototyping approaches to present AS-IS and TO-BE processes/workflows and rough designs of the proposed solution.
Gather Requirements/User Stories
Create JIRA User Stories (Epics, User Stories, Tasks) using Agile-Scrum Methodology
Write acceptance criteria
Conduct Sprint Grooming sessions & refinement sessions
Define goals & objectives
Perform Business Analysis
Create UML & UX Diagrams
Create UI Mockups
Creat REST & SOAP API Design
Create PowerPoint Presentations
Define functional requirements, and create Functional Specs Document
Create test plans & scripts for SIT & UAT
Support Systems Integration Testing
Lead UAT efforts
Perform System Analysis
Create data mapping for ETL process
Migrate Appian/MySQL data to MS SQL Server
Write SQL Queries for data analysis
Perform data analysis for data validation, data accuracy, and data quality
Conduct Sprint Grooming sessions & refinement sessions
Sprint management using JIRA
Document & Content Management using Confluence
Worked on AWS Data-Warehouse, and Data Lake Projects
Use Excel VLOOKUP and Pivot tables to analyze the data in the spreadsheet
Configured Data Lakes on AWS Platform for analytical purpose
Worked on Data Migration Project from Standard MS SQL & Oracle Platforms to AWS Cloud & Snowflake Cloud Platforms
Worked on Master Data Management (MDM) Process to maintain data governance, data quality, data security and data accuracy
Collaborated with stakeholders to gather, analyze, and document detailed business requirements.
Oversaw user acceptance testing (UAT) and managed change processes to ensure the successful implementation of solutions.
Utilize AWS services (e.g., S3, Glue) and Snowflake for data warehousing, ETL, and ELT processes.
Design Customer Information Systems using MS Dynamics 365
Build SQL/Snowflake views to support Power BI reporting and data analysis.
Worked on SSIS packages
Worked Tableau Reports
Use Adobe AEM tool for content management
Career transition
November 2022 - December 2022
Lumen Data Inc - Full time Remote
April 2022 – October 2022
Project Manager
Responsibilities:
Project Management including project planning, defining goals and objectives, effort estimation, test planning, deployment planning, tracking traceability of the project, project budgeting, analysis of estimated vs actual efforts
Work on Application Development Projects
Work on Database Architecture & Migration Project in AWS/ Snowflake Platforms
Provide support for project planning & create migration plans
Work on Data Governance that dictates governance policies and set data security standards
Work on MDM Database Design
Build Data Dictionary
Obtain User Stories from Business Stakeholders and convert the stories into functional requirements
Conduct Meetings and JAD Sessions with Business Stakeholders and Subject Matter Experts
Perform Business/Systems & Data Analysis
Create Functional Specs/High Level Design Documents
Create Test Scripts, Test Cases, Test Strategy for System Integration Testing & UAT
Provide support for Project Management Duties
Perform Gap Analysis
Analyze AS-IS & TO-BE Model
Project Planning using MS Project & Jira tools
Content Management using Confluence
Create product & sprint back logs using Jira tool
Create High Level Design Documents that contains processes for data download of Fans Data from Facebook, Twitter, Instagram, and other Social Media Websites
Create a Test Strategy & Write Test Plans/Test Scripts for System Integration Test & UAT
Design of Application User Interface Screens and fields
Write complex SQL Queries in Oracle PL SQL & MY SQL in Oracle Cloud Environment
Write complex SQL Queries in MS SQL Server Environment
Write complex SQL Queries in Snowflake environment
Use Excel VLookup and Pivot tables to analyze the data in the spreadsheet
Created Data Lakes on AWS Platform for analytical purpose
Create MDM Architecture Design
Create data flow & data model diagrams
Create REST & SOAP API Design
Migrate Data to Snowflake Cloud Environment
Design Entity Relationship Diagram to build the relationship between the tables
Create Architecture Diagrams
Create Data/Field Mapping from source to target environment
Perform Data Cleansing
Design ETL Process using source to target fields
Perform Data Validation, and support System Integration Testing Process
Identify the fields related to MDM and store the fields data vault
Sales Force Sales Cloud & Marketing Cloud data Integration
Import the data into MDM tables for standardization, and finally move the data int Adobe Experience Cloud
Define MDM Survivor-ship Logic
Verify the data that has been migrated in the Snowflake target table
Power BI & Tableau Reporting
Used Informatica Cloud & Informatica Power Center for Data Quality Analysis
Used Reltio for Data Quality Analysis
Designed customer information System using MS Dynamics 365
Microsoft Azure Cloud
SAP HANA
American International Group (AIG) - Remote
January 2022 - April 2022
Project Manager
Responsibilities:
Gather & Analyze Business User Stories in Agile-Scrum Environments
Conduct Scrum Ceremonies & Grooming Sessions
Conduct JAD Session and meetings with Subject Matter Experts and Business Stakeholders
Project Planning using MS Project & Jira tools
Prioritize the User Stories, and plan the Sprints using Jira
Analysis for Master Data Management Project
Maintain Data Governance, Data Security, Data Quality
Data Mapping, Data Analysis, Data Mining
Checking for data accuracy and data validation
Write complex SQL queries using Google SQL/Dremel SQL/Big Data Query
Quality Assurance on the data and database tables
Create Technical Design Documents
Participate in Business and Technical meetings
Sales Force Sales Cloud & Marketing Cloud data Integration
Worked on ETL Process
Professional Development
Career Break
August 2021 December 2021
Google - Remote Position
March 2021 – July 2021
Project Manager
Responsibilities:
Project Management including project planning, defining goals and objectives, effort estimation, test planning, deployment planning, tracking traceability of the project, project budgeting, analysis of estimated vs actual efforts
Gather & Analyze Business User Stories in Agile-Scrum Environments
Conduct Scrum Ceremonies & Grooming Sessions
Conduct JAD Session and meetings with Subject Matter Experts and Business Stakeholders
Project Planning using MS Project & Jira tools
Prioritize the User Stories, and plan the Sprints using Jira
Analysis for Master Data Management Project
Maintain Data Governance, Data Security, Data Quality
Data Mapping, Data Analysis, Data Mining
Checking for data accuracy and data validation
Write complex SQL queries using Google SQL/Dremel SQL/Big Data Query
Quality Assurance on the data and database tables
Create Technical Design Documents
Participate in Business and Technical meetings
Sales Force Sales Cloud & Marketing Cloud data Integration
Worked on ETL Process
Tool used are Google Chrome, Google SQL, Google Docs, Google Sheets, and Reltio as front tool for Data Management
Travel
November 2020 – February 2021
Kaiser Permanente – Burbank CA – Contract (Remote)
August 2020 – October 2020
Project Manager
Responsibilities:
Lead the Project Management, Business & Technical Efforts for Pharmacy Reporting Project
Gather Business User stories/requirements using Agile-Scrum Methodology
Perform Functional & Technical Analysis for financial reporting
Conduct meetings with Line of Business subject matter experts
Create requirement and Technical Design documents
Worked on Master Data Management (MDM) and Data Governance
Provide Solution to design & architect Data Warehouse Tables and schema
Develop ER Diagrams, Develop ETL Process, Develop Queries for the reports
Perform ODS Tables & Metadata Analysis, and support the efforts to build ODS data dictionary
Identify Data Source tables & columns in ODS/AWS Cloud Environment for Data Mapping
Perform Data Analysis & Data Mapping using Oracle Data Storage (ODS) for KP Financial Reporting
Create Test Strategy, Test Plans and write Test Scripts for QA and UAT
Perform End-To-End Quality Assurance Testing on Desktop/Laptop computers and Mobile phones. In addition, provide support to the UAT team
Test complex Oracle Queries for Data Mapping in AWS Cloud Environment
Create workflow process diagrams for reports workflows using MS Visio
Create Tableau Financial Reports and Dashboard Design, and test the Dashboards on KP Dev Tableau Server
Perform QA on Tableau Report workflows and ETL process
Sales Force Sales Cloud & Marketing Cloud data Integration
Coordinate the efforts with KPMC Team for Design & Data Mapping Issues
Arrange Project Meetings to discuss Reporting Requirements, and ongoing design issues
Create Technical Design Documents
Use SharePoint for Document & Content Management.
Communicate with IT Teams to discuss Database Schema & Table Design Issues
Use Excel VLookup and Pivot tables to analyze the data in the spreadsheet
Configured Data Lakes on AWS Platform for analytical purpose
Kaiser Permanente – Burbank CA – Contract (Remote)
January 2020 – June 2020
Project Manager
Responsibilities:
Lead the Project Management, Business & Technical Efforts for KPMC Reporting Project
Gather Business User stories/requirements using Agile-Scrum Methodology
Perform Functional & Technical Analysis for financial reporting
Conduct meetings with Line of Business subject matter experts
Create requirement and Technical Design documents
Worked on Master Data Management (MDM) and Data Governance
Provide Solution to design & architect Data Warehouse Tables and schema
Develop ER Diagrams, Develop ETL Process, Develop Queries for the reports
Perform ODS Tables & Metadata Analysis, and support the efforts to build ODS data dictionary
Identify Data Source tables & columns in ODS/AWS Cloud Environment for Data Mapping
Perform Data Analysis & Data Mapping using Oracle Data Storage (ODS) for KP Financial Reporting
Create Test Strategy, Test Plans and write Test Scripts for QA and UAT
Perform End-To-End Quality Assurance Testing on Desktop/Laptop computers and Mobile phones. In addition, provide support to the UAT team
Test complex Oracle Queries for Data Mapping in AWS Cloud Environment
Create workflow process diagrams for reports workflows using MS Visio
Create Tableau Financial Reports and Dashboard Design, and test the Dashboards on KP Dev Tableau Server
Perform QA on Tableau Report workflows and ETL process
Sales Force Sales Cloud & Marketing Cloud data Integration
Coordinate the efforts with KPMC Team for Design & Data Mapping Issues
Arrange Project Meetings to discuss Reporting Requirements, and ongoing design issues
Create Technical Design Documents
Use SharePoint for Document & Content Management.
Communicate with IT Teams to discuss Database Schema & Table Design Issues
Use Excel VLookup and Pivot tables to analyze the data in the spreadsheet
Configured Data Lakes on AWS Platform for analytical purpose
Career transition
November 2019 – December 20199
Warner Brother - Burbank CA
March 2019 – October 2019
Project Manager
Responsibilities:
Lead the Project Management, Business & Technical Efforts
Lead Accounting, Sales Force, and Single Sign On Projects
Worked on SAPHana S/4 Hana Modules that are TR, AP, and AR, consolidate amounts in SAP from external SAAS application
Gather Business User stories/User requirements using Agile-Scrum Methodology
Perform Functional & Technical Analysis for financial reporting
Project Management, Project Portfolio Management, Release Management and Change Management Process, Process Development
Document the change in requirement using change management process form and obtain the required approvals from the management
Create improvements to the change management strategy and Risk assessment process
Perform analysis on the requirements for Royalty Statements and the Digital License Contracts
Review, update design documents and upload to the WB SharePoint Site
Create design workflows using MS Visio
Develop ER Diagrams, Develop ETL Process, Develop Queries for the reports
Create Test Strategy, Test Plans and write Test Scripts for QA and UAT
Perform End-To-End Quality Assurance Testing on Desktop/Laptop computers and Mobile phones. In addition, provide support to the UAT team
Perform integration testing to validate Sales Org data sync between Media-morph and SAP ERP Systems
Use Toad for Oracle to write Oracle PL SQL Queries, and Informatica to create ETL Process to fetch external Salesforce Data based on Sales Cloud
Designing of Sales Cloud Screens using Salesforce Lightning tool
Provide Solution to design & architect Data Warehouse Tables and schema
Write complex SQL Queries to develop financial accounting reports, and validate report data using MS SQL Server 2017
Worked on Master Data Management (MDM) and Data Governance
Design Business Intelligence Reports using Tableau
Sales-Force Integration Testing for Warner Brothers Digital Sales Applications
Single Sign-On Design & Testing
Upload docs and reports to SharePoint for Document & Content Management.
Conduct JAD sessions with WB European Clients to discuss the requirements and design issues
PennyMac Loan Services LLC (Full Time) – Moorpark CA
September 2015 - February 2019
Systems Analyst Level V/Project Manager
Responsibilities:
Worked on Loan Servicing, Loan Origination, Single Sign On, Letter automation, Billing & Escrow Statement Generation, Treasury Management, System Migration, Procurement & Web development projects which include a special project for transformation of MSP Legacy System application into a SQL Server & Dot Net Platform based Web Application
Worked on SAP Modules that are TR, AP, and AR, consolidate amounts in SAP from external SAAS application
Maintain Database and Application Security Access
Project Management, Project Portfolio Management, Release Management and Change Management Process, Process Development
Analyzed business requirements and collaborated with technical teams to design appropriate solutions.
Supported UAT processes, ensuring all changes met business expectations and requirements.
Utilized AWS services and Snowflake to facilitate data warehousing and ETL operations.
Created and managed SQL/Snowflake views to support business intelligence and reporting needs.
Document the change in requirement using change management process form and obtain the required approvals from the management
Develop improvements to the change management strategy and Risk assessment process
Responsible for leading the ongoing development and analysis efforts and managing the project.
Create JIRA User Stories (Epics, User Stories, Tasks) using Agile-Scrum Methodology
Create Functional Specs Document.
Project Management of the assigned tickets that includes effort estimation for Life Cycle of the Project
Write Use Cases and create UML Diagrams using MS Visio. Use Case diagrams were used to analyze the system’s high-level requirements. These requirements were expressed through following use cases:
Gather Business User stories/requirements
Perform Functional & Technical Analysis
Perform functional & technical analysis
Create Functional & Technical Specs that includes the API Design and the Database Specs
Create UI wireframes and mockups
Perform AS-IS & TO-BE analysis
Create Use Cases
Work closely with Development team to end-to-end redesign and re-engineered the database and Dot Net ERP & CRM Application Design
Work in Local and AWS Cloud SQL Server Environments
Single Sign On Design & Testing in Windows & Mobile Phone environments
Work on network issues related to the company website and SQL databases
Provide analysis support for SQL Server Infrastructure & Database Migration
Provide Solution to design & architect Data Warehouse Tables and schema
Review the C#, and ASP.NET code using Visual Studio Dot Net Software
Develop ER Diagrams, Develop ETL Process, Develop Queries for the reports
Perform analysis on issues related to SQL Server & Websites Firewalls
Support the Web & Mobile REST & SOAP API Design efforts
Perform End-To-End Quality Assurance Testing on Desktop/Laptop computers and Mobile phones. In addition, provide support to the UAT team
Managed AWS and Snowflake environments, optimizing data warehousing and ETL processes.
Perform End-to-end QA Testing on Web and Mobile API that includes system integration testing
Write SQL Queries to perform Systems analysis and QA analysis, and Import of External Data into SQL tables
Work with SQL Server ETL, SSIS & SRS Packages
Migration of SQL Server 12 databases to Microsoft SQL Server 2016 AWS Environment
SQL Data Integration with SAP
Design Business Intelligence Reports using Tableau and Snowflake
MUFG Union Bank - Monterey Park CA
July 2015 - September 2015
Technical Project Manager - Contract
Time Warner Cable El-Segundo CA
January 2015 to June 2015
Technical Project Manager - Contract
Bank of America - Agoura Hills CA
May 2014 to December 2014
Technical Project Manager - Contract
First American Title Insurance - Santa Ana CA
July 2013 to April 2014
Technical Project Manager - Contract
Los Angeles Unified School District - Los Angeles CA
July 2012 to June 2013
Technical Project Manager - Contract
Bank of America
Technical Project Manager - Contract
January 2012 – June 2012
Sempra Energy – Southern California Gas
Technical Project Manager - Contract
July 2011 – December 2011
Bank of America
Technical Project Manager - Contract
July 2010 – June 2011
Dole Fresh Fruits
Technical Project Manager - Contract
January 2009 – June 2010
FreelanceTechnical Project Manager -Freelance Work
July 2007 – December 2008
American Honda Motors
Technical Project Manager - Contract
January 2007 – June 2007
Countrywide Financial
Technical Project Manager - Contract
August 2006 – December 2006
Southern California Edison
Technical Project Manager - Contract
August 2004 - August 2006
Kaiser Permanente Hospitals Inc.
Senior Programmer Analyst – Full-time
October 1998 – July 2004
Contact this candidate