SUMMARY:

Confidential is a senior hands - on Database Architect/DBA/Developer with 15 years experience optimizing and developing for MS SQL Server. He is an avid K.I.S.S practitioner, who strives for the development of elegant solutions for complex problems; Confidential is a master at T-SQL coding and the nuances of working with many aspects of the product. Typical projects involve T-SQL development & optimization requiring optimizer insight, database integration of ERP, or CRM products, normalized & dimensional modeling, and report writing using Crystal & SSRS.

TECHNICAL SKILLS:

Databases: MS SQL Server (Versions 7.0, 2000, 2005, 2008 R2, 2012, 2014, Azure) T-SQL, DTS, SSIS, SSRS, SSAS, Clustered Server, Link Server, Replication, Mirroring, MSXML (Xquery, Xpath), SQLMail, MSMQ, MDX, OLEDB) Oracle (Versions 8i, 9i, 10g, PL/SQL, OCI, PRO*C), Sybase (Versions 12.0, 12.5, 15, T-SQL, Replication, IQ), Informix (On-Line, SE, 4GL, Ace, ESQL/C, Redbrick), Teradata, MySQL, PostgreSQL, Ingres, MS Access

Data Modeling: Erwin (V 4.0, 7.2), MS Visio, Power Designer, Oracle Designer, S-Designor

Development/Reporting: Crystal(V8, 9, X, XI, 2008, 2011), SSRS(2005,2008,2012, 2014), XML, HTML, VBScript, Excel VBA, MS Access, MS Outlook Integration(2003,2007,2010), C#, .NET, WTC, Shell Scripting(CSH, Korn, Perl)

Applications: Confidential, SAP, Peoplesoft, Prophix, Xytech, VMware, Citrix, MS Project, Gentran

Operating Systems: Windows (2008, XP, 2003, 2000, NT) UNIX (Solaris, Linux, AIX, HP-UX, AUX)

Tools: PerfMon, Legato, Quest BenchFactory, SQL StressTest, SQL BackTrack, RedGate, TFS

PROFESSIONAL EXPERIENCE:

Principle Database Consultant/Senior DBA

Confidential, Santa Monica, CA

Responsibilities:

• Established a consulting practice concentrating on high-end MS SQL Server contract work in the area of database architecture, database administration, data modeling and T-SQL development.

Sr. DBA & ERP Admin

Confidential

Responsibilities:

• Administered ten servers in support of ERP implementation. Implemented proactive environmental monitoring that checked disk space, CPU utilization, database performance and port responsiveness to ensure 99.9% uptime. Customized Confidential Document Management system and integrated customization to Confidential .
• Implemented and managed a six server Load balanced environment utilizing both VM and physical servers.
• Created multiple custom reports. (MS SQL Server, OpenEdge Progress, Confidential, DocLink)

Sr. Reporting Architect

Confidential

Responsibilities:

• Designed and implemented a Reporting solution that extracted data from ADP, Oracle, Excel, Access into the Reporting Warehouse and produced reports and extracts in variety of format.
• The Reporting Warehouse provided additional value by crating unique analytics that captured complex business analysis.
• The reports were distributed via email, published via Website, and Excel sheets for the different audiences.
• As a second phase data was extracted into tableau to support capable users with sophisticated analysis needs of large data sets. (MS SQL Server, Oracle 11i, Tableau, IIS, SSRS, SSIS)

Senior Database Consultant

Confidential

Responsibilities:

• Designed and implemented a Data Warehouse and Reporting database for the US pharmaceutical trade group.
• The data warehouse was built to house data extracted out of Confidential and feed Prophix cubes budgeting and financial reporting needs.
• Work involves complete automation of the ETL processes; including the extraction of all relevant data from Confidential in a snapshot; data cleansing and validation; data transformation to support Phropix cubes and other reports; and loading of data. Constructed with multiple cubes to support multiple views of the data and various analytical reports. (MS SQL Server, Confidential, Prophix, Crystal, SSIS)

Project Manager & DBA

Confidential

Responsibilities:

• ERP upgrade of Confidential 7.4 GL, AR, AP & Purchasing for a leading Orthodontic service provider. Work included a comprehensive analysis of the state of the Confidential implementation; Reverse engineering of extensive undocumented customization and recreating functionality in the latest version.
• Recreated database integration points to a number of in house systems as well as to the different banks.
• Customized AP to fit requirements for multiple bank accounts with diverse MICR formats in a single check run. The volume of daily payments necessitated a full automation of bank.
• Project extended to implementation of Procurement.
• The Work involved extensive integration with internal systems and vendors’ EDI. The implementation required extensive customization to fit the company’s consolidated buying business model. (SQL, Sterling EDI, MSXML, Confidential, Crystal)

Data conversion Architect

Confidential

Responsibilities:

