Jay Burns Email & Phone Number

Englewood, CO, US

• With IHS Transformers (WFM) team processed new requests to update MS SQL objects based on business requests, find and correct production issues, and create new processes to allow for comprehensive processing of data.
• Work with IHS Transformers (WFM) team to update MS SQL stored procedures based on new business processing requests. Most of this code base needed to refactored to accommodate new software versions or replacement of old.
• Create or update SSIS packages and SQL Agent jobs to allow for fewer manual processes, decrease data processing time and allow for new automation with additional checkpoints, email statuses and flexibility across.
• Redesign auto archiving and purging processes to allow for better control and transparentness. Added ability to individually run specific tables through new processes and keep track of all processes through enhanced.
• Collaborated with other teams to implement promotion policies and procedures to meet with new company wide security structure.
• Train and mentor off-shore teammates to allow for round the clock production support. This included initial introduction to systems and processes, and review of current projects. This allowed for additional code review.

• Invoicing to contracts for clients and validation of subcontractor invoices
• Reconciliations and audit support
• Analysis, maintenance, and enhancement of information systems
• Identify information systems opportunities and risks

Westminster, Colorado, US

• Worked on two Data-Driven Maxar (DDM) teams: MDM to centralize data from across the company by allowing for a single source of truth of customer and product information, and upgrade PAID from manual spreadsheets to a.
• Used Python with PySpark libraries to import source files (.csv,.txt) into data frames. This allows data validation, updates, or manipulation to be processed in memory. Data frames acted as a buffer or temporary.
• Python allowed the update of cloud data over a secure VPN with SFTP, direct file access, or processing to PostgreSQL database servers as needed, as required by stakeholders and business owners.
• Python was used to open VPN tunnels, connect using SFTP protocols, start or stop AWS cloud services, including EC2, RDS, and S3 servers, and processes created for AWS Glue.
• Designed relational and dimensional data models for PAID. Created ETL’s to load data from outside applications and manually created CSV files through Python or AWS Glue.
• Created SQL stored processes from VBA routines to properly assign data values across multiple datasets. Used dimensional datasets to create variable-driven reports for the executive leadership team.

Denver, CO, US

• Gather data from across the district’s multiple applications into one central repository. This data would function as a single source for reports, extracts and analysis of how the district works to it overall goal of.
• Took over data analysis, SQL procedural coding, and ETL functions when teacher level application transitioned from outside vendor support to internal operational and maintenance mode.
• Redesigned application data structure from ground up to be more flexible and allow stake-holders to make quicker adjustments as the need arose.
• With team, redesigned single source data structure to all allow for multiple independent sources while keeping redundant data to a minimum
• Took a multi-day importing process with highly repeatable data and streamline structures and processes to allow for better data connect ability with very low data redundancy. Overall process time decrease to least than.

• Worked with various development teams to create tables, indexes, procedures and other links to a DB2 legacy System of Record database. High speed processing required due to connections to NASDAQ and customer need for.
• Created access procedures in iSQL to all other applications to access System of Record information stored in legacy DB2 database.
• Worked directly with Application Development teams to integrate new or updated procedures with most current version of software and requirements.
• Worked with Data Integration/Business Intelligence team to help facilitate access to very large volumes of data, which in turn allowed for better reporting of data for business and regulatory agencies.

Minneapolis, MN, US

• Processed custom configuration requests for Fortune 500 clients to use Sopheon Accolade application group. Worked with many cultures from around the world.
• Created metrics, designed reports in MS Office/MS Excel, write custom code in VBA, and design SQL queries. Worked with Project Managers from Sopheon and clients, as well as client stake holders, to design and implement.
• Created documents and reports using Sopheon technology call Smart Office, an add-on tool-set for MS Office, MS Excel, and QlikView.
• Work with MS SQL Server to setup database and configure custom metrics.
• Setup MS servers in virtual environment for both internal and external usage. External usage could be at clients or on hosted Sopheon server farm.

• Engage State Children’s Health Insurance Program (SCHIP) and Government Health Services to provide outsourcing, consulting, and information technology services.
• Create new Python processes to integrate with Pervasive and AutoSys systems to process third-party files.
• Used Python to connect with outside systems using SFTP for file download and upload. Created tests to confirm the file was complete before processing and loading specific flags to the system to notify of process.
• Designed new integrated Pervasive and AutoSys processes, which enabled various departments (Accounting, Human Resources, and IT) to use fewer entry points for payroll and project time tracking, allowing for increased.
• Used AutoSys and Pervasive data transformation with Oracle views to help transform data in HIPAA 834 formatted files from third-party vendors to internal systems and send updated files back. Processed files for.
• With Visual FoxPro maintain and continue development on CHAS (Child Health Administration Services) for Florida, Georgia, and Tennessee SCHIP programs to include the following abilities:

• Builder of new homes in Colorado since 1953 with communities along the Front Range from Fort Collins to Denver to Colorado Springs.
• Develop and rolled out multiple phases of a mission critical application (MISER) that is used to track homes lots and customers from contract to beginning of building through warranty period.
• Create training materials for custom developed software and provide the actual training.
• Developed in-house applications using Visual FoxPro, Excel and SQL to enable reporting of information stored in an AS/400 accounting system (McCosker/Trueline & JDEdwards).
• Developed in-house applications using Visual Basic.NET for use by closing department to enable them to product closing documents that meet minimum state standards with information from MISER and AS/400, along with data.
• Created Windows forms using Visual Basic.NET for input and calculations of possible mortgage scenarios from current standard rate information and a base pay calculator used for sales person commissions.

• Customized data extraction process to create custom reports that help recipients with their workloads and to understand where items in the workflow where in relation to other items.
• Designed new FoxPro applications and reports to better meet multiple recipients requests.
• Create and/or update Crystal Reports items to better process incoming data.
• Redesigned ETL process to use updated code, procedures, and indexes to decrease processing time from 6-8 hours down to 10-20 minutes.
• Work with all levels of management to reduce number of reports produced and reduced number of copies of reports with overall effort to reduce paper use by almost 50% and redundant reports by 60%.
• Created onsite report guide of all reports, with selection criteria, date ranges, report ranges (day, week, month, quarter) so as to get the right data to the right people with fewer reports.

Bs, Computer Science

Computers, Accounting