PATRICK DCOSTER

ad0rpq@r.postjobfree.com

Mobile: 512-***-****

Professional Summary:

Over 12 years of experience in data & analytics, specializing in data warehouse, data integration, and reporting.

Strong background in performance tuning T-SQL queries and procedures.

Proven track record in troubleshooting and optimizing ETL codes by redesigning tables and indexes.

Designed, developed, and implemented ETL processes for complex, high-volume data sources.

Expertise in data modeling with star & snowflake schemas to meet domain and business requirements.

Designed data warehouse tables for clinical, claims, and finance projects, focusing on performance optimization.

Proficient with tools like FileZilla, putty, Go Anywhere for FTP, SFTP, encryption, and decryption operations.

Skilled in Unix scripting for server-to-server file transfers, data masking, and encryption.

Collaborated with multiple agile and Kanban teams to deliver projects within specified timelines.

Produced PPTs, Visio data flow diagrams, and design documents for strategic project scoping.

Led end-to-end software development lifecycle (SDLC) of data warehouse ETL processes.

Bridged the gap between business and technical teams, translating requirements into technical tasks.

Assisted in building ETL and reporting requirements, including STTs, BRDs, and user stories.

Contributed to designing scrum boards for Op-ex & Cap-ex lanes in collaboration with product owners.

Facilitated story creation and task breakdowns for ETL and reporting teams.

Known for strong interpersonal skills, maintaining positive relationships with internal teams and business users.

Recognized as an effective leader by upper management and technical development team.

Technical Skills:

Languages

SQL, PL/SQL, Unix Scripting, Windows Batch Scripting

ETL Tools

Informatica Power Center 10.5.1,10. 1/9x Informatica IDQ, SSIS, DataStage, SaaS (Enterprise Guide)

Case Tools

ERWIN and Microsoft Visio, Google Drawio

Databases

Phoenix, Vertica, Oracle 11g/10g/9.x/8.x, SQL Server, Netezza, Salesforce Cloud, MS Access. Azure Data SQL

Reporting Tools

IBM Cognos 8, Tableau, Crystal Reports, Power BI

Dev Tools

Toad, SQL Loader, SQL PLUS, Agility, Work Bench, Microsoft SQL Server Management Studio, DB Visualizer, Explorer ++

Others

PL-SQL Developer, Active Batch, Jira, Bit Bucket, Version one, Star Team, Service now, Control-M, Star Point, Go Anywhere, Hip Chat, Jabber, Windows Messenger, Notepad ++, MS Office.

Professional Experience:

Boston Medical Center – Personal Soft

Role Sr. ETL Specialist – Contractor (Remote) May2022 – Current

BMC is a health care company and I was brought in to handle some of the ETL processes that were causing delays and issues. I started off by working with vendor clinical data trying to get the ETL process to run smoothly and refining the ETL process. After which I was brought to a claims project that needed to just be deployed to the production environment but later on, we realized that the process did not have a proper design so I had to redesign the entire process.

Work with the business to get requirements, define the design, data flow, tables, and database objects.

Work with the QA team in helping with the data load, data testing and validation.

Design the data flow, tables, and database objects.

Work & assist the team and the admin on the ETL code migrations to QA & Prod environments.

Hand off and KT sessions with other ETL developer.

Production support for some of the ETL process while they were setting up an offshore team.

Coach & mentor other developers on the SDLC & ETL processes.

Build batch scripts for file transfer, zipping and archiving files.

Bank of the West – Tek Systems

Role Sr.ETL Developer – Contractor Phoenix, AZ, Nov 2021 – October 2022

Working as a Sr.ETL developer for AXIOM team which does the monthly Fed reporting for Bank of the West.

This includes any new development or enhancements to existing ETL code.

Working with the off shore team in coordinating releases and getting requirements.

Work with the offshore QA team in helping with the data load, data testing and validation.

Work with the offshore QA team to understand the ETL process and steps and help them in building test case scenarios.

Was involved in Migration of code from the Development layer to the Production layer.

Vizient – Creospan

Role: Sr.ETL Developer – Contractor Chicago, IL, September 2019 – November 2021

