SQL Server Developer
Resume:
James Stevens
***@*******-******.**
https://www.linkedin.com/in/jgstevensiii
SUMMARY
Seasoned IT Professional with extensive experience in analysis, design, and development of critical global projects focused on innovative design, data architecture, and code development. Skilled in direct customer interaction driving the analysis and design of SQL database solutions that exceed customer expectations. Broad spectrum background in system and database administration in manufacturing, finance, and DOD work environments.
TECHNICAL SKILLS
Database Technologies: SQL 2012/2008R2/2005, SSRS, SSIS, DTS, TSQL, SQL 2005, Oracle 11g, Oracle 9i Certified DBA
Platforms: Windows, Unix, Windows Server
Technologies: SQL Server Management Studio, SQL Server Data Tools, Visual Studio 2013/2008, Team Foundation Server, C#.NET, VB.NET, SharePoint 2010, JavaScript, XML
Processes: SOX Audit, Software Development Life Cycle - SDLC
PROFESSIONAL EXPERIENCE
ACI WORLDWIDE, Norcross, GA March 2014 - Present
.NET / SQL Developer
Customize, document, and support and document system integrations and installations for online banking products using SQL 2008, C#, Visual Studio 2010.
ING INVESTMENT MANAGEMENT, Atlanta, GA August 2013 – March 2014
SQL Developer - Contract
Analyze and develop complex, audit-ready ETL processes in the Data Warehouse environment using T-SQL, stored procedures, and SSIS packages in SQL 2012/2008 r2, SSRS, Visual Studio 2013, SQL Server Data Tools, and Team Foundation Server 2012 for the financial services industry
BBDO (BATTEN, BARTON, DURSTINE & OSBORN), Atlanta, GA June 2011 – August 2013
SQL Developer
Analyze and develop front and backend software solutions for print media authoring and workflow management application that processes some 1,000 advertisements a month using SQL 2008 r2, SSRS, C#, ASP.NET 3.5, Visual Studio 2008, VisualSVN, TortoiseSVN, and other Open Source tools.
Lead programmer for SharePoint 2007 to SharePoint 2010 migration of custom media manager application for television, radio, and print ad media assets using SQL 2008 r2, C#, Visual Studio 2010.
Administrator for SharePoint 2010 farm
GENUINE PARTS COMPANY, Atlanta, GA Sept 2010 – June 2011
SQL Developer/ SQL Admin – Manage and develop database projects for Catalog IT organization
Analyzed, designed and developed custom web based, n-tiered, and discrepancy workflow system for parts catalog data with a monthly traffic of over 1,000 cases using OOP programming pattern. Cases connected the person behind the counter with the distribution center, data analysts, management, and suppliers to drive the quality of the catalog thus driving sales. Technologies used include SQL 2008 r2, SSIS, and Oracle 11g.
Full SDLC on project for custom media distribution software solutions to meet the needs of Distribution Centers and parts stores for Material Safety Data Sheets using SQL 2000, SQL 2005, SSIS, DTS, and Oracle 11g, drawing specifications directly from the customers
Extended Material Safety Data Sheet project above to a web form that would emulate the distributed solution using MS/SQL 2000/2005, SSIS, DTS, and Oracle 11g, drawing specifications directly from the customers
INDEPENDENT IT CONSULTANT, Woodstock, GA 2009 – 2010
SQL Developer (Jan 2009 – Sept 2010) for Emergency Visions - Contract
Design, develop, document, and implement custom database solutions to meet the needs of new customers for sales demonstration, training, and production using SQL 2005, VB.NET, ASP.NET drawing specifications directly from the customers
Managed migration project for major customer from a hosted environment to a customer based system
Development of highly customizable dashboards allowing greater flexibility in meeting customer reporting needs using SQL 2005, .NET
SQL Developer (April 2010 – Aug 2010) for Electronic Education Documentation Systems - Contract
Development of T-SQL scripts and stored procedures for management and audit of customer data in SQL 2005.
Database Administrator (Feb – Mar 2010) for ProcareRx
Database administrator for pharmacy benefits manager program Data Warehouse using SQL 2005, SSIS, and RedGate Software.
Developed web portal databases for pharmacy benefits manager program using SQL 2005, TSQL, VB.NET, Visual Studio 2008, and Infragistics .Net controls. Projects required requirements gathering and analysis from the end users through implementation packaging of n-tier OOP solutions.
.NET Developer (Jan – Feb 2010) for IBM - Contract
Development resource for bank divestiture project doing software analysis and conversion planning. Gathered specifications from customer meetings as input to project plan.
HEWLETT-PACKARD COMPANY, Atlanta, GA 1988 – 2009
Senior IT Developer/Engineer (2007 – 2009) – development/support functionality to Global Employee Financial organization
Eliminated costly manual SOX audit process by designing and developing an automated process using VB.NET and UNIX scripting for the payroll application reducing the teams workload by one person-week a month
Improved employee satisfaction and increased processing efficiency by designing and developing a centralized higher education request n-tier OOP application that maintained requests for some 95,000 employees globally using SQL 2005, SSIS, C#.NET, ASP.NET, and Windows/UNIX scripts
Reduced the number of escalated support calls more than 75% by developing and deploying internal web sites in North and South America using SharePoint, .NET, and HTML and by training and mentoring the offshore L2 support team. Received upper management recognition and a monetary bonus for the efforts
Saved the company approximately $6,000 a week in rebate processing costs by developing components of an external facing web application that allowed customers to do their own data entry for rebate requests using SQL 2000, ASP, VB, and JavaScript
Reduced operating costs and increased efficiency by designing and developing a global, centralized inter-company billing application using SQL 2000, ASP and VB that replaced manual, country specific billing processes
Senior Technical Analyst (2000 – 2007) – development / support for financial applications
Managed a host of financial application databases in SQL 2005 and Oracle 9i
Technology used: SQL 2005, DTS, ASP.NET, VB.NET
Reduced escalations from L3 to L4 support from seven to less than one a month by aggressive root cause analysis and proactive support processes to meet the Time To Fix requirements of the payroll application Service Level Agreement
Reduced support costs and application downtime by designing and implementing an automated, auditable, Move To Production process for the payroll application replacing an intensely manual process and saving two or more hours of support time per Move
Increased team efficiency and morale by developing and delivering application specific training to offshore teams in person. Was recognized by management for this above and beyond effort with a bonus.
Increased team efficiency by actively mentoring support staff and by developing best practices designed from a data center / developer perspective
IT e-Services Development Staff (1999 – 2000) – financial applications developer
Technology used: SQL 7, DTS, ASP, VB
Database Developer and Administrator for development team; modified and created new Oracle and Microsoft SQL databases and translated Turbo Image design to RDBMS design.
Created financial applications using ASP, VB, and JavaScript to process invoices to the general ledger and to bill location for non-trade transactions, instrumental to boosting efficiency.
Strategically designed, developed and executed an application to centrally process non-revenue transactions for the company world-wide to feed a legacy database application with 10 to 50 hits on a weekly basis expected including translation interface on HP3000 in COBOL, integral to streamlining operations.
IT Engineer (1995 – 1999) – System Manager for NT and MPEiX systems
Technology used: operating system tools and utilities
Recognized by management for leadership skills in developing and implementing a training program for 400 non-technical people to disassemble and reassembling a data center consisting of some 600 servers moving 10 miles down the road.
Steered physical space planning, power requirements and testing power, network requirements and testing connectivity, and console and ancillary equipment considerations, with strong focus on optimizing productivity, efficiency and performance.
To appropriately manage a fast-growing team, created and developed incident tracking system on a HPUX server using UNIX utilities and UNIX scripting for System Administrator Team.
Technology Specialist (1988 – 1995) – Operating System Specialist
Saved the company substantial time and labor costs by packaging operating system releases saving an average of 50% of downtime per system for the entire Eastern Sales Region
PRIOR PROFESSIONAL EXPERIENCE
BALTIMORE AIRCOIL COMPANY, Jessup, MD
Database Administrator - Managed and maintained large scale manufacturing databases
USG/DONN CORPORATION, Westlake, OH
Technical Support Manager - Managed operators and technical support staff
EDUCATION
Associate of Arts, Information Systems, Anne Arundel Community College, Arnold, MD
Associate of Arts, Fire Protection, Catonsville Community College, Catonsville, MD
TECHNICAL CERTIFICATIONS & PROFESSIONAL DEVELOPMENT
Oracle Certified Professional, Database Administrator
Microsoft Certified Application Developer (MCAD), Certified Solution Developer (MCSD)
Continuing Education Courses: XML, JavaScript, HTML, ASP, Situational Negotiation, Seven Habits, Supporting Microsoft NT Server, Constructive Contention, Unix System Administration, Working in Groups, MPEXL System Management, System Optimization and Performance
COMMUNITY ACTIVITIES
Firefighter/EMT – Anne Arundel County Fire Dept., Fire Line Officer, EMT, Trainer
Contact this candidate