Mark Raduenzel

Experience

• 

  M&M Mars

  Oct 1992 - Mar 1996

  Developer

   Built and managed a database application (using Lotus Approach) that allowed users to track product shipment and decrease the amount of inventory required on-hand to satisfy shipping requests. With no former experience, queried relational databases with SQL to create “ad hoc” 4GL reports for end users and dramatically increased the response time to user requests for reports by quickly becoming proficient in relational database structure and SQL. Created, edited and maintained network and PC specific batch files to allow for customizing network logon procedures. Show less

• 

  CNA Insurance

  Jul 1994 - Mar 1998

  Developer

   Developed a “ScheduleF” application in Visual Basic 4.0 using ODBC to process financial data stored in SQL Server for quarterly review by the National Association of Insurance Commissioners (NAIC). The ScheduleF application allowed users to enter and view ScheduleF and Letters of Credit (LOC) data and generate required reports utilizing Crystal Reports. Completed the project on time despite tight deadlines and constantly changing user requirements. Built a Microsoft Access 2.0 application to facilitate the analysis of potential future exposures for collection. Data was imported into Access from disparate data sources (i.e. MACR, Excel spreadsheets) and greatly improved the company’s ability to identify potential future exposures. Was instrumental in the design, development and implementation of a vendor developed software package (Pro-Cede) that incorporated all major functions for processing reinsurance business. Show less

• 

  Allstate Insurance

  Apr 1998 - Oct 1999

  Lead Developer

   Developed and maintained applications in Visual Basic 5.0 for reinsurance companies to track and report on claims with which the insurance company had a large exposure. The Strategic Claims application used ADO and relied heavily on SQL Server stored procedures to provide greater maintainability and scalability. Managed the implementation of ceded reinsurance processing systems and performed data conversions from legacy (i.e. DB2, MACR, Teradata) to client/server platforms such as SQL Server. Created standardized reports using SQL Server stored procedures and Crystal Reports to include in reinsurance applications. These reports could be plugged into existing applications with minimal effort, making them easy to maintain and customize. Designed and developed a General Ledger (GLInterface) reporting application using Visual Basic 5.0. The GLInterface application used SQL Server stored procedures to extract general ledger data according to predefined criteria and export the data to flat files for later analysis. Show less

• 

  Abbott Laboratories

  Nov 1999 - Feb 2002

  Developer

   Helped design and develop, in Visual C++, the Worldwide Laboratory Information Management System (WWLIMS). WWLIMS is a high profile, mission critical application that allows users to author and execute diagnostic tests, stored as XML documents, of health care products. Developed Statistical Process Control (SPC) applications using Visual Basic 6.0 for presenting graphs in order for users to visually analyze test results of a product.  Designed and developed a set of applications in Visual Basic 6.0 to track the stability of products intended for the marketplace. These applications accessed Oracle data to produce graphs to easily indicate when a product was not stable enough for release. Created and implemented Windows NT services using Visual C++ 6.0 to generate Adobe Acrobat Portable Document Format (PDF) files and send them to a Lotus Notes database, streamlining an existing process and making it less error prone and easier to maintain. Rewrote and enhanced existing failure investigations in Visual Basic 6.0 to capture corrective action information for failed test results. Using Oracle database objects (i.e. triggers and packages), significant business logic was added to make the applications more intuitive and robust. Developed an on-line reporting system using ASP, VBScript and ADO to allow users the flexibility of retrieving reports via a web browser anywhere in the world. Created ActiveX controls in Visual Basic 6.0 and Visual C++ 6.0 to display testing data in a customized hierarchical format. Customized an existing Visual C++ 6.0 application to provide more detailed reports to the Food and Drug Administration (FDA), saving the client $250,000. Show less

• 

  Industrial Storage Warehouse

  Apr 2002 - Jul 2005

  Lead Developer

   Completely re-architected and rewrote the Public Warehouse Package (originally written with VB 6.0) in Visual Basic.NET and C# to create a more stable user interface and greatly increase the maintainability of the application. Additional required functionality was also identified and incorporated. Served as technical lead over a small group of developers, overseeing the software architecture, design and coding. Developed architecture and data model in Sql Server 2000 to handle the major business functions of warehouse inventory tracking and billing. Used C# and VB.NET to implement components and enhancements to software applications to incorporate new functionality such a rendering and storing Adobe Acrobat (pdf) files, customer notifications via SMTP of inventory coming and going out of the warehouse and XML documents containing a customers inventory data. Integrated Sql Server Reporting Services into the Public Warehouse application to provide the end users with a comprehensive and flexible reporting solution. Designed and coded modules in C# and VB.NET to automatically generate invoices and send to the customer based on the movement of inventory into and out of the warehouse. Developed a storage location module, using C#, to allow the users to visually assign and retrieve an inventory item associated with a specific location in the warehouse. This module created a much more efficient warehouse by eliminating the need for employees to search for a particular item in the warehouse. Show less

