Resume

Sign in

Sql Server Developer

Location:
St. Louis, Missouri, United States
Salary:
$50/hour W2 6 months contract
Posted:
March 07, 2018

Contact this candidate

PROFESSIONAL SUMMARY

Senior Programmer / Analyst, Software Developer: APIs, CDNs, CMS, Front-End, UI/UX & Back-End Database / Cloud Applications and Web Services. Effective Project Leader / Supervisor / Manager and Technical Lead Developer in a variety of business service fields. Programming strengths lie in the areas of .NET – ASP, C#, VB, Silverlight, XAML, .NET Framework & IIS, Java – JAR, JSP, C/C++, DaaS, PaaS, SaaS, Perl(CGI, DBI), PHP, LAMP / WAMP(Linux / Windows, Apache, MySQL, Perl/PHP/Python), Python, PL/SQL, SQL, NoSQL, AJAX / Javascript / JS Frameworks, HTML5, CSS3, Flash / Actionscript / Flex / Yii, XML, XSLT, WML, WSDL / REST / SOAP. Expert Search Engine- Marketing (SEM) & Optimization (SEO) Evaluations and Tools development. Certified ‘White Hat’ Ethical Code Hacker - who is Proficient at Programming, Scripting, Automation, Penetration Testing, Security, Quality Control, Valid W3C Standards.

CORE COMPETENCIES

Databases: Access, Adabas, ADR-Datacom, Aurora, Azure, BBX, Borland Database Engine, Condor, CouchDB, Dbase3/4/5/FoxPro, DB2,

DynamoDB, Informix 7.2/9.3/10, Ingres, MariaDB, MongoDB, MS-Jet, MySQL, NoSQL Cloud, Oracle 8i-11g-12c, Paradox, Pervasive,

PostgresSQL, Progress, Prolog 6/6.5, SQL Server 7/2000/2005/2008/2012/2014, Sybase 11/12

Languages: ActionScript, C/C++/C#, Flash, Forte, FoxPro, HTML/WML/XML, Java, Javascript, Perl/CGI/DBI, PHP, PL/SQL, Powerscript,

Power Shell, Python, Silverlight, SQL, UNIX/Bash/Korn Shell, VB 6.0/.NET/VBA/VBScript, WSDL, XSLT

Methodologies: Agile, Cycle Counting, eXtreme Programming, FIFO / LIFO, Gordon Graham, Iterative, Kanban, MindJet / MindManager, MRE, PMP, RAD, Real Time, RUP, SCRUM, SDLC, SDM, Six Sigma DMAIC, TDD, Test First

Tools: Active Reports, Adobe Creative Suite: Indesign, Photoshop, Illustrator, Flash, Dreamweaver, Soundbooth, PDF, Android SDK, Anzo Suite Visualizer, Apache, AutoCAD, AWS, BIDS, Bigdata Triple Store Reasoner, BizTalk, Bootstrap, BrowseRDF(extensions), Browsers: Internet Explorer, Google: APIs, Chrome, Mozilla Firefox, Netscape, Opera, Safari, Browser Shots, CamStudio, Coffee Cup, Cognos, Crystal Reports 6-XI, cURL, Data Integrator XI, DataStage TX, DB Visualizer, Django, Drupal, DTS, DTSX, Ebase Xi, EC2, Eclipse IDE, Hadoop, Java JDK, Jetty/SOLR, Jira, Joomla, JQuery, Lotus Notes, Microsoft Expression Studio: Design, Blend, Encoder, Sketchflow, MS InfoPath, Microsoft Office Suite, MOSS 2007, SharePoint Designer, Portal Server, Magento, MindJet MindMapper, MySQL Admin, Navicat Lite, NetBeans, NetMeeting, Nokia SDK, Notepad, nuBuilder, NuSphere PHP IDE, OpenOffice, OWL, OXID eShop, PHP Admin, PCAnywhere, Powerbuilder 6.5-11.5, PowerBuilder, PowerDesigner, PowerSite, PuTTY, Python, RDF(S), RDFSharp API, RSS, SAP: CRM Analytics, ERP Financials, Semantic/Ontology, Smarty, SPARQL, SQLyog, SSAS, SSIS, SSMS, SSRS, Sybase ECMap, TeamViewer, TOAD, Triples, Turtles, UltraEdit 32, Visual FoxPro 6, Visual Studio Interdev/2003/2005/2008/2010, WCF, WebDev, Web Matrix, WebSphere MQ, WinWap, Wordpad, Workflow, WPF, WSS 3.0, XML Spy, X-Windows, Zabbix, Zen Cart, Zend