I completed the second project with them recently. This was to automate a SaaS process to a fully automated ETL process. It was to build the various reports on the Operational Data Base data from around 500 hospitals. My role was to work with the product owner directly along with the BA understand the process design and architect the data model and implement the ETL. This was a challenging project since we started this during the pandemic and the product owner was our only source of information.

I also worked on a previous project before, this project was to help build on their Clinical Data Mart which was in multiple databases. It was loading different entity data points which were enriched thru pie-spark process and placed in hive phoenix database. I was brought in to help with the last final load of data marts load after the enrichment process is completed.

Build and collect requirements from the business and the technical SME’s along with the BA. Create STT’s, user stories and acceptance criteria for the defined requirements.

Develop, Unit test and QA the ETL mappings. Work with the business user on UAT in different environments.

Build stored procedures around the current rules for each process and then enhance them as we move along to fine tune the process itself.

Work with the QA team in helping with the data load, data testing and validation.

Work with the QA team to understand the ETL process and steps and help them in building test case scenarios.

Scheduling ETL jobs using tools like active batch & windows scheduler.

Build user acceptance scenario along with the users.

Work with the admin on the ETL code migration.

Designing tables for different dimensions and facts.

Code review and QA testing other developers ETL work.

Deployment documentation.

MedPro – Paradigm Fort Wayne, IN, March 2019 – July 2019

Role: Sr.ETL Developer – Contractor (Remote)

This project was to re-design the EDW of MedPro from the old model to a new refined model. I was brought in for the EDW development along with working with some of the junior members to mentor and help with the development on their side. It also involved working with the business on refining the STT and requirements and updating stories accordingly.

Work with the business to get requirements. Getting mapping documents updated and refined as per standards.

Design the data flow, tables, and database objects.

Create documentation for the project, STT documents, QA documents, Migration documents, data flow diagrams, ETL Scripts to create database objects.

Develop, Unit test and QA the ETL mappings. Work with the business user on UAT in different environments.

Scheduling ETL jobs using tools like Control-M, Informatica scheduler, active batch & windows scheduler.

Work with the admin on the ETL code migration.

Trouble shoot issues and find solutions and data discrepancies.

Code review and performance tune ETL processes

Work with business users on defining requirements and translating them into tasks for developers.

Since I was the first one to be brought on to one of the projects I had to bring other team members and teams up to speed with KT sessions on the project.

Wilton Brands Naperville, IL, Nov – 2018 – March 2019

Role: ETL Developer - Contractor

Worked on the data Integration from multiple sources like oracle, flat files, MS access, and cloud to synchronize the central product management system. This was previously being done manually so I had to start from step one, so the new ETL process is standard and robust. In this project I worked all by myself along with the business user and managers to get requirements, break it down into technical tasks, develop it, QA and UAT it, migrate the code to different environments and eventually hand it off to the user in production after release.

Work with the business manager to get requirements define the design, data flow, tables, and database objects. And get the architects blessings before implementing it.

Create the source and target connections for Informatica so data can be read, data can be loaded into the database.

Create documentation for the project, STT documents, QA documents, Migration documents, data flow diagrams, ETL Scripts to create database objects.

Develop, unit test and QA the ETL mappings. Work with the business user on UAT in different environments.

Work with the admin on the ETL code migration.

Hand off and KT sessions with other ETL developer.

Created batch scripts to schedule the Informatica jobs for daily and weekly runs.

Created some windows batch scripts to FTP and SFTP files to read data and write data to remote servers.

DaVita (Village Health) Vernon Hills, IL, Jan 2017 – Nov - 2018

Role: Data Integration Tech Lead

File Management: Worked on formulating the technical design for intake of files from different payors. I had to develop a design that can fit different payors, files, domains, and different cycles. We had created an ETL process that can replicate a manual process that was differently for different payors for different files. I was leading the technical team alongside working with the business and being an SME on the project.

Sales Force & Enterprise DWH: Worked on getting data from an OLTP application database into Sales Force Cloud. Created a design to work with the reporting team and consume the files being provided by them into Salesforce Cloud. Also worked to get data back from Sales force into a Netezza enterprise DWH. This DWH was where all the data across the village was being housed for reporting purpose.

•Created & developed the design and architecture for incoming projects

