Candidates About

 

Fahad A Mohammed

SUMMARY:

·         Extensive experience in requirements gathering and analysis, design, development, testing and validation in Information Systems, data bases, data warehousing(DW), data integration(DI), OLAP and business intelligence(BI) space.

·         Extensive experience in Full Life Cycle Implementation of Data Mart / Data Warehouse applications using Teradata, Informatica PowerCenter 9.x /8.x / 7.x , Informatica Data Quality(IDQ), Informatica Master Data Management(MDM), Informatica Cloud/AWS, and Microsoft SQL Server Integration Service(SSIS).

·         Experience leading and managing small and medium sized Data warehousing and Business intelligence engagements and mentoring junior or associate consultants in both onshore and offshore model.

·         Experience creating ETL mappings, mapplets, sessions, workflows, Performance, error handling, supporting Production system and scheduling ETL in Informatica to Integrate various data sources like Oracle, DB2, SQL Server, Flat Files, XML files.

·         Strong experience in implementing manual change data capture and delete detection functionality in data warehouse.

·         Strong experience in Informatica administration like installations, configurations, etc. on Informatica PowerCenter (9.x/8.x/7.x) in windows and Linux environment.

·         Strong experience in Business Intelligence technologies like Cognos (8.x, 10.x) - Framework Manager, Report Studio, Query Studio, Cognos connection, Cognos Administration, Cognos TM1 and Business Objects Web Intelligence, Desktop Intelligence, Universe design, Crystal Reports, Tableau(Reports, Dashboards, Story board), SSRS, etc.

·         Experience in Dimensional Data Modeling using Star, Snowflake Schema, Fact & Dimensions tables, Physical & Logical Data Modeling using Erwin.

·         Strong Data cleansing, Data quality, Data archiving and Data/Code Migration knowledge and experience using manual process and Informatica Data Quality(parsing, standardization, Column profiling, Value profiling, Pattern profiling, Scorecards, Matching, Cross table profiling, Address validation, etc.) , IDE.

·         Extensive working experience in RDBMS like Oracle 11g/10g/9i/8i, MS-SQL Server, SQL, PL/SQL.

·         Good experience in UNIX writing shell scripts, performance tuning on database and Job Scheduling.

·         Skilled in Unit Test, System Integration Test and UAT (preparing test plan, test cases, validation, etc.)

·         Good understanding of EPIC 2014/2015(EMR - Electronic medical record software) modules like Ambulatory, Inpatient, Hospital billing, professional billing, ADT, Clarity ETL executions (full extract/ incremental extract), status boards, etc.

·         Good understanding of HIPAA compliance, data analysis of file formats like 835, 837, 834, etc.

·         Good understanding of ETL and/or data requirements for the Comprehensive Capital Analysis and Review (CCAR) project for banking sector.

·         Experience in preparing Project documents like Mapping document (source to target), Technical Specifications, Requirements documentation, Installation documents, Test/QA documentation and migrations documents.

·         Good understanding of big data/Hadoop concepts and data profiling and analysis in HIVE using HUE browser.

 

SKILLS:

RDBMS: Teradata 13.x/14.x, Oracle 11g/10g/9i/8i, SQL Server 2012/2008/2005/2000, DB2

ETL Tools: Informatica PowerCenter 10.x/9.x/8.6.1/8.5/8.3/8.1/7.1/6.2, Power Exchange, Informatica Data Quality (Analyst Tool), SSIS, Informatica MDM, Informatica Developer, Informatica Data Explorer, Informatica Metadata manager, Informatica Cloud, etc.

DB Tools: TOAD, SQL * PLUS, SQL * LOADER, Teradata, Import and Export, Oracle SQL Developer

Reporting Tools: Cognos BI 10.1/8.4/8.3, SAP Business Objects Enterprise XI, Desktop Intelligence 12.1.0.914, Web Intelligence, Universe Designer 12.1.0.914, OBIEE, SAP Crystal Reports, etc.

