Frank Redding Email & Phone Number

San Mateo, California, Us

San Mateo, California, Us

San Mateo, California, Us

Developed and Maintained a Microsoft Azure Database that stores all data for an IPad mobile application called MiAgents that is used by insurance companies to evaluate their individual agents.Built all back end stored procedures that allows MiAgents to access data over a web service. Played an important part in the design and implementation of model creation and changes. Designed an insurance alert system that delivers notifications based on client configurations on a web portal to MiAgents mobile application. Built a marketing rep evaluation system that allows for both rep and agent feedback. Designed overall production graphs that gave marketing reps the ability to view their policy production, incurred loss and quote numbers by agent hierarchy. Designed and Implemented an ETL platform based in SQL Azure. Built an extractor service based in C# to Audit, Zip and SFTP client files to an Azure VM. Designed and Built Azure VM to host A SFTP server that transmits clients files to MiAgents landing strip folders Help build a c# program called FTPMonitor that listens to our landing strip folders and processes every client file in our ETL process to load our MiAgents EDW Designed all stored procedures that ETLs all dimensional data. In addition I built all fact table roll ups for YTD premium, incurred losses and quotes based on clients daily transactional data. Built and maintained an audit system to maintain the integrity of our warehouse.

Danbury, Ct, Us

Maintained with SQL an Oracle 9i database that is used to store millions of records for Pharmaceutical Industry. Used WebQL (Web Harvesting Development Software) to automate data collection of state license information over the web.Designed and maintained Ab Initio programs that are used for ETL harvested data.Monitored State License Information ETL process for inconsistencies and corrupt data. When inaccurate data was discovered I investigated an adapted existing processes to rectify any irregularities.Used Cybermation to upload data from a State License Database into IMS core Oracle database Developed SSIS packages to ETL and cleanse millions of State License records.Designed and implemented multiple databases in sequel server, which included table design and architecture. Created stored procedures that helped perform and track daily maintenance that is performed on my company’s core database.I helped investigate client inquiries about the quality of our database and helped client managers describe the correct interpretation of the data or fix the specific issue that was at hand.Develop new standardized ETL process in SSIS to replace existing Ab Initio processes. This entailed condensing almost 60 different Ab Initio graphs which included numerous data flows into one SSIS package that can handle almost 700 state professions.

Sicklerville, Nj, Us

Maintained an Oracle database analysis of Maintenance of Way and Information Systems (MOWISTM) for forecasting track maintenance and assessing employee productivity reports.Project leader in product development and implementation of HMOWIS, a PDA application that works in conjunction with MOWIS and its Oracle database to record and monitor all defects within rail road track systems.Provide software maintenance for VB, VB.net, VC++.net applications and their Oracle databases. Data acquisition of pre/post grind measurements of a Harsco Grind Train, to monitor metal removal and quality control of the rail resurfacing utilizing a profilometer which records the pre and post grind profiles of rail systems and a VB program designed by myself to analyze the recorded profiles.Project leader in development of an embedded VC++ program interfacing with Train Ride Quality hardware to record and view real time X, Y, Z lateral forces exerted on a moving train.Data acquisition of the X, Y, Z lateral forces that are exerted on the rail by moving trains utilizing strain gauges that interface with a VB program that was develop by my engineering team.Repair and maintenance of electronic testing equipment, diagnostics, soldering, circuit board repair, calibration, and component replacement and installation.Maintenance and repair of office equipment, computer hardware, printers, software upgrades, server and e-mail maintenance. Work on-site with clients to address development of our products which would be adapted to suite their business needs. I have over 2 years of experience in engineering field work that includes developing the very tools that I used in the field.

Bachelor Of Engineering (Beng), Electrical And Electronics Engineering

Education record