Data Sql Server

Aleksandr Naroditskiy

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

Warminster, PA 18974

Cell: 267-***-****

E-mail: ************@*****.***

PROFILE:

I am known for providing organizational and technical leadership in dynamic environments. Direct, instruct, and coach team members, allocate work assignments, review progress, evaluate and report on performance. Extensive hands on experience in Business Intelligence, web, e-commerce, networking, hardware, telephony and client/server technologies. Expert knowledge in the advertising, CPG, publishing, healthcare and pharmaceutical industries. Experience developing mission critical systems while meeting scalability, availability, maintainability, performance requirements and infrastructure design. Managing on and off shore teams.

TECHNICAL

SKILLS

Languages:

VB.NET, C#, ASP.NET, Visual Basic 3.0-6.0, VB Script, ASP, CSS, Java, Java Script, HTML, DHTML, XML, C/C++, SQL, PL/SQL, T-SQL, Power Builder, Qbasic, embedded VB/C++/C#, shell scripting

Operating Systems:

Desktop: Windows XP/ Vista/Windows7/8/10, Linux, MS-DOS

Server: Windows Server 2000/2003/2008/2012, UNIX, Linux, OS/2

Mobile: Windows CE, Pocket PC

Databases:

Oracle 7.x-11g, MS SQL Server 6.5 -2005/2008/2012/2014, MS Access 2.0-2013, Sybase

Anywhere 5. x/7.0, MySQL, Sybase Adaptive Server 10.x/11.x, DB2 (BCU),

Netezza, Whitebox

ETL Tools:

SQL Server DTS/SSIS(ETL), Informatica, DataStage, Data Junction

Business Intelligence:

Crystal Reports/Enterprise, SSAS, SAP Business Objects, Microstrategy, Symphony RPM/AS

Utilities/Tools:

Install Shield 5-7, ActiveX, COM/DCOM, DAO, RDO, ADO, ODBC, TFS, WCF, SSRS,

InfoPath 2007, BizTalk, Windows API, MTS, MSMQ, IIS 4.0/7.0, Site Server 2.0, Erwin,

DeZign, VISIO, Adobe Photoshop 5.0-7.0/CS, Synchrologic, MOSS/SharePoint 2003-2013,

Microsoft office, Asterisk Finality PBX server, Elastix, FreePBX, GoAutoDial, Red Gate

Toolbelt, SQL Sentry, Jira, git hub

Virtualization:

Hiper-V, Xen, OpenVZ, WMware, Cloudmin, Vertualmin, Proxmox VE

EXPERIENCE

1/2017-

present

04/2016-

12/2016

Senior Solutions Architect

TCS, inc (client CVS/Omnicare pharmacy) Philadelphia, PA

Responsible for driving the architectural plans and designs for various functional application domains

Own the development and coordination of roadmaps depicting movement from current to future state

Guide the organization in reducing complexity and simplifying the delivery of services and solutions

Contribute to the execution of proofs-of-concept for new approaches and platforms

Participate in a high-level of collaboration and coordination with other architecture groups

Perform a consulting role with leadership in both business and application development to drive best in class technology solutions

Work collaboratively with business partners, product owners and product managers to develop and maintain business domain roadmaps aligned with broader enterprise technology strategy

Act as the subject matter expert for the functional domain to address application integration and infrastructure framework related questions

Work with vendors to understand emerging technologies, technical and functional roadmaps, and applicability to the environment

Senior Business Intelligence Architect (J.D. strategies consultant)

California Department of Railroad and Bridges (client) Hollywood, CA

03/2014-

04/2016

Developed roadmap for an enterprise-wide BI reporting and analytics platform

Defined the overall BI data architecture, including ETL processes, ODS, EDW,

MDM, data marts and Data Factory

Designed and build ETL processes

Recommended appropriate technologies to support the implementation of the BI

roadmap

Provided BI technical and architectural guidance to projects and teams, ensuring that

new initiatives enable effective data reporting

Collaborated with key business users to identify needs and opportunities for

improved data management and delivery

Developed reporting solutions as needed

Provided technical knowledge and business support to the BI team

Team Lead BI Solutions Architect/Senior SQL DBA Team Lead

