Patrick Crosby Email & Phone Number

United States

Houston, Texas, United States

• Implemented and managed multiple new major infrastructures as a key project team member• Performed data migration tasks including extraction, transformation, cleansing, and loading of data intonew infrastructures.• Developed, tested, and implemented integrations to connect data between multiple systems utilizing SSIS and eOne Smart Connect• Software testing and debugging• Assisted Avio project team with Mulesoft integration testing and error log troubleshooting for Salesforce,NetSuite, and Paycom.• Enhanced functionality by adding new fields, updating logic and listener code, all while closely monitoring Anypoint Platform.• Managed SQL 2012, 2014 Servers, SSRS, SSIS, Oversee integrity of the data infrastructure., CRM, CMMS,CES, GP, Hygiena, Avalara Configuration, NetSuite• Provided technical support for company's ERP system.

Houston, Texas, United States

• Managed and ensured the integrity of the organization's data infrastructure• Extracted, transformed, and loaded data using CloverETL and SSIS.• Developed and implemented Cognos framework structure to enhance reporting capabilities.• Managed a team responsible for Data Warehouse/BI operations.• Managed multiple infrastructure projects• Maintained balanced and seamless flow of technical work in the environment• Implemented proactive procedures to enhance efficiency and mitigate risks• Collaborated with team members to strategize and implement preventative measures, ensuring safety and avoiding cave-ins.• Assisted in optimizing solution manual workflow for improved productivity• Explored solution possibilities, troubleshooted and brainstormed to keep up with fast-paced technology advancements.

Houston, Texas, United States

• Acted as a technical escalations and oversaw incidents to completion• Managed the timely resolution of breached SLA tickets and ensured prompt completion.• Enabled the successful integration of IBM Cognos across the organization.• Managed security and administration of a business intelligence tools.• Developed complex functions, scripts, triggers, views, and stored procedures to aid in report development and decision making.• Supported ETL schedule while maintaining compliance and developing various standards to consistently execute ETL codes, ensuring an effective project life cycle.• Managed and maintained data warehouse and SQL Servers• Facilitated smooth transfer of data from Excel to data warehouse by utilizing thorough data analysis, conducting business user interviews, and implementing complex SQL procedures and ETL graphs• Addressed data migration issues while collating data from various source systems, including NetSuite, Salesforce, QuickBooks, and manual Excel spreadsheets.• Designed and implemented data warehouse models, integrating meta data into systems and creating necessary reports for end users.• Collaborate with all developers and business users to gather required data and concrete understanding of ultimate reporting goals. Monitor performance of databases.• Played a key role in the planning, design, development, and architecture of new databases.• Designed, architected, and implemented tables/views according to consumer requirements.• Maintained consistent schedule for data back-up and archiving.• Developed best practices for database design and development activities.• Liaised for online management systems, supporting development through go-live and maintenance for multiple departments including HR, Wellness, and Online Learning.• Enhanced the efficiency of complex code and graphs• Prepared for ERP introduction and data migration

Houston, Texas, United States

Promoted to help desk team lead responsibilities include ensuring excellent customer service, meeting SLAs, and managing incident restoration.• Acted as technical escalations and oversaw incidents to completion.• Managed the prompt resolution of SLA tickets.• Directed the help desk team to exceed customer service expectations.• Conducted meetings with IT service requesting departments to grasp business needs for services.• Enhanced helpdesk processes to optimize customer service experience for clients.

Houston, Texas, United States

Supported company-wide desktop support and technical operations as part of a helpdesk team. Assisted internal clients in person and remotely, delivering immediate assistance. Provided on-call coverage during off hours.• Maintained software and hardware to meet daily user needs.• Streamlined processes, enhancing customer service and increasing efficiency for clients.• Assisted system administrators with server and network support.• Took ownership of delegated projects from the helpdesk manager and successfully achieved their completion

Houston, Texas, United States

Primary point-of-contact for all desktop support and technical operation functions in a not-for-profit medical home facility. Provide immediate assistance to correct and advise on hardware/software issues pertaining to computers, electronic health records, practice management and phone systems; all while serving as a knowledgeable resource for data analysis, financial reporting and other productivity needs.• Spearheaded new pediatrics office with complete setup and execution of main server, computer work stations, network server, EMR and POS systems and more.• Office opened up to roughly 20% increase in revenue, charting the fastest and most sustainable course to business growth.• Improved customer service for desktop support by revamping entire helpdesk system with new network access management structure, including an employee database for privilege, access and hardware tracking.• Simplified network by applying new switches to LAN line phone, saving hundreds of dollars in annual expenses.

Philadelphia, Pennsylvania, United States