Sql Server Data

SVETLANA SHILOVA

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

Ph. 424-***-****

OBJECTIVE:

To obtain a position Sr. SQL Server Developer

SUMMARY:

Detailed oriented and disciplined IT consultant with SQL Server development and analysis experience and able to adapt quickly to change and team environment.

EXPERIENCE:

Energy Consult LLC, San Pedro, CA

Data Analyst (contract part time) 05/26/2017-2 Saturdays per month

Designs, develops, and documents basic data entry and tracking tools in support of Monthly expenses and Operation Analysis of the company. Generated “Monthly Expenses” excel file from Trial Balance (Trial Balance is the list of transactions, which created in General Ledger during the month).Assist management with data-related workflow to assure data validity and integrity.

Harbor Health System, Newport Beach, CA 05/2016-12/2016

Sr. Database Developer (contract)

Used management system, which utilized statistical data and validated the bills from medical providers. Created sql scripts, which validated accuracy of statistical columns used by Sedgwick claims management system (SQL server 2008 R2). Created, modified stored procedures, indexes, views.

Created, modified SSRS reports, which displays providers data for Sedgwick claims management system (Visual Studio 2015).Used Agile project development environment for Sedgwick claims management system validation and reports. Analyzed large amounts of complex data to ensure the best possible outcomes.

Teksystems, San Diego, CA 09/2015-03/2016

Sr. Database Developer (contract)

Created tsql scripts and MDX scripts, which tested accuracy of Scorecard application data vs. cube of Scorecard: Qfinity and Set Tracker data (each module has an own table structures for pharmacy data).

Created tsql scripts and MDX Scripts, which tested accuracy of Data mart of Scorecard vs. cube of Scorecard for IEX Agents (Schedules for Employees, supervisors, managers of pharmacy). Used Agile project development environment for data mart project. Connected Scorecard cube to Tableau. Created SSIS packages to load HFF data: separated new enrolled patients from existing patients per day; keep all data per week, per month. Archived processed files for verification purposes. Modified SSRS reports, which displays Scorecard data (SQL server 2008 R2).

Alivio Legal Inc, Los Angeles, CA 02/2015- 09/2015

BI Developer (contract)

Interacted with users to define requirements and develop workable solutions for Call Center group .Created stored procedures which populate the data for Call Center activities: 48 hours call back Accepted Calls; Web Leads Cancelled Calls, Intake Calls,Calls data for Texas with map. Created SSRS reports for Call Center, which used mentioned stored procs (used Visual Studio 2012). Created Ad hoc report for calculation of yearly retention cost and estimated cost per case for each client. Added Details report with calculation of packages prices, % of Commission for Account Executives to the main Account Executives Report. Reloaded Products data for Sales Force application with different formats requested by the users. Map source data to data warehouse tables. Created Cube with FactSales table, Dimension tables and store proc, which populates Data Warehouse tables every month. Connected cube to Qlikview. Moved SSRS reports to different location to improve security. Cleaned up the Construction data with the scripts. Created monthly process, which downloads CallDetails data to Data warehouse (SQL server 2012, SSIS)

Chipton-Ross Inc, El Segundo, CA

Database developer/administrator (contract) 02/2014- 11/2014

Created Stored procedures which populate the data for Scorecard tables .Converted Access databases to SQL 2008 R2 .Created the reports from the sql tables and verified that reports are accurate .Rewrite stored procedures to adjust modified tables structures for existing reports .Created SSRS reports, which used TDE database .Interacted with users to define requirements and develop workable solutions for benefit group. Improved performance and minimized blocking for SSRS reports .Document changes and workflows of database objects .Loaded sql tables with scripts from .csv files, created from Cobol application .Modified existing bulk process, which downloads payroll data: added new columns requested by the users .Created script which transferred payroll data to new table structure on time of implementation of new bulk process .Modify and troubleshoot ETL processes using SSIS to use the latest data files for monthly Cobra, QBE, Benefits processes. Created an automated process which loads quarter, monthly data to scorecard database (health provider’s data). Modified scripts, which populates Total Benefits Access process. Modified unified web portal; added new links for database access created from converted historical data.

Herbalife Inc, Los Angeles, CA

Sr. Database developer/administrator(contract) 02/2012- 11/2013

Installed SSRS 2008, SSRS 2008 R2, and migrated SSRS 2008 to SSRS 2012 and SSRS 2008 R2 to SSRS 2012 .Help with migration of BizTalk databases from SQL Server 2008 to SQL Server 2008 R2 .Identifies, develops, and documents database processes and procedures. Scheduled automated delivery of reports to get data in Excel format according with business needs .Implement user access controls and data security measures for Reports .Analyze and tune application performance to the Internet development group by optimizing stored procedures and triggers. Assist with application performance and query tuning, with blocking and deadlock, with change data capture implementation, with Golden Gate implementation .Helped with migration of dts packages to SSIS. Helped with optimization of reports performances in SQL Server (rewrite some sp, used by reports). Created Sales Tabular model for demonstration purposes in test (used SSAS 2012, Excel Pivot table).

