Mark Allen Email & Phone Number

Florissant, Mo, Us

Stamford, Connecticut, Us

• Part of Business Intelligence team for Field Operations department • Worked with cloud technologies: Redshift and Teradata • Created and updated stored procedure-based ETL processes in Teradata and Redshift • Researched data for requirements gathering and verification of currently known data • Verified data migration from Teradata to Redshift • Investigated root causes and built solutions for defects found during migration

Stamford, Connecticut, Us

• Part of the Customer Programming and Reporting team • Building SSIS packages for ETL processes • Used C# for building sql file-based executions and file manipulation • Installed and configured the Jenkins scheduling service for basic job scheduling • Created macro-enabled excel workbooks for refreshing/delivering reports • Created jobs using the Windows Scheduler • Documenting new/existing processes for future reference • Built and QA’d processes that interacted with customer-facing data • Built scripts interacting with AWS S3 using AWS CLI • Performed overnight production releases • On-call for job failures

Stamford, Connecticut, Us

• Part of the Field Ops Analytics team • Primarily focused on team support and report generation/maintenance • Supported overnight production deployments • Daily monitoring of production failures. Resolving them or informing the team as necessary • Created reports utilizing Jenkins scheduling with WSF, Batch, and macro Excel files • Migrated all SQL Agent jobs to the Jenkins scheduling tool • Created/refreshed regular ad-hoc reports for management • Researched and investigated means of improving current environments • First responder to customer emails concerning our team’s projects/reports • Created documentation for processes/reports that were previously not well known/documented • Trained/advised other team members on SQL Server coding and other miscellaneous scripts

St. Paul, Minnesota, Us

• Worked 100% remote • Worked with clients to fulfill security needs • Worked with Service-Now development teams to build, test, and release replacement tickets for the team’s current ticketing system • Controlled access to various IT technologies that the company needed • Practiced safe practices and documentation for completing security requests • Worked with ancillary teams to fulfill development needs • Controlled SQL Server access by creating roles/logins/users and granting/revoking permissions • Maintained active directory by creating/deleting/disabling users/contacts/groups • Resolved emails stopped by Data Loss Prevention program • Controlled DB2 access/permissions using RACF/Zyphyr Mainframe • Created, assigned, and extended RSA tokens • Performed emergency terminations • Supported team members by assisting with workloads and reducing the overall responsibility of the team • Collaborated with management and other teams to refine, correct, and/or create security processes

Lincoln, Nebraska, Us

-Part of BI team- Converted C# migration scripts into SSIS packages- Migrated data from SQL Server databases to Netezza databases- Converted stored procedures from SQL Server to a Netezza version- Built SSIS packages to automate existing processes- Worked with SMEs to implement/understand project requirements- Delegated and coordinated tasks to complete team-up projects quickly- Performed QA testing for production release- Worked in SCRUM and Agile environment- Cleared for 5C security clearance to do work for the Department of Education

Broomfield, Colorado, Us

- Part of Revenue Assurance team- Developed SSIS packages to create data audits with emphasis on Latin American data- Modified SSIS package to conform with better standards- Augmented SSIS packages with C# script tasks- Worked with analysts to refine data output to allow faster revenue recovery- Developed Tableau reports to highlight data issues- Maintained and modified SQL Agent jobs- Built procedures to evaluate data for revenue opportunities- Worked with analysts to refine existing procedures to allow faster revenue recovery- Performed environment tuning to improve performance (Index, query, SSIS package)- Performed data migrations to new data structures and environments- Developed Tableau reports to highlight data issues- Constantly pushed our team toward a more mature team structure- Acted as a liaison to South American counterpart team- Created tools for non-dev teams to work more efficiently- Developed web app pages with ASP.NET to allow outside teams to safely interact with these new tools

San Francisco, California, Us

- Part of the development team for several new products and processes Customer Experience Profile (CEP)- Solely tested new processes and products for bugs and coding errors as part of a development team- Created a complex stored procedure designed to check loaded data and ensure accuracy- Created and regularly implemented a process to check, name, and delete tables in a heavily used database- Monitored and tuned the performance of Stored Procedures and complex T-SQL Queries- Created proper SSIS Packages

New York, New York, Us

- Consistently created processes for cleaning and handling big data projects- Performed quality checks on other data analysts’ code before allowing it to run in production- Developed SSIS packages to safely transfer data across different servers to append new data- Granted highly selective security clearance for a federal case- Created canned, cascading, parameterized, and ad-hoc reports using SQL 2005/2008 Server Reporting Services- Developed backup and recovery plans and created a schedule to provide adequate disaster and emergency data rescue procedures