Candidates About

 

James Smith

Professional Summary

I am a Senior Data Warehousing/Business Intelligence professional with experience in all phases of Data Warehouse planning, development, testing and implementation.  My experience is extensive all all domains of Data, Big Data, Cloud, BI (Business Intelligence) and data integration.  I also have technical experience is all supporting venues including architecting, leading and development.

 

My industry experience is diverse and extensive.  It spans multiple verticals from US Govt to Insurance, Pharmaceuticals, Defense Contracting, Banking/Finance.

 

Active Secret Security clearance.

 

Technologies

 

Relational Database: Oracle 10g/11i, MS SQL Server 2008/2005, IBM/DB2, Teradata, Neteeza.

Cloud Services – Amazon Web Services (AWS), EMR, Redshift

Big Data – Hadoop/MapReduce, Cloudera, Pig, HDFS, Vertica, HIVE, Spark

Master Data Mangement (MDM) – Informatica MDM, EBX5 (Orchestra Networks)

ETL: Informatica/Informatica Cloud, IDQ/IDE, IBM DataStage/Infosphere, SAP Data Services BODS, SSIS, Talend, Talend MDM, Pentaho,

Software Languages:  PL/SQL, T-SQL, Java, C++, HiveQL, SparkQL

Data modeling:  ER_Studio, Embarcadero, TOAD, SQL Developer

Data Analysis and Quality: IDIQ/IDE, TOAD, Oracle Enterprise Mgr, SQL Server Mgmt Studio

Business Intelligence:  Business Objects XI, COGNOS

Services:  EBS, SOA, NIFI

Misc:  Peoplesoft, SAP, Unix, Windows, IBM/DB2 Admin console, XML, JSON

 

 

Professional Experience

 

A2C/TRAC Intermodal                                                                                  Sept 2016 to Present

MDM Architect/Developer/ ETL-Big Data Architect/Developer

·         Design and build Informatica MDM Hub solutions with full Reference and Master data sourcing, cleansing, standardization, matching, survivorship and hierarchy development.

·         Built scorecard and MDM matching using Informatica Powercenter, MDM and IDQ.

·         Design and build parallel MDM solutions in EBX5 with sourcing, cleansing, standardization, matching, survivorship and hierarchy rules and development.

·         Build support service layer using EBS, SOA and NIFI to interact with EBX5 MDM engine.

·         Built workflows for data governance and process management objectives along with automation of data loading/updating and validation of EBX5 container objects (Dataspaces, Datasets, Snapshots, etc.).

·         Provided Informatica Powercenter, MDM and EBX5 administration services.  Responsible for all aspects of Powercenter, MDM, IDQ, Web services and EBX5 environment management.

·         Sucessfully installed all components of EBX and stood up DEV/QA/UAT/PROD EBX5 environments.

·         Created and configured Dataspaces, Datasets, and all supporting administrative components including access control, component configuration and integration with Java tools like Eclipse.

·         Imported data models via xml/xsd from Erwin, Embarcadero and other modeling tools.

·         Modified, validated and published data models for dataset creation.

·         Built automatic deployment routines with incremental and full/mass deployment scenarios

·         Built DEV, QA,UAT and Production environments for both Informatica and EBX5.

·         Designed and built complex ETL solutions in Powercenter and data services within EBX5.

·         Developled complex Talend Big Data solutions within Hadoop/Yarn environments using both MapReduce and SPARK design/development.

·         Created Hadoop and HIVE data structures including external table configurations.

·         Debugged vairous Talend issues with Keytab authenication and Parquet incompatability.

 

 

WorldgateLLC/School District of Phila.                                                           March 2014 to Sept 2016

Data/ETL Architect – Informatica/Oracle/Talend/Pentaho/AWS

Informatica Administrator

●      Design, develop, test and implement new business oriented data warehouse including specific data marts for student enrollment, performance, attendance, discipline, and standardized test scores.