• 

  Xerox Capital Services

  Jul 2005 - Jul 2006

  Lead Developer

   Came onto the Campaign Manager project half-way and drove the project to a successful implementation on time and within budget using C#, Sql Server 2000 and Oracle 9i. The application increased call center productivity by providing the Business Center with a flexible solution which could queue calls to Collectors based on Tiered Collection strategies, specific revenue streams or targeted aging parameters. Assisted in the development and implementation of a Proration Data Tool (C#, Sql Server 2000) which performs calculations of invoice charges for installs and removals on contracts and used Microsoft Office Interop to write the data to a Microsoft Excel worksheet. Implementation of this application improved productivity, decreased error rates and saved approximately $40K/month in labor costs. Modified an existing ASP.NET/C# application which pulls data from a Sql Server database and creates an embedded Microsoft Excel worksheet. The changes to this application resulted in a productivity savings for field Account Associates of approximately 40 hours per month because the Account Associate no longer needs to added requested information manually. Created a Windows client C# Billing Calculator application which scrapes text from a Rumba screen, allows additional user input and posts calculated billing data to another Rumba screen. By automatically populating Rumba with data from a single interface, the users were able to eliminate data entries thereby increasing associate productivity, reducing input errors and minimizing the likelihood for lost revenue associated with input errors. Designed and developed a Windows Service using C# to manage contracts in a workflow application. The Windows Service maintained a list of contracts within a queue and allowed client applications to connect and interact with the queue using Remoting. Show less

• 

  Calamos Investments

  Mar 2006 - Oct 2009

  Lead Developer

   Designed and developed a centralized Sql Server 2000 Data Mart database with accompanying Windows C# user interface. The Data Mart was fed by internal corporate systems as well as external vendors and internal users. The user interface was required for the ability to review and approve data points for a given period. After all data points were approved and published the, data was used to create Quarterly Client Portfolio reports. Modified the highly visible and mission critical (C#) Mutual Fund Pricing application to include an option to process pricing exceptions without including Bloomberg and IDC fair value prices. This was intended to manage the risk of Bloomberg and IDC prices stopping the firm from striking the nightly Net Asset Value (NAV). Also, added functionality to reduce the number of exceptions that required review by the traders, and upgraded the application from Visual Studio 2003 to Visual Studio 2005. Designed and developed a C# Windows Console application that would examine the internal Market Data Sharepoint site for SDLC compliance of projects in order for the group to qualify for ISO certification. The console application was fully extensible and was designed with the concept of plug-ins in mind so that different compliance modules could be easily added. All warnings and violations were logged to a flat file and emailed to the appropriate Project Manager’s as well. Extended and enhanced the previously developed Data Mart database and application to include Institutional portfolio characteristics and performance data. Enhancements included Undo functionality, optimistic concurrency checking, increased performance, automatic refresh of changed data points, exporting multiple data points to Excel and a comprehensive account load status display. Show less

• 

  ULTA Beauty

  Jan 2010 - Apr 2017

  Senior Developer

   Reviewed and analyzed business requirements created by the business team to generate functional specifications, high level system architecture diagrams, use cases and detailed application technical designs used to drive the build phase.  Organized project tasks for developers, provided time estimates, performed code reviews, triaged defects with the QA team and coordinated the completion of deliverables within budget and time constraints. Assisted in the architecture, design and development of a Loyalty system which allows the business to award points to customers based on sales. The complex system was developed using C#, ASP.NET using HTML, CSS, JavaScript and used WCF web services to communicate with a Sql Server 2008 database. Designed, implemented and supported enterprise data integration solutions between internal systems, third-party application and third-party vendors. Designed and developed multi-threaded applications to process millions of Loyalty members in Sql Server for batch processing. These processes were designed to use minimal resources as well as minimize blocking to other transactions being processed concurrently.  Analyzed stored procedure execution plans and implemented modifications to the stored procedures to increase the performance of database calls and prevent timeouts/deadlocks. Through the database tuning process, recommended additional indexes for tables to increase the performance of queries and restructuring queries as necessary. Lead both onshore and offshore consultants in project efforts and resolving production defects of the Loyalty system. Provided technical direction and mentoring to consultants on a frequent basis to implement changes requested by the business partners. Show less

• 

  KPMG

  May 2017 - now

   Closely collaborated with senior stakeholders, project managers and business analysts to understand business requirements and then conceptualize, design, and implement on-prem and Microsoft Azure software solutions and enhancements. This includes defining and documenting non-functional requirements such as scalability, reliability, performance, security, logging, monitoring, etc.  Worked with the project manager to define software development project plans and documenting project constraints including scoping, estimating, budgeting, scheduling, and implementation. Designed technical solutions to meet business requirements. On most applications implemented, the design phase meant working with stakeholders to finalize scope, Security teams to assess risk & compliance, Azure infrastructure engineers to create a technical architecture, and UI/UX designers to create a functional web site design. Depending on the complexity of the project, a proof-of-concept or prototype was developed.  Presented the solution design to the stakeholders and development team so that all team members have a shared vision. At times, the business was presented with various options resulting from the design so they would understand the tradeoffs between time estimates, cost, and technology.  Cooperated with stakeholders to define product roadmaps. For initial developments this often included breaking a development effort out in phases. Further negotiated with the business on what the roadmap will contain based on priorities, estimates and budget. Lead the development team in the implementation phase of the projects. This involved creating user stories, assigning tasks based on priorities, clarifying application functionality for the team, working with engineers to stand up Microsoft Azure environments, reviewing code and examining QA test plans for completeness. Show less

  • Associate Director

    Sept 2024 - now

  • Technical Lead, Manager

    May 2017 - Sept 2024