PHP, MySQL, HTML, CSS, Customer Service, Visual Design, Marketing.

• Worked with the No Harm Test coordinator and other peers to facilitate the execution of No Harm Tests, ensuring no harm would be caused to the application's ecosystem due to an upstream change. • Provided process improvement insights. Established more efficient ways achieving the expected result where possible and as allowed.• Provided daily "pass down" communication to the offshore team, assisting them as needed, to help facilitate round the clock execution of tasks to achieve the end goal.• Interacted with the centralized DBA team to facilitate database refreshes, access requests, and permissions architecture. Improved communications with the DBA team to reduce errors with task execution.• Interacted with centralized Informatica administration group as needed to request various enhancements and changes to the Informatica environment.• Crafted SQL, varying from simple to complex, to check control tables for duplicates and invalid entries, verify environment readiness, roll back backed-out code changes, and to perform data cleanup and validation. • Provided statuses to management, including estimates for when tasks could be expected to be complete.• Performed migration and redeployment of relevant SAS and informatica jobs between DEV, SIT, and UAT environments.• Executed ETL processes in SAS and Informatica to load data for code testing purposes. • Interacted with developers to help troubleshoot processes and scripts which either failed or produced unexpected results. Cleaned up, re-migrated, and restarted the process or script as needed once corrective actions were identified. • Worked with upstream and downstream clients to establish ssh keys and set up access control list entries, which facilitate the receipt or transmission of files via SFTP and Connect:Direct (NDM).

• Provided real-time Autosys production monitoring of the client’s Enterprise Financial Data Warehouse• Upon the failure or long duration run of a job, analyzed Autosys logs, DataStage Director, Cognos reports, and Perl script logs to determine the root cause.• Developed a Unix Shell script to make monitoring easier for the team. The script displayed information on the screen in an easier to read fashion, and emailed log files in the event of a failure or long duration job.• Determined if the problem could be solved without the intervention of the client and corrected the problem or escalated when necessary• Developed a Korn Shell (ksh) script to make monitoring easier for the team. The script displayed information on the screen in an easier to read fashion, and emailed log files in the event of a failure or long duration job.• Created a Perl script to read the contents of several remote Windows Server directories. This script displayed the Cognos .mdc and .vcd files within the directory and saved the validation log to an archive directory for later review.• Provided training, mentoring, and guidance whenever requested to a team of 5 monitors.

• Designed many new ETL interfaces for the Teradata data warehouse in addition to supporting existing ETL interfaces• Assisted with the migration of several hundred ETL interfaces from DataStage 7.5.2 to DataStage 8.1 and mentored other developers when problems and job warnings were encountered.• Performed primary on-call production support for approximately 4,900 executions per day• Developed and implemented Data Warehouse ETL processes which sourced data from platforms such as Mainframe, Oracle, SQL Server, DB2 and MQ and loaded Teradata base and reporting tables • Completed necessary change request, production services, UAT signoff, and code review forms for audit purposes• Principal developer of a 25+ page Oracle Application Express (ApEx) application for adjusting KPI metrics related to product shipments. o Utilized LDAP authentication with enhanced authorization scheme controlled by a security table. Per business requirement, some users have different access depending on the day of the week.o Designed and modeled underlying database tables, views, triggers, indexes, and sequences.o Designed necessary DataStage ETL interfaces, PL/SQL scripts and Teradata BTEQ scripts to move data between ApEx and Teradata.o More than 250 users have completed more than 360,000 transactions.• Principal developer of a single page Oracle Application Express (ApEx) application which allows users to enter an item code and see inventories, movement, on hand lots, item costs, and upcoming ads and deals.o Utilized LDAP authentication and open to all users on the company domain.o Made JavaScript and CSS enhancements to quickly present the data to users in a non-scrolling dashboard format.o Designed and modeled the underlying database tables, tuning them as necessary to ensure rapid delivery of information.o Developed all necessary DataStage ETL interfaces to extract data from Teradata and load to Oracle as well as necessary PL/SQL scripts.