Jain Philip

*** * *** ***** ** Elmhurst IL ***** 630-***-**** adcopp@r.postjobfree.com https://www.linkedin.com/in/jainphilip

Summary

14+ years’ Industry experience in building Data warehouse and BI solutions in disparate ETL and BI technologies. Experienced in Data Analysis, Requirement Analysis, Conceptual Design, Process flow diagrams, 3NF and dimensional modeling, Data Standardization, Indexing, data mapping for ETL processes. Exceptional analytical and problem-solving skills.

Proficient in documenting BRD, Functional &Technical specifications and leading teams to provide end-to-end solution in a timely manner.

Architect level experience in implementing Master Data Management Systems (MDM) such as Profisee. Hands on experience in modeling MDM domains, design architecture workflows, Integration with downstream applications through APIs as well as subscription views.

Extensive knowledge and experience with Oracle/EXADATA and have managed large volumes of data in those environments. Implemented techniques like Partitions for efficient data management and query performance.

Expert level knowledge in SQL Server including Management of very large data sets using techniques like Partition functions, partition schemes, SQL Optimization/tuning, SSIS Coding.

BI Solutions include construction and maintenance of large Data warehouse environments and also FDA regulated industries, subject to a great deal of scrutiny for Data Quality and documentation requirements.

Architecture level experience with enterprise reporting tools such as Business Objects, Tibco Spotfire including construction and maintenance of their semantic layers, build/oversee innovative report construction activities.

Advanced Architecture & Coding experience with SAP BODS including ETL Integration with cloud-based applications such as Salesforce, Oracle CRM, Host Analytics using their connectors and web service calls. Experienced in making use of tools like SOAP UI, XML Notepad to make alterations to WSDL files as needed by the applications. Experienced in handling complex XML datasets from web applications.

Advanced knowledge in Power BI & DAX, have set up many complex datasets that does statistical analysis, control charting, production/OPS reporting, Product cost allocations etc.

Education

BACHELOR’S IN COMPUTER ENGINEERING 1991 MADURARI KAMARAJ UNIVERSITY (INDIA)

Certifications in Machine Learning (Stanford University) 2016

Data Visualizations in Tableau (Duke University) 2016

Skills & Abilities

MANAGEMENT-TECHNICAL LEADERSHIP

Managed team sizes of up to 4 team members in BI/Data warehousing Projects and is experienced in Onsite/Offshore model for Project execution.

TECHNICAL SKILLS

Azure SQL DW, Oracle EXADATA, MS SQL Server, DB2

Azure Data Factory, Azure Data Lake, Informatica PowerCenter 9.x, SAP BODS/DI, SSIS

Power BI, Business Objects, SSRS, SSAS, Spotfire, Tableau 9.x,

Profisee, SQL Server/MDS, ERwin, TOAD,

Azure Event Hub, Stream Analytics, Azure Service Bus, Azure Logic Apps,

Experience

BI-Consultant Department of VA Jan 2020 – Present

https://www.va.gov

Working as BI-Consultant with their PGD data integration project where in which we are bringing in PGD (Patient Generate Data) into a central data warehouse for research purpose. The API repository and the interfaces are built based on the FHIR standards and is hosted in a cloud platform. The storage structures include base64 encoded BLOBs holding the objects in its native format and the ETL process decode and parse them into relational structures in the data warehouse.

EDW & MDM Architect EVRAZ NA, Chicago, IL May 2016 –Sept 2019

https://www.evrazna.com

Functional Areas

Solution Architecture for various BI Initiatives at EVRAZ, currently focused on Quality & Operations related reporting at different manufacturing units across US & Canada.

Design/Architecture of Master Data Management (MDM) initiatives. We are using Profisee for MDM and have implemented Vendor Master, Product/SKU attributes, Chart of Accounts in Profisee.

Cloud adoption for BI team. We have already migrated our EDW to Azure. Currently we are using IaaS options in azure and working our way towards their PaaS offerings such as SQL Data Warehouse, Azure ML, Azure Streaming etc.

Architect/Project Lead for MDM implementation

EDW team took the lead role in setting up Profisee at EVRAZ and I have worked extensively in that project starting from the initial pilot implementation till many of the critical MDM domains were moved to Profisee. The following are some of the contributions I had for MDM project.

