Scott Mccarroll Email and Phone Number

ETL Developer/Data Modeler at the State of California Franchise Tax BoardWorked with DataStage 8.7. Modified existing ETL jobs to process new data types; including adjusting columns, derivations, and business logic as needed. Modified existing and created new job sequences to include e-mail driven error reporting. Performed full sequence and job-level unit testing and coordinated with test staff on larger system tests.Took over primary development and support for multiple large and highly critical ongoing batch jobs (jobs that run daily, generally multiple times per day). These applications were mission-critical for the client and represented vital tax information for both individuals and businesses where errors or issues would need to be dealt with quickly and efficiently. Well regarded by both client and other consulting staff on both a personal and professional level. Frequently a first point-of-contact by other staff seeking help with difficult issues (both in troubleshooting and in new development). This reputation was earned in part by being honest about where problems or challenges exist, regardless of where they were or how they came to be, and in part by being approachable and available regardless of the time of day or day of week.

DataStage ETL developer at Premier Inc., located in Charlotte, NC. • Worked with DataStage (8.5 and 8.7). • Modified existing real-time ETL jobs processing patient data to work in batch mode, created and maintained sequencers to run jobs. • Created and presented DataStage training materials for client users. Tool produced was then able to be used by both internal and external clients to provide a solid foundational experience with DataStage and ranged from running simple jobs to more complicated processes such as connecting to databases and extracting meaningful metadata from existing tables.

* Contractor at Benefitfocus in Greenville, SC.* ETL and Database development using PL/SQL with Oracle 11g* Performance analysis and tuning* Data migrations/transformations* Adding/removing columns, indexes, creating/updating triggers, etc.

* Oracle 10g/11g* SAP Business Objects DataIntegrator ETL tool* AIX* Managed 5 members* Team lead for 3 members

• Technologies: Cognos DataManager 8.1., SQL Server 2000 and 2005, and Tivoli Workload Scheduler 8.4.3.• Developed and maintained ETL processes using a combination of Cognos DataManager and SQL Server (DTS Packages and Procedures)• Provided support to the user community in developing and improving the efficiency of ad-hoc SQL queries • Administrator for Tivoli Workload Scheduler.

• Developed and Tested complex ETL applications using Oracle and PL/SQL.• Lead the migration to using PL/SQL over anonymous SQL blocks over a two year period of time starting late in 2001 and finishing in early 2003.• Co-lead an initiative to implement a series of “best practices” in PL/SQL development. This included the abundant use of metadata tables in dynamic SQL statements to fully parameterize ETL loading code. This greatly reduced the amount of time required for new development from 3-4+ weeks down to less than 1 or 2 weeks at most.• Collected, combined, and enhanced a series of disparate stored procedures and packages into a single “Load Package” written in PL/SQL.• Frequently mentored teammates and acted as an expert in the area of Unix Shell Scripting.• Winner of the “Shining Star” award for contributions to the development of and migration to a new “Enterprise Data Warehouse” that replaced three older legacy data warehouses. • Responsible for creating and maintaining database objects such as tables and views in EDW environment. • Interact with business customer to identify business requirements.• Preparation of business requirement document, technical specification, functional specifications, data transfer specifications, source to target mapping and logic identification.• Production support: monitoring the data warehouse ETL jobs, analyze and resolve data issues.

• Member of the Unix Shell and Utilities team in the Unix System Services for the S/390 division. Primary responsibilities focused on understanding and improving the existing documentation.