Resume

Sign in

Sql Server Customer Service

Location:
Summerville, SC
Posted:
February 26, 2016

Contact this candidate

Resume:

Todd Dickinson

**** ******* ****, #***

Ladson, SC

843-***-****

actpop@r.postjobfree.com

mailto:actpop@r.postjobfree.com

Talented Software Developer with extensive experience

successfully delivering effective solutions

SUMMARY OF QUALIFICATIONS

●Maximize organization’s investment in resources using structured analysis, data modeling, project management and information engineering techniques.

●Developed custom supply-chain solution that provides logistics planners with unique set of tools to manage a just-in-time production line sequence. System focuses on tracking key components in the assembly process, from manufacture in Germany and Spain, tracking component transport, monitor containers for detention and demurrage isssues, and tools to aid defining the daily production schedule to meet defined goals and other KPIs.

●Experience in providing front-line operations support and application development in a world-class manufacturing environment.

●Developed an advanced Business Support System (BSS) provisioning systems that integrated a wide range of devices with a telecommunications Customer Care software system. The solution was developed using several technologies, including C#, C, expert system (rule-base), SQL Server, and VB. Using IP-based communication devices, application securely communicated with devices nationwide.

●Provided customization and support to Dynamics CRM users. Developed complex integration between MS Dynamic CRM, MS Excel, MS Sharepoint and a third party Configuration, Pricing, and Quotation (CPQ) sales tool using Javascript, .Net, Web Services, WiX, VBA and ODBC. Responsible for the development of advanced management reports and dashboards utilizing Microsoft SQL Server Report Services.

TECHNICAL SKILLS

Programming:

C, C#, .Net, Visual Basic 5/6, VB.Net, MS-VBA, Visual Studio, Javascript, VBScript, OPS5/RuleWorks (Expert System), COBOL, PERL, Datatrieve, FMS Forms,T-SQL, IVR/Dialplan

Applications:

MS Dynamics CRM 4/2011, SQL Server Report Srvcs 2008 (SSRS), MS SharePoint, Asterisk, CAQ=QSYS

Databases:

MySQL, MS SQL Server, Sybase, db2/400

Platforms:

MS Windows Server, Linux, Redhat/CentOS, VAX/VMS, OS/400

PROFESSIONAL EXPERIENCE

Mercedes-Benz Vans Manufacturing, Ladson SC

2014 - Present

Systems Analyst, responsible for support of the daily operations of all production systems used for Engineering, Logistics and Production of Daimler Commercial Vans.

Designed and developed internal logistics scheduling solution to replace existing third-party applications. System allows the logistics group to exercise complete control over the order that a product line is built. Enhanced internal container management system to control the delivery, yard/lot assignment, unloading, and pickup of empty shipping containers.

Perform the troubleshooting and support of production critical systems needed for all aspects of vehicle production. Assembly line PLCs are directly managed by quality management system, product location is determined by a large number of video bar code devices and a large number of handheld scanners.

●Evaluated and implemented source code and version control systems within the organization.

●Developed, using an open source library, a reusable pattern that supports the automated generation and delivery of management reports, charts, and pivot tables as MS Excel spreadsheets with embedded VBA code modules.

Horry Telephone Cooperative, Conway SC

2007 – 2014

Senior Analyst, in the Commercial Applications group, for the nation’s largest telecommunications cooperative.

●Responsible for design, development, and support of several key applications that utilized Microsoft development tools; including Visual Studio 2007/2010 (C# & VB) .Net, C#, SQL Server, MySQL, and SSRS.

●Successfully delivered a stable, scalable CTI/IVR platform Asterisk, PERL, Java, and MySQL for accepting customer payments and generating outbound courtesy calls; processed almost 35,000 payments annually.

●Tightly integrated MS Dynamic CRM 4, SharePoint and a Configure Price Quote (CPQ) tool so that complex solutions can be consistently and accurately generated.

●Part of a team that made significant modifications to CRM 4’s entities, forms, triggers, plugins, and workflows.

●Using SQL Server Reporting Services, delivered reports, charts, and graphs to assist in managing all aspects of the sales cycle.

Communications Data Group, Champaign IL

1999 – 2007

Manager of Product Research & Development, for an established telecommunications solutions and services provider (e.g. Customer care, fulfillment, usage rating, and CABS)

●Extensive experience developing complex turnkey commercial applications that utilized Visual Studio 5/6 (VB, C# & C), .Net, SQL Server/MSDE, MySQL, TCP, and low level system libraries to create distributed applications. Client/Server architecture supported several different server platforms; from OS/400, Unix MySQL, to Windows SQL Server.

●Designed and led the team that developed advanced automated provisioning system; solution integrated OPS5 forward chaining rulebase module, configuration tables, with low level I/O routines. The product also had modules for facilities audit and ‘test drive’ marketing campaigns.

●Acted in the role of Sales Engineer and assisted the marketing group with the demonstration of products at sales conferences.

●Integrated video on demand and pay per view video systems with multi-platform customer care system. Purchases are mapped to standard charges with custom title descriptions and pricing.

●Developed application that supported the import of premium video event pricing, scheduling, and titles into several pay per view CATV headend vendors. Event purchase and preview windows driven by title based attributes.

●Managed group that made necessary changes to large mission critical legacy code base to support all date related calculations.

Communications Data Group, Champaign IL

1997 – 1998

Subject Matter Expert, Outside Plant, Facilities Engineering, Network Services

●Developed machine to machine interface, supporting several different formats and protocols using Visual Studio 5 (C & VB).

●Assisted software designers and developers by providing insight into the processes, technologies, and challenges facing large telecommunications providers. Reviewed designs and provided feedback to internal development support groups, including documentation, training, and marketing.

Hargray Telephone Company, Hilton Head Island SC

1993 – 1997

Analyst, Service Order, Outside Plant, Facilities Engineering, Network Services

●Designed and developed facilities inventory, management, and automatic assignment that accurately represented company’s physical outside plant design

●Improved customer service while reducing central office technician involvement during service disconnection/treatment process; reduced a weekly 30 man/hour process down to less than 4 man/hours.

●Enabled users, via a legacy COBOL system and low level API calls, the ability to directly review telephone switch activity.

●Introduced revolutionary process in which new residential customers could establish new service simply by plugging in phone and completing an application over the phone.

Hargray Telephone Company, Hilton Head Island SC

1986 – 1993

Programmer/Analyst, Service Order, Outside Plant, Facilities Engineering, Network Services

●Developed tools and utilities that allowed for the company engineers to manage the addition or changes to the cable and fiber facilities installed in the field. Engineers were also provided tools so that they could assign and control the records with the Enterprise CAD/Mapping system.

EDUCATION

Armstrong Atlantic State University, Savannah Ga

1982 – 1986

Bachelor of Science, Computer Science



Contact this candidate