Steve Farmer Email and Phone Number
Steve Farmer's Location
Atlanta Metropolitan Area, United States, United States
Steve Farmer's Contact Details
Steve Farmer work email
- Valid
- Valid
Steve Farmer personal email
- Valid
- Valid
Steve Farmer phone numbers
About Steve Farmer
Senior Data Analyst | Data Engineering & AI Solutions ExpertAs a Senior Data Analyst Engineer at Oversight Systems, I leverage over 20 years of experience in data analysis and engineering to drive transformative solutions in data analytics and AI. Passionate about converting complex datasets into actionable insights, I empower Fortune 100 companies to make data-driven decisions and optimize operations.Cloud Migration Expertise: Played a key role in a critical 18-month project migrating on-premise Oracle systems to cloud platforms including AWS, Databricks, and Snowflake. Utilized DBT for data transformation and modeling, ensuring seamless integration and enhanced performance.Data Engineering & ETL: With deep experience in ETL processes, I design and manage data pipelines for large-scale data ingestion and processing. My extensive knowledge of SQL and Python has been instrumental in optimizing database performance and maintaining data integrity.AI Innovations: Developed AI-powered solutions to enhance operational efficiency and decision-making. Created a chatbot using the OpenAI API and integrated OpenAI technologies into a Django-based website, showcasing proficiency in leveraging AI for practical applications.Business Intelligence & Visualization: Proficient in Tableau and Looker, I create interactive dashboards and reports that provide valuable insights for stakeholders. My work supports data-driven strategies across finance, sales, and client success teams.Collaboration & Leadership: Partner with diverse teams to build data models and reporting structures aligned with business objectives. I mentor junior analysts and contribute to team success by promoting best practices in coding standards and data analysis methodologies.Core Competencies: Data Engineering & Analytics: SQL (20+ years), Python, Databricks, Snowflake, AWS ETL Processes & Automation: DBT, Bash Scripting, Linux AI & Machine Learning: OpenAI API, Django Integration Business Intelligence: Tableau, Looker, Data Visualization Fluent in English, German, and French, my career is marked by roles and consulting engagements with global leaders in the energy and utilities sectors. I bring a global perspective and exceptional communication skills to every project. Dedicated to continuous learning, I stay at the forefront of industry trends to drive innovation and deliver impactful results in data analytics.Let's connect to explore how my skills and experience can contribute to your organization's success.
Steve Farmer's Current Company Details
Steve Farmer Work Experience Details
-
Data Analytics EngineerOversight Systems Oct 2018 - PresentAtlanta, Ga, UsAt the forefront of innovation in data systems, I am currently spearheading a critical initiative to standardize and upgrade our company's data infrastructure. In my role as a Data Analytics Engineer, I focus on harmonizing disparate systems to a unified codebase, ensuring that all systems operate seamlessly on the same version. My key responsibilities and achievements include:• System Standardization Leader: Orchestrating the transition of multiple systems to a consistent version, enhancing system interoperability and performance.• Automation Pioneer: Utilizing my expertise in SQL, Bash, and Python, I am developing sophisticated automation solutions to streamline operations and increase efficiency.• Technical Training & Mentoring: Actively involved in training new team members and offshore personnel, imparting crucial technical skills, and fostering a culture of continuous learning.• Technical Documentation Specialist: Creating detailed, user-friendly technical documentation in Confluence, making complex information accessible and understandable for diverse audiences.• Cross-functional collaboration: Working closely with various departments to ensure seamless integration and implementation of new system upgrades.• Legacy to Latest: Leveraging my deep understanding of AI, I am instrumental in transforming legacy systems into cutting-edge, AI-driven platforms.• Data Engineering Expert: Continuously applying my SQL mastery in designing and executing efficient data processes, maintaining optimal database performance.• Innovative Problem Solver: Combining my knowledge of Oracle SQL, Django, and Python to craft custom solutions that address unique business challenges.
-
Implementations SpecialistItsmorethansoftware Llc Apr 2005 - Oct 2018Provide consulting services specializing in applications design, development, and implementation of custom Oracle Utilities/LODESTAR solutions for diverse utility and energy sector clients. * Provide hands-on leadership, applications development, and coding for large-scale engagements and global projects with budgets ranging from $5 million to more than $100 million and teams of 12-50 multi-disciplinary staff. * Collaborate with client stakeholders, analysts, and department heads to clarify business/functional requirements and establish engagement goals. * Define and deploy roadmaps and priorities in alignment with overarching client objectives, project scope/ specifications, deadlines, and quality/regulatory requirements. Perform extensive programming and solutions architecture across all phases of SDLC. * Demonstrated strength in capturing critical data, utilizing XSLT and xPath, setting up JMS servers, generating rules language reports, developing data models, creating dashboards and integrating with various databases.
-
Services ConsultantTeamquest Corporation Oct 2015 - Feb 2017
-
Senior ConsultantDuke Energy Corporation Mar 2015 - Sep 2015Charlotte, North Carolina, UsTapped to update Oracle Utilities as a vital component of company's high profile ENRB Project. Created and enhanced Rules Language code. Modified Oracle Utilities frond end, expanding functionality to allow client submission of custom forms. -
Oracle Utilities Implementation SpecialistAmeren Jan 2014 - Jun 2014St. Louis, Mo, UsEngaged by the largest electric utility in Missouri for this 6-month implementation vital to daily finance/billing operations, data/information security, and compliance with strict industry regulations.* Built custom front end screens to create interval data using rules language.* Created adapters to capture complex pipeline data from various sources, FTP, Files, and Web Services. Utilized XSLT and xPath for data manipulation.* Setup JMS servers, and generated rules language reports to create data cuts. Established custom security permissions for custom pages. -
Senior Software EngineerAltagas Utilities Inc. Jan 2013 - Dec 2013Enlisted for 12-month engagement and charged with single-handedly driving full lifecycle architecture of custom Gas Nomination System from the ground up for AltaGas Retailers, utilizing Oracle Utilities backend and custom SQL packages for all transactions (https://settlementagutl.com). * Created dashboard for LODESTAR LPS application, developed complex rules language reports for extraction of meter data, and produced nomination portal for all retailers in C#.* Instrumental in development of backend data model and mappings using Oracle 11g.* Won enthusiastic praise for achieving all project deliverables on time under aggressive deadlines, with superior quality and zero business disruption.
-
Oracle Utilities Implementation SpecialistPraxair Apr 2012 - Sep 2012Danbury, Ct, UsRecruited by the largest industrial gases company in North and South America for complex, 6-month project aimed at installation and configuration of LODESTAR 1.6 Customer Choice Suite applications on development environment. Implemented SQL Server 2008 for use with LODESTAR application. * Created data models and mapping, and built complex billing outbound process in Rules Language.* Increased efficiency and productivity by developing rules language program that deletes all meter reads older than 3 month. Formulated complex consumption calculation in rules language. -
Oracle Utilities Implementation SpecialistCobb Energy Jul 2011 - Nov 2011• Installed MDM 2.0 framework, weblogic, Oracle DB, Oracle OSB, Oracle SOA and all supporting application on windows 2008.• Created complex Java programs to transform incoming variable length CSV files into XML• Using Oracles SGG I setup various OSB processed to transform the xml files into IMD records that were then ready for import into MDM
-
Oracle Utilities Implementation Specialist (Lodestar)Northeast Utilities Nov 2010 - May 2011Hartford, Connecticut, UsBrought in to jumpstart and steer large-scale Oracle Utilities/LODESTAR implementation for New England's largest utility system. Triggered immediate and measurable improvements in cost-efficiency, productivity, and data accuracy/integrity across core business functions through process automation, consolidation, and expert level coding/programming of industry leading technologies.* Wrote complex ASP.NET C# pages for calling web services to retrieve/send critical information to and from other systems. Enables automated consolidation and presentation of incoming data from both local sources and external web services data.* Authored innovative assembly in C# (com component) to enable seamless utilization of various web services from within Rules Language. Created Rules Language code to consume the assembly and return information from the web services.* Wrote C# page to mass update thousands of records at once while notifying user of any records changes.* Developed page to enable manual creation of work queue and associated service order if needed.* Utilized sniffer tool to ensure accuracy and validity of requests and information returned via web services. -
Oracle Utilities Implementation Specialist (Lodestar)Enernoc Aug 2009 - Oct 2010Boston, Ma, UsEnerNOC, Inc. August 2009 – October 2010Implementation Specialist• EnerNOC is a curtailment service aggregator that helps commercial, institutional, and industrial organizations use energy more efficiently as they participate in ISO and LDC Demand Response programs through a technology-enabled energy management solution. • Gathered design specifications for Release 1 integration and implementation of Oracle Utilities Billing Component with Financials system.• Wrote rules language to generate CSV and XML files, data validations and overall business logic. • Developed a rules language based interface to extract interval data and convert it to UTC based on correct time zone and create output file for requesting system.• Created a complex real time system to move meter data from the Oracle Utilities platform to the client’s system.• Developed C# web service calls within ASP.NET to create and update location and registration records in PJM’s eLRS (electronic load response system) for participants in both emergency and economic demand response programs.x web services from ASP.NET pages written in C# -
Implementation SpecialistTransalta Feb 2009 - Jul 2009Calgary, Alberta, Ca• Developed front-end screens for shadow billing processes. The user is able to see quickly which processes have failed, and are then able to execute them directly from the custom user interface.• Created custom screens to submit configured Rules Language processes. The user select individual processes and adds all necessary parameters.• Developing customized reporting screen where the user is able to view any type of report (PDF, Crystal, Excel, Word) that the user has kicked off from previously within the Oracle Utilities Energy Information Platform, based on custom processes.• Developed a fully dynamic Process Management Console using AJAX. The user will be able to see any process changes as they happen in real time. Several links are available for the user to go directly to a chosen report, therefore bypassing the view reports screen all together. User can also add notes, finalize a process and start a stored procedure to delete related processes, all that with just one click.• Secured custom application by adding new features into the existing security model, allowing administrators to turn on or off each custom screen.• Added a new data entry interface, written in AJAX, to enable the user to view Master/Detail records and add/update/delete in one screen as many records as they need to. The interface features a familiar excel look with many of the same features. -
Asp DeveloperExelon May 2007 - Jan 2009Chicago, Il, UsRecruited by this leading retail energy marketer to enhance functionality of Oracle Utilities Application Contract Management and Pricing Modules. Developed 150-200 user-friendly application server pages (ASP) that display custom client data and simplify complex database queries; dramatically improved and accelerated decision-making process related to contracts and pricing. * Customized and built business critical screens such as "Electric Pricing Checklist" and "Contract Quantities" that will call Oracle Utilities Rules Language as well as generate and display Crystal Reports.* Customized multiple navigation menus using XML, ASP, and custom views against the database.* Technologies used for development include ASP, Jscript, JavaScript, XML, XSL, XSLT, XSD, PL/SQL. Tools include Dreamweaver CS4, Toad 9.x, EditPlus 3.0 and Oracle 10g. -
Senior ProgrammerKimberly Clark Dec 2005 - May 2007Irving, Tx, UsResponsible for primary support of a sales application CRM written is ASP with SQL server database including problem solving individual requests from sellers through an issue ticket system with a guaranteed 8 hour turnaroundLead resource for updating functionality for the sales application.Recommend strategies for improvement (example: upgrading several parts from ASP to ASP.NET using VB.NET. )Participated in Kimberly-Clarks outsourcing initiative -
Senior Web DeveloperFlint Industries Sep 2000 - Aug 2005Converted Flintco Intranet with the new .NET languages (VB.NET). Also wrote a windows Tablet PC application in VB.NET for our project managers. The application is used to quickly record hand written entries into a database backend. The records can later be used to create reports for contractors. Created a web based helpdesk solution for our support staff. Tickets and be submitted and monitored by the user, system is fully automated with a SQL Server backend. It sends out automated emails to the support staff and the user respectively. Responsible for creating a web presence for the Flint Companies, www.flintco.com. Also created a project specific site that is fully dynamic, SQL Server 2000 backend, combined with a Sybase DB. Front pages randomly pull different projects from database. Secure access has been created for owners and project managers. Pages have been written in ASP with some JavaScript and HTML.
-
Senior AnalystSabre 1998 - 1999Southlake, Texas, UsSenior ConsultantResponsible for creating an Intranet site for the Change and Problem management department. The project consistsof getting all changes and problems, which are in an Oracle database, out on the intranet with query capabilities forvarious users. On the fly reporting tool, charting and notifying users electronically over the web. Became familiarwith project management. Tools used: Visual Interdev 6.0, Visual Basic 5.0, JavaScript , VBscript and HTML -
Web DeveloperBerendsen Fluid Power Mar 1998 - Aug 1998Tulsa, Oklahoma, UsResponsible for creating a financial Intranet. Created dynamic financial charts based on live databases using Visual Interdev, VBscript and JavaScript to code the active server pages. Worked with little or no supervision under a tight schedule to meet deadlines. Also created online forms for the company which management can approve online through a virtual signature. Added the company policies and procedure manual onto the intranet as well as many other company materials. -
AnalystWorldcom 1995 - 1998Assignment: Writing and maintaining the Trouble Ticket Management application for use over the Intranet. Tools used: FrontPage '98, CGI, Perl 5.0, Visual Basic, Visual InterDev 1.0.Developed and implemented a Trouble Ticket management system in Powerbuilder 5.0. Responsible for identifying, investigating and resolving production problem issues. Extensive experience creating data queries across mainframe, AS/400, Unix and PC SQL platforms. Responsible for developing customized reports from various data output. Performed research and analysis to identify and interpret traffic patterns. Also, served as a member of the beta testing group for Andyne GQL and Microstrategy DSS Agent query tool for a multi-billion records data warehouse. Responsible for training new employees on various applications.
-
Computer OperatorBergen Brunswig Sep 1994 - Nov 1995Solely responsible for AS/400 operations to assure that all billing and order entry processes were running correctly and to make adjustments to the system as needed. Accountable for ensuring that all invoices and labels were distributed to the correct customers for this multi-billion dollar company. Assisted with set up of customers PC's for order entry. Achievements led to a promotion to Operator II within one year of being hired.
Steve Farmer Skills
Oracle
Integration
Xml
Sql
Pl/sql
Web Services
Software Development
Databases
.net
Programming
Visual Studio
Unix
Web Development
C#
Oracle Utilities Mdm
Asp.net
Java
Javascript
Middleware
Ajax
Xslt
Html
Visual Basic
.net Framework
Active Server Pages
Development
System Migration
Rules Language
Oracle Pl Sql
Lodestar
Asp
Eclipse
Wordpress
Ouaf
Soa
Xsl
Xpath
Steve Farmer Education Details
-
Bryan Institute TulsaProgramming -
Freie Universität BerlinComputer Science
Frequently Asked Questions about Steve Farmer
What company does Steve Farmer work for?
Steve Farmer works for Oversight Systems
What is Steve Farmer's role at the current company?
Steve Farmer's current role is Data Analytics Engineer @ Oversight Systems | Data Engineering & SQL Mastery.
What is Steve Farmer's email address?
Steve Farmer's email address is fa****@****ail.com
What is Steve Farmer's direct phone number?
Steve Farmer's direct phone number is +177058*****
What schools did Steve Farmer attend?
Steve Farmer attended Bryan Institute Tulsa, Freie Universität Berlin.
What skills is Steve Farmer known for?
Steve Farmer has skills like Oracle, Integration, Xml, Sql, Pl/sql, Web Services, Software Development, Databases, .net, Programming, Visual Studio, Unix.
Free Chrome Extension
Find emails, phones & company data instantly
Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Aero Online
Your AI prospecting assistant
Select data to include:
Total price:
$0.00
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial