Kirill Studenikin

SQL Server Engineer

acgg8s@r.postjobfree.com

Primary Phone:

567-***-****

Overview:

• Over 8 years of professional experience in IT industry as a SQL server developer and eDiscovery

processing Engineer working in different domains including healthcare, insurance and financial

services.Extensive experience in installing, upgrading, configuring and managing SQL server

2012/2008 (R2)/2005/2000.

• Extensive experience in data integrating, analyzing and reporting using SQL server management

studio, SQL server business intelligence tools including DTS, SSIS, SSAS and SSRS.

• Proficient in developing transact SQL DDL, DML and DCL commands including complex queries,

views, functions, stored procedures, cursors and triggers on SQL server 2008 R2/2008/2005/2000.

• Excellent experience in coding, analyzing and implementing SQL commands using various rational

database management systems (RDBMS).

• Expert in using ETL tools SSIS, DTS, BCP and bulk insert to perform data transfer and data

migration from different server locations and heterogeneous sources like oracle, excel, access, xml,

csv, flat file.

• Expert in creating SSIS packages using various transformations, like aggregate, lookup, merge join

and slowly changing dimensions (SCD).

• Proficient in upgradation and migration MS SQL server 2005 to MS SQL server 2008/2008 R2

• Extensive experience in dimensional data model design and cube design using SQL server analysis

service (SSAS) and deploying them. Strong knowledge of data warehouse.

• Expert in using MDX to query multidimensional objects, such as cubes, and return multidimensional

cellsets that contain the cube’s data.

• Extensive experience in developing reports using SQL server reporting service (SSRS) including

parameterized, linked, drilldown, drill through, sub reports and ad hoc reports. In depth experience

in creating multiple levels cascading prompt for both static and dynamic parameter.

• Proficient in data modeling and analytical database designing using MS vision and ERWIN. Hands

on experience in database installation, configuration, maintenance, monitoring, backup and recovery

procedure and involved in the migration and upgrade of databases.

• Proficient in database debugging and performance optimization using SQL Profiler.

Involved in all phases of Software Development Life Cycle (SDLC): analyze, design,

•

implementation, testing and maintenance.

• Excellent interpersonal communication, problem solving, documentation and business analytical

skills with an ability to adapt new technology quickly and a strong team player.

• Proficient in data collection, culling, analyzing and processing data according to client needs and

eDiscovery standards

• Extensive experience in production and finalizing data for delivery over content intelligence and

loading to FTP server or providing for Concordance (LexisNexis) load

• Involved in processing sensitive data for international companies located in Japan, England, Paris,

India and local USA companies

Technical Skills:

T SQL, SQL, C#.NET, XML, ASP .NET, CSS, HTML, WINDOWS, LINUX, SQL SERVER, ORACLE, MS ACCESS,

ERWIN 4x, ERWIN 7x, Microsoft Visual Studio, SQL Server Management Studio (SSMS), Business

Intelligence Development Studio (BIDS), SQL Query Analyzer, Microsoft SQL Server Query Analyzer and

Enterprise Manager, MS SQL Server Reporting Services (SSRS), Crystal Reports, MS SharePoint, SQL Server

Integration Services (SSIS), SQL Server Analytical Services (SSAS), Litigation, LexisNexis, Concordance,

eDiscovery

Email: acgg8s@r.postjobfree.com phone: 567-***-**** LinkedIn Profile

Professional Experience:

July2014 to Present

PROMONTORY FINANCIAL GROUP

SQL Server Architect/Data Analyst

• Designed database for AML Risk assessment project

• Responsible in getting and analyzing data from client insuring it meets project needs.

• Created VBS script to standardize conversion of XLX* files into tab delimited txt

• Created over 20 different stored procedures to automate load from flat files into db. for

reusability.

• Created over 20 different complex views for cleansing and conversion purposes.

• Gather HIDTA and HIFCA instruction from official provider such as FINCEN to generate look

up table for compliance purposes.

• Had been reconciling data from previous risk assessment.

• Had been working on QA data to insure it meets methodology

• Participate in DOI production

• Participated in creating instruction for data load steps, crunching and twisting it accordingly.

• Created data dictionary and Data model for better representation of the data

• Working closely with secure network team to gather PII data and storing it in a secured environment.

• Used pivot and unpivot to meet normalization standard

• Utilizing CTE and row enumerator to cleanse data

• Identified LEID for customers that were not appeared on SAR’s report

Environment:Windows 7, MS SQL Server 2008 R2, MS SQL Server, MS SQL Integration Services 2008 R2, T

SQL.,SVN, Beyond Compare

November 2013 to January2014

UATP

SQL Server Developer 2

• Wrote stored procedures and queries for slide partitions on automated basis.

• Worked with various DTS packages to load data from PayPal into data warehouse.

• Created dynamic queries to gather partition boundaries, switch partition and generate a

new one

• Created new indexes for better performance of the database, and maintained data integrity

by using foreign key relationship.

• Integrated cascade process on delete using PK FK integrity.

• Recreate existing stored procedure by implementing in logic query temporary table for

better performance

• Involved in debugging SSIS packages

Environment:Windows XP, MS SQL Server 2000/2005/2008 R2, MS SQL Server, MS SQL Integration Services

2008 R2, T SQL.,MS SharePoint 2010,XML

Kirill Studenikin

SQL Server Engineer

acgg8s@r.postjobfree.com

Primary Phone:

567-***-****

CAPITAL NOVUS March 2013 to October 2013

eDiscovery Processing Engineer

• Responsible for all stages of the litigation lifecycle in planning, organizing, digitizing and

present projects in timely manner using a variety of Processing application

• Monitoring/Evaluation/troubleshooting data processing during ingestion

• Data Pre Process electronically stored information (ESI) for review such as Data Analysis,

Reporting, Decryption, File format conversion

• Create databases, manipulate raw data, import/export data, troubleshoot load files,

performs QA, and maintain review repositories

• Data processing such as system file\folder filtering, data extraction, deNISTing, de

duplication, culling and filtering of electronically stored information (ESI)

• Prepare images and data for production in a variety of litigation support software formats

• Prepare analyses of data and data collections for case

• Track and manage workflow to ensure client expectations and deadlines are met and work

with internal clients and management to resolve problems as they arise

• Preparing and formatting data load files, including programmatic reformatting of data as

needed to satisfy input requirements

• Performing quality reviews and validating converted information in preparation for database

creation

• Creating, loading, and testing database prior to release to the client

• Tracking and controlling a variety of tickets and tasks

• Test processing application and provide active and innovative solution for same

• Overview Quality Assurance Process of documents/Data load files presented to client.

Providing technical analysis to Technical and Non Technical staff/client as required

• Responsible in analyzing and implementing searchable indexes for processed data,

validation corrupted data

• Responsible in converting non standard data messages such as customized NSF files into

eDiscovery standard fields

• Involved in implementation testing and centralizing processing application for more

automated process

• Generating technical documentation for developers

Environment:Windows XP, MS SQL Server 2008 R2/2012, MS SQL Server Reporting Services 2008 R2, MS

SQL Integration Services 2008 R2, T SQL.,BizTalk, MS SharePoint 2010,ERWIN7x, .NET, XML, eZview,

eZreview, eZmanage, Concordance

EUREKA April 2011 to December 2012

MS SQL Server Developer (SSRS/SSIS/SSAS)

• Wrote stored procedures and queries for creating reports from data marts.

• Worked with various report items like tables, matrices and image.

• Created reports with drill down, drill through, cascading parameters, conditional formatting,

interactive sorting, dynamic grouping functionalities and custom assembly in SSRS

• Formatted reports to export to Excel as well as to print.

• Published reports to testing and production environments and facilitated the testing process.

• Responsible for resolving report defects in the dashboard application.

Involved in development and implementation of SSIS, SSAS and SSRS application

•

solutions for various business units across the organization.

• Formulated and documented ETL process design based on business requirements

Email: acgg8s@r.postjobfree.com phone: 567-***-**** LinkedIn Profile

and system specifications including source to target mappings, data dictionaries

and transformations.

Directly responsible for the Extraction, Transformation and Loading of data from

•

Multiple Sources to Data Warehouse.

Used DTS/SSIS for ETL processes, SSRS for Reporting needs and SSAS for Analytics

•

reporting including

Created highly complex SSIS packages using various Data transformations like

•

conditional splitting, Fuzzy Look Up, For Each Loop, Multi Cast, column conversion,

Fuzzy Grouping, Script Components, error handling.

Imported data from many heterogeneous elements like SQL Server, flat files, Excel,