ASI (http://www.asicentral.com ) Feasterville, PA

Pioneered, developed and implemented an entire environment to support company’s analytical efforts; starting from creating MDM, Data Factory (ETL) and Enterprise Data Warehouse.

As a solutions architect, I was responsible for the assessment of business requirements; collection and identification of technical specifications; and the subsequent development of technology solutions. As a team lead, I guided teams in right direction, gained consensus among clients and a team, and saw end to end implementation within timelines and of high quality. In my roles, I demonstrated high level knowledge of data integration (ETL), Data Warehousing and Business Intelligence concepts, and accountable for:

Served as sole subject matter expert in the development of Business Intelligence platform

Created Enterprise Data Warehouse and DataMart, help in identifying and revising enterprise reporting requirements

Created automated dynamic Data Load into Data Staging environment

Developed Star Schema and Snowflake models

Conducted strategy and architecture sessions, deliver artifacts such as MDM strategy and MDM architecture at detail level

Designed and optimized Data Mart schemes in order to handle the required dimensions and measures

Developed and maintained Business Objects metadata, universes, and reports

Managed reporting environment including report data sources, security, subscriptions and metadata

Lead data normalization and data integrity initiatives; created ETL processes for deduping, cleaning and processing business logic utilizing SSIS and stored procedures

Oversaw SQL Server administration, including database design and optimization, backup strategy and monitoring

Troubleshoot reports and the reporting database environment; worked closely with other IT members to develop an approach for resolution

Assessed impact of changes and updates to source production systems, planning and implementing resulting changes to reports including load testing

Worked directly with business owners and analysts in the development of requirements and user stories for data solutions

07/2012 -

03/2014

VP - System Architecture & Database Engineering

Motyx Incorporated ( http://www.saveon-groceries.com/ ) Wayne, PA

Hand on Technical Architect of iTunes app, SaveOn! (based on Microsoft technologies) - www.saveon-groceries.com.

This application automatically analyzes prices, coupons and promotional offers to recommend the best stores to shop and the best items to buy to maximize savings

Lead a team of developers in the design, development, testing, and deployment of a range of development projects in support of defined business plan objectives

Responsible for selecting technologies, platforms and environments

Conducted code reviews and specification conformance testing as defined by the selected software development methodology

Managed on and off shore teams

Oversaw the development and management of the team performing against plans and objectives

Developed and worked with the teams to meet KPIs, SLAs, and metrics

10/2011 -

07/2012

Senior Consultant

Turnberry Solutions (http://www.turnberrysolutions.com ) Blue Bell, PA

Collaborated with stakeholders (clients) to identify requirements

Developed applications based on C # Sharp .NET and Microsoft SQL Server 2012

Contributed to all phases of development including planning, design, development and release

Participated in the scrum development methodology

Provided technical leadership regarding development best practices

09/2010 -

10/2011

.NET Team Lead / Sr. Systems and Data Architect

Publishing Technology (http://www.publishingtechnology.com/) Somerset, NJ

Data Architect

Lead and direct enterprise-level strategic engagements for clients that involve cataloging the current state of the customer’s vendor and product portfolio, gathered future state requirements for the customer, and prescribed an actionable road map that aligned Enterprise Information Managements technologies with client business requirements

Guided project through the evaluation of data sources (existing or new) that are part of the solution, and helped define the requirements for moving/cleaning/normalizing the data (via ETL/Data services and SSIS)

Worked with development team to define metrics that can be used as tools to measure the effectiveness of data architecture standard

Oversaw functions of database administrators to ensure that developed solutions meet or exceed performance requirements for high-volume transaction processing and reporting

Accountable for standards, architecture compliance, and the collaboration on design, population and governance of metadata

.Net Architect

Provided technical consulting services to clients in the discipline of system architecture and component integration; ensured that technical solutions satisfy business requirements for present and future client needs; provided insight into selecting technical platforms, network architecture and system software while setting the direction and establishing the approach for technical solutions; participated in technical design reviews

Developed SharePoint applications using SharePoint 2010

Responsible for the creating of technical specifications from business requirements, developing reusable web and database code components using C#, ASP.NET, XML and SQL

Management Role

Created structured plans that identify objectives, steps to achieve these objectives, measured progress at select intervals and noted completion of intermediate achievements for my direct employees

Identified road maps for personal and professional growth

11/2009 -

09/2010

Senior Architect (Consultant) – SharePoint,,NET, C#

Omicron Consulting, LLC (Microsoft Gold Partner) Bala Cynwyd, PA

My clients’ development environment was mainly centered around Microsoft tools with an increasing focus on the SharePoint platform. Development work that was performed

included SharePoint site template design and implementation, SharePoint search, security, process workflow, specialized web parts, and the creation of the electronic forms.

List of several clients:

FMC

The primary responsibilities were writing scripts for Windows 7 deployment in order to automate imaging and deployment of 4000 IBM/Lenovo laptops with new OS, office and custom applications. The task was accomplished by using Batch Scripting, Power Shell and VB scripts

TIFF (TIFF school investment funds)

The primary responsibilities were creating and updating ASP.NET forms and User controls in order to expend the current functionalities for the existing funds (Required update was done in C# and SQL 2005/2008)

Merck

The primary responsibilities were the development of the SharePoint solutions. I was responsible for the design, development, testing and deployment of both new solutions as well as the migration of existing tools and applications to the SharePoint 2010 platform.

Worked with Visio and Excel services to integrate them into Master pages and Web Parts.

12/2007 -

11/2009

Director of Architecture, Optimization and Data Modeling (BI/Data Architect)

IRI, Inc Ft. Washington, PA

Architected and modeled multiple BI solutions for Panel and POS data for Bayer and Unilever companies (US based and international locations)

Worked on Guided Analysis tool that allows a non-marketer to easily analyze POS data and receive instantaneous answers for their current conditions

Translated business requirements into a data model structure (dimensional or snowflake)

Excellent knowledge in building data marts, creating star schemas, loading data into data mart through ETL tools

Participated in client and project team meetings to provide insights into data, reports, trends and conclusions on Segmentation and Targeting, Sales Forecasting, Sales Force Design, Territory Design, Sales and Marketing Effectiveness

09/2006 -

12/2007

Director of Operations

IRI, Inc Ft. Washington, PA

Consistently align technologies to the business needs through process, architecture, and organization

Lead department’s day-to-day operations and instrumented key business transformations

Created a subset of tools utilizing C#.NET to automate the loading processes for streamlining daily operational routines

Responsible for 24/7/365 operation of two large datacenters (200+ servers) that support data analyses for 95% of the major retailers and manufactures sectors

Successfully lead and managed six teams totaling 25 employees

Teams:

oDBA (Netezza, Oracle, DB2 (including BCU) and SQL Server)

oWindows Administrators

oLinux/ UNIX Team

oWeblogic and Websphere Administrators

oCustom Applications Administrators

oSAN storage Administrators

Involved in the design, development and the implementation of the projects based on wide varieties of databases, ETL tools (SQL Server ETL, Informatica, DataStage and etc) and BI (Business intelligence software packages including Crystal Reports, Crystal Enterprise, Business Objects, Microstrategy and Symphony RPM/AS)

Executed and guided the rollout of Assets Management software

Helped Company with conversion to an automated Help Desk system

Lead the process of building new datacenter, including software/ hardware consolidation, 3rd party vendor’s contract negotiation process, as well as the design and requirements determination.

Effectively managed employees by properly assigning them to technical tasks, ensuring that they are utilized 100% of the time, resolving personnel issues, establishing career goals and objectives and aiding their professional growth

Actively worked on the improvements of the structure of the support organization in order to move it to the proactive model so that the industry-leading levels of customer satisfaction and operational effectiveness can be met

01/2000 -

9/2006

Manager of Business Operations (P/T job)

eNARA Group, Inc Warminster, PA

Lead the development of Linux/Unix web and email servers

Developed custom phones systems (PBX) for analog and digital (VOIP) lines

Managed key partners, vendors and staff to oversee platform

selections and technology planning

Directed technology budget, involved in the strategic and technical planning

Deployed appropriate technologies and solutions to meet the changing needs of the business

Prioritized activities and deployed resources based on available

financial and time constrains

Recruited, screened, selected, hired and managed 12 employees

10/2000 -

9/2006

08/1999 –

10/2000

Senior DBA/ Webmaster/Senior Web Developer /Team Leader

McKesson, Inc/Verispan, LLC Horsham, PA

Performed team leader role by conducting technical reviews of the system design documentation with development and design team members

Acted as a technical and development lead for: web and windows based projects with on/off line capabilities for pharmaceutical companies (Pfizer, BMS, Astra Zeneca, McNeil Pharmaceutical) utilizing ASP, ASP.NET, ADO.NET, Oracle, Sybase and SQL Server

Developed “Pocket SFA” (sales force automation software) on pocket PC platform (Windows CE) utilizing WAN to enable sales force representatives to have access to the inventory and purchase order system. Software has a capability to authenticate user by capturing signature of an order.

Set up professional hosting environment utilizing MS Windows Clustering Services (for redundancy and reliability) that offers 99.9% server availability for the clients

Managed 7 SQL Servers (clustered/non-clustered) and 3 Oracle Servers (two Windows based and one Sun Solaris based)

Created databases with understanding of File group and RAID layout

Run traces, set up backup and recovery strategies for environments. Managed database replication. Performed scheduled maintenance.

Thorough understanding of SQL server: DTS, BCP, OLAP, ETL and DSS systems

Production support; installation, tuning and migration of instances; space management; backup and recovery; cloning, setting up of High-Availability and Disaster Recovery Solutions

Performed Unix support tasks (system performance monitoring, disk formatting, Unix tuning)

Initiated wide company policies and regulations on creating and modifying database schemas

Performed database normalizations/de-normalizations to increase stability and response time utilizing ErWin and OMC

Imposed shared components design model to increase reusability and performance of development environment

Standardization, regulations of the database and reusability of the code have a potential of saving 25-30% of the development time.

Senior Software Engineer

Datavision-Prologix, Inc Warminster, PA

Independently developed embedded software for handheld computers. Managed projects from writing of specs through the release of the final product. Designed and implemented interface between proprietary hardware and supervisor program running through RF on handheld PC under Windows CE

Software development experience in 3-tier Client/Server environment utilizing Visual Basic, C, Visual C++, Oracle, MS SQL Server 7.0, ADO and RF wireless technology on Windows CE and NT platform

Developed interactive web pages (Forms) for company internal use (Intranet) using ASP, JavaScript, HTML and ADO

Participated in 3rd party software integration, multi-platform capability and remote user support

Strong background in SQL query optimization and query analysis

Managed SQL server database security (user permissions, etc)

Set-up and installed database management system and service packs

Designed, implemented and managed high-availability solutions for SQL servers

Architect, designed, and implemented data warehouse schemas

Involved in the designing and prototyping for next generation products using COM/ActiveX model

PL/SQL development and tuning experience

Worked in both OLTP and Data warehouse environments

Created real time reports using PL/SQL in an OLTP environment

05/1998 -

08/1999

Senior Software Engineer

Peregrine Systems, Inc Warminster, PA

Responsible for the design and implementation of a Client/Server Based Security and Facility Management Systems. Involved in the programming Core applications for Data Collection Devices and bar codes technology

Developed front end applications utilizing Visual Basic 5.0 / 6.0, C/C ++

Enforced referential integrity, database business rules, and security schemes while working in Oracle 7.3 / 8.0, Sybase System 11-11.5, Sybase SQL Anywhere 5.5 and MS SQL Server 6.5 as back ends

Diagnosed and debug complicated Oracle performance, connectivity and security issues involving critical applications

Designed and implemented scripts/tools to help rollout and manage Oracle in a global distributed environment

Managed repository for database metadata

Identified and resolved table locking and blocking issues

Utilized Crystal Reports 4.0-6.0 and MS Access to produce advanced reports for the clients

08/1997-

05/2001

Software Instructor

DPT Philadelphia, PA

Involved in presenting and practicing programming languages such as Visual Basic, ASP,

VB Script, Java Script, HTML, Crystal Reports, Power Builder, C /C++, MS Access, Oracle, SQL Server for a group of users

06/1995 -

05/1998

Senior Programmer/Analyst

VOLT Information Sciences, Inc Blue Bell, PA

As a GUI Interface Developer, participated in analysis, design and development of the Directory Management System (DMS). DMS supports, normalizes, and processes data for a phone company publishing products such a “Yellow” and “White” Pages books, Phone Directory System

Implemented and created various utility programs: Service Orders, Data Filtration, and Report Generation.

The following software and techniques were used during the work time:

Developed GUI front ends on Visual Basic 4.0/5.0

Wrote procedures, triggers, cursors, parameterized queries, sequences in Sybase SQL Anywhere, Oracle 7.3, Microsoft Access 7.0 and UDB (DB2)

Utilized data access models: DAO, RDO, API, ODBC Direct

Per client requests created sophisticated reports with Crystal Report 5.0

Managed multi-language translation process

09/1993 -

02/1994

Programmer -Software Analyst

Comp-Inform Corporation Kiev, Ukraine

Worked as a team member on the development and maintenance of various business applications (Inventory, Payroll and HR System)

Developed programs in C, Pascal and QBasic for customers, orders, inventories and vendor’s information system

Designed interactive batch systems for storage, retrieval and maintenance

EDUCATION:

10/2015

BASI and MASI in advertisement technology (ASI Education) Feasterville, PA

09/2008

DB2 and Netezza technologies Chicago, IL

06/2006

Dell Certified System Expert (DCSE)

Dell Certifications:

Foundation 2005 Latitude, Foundation 2005 Desktops, Dell ESD – Certification, DSP - Mini-Tower V.2 Chassis Certification, DSP - Desktops V.2 Chassis Certification, Basic Wireless Technology

06/2002

Microsoft Visual Studio.NET in-house Training Horsham, PA

Extensive training in VB.NET, C#, XML and Web Services

04/2002

SUN Microsystems Training Plymouth Meeting, PA

Solaris 8 System Administration

09/1993 -

06/1994

Moscow University of Radio Engineering, Electronics and Automation

Moscow, Russia

MS in Computer Science, Graduated with Honor

09/1989 -

06/1993

Moscow University of Radio Engineering, Electronics and Automation

Moscow, Russia

BS in Computer Science, Graduated with Honor

REFERENCES: Available upon request

Contact this candidate