Education
Purdue University, B.S. Engineering Technology, 1998
Technical Skills Overview
• Application Servers: Intershop 3.0, Broadvision 4.5, ATG Dynamo 4.5, Cold Fusion 5.0
• Reporting Servers: SSRS 2005, 2008 R2, Crystal 8.5, Actuate 8
• Databases: SQL Server 2000,2005,2008 r2,Oracle 8i
• Analytic Apps: E.piphany Analytic Platform 5.0
• ERP Applications: Lawson Financials, Deltek Vision
• HR/Payroll Systems: Workday, Ceridian, Timestar
• Intelligence: SSAS 2008R2,Apache Hadoop Stack
• Languages: C#, Java, VBA
Professional Experience
Gensler Senior Associate 6/2001 to present
Lead Database Administrator 2009 to present
• Analyzed database server performance using PSSDIAG, PAL and the RML utility tool set.
• Enhanced query performance by implementing indexes, statistics and by analyzing query plans.
• Performed database support and maintenance on over 60 databases used by our internal applications.
• Provided 24x7 support for database processes and for our international user community.
• Performance tuned tempdb configuration for better SQL server performance.
• Worked with hardware vendors (NetApp, FusionIO) to create solutions for ultimate performance.
• Consulted Microsoft Engineers to create scalable solutions for long term growth and planning.
• Created virtual machines for testing and planning of SQL Server projects.
• Specified new hardware requirements for production servers going off lease.
• Implemented Log shipping with Red Gate’s SQL Backup to ensure hardware redundancy of critical databases.
• Installed and Configured Idera’s SQL Diagnostic Manager to monitor and report on production database servers.
• Installed and supported SQL Server versions 2000, 2005, 2008, 2008R2 which were used by 100+ applications.
• Developed, tested and implemented database DR plans to ensure preparedness for business continuity plans.
• Managed and performed database server migrations for HR, Payroll and Financial Systems.
• Coordinated with application owner’s and business analysts on data issues.
• Worked with developers to create SQL solutions to ensure proper interaction with the database servers.
• Performance tuned badly behaving SQL Queries to ensure critical processes were not impacted.
• Created automated processes via SSIS to provide 3rd party vendor files to ensure an automated, low risk process.
Business Intelligence Architect 2002 to present
• Installed, maintained SQL Server Analysis Services on production and development servers.
• Created SQL Server Integration Services projects to populate data warehouse and process SSAS Cubes.
• Installed and configured Hadoop and developed a MapReduce application to analyze web server logs.
• Lead multi-million dollar project involving a complete re-write of a legacy financial reporting on time and budget.
• Designed reporting architecture that led to an 80% increase in productivity of report development
• Managed team of report writers who 100+ custom reports for use with the Deltek Vision accounting system.
• Designed multi-currency, multi-company reporting framework that enabled reports to be run in any currency.
• Created international payroll programs for Tokyo and China based on local employment rules and regulations.
• Worked financial analysts across the globe to ensure currency needs were met and to mitigate risk.
• Created database processes which enabled the company to successfully close accounting periods.
• Installed and configured SSRS in multi-server environment to ensure maximum performance.
• Created custom logging framework for use with SSRS to help make better business decisions with usage metrics.
• Lead code reviews and acted as gatekeeper for our subversion repository to maintain code consistency.
• Created an intelligent time sensitive repopulation process of custom reporting data warehouse.
• Installed and maintained both Crystal reporting servers and Actuate reporting servers.
• Created a custom UI that called reports from outside of our Accounting system using Actuate’s Web Service.
• Authored reports in Crystal 8.5 and Actuate 8.
Technical Lead, Lawson ERP Implementation 05/2001 to 07/2002
• Lead multi-million dollar ERP implementation as technical lead, database and systems administrator.
• Developed framework, architecture and code for AP, AR, HR and BR data conversion.
• Managed design, development and implementation of interfaces to Bank of America.
• Installed and configured Lawson’s XML Portal for use with PSA and Lawson Financials.
• Created Perl scripts to capture and report on data from user logs, transactions logs, database logs and job logs.
• Created and managed development process for a proprietary reporting engine.
• Created Crystal Reports using Crystal Enterprise Server 8.5 technology.
• Created Perl scripts to monitor Lawson services, mail services and contacted pagers for notification on issues.
• Managed Oracle 7 database used by CFMS, our legacy system.
Fort Point Partners Consultant 2/2000 – 3/2001
Bluelight.com (through Fort Point Partners) 12/00 – 3/01
• Participated as a Senior DBA in Bluelight’s implementation of E.piphany’s CRM Platform.
• Involved in system architecture design and integration of software.
• Installed and designed an Oracle 8i and SQL Server 7.0 database for use with E.piphany's Analytic Server.
• Installed, configured and deployed E.piphany's Analytic Server and Campaign Management for E-mail.
Fortpoint.com (Internal Project) 09/2000 – 12/2000
• Involved as the lead DBA, constructed the back end of Fort Point’s sand box environment for innovation projects.
• Performed systems administration by installing PERL modules,creating ATG instances and Oracle 8i users.
• Provided DBA services by installing, designing, managing and maintaining Oracle 8i databases for ATG and BEA.
• Developed an ETL program in PERL that parsed web server logs and stored it in a data warehouse.
IdeaForest.com (through Fort Point Partners) 02/2000 – 09/2000
• Consulted IdeaForest, the leading online community for crafts, on integration issues with Smith Gardner’s MACS. Involved as a DBA, java developer and systems integrator on the project.
• Developed inventory application using Java and XML that retrieved inventory levels from Mail Order Catalog System (MACS) and updated ATG sku levels in an Oracle 8i database.
• Used Simple API for XML(SAX) to parse XML documents received from Web Order Gateway with Java.
• Developed a search engine in Java to search for skus, products and categories in ATG.
• Created stored procedures to validate data in a production environment.
• Documented code following JavaDoc standards, created object interaction and class diagrams using UML.
• Used Rational Clear Case to manage Java code base.
• Developed backup scripts and nightly jobs for IdeaForest.com development machines.
• Wrote proposals, work estimates, functionality specifications and technical turnover documents.
Myteam.com Senior Developer 1/1999 – 2/2000
• Wrote cross platform compatible Dynamic HTML that integrated with Broadvision's front end.
• Integrated PERL scripts that handled data submitted through html forms.
• Developed a Java Ticker that read information from a text file for sponsor advertising.
• Designed and developed highlight capsules that pulled dynamic content from Broadvision's content management system based on a user's profile.
• Hand coded thousands of HTML pages for use across Myteam's family of networks.
• Implemented Cascading Style Sheets to dynamically control fonts and colors across Myteam's family of networks.
• Implemented Broadvision's JavaScript interfaces to communicate with Oracle, Broadvision's content management system and with various Broadvision objects.
• Created Broadvision session objects for further personalization on Myteam.com web sites.
• Implemented an online web cast for the Little League World Series in August 1999.
Isys Global Internet Solutions Consultant 5/1998 to 12/1998
• Implemented Active X Agent technology for personalized help.
• Developed a storefront using Intershop 3.0 and cross platform compatible Dynamic HTML for various clients.
• Worked closely with designers to provide technical integration analysis.
• Hand coded HTML and integrated Photoshop layouts.
