David Pagliuca Email & Phone Number

Austin, Texas Area

Woburn, MA

I work as part of a database services team that provides timely BI reporting across the organization via ad-hoc queries, scheduled ETL processes, SSAS cubes, nightly FTP feeds or any other method that meets the business requirements.I provide detailed & often complex results to users in ways they can easily work with, interpret and gain insight from the.

• Lead developer and production database manager for global business-to-business marketing data warehouse which includes development of new ETL procedures (DTS/SSIS), on-going maintenance of daily processing flow.
• Analysis of new and existing data sources working closely with clients to resolve issue or inconsistencies and to determine staging, cleansing and processing needs.
• Designed and developed OLAP database fact, dimensional and extension tables as well as processes to extract and load data from the warehouse or various sources to support specific upper management reporting needs.
• Designed, developed and maintained processes to extract and load data into a variety of reporting tools focusing on reusable components with use of configurable options.
• Develop tables, indexes, views, functions, stored procedures, DTS packages, email notifications and windows batch scripts for daily processing of source feeds into production and to support client reporting/auditing.
• Develop ETL processes to stage source files, transform, validate, process/load into warehouse, apply business rules and generate output in specified format for distribution to key internal and external decision makers.

• Managed and mentored two junior analysts as leader of a client services group which offered custom conversion, reporting, scripting, and general SQL/ETL/DTS services.
• Interacted with clients to learn about their legacy system and develop conversion specification and software rollout plan.
• Performed ETL data conversions into SQL server using custom T-SQL scripts and DTS packages from legacy databases including FoxPro, Dbase, MS Access, ACT, File Maker, QuickBooks, Goldmine, Excel, and more.
• Created complex T-SQL scripts for a variety of custom conversion needs which included mapping and generating future scheduling records based on information extracted from legacy database.
• Interacted with clients daily to create report specifications to meet their reporting needs.
• Generated quote and time estimates based on report specifications, and then scheduled the completion of the report within the department.

• Load, cleanse, and transform client data from various financial systems using Microsoft Access, SQL Server 2000 and MySQL queries and tools.
• Resolve data conflicts by communicating with clients, project teams, and production support.
• Group client vendors and map them to appropriate commodity codes for reporting purposes.
• Create business rules for reporting and data segmentation purposes based on analysis of client cost centers, general ledger accounts, vendors, and various other accounts payable detail.
• Build data warehousing dimensional data based on analysis of raw client data for reporting and filtering of data.
• Develop web based executable MySQL scripts using PHP and Apache Web Server.

• Load client data into Access and SQL server using SQL queries and DTS for reporting and staging purposes.
• Validate data integrity and produce reports documenting issues.
• Develop reports and stored procedures to automate data validation process.
• Analyze client data for the purposes of reporting key financial elements to top-level management.
• Provide DBA support to servers as needed.
• Create and execute ad hoc queries and reports as needed.

• Performed role as lead administrator for all corporate databases, which included responsibility for system availability and backup and recovery planning.
• Installed, configured, and administered all corporate SQL servers which included close interaction with network services group.
• Implemented, configured, and administered corporate accounting system (PowerCerv Financials) and corporate customer care system (Onyx Customer Center) on Microsoft SQL Server.
• Administered finance department databases running on Sybase SQL Anywhere server including corporate time and expense application.
• Selected and configured hardware and software related to database projects.
• Scheduled database backups, responsible for system performance tuning and optimization, and various other DBA duties.

• Responsible for implementation, configuration, and administration of Microsoft SQL Server 6.5 database containing client data.
• Enhanced systems by designing custom tables, indexes, and views.
• Responsible for database backups, performance tuning, and data scrubbing.
• Developed scripts to convert data from AS/400 system to SQL Server on a nightly basis.
• Developed web based application to access client data using Alliare Cold Fusion.
• Web server administrator (IIS 3.0) and lead developer using Microsoft FrontPage and various HTML tools.

Bsba, Computer Information Systems

Activities and Societies: President of CIS Association

Agile & Scrum-Ban Training