MARK GRONDY

**** **** ****, *******, ******** ***57

773-***-**** • adkuf8@r.postjobfree.com

INFORMATION TECHNOLOGY

A senior IT professional with a strong business acumen and the proven ability to develop and create infrastructure tools to improve efficiency, security, system stability, and accuracy. Expertise in database programming, custom application development lifecycle, business analysis, data conversion, technical architecture, IT project management, and process reengineering. Excellent communication and problem-solving skills.

MELLON INVESTMENTS CORPORATION, Boston, MA 2020 to Present

Global Investment Manager.

Senior Database Developer

Responsible for ETL development, Interfaces, Integrations, Reports for new system implementation.

Wrote/Re-wrote several Oracle and Microsoft-based objects to accommodate migration from Charles River to Black Rock.

TATA STEEL AMERICAS (Formerly British Steel, Corus), Schaumburg, IL 2005 to 2020

Leading international manufacturer of hot and direct rolled, metallic coated, tube, and electrical steel.

Technology Manager/Senior EDI Analyst

Reporting to the CFO. Responsible for end-to-end EDI, Micro-Services and ETL development. Database Developer/DBA, ITSM including staff, contractor, vendor procurement/ performance vs. goal review. Oversaw team of up to 15 direct reports (FTE and consultants) and up to an annual budget of $5 million.

Wrote several EDI (B2B eCommerce) platforms originally with SQL Server backend, then migrated to Azure SQL using Data Factory, Data Lake and SQL Data Warehouse. Interfaces are RESTful. Administration apps written in C# and Python.

Moved JSON, XML and EDI data between trading partners. Included automated routines which scrubbed and formatted transactions from unlike data sources.

Created customizations and extensions to Order Management System MS Dynamics NAV using C#.NET, VB.NET, VBA, Python/Spark, SSRS/SSIS/SSAS, SAP Business Objects, Power BI and Tableau.

CHICAGO CLEARING CORPORATION, Chicago, IL 2014 to 2015

Industry leader in securities class actions claim filing, claims monetization and class action solutions.

Part-time contractor/developer

ETL Database Developer/DBA for Market Maker over Multi-asset and Fixed Income classes related to securities class action settlements. Clients consisted of brokerage houses, hedge funds, investment advisors, banks/bank trusts, high net worth individuals, family/state pension plans and insurance companies.

Created web interface matching customers’ securities holdings in litigation against the case files to compute due settlements.

Designed/Built several VBA apps to automate procedures to process mark-to-markets and data scrubbers.

Built Python, MySQL, VB/C#.NET and SSIS/SSRS exchanging data between unlike repositories. Results were migrated to SQL ODS to better bind with SSIS and SSRS.

UNDERWRITERS LABORATORIES, Northbrook, IL 2002 to 2005

A global independent, non-profit safety science company dedicated to advancing the UL mission.

Developer/Technical Lead of Systems Development

Reported to the Systems Director. Responsible for gap analysis, conversion and implementation of 25+ enterprise legacy applications’ integration with Oracle eBusiness Suite 11i (11.5.8) modules including installed base, order management, service contracts, inventory, iReceivables, GL, advanced planning/scheduling and TCA on Unix.

Team Lead and Developer on 10 person Project Team which built the UL Customer Home Page (myhome.ul.com) enterprise portal using J2EE.

Pilot users expressed feedback resulting in ‘buy-in’ and sponsorship from Top Management Team.

ORACLE CORPORATION, Chicago, IL 1998 to 2002

An American multinational computer technology corporation offering its own brands of database systems.

Principal Consultant

Reported to the Senior Practice Manager. Responsible for 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: Managed 30 Developers owning main artery of the Supply Chain Optimization System for Happy Meal Toys; saved company $3M+ 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: Led various 4- to 12-member teams in the 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.

FIXED INCOME CLEARING CORPORATION, New York, NY 1990 to 1997

DTCC subsidiary which reduces costs and gives customers common approach to fixed income transaction processing.

Technical Analyst and Operations Manager

Analysis/Development of client/server application providing user (OLTP) interface to Electronic Pool Notification (EPN). EPN automated the allocation (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 schemes resulting in identification of compliance violation of member firms.

Hiring and supervision of 5 staff members administering major New York financial exchange’s clearing division.

CHICAGO STOCK EXCHANGE, Chicago, IL 1987 - 1990

Registered Representative/Corporate Trust Officer

Team Lead of Series 7 Registered Representatives responsible for coordinating corporate reorganizations and supporting systems.

GELDERMANN, INCORPORATED, Chicago, IL 1986 - 1987

Arbitrage Clerk

Trader's assistant responsible for order entry for hedge and large retail accounts on the CBOT floor (Treasury Bond futures/options). Duties included error trade resolution and short-term inter-market analysis.

EDUCATION

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

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

TECHNICAL SKILLS

Methods: Agile, Oracle Applications Implementation (AIM), Oracle Custom Development Method (CDM), JAD, RAD, PRINCE2, ASAP

Tools, Protocols & Languages: ASP, VB.NET, SSIS, SSRS, Tableau, Power BI, Qlik, Informatica, VBA, XML, C/C#, Java, HTML, SAS, SQL, REST, Perl, Python, Unix/Linux shell scripts (bash, .ksh, .csh, .nawk, .awk, .sed), ERWin, Access Forms/Reports, Crystal Reports, QuickBooks, Salesforce.com, JIRA, Confluence, Azure SQL and DevOps, github, Visual Source Safe, PVCS, Rational Tools, Kintana, MQ Series, Mercator, EDI (X.12, EDIFACT, ODETTE)

Oracle Tools: Developer Forms/Reports 9i/10i, SQL*Loader, SQL*Plus, TOAD, PL/SQL, PRO*C, SQL*Net

ERP: Oracle Manufacturing (INV, BOM, ENG, OE, OM) 11x, Oracle Financials 11x (AP, AR, HR), Oracle CRM 11x, MS Dynamics NAV 4.0/5.0/2009/2013/2015, BaaN IV, Manugistics

Database: SQL Server, Oracle, MS Access, Sybase ASE, MySQL, PostGRE; Relational, Star and Snowflake Schemas

Hardware and Operating Systems: SUN-SOLARIS UNIX, HP-UX, Linux (Debian, Ubuntu), AIX, VMS, MS Windows, VOS, Stratus

Contact this candidate