●      Build MDM solutions including Merge/Purge, Survivorship, Heirarchy processing using Informatica MDM and IDQ toolsets.

●      Designed and build ODS Reference Data framework for Mastering Data and conformed BI reporting.

●      Designed and managed MDM data standards including translating standards into reusable tools across multiple MDM domains (Party,Location,Testing,Performance metrics,etc.) using Informatica MDM, ILM and IDQ.

●      Designed and implemented multi-domain MDM modeling to assist with integrated data mart construction and ETL.

●      Developed Informatica mappings, workflows and resuable components for Data Warehouse and BI summary ETL load processes.

●      Managed complete Powercenter/PowerExchange environments along with responsiblitiy in user access mgmt., Code deployment, repository management and mapping/workflow optimization.

●      Completed multiple environment uipgrades from versions 8.6 to 9.x.

●      Developed Talend ETL mappings/jobs for standardized district and school performance reports.  These objects replaced hand written SQL scripts.  Includes implementing Talend MDM in an AWS implementation integrating EMR (Elastic Map Reduce) and Redshift.

●      Designed and built ETL solutions in Informatica and Talend including complex looping Workflow development in Informatica. 

●      Build Pentaho and Talend mappings using open source version for legacy data integration systems using Kettle, Spoon, and Talend Data Integration ETL tooset.

●      Built Conformed and non-Conformed dimensions, Atomic and aggregate fact ETL solutions using Kettle, Spoon (Pentaho) and Informatica, Talend and PL/SQL routines.  Relational targets in Oracle and Teradata.

●      Provided architectural guidance and startegies for Teradata appliance use for large dataset aggregation  and summarization for enhanced portal data delivery.

●      Integrated Hadoop/HDFS as targets for Big Data downstream projects. Including creating Map Reduce for large historical analytical ETL.

●      Design and built Vertica database across multi-node VM and physical environments. 

●      Build Vertica projections across nodes for BI summarization and query optimization.

●      Created HDFS Big Data solutions using Hive, Horton Works, Map Reduce

●      Wrote Linux scripting for automation and scheduler job control.

●      Assisted with the design and implementation of Microstrategy environment for self-service reporting and analysis.

●      Assisted with single sign-on implementation with data warehouse and Microstrategy tools to further self-service BI strategies.

 

 

 

 

BCI/ARI                                                                                         August 2013 to February 2014

ETL Architect/Developer – SAP (BODS) Data Services//IBM DataStage-Infosphere

●      Created DataStage Jobs for persistent and Enterprise Data Warehouse target loads

●      Created DataStage Parallel job executions for EDW enhancement projects.

●      Performed migration of content between local and central repositories in Dev, QA and Prod environments.

●      Created complex data flows, workflows and Jobs for the creation of interfaces between different OLTP sources using SAP Data Services (BODS)

●      Created design requirements and standards for Data Services developers.

●      Configured BODS Job Server and Job configurations in support with Oracle and SQL Server database environments.

●      Created BODS Datastores in support of ETL development.

 

RCG/Unum Insurance                                                                   August 2012 to August 2013

Data Architect/ETL Architect – Informatica/Oracle/Erwin/Talend/Pentaho

●      Created Conceptual, Logical and Physical data models for data warehouse BI reporting projects from business requirements documentation.

●      Created Metadata repositories for Logical to Physical relational reporting.

●      Created Source to Target mapping documents outlining logic required for ETL coding efforts.

●      Coordinated and managed repositories for data models using ModelMart.

●      Perform extensive data profiling using Informatica profiling toolset and SQL/PLSQL.

●      Perform performance review on data model design to ensure the best performance windows (Partitioning, Localized and bit-mapped indexing, Clustering, etc.)

●      Created ETL design documents to support and standardize ETL development activity.

●      Created complex design solutions for managing job control and standardized error handling.

●      Created complex ETL mappings using Informatica along with reusable objects for collaborative development.

●      Created Workflows and reusable Sessions to automate mapping executions.

●      Design and developed SQL/PLSQL ETL coding solutions.

