SUMMARY

Mr. Curley has over ** years of experience in the project management, modeling, design, development, administration, migration, deployment, and implementation of RDBMS based enterprise applications, warehouses, marts, services, web sites, and tools. Mr. Curley is exceptionally proficient with all aspects of the SQL language, as related to T-SQL and PL/SQL. Mr. Curley has worked primarily as a Data Architect, DBA, and SQL Developer using Teradata, Oracle, MS SQL Server, and Sybase. He is well-conversant with technologies such as Clustering, High Availability, Disaster Recovery, Replication, Scalability, OLAP, OLTP, SOA, ETL, OLE, ADO, ERP, MRP, CRM, Data Modeling, Virtual Machines, Cloud Computing, Analysis Services, Reporting Services, Integration Services, Notification Services, Homogeneous and Heterogeneous Data Migration, reporting tools, and others. Mr. Curley’s DW experiences have encompassed both Inmon’s methodology of a single version of the truth and top-down approach and Kimball’s bottom-up BI orientation.

EDUCATION

Carnegie Mellon University, Pittsburgh, PA

BS in Mathematics

EXPERIENCE

1/20 – Present, Boyd Gaming EDM. Las Vegas, NV

Data Architect for an Enterprise Data Warehouse. Worked as a Senior Data Architect using ER/Studio, Sparx EA, and MS Visio on MS SQL Server, MySQL, and Snowflake and their associated tools. Wrote documents that comprised an analysis of the present state of the EDW and set standards to be followed by developers in terms of structures, documentation, testing, SDLC, and other parts of software creation. Modeled data requirement gathering and data profiling. Created Flow Diagrams, Entity Relationship Diagrams, both Logical and Physical, and Deployment diagrams. Analyzed and presented an analysis of Query Execution Plans of troublesome queries to developers and pointed out the issues and used this as a teaching opportunity for developers to understand better query writing techniques.

7/19 – 1/20, Nike ED&A. Hillsboro, OR

Data Architect for Finance and HR Enterprise Data and Analytics. Worked as a Senior Data Architect using ERWin Data Modeler for SAP, Snowflake, Oracle, and MS SQL Server and associated tools for each RDBMS listed. Modeled data outlined by way of requirement gathering. Created Procurement, HR, and Ledger Dimensional Logical Models based on the aforementioned requirements. Subsequently, physicalized those Logical Models into Physical Data Models and its corresponding DDL for Snowflake.

5/18 – 6/19, State of Nevada, Carson City, NV

Data Architect in the Welfare Division’s Child Support Enforcement System. Worked as a Senior Data Architect using Toad Data Modeler, DB2, Oracle, MySQL, and MS SQL Server and associated tools for each RDBMS listed. Also, designed and modeled data from the requirements outlined in an RFP and Response. He also ported the objects to each of the RDBMS mentioned above. He created a fully Normalized(3NF) Logical Model based on aforenoted documents and requirements. He physicalized that Logical Model into a Physical Data Model and its corresponding DDL for each of the RDBMS. He created all those databases from Physical Data Models via forward-engineering. Loaded requisite reference data into the database via insert scripts based on ISO, FIPS, OCSE, USPS, and other standards.

1/17 – 5/18 Clarus Commerce, Rocky Hill, CT

Data Architect for a Corporate Data Warehouse. Worked as a Senior Architect using Erwin. SQL Server and SSIS. Created new ETLs via models, data profiling, and mapping from the existing production OLTP web-based application. Created extracts for Data Sources used in Tableau dashboards and worksheets.

Met with persons throughout the company to translate their requirements into specifications, formal requirements documents, data maps, models, and ETLs required to meet the company’s needs. Piloted a transfer of EDW into Redshift on AWS.

5/16 – 1/17 Cigna, Bloomfield, CT

Data Modeler for a Corporate Data Warehouse. Worked as a senior modeler using ERwin principally for Operational Readiness, which constitutes the reference data used within the warehouse, including data quality and other monitoring tables. In that capacity, directed and trained in-house, on-shore, and off-shore personnel in the use of ERwin, modeling principles, models, and their associated DDL created. Advised and taught persons in the analysis of Query Execution Plans and Data Analysis and the use of monitoring tools within Oracle and Teradata.

10/15 - 4/16 MCHS, Miami, FL

