Sql Server Business Intelligence

Forest Hills, NY *****

******************@*****.***

Vladimir Nikolskiy

(347) 564 - 2527

LinkedIn : linkedin.com/in/vladimir-nikolskiy-358a564

SUMMARY OF QUALIFICATIONS

Over 25 years of experience in analyzing the business requirements to produce valuable applications. Created and maintained data marts, DW, tables, DB links, synonyms, triggers, function, packages and stored procedures. Best at data analysis and transforming it to business needs. Developed multiple business solutions to track data effectively. Created and supported multiple SQL Server SSIS Business Intelligence solutions for data ETL and other data transitions. Created Excel and Access reports (VBA) and data back end for ASP.net web sites (T-SQL). Created and maintained multiple Tableau\Crystal reports and participated in various other reporting tasks for management to provide an increase in operational efficiency. Created and updated many Excel spreadsheets to provide advanced features such as macros and VBA programming to integrate or conjoin with other databases or data sources for automated tasks or specific business or management needs. Produced ASP (ASP.NET, VB.NET, C#) application with SQL server back end which I have designed and created. Performed countless transfers from other platforms to SQL Server and Oracle and back. Created and updated many various Oracle, SQL Server & Access & SQLite databases with many different attributes and functions in combination with other features and Third parties. Have advanced knowledge of Crystal Report 8.5 and 10, Tableau.

SOFTWARE DEVELOPMENT KNOWLEDGE

Guru SQL Server 2005 - 2018, SSIS (2005-2025), Business Intelligence, PL/SQL Plus, T-SQL, ETL, and in VBA Script. Expert in MS Office (MS Word, Excel(Guru), Access(Guru), etc.) and MS Visio, XML, C, C++, C#, Sybase, SQL Server 2005 – 2018, Big Query, SQLite, Tableau, Crystal Reports 8.5 - 11, VSS, UNIX Shell Script, Perl, HTML, ASP, CSS, UML, ASP.NET, VB.NET, AJEX, Oracle(8i-12g), Java Script, Tableau, Jira, Confluence, Azure. Beginner level for Python, GitHub, Terraform, Google Looker

PROFESSIONAL EXPERIENCE

Senior Product Services & Management Analyst and Database Developer / Programmer Apr/15 to March/25

Northwell Health INC, N.Y. – GPO Operations

Developed new business driven solution and support in SQL server 2005-2018, T-SQL, MS Access, DM (CMU)

Created multiple business solutions to track data effectively or capture important information for other reports (SQL Server, MS SSIS)

Developed business Reports\Dashboards for management and data analysis on multiple-party platforms (MS Excel, Power BI, Tableau)

Create and support Reports\Tools in MS Access\Excel Report Apps in VBA with multiple sources (Oracle PS, SQL Server and etc.)

Helped the transition of multiple data platforms from different Hospitals (8) to the internal formal in SQL Server/Oracle PS

Created multiple internal emailers and tracking of data loads \ performance for other jobs in SQL Server

Developed multiple ETL to import and export jobs to ingest external Data and to provide our data (Oracle, MS SSIS and etc.)

Support and set up team projects and best practices in Jira and Confluence

System Analyst and Database Developer / Programmer Sep/11 to Feb/15

Cablevision, N.Y. – Billing and Collection

Developed new business driven solution and support in SQL server 2005-2008,T-SQL, ASP.NET, VB.net, C# (BORIS\BORIS2)

Developed new solution and converting the old MS Access Report Apps to SQL Server SSIS Reports, VBA, SSIS, XML

Automated and supported numerous database SSIS packages for data load and reports creation in SQL server (2K - 2012).

Created and supported numerous database SSIS packages for automated business processes in SQL server (2005-2008), T-SQL.

Provided the support and analysis for old MS Access systems VBA, SQL server 2K-2005(PostTap, TapCuts, Field De-Auth, and etc.)

Documented all the business cycles and tasks for each business task.

Consultant – System Analyst and Database Developer Dec/09 to Sep/11

ICONMA/Web MD, N.Y. - Mobile Department

Developed multiple business driven solutions in SQLite, SQL server 2005, Batch Programming, Perl, Access, Excel.

Automated monthly database update for mobile devices and other business tasks to expedite process cycle and reduce errors.

Documented the business cycles and tasks for future reference and further development to expedite each business task.

System Analyst and Database Developer / Web Developer Feb/07 to Dec/09

MTA, NEW YORK CITY TRANSIT AUTHORITY, N.Y. - CES

Developed multiple business driven solutions in Access (XP, 2003, 2007), Excel and VBA environment (PWA, Skill Match).

Designed SQL server 2005 database architecture and ad hoc queries for multiple business needs.

Developed an ASP application with SQL Server 2005 database that I developed as well.

Performed multiple web updates on TENS website.

Developing ASP application with the Sybase database (Fluke).

Developed multiple ad hoc reports and upgraded older reports to new features in Crystal Report 10 and in Oracle 10g (SPEAR).

Consultant – Accounting/Bookkeeping Department Aug/02 to Feb/07

OFFICIAL COMPUTERS / BE ABOVE

Modified and adjusted the payroll system in FoxPro 2.5X to current business needs and followed up on training of staff.

Modified and customized the existing tools for new business requirements, automatic update of government forms, bank reconciliation spread sheet, budget amendment, budget modification, In Kind report, monthly expense report (Caps), monthly payroll summary.

Modified and maintained department’s Database.

DB Developer\Junior Administrator - Programmer Oct/98 to Jan/02

NET2PHONE NEWARK, N.J.

Hands on experience with different facets of VB 6 projects from full stand-alone applications to small, automated jobs. Wrote many programs for processing of input information from different file types and creating dynamic reports.

Analyzed existing business system and designed new systems for middle tier (DCOM, COM+).

Developed and maintained a great number of different Controls and DLLs and reviewed their performance and update.

Developed database foundation for programs mentioned above (Oracle, Access and SQL Server) and served as junior DBA (Oracle, C, Unix). Developed multiple databases and worked in database cross over environment (Oracle, SQL Server, Access and Excel).

EDUCATION & TRAINING

BS in Information System - Magna Cum Laude

2006

TOURO COLLEGE - Brooklyn, NY

Contact this candidate