Career Progression
 

SQL DBA

Next Wave Logistics                                                                            Oct 2010 – Dec 2010      

Performed data modeling to convert legacy structures to a normalized model. Removed value based check constraints and turned them into maintainable reference dimensions. Made certain all fields reference other tables had foreign key constraints in place to enforce integrity.

Created advanced data warehouse data load scripts utilizing the newer Merge/Output construct for tracking inserted ID’s for dimension and fact relationships. 

Performed typical DBA work such as creating databases, setting security, creating stored procedures and views, backups and restores.
Worked with business analysts and contracted developers to implement new features into application. They defined the customer need; I then reviewed and standardized any existing code, as well as create new code to specifications. Utilized newer SQL constructs such as Merge and Common Table Expressions on a regular basis.

SQL BI Developer

AT&T                                                                                                 May 2010 – Oct 2010      

Completed many development projects converting legacy manual business into automated SQL Server processes. Worked with end users gathering requirements for input / output / and business rules.  Performed logical and physical data modeling. Utilized SSIS and stored procedures to create packages to load data. Created SSRS Reports, including data driven subscription reports for end user to obtain results.  Reports almost always included cascading drilldown parameters for users to isolate the area of data to view.

One solution I created replaced a process requiring 16 hours ad hoc work each week and over 250 Access queries. This solution provided asset allocations for AT&T nationwide and reduced work load to minutes.

Acted as backup DBA - Supported production environment by managing jobs, performance, disk space, DTS package processing, data warehouse loading, etc.

Business Intelligence Developer

Center for Disease Control                                                                   Nov 2009 – May 2010      

Involved in multiple projects simultaneously. My main project has me involved with all phases of the data warehouse development lifecycle. Performed logical and physical modeling of the development environment. Worked closely with Business and Data Analyst’s in design and testing needed to move from Dev to QA to Production. Responsible for the data migration from Mainframe flat files into the SQL Server 2008 Data Warehouse. The Model utilizes multiple fact and dimension tables arranged in a Snowflake Schema that conforms to the 3’rd normal form. We have typical Fact tables connected to 1:M Dimensions, snow flaking to 1:M Dimensions. We also utilize Many to Many relationships with cross reference tables identifying the relationships. Designed two Person (SCD) dimensions; Type 1 with cleansing and uniqueness in mind, Type 2 with preservation of historical values being critical.  Designed and developed SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to transform from Mainframe to Staging, then from Staging to Data Warehouse.  Fully documented Stored Procedures are utilized for source data within each Data Flow or SQL Task.  Data Cleansing, Auditing, and error trapping rollback upon exception are built into the processes. Performance Tuned both the staging and data warehouse environments utilizing query execution plans, data tuning, and profiler to gain optimal performance. 

On another project I utilize SSRS to create parameter driven reports that are called by a Dot Net developed front end.  Some of the features these reports utilize are the use of one/some/all parameter selections, computed and derived columns, colorization of KPI’s, and chaining to detail level reports. Utilize (CTE) Common Table Expressions to traverse personnel hierarchy. Accept XML Constructs as input parameters of SSRS Reports and parse with xquery to convert to a table format.

BI Data Warehouse Architect / DBA

AT&T / Primus                                                                                     Jan 2007 – Nov 2009      

Rapid Application development outside of corporate IT. Our typical delivery time is reduced from 6 months to one month. Ongoing support staff requirements reduced as much as 12 FTE to 1 FTE. One National Support System that I implemented and support by myself, has an equivalent offshore support team of 12.

Design and manage Heterogeneous ETL feeds using SQL Server, Oracle, DB2, and Teradata. Aggregate data feeds into reporting Data Warehouse using SQL Server 2005 stored procedures and SSIS DTS Packages. Expert with SSIS ETL. Ability to debug SSIS Packages and resolve issues at a very granular level. Create complex stored procedures, views, and functions. Optimize environment using Dynamic Management Functions, Tuning Advisor, Execution Plans, and years of experience working with SQL Server! Manage user security / database roles. Design table schema. Create Management Decision Dashboards, displaying Key Performance Indicators derived from the Metrics stored in the Data Warehouse. SSRS with Dundas Charts and Graphs integrated into SharePoint is used for the Dashboards. Expert with SSRS Reports. Act as DBA for development and Data Warehouse environments. Manage Backups, Indexing, Space Requirements, Production Deployment, daily scheduled Jobs. Utilize daily subscriptions to analyze and report on daily Data Load Status, so we are aware of problems before our end users are. Assist Manager by training other developers the established standards.

SQL ETL Developer

Bearingpoint                                                                                       Feb 2006 – Jan 2007      

Lead ETL Developer for Georgia’s Employee Retirement System. Designed import routines for 66 agencies throughout the state. Exception processing was critical to the effort. Interfaced with end users as to progress and customization needs. Trained QA department as well as End User Trainers on functional usage of system.  Optimized Stored Procedures using SQL 2000 Profiler, Execution Plans, and Performance Monitor. Performed Data Partitioning on EMC SAN to spread load across available arrays. Documented process flow in Visio.