Web Services: Amazon Web Services - AWS: Linux AMI, IAM, S3, EC2, EBS, Cloud Formation Templates, VPC, CIDR block AWS::EC2::Subnet, Cloud Trail API Calls, Cloud Watch App Monitoring, Auto Scaling EC2 Instances, Route 53 DNS, SNS, SQS, Lamda code run, RDS: Aurora, Oracle, Microsoft SQL Server, PostgreSQL, MySQL, MariaDB, DynamoDB – NoSQL Cloud Database, CouchDB, MongoDB, Redshift Cluster Management. SAP Web Services and Cloud Analytics - SAP: S/4HANA Cloud Integration (HCI), SAP BusinessObjects Business Intelligence, Fiori Apps, Hybris, NetWeaver, SAP UI5, jQuery, NWDS & WebDynpro Java, R/3 HANA, OData, PI/XI integration, SAP Application Server, SAP Gateway & ODATA (REST), Mobile Platform, WebAS ABAP Java Stack

PROFESSIONAL EXPERIENCE – 16 YEARS, 3+ MONTHS DURATIONS DETAILS

** HOWES-IT-GOING, St. Louis MO, USA, Canada, EU Oct 02 – Present

Contract Programmer/Analyst, Software Developer: API, Cloud, Database, Desktop, Linux/Unix, Web, Windows

Independently Own and Designed domain/portal www.Howes-IT-Going.com. Personally maintain all Web Pages, Content, POP3 Email, SMTP & FTP Servers and all Web Site Traffic and Administration. Independent Contracting. (10/02 to Present).

Team Member in the Requirements Gathering, Detail Design and Coding of a Web Based Tasking Collaborative Mechanism in an VB.NET and C# ASP.NET application. Subcontracted for Northrop Grumman MS at Scott AFB, IL. Wrote/debugged Oracle 10g Stored Procedure Packages using Toad and OEM; invoked by XML Data Readers and Web Grid Repeaters. All Web Forms and Services developed in the Visual Studio 2003 IDE. (09/04 to 05/05).

C# ASP.NET Web Application Developer for Maritz - American Express Membership Rewards Team. Worked on Rewards Online Maintenance Tool, Web Catalog, USMR and SQL Server Database Synchronization, Multiple SQL Server DTS Local Packages and Agent Jobs. Non standard Shopping Cart Web Service Digital Signature Certificates .PFX used with .WSDL, .DISCO, UTF-8 Encrypted SOAP extensions, web.config files and WebTier Services. (04/06 to 06/06).

Reserved/Created ICANN Domain Registrations. Designed/Developed Web Sites, Web Services and Content/CDN for Amazon AWS and Elastic Compute Cloud EC2, E-Bay Sales, SAP HANA, various Small to Large-Sized Companies using Google App Engine platform, C++, C#, VB.NET, ASP.NET, Perl/CGI/DBI, PHP, Java – JAR, JSP, MySQL, SQL Server, Oracle, LAMP, AJAX, JavaScript, XML Sitemap and Search Engine Optimization, PayPal Gateway, Authorzied.net. Learned, Developed and Implemented dynamic ActionScript, Flash .SWF, FLEX driven website content web pieces and interfaces. (06/06 to 12/06, Present-PT-Short)

Comprehensive Search Engine Optimization (SEO) Evaluations perfomed via C++, PHP/Java, C# applications and scripts. Analyze: DNS, Who Is, ICANN Registrations, HTML, Content, Meta Tags, Robots, Sitemap, Google, Bing, Yahoo Indexes. (06/06 to 12/06, Present-PT-Short)

Worked for CPA firm writing C# and VB.NET Windows applications to create Client’s: IRS W-2, 1099 and 2006 Tax Returns.

Used U.S. Federal, Missouri and Illinois State .PDF Document Templates for Input and Output Layouts. (12/06 to 06/07)

PROFESSIONAL EXPERIENCE – 16 YEARS, 3+ MONTHS DURATIONS DETAILS

** HOWES-IT-GOING, St. Louis MO, USA, Canada, EU Oct 02 – Present

