John Mccaffrey work email
- Valid
- Valid
John Mccaffrey personal email
John Mccaffrey phone numbers
• 14+ years of experience focusing on Data Engineering, Business Intelligence, and Data Governance.• Expert Azure Cloud Engineer focusing on Data Management tools such as Data Factory and Azure Data Lakes.• Extensive experience designing, building, and implementing data warehouse solutions.• Database developer with expert level experience in Pl-SQL (Oracle), T-SQL (SQL Server), P-SQL (Post-Gres).• Adept Python and R programmer focusing on data collection and model automation. • Excellent communication skills and have written detailed documentation and project plans to successfully communicate technical process to non-technical people. Specialties: • DATA SCIENCE: R, Python, RapidMiner• DATABASE: SQL Server, MySQL, Oracle, Greenplum• ETL: Data Factory, SSIS, Informatica, Pentaho• PROGRAMMING: Python, R, C#, Java, TSQL, PL/SQL,• REPORTING: Tableau, QlikSense, Shiny
-
Director Of Data EngineeringIncyte Jan 2013 - PresentWilmington, Delaware, Us• Transitioned from legacy systems to Azure cloud infrastructure, enhancing data processing speeds and reducing costs.• Instrumental in the firm's digital shift through the integration of Big Data techniques.• Developed an end-to-end Azure data pipeline using Logic Apps, Data Factory, Databricks, SQL Server, and Azure Synapse Analytics.• Managed data projects from inception to delivery, aligning with business goals.• Set up a company-wide data lake for enhanced access via Synapse Analytics.• Integrated real-time data processing via Databricks with Spark, boosting real-time analytics.• Designed advanced ETL processes using Azure Data Factory, Databricks SQL, and Python.• Pioneered Azure's integration with GPT-4, employing Vector databases and Langchain for data-centric models.• Partnered with Data Science, IT, and security teams to bolster analytics, compliance, and safety.• Oversaw Azure Resource group budgets, emphasizing cost-efficiency.• Hosted workshops on modern data engineering tools, maintaining team expertise.• Designed graph database solutions with Neo4j and optimized data extraction using Cypher queries.• Established monitoring for data pipelines, integrating with Azure metadata through a Shiny dashboard.]• Engaged with business leaders to align data strategies with company objectives.• Delivered quarterly data strategy insights to executives, highlighting progress and plans. -
Senior Business Intelligence EngineerHighpoint Solutions Jun 2010 - Jan 2013East Norriton, Pa, Us• Create, manage, and maintain large data warehouses and SSAS cubes.• Write complex reports using SSRS.• Meet with clients to gather technical information and come up with solutions.• Mentor junior level programmers and verify proper coding standards have been met by all SQL Developers.• Maintain internal SQL Server DB systems. -
Senior Database Developer, Etl And Data WarehousingCegedim-Dendrite Aug 2006 - Jun 2010La Défense, Cedex France, Fr• Oversee and implement all client data activity. • Write custom ETL processes using DTS and SSIS. • Custom Market Load procedures for specific data for each client and their markets. • Extensive use of DTS and Active X.• Database troubleshooting and repair.• Wrote custom C# web application to monitor all of our jobs across many servers in one central repository. Used built-in ASP.NET authentication tools and wrote custom data and business layers. -
Senior Database AdministratorBiltmore Technologies - Consultant To Sanofi Pasteur Aug 2005 - Aug 2006• Maintain all SQL Server databases for sanofi pasteur. This includes over 40 instances with some extremely large databases of SQL 2000 and SQL 7. • Provide data models and assist developers and analysts for new development using Sybase Power Designer.• Maintain and create indexes, stored procedures, triggers, and jobs when needed.• Perform Performance Tuning; examine and recommend corrections to performance problems and conduct investigations necessary to identify bottlenecks.• Use DTS and BCP to move data between systems.• Migrate schema or procedure changes to production systems when needed.• Wrote security audit scripts to identify weak passwords, privileges and service pack levels. • Created documentation, including backup, disaster recovery, security guidelines, and user permissions. • Implemented a new backup plan to move all backups to tape via HP Open View DataProtector for SQL Server.
-
Senior Database AdministratorProsoft Dec 2003 - Aug 2005Hyderabad, Telangana, In• Maintain all databases for the ROTC Cadet Command Information Management System (CCIMS) as well as all other related databases including JROTC, COOP sites, Scholarships and training sites using SQL Server. • Write complex DTS packages and SQL Scripts for reporting and the transfer of data from/into databases.• Review all T-SQL code written by developers. • Enforce security through Access Privileges. • Responsible for administrating and maintaining merge replication between the Military Domain which acts as the publisher to many different subscribers on both the commercial and military domains. This includes taking down and bringing up merge replication and applying schema changes to the Production Databases twice a month. • Responsible for monitoring the cluster and performing a fail over when needed. -
Senior ProgrammerProsoft May 2002 - Dec 2003Hyderabad, Telangana, In• Wrote code for an extremely large web application to run the US Army ROTC scholarship program.• Debug, correct and upgrade VB and ASP code for the CCIMS information system for the United States Army. • Analyze and implement new engineering changes as set forth by the analysts. • Communicate closely with the analysts to recognized and implement new changes to the system that will most benefit both the user and the functionality and adaptability of the system for changes in the future. • Compile DLL changes. • Write complex SQL code and stored procedures to run reports, calculate queries, and retrieve information. • Use ADO programming in conjunction with VB script to update data fields and keep the Database and the application seamless. • Designed and wrote the USDA Audit Update subsystem to help track their processes using ASP and JavaScript.
John Mccaffrey Skills
John Mccaffrey Education Details
-
William & MaryComputer Science
Frequently Asked Questions about John Mccaffrey
What company does John Mccaffrey work for?
John Mccaffrey works for Incyte
What is John Mccaffrey's role at the current company?
John Mccaffrey's current role is Director of Data Engineering.
What is John Mccaffrey's email address?
John Mccaffrey's email address is jm****@****zon.net
What is John Mccaffrey's direct phone number?
John Mccaffrey's direct phone number is +148495*****
What schools did John Mccaffrey attend?
John Mccaffrey attended William & Mary.
What skills is John Mccaffrey known for?
John Mccaffrey has skills like Microsoft Sql Server, T Sql, Data Warehousing, Databases, Sql, Etl, Ssis, C#, Ssrs, Asp.net, .net, Requirements Analysis.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial