David Edison Email & Phone Number

Charlotte, Nc, Us

Tampa, Fl, Us

Tampa, Fl, Us

Creating and updating complex stored procedures to process data from staging database to datawarehouse. Troubleshooting stored procedures and data in mysql and Sql to fix issues with incorrect data being populated to Compass and reports. Building new SSIS packages to populate data from flat files into sql data. Great communication between all levels of company to help resolve their issues in a timely manner. Conducting code review of sql queries and sp.

Raleigh, Nc, Us

Creating and maintaining SSIS packages, SSRS reports, and SQL databases. Mentoring co works on building SSIS skills and sql skills. Completing code reviews for team. Building test plans for system upgrades. Developed SSIS package that pulls data from Oracle database to fill sql warehouse. Uses 180 packages and runs about 1 million records a night. SSIS packages pull source data using sql queries to drop into staging tables to then update Datawarehouse. All the 180 packages are triggered by a master ssis package with a file that is created at the end using c# to let the system that triggered the master ssis package that is done to finish with nightly batch.Created new extract for finance to complete month end balance. Built ssis package to pull credit card, consumer and business loans from multiple database(sql, oracle). Sources use complex queries to pull data and export into excel to be digested by SAS process.Troubleshooted and fixed issues with SSIS packages having bad data, external files formatted wrong, change in tables, to basic error packages or reports. Maintained current SSIS job to enhance packages with new request from business owners. From adding new columns to excel extracts, combining 6 extracts into one by rebuilding the sql queries to use our new warehouse, and adding a step is ssis to validate if a customer is a registered member, modified sql queries to pull new data from oracle or sqlCreated SSRS reports for Finance, Marketing, and Management team. Reports contained custom bar/pie graphs, complex grouping, and expressions for hiding with condition statements and custom totaling. All with custom queries to pull data from multiple database from sql to oracle.Mentored new employees and Interns to understand our systems and databases. Grew their knowledge of SSIS and SQL by troubleshooting their work together and walking them through my work as an example. Was their resource for any questions that they would have.

Raleigh, North Carolina, Us

Developing and updating SSIS packages, DataStage packages, SSRS Report, WMR Portal web site to fit the needs of the business owners, creted/altered/inserted data into sql database using sqll• Developed a message banner for the WMR portal for maintenance window using a date range built with C#, HTML, and CSS. • Created an SSIS job to updates a current table daily instead of month end process. • Updated SSIS job to pull new data from flat file using C# to parse out the data and sql to updated the tables with new columns. Updated SSIS package to use new columns and updated extracts files to have new columns in them. • Created stored procedures to us a data sources in SSIS packages. • Troubleshooted and fixed errors in SSIS packages from bad data, password failure, external connection to FTP failing, and package not getting triggered.• Research and updated DataStage jobs with new SQL queries to fix issues with joins to get all the correct data in FCRM. Created DataStage jobs to pull data from DLAND database and SQL database to fix data that has been updated incorrectly in FCRM.• Create new SSRS reports to do a job between two different databases to see what wires that are getting dropped between two systems. Created sql query to pull data from database. • Updated existing packages using requirements that business owner wanted using sql to develop updated queries/stored procedures and sql to create/updated tables and view with new requirements.

Minnetonka, Mn, Us

Developing and updating .net webpage. Building webAPI’s for uploading files into Laserfiche. Creating Laserfice workflows to help automate work for business owners. Using SSIS to transfer data and manipulate data from SQL database, oracle, and flat files to Microsoft Dynamics to automate business manual process. -Developed Web api that allows Medica.com to connect to Laserfiche to pull documents stored in the repository when the user clicks on the link.Built and Maintained Laserfiche workflow and repository to automate business needs. Created workflows to pull data from a PDF’s then to place into Excel sheet. Update LTCC and SNBC to work with new PDF and Oracle Database. Built new repositories and folder structures for new workflows. - Updated and created SSIS packages for business owners to automate manual processes. Create SSIS packages to pull data from flat files or database to update contacts, leads, Letters, and Plans in Microsoft Dynamics. Created stored procedures to do match logic on contacts and leads to see if they existed in Microsoft Dynamics database and custom error handling for SSIS package. - Updates the ProviderPortal Webpage for Open enrollment with new PDF Application and Code behind to pull data from web form and populates the PDF application.

Olympia, Wa, Us

Created and customized web pages using JavaScript, JQuery, C#, SQL, ASP.Net, and HTML. Used Agile process to manage coding, testing, integration and deployment of webpage design. • Developing a website to allow users to submit Accident Incidents Forms to HR and allows HR to edit the forms and produce reports. This site gets rid of the need for paper forms and HR to having to keep an excel sheet of data. Developed using C#, ASP.NET, SQL, JavaScript, and Stored Procedures. • Created a state government web page that provides an electronic vehicle collision reporting system (ETORT). ETORT was the first Angular JS web site developed by WATECH. o Personally developed the State employee portion of the ETORT site https://etort.des.wa.gov/incidentreport • Developed enhancements for Washington’s Electronic Business Solution (WEBS) to meet user functionality complaints, Users are newly able to search by Commodity Code Category, post bids, expand description fields; see already selected Commodity Codes on Search Commodity Code Page. This system improves state ability to minimize taxpayer expense.• Debug, Develop, and publish fixes for customer tickets.• Reviewed functional customer requirements and design specifications to ensure accurate product delivery.• Prepared time estimates for testing deliverables• Developed test plans to identify testing effort scope, testing methodology, features and functions to be tested, and risk factors.• Executed manual test cases or automated test scripts using Test Case Manager.• Documented issues found during testing into the defect management tool.• Actively communicated testing status and production readiness to project management, providing concise and factual information.• Configured IT Service Management tool, EasyVista, including conditional SQL based workflows, custom questionnaires, HTML-based email templates

Olympia, Wa, Us

• Received, triaged and resolved service. • Provided technical support for resetting passwords, Active Directory updates, Outlook Vault/email account/errors, phones, printers, and installation of monitors/phone/computers• Served as helpdesk for custom developed budget applications: BDS, CBS, RPM, SPS, ER applications• Coordinated solutions with customers, developers, and testing.• Prioritized application issues • Updated user guides/manuals• Provided desktop support to customers to install new computer, keyboards, desk phones, and monitors• Provided principal administrative support

Olympia, Wa, Us

• Served as Systems Analyst for custom web applications• Assisted staff and division customers with use and features of applications• Resolved software issues and gathered technical information to escalate issues to development team • Created training on use of digital archival system• Managed “Building on a Disk” program and training on application (AutoCAD, Adobe Pro, scanning software).• Created an outreach plan to attract clients to purchase the digital archival system

• Scanned architectural drawings into PDF and created bookmarks.• Created AutoCAD drawings for community college and cities.

Ba, Information Technolgy - Software Programing

Certification, Computer Aided Drafting

Aa, 3D Media Design And Production