Actively involved in setting up Profisee server environments partnering with infrastructure team and Profisee tech support.

Initial POC project in Profisee where we moved Vendor Master subject area into Profisee. Worked with Purchase team in identifying the business process (workflow) of establishing a vendor (supplier) and different entities to be maintained. We are also using Profisee workflow features so that all record keeping related to vendor creation can be maintained with in Profisee including electronic signatures of various approvers

After successful implementation of Vendor Master in Profisee we a have brought in many other subject areas into Profisee such as Product Specifications, Manufacturing Process Parameters, Melting Practice,Employee Master, Chart of Accounts, different product Hierarchies etc. There is a number of enterprise applications directly integrated with Profisee like Oracle EBS, Workday (HR/Payroll), MES Systems, Purchasing systems such as Maximo.

The following are some my contributions for MDM on an ongoing basis.

Build/Maintain the data models.

Architect level contributions to build workflows for specific use cases.

Architecture level support creation/maintenance of Business rules.

Negotiations with applications teams in integration/automation jobs with Profisee.

Solution Architect for CANADIAN OPS REPORTING

EVRAZ is targeting to increase their productivity by 20% in the next 2 years and they have brought in external management consultants (Falconi) to help with the process. Worked with Falconi team in identifying the KPIs to be tracked and Reporting/Dashboard templates to deliver those to different user groups. The KPIs being tracked were OEE (overall equipment efficiency), performance, quality and availability. The reports were decided to be delivered through various channels such as TV displays (android boxes) at different locations inside the plant, mobile devices, PC/web browsers. Updated EDW Data model to accommodate the new additions, spec-ed out ETL and report development activities and coordinated development/delivery of those.

Data Architect & Development Lead for PRODUCT/SKU LEVEL COSTING Project

This is a new subject area in EDW where in which we are bringing in operational and financial data together for allocating manufacturing cost per Product/SKU. There are several use cases for this information such as profitability analysis, management/control of various production costs, statutory reporting to government, The overall solution included the following components. The cost allocation step of this is done in Hyperion cubes, EDW gathers the data from source systems and stage in EDW from the source systems and generates files in specified format so that the Hyperion automation scripts can pick up. Once the cubes are refreshed, output from the cube will come back to EDW in a similar format we are feeding them. This data will be normalized in EDW and made available for further consumption in different use cases.

Project Lead/Architect for QADW migration to EDW

QADW was a legacy reporting database to facilitate R&D and Quality teams for their analytical data needs. Brought in QADW to EDW for better ownership and maintenance of this dataset with common tools technologies.

Project Lead & Architect for EDW Azure Migration Project

This project was to revamp EDW architecture to segment EDW Data structures appropriately so that there is a clear separation of different data tiers in EDW .The overall objective is to bring in all legacy reporting databases into EDW on a continuous basis. EDW has been migrated to Azure the early 2019. Currently we are using IaaS options in azure and working our way towards their PaaS offerings such as SQL Data Warehouse, Azure ML, Azure Streaming etc.

Project Lead/Architect for Power BI Reporting..

Played a key role in bringing in Power BI as the enterprise reporting tool for EVRAZ. Worked with the infrastructure team in enabling Azure AD sync so that power Bi credentials aligns with on prem windows sign in, this also helped in using other azure services also using the same credentials as that of on prem AD

We have started migrating our reporting to power BI from mid-2017 onwards and its widely accepted with our user community now. With this larger user adoption and the needs for addition features, we have moved to premium capacity last year. We have 400+ users and its growing at a steady rate.

Manager – Reporting Operations Conifer Health Solutions, Tinley Park, IL Dec 2015 –May 2016

https://www.Coniferhealth.com /

Leading a team of 7 Report developers Delivering reporting solutions for internal and external clients.

Environment: Cognos 10.2, MSSQL Server 2012, SSIS, SSRS, Crystal Reports

BI Solution Architect Entrust data card, Shakopee, MN Dec 2012 –Nov 2015

https://www.entrustdatacard.com/

SOLUTION ARCHITECT & PROJECT LEADER FOR ORACLE CRMOD/EDW INTEGRATION PROJECT.

