Sheri Scott work email
- Valid
Sheri Scott personal email
Sheri Scott phone numbers
Sheri Scott is a Software Engineer at Nurse-Family Partnership. She possess expertise in sdlc, oracle, databases, requirements analysis, business analysis and 7 more skills. Colleagues describe her as "Sheri was a pleasure to work with during the ERCOT project personally and professionally." and "Sheri was my LodeStar developer at the Electric Reliability Council of Texas and helped in the development of the Texas Nodal Program, a new system for running the state's electricity grid. Sheri demonstrated incredible initiative and strong dedication in assisting me in the development of the area of Congestion Revenue Rights (CRR), financial instruments used to hedge congestion costs when the transmission grid becomes congested. Sheri developed and successfully implemented LodeStar code used in the settlement and billing process of CRRs, and has been quick to expand her conceptual and working knowledge of CRRs as well as various areas of the electric energy industry. Always quick to help others, Sheri has been a vital source of information from various groups within our organization. Always positive, and no doubt highly intelligent, she is enthusiastic, cheerful, and a pleasure to work with. As a member of various working groups, she has worked hard to build relationships with her co-workers, and has helped to create a happier and more productive team. It is for these reasons that I offer high recommendations for Sheri without reservation."
-
Sr Information Systems AnalystNurse-Family Partnership Oct 2015 - PresentDenver, Colorado, UsSet up new Help Desk support system in Salesforce Service Cloud with custom console and Apex triggers. Re-engineered SSIS package that generates monthly data extract files for multiple health care implementing agencies nationwide to make the extract files HIPAA compliant based on current agreements between NFP and the recipients of the data files. Fully automated the monthly data extracts via SQL Server Agent job. This automation involved adding a new linked server to the source database server, replacing all instances of drive letters with full paths to multiple locations on source and destination servers in the SSIS package and the Windows batch scripts. Configured sFTP sites in IIS for new data extracts. Created and implemented a new database level roles based on group access levels. Created database template for setting up new agency databases. Documented current information systems architecture in preparation for conversion to a Corporate Information Factory (CIF) architecture using Visio, Word, Excel, and Sharepoint. Participate in the planning and design of the CIF architecture. Tier 3 technical support. -
Developer/Data AnalystCenturylink Aug 2014 - Jul 2015Monroe, La, UsLoaded Pricing data into the Salesforce database using the Salesforce DataLoader tool and various other tools to analyze, manipulate, and prepare the data for loading it into the database. These tools included Oracle SQL Developer, MS Excel, MS SQL Server, and MS Access. With DataLoader I was able to write custom queries to perform inserts, upserts, exports, and deletes to and from .csv files I had prepared. Pricing consists of 20+ tables/objects that had to be loaded properly in order for the CenturyLink products/bundles being sold to appear correctly in the CenturyLink Quick Pricing web application. I used vlookup and various other Excel functions, macros, and Visual Basic code I had developed to prepare the data for loading. I use several other components of Salesforce for data analysis, code analysis, and unit testing. I documented the Pricing database schema, the Pricing data loading process, and troubleshooting tips using MS Word and Visio. We utilized Agile methodologies for planning, grooming, and tracking all projects. -
Sql DeveloperEmpereon Marketing May 2013 - Feb 2014UsWrote and modified several stored procedures and functions in MS SQL Server, Developed and modified several SSRS reports. -
Applications DeveloperLiberty Power Apr 2011 - May 2013Fort Lauderdale, Fl, Us.Net applications developmentSQL Server database developmentBI Publisher Report development -
Database EngineerPower Tagging Technologies Jun 2010 - Apr 2011
-
Pl/Sql, Lodestar DeveloperErcot Jan 2009 - Jul 2009Taylor, Tx, UsAccomplishments as an applications developer on the Advanced Metering project:• Developed PL/SQL packages, functions, procedures, and triggers; • Modified existing Lodestar 4.7 Rules Language according to requirements;• Incorporated Parent and Custom attributes logic in Lodestar Rules Language to improve memory management for processing large volumes of data; • Contributed to database design and parallel processing solutions;• Worked with the team database architect to develop optimal processing logic in PL/SQL to handle large volumes of data in a timely manner and code a solution in PL/SQL for database deadlock issues encountered when creating dynamic partitions for parallel processing;• Researched and resolved an issue with inconsistent output from one package by locating white paper for an undocumented Oracle 10g PL/SQL bug involving the use of optimization level 2 along with global variables and the sleep function, and modified my code to be independent of optimization levels;• Performed full development life cycle testing;• Documentation (Detail Design, Use Case). -
Powerbuilder DeveloperTransfirst, Llc Jun 2008 - Jan 2009Developed and maintained the Ontrak system. Ontrak is an inhouse system developed and used by TransFirst to conduct their core daily business operations. My duties consisted of developing new components and enhancements to the Ontrak system and performing maintenance on existing Ontrak applications. As a prominant member of the Efficiency Improvement Team (EIT) at TransFirst, I was responsible for indentifying, researching, developing, and deploying resolutions to inefficiencies in the Ontrak system. Within nine months of the onset of the team, EIT was able to increase the efficiency of the merchant application boarding process by 35%.
-
Pl/Sql, Lodestar DeveloperErcot May 2007 - May 2008Taylor, Tx, UsAccomplishments on ERCOT Nodal Project:• Wrote rate schedules and riders in Lodestar Rules Language to be used for the Real Time Congestion Revenue Rights (CRR) calculations. • Set up a Time of Use schedule for CRR in accordance with documented protocols.• Wrote several stored procedures in Oracle 10g PL/SQL, e.g. GETINTD pulls specific interval data and the associated header records from the database, parsing the blob containing the interval data into a float value for each interval in the time period; TOU calculates Time of Use hours for CRR; and CARD calculates CRR Auction Revenue Disbursements including revenues, bill amounts, and bill totals. All of these stored procedures utilize Associative Arrays, Collections, and Varrays in lieu of cursors for optimal performance. TOU is packaged with CARD. The package is called by a Lodestar rate schedule.• Proficient in CVS and Eclipse for version control, SharePoint for document management, and Mercury Quality Center 9.0 for tracking project status between functional areas and for tracking Lodestar and metadata issues.• Compiled the System Architectural Design document of all the Lodestar and PL/SQL development for the Nodal project. This document is visible to Market Participants and the public via the ERCOT Nodal Project website.• Wrote procedures for accomplishing a clean install of Oracle 10g client.
-
Powerbuilder DeveloperTransfirst, Llc Aug 2006 - May 2007Development, enhancements, and maintenance of the OnTrak System using full life cycle project management disciplines. All development in the OnTrak System involved heavy use of stored procedures, user objects, and inheritance.• Added functionality to the AppTrak library of OnTrak to automate the Discover card merchant application process. This project required the creation of 5 new tables in the MS SQL Sever databases; 1 new window, 1 new data pipeline, 2 new datawindows, 9 new functions, and 7 new powerscripts, as well as enhancements to 2 existing powerscripts and 4 existing datawindows.• Enhanced the TerminalTrak library by adding a new point of sale terminal report which required a new datawindow.• Added a vendor code entry and display box to the AppTrak library.
-
Programmer AnalystIbm Global Services Apr 1996 - Jun 2001Armonk, New York, Ny, UsDevelopment and maintence on systems used to support the XCEL Energy account. Languages included but were not limited to LodeStar, PL1, PowerBuilder, Cobol. Databases: DB2, Sysbase SQL Anywhere, Oracle. All projects required full system development life cycle compliance.• Remotely led four new team members in development and delivery of new Lodestar 3.8 billing processes after XCEL Energy acquired Southwest Public Service Co. to integrate Southwest customers into the XCEL Energy environment.• Facilitated formal Lodestar Billing Expert training for Southwest team members by procuring the training facility, installing Lodestar Billing Expert and Oracle on the workstations, verifying accessibility for each user, and arranging travel and lodging.• Designed new Lodestar Billing Expert rate scripts to be integrated into the existing XCEL Energy production billing system while acting as a mentor to Southwest team members.• Analyzed Southwest customer data and integrated it into the XCEL Energy environment.• Migrated new rate scripts to production in accordance with the effective dates of the various rates and verified proper billing after migrations.• Participated in 24x7 CIS on-call rotation.• Responsible for full life cycle project management for all assignments over 40 hours. -
Programmer AnalystXcel Energy Jun 1984 - Apr 1986Minneapolis, Minnesota, Us• Developed and maintained a variety of mainframe and object-oriented applications to support the Rates and Regulatory Services department at XCEL Energy for use in rate studies, rate design, and rate case filings with the Public Utilities Commission.• Developed and/or maintained six PowerBuilder applications starting in version 4.5 and ending up in version 7.0. These applications accessed a Sybase SQL Anywhere 5.0 database server. • Responsible for Sybase SQL Anywhere 5.0 database installation and administration.• LAN administrator for a 75 node Novell NetWare local area network.• Played a major role in converting from Novell NetWare to a Microsoft Windows network as a LAN administrator.• Converted all mainframe RDA applications to access customer information from DB2 rather than the legacy VSAM data files by embedding SQL queries into the code.• Performed data integrity verification by writing, executing, and monitoring complex SPUFI and QMF queries during the CIS conversion from VSAM to DB2.• Performed Y2K certification on all Rate Data Analysis applications.
Sheri Scott Skills
Sheri Scott Education Details
-
University Of Wyoming
Frequently Asked Questions about Sheri Scott
What company does Sheri Scott work for?
Sheri Scott works for Nurse-Family Partnership
What is Sheri Scott's role at the current company?
Sheri Scott's current role is Software Engineer.
What is Sheri Scott's email address?
Sheri Scott's email address is sh****@****hip.org
What is Sheri Scott's direct phone number?
Sheri Scott's direct phone number is +130332*****
What schools did Sheri Scott attend?
Sheri Scott attended University Of Wyoming.
What skills is Sheri Scott known for?
Sheri Scott has skills like Sdlc, Oracle, Databases, Requirements Analysis, Business Analysis, Microsoft Sql Server, Pl/sql, Database Design, Sharepoint, Business Intelligence, .net, Data Migration.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
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