Senior SQL DBA / Architect

Cap Gemini / Bell South                                                                      Feb 2005 – Feb 2006      

Performance tuning, Data Modeling, and ETL Data Migration for three simultaneous projects. Establish normalized database schema using SQL Server 2005 Beta 3. Create SSIS (SQL Server Integration Services) packages to load data from various sources such as Oracle, Text, Excel, and SQL Server into a central Data Warehouse.  Utilize SQL Plus and Toad to validate Oracle data mining. ETL Data Migration using DTS and VB Script. Create DTS packages to load all files in a directory in a loop while detecting the correct import type and then passing the file to the appropriate DTS Data Pump. Performance tuning on slow running processes.  Profile all stored procedures created by programmers and drastically reduce processing time. Create complex triggers to accommodate business logic.  Eliminate all table scans, create needed indexes, and re-write queries to use optimized t-sql. Show developers proper usage of advanced joins and cursors.  Data Warehousing (OLAP) with Microsoft Analysis Server and SQL 2005 Business Intelligence workbench. Perform data partitioning for terabyte size databases with tables consisting of more than 200 million rows, to utilize multiple RAID 10 drive arrays on EMC CX700 SAN. Setup disaster recovery and maintenance plans for production environments running on Windows 2003 64 bit Clustered architecture.

Director of Information Technology    

LDC Direct - Smyrna, Georgia                                                            May 2001 – Jan 2005      

Responsible for 24-hour multi-national Information Technology department for a high tech company with annual revenues above 5 Million.  Manage System Engineering and Database Administration staff of eight.  The IT team facilitates the Design and implementation of new features and enhancements to SQL Server 2000 databases supporting web-based products and data terminals which provide access to over 30,000 customers internationally.

RESPONSIBILITIES

·     Lead team in Performance Tuning, Developing, and troubleshooting Microsoft SQL/2000 stored procedures. Identify problem areas utilizing profiler. Update stored procedures using cursors, index hints, or advanced joins where necessary.  Define data partitioning for optimum location / separation of data files and indexes.  Design and build all production SCSI drive arrays.

·     Gather business requirements for system enhancements based on the needs of our customer base, as well as marketing research.  Managed each software release project.  Projects included developments in the areas of Embedded C terminal programming, Microsoft SQL stored procedures and triggers, GUI and Web based end user tools written in VB / C / ASP.

·     Lend hands on experience when tasks escalate beyond normal time frames, or rise to critical status. My SQL programming and Networking skills are very strong.

·     Manage system and database growth planning. Implemented Transactional Replication between two Dell PowerEdge 8450 8 Processor servers. Propose, purchase, and lead all implementation projects.

·     Design and Implement Security, Backup Schedule, Disaster Recovery, and Performance Threshold monitoring procedures.

·     Programming and support for an advanced system monitoring tool in Visual Basic .Net. Tracks performance thresholds, drive space availability, response times, blocking procedures, etc. in real time and sends notifications to appropriate staff when alerts are triggered.

·     Manage all negotiations of vendor contracts and manage vendor resources for support and projects to achieve optimal results.

·     Manage consultant’s scope and time reporting on projects.

·     Design Network Infrastructure (35 Servers) consisting of Windows NT and 2000 servers running on TCP/IP.  Manage Active Directory, DNS, DHCP, WINS.

·    Design and maintain advanced SNMP monitoring of all production servers, processes, and logs.

·     Manage internal and external security access through the Checkpoint Firewall with VPN.

·     Manage all web enhancements and new implementations.  Manage all telecommunication systems including the PBX and six communication servers serving over 35,000 users worldwide.

·     Hire and train all new IT staff members. Train staff from the accounting and technical support departments on application usage.

·     Provide support for company PBX and voicemail.

ACCOMPLISHMENTS

·     Created a secure, stable infrastructure where we were able to maintain for our customers a 99.9% uptime of database and web servers. Assure delivery of contract ional reports to customer base.

·     Improved communications with customer base and resolved issues to achieve a high level of satisfaction.

·     Improved POS Terminal functionality to include swipe activation, real time activation, debit card charge / recharge, and modular communication to 3^rd party carriers.

·     Improved system performance by as much as 70% due to my database upgrade project. Virtually eliminated times of contention where customers would not be able to perform tasks.

o    Migrated to Microsoft SQL 2000.

o    Implemented data partitioning to separate commonly used tables and indexes.

o    Implemented tracking jobs to identify and reschedule jobs that used to cause serious system blocking.

·     Relocation of Production Database, Web, FTP, EDI, and Communication Servers to Co-Location facility E-DeltaCom. 

o    Create Project plan and manage all resources (internal and external) involved in project. 

o    Design new network layout (including TCP/IP, DNS, DHCP, WIN’s) and map in Visio. 

