SUMMARY:

Over 25 years of experience as both a finance and technology professional working in over a dozen industries, in addition to state and Federal government. My primary technical focus has been on data movement, storage, design and reporting, including working on the installation or enhancement of 10+ financial/accounting systems. He has also developed extensively on front - end and middle-tiers, including user interfaces, primarily in .NET. As a developer and SME, I work extensively with stakeholders and management to hone requirements to complete specifications documents and carry them through to deployment.

SKILL:

• Database architecture & design
• Data warehouse design and ETL construction
• Database application development
• Performance tuning (Indexing, horizontal partitioning, load balancing)
• Database administration / production support (SQL Server 2000/2005/2008 R2)
• Integration Services (SQL Server 2005/2008R2)
• ETL
• DTS, SSIS, SSRS
• Reporting and Analysis
• VB.NET, ASP.NET
• Crystal Enterprise administration and report development
• Database Modeling
• Advanced complex stored procedures (SQL Server 2000/2005/2008 R2, Oracle and MySQL)
• Creating and scheduling jobs (SQL Server 2000/2005/2008 R2, Unix/Linux)
• Application Integration (SQL Server 2000/2005/2008 R2, Oracle, MySQL)
• Design and construction of test harnesses and utility applications centered on MS Office automation

TECHNICAL SKILLS:

Key Technologies: MSSQL, MySQL, Oracle, PostgreSQL, MS Access, .NET (VB, C#), HTML, CSS, Javascript, AngularJS, Java, Ruby, VBA, VB6, Crystal Reports, JasperReports.

CAREER HISTORY:

Confidential, Washington, DC

Sr. DBA / Database Engineer

Responsibilities:

• Lead role on data architecture
• Set standards for database server configuration and backups / failover
• Consolidate data from all relevant data sources for OMB Reporting
• Construct ETLs for automating data consolidation
• Provide data to Data Analysts for any given ad hoc request for data
• Design and develop databases and database objects
• Design, test and deploy code for Datapoint extensions
• Monitor and administer MAX MySQL servers for development, testing, staging and production
• Work with business analysts and users to determine ideal database structures
• Work with and support Data Analysts on all data issues
• Create and maintain database standards
• Automated retrieval of Integrated Data Collections, reducing time spent from 3 days to 3 hours
• Consolidated dozens of disparate data sources at OMB to a single, secured server
• Created numerous reports, many of them ad hoc, to ensure all policy deadlines and requirements are met

Confidential, Reston, VA

Senior Database and Application Architect

Responsibilities:

• Customized web and client/server solutions to government, non-profit and mid-market clients
• Lead developer on customized applications and architect for numerous enterprise data solutions on SQL Server and Oracle. Data warehouse architect and ETL developer additionally leveraging SQL and shell scripting
• Developed a government solution that combined 17 separate Access applications into a single .NET application.
• Worked as DBA and database architect on SQL Server 2008R2/2005 (including SSIS development), SQL Server 2000, SQL Server 7, Oracle 9i, Oracle 10g and MySQL.
• Advanced programmer in VB.NET, VBA (Access/Excel/Word) and VB6. Crystal developer for government and various other organizations. Excellent communication and organizational skills proven with each client and project
• Architect and developer of automated revenue and payment process for web advertising corporation
• Hands-on development and management of numerous projects running concurrently, meeting all deadlines for each project and effectively managing all development resources, even cross-department
• Primary contact on all projects to both business customers and IT management
• For Fortune 500 Company, developed complex SSIS/DTS packages for ETL processing from over 30 different source systems representing five different source types and database platforms. Leveraged SSIS dynamic configuration settings (database and XML), global variables, and VB.NET scripting to build IS packages that were reconfigurable at run-time through various methods, including via SQL
• Designed and developed data warehouse solutions for several clients
• Received corporate from Fortune 500 company for business process automation project (as a consultant) using Crystal Reports and SQL Server Database architect, developer and DBA for multi-million-dollar Inventory system for Fortune 500 company
• Design, development and deployment of data warehouse and Enterprise Portal for internal reporting of international organization
• Designed and Developed Project Management application for large state agency
• Developed .NET and SQL programming tools to facilitate rapid development

Confidential, Tampa, FL

Director of Information Technology/ Sr. Business Analyst

Responsibilities:

• Managed all computer systems changes and network reconfigurations for the centralization of accounting/ treasury functions of 5 subsidiaries
• Developed Access applications for user base ranging from 5 to 150
• From the ground up, built multi-locational client/server network and locational P2P networks
• Restructured IT systems and reports that uncovered hidden costs, saving an estimated $75,000 per year

Confidential, St. Petersburg, FL

International Director - Financial Information Systems

Responsibilities:

• Managed reporting operations, reporting directly to the president of the international divisions of a $300 Million company specializing in point-of- sale marketing. Conducted system audits for compliance as well as monthly, quarterly and yearly report compilations. Additional responsibility for statutory statements and reporting from foreign countries, managing connectivity and daily data flow
• Directed IT personnel in foreign locations of Mexico City, London and Tokyo with minimal travel. Developed numerous Access applications to be used at the various sites

Confidential, Bakersfield, CA

International Director

Responsibilities:

• Development of first GUI reporting system with drill-down capabilities and user-enabled ad hoc report writing
• Directed staff in the movement and re-engineering of the systems involved with the international treasury process from Tulsa to Bakersfield, reducing treasury IT staff from five to one without any interruption in service and without a single error, saving approximately $500,000 in payroll & overhead costs per year
• Co-lead on an information systems audit of a joint venture partner in Doha, Qatar, in the process uncovering data errors that resulted in a significant payout reduction
• Developed an automated method of tracking rotating expatriate personnel for the Siberian operation that was implemented and resulted in payroll savings (Russian taxes) of $30,000/month
• Received Occidental’s President’s for unprecedented savings in treasury department systems move

Russian Information Technology Manager

Confidential

Responsibilities:

• Established network infrastructure for two Siberian operations and for the primary offices in Confidential
• Engaged the use of satellite communications to reduce telecom expenses by over 50%

IT Manager

Confidential

Responsibilities:

• Deployed for two months to Damascus, Syria, in the absence of permanently assigned technology expat, to review infrastructure, make system upgrades and establish technology plan for the following two years
• Trimmed two days from the monthly closing process by negotiating technology enhancements, saving approximately $100,000/year
• Developed Access applications for tracking various detailed information for international sites
• Developed data query sub-applications for financial staff, eliminating inefficiencies that equated to savings of $45,000/year
• Built and maintained a database to track each piece of leased equipment for the entire chemical division, allowing for verification of every asset using any one or more parameters.
• Supported sales, logistics, finance, accounting and executive departments on both hardware and software. Included Novell, Lotus and various proprietary legacy systems based on AS/400