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•Train users to create and tune Tableau workbooks for live query capabilities against a near-realtime data pipeline in Snowflake•Develop batch ETLs in a Hadoop environment using Apache Pig and HiveQL•Support a 90 PB Hive data warehouse using a batch Hadoop environment built on AmazonEMR, EC2, and S3•Develop Python processes to scrape websites and call third-party API endpoints forintegration into a Hive data warehouse•Mentor Analysts and Engineers for process and ad-hoc query development in Snowflake,Hadoop, and Tableau workbook creation

•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•Developed in-house data sanitization process in T-SQL•Develop handling encryption/decryption of sensitive data for applications using SQL Server Asymmetric Keys and Certificates•Create SSIS packages and code stored procedures for import and export of external customer data•Maintenance and development of VB.NET application for report generation and data manipulation•Work under high pressure to resolve production database issues in a 24/7 environment•Effectively communicate change control and maintenance requests to internal stakeholders•Use StarTeam for all database-related code for proper source control and deployment procedures•Work effectively with Storage Administrators for LUN storage needs on an EMC VNX storage array environment•Additional work with Oracle, MySQL, and Greenplum

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.•Mentor and train data analysts and participate in a companywide mentoring program.•Perform level 2 support on server, network, data, and application issues.

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.•Exceptional customer service skills to external clients as well as internal employees.•Strong project management and public speaking skills.•Lead and conduct conference calls with customers. Fully responsible for the data acquisition phase of each project.•Effectively communicate to technical and business leaders.•Strong working knowledge of business operations to properly work with various departments within the organization.

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.•Developed standard build of all desktops and laptops.•Implemented and administered a new help desk ticket tracking system for the entire organization.•Provided support documentation for future help desk employees to help with my transition to a new role.

Mba, Business Administration

Bs, Information Systems And Operations Management