William Opila

Cell 630-***-****

Email adcskb@r.postjobfree.com

**** *********

Downers Grove Il

SKILLS

•Software: GUI, web and database design, Windows and Web Services design – SQL Server 6,7, 2000, 2005, 2008,2010 2012 /T-SQL, Visual Studio .NET – VB/C#.NET, Angular 1,2,6,7,8,9, KnockOutjs, Entity Framework, MVC, Razor, ASP.NET, XML/XSLT, JavaScript, Visual Basic 6.0, HTML, MS Access 97 and 2000, Java, Bowstreet, WebSphere, Interworld ecommerce, Oracle, Edi, Delphi,TFS, AJAX, WPF, Bing Maps, WCF Test Client

PROFESSIONAL EXPERIENCE

True Group Oak Brook, IL

2017 – Present

Clients

McDonalds – Largest fast food chain in the world

•Created .net/MVC/ Angular 8 pages to allow users at various levels to view the results of customer surveys and in store mystery shopper reviews

•Created services to access data from various sources and roll them up into usable groupings (sql tables, sql cubes, Oracle)

•Worked on tool to synch up translation data between a system in sql server and a oracle based server.

Flyby – Application to track users of mobile devices in and around various locations

•Integrated data from Meraki AP’s into a usable Cloud sql server Database for use in various application

•Created a user configurable Angular 8 dashboard for various customers to view there rolled up data in a simplified form.

•Created texting and emailing app that could trigger whenever a user meet certain durations at a location. A example of this would be if a VIP customer enters the building the appropriate staff is notified or if user is in their hotel room and has not gone to the bar yet we can send him a note to come down and get a drink.

F2-HealthCare – Company that finds lost income in hospital billing

•Automated uploading of hospital billing files.

•Processed the uploaded data into the sub sets of data that shows where the opportunities are.

•Automated the Customer finder app to find potential hospitals that are missing billing opportunities.

Bridgepoint Technologies Oak Brook, IL

2015 – 2017

Clients

BCG - an worldwide management consulting firm with 88 offices in 48 countries.