CRMOD is a cloud based CRM solution from Oracle and this project brought in this data to EDW and conformed to the rest of the subject areas in BI. We had many challenges from its get go like no direct connectivity options to the source other than the standard web Services, data size limitations of web services, challenges with CDC aspects of the datasets. I was instrumental in figuring out a solution approach using SAP DS web service connectors and control structures. Major accomplishments with this project were Sales Pipeline reporting, Budget vs Actuals vs forecast reporting, Forecast/Planning reporting.

SOLUTION ARCHITECT FOR SALESFORCE/EDW INTEGRATION

Entrustdatacard has moved to Salesforce as their enterprise CRM application with the acquisition of Entrust and completed the project integrating salesforce data to EDW. This project included redesigning of CRM subject area in EDW in accordance with the additional data elements coming in from salesforce and also data conversion and preservation of data elements from CRMOD. The ETL/Data Integration was using Salesforce connectors for SAP DS. Took key role in setting up the connectors and establishing SSL certificates needed for salesforce.

PROJECT LEADER FOR EDW FOUNDATION PROJECT.

Entrust data card is one of the earliest implementers of a readymade DW solution from Business Objects commonly referred as Rapid Marts. Over the years Data Card had done several customizations to the base product and those were not done in an orderly fashion. This project will scrub through the current Rapid Mart content subject area by subject area, reverse engineer the content into Erwin, scrub through the data elements and remove data elements that are no longer relevant for the business.

ENVIRONMENT:

Oracle Exadata, SAP DS, Business Objects, Oracle EBS, Salesforce.com, Host Analytics

Principal IT Technologist Medtronic Inc., Brooklyn Center, MN Jun 2006 - Nov 2012

https://www.medtronic.com

EMMA (ENVIRONMENT FOR MANUFACTURING METRICS AND ANALYSIS)

This is for Medtronic’s CRDM business consolidating Engineering Measurement & SPC data across globe into a centralized BI platform. I have taken several roles in this project.

SOLUTION ARCHITECT

Lead a team 4 Business Analysts in interviewing different levels of the MFG Operations team to come up with specifications for the customer facing components of the project.

Identified the source systems and the legacy reporting solutions that need to be part of the overall solution. Designed processes to build cross reference data between source systems and legacy reporting databases.

Taken the lead role in developing/building a POC project encompasses key technical challenges and resolution approached for those

Reverse engineered the source systems databases and legacy reporting databases that existed prior to this project.

Created data models for various data stages which also includes cross reference data that links between different subject areas.

ETL ARCHITECTURE:

Designed developed strategies for ETL process which includes the approach to manage network bandwidth issues.

Managing CDC especially in the light of different time zones.

Developed specifications for offshore teams developed the ETL Processes.

TESTING STRATEGY

Partnered with testing team in developing test cases for the project and also designed a process through which the test cases can be automated

The initial release of the project included 8 Manufacturing facilities and the data size came close to 30TB.

REPORTING INFRASTRUCTURE FOR MECC (MEDTRONIC ENERGY AND COMPONENT CENTER)

This was to build a BI infrastructure for MECC for their MFG Operations and my roles and responsibilities of this project also were similar to the above. Success fully completed this effort; and received many accolades for the accomplishments. The success story for this Project has prompted other divisions of Medtronic to adapt to this solution; the corporate has formed a Tiger team to lead this effort. Have taken several key roles in the efforts by the Tiger team in implementing DW solutions for other Medtronic Manufacturing sites.

ENVIRONMENT: ORACLE 11G, MS SQL SERVER,SSIS, INFORMATICA POWER CENTER, SPOTFIRE (TIBCO), BUSINESS OBJECTS, CITRIX, UNIX

ETL Tech Lead Wellsfargo Sep 2005 – May 2006

As an ETL Technical Lead for the Home Mortgage division of Wells Fargo, worked on a 50 TB Data Warehouse. Involved in developing/maintaining subject areas like Credit Risk management, Regulatory reporting etc. Performed ETL development and maintenance for several Data Mart projects. The ETL systems were primarily based on scripting languages, such as Perl, Unix shell scripts, DB2, PL/SQL, along home grown Scheduling tools. Facilitated technical design, documentation and coordination activities with other supporting groups, including data modelers, system analysts, and database administrators. Worked on various stages of the development life cycle, such as Design, Design walkthrough with the Business and other supporting teams, Coding, Testing, and Documentation. Led production implementation and mentored Production Support team on the newly installed ETL steps.

