Casey Fox Email & Phone Number

Scottsdale, Arizona, Us

-Provide technical leadership for enterprise security architecture, engineering, and implementation-Create action items, processes, and technical solutions that enable the company to meet business goals as well as customer regulatory requirements-Review, assess and mitigate internal and external threats to company information-Responsible for the data warehouse strategy across the enterprise, establishing a secure overall data warehouse architecture for the business-Align business rules and corporate strategy with technology to provide decision support and analytics

-Responsible for overall data warehouse structure; ensure structure is set up for optimization of data extraction and integration. Oversee analysis of business and technical requirements and data models to ensure full understanding of detailed data and leadership requirements. Collaborate with leadership and end-users on overall design of physical structure and implementation plans.-Oversee designated development team; responsible for overall productivity and efficiency of the team. Perform leadership activities including, but not limited to, conducting training assessments, providing coaching, addressing performance concerns, conducting disciplinary actions, setting performance plans, and recommending individual and department growth opportunities. Responsible for ensuring all training and learning materials align and incorporate overall company goals and objectives as well as ensuring adherence to existing training and development strategies; identify inconsistencies and take appropriate actions in executing corrective measures.-Design, document and build physical database objects, including but not limited to table, column, index and view definitions; meet system standards and leader requirements. Responsible for development of scripts for the creation of the physical data warehouse tables, views and macros. Ensure appropriate levels of documentation.-Responsible for overall system performance; direct, lead, monitor and administer ETL and system activity, including optimization and tuning of data loads. Direct job and activity schedules to promote optimal performance, maximum availability and minimize data latency and data load durations.-Design and document data security and asset protection techniques; adhere to data security and protection policies. Recommend optimization to ensure and improve system performance and reliability.-Direct off hours on-call support-Maintain a positive work atmosphere-Perform additional duties as assigned by leadership

-Analyze business and technical requirements and data models to understand the detailed data leadership requirements.-Collaborate on the design of physical structure and implementation of database objects.-Design, document and build physical database objects from table, column, index and view definitions.-Develop scripts for the creation of the physical data warehouse tables, views and macros.-Adhere to data security and protection policies.-Design and document data security and asset protection techniques.-Lead, monitor and administer Extract-Transfrom-Load (ETL) and system performance, including optimization and tuning of data loads.-Recommend optimization to ensure and improve system performance and reliability.-Lead job and activity schedules to promote optimal performance, maximum availability and minimize data latency and data load durations.-Provide off hours on-call support to resolve production issues within the stated service level agreement.-Maintain a positive work atmosphere by acting and communicating in a manner which facilitates the success of business operations in order to meet company demands and expectations.-Perform additional duties as assigned by leadership

-Developed unique training solution to tailor a course to specific job descriptions-Created training material including: presentations, tests, projects, instructor guide and lesson plans-Worked with the college to develop pre-screening material-Collaborated with the school to market the program-Taught 12 week Web Development Course-Ran the course just like a project-Viewed each topic as a deliverable and pushed developers (students) to complete tasks and meet timelines-Developed .NET Development course

Indianapolis, Indiana, Us

-Provide technical leadership for multiple projects in parallel-Maintain active relationships with customers to determine business requirements and lead requirements gathering meetings-Own the change request process and coordinate with other teams as necessary-Develops and owns list of final enhancements-Develop and define application scope and objectives and prepare technical and/or functional specifications-Performs technical design reviews and code reviews-Ensures unit test is completed and meets the test plan requirements, system testing is completed and system is implemented according to plan-Assesses current status and supports data information planning-Coordinating on-call support and ensures effective monitoring of system-Maintain technical development environment-Facilitate group sessions to elicit complex information on requirements clarification, design sessions, code reviews and troubleshooting issues-Support vendor evaluation

Hanover, Md, Us

Senior ETL Developer for a large telecommunications conversion project.Environment: UNIX, Talend, Java, Oracle, Flat Files-Developing UNIX scripts to audit existing Talend extract Java code and notify users-Transitioning audit capability to redesigned Talend jobs-Building SDLC structure and processes-Building streamlined process to identify and address DDL related issues before they occur-Creating processes for code review-Creating coding standards and best practices documentation-Presenting audit reviews to testing teams and managers

Eden Prairie, Mn, Us

