SUMMARY:

• Data Scientist with 30 years of professional experience in system requirements gathering, designing database workflow procedures and developing SQL and Access databases. Sharp - shooter in identifying incorrect data and business processes to generate revenue.
• Develop Quality Assurance User Acceptance manuals and testing procedures. Create User Manuals for all systems developed and train clients on the use of the system. Manage client relationships. Generate significant revenue.

TECHNICAL SKILLS:

• SQL Server 2000
• 2012
• VBA Expert
• VB
• VB.net
• Microsoft Access Expert
• Microsoft Word
• Microsoft Excel Expert
• SSRS
• SSIS
• Microsoft PowerPoint
• SQL Query
• XML
• Jasper
• HTML
• Ad - Hoc Report Writing
• BIRT
• Java/JavaScript
• PHP
• MySQL

PROFESSIONAL EXPERIENCE:

Confidential

Mid-Level Contract Worker

• Acted as an evaluator for the Affordable Care Act applications, ensuring the applicants met the requirements for eligibility. Used SQL Server, Oracle, and Access.

Confidential

Data Scientist

• Currently working with Michael Lamb, City Controller to audit PWSA to meet my goal, correct water bills for the entire city of Pittsburgh.

Confidential

Data Scientist

• Hired by Pittsburgh Water and Sewage Authority to stop water bills in the millions from being generated, resulting in Rick Earle running news stories about the bizarre bills. A team of five developers spent two years trying to figure out how these bills were being generated. Took me 15 minutes to simply do a search of the database to find where that exact value of the one 4 million dollar bill repeated itself. Found that the customer service clerks were trying to search for a location id, a nine digit number, accidently typing that value in the amount due field.
• I then worked deeply with the Smart Meter Reader data. The results were stunning. 35% of the Smart Meters are either not sending signals or are sending a prior month with a higher reading than the current month.
• PWSA management requested that I put together solid data to have the current director removed from office. I was successful by pulling seven simple columns to show inept management and lost revenue.
• Was asked to identify high bills, in the $1,000 ballpark that were still being generated. I am trained to generate revenue, so I looked at the low bills, too. Uncovered millions in lost revenue and seemingly intentional withholding of bills not being generated. I put together a work flow of how the entire process was broken, from the worst SQL database I have ever seen in my life with no constraints, unique identifiers, and then diagrammed the “meter - read sent - bill generated - payment received - payment not received - deposit - pay Alcosan” business cycle. The results were short of horrifying.

Project Manager

Confidential

• Developing a mysql/PHP system to track installation of wireless towers nationwide. Writing triggers and stored procedures to cleanse data, sql import scripts to obtain external data. Developing Access system to document the database and for submission of design requests and problem tickets by end users.
• Programming the publication of reports from the PHP/MySQL system to SharePoint, emailing notifications to appropriate managers as each step in the installation process is completed.

Software Engineer II, Manager Special Accounts

Confidential

• Support seven clients with 45 SQL databases unique to each company. Manage helpdesk tickets, address helpdesk tickets requiring coding changes in Access versions 2000 - 2103. I successfully performed the system migration of four clients from SQL 2000 to SQL Server 2008SR2. Consult with the client IT teams to teach them how to configure and maintain their SQL databases, ensuring backups are scheduled and statistics are reviewed.
• Do extensive data integrity checks as the systems were poorly written, creating data integrity issues. Develop plans for correcting the errant data, create additional systems for correcting the data, and then correct the vba code or sql scripting to perform validation checks to ensure bad data cannot be entered.
• Manage help desk ticketing system. Receive tickets, assign analyst, monitor progress, and close upon acceptance from clients. Conduct weekly meetings with clients to review their open tickets and to discuss any issues or concerns with their systems.
• Currently converting 150 Jasper, Java Based reports, to BIRT, JavaScript based reports.
• As needed, work with R J Lee IT team to develop web based pages using XML.
• Obtain auditor rules for our systems to ensure that our clients will pass their twice yearly audits.
• Write classroom materials for the Carnegie Mellon University new hires and conduct classroom training in sql and basic database concepts.
• Used Salesforce to work with sales team in generating leads and supporting customers.

Senior Consultant

Confidential