Data Architect, Modeler for an existing MCHS EDW. Reversed Engineered the existing ERD and analyzed Informatica and BODS processes to identify gaps, deficiencies, and relational model errors. Redefined primary keys, foreign key relationships, data structures, and redesigned processes to mitigate issues discovered. Modeled structures using ERwin and created DDL in Oracle 11g and corresponding HDFS file structures to load unstructured and EDW Reference Data into Cloudera Hadoop for Research Scientist to use in Big Data Analysis. Directed off-shore and in-house persons in creating models and ETL

9/14-10/15 ESPN, Bristol, CT

Data Architect, Modeler. Primarily Data Modeler and Architect for ESPN’s Content Scheduler. Mainly took the old system and redlined it to run on Oracle Exadata using Hibernate as an ORM Tool. Considering these two essential requirements all modeling using Power Designer was directed around a Third Normal Form goal These tasks involved a complete profiling and analysis of the existing data and usage; a Conceptual Data Modeling effort; a Logical Data Model effort; a Physical Data Modeling effort; initial data loading analysis, scripting, testing and deployment of DDL and its associated DML.

7/13-9/14 Mozido, Austin, TX

Data Architect, Modeler, DBA. Primarily Data Modeler and Architect for mobile cloud-based banking applications used to transmit and reconcile money transfers. Created CRM, LDM, PDM, and Physical ERDs and managed metadata and created DBs and the associated objects using DataNamic DeZign. Also, he created the Functions and Stored Procedures used in the Dimension of Time, Geography, Customer, and the Facts of Money Transfers within the DW. He oversaw the delivery of data and the analytics from the DW to the user community using Postgresql and Pentaho.

12/12-7/13 Bank of America, Addison, TX

Data Architect, Modeler. Primarily Data Modeler and Architect for banking applications used in monitoring foreclosures and remediation of mortgages and the legal rules used to regulate that process. Created DFM, CRM, LDM, PDM, and Physical ERDs, managed metadata, created DBs, OLAP Cubes, and the associated objects using Sybase PowerDesigner. Also, created the Functions and Stored Procedures used in Dimension of Time within the DW; oversaw the delivery of data from the DW to the user community using SSRS, SSIS, and SSAS, IBM Cognos and Tibco Spotfire.

10/11-12/12 Link Technologies, Las Vegas, NV

Data Architect within an environment for modeling, developing, migrating, and administrating systems used in significant releases of databases, database objects, data marts, and reports for MGM Resorts International’s Data Warehouses; used Teradata, Oracle, MS SQL Server, and their associated languages and their tools. Also, created models generated through ERwin and deployed the resultant DDL. Managed project to deliver Hotel Reservation housed on an Oracle-based system using SSIS for staging on MS SQL Server and terminating into Teradata. Utilizing this technique allowed the building of join indexes, the building blocks for materialized views in Teradata used by Data Marts that mitigated an issue where the ETL was fully extant on Teradata, the Data Mart building via materialized views processing was non-performant. During the construction of this project Teradata tools employed were Parallel Load, FastLoad, MutiLoad, Visual Explain, Index Wizard, Statistic Wizard, System Emulation Tool, and Workload Management and Oracle’s SQL Developer and SQL Server’s SSIS, SSMS, SSRS, SQL-Diag, SQL Nexus, Performance Monitor and MS Visual Studio.

3/08-10/11 IGT, Reno, NV

Data Architect/DBA in an environment for modeling, developing, releasing, upgrading, and administrating systems used in significant releases of database objects and their corresponding Windows Services used to control gaming devices in large casino environments. Duties included building servers and maintaining development environments as well as patching applications, modeling new and existing databases and objects, writing Stored Procedures and T-SQL scripts, developing upgrade scripts, backups and recovery, job schedules, security, user, roles, and file maintenance. Also, participated in a team that tested and released IGT Systems into new casinos such as Aria and Cosmopolitan of Las Vegas. Worked nearly exclusively with MS SQL Server 2005 and SQL Server 2008 R2 on Windows Server 2003 and Windows Server 2008 as well as .Net and VSTFS DB Professional. Performed and completed a project to scale-out SQL Server 2005 using a mixture of vertical and horizontal methods. Created release packages using InstallShield for all DDL and DML changes released to production databases, including pre-and-post deployment test scripts and supporting documentation. Modeled Analytics DW using SSRS and oversaw install and testing within IGT’s Interoperability Lab as well as modeling and developing reports using SSIS and SSRS.

8/06-2/08 Covance, Reno, NV

Data Architect/DBA for testing, developing and administering systems used for significant releases of databases and their corresponding applications used to read ECG data over the web. Duties included modeling DBs, building servers, and environments, as well as patching applications, backups and recovery, maintenance, job schedules, security, user, roles, and file maintenance. Majority of production work using MS SQL Server 2000 on Windows 2003 with some additional conversion work on MS SQL Server 2005, including upgrades, clustering, and replication. Designed, developed, integrated, and deployed all models, complex queries, and SPs used for all new development. Coordinated, developed, and implemented a project to change SQL Server Authentication for applications to use Windows Authentication exclusively with Logons by Services. Created release packages for all DDL and DML changes deployed to production databases, including post-test scripts and supporting documentation.

9/03-8/06 JTS Communities, Sacramento, CA

Performed and executed a SQL project to Cluster MS SQL Server 2000 on Windows 2003 for High Availability. Acted as sole DBA for production support of SQL Servers; deployed all backups, restores, user maintenance, test system refreshes, and supported applications and servers when problems were encountered, Ported a system based on InterBase/MS-Windows 2000/VB-6 to MS-SQL/Windows2000/.NET; created scheduling system to arrange construction crews’ schedules with dependencies, time constraints, and variances. Developed scripts to automate backup and recovery for disparate databases throughout the enterprise.

7/99- 9/03 Pumatech, Inc., San Jose, CA

DBA and Data Modeler/Architect for an Oracle 8i-9i/Solaris/Wireless Internet-based application development and production systems. The production system incorporated EMC Symmetrix and Veritas Cluster Server and Net Backup. Also acted as DBA on a Baan 5c/MYSQL-Server/Windows 2000 system; ported various Sybase development systems to Oracle production systems. Production DBA support on a 24/7 basis, backup and restore databases, maintained user logins and passwords, maintained replications, schema and schedules, created test and QC environments and their refresh schedules, automated performance monitors to spot troublesome queries and computer performance issues before failures.

5/96 – 7/99 Sun Microsystems Mountain View, CA

DBA and Data Modeler for a Scopus (Seibel/Solaris/Oracle based worldwide customer support call center system, participated from conception until the final roll-out of the production system. Also, designed, developed & implemented an application to migrate existing call center data into the new system.

4/94 – 4/96 Sybase, Emeryville, CA

Development DBA and Data Architect. Deployed a new bug tracking system to coincide with the release of Sybase 11 software. The system was Sybase/Unix/Siebel based, and also created a homogeneous data conversion system to load the “old” data into the new system. Created a development environment, and acted as DBA for all servers used in the project, modeled changes for developers’ use, built and deployed schema changes and releases.

10/91 – 3/94 Apple Computer, Inc., Cupertino, CA

Technical Lead/Project Manager, the USA, and Pacific Data Warehouse Created all design documents, including ERDs, HLD, LLD, and code to incorporate customer classification data into the warehouse network. Coordinated a Configuration Management task for all the Apple Warehouse systems. Ran a project to consolidate data from existing legacy systems into one central repository and reporting system. Created designs, schemata, and models; staffed and supervised all aspects of code and database generation, application deployment, and implementation; and acted as a central focal point for inter-departmental communication and problem resolution.

9/90 – 10/91 Icotron, Honeywell Advanced Controls Division, Phoenix, AZ

Application Developer. Application Developer for the tracking system to download control data into Sybase and Ingres databases. Built reporting system and laboratory analysis interfaces and created an entire application to track production data in an aluminum manufacturing plant.

1/90-9/90 Ingres Corporation, Alameda, CA

Porting Engineer. Porting Engineer for test tools on significant releases of Ingres (6.2 and 6.3). Coordinated a department-wide Configuration Management implementation to organize the versioning of ports for each of the deployment platforms.

6/88-1/90 ABB-Impell, San Ramon, CA

Senior System Analyst. As a Senior System Analyst for the Nuclear Consulting Division created human interface applications to monitor plant performance and created reporting programs. Project Engineer on various projects.

5/85-6/88 Sacramento Municipal Utility District, Sacramento, CA

Senior System Analyst Nuclear Engineering Division. Created human interface applications to monitor plant performance and reports.

11/83-5/85 Sandia National Laboratory, Particle Beam Accelerator Group, Albuquerque, NM

Entry Level Programmer. Entry Level programmer for real-time experiments.

Contact this candidate