Merritt Cely, Mba Email & Phone Number

Cary, NC, US

• Promotion path at Epic is Data Engineer->Senior Data Engineer->Engineering Lead, Data
• Manage a team of Engineers responsible for building and supporting the Data Warehousing environment at Epic
• Own the execution of a project to migrate from Hive->Databricks-- Previous experience highlights at Epic --
• Own, design, develop, and maintain a 1.5 PB Snowflake data warehouse adopted by over500 users for ad hoc queries, BI analysis with Tableau, and custom application integration
• Develop Python process that loads 500-700 million records every 10 minutes into Snowflakefrom Amazon S3 for Fortnite and other products
• Design Python process that determines data types of JSON keys and automatically parsesthem into their own tables with properly typed columns

• Design, Develop, and Optimize a SQL Server Data Warehouse using SSIS and T-SQL storedprocedures
• Design and develop ETL processes using SSIS for external and internal data imports
• Create and Update Tables, Views, Triggers, and Stored Procedures for SQL Server 2012 in afast-paced, startup environment
• Develop table-driven business rule engine using dynamic SQL for transactional data integrity
• Create reports using QlikView and NPrinting
• Optimize T-SQL queries for enhanced application performance

Morrisville, North Carolina, US

• Troubleshoot bugs and maintain code for C# data extract executables for CSV and XML file formats
• Write and maintain T-SQL and PL/SQL stored procedures, tables, views, functions, triggers, and indexes for SQL Server 2008 and Oracle 11g database platforms
• Data modeling – simplify and denormalize data for a leaner and streamlined database structure
• Use Subversion/TortoiseSVN for source control for multiple software versions
• Utilize Test Track Pro and Salesforce for bug tracking and resolution

Morrisville, NC, US

• Create and manage T-SQL stored procedures, tables, views, functions, triggers, and indexes in a MS SQL Server 2005/2008/2012/2014 environment
• Set up and configure multiple SQL Server instances using Replication and DTC Transactions in a clustered environment
• Tune database performance (execution plan analysis of stored procedures, index tuning, parameter sniffing, and table/view design) and work with software development team on applicable issues
• Monitor performance of database instances and troubleshoot issues using Idera SQL Diagnostic Manager
• Develop SQL Server Maintenance Plans for Full, Differential, and Transaction Log backups to EMC Data Domain
• Refresh 2.1 TB of production data to 5 other instances (2 DEV, STAGE, QA, and UAT) on a 2-month “slot” schedule

Greensboro, NC, US

• Promoted from Data Analyst.
• Developed SSIS package to automatically index claim images into ApplicationXtender document management system
• Act as liaison between.NET software development team and business stakeholders to create a clear specifications for the development team, as well as meet the requirements needs of customers.
• Fully document software requirements and other areas such as competitive intelligence whitepapers, help documentation, and process workflows.
• Create and track user stories and bugs using TFS.
• Perform software quality assurance.

Greensboro, NC, US

• Promoted from Help Desk Analyst/Client Support Specialist.
• Perform data acquisition, analysis, and integration from client ERP systems (SAP, Oracle, Peoplesoft, Legacy systems, etc) into the FirstStrike recovery audit platform.
• Extensive use of SQL and Pervasive Data Integrator for data manipulation, mapping, and management.
• Database management using MS SQL Server tools.
• Loaded data into SQL Server from a variety of formats, including ASCII, Excel, and EBCDIC.
• Performd ad-hoc reporting for auditors and clients using SQL, Excel, and Access.

Greensboro, NC, US

• Won outstanding associate award for excellent customer service feedback from a Fortune 10 telecommunications client.
• Perform level 1 support on various technical issues for internal and external customers, including Citrix support and troubleshooting.
• Primary support contact for over 50 clients of Fortune 500 companies.
• Provided Citrix Presentation Server 4.5 support for three separate farms.
• Worked with each client in a 2003 Active Directory environment.
• Increased scope of help desk support – in addition to desktop support issues, supported server-level issues and external customer issues with software implementations.

Mba, Business Administration

Bs, Information Systems And Operations Management