Dimensional Data Modeling / Tools: Star Schema, Snow-Flake Schema, Logical and Physical Data Modeling, Erwin

ERP: SAP, Oracle EBS

Languages: PL/SQL, SQL, UNIX Shell Scripting, JAVA, C, C++, HTML

Operating Systems: Windows, UNIX, AIX, Linux, Solaris, etc.

Other Tools/Software: Microsoft Office 2010 (Excel, PowerPoint), WINSCP, PUTTY, FileZilla, FTP, SFTP, SCP, Telnet, Oracle Developer, Mercury Quality Center, Rational Rose, Microsoft Visio, Rightnow CX (hosted enterprise CRM), Lotus Notes, WinSCP, EPIC (electronic medical record software), JIRA, etc.

 

EDUCATION:

Masters in Management and Information Systems, Southern Illinois University Edwardsville, Edwardsville, IL

 

EXPERIENCE:

Client: Philadelphia Department of Human Services (DHS), Philadelphia, PA – Contractor                 May 2017 – Current
Senior Analyst (Data/DW/BI)
Project Description:

Case management system is used by DHHS to manage care and services to the children in foster care and adoption. Data warehouse is used to report against the efficiency of the care and services provided.

Responsibilities:

·         Working with users, subject matter experts (SME) in creating mock-ups, prototypes, wireframes, Functional Requirements(FRD), business requirements(BRD), Technical design specification documents for reports, UI screens and ETL interfaces, Mapping document (Source to Target), data lineage documents, etc. for placement, referrals, investigations, health/medical diagnosis, child care, foster care, adoption, finance, contracts, payments, budget, etc. related data in DHS.

·         Validated BI/DW/ETL deliverables in DEV, QA and Prod to ensure minimal business impact and delivery of complete solution.

·         Designed and monitored data quality using automated ETL process to ensure accuracy, completeness, timeliness, etc.

·         Data Analysis/Profiling to discover and fix the underlying data anomalies, design issues, data modeling issues, patterns, etc. using SQL, PL-SQL, R, etc.

·         Led team in designing Data, ETL and process flow and assigning tasks/sub processes to team members for requirements gathering and designing solutions.

·         Led the team towards setting standards for requirements documents, testing standards, standards/templates and other artifacts.

·         Involved in providing input towards ETL tool selection, evaluation and proposal processes.

·         Used Cognos to develop reports and perform data validations.

Environment: Oracle, SQL, Informatica, Pentaho, Cognos, SPSS, R, TFS, etc.

 

Client: Health management systems (HMS), Irving, TX – Contractor                                                                       Aug 2016 – Feb 2017

Senior ETL Developer/Analyst (BI/DW/Data/Informatica)

Project Description:

EDW – Enterprise wide data warehouse (EDW) used by HMS to analyze the operational and Key performance indexes (KPI’s) related to health claims, Eligibility and subrogation for Medicare and Medicaid recipients.

Responsibilities:

•      Participated in Joint Application Development (JAD) sessions with project sponsors, end-users, and development team members, subject-matter experts, Business Analyst and stakeholders to understand the business and data requirements.

•      Created mock-ups, prototypes, technical design documents, business (user) requirements documents, test documents, etc. to deliver DW/BI solutions.

•      Created design documents and ETL mapping specification documents for DW/BI solutions and provided estimates for the same.

•      Performed Data analysis/Profiling on State Agency’s (NC, AL, CO, etc.) data (health claims, Medicaid/Medicare recipients, subrogation, call center operations, etc.) to understand requirements of data and business, to ensure data follows the defined standards and to identify data anomalies.

•      Performed analysis, design and customization of Enterprise data warehouse (EDW) with respect to health care and clinical data.

•      Designed DW and ETL and data integration solutions using ETL tools like Informatica Power Center 9.x, Teradata scripts (TPT) and SQL to support business metrics (HIPP, Call center operations, Claims, Subrogation, etc.) for the HMS Enterprise data warehouse (EDW).

•      Extracted analytics data from API, SOAP, Service now, JSON, XML, Web, Flat files, Databases, etc. to load into EDW (Teradata) using Informatica (ETL) and Teradata.

•      Validated BI/DW deliverables in DEV, QA and Prod to ensure minimal business impact and delivery of complete solution.

•      Designed and monitored data quality using automated ETL process to ensure accuracy, completeness, timeliness, etc.

•      Communicated status, concerns, etc. timely to the stake holders to mitigate risks of timely delivery.

•      Assigned and tracked incidents (in Service Now) to Analyst, Developers, DBA’s, etc. to deliver and deploy DW solutions.

Environment: Teradata, Teradata SQL Assistant 14.x, Teradata parallel transporter(TPT), DB2, ETL, Informatica Power Center 9.x, Informatica Power Exchange, Mainframe, Oracle, TOAD, DB2, AIX 7.1, Service Now, Share point, Informatica web services/XML/HTTP/API/JSON, HIPAA Compliance, EDI Files(835, 837), HL7, etc.

 

Client: Cedars-Sinai Health System (Hospital/Medical Center), Los Angeles, CA – Contractor                           Jan 2016 – Jul 2016

Senior ETL Developer/Analyst (BI/DW/Data/Informatica)

Project Description:

EDW – Enterprise wide data warehouse (EDW) used by Cedar Sinai Medical Center to analyze the financial and clinical data to improve their business.

Responsibilities:

•      Participated in Joint Application Development (JAD) sessions with project sponsors, end-users, and development team members, subject-matter experts, Business Analyst and stakeholders to understand the business and data requirements.

•      Created mock-ups, prototypes, wireframes, technical design documents, business (user) requirements documents, test documents, etc. to deliver data integration and DW/BI solutions.

•      Performed Data analysis and Data Profiling on EPIC data (clinical data, physician’s data, patient vitals, admitting, discharge, transfer, imaging, lab, pharmacy, claims, fee schedule, hospital billing, professional billing, ambulatory, inpatient, etc.) to understand business requirements, to ensure data follows the defined standards and to identify data anomalies.

•      Performed analysis and customization of Heath Catalyst (before Healthcare Data works) Healthcare Data warehouse system to load fee schedule and claims data from EPIC Clarity data models into Enterprise data warehouse (EDW).

•      Designed DW and ETL solutions using ETL tools (Informatica Power Center 9.x), PL/SQL and SQL to support business metrics for the Cedar-Sinai Enterprise data warehouse (EDW) by extracting data from EPIC clarity data models.

•      Validated BI/DW deliverables in DEV, QA and Prod to ensure minimal business impact and to deliver complete solution.

•      Designed and monitored data quality using automated ETL process to ensure accuracy, completeness, timeliness, etc. of the EPIC source data in EDW.

•      Identified and mitigated some of the OWASP’s (Open Web Application Security Project) top ten vulnerabilities especially around Personal Identification Information (PII) data, invalid input data, sensitive data exposure, etc.

•      Performed data analysis of chronicles and master files using clarity compass (database object Search, column search, etc.).

•      Provided support for EPIC Clarity ETL incremental/full load jobs, executions and routines.

•      Assigned and tracked incidents (in Service Now) to Analyst, Developers, DBA’s, etc. to deliver and deploy DW solutions.

Environment: SQL, PL-SQL, Oracle SQL Developer, Data Quality, ETL, Microsoft Excel, Informatica Power Center 9.x, Oracle, TOAD, SAP Business Objects, AIX 7.1, EPIC 2014(Electronic Medical Record – EMR software), Clarity, Quest, Power Path (laboratory management solution), Service Now, Healthcare Data Works Knowledge edge (bought by Heath Catalyst), HIPAA Compliance, EDI File formats 834, 835, 837, HL7, etc.

 

 

