Muhammad Rizwan Email & Phone Number

Buffalo, Ny, Us

Ibm Buffalo, Ny Usa

Downtown Columbus, Oh

HPE (Hewlett Packard Enterprise) is Managing Ohio MITS (HEDIS - Medicaid / Managed Care Information Technology Systems (Ohio Medicaid Managed Care Program)) front end system, which interact directly with users.Responsibilities:• While worked for State of Ohio (Medicaid - MITS) represented HPE (Hewlett Packard Enterprise) world fame HP in Computing world. • HPE is fully working under the supervision of Ohio MITS, strictly followed rules and Regulations of Ohio Medicaid Managed Care Program (HEDIS). • HPE is implementing changes under the releases every month, every release contains different projects. • As team lead responsible to maintain MAR and BIAR reporting systems (Data Warehouse), Ohio MITS is using Informatica Power Center ETL to load data from OLTP to OLAP (Data Warehouse) and SAP Business Objects for both reporting systems.

Columbus, Ohio

Heavy used of SQL and Toad to performed Data Analysis until find root cause of problems and suggested solutions, Data Quality, Data Governance, Data Profiling, Metadata Repository (Mask input) (Data Dictionary), Data Mapping, Master Data Repository, Designing of ETL (Informatica Power Center) framework and worked with Informatica Power Center developer, Designing of MicroStrategy framework and worked with MicroStrategy developer. Maintain MARI (Measuring Actuarial Rate Impact) on Mainframe, Developed test cases on all issues listed in every month release for System testing and UAT and documented in release document in SharePoint, Performed System Integration Testing (SIT) and UAT, documented all results with status passed/fails, created all defects in HP ALM (QC) used ALM to managed all defects.

Kc, Mo & Itasca, Il

Lead the project to convert all DataStage Server jobs into DataStage Parallel jobs with some major changes in in related table in OLAP/Data Warehouse. Lead team of 20 resources (DataStage developers and QAs).

Syracuse, New York Area

•Worked on DWH – FRDM (Facets Reporting Data Mart) is a project under Enterprise Data Warehouse; MVP is migrating from Sagent to Informatica PowerCenter and SAP BO to Cognos. •MVP Health Care using RDBMS; Oracle for Data Warehouse and Sybase for Health Care Systems, MVP also using Data Centric for quick and better response. •Analysis and verified all mapping from 4010 to 5010, performed gap analysis, and documented. •Worked in Production support on Data Warehouse and EDI Mapping from 4010 to 5010. • Modified all COBOL program in order to accommodate changes from 4010 to 5010 format (HIPAA-EDI). • Modified all CICS Screen (COBOL, CICS, DB2 program) used CICS Transaction Server Channels and Containers to accommodate changes from 4010 to 5010. • Worked on System Testing (functional Testing) of NYS 837I (Institutional Claims and NYS 820 Medicaid Premium Payment). •Worked on Data Profiling and Input Mask used Informatica IDE, updated Master Data Repository. •Performed Risk Analysis due to new Data Mart/Critical situation and suggested precaution to minimize Risk. •Used UBE (Ultra Edit) to view and Data Manipulation to test EDI-HIPAA Transactions with different options. •Extensively performed Data Analysis, used TOAD to generate and run SQL, extracted result in Excel sheet, and used filters, formulas, Macros with advance functions and features to analyzed reports as per requirements by the management. •Extensively worked on designing ETL Framework for Informatica PowerCenter, defined Source Target, Metadata Repository, Configuration and logs. • Worked on Cognos; Query Studio, Report Studio, Analysis Studio, Event Studio. •Experience UNIX administration functions to provide privileges to UNIX users. •Worked in Systems Development Life Cycle (SDLC); Agile (Scrum) Methodology.

Virginia Beach, Va

•Amerigroup Health Care using RDBMS; Oracle for Data Warehouse, and DB2 on IBM Mainframe. •Extensively worked on Data Lineage, Data Integrity, Data Quality to serve Data Warehouse for the purposes. •Worked on new business as well as expansion in business areas in different states including Texas State (TX-JP expansion), NYS (NY Homeless, NY Health Plus expansion).•Conducted JAD session, to discrepancies, and workflow concept, ability to gather and document the 'As-Is' and 'To-Be' processes, used Visio and IBM template for Data Flow Diagram. •Validated Medical, Hospital and Dental claims in FACETS, verified Codes with description and requirements, verified adjudication process of Claims of FACETS. •Extensively used Claims processing, Provider, Subscriber/Member, Utilization Management and NetworX Applications in FACETS. •Extensively worked on FACETS for EDI transactions; 820-Membership enrollment, 837P/I/D-Claims and 835-Remittances and validated the Claims and perform Adjudication in FACETS. •Extensively performed Data Analysis, used TOAD to generate and run SQL, extracted result in Excel sheet, and used filters, formulas, Macros to analyzed reports as per requirement to make decision. •Worked on Migration of existing Informatica PowerCenter objects V8.1 to V8.6 within Configuration Management environment with extensive regression testing requirements. Administration of PowerCenter. •Closely worked with Informatica (Power Center 8.6) developers, performed analysis for the Transformation and mapping and verified data (Data Warehouse) used SQL. •Performed Data Manipulation to test different ETL transformations with different scenarios. • Used MS Office suite with Outlooks, Visio, Power Point, Excel/Word) & SharePoint. •Worked in Systems Development Life Cycle (SDLC); Agile (Scrum) Methodology.

