MARK GRONDY

**** *. **********

Chicago, IL ***13

773-***-****

Email: acok1o@r.postjobfree.com

Summary:

. Hands-on manager/developer in all SDLC phases with 19 years practical

experience

. Proven work in team building and a superior communicator that

understands ownership, success and closure

. Vertical expertise with Trading/Clearing in Capital Markets, Financial

Services, Brokerage, Insurance, Manufacturing/Supply Chain,

Warehouse/Distribution, Finance/Accounting, Aviation/Aerospace,

Engineering, Leasing, Metals, Real Estate, State/Local Government, and

Non-Profit

Professional Experience:

Chicago Clearing Corporation (CCC)

6/2010 - Present

Consultant

. ETL Database developer/DBA (Python, C#/VB.NET, MySQL, SQL Server) for

Market Maker over Multi-asset and Fixed Income classes typically related

to securities class action settlements for clients consisting of

brokerage houses, hedge funds, investment advisors, banks/bank trusts,

high net worth individuals, family/state pension plans and insurance

companies.

. Created basic web interface in SSRS (VS2008) which matched customers'

securities holdings in litigation against the case files to compute due

settlements. The application queried the customers' positions in the

affected asset class and presented eligible amounts for settlement in an

Excel report.

. Designed/Built several VBA apps to automate many procedures to process

mark-to-markets and various data scrubbers

Built Python, MySQL, VB/C#.NET and SSIS/SSRS (VS2005) applications that

moved data back-forth between unlike repositories. Python portion

scrubbed unstructured data, read flat transaction file containing

financial adjustments to customer positions. The adjustment amounts were

matched against the key fields for the appropriate customers that existed

in MySQL tables. The updated tables were migrated to SQL Server to

better bind with SSIS and SSRS.

Tata Steel Americas (formerly British Steel, Corus), Schaumburg, IL

6/2005 - Present

Technology Manager and Developer/Analyst

Responsible for comprehensive ITSM including staff, contractor, PMO,

performance vs. goal review and budgeting. Fully responsible for vendor

procurement and disposition. Used Agile Methodology hybrid for most

projects.

. Built several customizations and extensions to MS Dynamics 5.0 using

C#.NET, VB.NET, VBA, Python, SSRS, SSIS and SSAS

. ERP Supply Chain and Financials project manager (and part-time

developer/analyst) for complete rewrite from Baan IV/Oracle 8x to MS

Dynamics NAV (Navision) 5.0/SQL Server for 100 internal users located in

the U.S., U.K. and Middle East. Recognized by Senior Management for

outstanding 'people skills'.

. Built a worldwide hierarchical team of 15 from 'scratch' by personally

interviewing, evangelizing and getting buy-in for the project. Rich

experience in the 'soft-skills' of large software implementations enabled

matching skillsets to project roles such as Workpack leads, Process

thread managers and Testers.

. Saved $580K per year in license, support and maintenance fees through

elimination of 6 adjunct systems. Saved $400k per year in consultants

fees.

. Fully responsible for architecture and systems design and development

strategies, its associated hardware requirements as well as data

sensitivity and security issues.

National Association of the Boards of Pharmacy, Mount Prospect, IL

5/2005

Consultant

. Instructed IT Staff and Management of 6 individuals how to best use the

Oracle Applications 11i Trading Community Architecture (TCA). Built

queries to initialize entire data warehouse.

Underwriters Laboratories, Northbrook, IL

11/2002 - 5/2005

Developer/Technical Lead of Systems Development

. Gap analysis, conversion and implementation of over 25 enterprise legacy

applications' integration with Oracle Applications 11i (11.5.8) modules

including Installed Base, Order Management, Service Contracts, Inventory,

iReceivables, GL, Advanced Planning/Scheduling and TCA.

. Team Lead and Developer on 10 person Project Team which built the UL

Customer Home Page (myhome.ul.com) enterprise portal in Oracle 10g and

9ias (9.0.4).

. Despite the team being 'green' and on a lean budget, pilot users

expressed feedback resulting in 'buy-in' and sponsorship from Top

Management Team. Successfully implemented offshore and in-house

outsourcing initiative.

. Hands-on capabilities in their underlying technologies such as Cold

Fusion 5.0, VB 6.0, Oracle Forms/Reports.

Oracle Corporation, Chicago, IL

10/1998 - 11/2002

Principal Consultant

Implementation and Development for large Supply Chain/CRM Systems and

international deployments of Oracle Financials, Manufacturing and CRM

Release 11x. Oracle 'Site Manager' fully responsible for consultant (and

sub-contractor) ramp-up and ramp-down processes.

. For McDonald's Corporation World Headquarters: Manager over 30

developers owning the "main artery" of the Supply Chain Optimization

System for Happy Meal Toys, which saved company in excess of $3 million

per annum. Chief development liaison to governance (PMO) and QA sector

focusing on 'zero defect' releases plus administration, implementations

and versioning.

. For Principal Financial Group World Headquarters: Dual

functional/technical team lead for implementation of Oracle Sales

Compensation (CRM) over the sales and commission process. Addressed

functional gaps in ERP by creating new insurance vertical "bolt-on"

module (Advance and Recovery) for Oracle Sales and Marketing. Led

various 4 to 12 member teams.

Thomas-Gont Enterprises, Inc., Hillside, IL

1997 - 1998

Consultant

Technical lead for Microsoft and Oracle development projects.

. For United Airlines World Headquarters: Led process re-engineering,

project management and development/implementation of the airline's

minority (MBE) purchasing, procurement and vendor tracking system.

. For Budget Rent-A-Car World Headquarters: Responsible for requirements,

technical design and installation of fleet forecasting system.

Functionality consisted of a hybrid OLAP and BI/DSS which formulated

mileage, age and various logistical histories to compute fleet

optimization levels.

. For City of Chicago Department of Aviation: Provided system development

and technical lead for rewrite of agency's human resources and

procurement department.

Fixed Income Clearing Corporation (FICC), Mortgage-Backed Securities

Division, New York, NY

1990 - 1997

Technical Analyst (1996 - 1997)

. Analysis/Development of client/server application (VB5-VB6) providing

user (OLTP) interface to Electronic Pool Notification (EPN). EPN

accommodated secondary trading of mortgage pools ahead of settlement

date. Solved the "need for speed" allowing transmission of 'bulked up'

information before intra-day cut-offs. Enhanced product based on

industry requirements. EPN achieved high praise for its quick time to

market, ease of use and scalability.

. Defined and wrote numerous SAS applications for market surveillance on a

major New York OTC securities exchange. Tracked wash trading patterns and

other illegal schemes resulting in identification of compliance violation

of member firms.

Manager of Operations (1994 - 1996)

. Hiring and supervision of 5 staff members administering major New York

financial exchange's clearing division.

. Managed Mortgage-Backed Securities (MBS) and MBS Options Clearing

operations, compliance, margin, cash settlement, accounting, technical

operations and billing.

. Maintained and administered Members' settlement and collateral funds

typically exceeding $4 billion per day.

Product Analyst (1990 - 1994)

. Defined, evaluated and developed legacy system enhancements to the

clearing process of MBS and MBS Options. Analyzed opportunity, risk,

cost, operating needs and market potential via member survey.

. Provided consultation to current and potential member firms and

recommended best-suited data communications services.

Chicago Stock Exchange, Chicago, IL

1987 - 1990

Registered Representative/Corporate Trust Officer

. Team Lead of Series 7 Registered Representatives responsible for

coordinating corporate reorganizations.

Geldermann, Incorporated, Chicago, IL

1986 - 1987

Arbitrage Clerk

. Trader's assistant responsible for order entry for hedge and large retail

accounts on the floor of the Chicago Board of Trade in the Treasury Bond

futures and options markets. Duties included error trade resolution and

short-term inter-market analysis.

Capabilities:

Skills/Techniques

Custom and ERP Software/Systems Development Lifecycle, Business and Gap/Fit

Analysis, Applications Development/Implementation, Data Conversion,

Technical Architecture, System Performance Management, Process

Reengineering, Database Installation, Tuning and Instance Management,

OOP/OOD, Disaster Recovery, Project Management,

Methods

Oracle Applications Implementation (AIM), Oracle Custom Development Method

(CDM), JAD, RAD, PRINCE2, ASAP, Agile.

Tools, Protocols & Languages

VB6, ASP, VB.NET, SSIS, SSRS, VBA, C, Java, Cold Fusion 5.0, HTML, SAS,

COBOL, Microfocus COBOL, SQL, PL/1, Perl, Python, Unix/Linux shell scripts

(.ksh, .csh, .nawk, .awk, .sed), ERWin, Access Forms/Reports, Crystal

Reports, Lotus Domino, Salesforce.com, Visual Source Safe, PVCS, Rational

Clear Case, Kintana, MQ Series, Mercator, EDI (X.12, EDIFACT). Oracle

Tools: Developer/Designer/Discoverer/Forms 6i/9i, Reports 6i/9i,

SQL*Loader, SQL*Plus, TOAD, PL/SQL, PRO*C, 8iAS, 9iAS, Oracle Portal 9ias

(R2), Oracle AQ 8.0.x/8i, OEM, Oracle Application Server (OAS) 4.0, Web

Application Server 3.0.x, SQL*Net 1.x/2.x, Oracle Workflow

ERP

Oracle Manufacturing (INV, BOM, ENG, OE, OM) 11.0.x/11i, Oracle Financials

10.7, 11x, 11i (AP, AR, HR), Oracle CRM 3i, 11i (Sales Compensation, Sales

and Marketing, Service Contracts, Installed Base), MS Dynamics NAV 4.0/5.0,

BaaN IV, Manugistics

Database

Oracle DBMS 11x, 10x, 9i, 8.0.x/8i/8.1.x, 7.x, MS Access 2.0/97/2000, SQL

Server 7.0, Sybase ASE, MySQL

Hardware & Operating Systems

SUN-SOLARIS UNIX 2.6/2.7, HP-UNIX, AIX, NT Server, VMS, MS Windows

NT/2000/XP/2003, VOS, MS DOS, SunOS 5.x, IBM PC and compatibles, Compaq

Proliant 5000, Sun Enterprise 4500, Sun Ultra 10000, Sun E10K, STRATUS

Education

DePaul University, Chicago, Illinois, M.A. Information Technology.

Illinois State University, Normal, Illinois, B.S. Economics.

References

Available upon request

Contact this candidate