Data Engineering Lead - Cloud & AI Solutions Expert
Resume:
Zia Zahid
Ph: 918-***-****
Email: ******@***.***
Professional Summary.
Over 20 years’ experience in all facets of project life cycle, from initial feasibility analysis and conceptual design through documentation, implementation, user training and enhancements. Experienced in Cloud, AI, Machine Learning, Web Applications, Distributed Business Applications, Client/Server, mid-range and mainframe environment. Strong communication skills combined with a positive attitude to be a key team player. Demonstrated leadership abilities to resolve issues, drive projects and meet critical deadlines. Highly adaptable individual, motivated to develop successful solutions. I have worked with fortune 500 as well as small entrepreneurial businesses.
Functional expertise areas:
·Big Data/Data Lakes/Data Warehouse/ETL /ELT
·ML, AI, Business Intelligence
·DB Design & Dev (RDBMS, NoSQL, Cloud)
·Data Modeling (ER, Dimensional, SF)
·ERP Applications Peoplesoft, SAP, Maximo
·Water fall, Agile, Scrum, Kanban
Professional Strengths.
·Expert in Data warehouse (SQL Server, Oracle), ETL (SSIS, Informatica, PL/SQL, T-SQL),
ELT (Big data analytics) BI (SSAS, OBIEE, COGNOS, SSRS, SAP Business Objects, Spotfire, Tableau) and data modeling (ERWIN, ER/Studio, Visio)
·Experience in developing and deploying enterprise based applications using major components in Hadoop
ecosystem like HDFS, MapReduce, YARN, Hive, Pig, HBase, Flume, Sqoop, Spark, Storm, Scala Kafka,
Oozie, Zookeeper, MongoDB, Cassandra, and Solr.
·Worked with developers to create the migration/integration of legacy systems to AWS cloud.
·Expert in on-premises Data migration to Clouds of AWS and Microsoft Azure using Rehost (lift and shift) method.
·Delivered a proof of concept (POC) on SQL Server 2019 Big Data Cluster (Azure).
·Led a team of highly skilled software engineers in IT software development, product selection, microservice
infrastructure design to establish practices consistent with business strategies and priorities.
·Expert in design, develop, deploy and schedule reports using reporting tools Tableau 10.5, SAP BO 4.2,
COGNOS, Crystal Report, SSRS and Spotfire 6.
·Expert using ETL Tools like Informatica Power Center, Power Exchange, IDQ 10.1/9.6/9.1/8.6, ODI 10, 11, 12c
and SSIS 2016/2014/2012/2008/2005
·Hands on experience with New version of ODI 12c.
·Hands on experience with popular SQL monitoring tools, Idera 9.0, Dell Spotlight 12.2,
Informatica Admin Console 10.1.
·Expert designing, developing OLAP cubes using SSAS.
·Expert in Data Integration from IBM Informix, DB2 to Azure SQL Server.
·Expert in Data Migration for non-SAP / SAP into S4 HANA database.
·Managed the implementation of Peoplesoft’s CRM 8.9 Support and ETL tasks for data warehouse integrations.
·Implement high availability with AlwaysOn Availability Groups and failover clustering
·Expert in design, develop and implement ETL packages using DTS and SSIS.
·Experienced in historical data maintenance (system-versioned (temporal tables)) using SQL Server 2019.
·Strong background in writing stored procedures, views, triggers, functions in Oracle PL/SQL and SQL Server.
·Expert implementing Data Compression (Page/Row) / Table Partitioning using SQL Server 2014.
·Expertise in Informatica to develop, test and tune mappings, sessions and workflows, analyzing and
validating data, Logical and Physical data modeling that includes ER and dimensional modeling using ERWIN.
·Proven experience and Solid understanding of Data Warehousing, Decision Support Systems (DSS), OLAP
and Business Intelligence skills.
·Experienced in Physical, Logical database implementation, indexing and performance tuning for development,
test and production environments.
·Used all programming methodologies like batch, structured, Object Oriented and RDBMS.
·Expertise in all phases of ETL Testing using Informatica and SSIS.
·Experienced using Helpdesk software, Unicenter ServicePlus Service Desk MS System Center 2012 Service
Manager.
·Expert knowledge of Perl script, VB script, JavaScript, Powershell Script, JSON.
·Experienced in keeping track of IT projects using MS Project Professional.
·Converted applications from mainframe to mainframe, mainframe to Mid-range, Mid-range to p.c.
·Well Aware of project management methodologies, Waterfall, Agile, Scrum.
·Experienced performing Sarbanes-Oxley tests for IT, and making business applications SOX complaint.
Technical Expertise:
Operating systems: Windows Server 2012 R 2 Windows 10, 8.1, 7/XP/ 2003/2000/NT 4.0/ 98, UNIX 5.1, X-Windows, Open VMS, MVS, OS/400, MTS and IIS 5.0, 6.0, 7, Proxy MVS PC version.
Application Servers: Windows 2000 Server (NT), Windows 2003, 2008 R2, 2012 Server, VS Team Foundation Server 2012. Team Services 2016 For Agile Development, MS IIS, MS SharePoint Portal Server 2003, 2007, 2010.
Languages/Scripts/Packages: Visual Studio 2005, 2008, 2010, 2013, 2015, ArcGIS 10, .NET Framework 3.5, 4, MVC 3, ASP.NET, VB.NET, C# 2, 3, Visual BASIC 6, VB.NET, ASP.NET, VB-Scripts, Java scripts, JSON, Perl scripts, HTML, XML, MS Visual InterDev 6, MS Visual C++, Pragmatic Works DocxPress, Microsoft Project Professional, Microsoft Office 2010, ACU COBOL, ACU 4 GL VAX/COBOL, FMS, DCL, COBOL II, CICS, DB2, Micro Focus COBOL
Helpdesk/QA tools: ServiceNow Service management, Unicenter ServicePlus Service Desk MS System Center 2012 Service Manager, HP Quality Center.
DBMS/RDBMS: Azure SQL Server, SQL server 2000 Thru 2019 T-SQL, ORACLE 8 thru 11g SQLplus, PL/SQL, IBM Informix, DB2, Teradata SQL Assistant 14, Spatial Databases with ArcGIS10, MS Access, Greenplum Postgre SQL, MySQL 5.7.12.
Server Side Scripting: Perl script, JavaScript, JSON, VBScript, C#, VB.NET.
ERP: PeopleSoft Enterprise CRM 8.9, PeopleSoft 8.8 HRMS, PeopleTools 8.45.11, Application Designer 8.45.11, eRecruitment, T & L, Security. SAP ECC 6.0, BI, BW. SAP Hana SPS07, Maximo 7.5, SAP S/4 HANA.
Data Modeling BI / ETL Tools: Azure Data Factory pipelines, Databricks, Snowflake, Power BI for Office 365 (Power Query, Power View/Power Map, Power Pivot) OBIEE 10,11G, ODI 10, 11, 12c, ER/Studio, Erwin 9.6, Informatica Power Center 8.6.1, 9.1.0, 9.5.1IDQ, PowerExchange, IBM InfoSphere QualityStage, DataStage, SQL Server BI Development Studio, DataTools 2005/2008/2012, SSIS, SSRS, SSAS, PerformancePoint, PowerPivot, Power BI, Spotfire 6, DashBoard Designer 2010, PS Query, SQR, Crystal Reports, COGNOS 7.3, 8, 10, SAP Business Objects XI, Tableau 10.5. RedGate SQL Compare 8.2, Mobius (Archive Creator 4.1)
Professional Experience:
Stride Bank, N.A.
(Direct Client)
Tulsa, OK.
ETL Architect / Senior Data Engineer Jun 25 – To Date
Accelerated data pipeline operations 25–30% by architecting an MCP server that connected AI agents (OpenAI GPT-4) directly to banking data sources, enabling automated workflows and real-time tool access across fintech ETL systems.
Designed and prepared a test plan for Non Qualified Mortgage (NQM) 20 pipelines (using python code with Azure DevOps ci/cd) that integrates source excel files to sql server 2019 tables for power bi dashboards and reports.
Analysis, designed and development of ETL pipelines for Jack-Henry Core banking data on AS400 to SQL Server
Designed and developed ETL processes for Galileo, FinPlat, Affirm, Stash using sql server 2019/22 SSIS packages.
Designed and developed ETL of fintech processes to Abrigo Banking Data warehouse system using sql server 2019/22 SSIS packages.
Designing a POC for SQL Server data migration to Azure SQL Server database for front-end needs.
Identified and prepare end to end Data flow diagram for Stride bank.
Designed, developed and enhanced the APS summary dashboard for fintech processors statuses updates using PowerBI service and SSRS.
Designed and developed Azure Devops CICD pipelines for Stride bank processors ETL developments.
Pioneered data mesh pilot by defining finance domains (e.g., SAP S/4HANA modules), migrating SSIS ETL pipelines to dbt models in Data bricks Unity Catalog, enabling 40% faster self-service data products for 5 cross-functional teams.
Established federated governance via domain-owned DDL schemas with metadata standards (business rules, lineage tags), reducing central bottlenecks by 30% and enforcing interoperability across Azure Synapse and Delta Lake assets.
Authored domain-specific DDL scripts (CREATE TABLE AS SELECT, ALTER VIEW) integrated with Delta Live Tables, embedding quality metadata and RBAC for decentralized ownership, cutting schema evolution time from weeks to days in regulated banking environments.
Architected scalable Informatica workflows to synchronize SAP HCM and SuccessFactors data via REST APIs and controlled flat file ingestion, ensuring compliance with Stride Bank’s data governance, audit, and security standards.
INL Idaho National Lab (Remote)
(United Global Technologies)
EDW Architect. Jun 2023 – Jun 2025
Analysis, designed and development HR Recruiting Datamart using Oracle Business Intelligence – Taleo Connect Client.
Designed and developed ETL process for Asset Suit System on Oracle 19c ee using SQL Server SSIS packages.
Designing a POC for SQL Server data migration to Azure SQL Server database for front-end needs.
Designed and implemented Integration of GIT repositories with Azure DevOps pipelines. Implemented version control, branching strategies and code reviews. Automated deployments to various environments e.g. (Stage,QA and Prod, blue-green deployments).
Analysis, designed and developed ETL processes (SSIS packages / ADF pipelines ) for Medallion Architecture to ingest data into Bronze / Silver / Gold layers.
Designed and developed an architecture of Semantic Layer for HR Intellectual Property Data warehouse using ErwinData Modeler / Data Intelligence suite for data modeling, SSIS 2019 for ETL on SQL Server 2019 database.
Designed and developed ETL processes / packages for HR Intellectual Property Data warehouse using SQL Server 2019 SSIS 2019.
Analyzed, designed and developed Work Management System’s data mart for dashboards, score cards and reporting.
Analyzed, designed and developed HR Talent Management’s data mart for dashboards, score cards and reporting.
Built end to end Databricks ETL pipelines (bronze–silver–gold) to improve data quality, observability, and time to insight for key INL business stakeholders.
Partnered with cross functional domain teams to define data contracts, ownership, and SLAs in support of an enterprise data mesh strategy.
John Hopkins Healthcare
(Integrated BI Solution Inc)
Data Modeler / EDW Architect. July 2022 – Jun 2023
Designed, Analyzed and Developed model for HEDIS Measures Value Sets for Exclusions
Prepared a dimensional model for PCR Data for HEDIS data ware house
Support and enhance the Analytics architecture of HEDIS (Healthcare Effectiveness Data and Information Set) for John Hopkins Healthcare users utilizing ER Studio as Data Modeling Tool, VISIO, SQL Server 2016 and Power BI.
Designed and developed an architecture of Semantic Layer for John Hopkins Medicines users of Members, Claims and Providers using ER Studio for data modeling, Azure Synapse Analytics with Power BI
Prepared Conceptual / Logical / Physical Data Model for semantic layer with Informatica EDC for data dictionary and Axon for data governance.
Organized and facilitated sprint planning, daily stand-ups, sprint reviews, sprint retrospectives and release planning for 3 teams.
Architected, designed and trained in development of Informatica ELT workflows, Data Quality rule development in
IDQ, Data Governance business flows in Axon, and metadata capture through informatica’s Data catalog (EDC)
Developed the MDM data structures to provide the information and solution within Informatica MDM for Healthcare Provider and Member’s Data.
Designed and implemented Azure Data Lake migration from Gen1 to Gen2.
Built and optimized ELT pipelines into Snowflake from heterogeneous sources (EHR, claims, provider systems),
leveraging streams, tasks, and Snowpipe for incremental and near–real-time ingestion.
Implemented robust security and governance in Snowflake, including RBAC roles, masking policies, and row level
access controls for PHI and sensitive financial data.
Tuned Snowflake warehouses and query patterns (clustering keys, micro partition pruning, result caching) to reduce
compute cost and improve complex analytic query performance.
Databricks ETL pipelines (Spark Clusters) for a semantic layer that will provide data feed for the providers analytics
Led the design and implementation of data mesh–aligned domain data products, enabling teams to own and serve high quality data for analytics and operational use.
NBCUniversal Sports NEXT.
(Direct Client)
Data Services Manager. Jan 2022 – July 2022
Designed and developed Cloud Loyalty System Architecture for NBCUniversal SportsNext to facilitate EZLinks andGolfNow’s Golf courses and golfers for their bookings, tee times and weather data using Azure and AWS cloud infrastructures
Manage a team of 7 data engineers in Data Engineering and Analytics department.
Designed and developed an architecture of Course Price Optimization project to support all golf courses comes under NBCUniversal Sports NEXT
Manage and support Golf Now One Data Layer reports project, which provide support to all Golf Course owners and Golfers.
Designed and developed conceptual/logical/physical data models for customer/golfers data segmentation and data mining projects.
Utilized Jira and Confluence tools to prepare, monitor and share 3 teams metrics and delivery results.
Organized and facilitated sprint planning, daily stand-ups, sprint reviews, sprint retrospectives and release planning for 3 teams.
Utilized Snowflake Time Travel, zero copy cloning, and transient tables to enable safe sandboxing, impact analysis, and rapid environment provisioning for analytics teams.
Collaborated with BI and data science teams to expose certified Snowflake views and semantic models, improving self service analytics adoption for clinical, quality, and finance stakeholders.
Designed and maintained scalable Databricks data pipelines to ingest, transform, and publish NBC content and audience data for analytics and reporting.
CommunityCare a Healthcare Company Tulsa, OK.
(Contract to Hire = Archon Resources LLC)
EDW Architect. Nov 2019 – Dec 2021
·Designed, developed and implemented Healthcare Claims model on Azure SQL Server
·Designed, developed and implemented Azure Data Factory pipelines to pull data from Oracle and IBM Informix to Azure SQL Server
·Designed, developed and implemented Claims, Members and Accounting dashboards using Power BI with Azure
SQL Server Database as a source.
·Build engineering and release management process, building and deploying applications by adopting DevOps
practices such as CD/CI in runtime with various tools like Git and managing cloud services with Azure.
·Migrated Amisys Claim system from Oracle - SQL Server 2019 on-prem to Oracle - Azure Database using
Azure Data Factory as ETL tool.
Designed and developed EDW data model for Healthcare Claim on SQL Server 2019 and ETL using SSIS
packages to integrate disparate source systems to SQL Server 2019.
·POC of a OEMcc 12c Data Masking project for a health care company
·Migrated legacy centralized pipelines into domain oriented Databricks data products, improving discoverability,
governance, and reuse under a data mesh architecture.
·Architected and implemented Snowflake-based data warehouse solutions, designing raw/curated/consumption layers
and dimensional models for claims, members, and providers to support advanced healthcare analytics.
·Optimized Databricks Spark pipelines for performance and cost, including job orchestration, monitoring, and
automated recovery for critical workflows.
·Scoped, analyzed and developed an ETL project using Attunity for a local Health care company.
·Collaborated with platform and governance teams to align data mesh principles (domain ownership, self serve
platform, federated governance) with organizational standards and compliance.
·Designed, developed and Implemented new data warehouse (Dimensional Model) solution
(Encounters, Claims, PHA, Prescriptions, Labs, Outcomes) using Oracle 12c.
Navy Federal Credit Union, Vienna, VA.
(Zillion Technologies Inc)
Data Warehouse Architect. Nov 2018 – Nov 2019
·Designed, Developed and Implemented Project Portfolio Management (PPM) ETL Upgrade project, upgraded,
converted, deployed over 150 SSIS packages from SSIS 2010 to SSIS 2017 using Visual Studio 2017.
·Managed Parallel Upgrade from SQL Server 2010 to SQL Server 2017.
·Support PPM ETL processes, Implementation / Deployment, using Oracle 12c as one of Source and SQL Server
2017 as Target.
·Support PPM Data mart to maintain and enhance star / snow flake scheme structure.
RML an Ascension Health System, Tulsa, OK.
(Direct Client)
Solution Architect. Nov 2016 – Nov 2018
·Designed, developed and Implemented new data warehouse (Dimensional Model) solution for the Hospitals/Clinical
Operations (Encounters, Orders, Results, Claims, PHA, Prescriptions, Labs, Outcomes) using Informatica 10.1,
SQL Server 2014 technologies. Build and implement visualization based on the new DWH using SAP Business
Objects Enterprise 4.2, Tableau 10.5 and COGNOS.
·Manage Administration and security to SAP Business Objects, Tableau users like single sign-on environment.
·Installed and configured multiple tableau environments (Dev, QA, Prod)
·Managed conversion of SAP Business Objects 4.2 to Tableau 10.5
·Managed to load patients / providers data into SAP HANA for real time analytics.
·Collaborate Tableau analytics team to provide enterprise wide solutions.
·Monitor over 300/1800 workflow/worklets/sessions for nightly ETL processes/OPS using Informatica 10.1 PC
Workflow Monitor/Spotlight on SQL Server Enterprise 11 from Dell Software.
·Managed Informatica Upgrade from 9.0.1 à 9.1.0 à 9.6 à 10.1.1.
·Managed InPlace Upgrade from SQL Server 2005/Server 2008R2 to SQL Server 2014.
·Managed Parallel Upgrade from SQL Server 2005/Server 2008R2 to SQL Server 2014.
·Implemented Compression / Partitioning on 10 TB database using SQL Server 2014.
·Designed, Developed and Implemented OutReach Operation’s Data (150 Tables) consumed Web Service to bring
data into RML Data Warehouse using SSIS 2016 as ETL Tool.
·Managed a SAN migration (VMAX to Hitachi) project.
·Designed and develop a POC for SQL Server on premise Healthcare data migration to Microsoft Azure for Azure
Data Lake migrations using SSIS and Azure Data Factory.
·Designed, developed and Implemented ETL models for all healthcare subject areas using Informatcia 10.1 as ETL
Tool.
·Lead projects at various stages from user stories/ requirements gathering and business rules analysis to creating
conceptual, logical and physical model using Ervin Data Modeler 9.5.
·Responsible for project planning, technology, risk, scope management, resource estimation, metrics definition,
change control process, define data quality process and standards, verification and validation.
·Compliance with non-functional requirements, security, performance, maintainability, scalability, usability and
reliability of a product
·Co-ordinate with business owners, DBAs, reporting team to address system improvements.
·Mentored individuals from business and technical stand point.
·Responsible for Data Modelling, Architecture, Production support and Integration / migration of the solution
CareATC, Tulsa, OK.
(Contract to hire=Archon Resources LLC)
Data Warehouse Architect. Dec 2015 – Nov 2016
·Designed, developed and Implemented new data warehouse (Dimensional Model) solution for the Clinical
Operations (eCW Encounters, Claims, PHA, Prescriptions, Labs, Outcomes) using SQL Server 2014 technologies.
Build and implement visualization based on the new DWH using Tableau 9.2 and COGNOS.
·Manage Administration and security to Tableau users like single sign-on environment.
·Managed conversion of COGNOS 10 to Tableau 10.5
·Implemented standardized metadata, quality checks, and lineage tracking to make domain datasets mesh ready and
self service for downstream consumers.
·Planned and Managed SQL Server 2008R2 upgrade to SQL Server 2014.
·Planned and managed On Premises healthcare data migration to cloud of AWS RDS using AWS Data migration
Service.
·Designed, developed and Implemented ETL models for all healthcare subject areas using SSIS 2014 as ETL package
and VS 2015 as development tool.
·Lead projects at various stages from requirements gathering and business rules analysis to creating conceptual,
logical and physical model using Ervin 9.64, SSIS 2014 development.
·Instrumental in creating process, procedures, policies and standards for data warehouse implementation
·Creating/Converting/Managing User Stories into project plans, task allocation, work with stake holders and PMO
office for achieving project goals in an agile work environment using Visual Studio Team Services 2016
·Responsible for project planning, scope management, resource estimation, metrics definition, change control
process, define data quality process and standards, verification and validation.
·Designed architecture for SSIS implementation.
·Co-ordinate with business owners, DBAs, reporting team to address system improvements.
·Mentored individuals from business and technical stand point.
·Responsible for Data Modelling, Architecture, Production support and migration of the product.
AAFES (Army Air Force Exchange Services), Dallas, TX.
Lead Data Warehouse / BI Architect. Jun 2015 – Dec 2015
·Designed, developed and implemented HCA (data warehouse project) for AAFES HR department, using IMS, DB2, Teradata 14 as major sources, staged on SQL Server 2014 and targeted on Green plum database with Informatica 9.5.1 as ETL tool.
·Converted HCA relational model to dimensional model for AAFES HR departments Dashboard, score cards and reporting needs.
·Used Power Exchange to connect to IMS, DB2 and COBOL copybooks, with complex transformations in Informatica 9.5.1 Power Center tools (Sources, Targets, Sessions and Workflows) and pushed to Green Plum database.
·Designed, developed and implemented HCA dash board and reports using SQL Server 2014 SSRS.
·Lead 3 ETL developers and 2 DBAs throughout the HCA project.
·Developed a POC (proof of concept) using ODI 11 as ETL/ELT Tool and OBIEE 11 as BI for AAFES HR predictive analytics Project.
SandRidge Energy, Oklahoma City, OK.
Senior Data Warehouse/BI Architect. Jun 2014 – Jun 2015
·Designed, developed and implemented Spotfire 6 Analysis for SCADA vs Field Direct Measures, production matrix.
·Designed and developed the analysis of MS Service Manager Tickets using Power BI for Office 365 (Power Query, Power View/Power Map and Power Pivot)
·Design, Develop a Dimensional Model for Maximo’s WorkOrder module using SQL BI 2012 tools.
·Lead and Managed databases, data warehouse and ETL Testing with SSIS.
·Developed Powershell scripts to Automate File Delivery From multiple sites FTP Sites
·Helped in design and development of high availability project with AlwaysOn Availability Groups and failover clustering.
·Designed, Developed and implemented a Dimensional Model for Production using SQL BI 2012 tools. Also presented the Production model to the whole IT department.
·Support Production, Midstream and Accounting users for their reporting and analysis needs using Sharepoint 2013, SSRS 2012, Report Model 3 and Spotfire 6.
Bank Of Oklahoma Tulsa, OK.
Senior ETL/BI Architect. Jun 2013 – Jun 2014
·Liaise with business SME in analyzing business requirements, understand various data sources.
·Architect the productivity datamart, review maintain database objects
·Develop strategies for use in high volume, high performance heterogeneous environments, design/capture metadata and rules associated with ETL processes in SSIS.
·Lead and Managed all phases of ETL Testing for Anti Money Laundering project using SSIS and managed and monitored ETL Testing using HP Quality Center.
·Design and develop Technical/Functional specs for ETL development and implementation, manage artifacts – versions, software code, documents, design models and directory structure.
·Map source data elements from various systems, Mortgages, Loans, Wires, ATM, ACH and VisionIP and develop, test support ETL processes.
·Design and develop ETL/Application integration processes for CARS (Historical data integration System) an BSA/Anti Money Laundering (AML/Lookback) Software System called CARS data warehouse using SQL Server 2008R2 SSIS.
·Design and develop ETL/Application integration processes for Actimize a BSA/Anti Money Laundering (AML) Software System called Actimize data warehouse using SQL Server 2008R2 SSIS.
· Designed and developed Lookback an AML history Project using SSIS 2008 R2 as an ETL tool
Spirit Aero System Tulsa, OK.
Senior ETL Consultant. Nov 2012 – Jun 2013
·Provide ETL support to a data migration project from legacy to ERP system (SAP ECC 6.0) using Informatica Power Center 9.1.0. Power Exchange, IDQ.
·Define data read strategies to pull legacy data into spreadsheets and flat files
·Define source and target structures, designed mappings, created sessions and workflows and loaded data into relational targets.
·Formulation and implementation of data migration plans, ETL processes for legacy system to SAP Material Master, Production Planning, Routings and Purchasing.
·Implemented Powershell scripts to Add AD Users to the Contacts DB
City Of Tulsa, OK.
Information / BI Architect Sep 2011 – Nov 2012
·Designed and developed (Pulled multiple sources data into Oracle staging tables and fact/dimension tables using SSIS packages, build ODI processes for extracting, cleansing, transforming, integrating and loading data into DWH, build physical, logical and business models (rpds) to use for User Dashboards) using OBIEE 10/11G Dashboards for Tulsa Airport Statistics (Landings, Cargo and Revenue), Tulsa Police (Incidents Search) and Tulsa Fire department (Fire Response Time) dashboards
·Help upgrade the existing functionality with the new OBIEE 11g capabilities and also developing new functionality in addition to the existing one.
·Design, developed and implemented ETL processes using SSIS 2008 packages to pull data from multiple sources (mainframe vsam files, flat files and sql server tables) to Oracle 10/11G for OBIEE 10G dashboards.
·Designing a semantic OLAP model for Tulsa Airport Authority using Microsoft technologies.
·Upgraded/Migrated SSIS 2005 packages including sql agent jobs to SSIS 2008 on Windows 2008 R2 server.
·Designed/modeled a GIS project, using ArcMap 10 for City of Tulsa Police and Fire Maps.
·Operational governance of the local SharePoint 2010 installation; including setup of the Service Apps, creation of Sites and workspaces, management of users and configuration of the server or farm using the Central Administration tools, management of permissions for users and groups.
Spirit Aero System Tulsa, OK.
Senior ETL Consultant. Nov 2010 – Sep 2011
·Provide ETL support to a data migration project from legacy to ERP system (SAP ECC 6.0) using Informatica Power Center 8.1.1.
·gPLM data migration from Legacy to SAP using SQL Server 2005/2008/ Informatica 8.1.1 as ETL Tools
·Define data read strategies to pull legacy data into spreadsheets and flat files
·Define source and target structures, designed mappings, created sessions and workflows and loaded data into relational targets.
·Formulation and implementation of data migration plans, ETL processes for legacy system to SAP Material Master, Production Planning, Routings and Purchasing.
·Build Report model in SSRS (SQL Server 2005) for PLBOM, a manufacturing application.
·Created a website using C#/ASP.NET with SQL Server 2005 as back end for Material Master.
Brightstar Corporation Libertyville, IL.
A Supply Chain Service Provider for Cell phone industry. May 2010 – Nov 2010
Business Intelligence Analyst.
·Provide system analysis, design development and deployment of Business Intelligence applications using MicroSoft BI development tools. Project is to shift over 1 year worth of data from production, run nightly SQL agent job has ETL package built in SSIS moving 30 tables initial and incremental run shifting data over 84 million records. Built Views for existing 30 reports that look for data on both production and archive databases using SSRS. Created snapshot (Read only database) of production database to enhance reports performance.
·Provide analysis and design of ETL processes for multiple sources to feed data into warehouse using MS SQL Server 2008 SSIS packages
·Performed analysis, design and development of OLAP cubes according to the user’s required facts and dimensions using SQL Server 2008 SSAS.
·Analysis, design and development of Reporting Services using SQL Server 2008 SSRS.
·Providing ongoing support to the .NET applications of the company using Visual Studio 2008, C# 3, ASP.NET, VB.NET.
EDS an HP Company, Tulsa, OK. Oct 2006 – May 2010 Information Specialist / Subject Matter Expert:
·Stabilized and maintained legacy data warehouse platform with numerous code changes and new processes
·Managed major releases and upgrades into the data warehouse environment including fixes and new enhancements
·Involved in upgrading Informatica from 7.1.1 to 8.6.1 and replacing FirstLogic components with Informatica Data Quality (IDQ)
·Proficient in Data Modeling, ER diagrams and hands on experience with ERWIN, ER/Studio and MS Visio.
·Extracting data from relational databases & Loading data into the staging tables and then performed transformations before loading into the target.
·
Contact this candidate