Client: LOS ANGELES UNIFIED SCHOOL DISTRICT (LAUSD), Los Angeles, CA – Contractor                                   Nov 2014 – Dec 2015

Senior Analyst (BI/DW/Data/Business)

Project Description:

MISIS – My Integrated Student Information System (MISIS)—District’s Information System solution for entering, managing, analyzing, and reporting all data connected to every single student. Early Education / K-12 Data experience.

Responsibilities:

·         Working with users, subject matter experts (SME) in creating mock-ups, prototypes, wireframes, Functional Requirements, Technical design specification documents for reports, screens and ETL interfaces, Mapping document (Source to Target).

·         Propose possible alternative technical Data/ETL solutions that fulfill the business requirement in the technical infrastructure.

·         Working with Developer, QA (onshore/offshore) and manage development, QA/testing and deployment as per Service Level Agreements (SLA’s).

·         Data Analysis/Profiling to discover and fix the underlying data anomalies, design issues, data modeling issues, etc. using SQL and PL-SQL.

·         Working with developers (onshore and offshore) to understand the current design and implement new business requirements with least impact to the business.

·         Design and lead data solutions and ETL interfaces to solve business problems and fulfill business requirements for MISIS.

·         Test and validate reports, screens or ETL interfaces before deployment and report bank any issues to Development and QA.

·         Investigate data quality issues by manually analyzing data and those reported by users of the Data Warehouse/Information System and manage it to resolution.

·         Identified and mitigated some of the OWASP’s (Open Web Application Security Project) top ten vulnerabilities especially around Broken Authentication and Session Management, invalid input data, sensitive data exposure, etc.

·         Managing and tracking bugs and enhancements on Microsoft TFS (Team Foundation Server).

Environment: SQL, PL-SQL, Oracle SQL Developer, Data Quality, ETL, SSIS, SSRS, TFS (Team Foundation Server), Visual Studio 2010, SQL Server Studio, Microsoft Excel, Informatica, Oracle, OBIEE, ODI, Scrum/Agile methodology.

 

Employer: iGATE

Client: Union Bank (MUFG), Los Angeles, CA – Contractor on SOW                                                                         July 2014 – Nov 2014

Data warehouse Solutions Analyst/Lead (BI/DW/Data/Informatica)

Project Description:

Manage, lead, design and implement ETL and/or data requirements for the Comprehensive Capital Analysis and Review (CCAR) project and the loan data.

Responsibilities:

•      Conducted weekly status calls with business users, SME’s, Data Analysts and DMO and with other development teams to understand their requirements about routine maintenance, downtime, code migrations, enhancements, change requests, etc.

•      Managed and led the offshore team & onshore team to deliver DW/ETL business solutions within the agreed SLA's.

•      Participated in Joint Application Development (JAD) sessions with project sponsors, end-users, development team members, subject-matter experts and stakeholders to communicate their perspectives with each other, resolve any issues.

•      Prepared and managed time/cost/resource estimates needed for projects (SOW / WO) and worked in architect role as and when needed.

•      Defined scope, goals and deliverables (that support business goals) by collaborating with senior management and stakeholders.

•      Effectively communicated project expectations to team members and stakeholders in a timely and clear fashion.

•      Delegated tasks and responsibilities, led, managed and mentored a team of 2-3 associates on site and offshore.

•      Designed/architected data integration and ETL solutions (using ETL tools and SQL) to create and support business metrics for CCAR and loan data for federal regulatory reporting.

•      Performed Data analysis and Data Profiling using SQL queries and tools before and after designing ETL solutions.

•      Created mock-ups, prototypes, wireframes, technical design documents from the business (user) requirements documents received form the business users or Data Analysts or DMO.

•      Lead an off shore team of two or more resources to help design solutions for the CCAR project.

•      Performed EDIT CHECK (using RULE ENGINES) validation to validate CCAR (loan and mortgage) data to ensure data quality before submitting to Federal Reserve.

