Please contact me for a copy of my resume - this, online resume has been deleted.
Sr. Business Intelligence/ SQL Server Consultant III
August 2012 to Present
Business Intelligence Architect & Analyst
June 2011 to July 2012
Sr. IT & Business Analytics Managing Consultant
March 2010 to May 2011
Sr. Management Consultant
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
April 2008 to March 2009
Director of e-Commerce Services
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.
2005 to 2008
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.
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.
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.
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.
Sr. Software/Systems Developer
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
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.
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
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
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.
Master of Business Administration
Master of Science in Computer Science
1993 to 1994
Bachelor of Science in Computers Science
Doctor of Information Systems in Research Area