Portfolio Management Power Bi
Resume:
Rafat Waqar
Sugar Land, TX
Cell Phone: 310-***-****
Email: *********@*****.***
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