Sql Software

DANIEL S.OTTO

Cell: 715-***-**** ***********@*******.***

SKILL SUMMARY:

An accomplished and well-rounded Information Technology professional with excellent technical, problem-solving and leadership skills. Vast experience in database systems, with focus on Microsoft SQL Server. Able to lead and implement new technologies and best practices through proven communication, planning and technical skills.

QUALIFICATION AND TECHNOLOGY SUMMARY:

* Database Experience: 7+ years MS SQL Administration with experience with MySQL and Oracle RDBMS

* Programming experience: SQL, TSQL, PLSQL, DTS, SSIS, SSRS, Batch scripting, HTML/DHTML, XML, Visual Basic, DOS, Pascal and Basic and limited experience with Unix, JAVA, PHP and Web Services

* Extensive use of MS SQL technologies including partitioning, replication, stored procedures, functions, triggers, SQL Profiler, security, linked servers, service broker, reporting services, change data capture and more

* Experience with developing, maintaining and analyzing audit trails and logs for investigation and troubleshooting

* Extensive computer hardware, server and networking knowledge (SAN, VPN, LAN/WAN, DHCP, DNS, TCP/IP)

* Operating Systems: MS Windows 2008, 2003, XP, 2000, NT, 98, 95, 3.11, DOS and Mac OS

* Application software: MS SQL, MS Visual Studio .NET, Team Foundation Server, MS Office, MS Outlook, Siebel 6 and 7, PVCS, IIS, Apache, Toad, Notes and many others

* Experience with creating and designing system architecture, data flow and entity relationship diagrams and more

PROFESSIONAL EXPERIENCE:

Eastbay/Footlocker.com December 2008 to Present

Database Administrator, IT Development Department at Eastbay

* Managed 20+ SQL servers in all aspects of administration including design, optimization, best practices, security, troubleshooting, backup/restore, disaster/recovery, maintenance plans, outage windows and more

* Developed an SSIS template using environmental variables for task logging and centralized configuration

* Stabilized SQL server and processes and developed specific strategies for OLAP and OLTP environments

* Designed and created automated reports for all SQL servers systems and general database information

* Upgraded and transferred SQL servers and databases to SQL 2008, SQL clusters and new hardware (SAN) systems

* Started Service Broker implementation in conjunction with MS Biztalk implementation

* Installed and developed and trained personnel for several SQL Reporting Services instances

* Maximized high availability through several SQL clusters from 2 to 6 nodes and table partitioning

* Developed automated backups, index and statistic monitoring and optimization and related reports

* Performed daily maintenance, troubleshooting connectivity and performance issues via SQL Profiler and more

* Created ETL connections to a variety of data sources using SSIS or custom T-SQL stored procedures

* Lead team in SQL best practices, data and process design, standardization, daily operations and SDLC

* Created complex stored procedures and SQL processes to handle specific legacy and new processes

USA Datanet September 2004 to December 2008

Database Administrator, IT Department reporting to the Chief Financial Officer

* Managed and maintained multiple MS SQL servers and worked with other groups to resolve issues

* Utilized a wide variety of data sources such as: MSSQL, MySQL, Oracle, MS Access, EMI, flat files and more

* Managed and participated in database design, recovery, storage, backup, archiving and disaster recover planning

* Developed and implemented reports and processes for rating and profitability of over 3 million daily records

* Implemented several warning systems and audit logs for server and database processes

* Optimized server utilization and planning through database optimizations, strategies and task timings

* Managed and developed the carrier access billing project which earned USA Datanet $650K and $12K monthly

* Designed and maintained Switch, Carrier and Report Data Warehouses in MSSQL 2000

* Developed complex processes for data migration, mediation, importation, exportation and reconciliation

* Crafted entire reconciliation process for all generated and billed records and presented to annual audit companies

* Implemented and developed a web based, company wide reporting platform via SQL Reporting Services

* Provided visibility and analysis though automated processes and Ad hoc queries with all major databases including: billing, switch, customer, provisioning, carrier and mediation

* Constructed, tested and implemented many tools and utilities utilizing a variety of languages and systems

* Lead a company wide reporting project to further centralize all reporting needs via the use of the latest technology

* Coordinated data and processes with several functional groups ensuring client needs are met and exceeded

* Participated and contributed to mission critical projects allowing USA Datanet to remain successful in the highly competitive and evolving telecommunications market

Abbott Laboratories March 2000 to August 2004

Systems Analyst/Administrator, Global Technology Solutions, January 2002 to August 2004

* Lead projects for successful deployment of Siebel software throughout the system development life cycle

* Administrator of an ePharma Sales Force Automation application SDLC with validation, testing, code promotion, quality control and Federal Regulations (21CFR Part 11)

* Managed Production releases, Service Requests, Server installations, upgrades and performance optimizations

* Developed ad hoc SQL queries and Access Databases for legacy data across multiple systems

* Promoted and followed QA procedure for code promotion and migration of upgrade components

* Troubleshot system processes, Abbott Dial-up, Abbott VPN, servers, laptop hardware and more

* Provided 24/7 server support as well as handled level III issues and other critical system wide issues

* Coordinated and executed development and production tasks for the Development, QA and production environments

* Conducted hardware and software builds for Home Office, Laptop and Hand-Held installations

* Managed server deployment activities for the rollout of over 4000 connected and remote users

* Assured coherence to Good Manufacturing Practices (GMP) and Federal Regulations

* Conducted configuration, issue resolution, investigation, user acceptance testing and documentation

Associate Engineer, Abbott Diagnostic Division, Validation and Verification, May 2001 to January 2002

* Validated Architect software through requirement testing in the development phase of the Architect SDLC

* Owned test plans and created and updated software requirements including corresponding requirement items

* Wrote and debugged test cases for manual, simulated and test case automation (Silk Test) execution

* Formally executed test cases for software increments, software builds and software for release

Validation Product Remediation Scientist, Abbott Diagnostic Division, March 2000 to May 2001

* Managed five individuals in all validation activities, and Initiator of several Test Method validations for product remediation across three Abbott Platforms: IMx / AxSYM and Architect

* Assembled and chaired Cross Functional Teams (Business Team, Validation Quality Groups, Quality, Quintiles Consulting & others)

* Extensively used Microsoft Application software for the production of reports, presentations and statistics

Illinois State Police

Forensic Scientist, Forensic Science Center at Chicago April 1995 to March 2000

* Database Administrator of the local FBI Combined DNA Indexing System (CODIS): bulk uploads, local, state and national searches, server and client software updates, user maintenance, troubleshooting and maintained Macintosh and PC workstations

* Administered Windows NT CODIS server and created plans for a PC/Mac LAN

* Designed and constructed a complete LAN/WAN via T1 to replace the outdated STU modem

* Court qualified in expert witness testimony concerning reports of forensic biology, RFLP and STR DNA analysis

EDUCATION:

University of Maryland, Baltimore County Illinois College, Jacksonville, Illinois

Masters of Science Degree Bachelor of Science Degree

Specialization: Information Systems Specialization: Double major: Chemistry and Biology

Graduated: May 2003 with Honors Graduated: May 1994 with Honors

GPA: 3.9/4.0 GPA: 3.783/4.0 Deans List, National Deans List

ACTIVITIES AND HONORS:

* AIM Executive Excellence Award recipient 2003 and Star Award recipient 2004

* Presidents Award recipient 2007 – USA Datanet

* Eagle Scout, Troop 347, Fall 1989

Contact this candidate