•

DB2 etc. into SQL Server using SSIS 2008 R2/2005.

Created business critical KPIs using MS SQL server analysis services (SSAS)

•

representing aggregations in several different ways hierarchically and using

custom groupings that the company will use to analyze performance.

Scheduled many jobs job to run on a daily basis to import and export data at

•

nightly basis.

• Handled slowly changing dimensions to maintain the history of the data. Responsible for creating

cubes and dimensions using MS SQL server analysis services (SSAS).

Created reports by retrieving the data from cube using MDX reports.

•

Created new indexes for better performance of the database, and maintained data

•

integrity by using foreign key relationship.

• Developed many stored procedures which acts as data source for the all the web

based and reporting applications here in this project.

Environment:Windows XP, MS SQL Server 2005/2008 R2/2012, MS SQL Server Reporting Services 2008 R2,

MS SQL Integration Services 2008 R2, T SQL.,BizTalk, MS SharePoint 2010,ERWIN7x, .NET, XML

SERDE MEDICAL SOLUTIONS September 2009 to March 2011

MS SQL Server / BI Developer

• Involved in planning, defining and designing database based on business requirements and

provided documentation using Microsoft Visio.

• Designed SSIS packages to transfer data from excel and other server to SQL server based on

business intelligence development studio.

• Extensively used SSIS transformations such as lookup, merge, merge join, conditional split,

derived column, data conversion and aggregate etc.

Used DTS/SSIS for ETL processes, SSRS for Reporting needs and SSAS for

•

Analytics reporting including

• Handled slowly changing dimensions to maintain the history of the data. Responsible for

creating cubes and dimensions using MS SQL server analysis services (SSAS).

• Created business critical KPIs using MS SQL server analysis services (SSAS) representing

aggregations in several different ways hierarchically and using custom groupings that the

company will use to analyze performance.

• Designed, developed and deployed reports in MS SQL server environment using SSRS.

Generated sub reports, drill down reports, and drill through reports and parameterized reports

using SSRS.

• Coordinated with DBA in creating and managing tables, indexes, triggers. Indexes based on

logical design models, user requirements and physical constraints.

• Wrote T SQL queries including store procedures such as porting script and used them to build

packages.

• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of

software.

• Performed daily tasks including backup and restore by using MS SQL Server 2005 tools like SQL

server management studio, SQL server profiler, SQL server agent.

• Performed T SQL tuning and optimization of queries for reports that take longer execution time

Kirill Studenikin

SQL Server Engineer

acgg8s@r.postjobfree.com

Primary Phone:

567-***-****

using MS SQL server profiler, SQL query analyzer in MS SQL server 2005.

• Involved in working process generating reports in IMS Sales Data

• Supported production operation activities, with focus on integration and development of new

and existing products and services.

Environment:MS SQL Server 2008/2005, SSRS, SSIS 2008/2005, SSAS, Crystal Report Xi R2/2008, MS

Access 2003, Excel 2003/2007, IMS Sales Data, Remote Desktop, .Net, SQL Profiler, Microsoft Visio.

HIM FARM May 2005 to August 2009

MS SQL Server Developer / BI Developer

• Involved in planning, defining and designing database based on business requirement and provided

documentation.

• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the

packages and stored procedures. In addition, modified the existing SSIS packages to meet the

changes specified by the users.

• Applied various data transformations like slowly changing dimension, aggregate, sort, multicasting,

conditional split, derived column etc.

• Created a number of cubes, dimensions and business critical KPIs using SSAS. Wrote several MDX

queries to create name sets and calculated member and created reports by manipulating data from

cubes in SSAS.

• Scheduled jobs for executing the stored SSIS packages, which were developed to update the

database on daily basis.

• Designed, developed and deployed reports in MS SQL Server environment using SSRS 2005.

• Scheduled the monthly/weekly/daily reports to run automatically onto the dashboard. Configured

the report viewing security for various users at various levels using report manager.

• Designed and implemented stored procedures and triggers for automating tasks.

Environment:MS SQL Server 2008/2005, T SQL, MS SQL Server Reporting Services, MS SQL Server

Integrating Services, MS SQL Server Analysis Services, Oracle 10g, Access, Excel.

Education:

Bachelors in Engineering

Email: acgg8s@r.postjobfree.com phone: 567-***-**** LinkedIn Profile

Contact this candidate