Steve Dingle Email & Phone Number

Lancashire, United Kingdom

In March 2016 I formed Rightway Data to work with different organisations, facing new data challenges, as I love diversity almost as much as I like consistency. Besides being the owner, I am also the technical director, which means directing how things get done and lead developer, which means actually doing them. As lead developer, I provide the SSRS reporting, SSIS data processing and any other data related solutions for my clients. During the first year, I focused on developing the following in-house tools to reduce development time, subsequently lowering client costs.Business Reports Manager Report documentation is necessary. You need to know what reports are available, their format, the data they contain, how and when they are run and who is responsible for them. BRM provides a database and set of reports for holding and presenting this information. While BRM can be used for reports in any format such as SSRS and Excel, for SSRS reports BRM also provides a data-driven approach to formatting and organisation branding.Package Management FrameworkAs with reports, SSIS package documentation is necessary. You need to know what packages are running, how often they run, their purpose, their dependencies and who is responsible for them. PMF is an SSIS framework that provides a database for documenting and data driving SSIS packages. PMF includes package templates containing reusable, common functionality and a suite of SSRS reports for package and package run details. PMF also uses the Business Reports Manager for managing its reports.Additionally, I developed the Rightway Data website using Joomla 3.7 which was an enjoyable and educational experience, however, it is obvious I am not a web developer and in the future will be leaving that up to the experts.I am actively seeking new clients, so give me a shout to discuss how I can help with your SSRS/SSIS or other data related challenges.

Lancashire, United Kingdom

In July 2015 I left Marie Curie due to health reasons. With 'making lemonade' in mind and over 35 years of continuous work, I decided to take some time to recharge.While I was out of the workforce I was not idle during this time. - I updated my SQL Server, SSIS and SSRS skills to the latest versions.- I started training in Access/VBA to provide the front-end to my planned SQL Server tool set.- I learned the basics of CSS/HTML and how to use a CMS (content management system) like Joomla to create websites. I need to stress here this is for personal growth, I do not offer any services as a web developer. At the end of my sabbatical, I decided to get back into consulting and opened my Information Systems company, Rightway Data Limited.

London, United Kingdom

Marie Curie is a UK based charity with over 4,000 employees, that provides care and support for people living with terminal illness, and their families. In 2016 they cared for over 40,000 people across the UK. Initially hired as a Systems Analyst, by February 2013 I was promoted to Senior Systems Analyst which included more project, campaign specific and managerial responsibilities. My primary focus was working with CARE (IRIS/NFP Advanced), a CRM system for charities. Working with business analysts and stakeholders I developed and maintained SSRS reports for managing fundraising campaigns such as the Great Daffodil Appeal, Great Blooming Tea Party and many others. Using SSRS I develop a reporting suite for the Major Gifts team, which manages the portfolio of high-net-worth individuals and trusts for gifts of over £10,000.Using SSIS I developed packages for importing fundraising campaign data and 3rd party data flows. To improve consistency, transparency and visibility I developed an in-house SSIS framework used by the team for package development and administration. I also provided SSIS training for all members of the database services team.Working within the CARE SQL Server database, I developed a data profiling method for identifying unique donation accounts that were subsequently used to track the click-through rate for online banner ads and mailings.In July 2015 I left Marie Curie due to health reasons.

Watford, United Kingdom

Corona Energy is an independent supplier of gas and electricity to British business, corporate and public sector customers.The company’s data was held in Visual FoxPro 9.0 and Oracle 10g databases and while my title was data analyst, I was also a developer and designed and developed the following systems:- A desktop application used to process EDI (Electronic Document Interface) files that produced ad-hoc user reports. - Enhanced the existing contract renewal system converting it from a manual system of Excel spreadsheets to a more automated self-monitoring system that increased accuracy thereby reducing riskIn 2009, Corona decided to change their system to a SQL Server and Microsoft Dynamics AX system specifically built for the energy and utilities industry, MECOMS. I was part of the team that played a major role in migrating the existing .5 terabytes of data from Visual FoxPro and Oracle into SQL Server.Some of my key achievements during that time were:- Mapping all the data into the new system while working closely with the MECOMS team- Writing code to perform various parts of the data migration- Building a Visual FoxPro application to automate, manage and report on the migration process- Developing an automated system to extract weather information from the National Grid and integrate the data into the new system In December 2011 I took voluntary redundancy with most of the in-house development team as the MECOMS team would be providing a majority of the support for the new system.