Helped with migration of Access applications to SQL Server 2008 R2, with migration of internet applications to SQL Server 2012 .Used PowerShell to automate tasks in SQL Server 2008. Helped with release of builds in test, Uat and production SQL Server 2008 instances. Helped the developers troubleshot and resolve the data issue with download process from Oracle to SQL Server. Maintained the transactional replications (SQL server 2008, 2008 R2) .Improved a performance of OLTP for sales transaction of Herbalife .Created stored procedures, triggers, indexes, partitioned tables. Synchronize the data for InternetEcm database with SQL Azure cloud platform.

Time Warner Cable Inc, Los angels, CA

Database developer/administrator 3/2008- 10/2011

Installed sql server 2005, 2008, Reporting Services, and Analysis Services .Designs and implements reports utilizing Microsoft SQL Server Reporting Services .Managing security: ensuring that sensitive data is not provided to unauthorized users. Run profiler for audit purposes: make sure that changes are being made only by authorized personnel. Documented db design (used Visio) and data access security (MS SharePoint) .Optimized SQL Server performance: created Optimization jobs, performed tuning of stored procedures, collected performance data by using DMV and SQL Profiler. Maintain data effectively as well as create routines to import data from external sources. Downloaded Kronos data to sql server 2008 (used For Each Loop containers for text files). Migrated an Access database into SQL Server 2005 using SSIS. Improved the performance, modified the database structure of Scorecard application (dashboard, ColdFusion). Migrated some tables of Oracle 11 g to SQL Server 2008 for Scorecard .Troubleshoot and provide technical solutions to database issues encountered by Scorecard, EMS applications .Upgrade SQL Server 2000 to 2008 or 2005 to 2008: created data mapping documents, transfer dts packages to SSIS, recreate jobs, documented the results. Design, implement, schedule and manage data transformation .Improved existing ETL processes, which download billing info from Oracle 11g to SQL Server 2000/2008 data warehouse. Synchronize the data. Developed and executed test plans and controlled for efforts around ETL processes, data completeness, and data accuracy from ETL processes. Created stored procedures, triggers, indexes, partitioned tables .Stored database objects in VSS. Modification of existing self billing cube for the business needs with MDX, performance tuning and administration. Troubleshoot end-user issues until resolved, update the tickets.

CLAW/MLS, Los Angeles, CA

Database developer/administrator 04/2003-10/2007

Created and maintained transactional replications of production databases. Created scripts, which set up subscription server as a primary server in case of hardware failure of primary server (Sql Server 2000 standard edition) .Migrated data from existing SQL Server to the new more powerful SQL Server, transferred packages, recreated jobs .Quality control and audit of databases, to ensure accurate and appropriate use of data . Improved a performance of OLTP for real estate business .Migrated data from System 4 to MLS database: created scripts to download data and update missing data in time of migration .Created scripts, which fixed historical data of real estate transactions (used T-SQL) .Created jobs to update data in according business rules. Created processes to transfer data to ftp server for idx client’s .Developed or modified DTS packages for integration with existing systems .Used SQL Profiler to monitor the performance of events. Created stored procedures, triggers, indexes, performed tuning of stored procedures .Started to migrate SQL Server 2000 to 2005 on staging (created scripts for replications, transferred packages to SSIS, enabled Surface Area Property like xp_cmdshell command).

CLAW/MLS, Los angels, CA

Developer 02/2002-04/2003

Created process, which updates Commercial database, public records data .Fixed drawbridge process to download data from AT&T to mls database .Created Intranet application, application for download mls data for Palm device (Cold Fusion ).Created Public record application, POW application (ColdFusion,ASP.Net).

EDUCATION:

MSCE - EXAM 70-466 SQL Server 2012 Implementing Data Models and Reports -02/2015

MCSE - EXAM 70-459 SQL Server 2012 Data Platform --01/2014

MCSA - EXAM 70-458 SQL Server 2012 Part 2 -12/2013

MCSA - EXAM 70-457 SQL Server 2012 Part 1 -11/2013

MCITP - EXAM 70-450 SQL Server 2008 Database Administrator -01/2012

MCTS - EXAM 70-432 SQL Server 2008 -12/2011

SQL server 2005 for Database Administrator, UCLA 10/2007-12/2007

BSCS, Belorussia State University 1998

COMPUTER SKILLS:

Operating systems Windows 7, 10, 2000/2003/2008/2008 R2 servers, WINDOWS 95/98, WINDOWS NT4.0, MS DOS.MS SQL 2000, MSSQL 2005, MS SQL 2008, MS SQL 2008 R2, MS SQL 2012; MS Visual Studio 2012, MS Visual Studio 2010, BI Development Studio, SSIS, SSRS, Report Builder, SSAS Multidimensional and Tabular models, Access, Kronos, Oracle 11g Client, Visio, Erwin, MS SharePoint, Toad Data Modeler, light speed backup software.

Programming languages TSQL, MDX, Visual Basic, VBScript, VBA, PL/SQL, C. Knowledge of API, CFML, ColdFusion 4.5/4.0, VB 6/5, Visual J++6, ASP, InterDev 6.0, ODBC, COM, ADO, HTML 4/0, DOM, CSS, MS IIS 4.0, PowerShell. Knowledge of data mining, data warehouse, data marts, STAR schemas, statistical functions.

PERSONAL SKILLS:

Detailed oriented, hardworking, accurate, discipline, quick learner, team player, reliable, well organized.

Contact this candidate