●      Created Talend/inline Java routines to load and standardize incoming data for downstream processing.  Includes POC work with Talend MDM tool.

●      Created Pentaho ETL routines using Spoon and Kettle for aggregate and OLAP based data marts.

●      Created Scripts for interfacing with job control tools like CTRL-M and Autosys.

 

SSCI/US DEPT OF STATE.                                                                    March 2010 to August 2012

Data Warehouse Architect/ETL Architect – SAP Data Services, Informatica/PL/SQL/Talend

●      Responsible for the design and development of Consular Affairs decision support data warehouse which included Logical/Physical model design, ETL transformation logic/documentation, ETL development using SAP BO XI Data Services, Informatica and PL/SQL, Business Intelligence Universe and reporting support using Business Objects XI, and post implementation documentation.

●      Responsible for SAP BO XI Data Services installation, configuration (including grid configurations), and overall administration.

●      Designed and developed complex ETL mappings and Workflows using Informatica and SAP BO XI Data Services.  Challenging ETL issues included unstructured sources, high volume optimization, and complex analytics.

●      Support BI initiatives with Query optimization and performance enhancements utilizing a myriad of Oracle enhancements tools (partitioning, indexing,etc).

●      Designed and developed a comprehensive, full lineage metadata reporting environment integrating several tools (Data Modeling, ETL, BI, and Metadata management applications).

●      Managed a team of three ETL developers supporting BI projects.

●      Designed and developed Talend ETL jobs using open source tool for ODS population

●      Created Talend auditing routines for metadata management project.

●      Designed and developed complex Business Intelligence solutions involving data modeling, ETL, programming and metadata management of Data Stores, Data Marts, Master Data management, and project specific aggregation deliverables.

 

Standard & Poors, Inc.                                                             April 2009 to March 2010

Senior Consultant/ETL Architect/Informatica Architect - Informatica                                             

●      Performed Installation, configuration, upgrades, troubleshooting of existing Informatica environments including multi-integration nodal (grid) configuration.

●      Perform repository upgrades from 32-bit to 64 bit Informatica upgrade.

●      Architected user development, test, integration and production Informatica environments.

●      Designed and created complex automated ETL structures (mappings, workflows, sessions, mapplets, worklets, etc.) using Informatica 8.6 to populate ODS and data marts from multiple and varied data sources including XML/XSD, Relational, Flat File, VSAM, and Unstructured formats.

●      Created overall ETL plan including identification of data structures, ETL algorithms, metadata reporting, data cleansing and validation and BI support.

●      Created automated ETL conversion and integration systems using Informatica and XML/XSD sources and tools.

●      Created and managed reference lists located in SharePoint and Oracle.

●      Created MDM enterprise structures using ERWin and Informatica Metadata Manager.  Managed updates using Informatica PowerCenter.

●      Created re-usable Informatica objects for common code utilization and enforcement of coding standards.

●      Perform ETL and Oracle database performance tuning including re-engineering to meet SLA requirements.

●      Created Oracle packages, stored procedures and in-line PL/SQL in support of ETL requirements.

 

Thomson-Reuters,Inc.                                                              Jan 2009 to April 2009

Senior Consultant/ Informatica Architect/Oracle DBA – Informatica/ Erwin                          

●      Designed, Created and Managed Informatica Environments using Admin Console and Repository Manager toolsets.

●      Created complex workflows, mappings and other Informatica objects to load EDI data from FTP, XML/XSD, and relational sources into Decision Support Star Schemas data marts. 

●      Performed extensive performance tuning on Informatica mappings, sessions and workflows

●      Created Unix scripting using PMCMD for Informatica execution automation and scheduling.

●      Created Oracle Packages and stored procedures for the creation of a database monitoring and reporting tool as well as in support of ETL activities.

●      Used Informatica Metadata Manager for management of mapping and external metadata.

●      Perform Oracle DBA tasks in Oracle 10g environment including database creation, tuning/optimization, backups (RMAN, Import/Export) and RAC/Grid management.

●      Created logical and physical data models using ERWin including the use of naming standards (.nsm) files and Global Domain Dictionaries.

 

Radian Mortgage Surety, Inc.                                                        May 2008 to Jan 2009

 Lead DW Engineer/Informatica Administrator - Informatica

●      Provided sole Administrator services for Informatica 8.1.1 and 8.6 environments including managing users, Object migrations, and Repository backups and installation.

●      Imported and converted 32-bit repositories to 64-bit repositories.

●      Created complex mappings using Informatica and PL/SQL to build ODS and Star Schema Data Marts including type I and II dimensions, Hierarchical Star Fact tables, Conformed dimensions and Enterprise ODS.

●      Tuned and optimized Oracle Databases for Query, Reporting and OLAP optimization.

●      Created Unix scripts for Informatica workflow, PL/SQL scripting, and Unix command executions.

●      Created ERWin logical and physical data models in support of ODS and Decision Support data structures.

●      Created mapping logic documents for ETL, Data Profiling, and Cube population efforts.

 

Lochheed Martin                                                                      November 2005 to May 2008

DW/BI Consultant/Lead ETL Developer – Executive Dashboard Project – Informatica/Peoplesoft

●      Created complex mappings and workflows using Informatica to load Oracle decision-support/BI Instances with data from In-House reporting star schemas, ODS, PeopleSoft, and Web Services sources (using PowerConnect) for Executive Dashboard Snapshot reporting.

●      Modeled and Engineered the creation of dimensional star schemas as data marts from ODS for new subject area reporting and analysis including Type I and II dimensions.

●      Created Materialized Views as summary objects from Fact tables to support COGNOS Framework Manager and Business Objects Universe functionality.

●      Managed ETL Developers in the creation, development and testing of mappings and workflows for Executive Dashboard data loading, reporting and auditing.

●      Created Oracle Packages, Functions and Stored Procedures to augment supplemental aggregations required for changing reporting requirements in support of .NET user interface development.

●      Wrote Peoplecode SQR’s in support of integration of data between the Executive Dashboard and PeopleSoft instances.

 

DW Consultant/Senior ETL Developer  - SWIFT Project – Informatica/PeopleSoft                                

·         Designed and built complex mappings and workflows using Informatica to migrate data from legacy and manual acquisition systems into various Peoplesoft Module data structures.

·         Used Peoplesoft component interface to load data into the component modules.

·         Designed and wrote PL/SQL scripts to support post Go-Live data enhancement initiatives and data validation.

·         Used Application Designer to access Component objects in PeopleSoft for code debugging, lookup values, and Component object to underlying data structure mappings.

·         Created Power Exchange objects for converting and loading VSAM data sources within Informatica mappings.

·         Used terminal emulation (PUTTY) to access UNIX servers/directories as well FTP services.

 

 

King Pharmaceutical                                                                Oct 2004 to November 2005

DW Consultant/Senior Developer – Informatica/Sql Server/Oracle

●      Created complex mappings and workflows using Informatica involving multiple RDBMS, Flat File, SalesForce.com sources and targets for Sales and Marketing inititiaves.

●      Created mapping documents including metadata extensions specifications to guide DW and Data mart ETL development.

●      Created reusable complex Maplets, Lookups and Worklets to support ETL team intitatives.

●      Performed performance tuning on Mappings and Workflows to decrease runtimes and increase efficiencies.

●      Senior BI (Business Intelligence) developer developing reports and microcubes supporting Sales, Sales Operations and Marketing programs using Business Objects, Microsoft Access, PL/SQL, T-SQL, and Excel VBA.

●      Created Universes and models reflecting data mart structures for production and adhoc reporting using SQL Server and Oracle sources including Views, Materialized Views, etc.

●      Data warehouse, Master Data, Metadata and Data mart database design using Erwin.

●      Created reports using Designer, Reporter Manager and Web Intelligence.