• Data Conversion Architecture, Application Implementation, Data Modeling, reporting Architecture, Lead DBA and Business Analysis on a large implementation of the studio’s asset management system.
• Brought project from inception to successful completion. The new system manages all studios’ assets and incorporated diverse technologies and data from all studios’ major systems.
• Projects included asset configuration, ordering, multi-warehouse management (bar-coding, scanning, picking, packing, shipping), asset tracking, pricing, asset categorization, interfaces to financial and royalty systems.
• Created data mapping, cleanup, conversion rules and interface design for smooth data transition.
• Created reporting structures for Business Objects and Replication schema for Reporting server.
• Project extended to integration of data from a newly merged organization and external post-production labs. The required complex analysis and data mapping tested the original design, which was proven as modular and flexible. (Xytech, Excel, Oracle, FoxPro, FileMakerPro, SQL Server, Crystal, BO universe)

Sr. DBA & ETL Architect

Confidential

Responsibilities:

• ETL consulting from MS SQL Data Warehouse to MortgageServ 80-char format for a mortgage bank.
• Work involved analysis and data modeling of target record styles, developed SPs to convert data from source to target.
• Created a generic toolkit for conversion of relational data to mainframe format. (MS SQL Server)

Database Conversion Engineer

Confidential

Responsibilities:

• Database conversion from Oracle to MS SQL and Sybase for a Change-Management software company. Designed a seamless conversion with minimal impact on client code.
• Converted database schema and stored procedures to exact SQL Server equivalent code, and with minor changes to Sybase. (MS SQL, Oracle, Sybase)

Sr. Database Consultant

Confidential

Responsibilities:

• Data modeling, database programming and performance optimization of a portfolio risk analysis tool for an Investment house.
• T-SQL development of investment risk analysis indices algorithms and complex portfolio management utilities.
• Created ETL programs to capture/clean/transform financial data. (MS SQL Server)

Database Architect

Confidential

Responsibilities:

• Database architecture and programming for a leading provider of Customer Experience Management.
• Provided impact analysis and converted to SQL Active/Passive Cluster.
• Evaluated ASP upload and MSMQ performance.
• Created transaction-less framework and converted all SPs to use framework. (MS SQL Server)

Sr. Database Engineer

Confidential

Responsibilities:

• Data modeling and stored procedures development for a leading Energy Management Software company.
• Designed a new strategy for data caching for optimized access. Redeveloped most stored procedures for a major release.
• Mentored programmers in optimized stored procedures development. (Oracle, PL/SQL)

Lead DBA

Confidential

Responsibilities:

• MS SQL Server and Windows OS server upgrades of all major Newspaper systems.
• Established testing, backup and impact analysis process for 30 SQL servers’ seamless upgrades. Identified T-SQL code that may break as a result of upgrade and fix issues.
• Performed off-hours server backups and upgrades. (MS SQL Server)

Chief Technical (Consultant)

Confidential

Responsibilities:

• Database architecture and CTO for a leading provider of entertainment news, info. and ticketing.
• Led the restructuring of the IT department. Led a major website redesign.
• Established hardware and software architecture; including load balancing, content distribution, Ads serving, traffic tracking, and video production/encoding/streaming.
• Created an enterprise wide database that captured data across from all sites and enabled easy publication of dynamic data.
• The database enabled company expansion through the creation of new sites for delivering movie/celebrity/TV/music information. (MS SQL Server, Oracle)

Vice President of Engineering (Consultant)

Confidential

Responsibilities:

• Management and technical consulting for a start-up, who is now the world leader in tier-1 convergent OSS Mediation.
• Work included recruiting engineers, contributing to business plan, helping secure first round VC financing, establish technology direction & architecture.
• The application sniffed Internet traffic and reconstructed HTML/UDP/FTP/DHTML traffic information from IP packets.
• The application sniffed Internet traffic and reconstructed HTML, UDP, FTP, DHTML from IP packets.
• The application architecture, which allowed for infinite scalability, proved invaluable to the company’s growth. (Oracle, MS SQL Server)

Senior Database Architect / Director of Strategic Development

Confidential, Santa Monica, CA

Responsibilities:

• Hands-on management of a fast growing development division, tripling in size. Led the development of a decision support suite of applications for bank profitability mgmt. Established development plans, led development tools selection, and established software releases. (MS Visual C++, OLE, ActiveX and Oracle 8)
• Incorporated SCRUM & Agile development methodologies; including detail design documents, design sessions, Booch notation OO design, ER diagrams, and code reviews. Managed the full development life cycle of multiple product suite releases with perfect on-time delivery record.
• Successfully managed a large team of talented developers in the redesign of TSER UI. The new UI was highly praised for its improved usability and interoperability to 3rd party tools.
• Established an efficient and thorough screening process that identified candidates of the highest caliber with minimal impact on staff. TSC became a highly thought-after workplace for developers

Chief Architect / Lead DBA

Confidential, Irvine, CA

Responsibilities:

• Research of technical trends and their applicability to Confidential .
• Provided expert Sybase and MS SQL Server mentoring to development and a technical “sounding board” to executive management.
• Responsible for creation of software development standards and guidelines for all development units.
• Technical guru for 120 system engineers and consultants on hundreds of engagements.
• Created sizing tools that produced accurate system requirements based on simple financial questions.
• Managed Rapid development of new features, used to demo features prior to official release. (C, SQL)
• Designed and developed financial software for windows using a custom developed GUI to communicate to MS SQL Server that was the first in its market. Developed major parts of Confidential Enterprise system manager, Accounts Receivable, Accounts Payable and General Ledger modules. ( Confidential Workbench, SQL Server)