Alexander Firmenich Email & Phone Number

Cincinnati, Oh, Us

Cincinnati, Ohio, United States

-Manage onshore and offshore data engineering teams to complete project work and maintain the enterprise data warehouse 24/7-Conduct individual performance reviews based on goals set for the calendar year-Manage allocating resources for project work in conjunction with the Project Management Office-Facilitate conversations to improve IT and business processes-Enforce standards for technical, functional, and business requirements -Collaborate with data and enterprise architects on proof of concepts (solutions)-Collaborate with business stakeholders internally about new requirements for supporting current/future IT applications-Assist with incident management and coordinate remediations-Coordinate with other IT teams for intergation testing, data services, business intelligence, etc.-Lead database deployments/releases between environments and maintaining them-Assist senior management with strategic decisions about the enterprise's data assets

Cincinnati, Ohio, United States

-IT Leadership Development Program, Class of 2022- Manage data engineering contractors for data warehouse enhancements and assisting with their development- Extract, transform, and load (ETL) developer for Microsoft SQL Server, Oracle, and IBM DB2 databases- Create automated workflows using ESP and PowerShell to load data automatically day-to-day for the data warehouse - Assist with projects related to databases used for web applications, reporting dashboards, etc. - Primary point of contact for data quality issues for any databases - Assist with relational data model creations, modifications, and deployments- Gather requirements, create designs, and assist with solution architecture

Cincinnati, Ohio

- Extract, transform, and load (ETL) developer for data warehouse that stores data for 20+ source information systems

Cincinnati Area

- Gathered data requirements from business units and performed analyses regarding data quality- Collected information from stakeholders to change data values in the databases- Assisted ETL developers and web designers with day-to-day data quality issues- Created a TFS dashboard for Agile tracking of user stories and lead daily team huddles

Cincinnati Area

- Created and automated custom reports with SQL Server/Developer to multiple external partners and to colleagues in finance- Worked with IT on user stories/projects to meet business demands and requirements- UAT tested changes within databases- Optimized SQL code for data stage processes to run faster- Worked with big data (credit card transaction data)- Created Business Objects reports for monthly finance reporting

Cincinnati Area

- Helped support and implement pricing actions on Vantiv’s portfolio based on benchmarking from multiple data sources to optimize revenue- Collected and organized data by querying from databases to perform ad hoc analyses to support business strategies - Developed incremental revenue trackers using R and MS Excel to track revenue generated from pricing actions for reporting to FP & A

Greater Philadelphia Area

-Performed credit card processing pricing analyses for merchants to consult how to save costs

Greater New York City Area

Worked as a mathematics tutor for student-athletes ranging from Algebra to Differential Equations.

Master Of Professional Studies (Mps), Enterprise Architecture And Business Transformation

Bachelor Of Arts (B.A.), Mathematics