Post a Job Sign in

Michael Frelas

Please send email for details - thank you. (This resume has been deleted.)

Rockford, IL

-

Please contact me for a copy of my resume - this, online resume has been deleted.

Work Experience

Sr. Business Intelligence/ SQL Server Consultant III

Not available
-
Lombard, IL
-

August 2012 to Present

Excel 2010

Business Intelligence Architect & Analyst

Not available.
-
Marengo, IL
-

June 2011 to July 2012

Not available.

Sr. IT & Business Analytics Managing Consultant

Not available.
-
IN
-

March 2010 to May 2011

Sr. Management Consultant

AT&T
-
Hoffman Estates, IL
-

March 2009 to March 2010

Responsible for creation, maintenance and enhancements of pricing team's scorecard system allowing identification of not fully realized revenue opportunities. Involved in periodic 
 
evaluation and adjustment of scorecard's normalization factors, ETL processes and the analysis of results. Performed continuous improvements to the system's performance and to the existing within the system analytical models. 
Technologies/Programs Used: Microsoft SQL Server 2008, MS Access 2003, Excel, VBA.

Sr. IT & Business Analytics Managing Consultant

GT&M , Inc
-
Indiana
-

April 2008 to March 2009

Director of e-Commerce Services

Teleformix
-
Schaumburg, IL
-

September 2007 to April 2008

Responsible for daily operation of credit card transaction processing/credit card order management activities. Managed customer billings, order fulfillment and general system problem 
resolution. Identified and satisfied needs associated with new product rollouts. Enhanced existing operational procedures leading to increased customer satisfaction and waste reduction. Created, monitored and evaluated key business performance indicators and business analytics. Acted as primary point of contact for all customers: for both technical and business issues. Managed technological projects dealing with system enhancement and problem fixes as well as managed technical staff responsible for implementation and support. Managed development of financial and operational reports along with underlying stored procedures as part of company's business intelligence initiative. Responsible for team development, annual employee evaluation, employee termination and hiring. 
Technologies/Programs Used: UNIX HP-UX, Oracle 9, Informix, SQL Server 2005, Crystal Reports Server, MS Access, .Net, XML.

SSAS, SSRS, SSIS, Business Objects
-

2005 to 2008

MS Access 2007/2010, Visio, EDI, ASP.Net, XCelsius, JavaScript, VBScript, VBA.

Applications Manager

Winterthur Property & Casualty Insurance
-
Madison, WI
-

September 2006 to September 2007

Functioned as a sole point of responsibility for all U.S. agent-facing web applications and systems. Managed the deliverables for both: commercial and personal lines in terms of applications maintenance, applications enhancements, code migrations and alignment of software 
requirements with business strategic goals. Directly responsible for a team of seven senior programmers, project manager, business analyst and three off-shore resources. Developed effective procedures for proper and structured project hand-off from the third-party software companies. Played active role in reviews of technical and business system components and technical and business issues resolution. Member of the corporate IT management team participating in specifying strategic direction of IT. Held responsible for day-to-day planning, management and control of projects and resources, including mission critical $17M project servicing 2000+ concurrent users located throughout Midwest. Responsible for initial team formation, team development, annual employee evaluation, employee termination and hiring. 
Technologies/Programs Used: DB2, SQL Server 2005, Web Methods, SOAP, C#, ASP.Net, Classic ASP, VB 6.0, Unix, XML, .Net, MS Project: client & server, LoadRunner.

IT Manager

Alcoa Corporation
-
Beloit, WI
-

January 2006 to September 2006

Responsible for daily (24x7) operations of cast wheel manufacturing plant employing over 400 people and the annual budget of $500K. Responsible for collection of production data, process re-engineering, implementation and support. Provided IT guidance for various departments and co-operated with corporate office in implementation of company-wide initiatives. Responsible for departmental budget, including formulation. Performed urgent system re-programming leading to avoidance of penalties imposed by EDI trading partners. Assumed staff-level duties in 
emergency situations. Managed in-house systems and provided plant manager and business unit controller with data necessary for optimal decision making. Regularly conducted IT Department's SOX compliance testing. Coordinated infrastructure upgrades and maintained vendor relations. Assisted finance department with resolution of daily GL issues. Responsible for a team of three people and their annual evaluations. 
Technologies/Programs Used: UNIX, SQL Server 2005, MFG-Pro, Classic ASP, VB 6.0, MS Access 2003, Crystal Ball, JavaScript.

Independent Consultant

-

2001 to 2005