o    Work with Telecom providers to get seven T1 lines moved with minimal downtime.

o    Setup VPN tunnel to remote site as well as VPN connectivity for secure clients.

o    Coordinate moving of DNS and Firewall rules to E-DeltaCom with no loss of service.

·     Re-negotiated co-location contract resulting in a 70k annual reduction in cost.

·     Research and Identify alternative for Local and Long Distance phone carriers.  The results of my implemented changes reduced monthly telecomm expense by $30k.

·     Created Telecommunications infrastructure capable of handling 30,000 international customers on 10 T1/PRI/Frame Relay lines connected to various channel banks, DSP’s, and routers.

·     Created internal monitoring tools using SNMP, VB6, VB.Net, and ASP.Net. These front end tools access my stored procedures to quickly identify the operating conditions of our communication servers and terminals.

Manager of Information Systems    

Jacada Inc - Atlanta, Georgia                                                               Mar 2000 – Apr 2001 

Responsible for 24-hour multi-national operations for high tech company.  Manage staff of three plus various outside consultants. Support over 100 users, local and remote. Planned annual US IT budget of over $1,000,000. Interact with department heads to assess technical needs and priorities of the company.  Manage priorities and lead projects. Reported to the Vice President of IT in Israel.

RESPONSIBILITIES

• Responsible for maintaining a high level of service to all departments.
• Performed capacity planning and infrastructure design.
• Responsible for the procurement of software, hardware, and services.
• I negotiated the contracts with outside vendors and consultants to enhance our small staff.
• Provide remote access to Information Systems for 50 sales and consultants traveling worldwide.
• DBA for the Microsoft SQL 6.5 & 7.0 applications.
• Develop and maintain secure environment.
• Manage Help Desk support.
• Supported the PBX system with international connectivity over ISDN to Israel and our PolyCom teleconferencing system.

ACCOMPLISHMENTS

·         Project Manager for re-implementation of the Onyx CRM Web integration.  Project was on-time and within successfully within scope.

o        Performed time management of all resources needed for the project. 

o        Managed the usage of outside consultants to provide custom Onyx SQL modifications. 

o        Provided frequent progress reports and monitored schedules to keep project on time. 

o        Led debugging / testing team to verify all new program logic functioned as expected. 

o        Developed startup procedures, checklists, and roll back procedures. 

o        Updated stored procedures and created views for custom reporting requirements to assure a timely project finish and reducing consulting costs by 25%.

o        Maintained documentation of processes, and trained staff on usage of the finished product.

·         Redesigned and expanded Windows 2000/NT TCP/IP network infrastructure utilizing Cisco switches and routers.

·         Developed training programs for end users and IS Staff.

Gutter World Inc.; Atlanta, GA                                                    Mar 1998 – Feb 2000                 

Managed, supervised, and trained IT support staff of three utilizing Microsoft NT, MS Exchange Server, MS Internet Information Server. Negotiated and managed vendor contracts to facilitate small staff. Analyzed future capacity needs and prepared IT budget of $250,000 accordingly. Acted as Webmaster by completely re-doing the company web site utilizing FrontPage 2000. Hired full time Webmaster. Led programming team in conversion of a legacy manufacturing system (CTOS) to Magic 4GL GUI Client Server application.

System Manager    

Management of Information Technology; Norcross, GA                      Jun 1997 -- Feb 1998

Lead team of 4 programmers. Managed full life cycle of the software package I created.  Responsible for new developments, testing, conversions, documentation, marketing, sales, deployment, and support. Developed new product and services for internal and Internet usage. Managed NT Network, MS Internet Information Server, MS Proxy Server, as well as Novell Netware LAN with Win 3.x, 95, and 98 workstations.  Achieved MCSE certification, specializing in Microsoft SQL and Internet Information Server.

Information Systems Manager    

San Joaquin County Public Health Services; Stockton, CA                May 1988 – Jun 1997

Managed a staff of seven IT professionals, facilitating both systems and applications. Hired and trained all 7.  Supported over 250 users needs for systems and applications.  Developed and managed an annual IT budget of over $500,000.

RESPONSIBILITIES

·         Gathered business requirements from executive management. 

·         Served as Microsoft SQL DBA utilizing Microsoft SQL 6.0 and 6.5.

·         Manage Projects utilizing consultants for medical clinic, laboratory, and birth registry applications.

·         Administered Microsoft Windows NT and Novel Networks.

·         Managed Help Desk support. 

ACCOMPLISHMENTS

·         Led the grant writing team, which was commissioned to develop a countywide Immunization Registry. Acted as Project Manager and lead developer.

·         Designed network infrastructure of corporate WAN consisting of 5 remote LANs utilizing both Microsoft NT and Novell Netware servers.

·         Managed full life cycle development of new system for budget accounting and purchasing. Product reduced entry time by 50% and created a cost savings of one Full Time employee.

·         Established a company wide training program for using internal applications and Microsoft Office products such as Excel and Word.