●      Assisted Oracle DBA in Oracle database development, configuration, optimization and maintenance.

●     Provided complete ETL documentation of mappings, workflows, parameters and business processes as they relate to ETL delivery.

 

Roche Labs, Inc                                                                                                          

Consutant - Oracle DBA/Database Manager – Informatica/Oracle                      Jan 2003 to Oct 2004

Designed, engineered and managed a very large (2TB), multi-instance Claims-based data warehouse including the following tasks:

●      Performed all necessary creation, management, maintenance, performance tuning and troubleshooting tasks for Oracle environments and databases/instances. 

●      Modeled and forward engineered underlying data marts and decision support data objects (star schemas) using Erwin, Oracle Designer, Visio and TOAD. 

●      Performed ETL services to automate and migrate source data into Data Warehouse using Informatica (v7.0), TOAD, and customized script development using SQL Loader, UNIX and SAS. 

●      Created customized Mappings, and Workflows to migrate source (vendor) data to Claims Data Warehouse.

●      Created customized Mappings, Mapplets and Workflows to create analytical datasets to support ongoing projects and claims database ETL using Informatica and PL/SQL.

●      Created customized Mappings, Mapplets and Workflows to extract clinical data from Oracle Clinical repositories to SAS analytical environment.

●      Designing a Medical Affairs Metadata repository using Informatica (including metadata extensions), Erwin (customized UDP) and SQL Loader log data for data dictionary web access and publication.

●      Assisted with the installation and configuration of PowerCenter repository, and Server components.

●      Performed Level 1 and Level 2 data validation to ensure accuracy, data integrity and compliance with local data standards.

●      Performed PL/SQL code development to support Data Warehouse applications, reporting and analysis requirements.

●      Created OLAP objects using Cognos, Brio, and Oracle Discoverer for decision-support projects.

●      Assisted in the creation of Brio and SAS environments to connect to Oracle Data Warehouse and local SAS computing environments.

●      Used and support Oracle Clinical for analysis and migration of clinical trial data.

●      Managed multi-source terminology web-based applications and database environments which included UMLS, CPT4 HCPCS, ICD9/10, NDC and CDC source and drug interaction data.

●      Co-managed Documentum environment for FDA submission documents and data.

 

Pfizer/Pharmacia

Consultant - Oracle DBA/Database Manager – Oracle/PL-SQL                Mar 2001 to Jan 2003

Designed, engineered and managed very large (1.75 TB) claims data mart/data warehouse.  Performed the following tasks:

●      Created and managed clinical trials data mart for effective clinical trials metrics analysis utilizing Oracle Designer, Oracle Discoverer

●      Incorporated OLAP tools for effective data warehouse presentation to Medical Directors as well as adhoc reporting using Oracle Reports.

●      Performed all necessary creation, management, maintenance, performance tuning and troubleshooting tasks for Oracle environments and databases/instances

●      Interfaced with data vendors on data procurement, quality, and technical issues

●      Programmed in PL/SQL//Dynamic PL/SQL creating Packages, Stored Procedures, Triggers, Objects, to support Applications, OLAP tools, ETL, and Data Management.

●      Programmed in Pro C, C++ for file extraction in support of ongoing studies as well as SAS for ETL and data validation.

●      Created OLAP cubes using Cognos Visualizer and PowerPlay to aid in EDA trial phases

●      Performed Unix Kshell scripting for task automation and Oracle maintenance

●      Installed and configured Oracle software within HP Unix environments

●      Installed and configured SAS software within HP Unix environments

●      Provided Support for Oracle to SAS interfacing and user SQL-based projects

●      Data modeling incorporated Star Schema design for effective Business Intelligence related access, analysis and presentation

●      Designed and created web-based Data Dictionary system to aid users in data warehouse access, query optimization and reporting.

 

Special:  Secret Security Clearance - Active

 

Education

●      Bachelor of Science                                                      1979 - 1983

–                  Business Administration and Computer Science

<span