•      Performed data analysis/profiling of the loans and mortgage data (BDE, UBDW, Green Plum, MSP, AFS, SIL, etc.) before populating into the data warehouse.

•      Utilized concepts and functionality of Informatica Data Quality (IDQ), Informatica Data Explorer (IDE) tools to profile and monitor data issues, discover and analyze all data anomalies across all data sources.

•      Assigned and tracked incidents (in HPSM) to Analysts, Developers, DBA’s, etc. to deliver and deploy DW solutions.

Environment: SQL, PL-SQL, Flat files, Oracle SQL Developer, Data Quality, Informatica 8.x/9.x, IDQ, IDE, Green Plum, PG ADMIN 3, Oracle, Autosys, Unix, Linux, APEX, Scrum/Agile methodology, HP Service manager(HPSM), etc.

 

Client: FedEx, Memphis, TN – Contractor                                                                                                                      October 2013 – July 2014

Data warehouse/ETL Solutions Analyst  

Project Description:

Manage SSIS environment which includes development, support, maintenance and administration.

 

Responsibilities:

•      Designed/architected ETL solutions to create and support business metrics for Accounts Receivable Dashboard for data in SQL Server and Teradata.

•      Used Data quality tools and/or queries for Data Analysis, Data Profiling (row/column level, statistics, pattern, standardization, address validation, deduplication), Data Validation, etc. to ensure data quality.

•      Utilized concepts and functionality of Informatica Data Quality (IDQ), Informatica Data Explorer (IDE) tools to profile and monitor data issues, discover and analyze all data anomalies across all data sources.

•      Performed source system data (Oracle EBS, Teradata) profiling and work with the business users to cleanse the data before loading in the Data mart.

•      Involved in migration of EDW ETL objects from Microsoft SSIS to Ab Initio.

•      Performed ETL Testing/Validation (Designed and documented test strategy, test plan, test cases, test results, etc.) post migration of ETL jobs from SSIS to Ab Initio.

•      Performed high code review of Ab Initio graphs (ETL) n Ab Initio GDE to ensure business logic is as per original SSIS code and user requirement.

•      Participated in Requirements gathering and Data Modeling (Dimensional and Relational).

•      Performed ETL Testing/Validation (Designed and documented test strategy, test plan, test cases, test results, etc.)

•      Validated ETL data in the data mart using the Business Objects reports/ dashboard developed by the development team.

•      Created SAP Business Objects QAAWS queries to analyze and test the data in the data mart.

•      Provided OLAP data to the AR dashboards using analytical functions and SSIS packages.

Environment: Microsoft SQL Server 2005/2008, Microsoft SQL Server management studio 2005, Microsoft SQL Server Integration Service(SSIS), Ab Initio, TOAD, SQL SERVER 2008, SAP BUSINESS OBJECTS 4.x, T-SQL, SQL, PL-SQL, Flat files, Oracle SQL Developer, Data Quality, Informatica 8.x/9.x, IDQ, IDE, etc.

 

Employer: Noetix Corporation, Granite City, IL, USA – Employee                                                                            Aug 2009 – July 2013

Data Warehousing/Business Intelligence Analyst (Informatica/BI)

Noetix provides the full spectrum of enterprise business intelligence/data warehousing solutions for Oracle applications from real-time operational reporting to strategic analysis. Noetix bought Jaros technologies (my previous employer).

Few clients I implemented DW/BI solutions for (through Noetix Corporation) between August 2009 and January 2013:

Invacare Corp, GE Shared services, GE Transportation, GE Energy, GE Health, GE Medical, CVS Pharmacy, Navilyst Medical, MoneyGram, etc.

Responsibilities:

•      Collaborated with senior management to understand the data architecture strategy and long term plans.

•      Collaborated with technical and business team to understand the data requirements.

•      Performed source system data (Oracle ERP/EBS, SQL Server) profiling to cleanse the data before loading in the ODS and DM.

