Nelson Cuadrado Email & Phone Number

Plymouth Meeting, Pa

• Job Processor Frameworko Service Broker and XML-based database system for executing jobs off the main DB server and returning only results to be applied asynchronously. Resulted in significant performance improvements and never having to ask the DB team to disable their jobs during the day again.o Worked with other developers to add their jobs into the framework.• Advice Engineo A rules-based engine that generates preventive care and other recommendations for our members to interact with in the portal and mobile apps. o Through integration, made the Advice available to our Agents for coaching opportunities when members are on the phone.• Member Searcho A search using Full-text indexing over more than 90 million members with an average execution of .25 seconds, which replaced a previous search tool that was loaded with timeouts.o Service Broker is used to sync the member records.• Data archiving system, Data Destruction and Duplicate Removalo These three notable and complex jobs run within the Job Processor Framework and deal with massive amounts of data spanning hundreds of tables.• Campaign Engineo As an extension to the Advice Engine, developed the tools for member selection, applying SMS consent, opt-out logic, case-creation and distribution to the delivery engine in AWS.o Taking the results from AWS such as delivery status, replies and unsubscribes and applying them to the database.

Allentown, Pennsylvania Area

• Completed design, development and deployment of a data warehouse including a normalized data store for consolidating data from multiple systems as well as dimensional data marts for loading into multidimensional databases for data analysis.• Developed ETL packages using SSIS for loading data into the NDS and DDS.• Created a suite of executive-level reporting from the new warehouse using SSRS.• Created SSAS cubes for data analysis as well as trained high-end users to navigate and dice the cubes using Excel and PowerPivot. • Assisted the team with migrating to TFS from Perforce. Developed a document set for common TFS-related tasks and led the training effort.• Completed four complex reporting projects for the Fraud, Policy Administration Services, Operations and Quality Control units. Many of these reports completely automated manual tasks and contributed to improving departmental efficiencies.• Developed a framework for mass-generating subscription reports using SQL Server 2008 Standard Edition. The process mimics data-driven subscriptions without the need for SQL Server Enterprise Edition.

Plymouth Meeting, Pa

• Designed and developed a data warehouse for providing unified reporting from over six OLTP databases and the Master Data database. Personally designed the entire database model and the ETL needed for loading and keeping the warehouse current. As part of this project, led the database team and a team of consultants to rewrite numerous of reports from the separate OLTP databases to the collective data from the warehouse. • Designed and implemented a central repository database for the management of master data including client, member, eligibility, subscribed services, medical plans, documentation and other related information to make available to call center and operational staff.• Designed and built various repository databases for storing data from externally hosted applications, most importantly – the CRM database. Designed and implemented integration packages using SQL Server Integration Services (SSIS) for synchronizing these databases from data feeds. Constructing this integration led to over the development of 200 management and executive-level reports, many of which are now critical to day-to-day operations and executive-level decision making.

Wyomissing, Pa

• Project lead on multiple database system implementation projects.• Responsible for providing training and direction to developers in advanced programming techniques.• Evaluation and testing of database auditing software.• Development of database administration for managing SQL Servers on the enterprise.• Conversion of Access applications to SQL Server back-ends.

• Responsible for migration from SQL Server 2000 to SQL Server 2005 and implementing new SQL functionality including Reporting Services and Integration Services.• Report creation using SQL Server Reporting Services, Active Reports and MS Access.• Performance tuning, including query fine-tuning and indexing.• Creation of the majority of server-side programming objects and functionality including audit trails, alerts, triggers, user-defined functions, stored procedures and the migration of legacy data into the new system.• Setting up and monitoring advanced replication jobs that supply the data warehouse and the external web site.• Monitoring SQL Servers in production, maintaining security and optimizing databases.• In collaboration with a team of developers, developed and implemented the Global Project Management System; a mission-critical system designed for maintaining project, inventory, purchasing, billing and related data.• Prepared system documentation; trained and supported end-users.

Data Modeling/Warehousing And Database Administration

Computer Information Systems

Education record

I took Honors and Advanced Placement courses, played trombone and baritone horn in the school band, served as Senior Class President