•Designed database objects as per the need of the project.

•Put together L0, L1 and final development estimates for projects.

•Participated in understanding of data specifications and data objects to integrate data with other systems.

•Prepared and documented ETL processes and design specifications for audit purpose.

•Provided technical guidance during all stages of SDLC.

•Participated in understanding and analysis of business requirements.

•Formulated and maintained new ETL processes and specifications.

•Prepared and executed standards for data warehouse projects.

•Developed and implemented integration test plans for Informatica sessions.

•Designed and developed ETL processes for data warehouses and data marts.

•Lead both the Capex and Op-ex sides of development

•Created Visio and PPT’s for business users and developers to explain process and data flow.

•Conducted code reviews and migration reviews.

•Helped the team in troubleshooting and resolving production and performance issues.

•Delegated work according to Sprint needs and picked up development work if needed.

•Build scripts for file cleanings & file moving within same servers or different FTP & SFTP servers.

DaVita (Village Health) Vernon Hills, IL, Jan 2013- Dec 2016

Role: Sr. ETL Developer

Description: We built the Clinical Data warehouse to help the Village Health business users and nurses to analyze patient progress and make changes in the patient routine. This project also helped the nurses to look and evaluate the nurse performance, so they could help in the recovery of the patient. We also built the Claims Data Warehouse for various payers like ‘HUMANA’ and ‘SCAN’ to analyze financial data.

•Involved in business analysis meetings with the end user to understand the existing system and future requirements.

•Prioritize projects based on the customer deadline and budget allocated for the projects.

•Act as an intermediate between the business analyst group and the ETL development team to understand the requirements and translate them into technical specifications.

•Involved in the design and development of data warehouse and reports to track the key business entities. Informatica is the ETL tool used to load the data into the data warehouse and Congo’s for creating the reports.

•Identified the facts and dimensions based on the line of business and designed the relevant dimension and fact tables.

•Developed UNIX shell scripts, PL/SQL stored procedures for creating/dropping of table and indexes and executing procedures.

•Loaded target data on daily, weekly and monthly basis using incremental aggregation.

•Imported data from various sources transformed and loaded into data warehouse Targets using Informatica.

•Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.

•Optimizing query performance and performance tuning the code to reduce the load on the server.

•Created partitions to concurrently load the data into sources

•Unit testing & QA testing mappings, defining acceptance criteria as per user requirements.

•Documentation to describe program development, logic, coding, testing, changes, and corrections.

•Was involved in Migration of code from the Development layer to the Production layer.

•Worked with the offshore team to complete migrations and work on production issues.

•Responsible for delegating the tasks to Jr developers, helping & mentoring them.

Business Intelli Solutions

Client: DaVita Village Health Vernon Hills, IL May 2011- Dec 2012

Role: ETL Developer (contractor)

Responsibilities:

•Designed mappings using the transformations joiner, aggregator, expression, lookup, Router, Filter, and Update Strategy transformations and mapplet’s to load data into the target.

• Extensively used Informatica 9.1 in loading data from flat files, sources, and Oracle.

•Optimized and fine-tuned SQL queries, stored procedures, data load processes to avoid overhead on the database and application servers.

•Worked on Power Center client tools like source analyzer, target designer, mapping designer, mapplet designer and transformations developer.

•Created complex mappings including slowly changing dimensions and data loads for OLTP systems.

Dell International, Hyderabad, India June 2007 - June 2008

Role: Sr. Customer Support/ QA auditor

Responsibilities:

•Started off doing customer support initially answering calls for US business customers

•Was later promoted to an auditor role which I listened into calls from other teammates and gave feedback on quality and improvement options.

ICICI Bank, Hyderabad, India May 2005 - May 2006

Role: Phone banking officer

Responsibilities:

Answered queries on the phone for all enquiries about all loans and loans against shares.

Audited calls and later was promoted as soft skills coach.

Listened to calls and gave feed back to new Phone officers.

EDUCATION

University of Central Missouri, Warrensburg, MO (Aug 2008 – Dec 2010)

Master of Science, Industrial Management

CMR College of Engineering, Hyderabad, India

B. Tech in Mechanical Engineering.

Contact this candidate