• I was hired as a consultant to convert nine FoxPro databases to one SQL/Access database. I met with users gathering their business requirements, transferred the relevant data from FoxPro to SQL, and built a new SQL database and an Access interface. Heavy VBA coding involved in Access to establish security for the system. I also enhanced and fixed three existing Access databases. Developed user documentation for training; trained end-users.
• I wrote the Quality Assurance procedures for the system to ensure all auditing requirements were being met. Worked with the QA team in testing the system. Developed a comprehensive Audit Trail to track every value that was added, edited, or deleted by user, time, and form used to change the data.

Database and Systems Analyst

Confidential

• Company Microsoft expert, in charge of developing and maintaining all Microsoft SQL and Access databases for all departments. Interfaced with SQL server for daily production of management reports using Access or Crystal Reports as the front-end for reporting daily contribution statistics. Leveraged the power of SSRS for more complicated reports. Many users preferred Excel output of data; provided an option in all databases to output reports to Excel spreadsheets.
• Manager of data supplied by third-party company contributors that was provided in a multitude of formats, and integrated that data into our Andar CRM system through a series of data uploads. Used SQL scripting to automate each of our 163 third-party contributor’s data integration. Relied heavily on SSIS for importing the third party data, writing routines to parse the data into our SQL backend.
• Directed and executed the transformation from the existing Rainbow CRM application to the And a CRM application. Normalized the existing data, cleansed the data, imported into new CRM system. Trained the company on the new CRM system, then acted as support for the CRM system.
• I managed weekly reporting of contributions by organization, including historical tracking of data. As the climate of contributions changed.
• Prepared the yearly upload of external files of company data, which is comprised of employee information in preparation of company campaigns.
• Performed business analysis and lead projects impacting numerous lines of business.
• Created functional requirement documents and functional design documents.
• Facilitated walkthroughs with business users.
• Wrote SQL and Access databases for the company and our contributors such as Carnegie Mellon University, as needed; included user documentation training manuals and trained end-users.
• Coordinated our yearly audits, working with the auditors to provide the required data of pledges made, pledges actually received, and proof of the distribution of the contributions to the correct non-profit agency as designated by the individual.
• Identified corporate waste of revenue; our “take” from an individual’s contribution was to be 12%. Analyzing the data, I found our overhead was actually 21%. Resulted in the removal of our company president and the appointment of a new president to run this non-profit like a private business, generating revenue.
• Supervised two subordinates.

Database and Systems Analyst

Confidential

• Acted as an SQL and Access consultant for various Pittsburgh clients including Confidential, Confidential, Confidential, Confidential, and Confidential . Consulted with clients regarding their SQL/Access needs and developed their SQL/Access databases. Developed training manuals for their systems and trained the end-users on the use and maintenance of their system.
• At Confidential, analyzed their data and statistics that were developed by Carnegie Mellon University for creating “test questions” for employees and new hires. Found 27 incorrect formulas that affected thousands of employees failing a test, when in fact, they passed. I then automated the production of the tests booklets, eliminating $45,000 a year in printing fees as the client could now just print their own manuals.
• Worked with Big Machines at Confidential, streamlining the order flow process and dovetailing Oracle with report-writing software.
• Facilitated walkthroughs with business users.
• Converted high level requirements and workflow requirements into functional requirements and provided documentation for functionality, navigation and use cases.

Database and Systems Analyst

Confidential

• Worked as a contractor for the CDC as an SQL/Access programmer, developing their equipment database. Over 50 users were involved in the development and use of the system.
• Created functional requirement documents.
• Utilized SQL to conduct data sorts to established test parameters and conduct QA checkout.
• Responsible for Quality Assurance and Test Results.
• Appointed the sole contact for interacting with auditors that seemed to visit on a monthly basis, never failed an audit.

Systems Analyst

Confidential

• Functioned as SQL, Access, and Crystal Reports specialist in producing daily management reports detailing the number of calls that came into the call center. Wrote SQL databases as needed to track different segments of activity.
• Did statistical analysis of the alarm data being transmitted to the call center. Guardian had 57 call center clerks who were each assigned a geographical area. Identified 7 were taking smoking breaks and not covering their calls.
• Immediately put into place an “alarm” system for me to see if an alarm was tripped and the police were not called within 1 minute. A call from Upper St. Clair came in. The clerk was smoking. I put out a red alert to get the call to police in. No one listened; the woman was stabbed to death.