Various mid-size companies in U.S. and Canada 
Reseller, integrator and developer of financial, manufacturing and medical practice management systems for small and mid-size companies throughout the US and Canada. Presented, sold, installed, modified and supported accounting, inventory, manufacturing and medical systems. 
Developed project plans, managed projects and performed system implementations. Planned, performed and managed database conversions and data mappings between ported systems. 
Provided post data conversion data quality checks, data integrity testing procedures as well as support. Expanded existing in-house software systems by developing and integrating additional strategic modules (MRP, Medical Billing, etc.). Responsible for post-implementation system start-up, daily operations and maintenance of servers (database, file, email as well as backup and security applications) at several mid-size companies. Performed primary financial controller's functions that included: financial analysis, GL transaction entry, inventory analysis, cash flow analysis and resolution of accounting ambiguities - particularly at the period closing times. 
Technologies/Programs Used: Microsoft SQL Server 7.0, FRx Reporting, Crystal Reports, MS Access 2000, Visio, ASP, JavaScript, VBScript, VBA, Excel.

IT Director/CTO

e-Solutions.com, llc
-
South Bend, IN
-

1999 to 2001

Established strategic direction and held responsibility for the development and implementation of policy, procedures and processes required to maintain quality technical infrastructure, services and operation for the company. Prepared and negotiated contracts and project timelines. Served as primary architect of the company's n-tier B2B system. Provided support and leadership to technical staff of 19 people in Europe and US. Managed client's expectations and relationships. 
Negotiated with clients to resolve problems and conflicts with service delivery or with product performance. Managed budgets for European and US offices. Controlled projects, managed deliverables and project scope, provided status reports, performed recruiting, firing and project resource planning. Conducted presentations and closed sales of Internet based (B2B) services and products. 
Technologies/Programs Used: Microsoft SQL Server 6.5, FRx Reporting, Crystal Reports, MS Access 97, Visio, ASP, JavaScript, VBScript, VBA, Excel, IIS, MS Exchange, UNIX, Oracle.

Sr. Software/Systems Developer

NCA Consulting, Inc
-
Schaumburg, IL
-

1996 to 1999

Designed, developed and tested software tools assisting field engineers in the installation and modification of various telecommunication (BTS) equipment. Project involved full software life-cycle stages including detailed requirements gathering stage and testing phase. 
Technologies/Programs Used: UNIX, C, C++, Perl, Oracle, TCP/IP. 
 
project: United airlines, elk grove village, IL 
Sr. Software Developer 
Designed and developed two major components of the Flight Network Optimization System. Worked closely with Mathematicians to transfer mathematical models into working software. Involved in design, programming, unit and system testing of the produced software. 
Technologies/Programs Used: UNIX, Oracle, C, C++, Orchestrate 
 
project: Walgreens, Deerfield, IL 
Sr. Programmer Analyst 
Wrote the middle layer of the client/server communication protocol between pharmacy's In-Window and the doctor's office. Connectivity between the two entities was accomplished using Tuxedo messaging architecture. 
Technologies/Programs Used: UNIX, Oracle, C, Tuxedo, TCP/IP. 
 
project: Sears roebuck & co., hoffman estates, IL 
Software Developer 
Converted existing point of sale system from OS/2 to Windows NT platform. 
Wrote generic transaction building system that generated computer transactions of various formats based on user's configuration. 
Technologies/Programs Used: UNIX, Windows, OS/2, Oracle, Informix, C.

Software Developer

k-2 Technologies, Inc
-
Columbus, OH
-

1994 to 1996

Co-authored client/server system responsible for managing daily operations of the steel processing plant. Project involved requirement's gathering, code implementation and testing. 
System controlled the operation of various machines on the factory floor as well as was responsible for scheduling. 
Technologies/Programs Used: VX-REXX, DB2, OS/2, VB 4.0. 
 
TEACHERS CREDIT UNION, SOUTH BEND, IN 
Programmer Analyst 
Utilizing client/server architecture model designed and developed statewide Automatic Teller Machine Balancing and Transaction Processing system. Performed AIX system administration. 
Technologies/Programs Used: SQL Server 6.5, AIX, DB2, VB 4.0, VX-REXX, 
 
Pentek corporation, Indianapolis, In & MANCHESTER, England 
Software Engineer 
Installed, modified and developed embedded software for the computerized material handling system. Wrote communication protocols and designed algorithms controlling factory machinery. 
Technologies/Programs Used: QNX, Windows, C, VB 4.0.

Education

Master of Business Administration

Bellevue University

2006

Master of Science in Computer Science

Queen's University

1993 to 1994

Bachelor of Science in Computers Science

Indiana university

1993

Doctor of Information Systems in Research Area

The Robert Gordon University