•Created Angular MVC pages/services that allow the user to update various elements. (MVC, WCF, AngularJS, C# Server2012)

•Created a Set Base line page and service that let the user make a snapshot of all the data in the system at any given time and compare the current Data to a previous snapshot (MVC, Angular,#, SQL Server2012, WCF, XML)

•Create automated data refresh for Automated testing allowing testing to have a predictable database. (C#, SQL Server2012, GIT, XML)

ULTA - ULTA Beauty is the largest beauty retailer in the United States and the premier beauty destination for cosmetics

•Involved with the team responsible for creating the company’s first credit card offer. Responsibilities included developing SQL, new web services (ASP.NET, C#, SQL/Server2008, TFS, WCF Test Client. XML)

•Created point’s allocation algorithm to apply points to customer’s loyalty accounts depending on their credit card purchases (C#, SQL/Server2008, TFS, WCF Test Client. XML)

Internal Client

•Reworking Question application from a ASP.net application to Single Page MVC application in C# .(.Net, SQL server, Web, Angular, REST)

•Fixed issues on the current web site and helped reduce the number of open issues.(.Net, SQL server, Web)

Encore Consulting Oak Brook, IL

2014 – 2015

Clients

FTD - FTD has been delivering flowers since 1910 and the highly-recognized FTD® and Interflora® brands are supported by the iconic Mercury Man logo which is displayed in nearly 40,000 floral shops in approximately 150 countries.

Consultant

•Updated a desktop application to use Bing Maps as its engine to route floral deliveries .(.Net, SQL server, WPF)

•Created and modified Web Services to help with routing of delivery vehicles.(.Net, SQL server, SOAP)

•Designed and implemented SQL server database changes to help more efficiently return data for delivery tasks . (SQL server)

Sirva - A leader in providing relocation and moving solutions to consumers, corporations and governments. We move more than 300,000 families each year to more than 175 countries around the world

Consultant

•Created and modified current functions and pages in the web applications .(.Net, SQL server, HTML,JavaScript, Scrum, Agile methodology)

•Created and modified Web Services to meet the needs of internal and external organizations.(.Net, SQL server, SOAP, Scrum, Agile methodology)

•Designed and implemented SQL server database changes to increase application speed. (SQL server)

Intertek Oak Brook, IL

2012 – 2014

Intertek Inc. provides companies around the world testing and evaluation to ensure the quality and safety of their products, processes and systems.

Consultant

•Evaluated current systems in order to improve performance and reliability of the web application.(.Net, SQL server, Scrum, Agile methodology)

•Designed and implemented SQL server database changes to increase application speed. (SQL server)

•Design and created new section of the web application and Web services.(.Net, SQL server, Scrum, Agile methodology)

•Supported the production environment dealing with the day to day emergencies .(.Net, SQL server)

•Increased logging capability of the application to make debugging production more effective (.Net, SQL server)

•Helped create a Data Warehouse using SSIS.

•Created and maintained Reports as needed using SSRS

Custom Call Data Systems Naperville, IL

2002 – 2012

CustomCall Data Systems, Inc. provides Billing, Provisioning and Workflow solutions to Communications Service Providers, such as telephone companies, Voice over Internet Protocol providers, cable TV and IPTV companies as well as wireless providers.

Sr. Application Developer

•Designed, created and deployed a web application supporting the entries of local phone service orders across multiple local carriers (.Net, SQL server)

•Directly responsible for the design, development, installation and support of a application that interfaces with 8 major local phone carriers.

•Designed and created database structures supporting the web application along with interfacing with over 30 external companies (.Net, SQL server)

•Created applications to create, transmit and receive EDI from 10 phone companies (.Net, SQL server)

•Created SOAP/Rest web services for receiving over 200,00 transactions per month from multiple phone companies (.Net, SQL server)

•Created applications calling web services for order creation and preorder transactions for multiple phone companies

•Converted Custom Call Data Systems desktop application to a web based product. The implementation combined 8 different application into to one web site

•Managed offshore and onshore design and development of major projects.

Leverent Consulting, Naperville, IL

2000 - 2002

A local consulting firm that specializes in meeting unique needs of its customers.

Senior Technical Consultant

IT Consultant actively involved in projects for major companies (Motorola, Imation, Hewitt Associates)

•Managed a team through the full development cycle on a B2B site offering its users a Supply Chain management solution for the production/delivery of apparel. (Bowstreet, Java, Oracle, HTML, Java Script)

•Developed and deployed a ”War Room" software, enabling worldwide senior management to more precisely target markets and focus their sales effort. (VB, SQL Server, HTML)

•Participated in building a portal site that utilized multiple skins applied to the same site, tailoring the site experience to the given user and their needs. (Bowstreet, Java, Oracle, HTML, JavaScript)

•Created a B2B site for Interior designers to find specialized supplies and services. Site also provides a design section where a designer could recommend products and customers could give feedback.

USWEB/CKS MarchFirst, Chicago, IL

1996 - 2000

USWEB/CKS completed hundreds of custom software development projects for a long list of satisfied clients ranging from Fortune 500 corporations to entrepreneurial companies who require superior software development skills and expert project management.

Senior Technical Consultant

IT consulting involved in projects for major companies (ATT, Hewitt Associates, ACI)

•Developed an E-Commerce site for a major mall allowing all the vendors to have a combined E-Commerce Site. (Interworld Commerce Exchange, ASP, JavaScript, SQL Server)

•Created a web site for a telecommunication reseller enabling customers order different combinations of phone service. (VB, MTS,ASP, JavaScript, HTML, SQL Server)

•Developed a graphing control for graphing health plan information (VB for the Control, Java for the data access, Oracle Data Base)

•Created an ordering system for telecommunication services from multiple providers. This system communicated with various outside vendors using their proprietary interface. ( Delphi Front end, Oracle Access Backend)

•Developed an order Tracking system (VB, Oracle)

ACI Chicago, IL

1994 - 1996

An international consulting organization servicing clients thought out the world

Senior Technical Consultant

IT consultant involved in projects for major companies (Kraft Foods, Allstate Insurance, Zenith Computers)

1.Created a tool for administering pay increases and bonuses (VB)

2.Developed a employee performance review system (VB, Access)

3.Created a “Phone Center Tool Kit” allowing human resource representatives to identify the caller and automatically bring up personnel records. The system included a Call Tracker along with information retrieval from a mainframe (VB, SQL Server)

4.Designed a document tracking system for large scale development teams

5.Developed a global sales force document library system (VB SQL Server, RAS Dial up)

6.Developed a mass mailing data base and front end for mailings to different sections of Customers (VB SQL Server)

7.Created an Executive Report System for rolling up Data for Different Divisions of the Client. This System Contained adhoc capability and Graphing Tools( VB, SQL Server)

8.Developing Data Base in Client/Server environment

9.Installed Windows NT SQL Server

10.Designed and deployed Windows NT RAS network

TASC Chicago, IL

1990 - 1994

TASC (Treatment Alternatives for Safe Communities) is a not-for-profit organization that provides behavioral health recovery management services for individuals with substance abuse and mental health disorders. Through a specialized system of clinical case management, TASC initiates and motivates positive behavior change and long-term recovery for individuals in Illinois' criminal justice, corrections, juvenile justice, child welfare, and other public systems.

MIS Manger

Directly responsible for the management of entire IT infrastructure from software development the hardware deployment, Was a member of multiple government oversight boards that oversaw state software development Implemented one of the first VB/sql server projects in the Chicago land area

1.Created a statewide Windows based client tracking system for over 100,000 clients that include Monitoring Court Cases, Drug Testing, Staff Work Load, Required governmental Reporting (VB, SQL Server, Network Design)

2.Supported statewide computer network over 15 sites and 400 users

3.Converted network from DOS to Windows environment

4.Developing Data Base in Client/Server environment

5.Installed multiple server Novell Network

6.Installed SQL Server

Market Facts Oak Park, IL

1988 - 1990

Market Facts is a global market research firm that generates insights to help clients drive competitive brand, product and customer experience strategies.

Programmer/Analyst

1.Wore many hats from developer to network engineer to software trainer in the implementation a new computerized interviewing system

2.Implemented a new computerized interviewing system

3.Designed a computerized sample management process for mainframes and microcomputers

4.Managed conversion of mainframe data sets to microcomputer databases

5.Demonstrated data collection and review systems to potential clients

6.Supervised user training program Managed NOVELL network

EDUCATION

BS in Computer Science and Mathematics

Loyola University of Chicago, Chicago, IL

Contact this candidate