Christopher Gorka

*** ***** ***** ******

Princeton, NJ 08540

Home phone: 732-***-****

Email address: acricg@r.postjobfree.com

Summary

Extensive database, Business Intelligence (BI), Data Mining, Data Warehousing, data marts OLAP and SOA expertise. Machine Learning proficient. Experienced C#, ASP.NET/MVC, Window Services, WCF Services, WCF, SOA, SSIS, SSAS architect and developer. Performance optimization and analysis. Project and operation management, result driven, strong leadership skills. Practical exposure to the variety of development methodology from Waterfall to Agile as well as Extreme Programming. Understanding wide range of computer technologies and services. Hands-on software development and network engineering. Knowledge of encryption and security methodologies. Experience working in and managing the entire software development lifecycle (SDLC). Enterprise Application Integration (EAI) and business.

PROFESSIONAL

EXPERIENCE

07/2002 – present Deutsch Inc. (IPG) New York, NY

(Creative Advertising Agency – part of global Interpublic Group)

Architect, BI & Software

Responsible for relational and dimensional database architecture (logical and physical data models), data integration, and web applications. Conducts proofs-of-concept and develops prototypes. Team and consultants management. Acts as a business process architect and catalyst.

Examples of solely delivered solutions:

Programed an orchestrated array of Windows Services, utilizing API like EWS to facilitate enterprise data integration.

Created digital Advertising data warehouse with Analysis services cube representation and client facing Tableau’s visualization (dashboard).

Introduced and propagated R project utilization for statistical computing.

Based on SSAS, built enterprise international multi brand fee entry and reporting system with many to many currency conversions.

Built complex, client staffing plan profitability performance system using MS SQL server, Analysis Services and MS office application written in C# to forecast, analyze fulfillment, report and data mine employee time and compensation.

Created SSAS based cubes to report enterprise employee compensation, benefits and taxation.

Designed and implemented agency wide data warehouse, incorporating internal and enterprise OLTP data to serve OLAP and reporting needs.

Designed and developed Freelance Management System driven by a transactional database: web applications (C# and Ajax) incorporating very intuitive timesheet entry system, freelancer assignment entry, fulfillment, and reporting.

Created Hyperion EssBase based financial system incorporating ADP (Oracle) and PeopleSoft payroll data, timesheets (hosted on SQL server) and financial, transactional data downloaded from legacy mainframe system. Created fully automated data transformation (ETL) and notification system based on Microsoft Data Transformation Services (MS DTS) with incorporated VPN and encrypted FTP data delivery. Implemented GL, sophisticated compensation allocation and client profitability data marts.

04/1992 –02/2002 Media Planning Group (Havas Advertising) New York, NY

(Multinational Advertising Agency specializing in media buying, planning and research)

IT Director

Responsible for US Java platform development and database web delivery.

SAS 8.2 data warehousing and data mining design and implementation. Built data marts representation of corporate financial and TV viewership data. Used MOLAP, ROLAP and HOLAP models to facilitate various data storage and retrieval speed requirements.

Microsoft Analysis Services data warehousing implementation. Extensively used Erwin for data modeling.

Programmed legacy, mainframe non-relational database, automatic extraction, transformation and load process (ETL) over WAN into relational MS SQL 7.0 server database. Extensively used Data Transformation Services (DTS) to facilitate automatic data transformation and cleansing. Created SAS data warehouse serving the content to the corporate intra/extranet. Programmed OLAP, JSP/Servlets (Model-View-Controller) based, corporate database exposure with seamless Lotus Notes intra/extranets and security integration. Used extensively JDBC and Java Beans.

Page 2 of 2

Built web application for multidimensional aggregated data (cubes) presentation based on SAS data warehousing and J2EE technology with automatic Oracle DB synchronization. Implemented internationalization for English and Spanish.

Designed performance optimized, MS SQL server based, relational TV ratings database. Wrote client/server (Visual Basic 6.0), National TV reporting system automatically retrieving flat file type TV ratings from Nielsen’s Website and uploading into MS SQL sever to allow advertising industry specific reports generation.

Resume of Chris Gorka

Provided MS SQL server 7.0/2000 database administration, data modeling, database normalization and client/server software development. Programmed triggers and stored procedures.

Implemented ASP Citrix MetaFrame 1.8/MS Windows 2000 Terminal Server solution with Secure ICA over Internet to accommodate remote offices operations. Initiated NFuse deployment.

Wrote (C/C++) innovated Artificial Intelligence system to verify in real time TV commercials occurrence (CMR database) and to assign Nielsen’s ratings for any demographic group.

Implemented NT 4.0/2000 Network, incorporating 10+ servers, connecting over 500 hosts. Provided initial administration and troubleshooting. Design WINS/DNS architecture for multiple US offices. Completed network design, implementation and testing phases of the project.

09/1989-04/1992 Joseph E. Seagram & Sons, Inc. New York, NY

Network Engineer (consultant)

Responsible for Novell implementation and mainframe connectivity deployment.

Built Novell servers based on Compaq Hardware. Installed Novell Netware server software, configured Novell NLM.

Installed and configured massive storage devices, such as hard drive arrays.

Performed Server and PC hardware/software configuration and troubleshooting.

04/1986- 09/1989 National Academy of Sciences

Scholar/Researcher

Microprocessor embedded hardware and software design for speech synthesis, analysis and recognition. DSP research for vocoder applications.

Built speech synthesis PC card and microprocessor controlled device, which become commercially available.

Designed microprocessor based, real time 240-point Fast Fourier Transforms Analyzer.

TECHNICAL SKILLS

SSIS, SSAS, SQL, MDX, C#, SOA, ASP.NET/MVC, Microsoft.NET Framework. 1.1-4.5, WCF, WCF services, Big Data, Hadoop, Hive, Mahout, MongoDB, Machine Learning, Windows services, Multithreading, REST, JavaScript, Nood,js, Hyperion, R, Assembler (x86, 68x, etc.), XML, SOAP/WSDL/DISCO/UDDI, RDBMS, COM/DCOM, UML, ADO.NET, ADOMD.NET, ADOMD, XMLA, PKI, C++, OOAD, SCSI, RAID, EWS, MS SQL server 2005/2008/2012/2014, MS Analysis Services (2008/2012/2013), Tableau, IIS Web server, Apache.

MS Visual Studio.NET 2013, Visio for Enterprise Architects, MS Visio, Erwin, MS Office.

MS Windows server 2008/2012/2014, Windows Virtualization, Window Azure, Citrix MetaFrame, Linux.

Proficient in digital and analog electronics.

Cisco switches, Ethernet, Cisco routers, CSU/DSU, firewall, ISDN, xDSL, Frame Relay,

T1/E1, PBX, SNA, IPX/SPX, TCP/IP, RPC, DNS, LDAP, IMAP4, POP, SMTP, VPN, PKI, SSL,SIP.

EDUCATION

1986/89 National Academy of Sciences

Scholar, PhD candidate in Computer Science

1986 Poznan University of Technology

Master’s Degree in Electrical Engineering

Major: Digital Control Systems, Automation and Electrical Metrology.

Contact this candidate