Data Developer
Resume:
Dan Swank
Summary
A very experienced Data Architect and BI Developer with a proven track
record of designing, developing and implementing quality Business
Intelligence solutions to meet business requirements.
- Completed numerous full life cycle BI implementations: analysis, design,
develop, deploy and support.
- Particularly strong in data architecture, dimensional modeling and
database design.
- Very strong with PL/SQL for creating ETL processes, data cubes and
associated development.
- Highly experienced creating Business Objects universes and reports.
- Extensive experience with BI Operations - data load management
(full/delta), performance tuning.
- Career-long pride in developing solutions that are reliable, perform
well, and are scalable.
Technical Skills
Oracle through 11g
- Creation of data objects
- PL/SQL coding and code tuning
- Exploration of Oracle data dictionaries
- Capturing metadata from source procedures
- Isolating expensive SQL
Business Objects
- Complex Universe creation
- Complex Webi report creation
- Row and column level security
Informatica
- Source to target mappings
- Basic transformations
- Related shell scripting
Analysis/Design/Documentation
- Functional and Technical Specifications
- Database Design Documents
- Database Creation Artifact Documentation
- Test Plans and Procedures
- Training/User Documentation
Developer Management
- Develop and manage Project Plans
- System Development Life Cycle methodologies
- Ongoing measurement of quality
- Working with and managing off-shore teams
- Dependency and critical path analysis
SQL Server through 2005
- T-SQL
- SSIS
Professional Experience
General Dynamics, San Diego, CA 01/2008 - 09/2010
Consultant, providing Data Architect and BI Developer skills in support of
data warehouse development and business intelligence projects at NAVAIR.
- Collected functional requirements and wrote requirements documents.
- Analyzed the data in source systems (MTO, WDS, Maint. Repair & Overhaul,
and financial systems).
- Architected the database solutions, wrote design documents and built the
databases.
- Populated the tables and developed prototypes to prove end-to-end
correctness of the solutions.
- Created source to target mappings for the Informatica team.
- Created the more challenging Business Objects universes and reports.
- Ensured compliance of universe and reporting development with standards.
- Supported team efforts during testing, training and deployment.
Specific projects included the following:
Earned Value Management - Designed developed and deployed a system
combining planning, production and financial data to estimate earned value
and cost at completion. Cost was in both man-hours and dollars with drill-
down to detailed data.
Component Delay - Designed, developed and deployed a system to report delay
of work in process, with and without various kinds of component delay.
Direct Material Expense History - Automated the process of loading planned
standard costs and actual costs of key components into the datamarts.
Corporate Reporting Database - Created a near real-time database of key
tables replicated from multiple productions systems.
Conversion of Aircraft and Engine Metrics from Cold Fusion to Business
Objects - Created a universe consisting of tables used by the Cold Fusion
reports and led the creation of reports from the Business Objects universe.
Ad Hoc Corporate Reporting Database - Supported ETL developers with the
creation of a dozen dimensional datamarts corresponding to a dozen business
areas with data from eight production systems.
Expensive SQL - Created a system that monitored the Oracle SQL cache and
logged expensive SQL created dynamically by Business Objects reports.
Intuit, San Diego, CA 08/2007 - 12/2007
Business Intelligence Developer Consultant
- Evolved Intuit's text analytics prototype into a system production ready
for the coming tax season.
- Enabled input and analysis of semi-structured data from survey, feedback
forms and the call center.
- Converted ETL from anonymous SQL blocks to stored procedures.
- Retrofitted scripts and stored procedures with process logging, timings
and email notifications.
- Remedied performance problems brought to light through the process
timings.
- Minimized operator intervention through logic to insert only data not
already inserted.
- Wrote system and operator documentation.
First American, Santa Ana, CA 11/2004 - 08/2007
BI Data Architect Consultant - 01/2006 - 08/2007
- Designed a data warehouse consisting of data from twelve First American
companies.
- Designed and developed the enterprise data warehouse using Erwin.
- Designed the ETL processes and prototyped them in Informatica.
- Developed Informatica components to support loads on a daily, hourly or
near real-time basis.
- Implemented data structures to accommodate cube creation and reporting
with Micro Strategy.
- Developed the overall strategy for on-boarding data from the dozen First
American companies.
Senior DBA Consultant - 11/2004 - 01/2006
- Developed database coding standards and techniques.
- Trained and managed DBA's and database developers located in both the
U.S. and in India.
- Designed and coded high speed, searching and matching components in
PL/SQL.
CapitalOne Auto Finance, Foothill Ranch, CA 11/2002 - 11/2004
BI Data Warehouse Designer/Developer Consultant
- Designed and developed a BI data warehouse using ER Studio, Rapid SQL
and DBArtisan.
- Built the database servers, installed the software and put the servers
into service.
- Designed ETL processes and developed them using PL/SQL.
- Implemented data structuring techniques to overcome limits of Business
Objects.
- Created the Business Objects universes.
- Implemented procedures for loading data multiple times per day, while
retaining consistent reports.
- Completed two major development phases from design through deployment.
- Wrote technical documentation.
Performance Tuning
- Inserted timing traces in nightly batch processes of the production
system.
- Isolated which processes were long-running and performed analysis and
prototyping.
- Improved the performance of the nightly batch, to run in a small
fraction of its former time.
Genomatica, La Jolla, CA 5/2002 - 11/2002
Oracle Development DBA Consultant
- Developed database routines for predictive gene modeling through
simulation.
- Wrote stored procedures, packages and triggers for the database access
layer of the application.
- Implemented replication of molecular models between customer databases.
Ask Jeeves, Los Angeles, CA 7/2001 - 4/2002
Senior Programmer Consultant
- Designed and developed the Analytics Datamart for the JeevesOne search
engine.
- Gathered requirements, wrote specifications and gained management
approvals.
- Utilized XML to separate SQL statements from the data loading engine.
- Developed data migration scripts in the form of XML configuration files.
- Wrote database documentation and provided technical input for training
materials.
V2Commerce, San Diego, CA 10/2000 - 6/2001
Database Architect and DBA Consultant
- Performed all DBA activities for Oracle development and production
environments.
- Developed JSP applications for administrative tasks and performance
monitoring.
- Supported Servlet programmers by prototyping SQL procedures as Java JSP
pages.
- Led the coding of the database layer, in the Java web application.
- Wrote transaction logging, backup and recovery procedures for all
systems.
- Wrote backup and failover scripts and maintained 24/7 availability.
Education
- CompTIA Security+ Certification
- Oracle 8 DBA Certificate
- PowerBuilder Certificate
- BA in Business Admin., University of Michigan
Security Clearance - Secret.
Contact this candidate