John Mccaffrey Email & Phone Number

Wilmington, 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.

East 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.

La 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.

• 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.

Hyderabad, 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.

Hyderabad, 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.