London, United Kingdom

I moved to London from Charlotte, North Carolina and started an IT consulting company with my colleague, Volker Stamme. We provided consulting, training and development services in Visual FoxPro, SQL Server and C#. D&S Business Solutions closed its doors in August 2008

Charlotte, North Carolina Area

UVEST Financial Services offered brokerage services to 3rd party financial institutions, like banks, and also provided investment services to the general public. UVEST was acquired by LPL Financial services in 2007.Initially hired as a short-term consultant to improve the performance of an existing FoxPro 2.5 system, I eventually developed an entire Visual FoxPro desktop application to manage all administrative tasks for the company. Some of the highlights of that system included:- Reducing their monthly billing cycle from 4 days to 1 and increasing invoice accuracy by 50%- Migrating their pay-out system from a complex series of spreadsheets into a database which integrated with their accounting system, Peachtree- Providing a prospect management module used to track potential clients- Providing a trade and account tracking toolI maintained this system until 2006 when it was decided to convert to a C#/SQL Server 2005 system. Unfortunately, that project was cancelled in June 2008.

Greater New York City Area

A charitable organisation founded by members of the Bulova watch family, the Fund awards monetary gifts and grants each year to various charitable organisations. I developed a custom Visual FoxPro application that tracked and managed their gifts and grants, greatly improving on the previous system of excel spreadsheets.

London, United Kingdom

LSHTM is a world-leading centre for research and postgraduate education in public and global health.In 2000, LSHTM started ObaapaVitA Trial in Kintampo, Ghana to determine the impact of Vitamin A on maternal mortality. On site in Kintampo, Ghana, we created a reporting system for the research database containing study results for over 100,000 Ghanaian women. The system included reports and wizards that through comparative testing was found to have increased findings accuracy by 100%.We also provided SQL and reporting writing training for the on-site staff.

Charlotte, North Carolina Area

In 1995, I had the opportunity to work on a big project for Columbia University so started an IT consulting company.As owner and lead developer I worked on the following projects:- Columbia UniversityThe Richard and Hinda Rosenthal Center for Complementary and Alternative Medicine was set up to facilitate and conduct scientific investigation evaluating the effectiveness, safety and mechanisms of alternative and complementary practices. I developed their CRM application using FoxPro 2.6.- AAAA Benefits, Inc.AAAA Benefits, Inc is the benefits division of the America Association of Advertising Agencies. I developed a SQL Server 6.5 data model for maintaining the division’s main contact and member information, allowing for the administration of billing and collections of the health and life insurance plans provided to A.A.A.A. members. - Lending Tree LendingTree, one of the first online lending services, hadn't even opened its doors yet when I was brought in to develop both their internet and intranet sites to facilitate the granting and processing of loans using Visual FoxPro and SQL Server 6.5. - Bank of AmericaI helped design and development an intranet site using Visual Interdev and Active Server Pages against Visual FoxPro tables and a SQL Server 6.5 database that processed home equity loans around the country.- T.I IndustriesAs a producer of wooden picture frames, they used Visual FoxPro to control their 4 assembly lines which included gates, lights, scales and shipping labels. I was hired to make various improvements on the existing system. - NeoFax NeoFax developed Visual FoxPro software that provided a neonatal drug calculator and comparison interface and produced patient history reports and IV bag labels. I worked closely with the owner of Neofax on various portions of the application.I closed Steve Dingle Solutions in September 2002 to start a new venture in London, D&S Business Solutions.

N

I started as a data entry clerk in the benefits division entering insurance and retirement fund data such as health, disability, life, pensions and profit sharing, for members of A.A.A.A.I later became the manager of the department and sole developer of the in-house dBase II and FoxPro 2.0 system.My final position before leaving was Assistant Controller.I left A.A.A.A. in December 1994 to start my own IT consulting company, Steve Dingle Solutions.

New Jersey, Usa

In order for completeness, I list here the various jobs I held between the age of 14 and 25, in descending order.- Document Relocator- Alloys Amalgamator- Automotive Hygiene Engineer- Rapid Sustenance Provider - Current Events Periodical Distributor