Programmer Resume
Schaumburg, IL
OBJECTIVE:
- Utilize software/db/reporting solutions and support to achieve valuable productivity and insight gains
SUMMARY:
- Software, Web, Report Development:
- Strong ASP.NET and .NET developer, current versions VS 2010/2015/17 , C#, VB, Bootstrap,, javascript, jQuery, excellent Webform developer, also good with MVC code. Use VSTO for automating Excel.
- Expert Crystal Reports Designer 8 - 2014 and SSRS report developer, SQL query builder, with reports delivered programmatically, or published on SAP Portal, Crystal Server, Enterprise, custom asp.net web app or Reporting Services portal. Developed many .NET and COM interop Office automation projects using VBA and Office Object Libraries.
- Skilled and experienced using C, Perl (Active State and Linux), K-Shell, Bash, DOS, PowerShell among other languages and script hosts.
- Build l ASPX and HTML sites in utilizing mix of HTML, ASPX controls, Bootstrap framework, jQuery, JavaScript and CSS. Create User Controls (ascx), helper libraries, and extensions as needed for code reuse and readability.
- Create maintainable file structure and layers, such as Data Access Layer, Business Object Layer, etc.
- Skilled at automating, populating, refreshing, publishing and delivering Excel and other Office Doc types.
- Advanced Web Scraping and automation programming, consuming web services.
- Use Sharepoint to integrate workflow with custom applications.
- Database Development: Expert SQL scripter (DDL and DML) with strong DB modeling and DB analytical skills. Strong experience with SQL Server, Oracle 8 to 11G, MySql and Access.
- Reporting Expertise with Crystal Designer/Enterprise, SSRS, Xcelsius and Qlikview and Excel.
- Excellent data analytical skills to relationships of schemas and building queries and sql scripts incrementally from the ground up for code or use in Crystal or SSRS.
- Experienced Software/DB/Report software development engineer with great experience in all phases of development on multiple OS’s.
PROFESSIONAL EXPERIENCE:
Confidential
Programmer
Responsibilities:
- Developed numerous intra and internet apps and greatly improved many additional websites for City of La Crosse. Improved existing reports and created numerous new reports in Crystal 2013 and SSRS for all departments.
- Sites built and in full use, include, a) Squad Car check-in intranet app, C#, jQuery, javascript, with email notifications to stakeholders, accompanying backend SSRS report, b) Assessors online data search, public, c) Parks and Recreation Sign-up, public, C# d) Finance Custom Reports Portal, C# with mx of Crystal custom embedded reports and SSRS hosted reports with ASP.net frontend all Excel ready, Autogenerates payroll deductions bi-weekly multiple tabs e) Court Check-in VB, one app, a realtime Court Clerk Viewer on court clerk side, f) total revamp of License issuing asp.net app and license generator for City Clerks, VB g) Police Response to Resistance application with multiple landing pages for various officers to to access based upon ranke for smooth workflow between Captains and officers., h) Radio Billing, w/Notifications and Excel exports, C#, jQuery datatables, Bootstrap, Admin LTE framework i) Inter Department Signup App, within Sharepoint, with supporting SSRS report to see how has signed up and for admins to print out list of attendees for any . VB. - Add courses.
- All above apps developed in Visual Studio, Bootstrap, jQuery w/various plugins, javascript, Crystal, SSRS, nLog, ePlus nuget packages and more. utilized mobile first, responsive and fluid web page layouts.
- DB platforms utilized, include primarily SQL Server, SSMS, SSRS and MySql 4.5 & Workbench and Oracle 11G/ PLSQL scripting and Oracle’s SQL Developer.
Confidential
Software Design/Developer
Responsibilities:
- Added several features in 2017, including auto restart at point of last failure in a multiple file input of 1000’s of tickets, and custom notification events with text fixture.
- Designed and wrote VB.net Win 7 program driver application and Web Scraper automation driven by user configurable xml files. Installed and currently running unattended from task scheduler without incident.
- Designed & developed VC# component (with test fixture) to parse out complex financial information in UTF-8 encoded files using complex RegEx matching expression parsing.
- Adding more features and expanding scope of projects to satisfaction of client
Confidential, Schaumburg, IL
CR Reports Developer
Responsibilities:
- Developed in Crystal Reports 2013, 8 complex business critical reports. Developed and modified Oracle SQL Scripts used directly in multi-sub-report reports, including sub-selects, multi-join and union queries.
- Instructed client on advanced Crystal report techniques development and speed enhancements.
- Used PL/SQL Developer to write custom queries and materialized views for reports.
- Reversed Engineer information displayed In web portal tables to display same in reports.
- Published all custom reports to SAP portal for general use by department.
Confidential, Chicago, IL
Software & Systems Engineer
Responsibilities:
- Sole Crystal Reports Designer 10, XI and Enterprise Developer and Administrator.
- Complex Automation process developed in VC# using .Net UI Automation Client class coupled with a web scraper application for pre and post processing of 30K tickets daily to automate the reclamation of 30K tickets daily. This total software solution drastically reduced time, error and increased accuracy and monetary gains from commission reclamation on all tickets sold the previous day.
- Designed and developed multiple software applications utilizing multi-threading in VB.NET with MySql backend that automated data loading to locally persisted db from http or ftp text and xml data sources, of invaluable volatile non-persistent remote data using ETL techniques. Permanent Highly Available Data then provided to other interested customers for further analysis by custom Crystal and Qlikview Reports and for long-term trending and forecasting from this persistent local data store.
- Automated Access 2013 database macros both internally to the db and via Access Object modeI inside VB.net to run macros unattended.
- Developed LAMP web application that company business units relied on for up to the minute sales of all sale verticals. The system was an Apache hosted intranet portal developed in KSH, C, Perl, and HTML with PlSql, Oracle 11g, to gather data. Displayed intraday sales charts in running total graphs using GTK graphic library, displayed on rotating pages on SOC plasma for all points of sales and products. These real-time graphs also displayed the varianceof current sales to previous time periods and emailed throughout day to business groups to monitor their particular segment up to the minute.
- Used SSRS to write reports for the SQL Server db backend auditing of the Crystal Enterprise servers I installed and configured.
- Created many custom dynamic reports that had moving time frames based upon current date and time and shifted these time windows in the future or past accordingly so whenever they ran, the report used correct time window as filter. Complex programmatic report logic written in report development.
- All reports went through rigorous user acceptance testing (UAT) and validation.
- Utilized Crystal Report object model components extensively for VC # and VB .NET automations .
- Data sources used incl., Oracle 9 - 11g, SQL Server, MySql, DB2, Access.
- Designed and implemented custom ASPX dynamic web portals for Service Desk and various business groups, enabling them to run their Reports from the Enterprise through the aspx page and specifying parameters selected by user on web page. Configured all sites in IIS 6 & 7. Also ran these on WinNT 2003 Server and Win2008 Server.
- Set up both installations of Crystal Enterprise and user permissions for a 5 seat license, but allowed ad-hoc reporting to anybody that desired by using Guest account.
- Tuned and monitored the Enterprise and IIS server to deliver reports and ASPX sites optimally and reliably and reported errors to administrator using audit notifications.
- Set up Crystal Xcelsius Dashboard flash object report for real-time display of KPI within otherwise static company wiki page.
- Wrotebusiness critical multithreaded automation in VB.net toprocessordownloadinformation from outside vendors like Gomez and Mercury Topaz on a daily basis using both .net and Perl and xml. Designed custom Stored Procedures to speed up access of loading data. Shelled out to ActiveState Perl for parsing incoming xml data stream . This data and reports written from it were used by SLT on a daily basis to monitor and improve website performance.
- Developed dynamic ASPX portal with rotating Javascipt timed pages to rotate through the upcoming and overdue Change tasks and Incidents assigned to SOC team members .
- Modeled and created many MySql Databases and stored procedures to tabulate the data and to retrieve it quickly with partitioning.
- Created reports on this data published these and other reports to IISWebServers.
- All processes all had built in error handling to take corrective action for great resiliency.
- Additional report automations included .Net programs that used web services of wiki and jira to publish site latency graphs directly to wIki or jira every morning or emailing HTML content to users.
- Wrote and created ITSM reports for Remedy and Service Now showing for instance accurate mean time to resolution of problem tickets.
- Created complex SQL for Qlikview reports. Debugged existing Qlikview reports.
Confidential, Rolling Meadows, IL
Software Engineer
Responsibilities:
- Implemented large suiteofcomplex ERPreportsusingCrystalReports 9.
- Created Time card reports and assisted in Excel formula debugging and analysis.
Confidential, Monogen Chicago, IL
Software Engineer
Responsibilities:
- Developed a suite of multilingual enabled programs in VB 6 using Access and SQL Server databases to control custom hardware and allow lab technicians ability to scan every part of cytology slide specimens and accurately grade specimens using a hierarchical tree interface of standard hospital protocols and shortcuts. Workflow built right into software for slide to proceed to QA technician or Pathologist.
- This Confidential t/specimen/evaluation infowasuploadedtohospitalLISusingHL7 standard protocol wrote from specification for medical records transmission to hospital LIS system over network or alternatively, uploaded to LIS via a telnet session using screen scraping in real-time.
- DeployedtoDetroitMedicalCenterCytology labof 30cytologist fixing all issues with DB concurrency and the interface in TIP mode.
- One of the applications in this suite were a set of custom Crystal Reports 8.5 presented within VB application using Crystal Report Engine Object Library.
- The manager of the Cytology lab would like to utilize these retrieve essential critical lab reports with information on each technicians’ performance and specimen/ Confidential t information as well as many predefined report required by hospital standards.
Confidential, Deerfield IL
Software Engineer Consultant
Responsibilities:
- Wrote custom C PC dashboard to display real time sensor information of Motorola sponsored Formula One Race Car.
Confidential, Franklin Park, IL
Software Engineer Consultant
Responsibilities:
- Utilized expansion hardware on PC consisting of a multi-port RS232 card for control of test fixture, GPIB controller for running HP test equipment measurements, multi-port I/O card for retrieving additional test measurements and A/D card for reading current measurements as theappliancesrolledofftheassemblyline.
- Created highly responsive real-time graphics in C, using integer math for fast fractional math calculations allowing accurate final adjustment of critical settings.
Confidential, Arlington Heights, IL
Software Engineer
Responsibilities:
- Designedandcodedin C ahighly successful PCsoftwaregame, Ducktales and devising much of the game elements on the fly with approval from Disney.
Confidential, Chicago, IL
Software Engineer
Responsibilities:
- Developed next generation tax law library tools in C with Windows 3.1 SDK
Confidential, Westlake Village, CA
Software Engineer
Responsibilities:
- Developed math support libraries and screen drivers.
- Programmed GP IB test automations.
Confidential, Downers Grove, IL
Software Engineer
Responsibilities:
- Wrote shell scripts and coded Recent Change modules in C.
- Debugged M68000 assembly when running in test switch lab, to support telecommunications network of MCI.