Environment: UNIX, Informatica, Teradata, Flat Files-Coordinate with Business Analysts to gather requirements-Write technical requirements/technical responses to the requirements-Drive mapping documentation-Research/resolve issues, risks, action items-Work with Development team to answer questions/clarifications needed for design-Work with Development team to create ETL design and develop code-Assist Testing team with test strategy/test plans-Validate unit test logs and mapping once data is done with Unit Testing-Work with Balancing team to balance data-Collaborate with SIT-Work with SIT logs-Research defects and help in defect resolution in all environments-Work with Leads to resolve any issues-Answer questions/perform research for UAT log items

Eden Prairie, Mn, Us

Environment: Windows, Informatica, SQL Server, Oracle-Provide background on SQL and Data Warehousing concepts-Present overall ETL concepts-Provide introduction to Informatica-Create course material and labs to check understanding-Provide introduction to third-party scheduling tools-Provide introduction to Windows/UNIX scripting-Present advanced Informatica and ETL concepts

Eden Prairie, Mn, Us

Technical Lead on a project to remove duplicate entries and to prevent duplicates from being entered in a Siebel environment.Environment:Performed a full extract of data from the Siebel base tables into work tables on a SQL Server databasePreviously, all data integrity was handled on the Siebel side. Added constraints to the database to address dataq integrityCreated stored procedures to remove duplicate data and send that cleansed data to staging tables before moving back to productionUsed Siebel to import the cleansed data from the staging tables back into the Siebel base tablesMigrated the duplicate prevention Siebel code from the test environment to productionProvided end users with an explanation of how to handle anything they would notice as an existing duplicate with the "Merge" functionality in SiebelAutomated an interim production cleanup process using scheduled stored procedures that would populate audit tables upon completion

Eden Prairie, Mn, Us

Project/Technical Lead for a data migration project.Responsibilities:Design/Develop daily extract processOversee environment creation and access (Source, Target, ETL, Scheduling, UI, Reporting)Oversee data architecture, UI design, BO designCoordinate with offshore resourcesCoordinate with Project Manager to ensure project deliverables are being met

Eden Prairie, Mn, Us

I worked as a Project Lead for a data migration project. In addition, I retained my development duties.ResponsibilitiesCoordinate answers to technical questions between technical resources, developers, and business users.Ensure project timelines are being metProvide weekly status reports on individual tasks at hand to the Project ManagerMaintain knowledge of all areas of the projectProvide knowledge transfer for new developers rolling onto the projectAssume the role of the client-facing representative for project developmentStay on top of my individual development responsibilitiesDevelop SOW based on client scopeDistribute tasks to ensure all members of the team are fully engaged

Eden Prairie, Mn, Us

I worked as an ETL Developer and an ETL Developer Lead. Projects Data migration project for a top healthcare client. The migration was from multiple Teradata source databases to a centralized Oracle target.Created Low Level Design Documentation for the development of the migration code based on the business requirements.Developed the DDL to create Teradata tables on a Staging Area database.Wrote BTEQ scripts to populate the tables in the Staging Area. Used Informatica to migrate the data from the Staging Area, as well as, the source databases.Created a shell script to kick off the BTEQ scripts from the Informatica Workflow.Built Oracle Triggers to update target records with sequence generators.Created Unit Test Cases to verify the data.Provided support and development for each phase of testing (Dev, SIT, UAT).Provided support and development for additional releases.Designed and built a training environment for Informatica, Teradata and Oracle. Incorporated multiple computers into the environment with Windows and UNIX platforms.Developed training material for Oracle Discoverer Plus to be used by future employees. Developed basic and advanced training material for Informatica that was immediately distributed for current employee training. This material includes guidance for Informatica Server and Client.Developed basic and advanced training material for Teradata that was distributed along with the Informatica training guide. This material includes guidance for Teradata Administrator, SQL Assistant and BTEQ. Also, it details Teradata Fastload, Multiload, TPump, and FastExport, as well as, running these tools from a shell script.

Developed websites using HTML, ASP, PHP, MySQL, Javascript, AJAX, HTML5-Developed a Dynamic Social Networking site based on a MySQL database.Created online photo albums -Created message boards using PHP and MySQL -Built a website for a local band including an online store -Created a java music editor that allows a user to play a music track and crop out a section to download as a ring tone

Redesigned a company website and performed Graphics Design in spare time. Projects * Used PHP to filter incoming mail throughout company * Designed an online storefront using MySQL and PHP

Morgantown, West Virginia, Us

Effectively helped students and faculty with computer related questions and problemsTroubleshooting and Installation of software and hardware