Palo Alto

•Leading a team of 8-9, used TRACKER for TASK and TIME management, distributed the work among them as per their strength and knowledge and resolved issues for each tester. • Developed Test Plans, Test Cases for System Testing from BRD/FRD and change request. •Worked on EDI-HIPAA transactions; 834, 835, 837P and 837I). •Performed manual testing considering both positive and negative scenarios. • Performed Unit Testing, Integration Testing, Systems Testing, Functional and Regression Testing of FACETS. • Performed Data Manipulation to test different ETL transformations with different scenarios. •Worked with EDI transactions 837 and 835 Remittances and validated the Claims in FACETS. •Involved in processing Claims in FACETS and validating the full cycle process to make sure the checks are generated. •Used HP ALM Quality Center to track and report bugs and defects and was also responsible for communicating the status to everyone involved. • Used SQL to performed Back End Testing for data validation to ensure the accuracy of data. • Palo Alto follows Systems Development Life Cycle (SDLC); Agile (Scrum/XP) Methodology.

Toronto, Canada

•Worked on requirements gathering, source data analysis, and identified business rules for data migration and for developing Data warehouse / Data Mart. •Worked on Entity Relationship, prepared ER Diagrams to resolve issues in Data warehouse. •Worked on Data Profiling used ERwin for Metadata Repository, Data Mapping for ETL Process. • Extensively worked on Designing ETL Framework for DataStage, defined Source (OLTP), Target (DWH), metadata repository, configuration and logs, etc. •Worked on DataStage with difference Transformation used VSAM/GDG/DB2 (OLTP) move Data to ODS, used Transformation to cleansing data and filter data as per requirements, move data from ODS to Target OLAP. •Participated in creation of Data Models (Logical and Physical, Star Schemas, Snowflake Schemas) used Erwin. •Worked on documentation of the data model using an extensive set of ERwin conceptual, logical and physical diagrams. •Worked in Systems Development Life Cycle (SDLC); Agile (Scrum) Methodology.

Ann Arbor / Detroit, Michigan

•Supported Transportation and Utility Billing Applications, Billing application using IMS and DL/1.•Carrying Pager on routine basis to support/resolve production issues. •Modified existing program and added new program to fulfill Business Requirement for Billing and Transportation applications.

Toronto, Canada

•Worked Credit Card Application; add and modified programs as per business requirement. •Worked on Retail Banking Applications using IMS and DL/1, wrote new and modified existing programs and conducted both unit and regression testing. •Worked on Data Lineage, Data Profiling, participated in Data Modeling (Logical and Physical) Design and Normalization up to 3NF for Databases/Mata Mart/Data Warehouse used CA-Erwin, CIBC moving to maintain Data Warehouse, attended full training on DataStage.

Mississauga, On

•Worked on EDI, System (host) received data (in-bound) from broker system, run sub-application to convert into data file, run policy application, data with errors and sent back to brokers. •Worked on Insurance Package HUON (Personal and Commercial)to customize according to Canadian Insurance Standard CSIO and company standard as well.

Rawalpindi

•Performed Analysis, Designed/redesigned, Developed, and Implemented Applications: Payroll, Accounts (GL, receivable/payable, Monthly/yearly Compilation of Defence Accounts, ad-hoc reports), MIS, Recruitment, production support to all running applications etc. •Conducted feasibility study for enhancement of Data processing Facilities, made recommendation with the comparative statement “As-Is” and “To-Be”, Project was approved by the concern Ministry of Federal Government. • Successfully completed Conversion of applications (Codes) and Data from old system to newly installed system with enhancement of application to fulfill Business requirements.

Rawalpindi

•Joined as Programmer and quickly promoted as Systems Analyst on the basis of performance. •Developed and implemented Civil Exchange and Military accounts systems successfully. •Restructure defence account system and reduced processing time by 40%. •Learn accounting and defence accounting both in detail to perform effectively and efficiently.