Contract Programmer/Analyst, Software Developer: API, Cloud, Database, Desktop, Linux/Unix, Web, Windows

Created a PowerBuilder 10 - 11.5 DataWindow.NET front end application for an Internet Recruiting Firm’s Oracle 10g/11g database system. Migrated various PowerBuilder 8.0 ODBC, Web.PB, Data Windows, Queries, Global Functions, Structures and Library Modules. PowerScript Language envoked event driven commands and functions across several User Object Modules, Controls, Menus & Windows. Performed Insert, Update and Delete of processed Employee/Job Applicant Information, Job Openings and Bidding Systems. Wrote SAP CRM Automated Customer Support API. (10/07 to 07/08)

Magento E-Commerce Open Source Systems Integration: Admin, Store, Pricing, Shipping in LAMP/Java. UPS Access Point Extensions to the Magento M-Commerce Shipping software for U.S. AND International Customers. Integrated: UPS, UPS XML (account rates), FedEx (account rates), USPS and DHL. Interfaced select Pickup Points and Delivery Center points taken from UPS Delivery Points data records and account rates.(07/08 to 12/08, Present-PT-Short)

Maintained/Enhanced a Mortgage Processing Portal and Document Management System. A portal for agents of a startup foreclosure mortgage processing company to view and enter information required to process a mortgage from loan origination through closing. BizTalk Server 2004, ASP.NET, C#, XML Web Services, SOAP Extensions, SQL Server. (07/08 to 12/08)

Developed LAMP(Linux, Apache, MySQL and Perl/PHP/Python) and Ajax(asynchronous javascript and xml) programs for cross browser interface applications servicing Liturgical Bible Publishing and online Christian internet systems. (07/08 to 06/09)

Sr. Programmer Analyst, Objects Model Designer with 4 Team Members in Web Interface Design and Enhancements – LAMP, Moodle, M.V.C. and Open Source Systems for a Real Estate Education Courses Start Up Company. (08/09 to 10/09)

Online Home Improvement Store E-Commerce and CSM web pieces written in LAMP, Java, Flash/Flex/Yii and XML.

(10/09 to 12/09)

Converted monthly faxed/printed/database stored Brochures, Catalogs and Magazines’ ads, content, copy and images to a digitally scanned, web based ‘flip book’ type viewer platform; with ability to print, download and ‘save as’. Application written in PHP, Flash/Flex, HTML, Javascript, XML, XSLT. (01/10 to 11/10)

Sr. Quality Assurance Developer for Backend Database Support Systems processing Automated Testing and Performance Monitoring of Search Engine Marketing firm data. Team Member in a fast paced Daily Systems Change Approval Board meetings format shop; consisting of Development Teams, QA Testers, Marketing, Operations, System Admins and Installations. Wrote, debugged and maintained linux shell scripts, PHP programs, MySQL queries. Jira and GIT for source code control CABs and Zabbix for systems Performance Monitoring graphs and error logs. (11/10 to 03/11)

Reverse Engineered proprietary intranet software package for Auto Parts Design System. Independently Uncompiled and Unobfuscated Zend Framework PHP web pages and javascripts from executables restoring all source code pieces, which were maliciously implemented by disgruntled former employee. (04/11 to 06/11)

Marketing Research Company - ETL Cube Data - Sr. Programmer Analyst processing: CATI, CfMC Internet/Web Survey Question & Answers using Microsoft TFS, SQL Server SSIS, SSRS, Sharepoint, C#, VBScript, Textpad, DOS .BAT & .CMD, Citrix, Remote Desktop Server and Secure FTP connections. Wrote SAP ERP Financials Analytics API. (12/11 to 05/12).

Dept of V.A. Sr. Web Developer Analyst S.C.I. Clearance worked on Employee Education System, VA Knowledge Network and Content Distribution Network. Supported VB/.NET front end, SQL Server DB backend, Windows Media Server, Web Publishing Points, Silverlight XAML Video Players, Cisco Routers and Cloud Edge Rendezvous Points via Digital Rapids Multicasting. Created UX/UI for Online Videos, Upload, Ingest, Metadata, Transcode, Encode, QC, DRM, CDN, Playback(Flash, Silverlight, HTML5, Native Players), Ad/Message Serving Insertion, Video Analytics, Enforce Licensing, GEO Restrictions(03/13 to 05/13).