•      Performed OLAP and OLTP Design/architect roles for high level design and configuration at the beginning of the project.

•      Designed physical and logical data models (relational and dimensional) for ODS and DM layers to support changing business requirements.

•      Reverse engineered the reports and identified the Data model elements (in the source systems), Dimensions, Facts and Measures required for new enhancements of reports.

•      Enforced referential integrity in the OLTP data model for consistent relationship between tables and efficient database design.

•      Assisted business users in data testing and validation (UAT) by developing Test plans, Test Cases (negative, positive) and reports.

•      Implemented the end to end Standard Noetix Analytics 4.x/5.x Data warehousing solution (ODS, DM) & other DW solutions using Informatica, UNIX, Oracle, PL/SQL, T-SQL.

•      Designed/architected/Developed various ETL solutions to load data from various sources using transformations like Source Qualifier, Expression, Filter, Router, Update, Sorter, Lookup, Aggregator, Joiner, and SQL to support business requirements.

•      Performed ETL Testing/Validation (Designed and documented test strategy, test plan, test cases, test results, etc.) to ensure data was complete and correct as per the data models.

•      Identified data issues and improved data quality by Data Profiling (row/column level, statistics, pattern, etc.), Structural Profiling (PK Inference, FK Inference), Score carding, IDQ and IDE tools.

•      Implemented Type 1, Type 2 and Type 3 slowly changing dimensions (SCD), parameter files using Informatica Powercenter.

•      Utilized concepts and functionality of Informatica Data Quality (IDQ), Informatica Data Explorer (IDE) tools and manual data quality processes to profile and monitor data issues, discover and analyze all data anomalies across all data sources.

Environment: Informatica Power Center 9.1/8.6.1/7.x, Data Quality, IDE, IDQ, Cognos 8 /10, Oracle 9i, Oracle OBIEE, Oracle SQL Developer, SQL server 2005/07, PL/SQL, SAP Business Objects XI/3.x, Flat files, UNIX-AIX 5.1, Linux, Putty, WinSCP 4.3.2, Toad for Oracle 8.6.1, MS-office, MS-Visio, Lotus Notes.

 

Jaros Technologies, Granite City, IL – Contractor                                                                                          December 2008 – August 2009

Data warehouse/Informatica Developer

Jaros Technologies provides the full spectrum of enterprise business intelligence/data warehousing solutions for Oracle applications (EBS) from real-time operational reporting to strategic analysis.

 

Responsibilities:

 

•      Participated in analysis, engineering, development and Support of Jaros Analytics product (Packaged Enterprise Data warehousing solution).

•      Actively worked with Informatica Power Center to create and manage Data Marts and Data Warehouse including scheduling jobs, troubleshooting job failures, performance tuning, creating enhancements, managing Cognos reports design and development, etc.

•      Provided on call DW support to GE on rotation basis even on the weekends.

•      Worked extensively on resolving support tickets, defects, bugs, data issues, job failures, etc. of the DW/BI solution.

Environment: Informatica 8.1.1, TOAD, Oracle11g, Oracle SQL Developer, UNIX, Cognos 8.3, Cognos 8.4, SQL, PL-SQL, Putty, WinSCP, etc.

 

United States Steel Corporation, Granite City, IL – Contractor                                                                 May 2008 – December 2008

Data warehouse/ETL Developer (PL-SQL/SQL)

United States Steel Corporation, headquartered in Pittsburgh, PA, is an integrated steel producer with major production operations in the United States, Canada and Central Europe and an annual raw steelmaking capability of 29.3 million net tons.

Responsibilities:

•      Participated in Joint Application Development (JAD) sessions with project sponsors, end-users, development team members, subject-matter experts and stakeholders to understand their requirements about routine maintenance, downtime, code migrations, enhancements, etc.

•      Created and maintained database/ETL objects (stored procedures, triggers, etc.) for cast heat, slabs area to populate data warehouse for Steelmaking Process Control Project

•