Sterling Engineering Resume
Chicago, IL
SUMMARY:
- Experienced in database programming, application development, ecommerce, SharePoint, data mining, and troubleshooting.
- I am a detail oriented, motivated, and quicker learning team player with strong communication and interpersonal skills.
- Seeking a Information Systems opportunity to contribute my education, experience, and skills to the success of an organization.
TECHNICAL SKILLS:
Software: Microsoft Word, Excel, Outlook, PowerPoint, SharePoint, Project, InfoPath 2010, Publisher, Visio and Access(2007, 2010, 2013); Adobe Master Collection CS6; SQL Database; Visual Studio 2010, 2013, 2015; Zone Alarm Free Antivirus + Firewall 2013, Visual 2012
Operating Systems: UNIX; LINUX; Windows XP, Vista, 2000, ME, 7, and 8, MAC OS, Windows SQL Server 2003, 2008, & 2008 R2, 2012 R2
Languages: HTML, CSS, VBA, SQL, VB.Net, ASP.NET, JavaScript, T - SQL, C#
Networking: VMware; Hyper-V; Basic Network Switching, VPN, LAN, WAN, VLAN, Cisco Routers, WEBEX, Machine-to-Machine Communication.
Other: HTML Website Design and Development; (SharePoint training was done in house at BCBS and included an 8 hour session that included everything from basic usage to advanced development practices and abilities of SharePoint)
PROFESSIONAL EXPERIENCE:
Sterling Engineering
Confidential
Responsibilities:
- Repair database that was in development and not working.
- Remodel database for possible web deployment in the future
- Load with current data from spreadsheets.
- Normalize data and enter new fields for continuing improvement process
- SharePoint forms development / workflow creation
Confidential
Web Application Developer
Responsibilities:- Build an Access Database to track data from machines
- Build a program to pull information from multiple machines and load into database after normalizing the data
- Build a web application to read information from database and display it in a manner that can be used by management
- Create an FTP server and export files to .csv for machine pickup
- Test and implement systems as needed.
- Build database with web front end to tract CPU, and OS problems and upgrades.
- .net programming to align with project requirements
- Working with ever changing requirements
SharePoint Developer
Confidential, Chicago, IL
Responsibilities:- Speaking with Upper Level Management and Departmental Leads to determine requirements of site layout and functionality.
- Front End Development of SharePoint
- Reviewing requirements and system capabilities to determine if the current system layout is capable of handling the requirements.
- Setup Communities and Permission Levels
- Worked with BCBS’s ITG department to help resolve issues in SharePoint that were being caused by ether the application or a SharePoint Setting.
- Uploaded Access Database and was the go to guy for support questions and any changes that needed to be made.
- Helped integrate an HP application into the SharePoint environment by keeping the look in SharePoint as close to what was used in the actual HP application to allow as close of a seamless transition as possible.
- Used SharePoint Designer to develop a layout; Tabs and pages with custom Views
- Created Custom SharePoint Forms in InfoPath 2010
- Created Custom SharePoint spreadsheet for calculating desired results by pulling information from different locations and using those to perform calculations in the effort to gain desired result.
- Uploaded of Documents from multiple locations including different servers located across the country, Lotus Notes databases and other Access databases
- Created several Custom Workflows that could be chosen from when form was implemented
- General maintenance for their SharePoint Sites
- Writing Use Case Scenarios for use in the testing process of applications
- Created training materials for use in training people in how to use the application and a manager manual for the managers to be able to enter and change information that is present within the database as well as giving specific details and specs of said application to allow further development in the future.
- After each application was designed with an Agile approach the testing began with a small group where I would sit in and answer any questions and to see how the product was used and what might make the job a little easier this generally took several attempts.
Database Programmer/Developer
Confidential,Chicago, IL
Responsibilities:- Redesigned of existing Database by change VBA to SQL
- Redesigned all Tables and Layouts to conform to Web Compatibility for SharePoint Migration.
- Completed rewrite of Form’s to allow for Web compatibility.
- Worked with different departments to determine deliverables
- Designed and created Queries and Reports to match Manager’s needs.
- Worked with management to determine the information to be pulled for their reports
- Migrated final product to SharePoint
- Team based testing of database and software to work out usability issues while maintaining database security.
Database Programmer/Application Developer
Confidential,Chicago, IL
Responsibilities:- Utilized Access to develop a Database
- Programmed and application development using VBA, SQL
- Worked on project team for development of LazerApp Was the contact for LazerApp in Bankers Life & Casualty everything was routed through me.
- Built a completely automated Application for LazerApp that when opened would go to the company site load a list of current employee's then match them against a list color the ones that were let go red and send an email off to LazerApp to have their license pulled
- Worked in beginning with E-App to help develop a program that will work
- Worked on all State Compliance and forms requests with legal
- Built a Complete Database library of all current functional forms used in all 50 States along with updating a Library with current forms
- Limited SSAS use very basic analytical processing and data mining
- Helped as an advisor to different departments on Excel, Access, VB use and application and other programming problems
Dispatcher/ Application Developer/ Assistant Manager
Confidential
Responsibilities:- Run the afternoon shift of the Naperville store.
- End of day paperwork
- Ordering, Receiving.
- Dispatching fuel trucks to different locations throughout northern Illinois to prevent stations from running out of fuel
- Creating an excel spreadsheet that was to be used as a forecast tool to help the dispatcher determine what amount of fuel that a station might use to help keep tighter rains on the amount of fuel going to different locations (Macro, VB.NET)
- Deal with problems that might arise at a store such as discrepancies in numbers from fuel system, paperwork errors, ordering errors and building maintenance.