SQL Developer/ Business Intelligence

Dave Dana

***** ********** ***** 562-***-**** (cell)

La Mirada, CA 90638 ************@*****.*** 562-***-**** (home)

SQL Developer Business Intelligence

Reporting: Developed at an enterprise level for a national financial organization.

o

ETL: Imported large datasets nightly from multiple transactional systems into a central repository.

o

Data Warehouse: Performed all development and most dba-related tasks.

o

Skills: Implemented T-SQL (SS2005/2008R2), SSIS, SSRS, and limited database administration and C#.

o

Work History: Provided previous organization with 17 years of dedicated service.

o

MSIT, University of California, Fullerton MBA, University of Phoenix BA, University of California, Irvine

PROFESSIONAL EXPERIENCE

Investor’s Business Daily Los Angeles, CA, 1998 – 2015

SQL Developer/ Business Intelligence 2006 – 2015

ACCOMPLISHMENTS

Saved thousands of dollars in labor costs by taking over all duties related to development of data warehouse

o

including reporting and ETL.

o Eliminated hundreds of hours of manual effort through creative uses of SSRS to automate reporting.

o Simplified reporting on enterprise level by providing a centralized hub for broad scope of requests.

o Improved requirements gathering process through use of communication skills and business background.

o Increased efficiency of email marketing program by enabling business users to create and launch campaigns.

Reporting

• Designed hundreds of analytical and operational reports for use across multiple departments.

• Used enhanced delivery methods to increase impact of reporting.

• Employed creative uses of SSRS tools to meet unique requirements.

• Managed user access permissions.

ETL

• Processed data sets daily from a group of large, internal transactional systems and third parties.

• Incorporated range of data source types including SQL, Oracle, Access, and flat files.

• Built automated processes to exchange data via SFTP with external partners.

T-SQL

• Produced stored procedures and ad hoc queries extensively in support of reporting, ETL, and

business operations.

• Integrated diverse range of source data into standardized outputs.

• Optimized code to work with large tables (exceeding one billion rows).

Database Administration

• Enhanced data processing through use of Profiler, execution plans, and indexing.

• Coordinated server maintenance including backups, indexes, and statistics.

• Employed additional features including triggers, constraints, views, functions, and linked servers.

• Used SQL Server Agent jobs extensively in support of ETL, data aggregation, and server maintenance.

• Managed security including role- and user-level permissions.

Operational Support

• Created back-end data flow for multi-step program involving several departments. Touch points included

customers, service-providers, and business analysts.

• Developed end-to-end processes (from market segmentation to list delivery) to support the company’s

primary email marketing campaigns.

Circulation Supervisor 1999 – 2006

Other Experience

o United States Army, Ft. Hood, TX - Telecommunications

Contact this candidate