SUMMARY

• Extensive database, Business Intelligence (BI), Data Mining, Data Warehousing, data marts OLAP, Object - Oriented Programming (OOP) and Service-Oriented Architecture (SOA) expertise. Machine Learning (Neural Networks, SAT/SMT solvers, Bayesian networks) 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.
• Robotic Process Automation fanatic.
• 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.
• Experienced managing the entire software development lifecycle (SDLC).
• Strong Enterprise Application Integration (EAI) skills. SaaS, IaaS and PaaS within Azure. SaaS proponent.
• Multilingual, exposed to multiple cultures. Extensive travel record. American/European.

TECHNICAL SKILLS

• SSIS
• SSAS
• SQL
• MDX
• C#
• SOA
• ASP.NET/MVC
• Microsoft.NET Framework 4.6
• Entity Framework (EF)
• WCF
• WCF services
• MSMQ
• Big Data
• Hadoop
• Hive
• Mahout
• MongoDB
• Spark
• MapReduce
• Machine Learning: Neural Networks and Genetic algorithms
• SAT/SMT solvers
• Bayesian networks
• Windows services
• Multithreading
• RESTful
• JavaScript
• Nood js
• Hyperion
• R
• Assembler x86 68x
• XML
• SOAP/WSDL/DISCO/UDDI
• RDBMS
• COM/DCOM
• UML
• ADO.NET
• ADOMD.NET
• ADOMD
• XMLA
• PKI
• C++
• OOAD
• SCSI
• RAID
• EWS
• MS SQL server 2008/2012/2014/2016
• MS Analysis Services ( 2008/2012/2014/2016 )
• Tableau
• IIS Web server
• Apache. MS Visual Studio.NET 2017
• Visio for Enterprise Architects
• Enterprise Architecture with focus on TOGAF and Zachman methodologies
• MS Visio
• Erwin
• MS Office
• Oracle PBCS
• Robotic Process Automation
• Automation Anywhere
• Blue Prism
• UiPath
• MS Windows server 2008 to 2016
• Windows Virtualization
• SaaS
• IaaS and PaaS within Azure
• Citrix
• Linux.

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Architect, BI & Software

Responsibilities:

• Blue Prism RPA implementation initiative member (holding company - IPG project).
• Oracle EPM client profitability implementation - project management.
• Robotic Process Automation (RPA) introduction and deployment. UiPath implementation of automatic tabular data entry into SAP.
• Designed and developed hybrid, on premises and Azure cloud, Freelance Management System driven by a transactional database: web applications (C#) incorporating very intuitive timesheet entry system, freelancer assignment entry, fulfillment, and reporting. MVC and web forms integration (legacy code). Active Directory authentication for internal applications and ASP.NET Identity authentication for external freelancer facing application.
• Oracle Planning and Budgeting Cloud Service (PBCS) implementation.
• Programed an orchestrated array of Windows Services, utilizing API like EWS to facilitate enterprise data integration.
• Designed template of client facing web application delivering advertising analytics (Tableau engine, C# MVC, ASP.NET Identity framework).
• 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.
• NetSuite OpenAir integration with the corporate databases.
• Reengineered intranet, corrected authentication, email architecture, code of Employee Tracking Application, PTO and recruiting applications.
• 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 mining 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.

Confidential, New York, NY

IT Director

Responsibilities:

• 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. Lead the multinational team developing a comparable solution for the Mexican market.
• 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.
• Microsoft Analysis Services data warehousing implementation. Extensively used Erwin for data modeling.
• 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 server to allow advertising industry specific reports generation.
• Programmed legacy, mainframe non-relational database, automatic extraction, transformation, and load process (ETL) over WAN into relational MS SQL 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.
• Built web application for multidimensional aggregated data (cubes) presentation based on SAS data warehousing and J2EE technology with automatic Oracle DB synchronization.
• Designed performance optimized, MS SQL server based, relational TV ratings database. Wrote client/server, 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.
• Collaborated with Madrid (Spain) office in network integration.
• Provided MS SQL server database administration, data modeling, database normalization and client/server software development. Programmed triggers and stored procedures.
• Proposed and 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. Eliminated expensive need for across country Frame Relay deployment.
• Proposed and deployed MS Exchange server for corporate emailing.
• 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.
• 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.

Confidential, New York, NY

Network Engineer

Responsibilities:

• Built Novell servers based on Compaq Hardware. Installed Novell Netware server software, configured Novell NLM.
• Installed and configured massive storage devices, hard drive arrays.
• Performed Server and PC hardware/software configuration and troubleshooting.