ENVIRONMENT:

Mainframe, IBM-AIX, Data Stage, Business Objects, DB2

ETL Architect/Developer GMAC RFC, Bloomington, MN Aug 2004 - Aug 2005

As an ETL Architect, was instrumental in introducing the concept of a unified ETL architecture to the Data Warehouse team. Created the initial proof of concept, and was asked to implement the ETL architecture in one of the projects. The major breakthrough with this approach was making the ETL process transparent to the Data Consumers and Providers business units without directly engaging Data Warehouse team personnel. This was accomplished through a set of architecture tables and by building Informatica mapping templates to maintain the tables automatically, along with the regular Data Movement operations. The templates became part of all mapping adhering to the architecture. The first two releases of this project have been completed and are in Production. Received many accolades for accomplishments.

ENVIRONMENT:

IBM AIX, Oracle, SQL Server, Informatica 6.2, and Pro-Clarity, SSIS, SSAS

ETL DEVELOPER THRIVENT FINANCIALS, Minneapolis, MN JAN 2004 – JUL 2004

Participated in several key roles in this project; worked very closely with the Architecture team in building a unified approach/architecture for the ETL processes, conceptualized the behavior of different data stages (such as staging, accredited [validated], ODS, and DWH, etc) Worked with the Architecture team and the business in defining and implementing error handling (ETL) mechanisms and reporting mechanisms during the ETL process. Built Informatica Mapping templates to support the architectural needs at different data stages, which helped enormously during the development phase; since all the architecture related requisites were already available in the templates and the developers were concentrating on the real subject areas.

ENVIRONMENT:

IBM Mainframe, DB2, Platinum, AIX, Informatica 6.2, and Power Analyzer

SR. Developer Sprint – PCS, Overland Park, KS Aug 2001 – Dec 2003

NMS CONVERSION PROJECT

Worked as a Senior Informatica Developer with the Data Migration team on an initiative to bring in a centralized Number Management system, across multi-vendor Billing and Customer Support applications. Was responsible for transferring data from the existing legacy systems to the new NMS system from AMDOCS. The significance of this project was a high level of business dependency, minimum down time, and very large data volume (over 300 million records, including current and history data). Set up Informatica development environment for the NMS conversion, designed and developed Informatica Mappings based on the specifications established by the Requirements team, created and maintained standards for the coding and naming conventions, and administered Informatica Server and Repository. Worked extensively on integrating Informatica developments with other tools, such as Syncsort, Oracle PL/SQL processes, and Unix shell process.

RENAISSANCE CONVERSION PROJECT

This was an initiative to eliminate third-party billing contractors and bring the Billing systems to an in-house maintained application from AMDOCS. Worked as a Senior Developer with the Data Migration team to build a custom ETL tool that was used as the conversion Engine. The conversion engine consisted of a set of Extractors, Translators, and Loaders with the inter-process communications through MQ Series messages. Role was to develop the Price Plan module, one of the subject areas in the Translator. The conversion engine was unique in its nature, unlike other conventional migration projects; the data was transferred online, when both the Billing systems were up and running. This helped establish a 0 down time for the Billing systems, as well as the Sprint business/customer support activities.

ENVIRONMENT:

HP-UX, C++, MQ Series, Oracle 9i, MS SQL Server, Sync Sort 3.3, MS SQL Server, ERwin, and Perl.

BI Developer Siemens Medical Systems, Edison, NJ Jan 2001 – Jun 2001

The Integrated Service Management (ISM) data mart was used by the Service division, to support the North American operations. Worked as a Senior Cognos Developer with the Business Intelligence/Reporting team. Designed and developed Cognos Impromptu catalogs as per the specifications established by the Requirements team. Interacted very frequently with the Senior Management team for training and fine-tuning of development efforts. Also had the opportunity to work with other teams in further enrichment of the data mart. Worked with the DBA team in identifying new indexing requirements and further demoralization activities. Provided support to the ETL team with Informatica knowledge to configure Power Connect for SAP systems.

ENVIRONMENT:

Oracle 8.0, Cognos Impromptu 5.0, Cognos Impromptu Web Reports, and Informatica PowerCenter 1.7

Contact this candidate