Rafat Waqar

Sugar Land, TX

Cell Phone: 310-***-****

Email: adz8xs@r.postjobfree.com

Seeking Position: Senior IT Business Systems/Data Consultant

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 SAP HANA Modules Accounts Payable/Accounts Receivable

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

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

Work Experience

Cyberthink Inc - Contract at Charles Schwab Corporation

January 2023 – April 2023

Senior Business Systems/Data Analyst

Followings were the duties:

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

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

Worked on SSIS packages

Worked Tableau Reports

LumenData Inc - Full time

April 2022 - December 2022

Senior MDM Business Analyst

Followings were the duties:

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

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

Microsoft Azure Cloud

SAP HANA

MS Dynamics 365

MPhasis Inc - Full time

Project at American International Group

January 2022 - April 2022

Senior Lead Business Systems/Data Analyst

Following are the duties:

Work on an Application/Data Migration Project in an Agile-Scrum Environment on AWS Platform

Provide support for project planning & create migration plans

Work on Data Governance that dictates governance policies and set data security standards

Obtain User Stories and convert the stories into functional requirements

Perform Business/Systems & Data Analysis

Create Functional Specs Document

Perform Program Management & Project Management Duties

Content Management using Confluence

Create product & sprint back logs using Jira tool

Set up daily scrum meetings to discuss product & sprint issues

Create a Test Strategy & Write Test Plans/Test Scripts for System Integration Test & UAT

Store documents in MS SharePoint Website

Design Data-warehouse target tables and provide metadata in each table design

Design Entity Relationship Diagram to build the relationship between the tables

Create Data/Field Mapping from source to target environment

Design ETL Process using source to target fields

Verify the data that the data has been migrated in the target table, and ready for unit testing

Write unit test queries by selecting the required data for reports

Design the reports in Power BI based on unit test queries, and run the test reports

Mindlance Inc - Contract

Google - Remote Position

March 2021 – July 2021

Senior Data Analyst

Following are the duties:

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

Artech Information Systems

Project: Kaiser Permanente - Pleasanton CA (Remote)

August 2020 – November 2020

Solution Architect

The duties are as follows:

Lead the Project Management, Business and Technical Efforts for Pharmacy Claims Reporting Project

Gather Business User stories/requirements, and perform analysis 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 document

Worked on Master Data Management (MDM) and Data Governance

Provide Solution to design & architect Data Warehouse Tables and schema

Perform ODS Tables & Metadata Analysis, and support the efforts to build ODS data dictionary

Identify Data Source tables & columns in ODS for Data Mapping

Perform Data Analysis & Data Mapping using Oracle Data Storage (ODS) for KP Financial Reporting

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

Test complex Oracle Queries for Data Mapping in AWS Cloud Environment

Create workflow process diagrams for reports workflows using MS Visio

Design Alteryx ETL Workflow to be used as Data Source for Tableau/Power BI Reports, and run the workflow jobs in Alteryx Gallery

Sales Force Sales Cloud, B2C Cloud & Marketing Cloud data Integration

Perform QA on ETL process

Use SharePoint for Document as Document Repository.

Coordinate the efforts with Team for Design & Data Mapping Issues

Arrange Project Meetings to discuss Reporting Requirements, and ongoing design issues

Communicate with IT Teams to discuss Database Schema & Table Design Issues

Software used: MS Office 365, Toad for Oracle, Oracle SQL Developer, Tableau, Power BI, MS Visio, Jira Project management tool for creating and managing project/initiative artifacts

Randstad Technologies - Contract

Project Kaiser Permanente – Burbank CA (Remote)

January 2020 – June 2020

Data Architect

The duties are as follows:

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

Design Alteryx ETL Workflow to be used as Data Source for Tableau/Power BI Reports, and run the workflow jobs in Alteryx Gallery

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

Software used: MS Office 365, Toad Data Point, Oracle SQL Developer, Alteryx Designer, Tableau, Power BI, MS Visio, Jira Project management tool for creating and managing project/initiative artifacts

Genuent Global LLC - Contract

Warner Brother - Burbank CA

March 2019 – December 2019

Senior Business Analyst

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

Design Alteryx ETL Workflow to be used as Data Source for Tableau/Power BI Reports, and run the workflow jobs in Alteryx Gallery

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

Singl 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

Software used: MS SQL Server Management Studio 2018, Oracle Database, MS Access, MS SharePoint, Office 365 that includes Word, Excel, PowerPoint, Jira Project management tool for creating and managing project/initiative artifacts

PennyMac Loan Services LLC (Full Time) – Moorpark CA

September 2015 - February 2019

Systems Analyst Level V

Lead the Project Management, Business & Technical Efforts

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

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

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

Conduct facilitation meetings with line of business & Business Partners to discuss the current issues within the system

Worked Agile/Scrum Environment for existing Application enhancements and used full SDLC for the new Projects

Worked on Data Warehouse, Data Mapping, and Data migration projects using Informatica version 10.2.0

Worked on Master Data Management (MDM) and Data Governance

Use Google Docs for Document & Content Management

Software used: MS SQL Server Management Studio 2018, Oracle Database, MS Access, MS SharePoint, Office 365 that includes Word, Excel, PowerPoint, Jira Project management tool for creating and managing project/initiative artifacts

MUFG Union Bank - Monterey Park CA

July 2015 - September 2015

Senior Business Systems Analyst

Time Warner Cable El-Segundo CA

April 2015 to May 2015

Senior Business Systems Analyst

Bank of America - Agoura Hills CA

May 2014 to December 2014

Senior Business Systems Analyst

First American Title Insurance - Santa Ana CA

July 2013 to November 2013

Senior Business Systems Analyst

Los Angeles Unified School District - Los Angeles CA

October 2012 to November 2012

Senior Business Systems Analyst

Bank of America - Calabasas and Agoura Hills, CA

December 2011 – August 2012

Senior Systems Analyst

Sempra Energy - Los Angeles, CA

July 2011 – September 2011

Senior Business Analyst

Bank of America - Agoura Hills CA

July 2010 – June 2011

Senior Systems Analyst

Dole Fresh Fruits - Westlake Village, CA

November 2009 – March 2010

Senior Business Systems Analyst

Self Employed

August 2007 – October 2009

Senior Business Systems Analyst

American Honda Motors Torrance, CA

January 2007 – July 2007

Senior Business Systems Analyst

Countrywide Financial - Westlake Village, CA

August 2006 – December 2006

Senior Business Systems Analyst

Southern California Edison - Rosemead, CA

November 2004 – August 2006

Senior Business Systems Analyst

Kaiser Permanente Hospitals, Inc. - Pasadena, CA

October 1998 – July 2004

Senior Programmer Analyst

Contact this candidate