Christian Hirsh
Pittsburgh, PA ·
chhir[email protected]
Scan contact card
Data first thought process with experience leveraging Agile, ETL Pipelines, Database best practices to manage any large scale data warehouse, both on prem and in the cloud.
Certifications
Socialization
Skills
Data Storage
- Microsoft SQL Server
- Oracle
- MongoDB
- PostgreSQL
- Delta Lake
Data Integration
- Informatica PowerCenter
- Microsoft SSIS
- Apache Airflow
- Airbyte
Languages
- C#
- SQL
- Python
- GPT-3 (Chat-GPT)
Data Tools & Reporting
- Jupyter Hub
- Selenium
- Pandas
- pyspark
- MLflow
- Power BI
Platform Development & Administration
- Wordpress
- GitHub
- HUGO
- Atlassian
- Trello
Containers & Cloud
Experience
Agilarc LLC Consulting Experience
Data Integration (ETL)
- Develop Informatica/ SSIS workflows to transfer data between various environments and systems.
- Implement slowly changing dimensions allowing audit teams to see data has changed over time.
- Created custom SQL queries to assure the correct selection of data from sources.
- Profile and generate reports on datasets I created to verify and comply with any business, audit, and deployment needs.
- Used TIDAL automation client to schedule and automate the running or data integration jobs
- Export reports and datasets to various files types (.txt, .csv, .xls, .xml) to present to business members.
- Tracked project tasks in Kanban tools such as LeanKit, Jira, and Trello to assure Project Managers always knew current project status.
- Wrote deployment and knowledge transfer documentation to allow others to maintain my programs.
May 2017 - Present
System Migration
- Oracle to Microsoft SQL Server (Azure)
- Mainframe (COBOL) to Microsoft SQL Server (On Prem)
- Microsoft SQL Server (On Prem) to Mainframe fixed width files.
- Oracle / MS SQL Server to various file types.
Cloud Infrastructure
- Azure – Cognitive Service, Cosmos DB, Azure Functions
- Digital Ocean - Creation and management of safety related web app
- AWS – EC2(custom Larval webapp), RedShift
- Google Firebase – Static website hosting
- Hologram IOT- SIM card messaging (Homemade remote starter project)
Education
The Pennsylvania State University - Erie (The Behrend College)
Bachelor of Science
Management Information Systems (System Analysis)
Minor in Operations & Supply Chain Management
2013 - 2017