Data Sql Server

STEVEN ALPEROVICH

Palisades Park NJ ***** 201-***-**** ***********@*****.***

QUALIFICATIONS SUMMARY

An accomplished Information Technology professional with comprehensive experience in design, development and implementation of Health, Financial and Pharmaceutical systems.

TECHNICAL SKILLS & PLATFORMS

BI tools: Azure, SSMS, SSIS, SSAS, SSRS, MICROSOFT SQL SERVER DATA TOOLS/BUSINESS INTELLEGENCE DATA STUDIO(BIDS), MICROSOFT OFFICE, POWER PIVOT, POWER BI, REPORT BUILDER, TEAM FOUNDATION SERVER, IDASHBOARDING, MASTER DATA SERVISES.

Databases: SQL Server; T-SQL; MYSQL; DB2/SQL; UDB; MS ACCESS; ORACLE, TERADATA

Others: MQ SERIES, DB2, DYNAMICS SQL, QMF, BMC/PLATINUM, SDF II/BMS, OS/MVS, CICS COMMAND LEVEL, CEDF, INTERTEST, DATAEXPERT, IMS/DB, VSAM, EXPEDITOR, TSO/ISPF, PANVALET, LIBRARIAN, ENDEVOR, CHANGEMAN, OS/JCL, EASYTRIEVE, FILE-AID

PROFESSIONAL EXPERIENCE

Duck Creek Insurance Company, Warren NJ September 2017 to Present

BI Senior Programmer Analyst

-Create complex SQL, T-SQL queries, store procedures, complex queries, dynamic SQL and functions for claims and policies data

-Create tables using SQL Server column store to compress indexes and query data in memory

-Design and implement ETL processes to load claims and policies data into warehouse and data mart using SSIS

-Troubleshoot and analyze ETL issues identified by automated monitoring, other developers and end users

-Design and Develop fact, dimension and date tables for dimensional data modeling.

-Work with users and business leads to develop cross functional specifications.

-Design and implement insurance claims and policies reports using SSRS.

-Work with QA team on validation process

-Design and implement Power BI reports, scorecards, dashboards and kpis using Azure cloud technologies.

-Create Power BI calculated columns and measures using DAX language

-Created Power BI lists, records, tables and functions using M language.

-Design and implement OLAP cube using SSAS

Maimonides Medical Center, Brooklyn, NY June 2015 to September 2017

BI Programmer Analyst

-Create code for database modification, stored procedures, triggers and functions. using SQL Server and T-SQL.

-Design and develop ETL/SSIS programs to extract data and load to the Data Warehouse using SSIS

-Troubleshoot and analyze ETL process failures, data anomalies and other ETL or data warehouse issues identified by automated monitoring, other developers and end users

-Develop AD-HOC reports for clients using SSRS (SQL server reporting services)

-Work with customers to define and document the scope and functional requirements for data and reporting needs

-Design and developed POWER BI dashboards, reports for senior.

-Create Power BI calculated columns and measures using DAX language.

-Create data dictionary using MDS (Master Data Services).

-Create OLAP cubes using SSAS (SQL server analytical services).

-Provide training for clients in the BI and data warehousing space.

-RAS (Report Automation System) Administrator. Responsibilities included: system maintenance, user’s accounts creation/maintenance, report capture, data extraction, e-mail notification, custom splitting (into different departments)

-Create Monarch data models to extract data from RAS reports and load data using ETL/SSIS into Data Warehouse.

Express Scripts, Franklin Lakes, NJ April 2013 to May 2015

BI Programmer Analyst

-Designed and developed ETL processes using SSIS and T-SQL for downstream data feeds into Data Warehouse.

-Design, develop and implement a Benefit Statistics Data mart and Dashboards, integrated with SharePoint, using SSIS and T-SQL.

-Designed, developed, and implemented various Benefits, Sales reports using SSRS.

-Created OLAP Cubes using SSAS.

-Created T-SQL queries, Cursors, Store Procedures and Functions.

-Created Indexes, views and triggers.

-Performed tuning on the T-SQL queries and indexes.

Pegasus Funding, NY February 2012 to March 2013

BI Database Developer

-Created triggers, indexes, views and functions using SQL SERVER 2008/2012 R2 databases.

-Performance optimization to the T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary.

-Created T-SQL queries, Store Procedures for the purpose of insert/modify/delete SQL server DB.

-Created Datawarehouse using ETL/SSIS (SQL Server Integration System).

-Developed reports for clients using SSRS (SQL server reporting services)

Medco Pharmaceutical, Franklin Lakes, NJ June 2010 to February 2012

Senior Programmer Analyst (Consultant)

-HIPAA Project: Using SMART TS performed module inventory of all programs impacted by various requirements.

-Prepared Technical Specifications Document (TSD) related to the HIPAA project.

-Supported an offshore team by resolving issues and providing solutions to enhance processes and procedures.

-Creating dynamic SQL in mainframe to be executed in SQL Server environment. In-depth knowledge of Transact- SQL. Expert in creating indexes, complex store procedures, Triggers to facilitate efficient data communication and data consistency.

Citigroup, Wane, NJ June 2008 to June 2010 Senior Programmer Analyst (Consultant)

-Designed, coded and implemented Voluntary Corporate Action System (offer was mailed to shareholders)

-Software utilized: SQL Server 2008 R2, Created T-SQL queries, Store Procedures, functions

-Coded and implemented batch programs to process data extracted from SunGard’s Invest ONE platform

-Generated custom reports for viewing and download by Citi’s clients from its website

JP Morgan Chase, Tampa, FL April 2006 to May 2008

Senior Programmer Analyst (Consultant)

-Developed multiple background and foreground Cobol/CICS/DB2/SQL transactions to create queries and logged in errors; Created input data (JCL to NDM) to Tandem Operating System

-Wrote JCL to backup DB2/SQL tables and execute queries

EDUCATION

Bergen Community College Information Systems

Empire Technical School Data Processing

Contact this candidate