Sr. Programmer Analyst for Upgrading a PHP, AJAX, MySQL cookies based Contact Information system to a sessions based database going from Host For Web servers to Amazon Web Services EC2. Some Linux and Ubuntu system administration also performed along with data conversions and UTC reformatting. Installed Open Source Data Vision Reporting. (05/13 to 07/13).

Designed Free and Premium(marketed/sold) W3C Compliant Valid HTML5, CSS3, AJAX, JQuery Responsive Desktop and Mobile Friendly Website Templates and Smart Phone, Tablet and Wireless Device Emulators. (07/13 to 12/13, Present-PT)

Bank/Credit Card Company - Credit Checks against: Equifax, Experian, TransUnion - Credit Bureaus Data Stores in C#, WCF, Workflows, RDFSharp API calls with SPARQL queries, SQL Server/MySQL, RDF/XML, RDFS, OWL Verbalizer, NTriples, Turtles, Anzo Suite Visualizer, Bigdata Triple Store Reasoner, BrowseRDF(extensions), AJAX, JSON objects, KnockoutJS observables & BackboneJS data binds {{data}}, Java/JAR/JSP integrations, SSL/HTTPS, XMLHttpRequests, XML XSLT DTD - Data Transformations, Displays and messaging, SOAP, DOAP, SMTP. Uniform Resource Identifiers and Locators - URIs URLs end to end triples data comparisons, merging and detailed data reports auto generated dynamically with W3C valid HTML5, CSS3 presentation layers for multiple internet and semantic/ontology browsers: Google Chrome, Firefox, I.E., Opera, Safari. (08/13 to 04/14)

Loan Origination Software Consulting Company - Supported CRM, ASP and Installed DLL Client Framework and Data via SQL Server 2012 R2 Databases with Hierarchical Cascade Updates. Wrote dynamic SQL queries, data conversions, extracts: XML, JSON, SMTP messages with attachments and SSRS reports. Exposure to DocuSign and Constant Contact API SDKs with C# framework code. (04/14 to 09/14)

Developed CRM, ERP, Email Campaigns Automation Tools for IBM Bell Atlantic Sorbus co-op. Trained on RPA Kryon-Leo Server Studio Console and APIs to Push and Pull robots process rules. Recorded Robotic Process Automation macros applications to: Run- Program, Script, SQL, cURL, Get- Excel Imported spread sheets data, pivot tables, embedded recorded VBA macros(.csv, .xls, .doc, .mdb), Get SAP Objects. Created APIs .BAT, .CMD, Windows Task Jobs, Cron Jobs, AIX/Linux/Unix Scripts .CC, .SH, SQL. Processed TXT, XML, XAML, DTD and EDI Transactions Sets. Ran attended, unattended and combined RPA-apps via thin client and RDP connections to MS Active Directory, Open LDAP, Apache Directory Server, IBM Directory Server, Virtual Machines VMs. (09/14 to 12/14)

PROFESSIONAL EXPERIENCE – 16 YEARS, 3+ MONTHS DURATIONS DETAILS

** HOWES-IT-GOING, St. Louis MO, USA, Canada, EU Oct 02 – Present

Contract Programmer/Analyst, Software Developer: API, Cloud, Database, Desktop, Linux/Unix, Web, Windows

Sr. Programmer Analyst, Database Developer – Independently Created SQL Server 2012 Data Warehouse containing Loan Company’s Proprietary COBOL Vision data from text flat file extracts. Imported, Parsed and Indexed 1 TB sized database in 5 hours! Created Customized PHP: Problem Log Package, MySQL Table Editor and Single Login Session LDAP web tools. Also developed Java JSP Servlet MySQL JDBC table editor templates with intentions to convert COBOL programs to Java/JSP. (12/14 to 11/15)

Sr. Java JSP Servlet Web Services Front/Back End Developer – Created generic/portable JDBC MySQL table editor tools in a TDD JAX-WS, RESTful and SOAP, Spring MVC, Bootstrap, AJAX, AngularJS, KnockoutJS, Apache-Tomcat and WebSphere environments. Used Eclipse, JSP-API, Servlet-API, jasper, J2EE, java sql/utils, localhost:8080 3306 (11/15 to 03/16)

Amazon Web Services Cloud Solutions/Integrations Developer. Developed and maintained AWS HPC Compute Clusters, Cloud Formation Templates, CIDR block AWS::EC2::Subnet, Cloud Trail API Web Service calls, Cloud Watch Web Service and Application Monitoring, Auto Scaling EC2 Instances, Route 53 DNS and IAM and S3 Controls bucket policies, SNS push notifications, SQS queuing, Lamda run code without provisioning, RDS Databases: Aurora, Oracle, Microsoft SQL Server, PostgreSQL, MySQL, MariaDB, DynamoDB – NoSQL Cloud Database Service, Redshift Cloud cluster datawarehouse. Wrote .NET/C#, VBScript, PHP, Python, Unix, Linux AMI, Shell and Powershell scripts. Integrated various applications software and systems applications with AWS APIs. Performed Web Services Identity and Access Management IAM, EBS, Component Management, Enterprise Authentication and Authorization, Job Scheduling, Dependencies, Queuing and VPC Flow Logs. (03/16 to 08/16, Present-PT-Short)

EDI Health Care Project Manager/Business Analyst Processing ICD9/10, CPT, HCPCS, Electronic COB, Amisys Database Warehouse, HIPAA 834, 835, 837, 277 X12 and proprietary formats mappings and reports. Created SQL Server 2012 SSIS, SSRS, SSAS and Pervasive DB ETL Batch and DTSX Jobs. Monitored and resolved Remedy Tickets. Identified, Analyzed, Interpreted Trends, Patterns, Data Sets, Reports, Dashboards, Graphs and Presentations. (08/16 to 10/16, Present-PT-Short)

Developed Travelport EDIFACT, EMD, Galileo XML API Integrations with SITA OnAir and Sabre GDS Airlines Reservations Systems for KLM, British Airways and Swiss Air. Generated Reservations and ticketing data feeds to airline data warehouse, ETL set-up and data interpretation. Used Oracle 11g, PL/SQL, SQL Server 2012, Stored Procs, Triggers, XML.(10/16 to 01/17)

Reverse Engineered Hat Manufacturer’s Digital Embroidery (Wilcom) software package for SQL Server Database Migration.

Globally changed URL and URI embedded files, folders and server locations with SQL stored procedures in Windows XP. Used Xcopy, BAT and CMD files scripts. Redesigned old ASPX web pages to be updated to new modern HTML5 CSS3 responsive mobile friendly website. Created PHP & Python scripts to read SBT Financial Inventory Reports. (01/17 to 05/17)

Team Member in Startup Company SAP CRM Custom IDE Fiori Apps Tool Kit. Attended SAP Trainings and learned SAP S/4HANA, AS ABAP, User Experience, Fiori: Implementation, Administration and Configuration, Gateway Building 0Data Services and UIs with HTML5 and SAPUI5. Developed custom controls in SAPUI5 using OOP Java/Javascript which are not available with the standard SAP UI5 Framework. SAP to purchase Launchpad add-on tools and become part of next Solution Manager SAP Fiori wave. Coded specific requirements of the client and integrations with backend systems using 0Data services. (05/17 to 11/17)

Short Term Contracting Web: AWS, Constant Contact, Cloud, DevOps, E-Commerce, SalesForce, SAPUI5, AJAX, CGI, DBI, HTML5, CSS3, Java(JAR,JSP), .NET(ASP,C#,VB), Perl, PHP, Python, RSS, SEO, Unix, W3C, WSDL, XML.(11/17 to Present)

EDUCATION

B.S. Computer Science / Mathematics - Dec 1988(3.5 G.P.A.)

University of Maryland University College-UMUC / U.S. Army - Tompkins Kaserne - Schwetzingen, Germany

Client Sponsored Corporate SAP Trainings 2017 May to June

SAP S/4HANA 1511, AS ABAP 7.50, SAPX01 SAP User Experience, SAPX03 SAP Fiori Implementation, Administration and Configuration,GW100 SAP Gateway Building OData Services, UX402 SAP Developing UIs with SAPUI5

CERTIFICATIONS

Microsoft Certified: Solution Developer - MCSD VB 6.0 & .NET, Professional, Plus Internet - MCP/+ Internet

Microsoft Certified Technical Specialist (MOSS2007)

National Computer Science Academy - CP 450 HTML 5, CP 430 CSS, CP 242 JavaScript

EC Council Certified Ethical Hacker CEH 312-50



Contact this candidate