John Web Avila Email & Phone Number

Rosemont, Illinois, United States

Glendale Heights, Il

• First ever Database Administrator for the organization.• Create database management procedures.• Architected a process to ensure International data is compliant with the European Union’s new GDPR law. • Created Policy documentation on keeping data secure throughout the Organization. • Implemented Disaster Recovery Plan to the Cloud to recover within 15 minutes or less of data loss.• Created SSRS reports to help predict the future costs of Transportation.• Implemented Replication within a Clustered SQL Server 2012 environment in 3 locations across the US.• Automated shipping tracking processes, USPS Vendor Cost uploads and Archiving of Data using SSIS.• Integrated proprietary software with SAP to eliminate the need of manual data entry to QuickBooks.• Lead database architect in Agile projects to improve the trucking transfers between locations.• Ran diagnostics on all database environments to improve performance. Adjusted server configurations to be in line with best practice standards. Cleaned up all DB environments of unused objects.• Implemented a new Staging tier which allowed for proper QA, before deployment windows.

Hoffman Estates, Il.

• First ever Database Administrator for the organization.• Strategic Planning and Database Team Manager• Responsible for Business Intelligence envisioning and implementation.• Defined data warehouse architecture, platform and applications• Implemented metadata standards, data governance and stewardship, ETL, ODS, data warehouse, data marts, reporting, dashboard, analytics, segmentation, and predictive modeling• Improved overall database and server performance by tuning/applying indexes, adjusting server configurations and identify/removing deadlocks and other bottlenecks.• Consolidated a multitude of databases/servers which included upgrading to more current versions and migrating DTS/SSIS packages.• Implemented a smart, enterprise wide backup and maintenance strategy. Reduced overall maintenance package job duration by 25%.• Designed and implemented a new Data Warehouse environment, including setting up new SSAS cubes and reporting environment using SSRS.• Implemented Data partitioning, Error Handling through TRY-CATCH-THROW statements, Common Table Expression (CTE).• Involved in decision making process for enterprise applications including MS Dynamics AX, MS Dynamics CRM, ecommerce platform and phone system. Also, responsible for the integration between all of these platforms as well as reporting from each of them.• Architected ecommerce strategies including a new Autoship Program, which allowed customers to automatically receive shipments on intervals. Lead a team of programmers and designers to implement the new functionality.• Received company awards for Most Improved and MVP. Opening speaker at the 2015 company Christmas party.

Chicago, Il.

Database Administrator and Developer- Managed SQL Server database servers in multiple environments. - Created data diagrams, data dictionaries, and other database documentation. - Created SSIS/DTS packages for client integration. - Senior database developer with advanced TSQL skills. - Experience with MySQL, Oracle, MS Access, FoxPro, WMS, FileMaker, Counterpoint and other data systems. Lead Technical Team Manager- Managed a team of application developers, system architects, database developers, graphic designers and quality assurance specialists. - Worked with clients and design partners to determine and document business requirements, system architecture, IT infrastructure, technical solutions, database design and technical analysis. - Determined employee work flow. - Managed 3rd party vendor relations. Project Manager- Main point of contact for clients. Used tools such as Microsoft Project to determine timeline and cost. - Created Statement of Work, hosting and maintenance contracts; coordinated meetings between clients, graphic design partners, 3rd party vendors and internal staff. - Helped determine and create site maps, work flow, technical wireframes and business requirements. - Ensured milestones were met and project is within budget. - Managed business support case issues.E-Commerce Manager- Worked with clients to determine the best e-commerce solution for their business needs. - Created shopping carts and integrated with payment gateways. Implemented SSL and encryption techniques. - Ensured application development and IT infrastructure security standards were met. - Lead and integrated marketing efforts with Google, Yahoo and other industry experts. - Experience with Verisign, Pay Flow, Authorize.net, SkipJack and Chase Paymentech.

Associate’S Degree, Interactive Media And Project Management

Education record

High School