Analyst/IT-Consultant Resume New York - Hire IT People

SUMMARY:

In - depth knowledge of Transact-SQL and creating indexes, views, complex stored procedures, user-defined functions, derived tables, and triggers to facilitate efficient data manipulation and data consistency.
Highly experienced in installing, configuring, managing, monitoring and troubleshooting MS SQL Server and implementingbackup and recovery strategy for databases.
Data Warehousing modeling (Star Schema, Snowflake) using MS SQL
Experienced in creating OLAP cubes using SQL Server analysis services (SSAS) and in creating groups and measures, KPIs.
OLTP data modeling (2NF,3NF)
Hands-on experience with various cloud platforms.
Hands-on experience with NoSQL databases (Document as well as Graph)
Understanding OOP.
Development experience with Visual FoxPro, Delphi, C#, Scala, Python, RoR
Hands-on experience configuring POS hardware, such as different Touch terminals, POS Printers etc. (Posiflex, IBM, Epson, Citizen, Metrologic etc.).
Self - starter with excellent analytical and problem-solving skills, with over 7 years experience with MS SQL Server design and development and POS hardware. Works great in leadership positions and as part of a team.

TECHNICAL SKILLS:

Technology and Tools: Microsoft Azure platform, AWS, IBM BlueMix, Neo4J, T-SQL, MS SQL Server 2014/2012/2008/2005/2000 , MS Access, (SQL Server Reporting Service) SSRS, (SQL Server Analysis Service) SSAS, IBM Cognos BI 7.4, Microsoft Visio 2007, BPWin, Delphi 7, Visual FoxPro 6/7/9,C#, Windows Server 2000/2008, AD, Linux, VMWare, TCP/IP, VPN, Lotus Notes 6, Tableau, Qlik Sense, Apache Hadoop, HTML/CSS.

PROFESSIONAL EXPERIENCE:

Confidential, New York

Analyst/IT-Consultant

Responsibilities:

Design NoSQL data model for medical billing system.
Support migration from premises to cloud platform (Local installed SQL 2012 to Cloud based Azure)
Developing Back-End of the medical claim processing system (based on DocumentDB and SQL Server).
Building analytical platform for analyze medical claims (utilizing graph approach based on Neo4J)

Confidential, New York

Analyst/IT-Consultant

Responsibilities:

Designing Data Warehouse (snow-flake, star, schema MS SQL 2008)
Worked on several projects as independent contractor
Aggregation data from various sources (ETL SSIS)
Designing Stored procedures, triggers.
Migration legacy projects to MS SQL Server platform (from MS Access to MS SQL 2012)

Confidential

Chief Operating Officer/Architect/Lead developer

Responsibilities:

Hired SQL Developers to implement SQL BI Solutions for established clientele
Forecast models, MDX Queries.
Was in charge of requirements analysis and proposal preparation oversight; Negotiations of agreements with vendors; Preparation and execution of contracts;
Analysis, description and optimization of business processes of the customer;
Led the team to implement BI solutions (Star and Snowflake schema) that included, data modeling using MS BI Stack (SSIS (different data sources), SQL Server, SSRS, SharePoint Integration etc.)

Confidential

Analyst/IT Consultant

Responsibilities:

Implementation, development and operation of the CPM (IBM Cognos BI 7.4)/ CRM-systems, integrated management systems in the group of hotel;
Development of technical specifications for external developers and integrators;
Designing of reports system based on MS SQL Server 2005 Reporting Services;
Designing DWH (based on Microsoft solutions) in collaboration to BI-architect;
DBA Administrator (MS SQL Server 2005);
Analysis, description and optimization of business processes of company (Visio, BPWin, Intalev Navigator);
Personnel .

Confidential

Analyst

Responsibilities:

Pre-sale participation;
Analysis, description and optimization of customer business processes;
Formalization of business objectives;
Participation in ERP System implementation at hotels and restaurants (accounting systems, access control, billing system, pay TV, online reservations, etc.);
Developed Sql DB from scratch, wrote stored procedures, triggers, created views, wrote queries, has done query optimizations
Personnel .

Environment: Delfi, C#, Asp.Net, Visual FoxPro, SQL Server 2000/2005

Junior Developer

Confidential

Responsibilities:

Relational database design (MS SQL Server 2000);
Triggers, Stored Procedures.
BackOffice developer of restaurant ERP system (T-SQL, Visual FoxPro, Delphi);
System reports design based on Crystal Reports;
Participation in UI design of Front Office module;
Testing POS hardware for compatibility with ERP modules (Posiflex, Metrologic, etc.).

We provide IT Staff Augmentation Services!

Analyst/it-consultant Resume

New, YorK

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship