Sql Server Business Intelligence

Arthur Lev

***** ********** **** # *** 818-***-**** Cell

VanNuys, CA 91406 ********@*****.***

CAREER OBJECTIVE:

Obtain a dynamic and challenging position in the field of WEB Development, SQL Development, database development and management. Also, to design and develop software applications and systems utilized over private and public networks.

Over 15 years of experience managing software development, database administration and Data Warehouse / Business Intelligence for back office applications, ERP Systems and front end web sites.

PROFESSIONAL SKILLS:

Languages: VB.NET,T-SQL, HTML, XML, VBScript, C#, JavaScript, jQuery, AngularJS

Software: MSSourceSafe6.0, MSOffice, CrystalReports, MS PWS, MS Visual Studio 2008/10/15, MS Front Page 2000, MS SharePoint

Databases: MS Access 9X/2000, MS SQL Server 2005/08/12/14

Operating Systems: Windows 8.X, Windows NT, 9X, 2K, XP,VISTA

+10 years professional experience in database/software design using Visual Basic and SQL languages. Certified developer of Client-Server application for Microsoft Windows 9X/NT /XP/Vista. Experienced in Systems Analysis. Skilled in designing reports using Crystal Reports, SQL Server 2005/2012/2014/2017 and Access. Expert in Access, Excel, Word, AutoCAD, MS PWS, MS Visual Studio 6.0 /2008 (MS Visual Interdev 6.0), MS FrontPage2000. Experience with working knowledge of Pivot tables. Extensive knowledge in Internet WWW development using HTML, DHTML, XML, ASP Classic, ASP.NET, VBScript, JavaScript, jQuery, AngularJS. Strong hands-on knowledge in T-SQL query writing, stored procedures, triggers and views of MS SQL Server.

Knowledge of tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard in SSAS and SSIS.

Experience of source data analysis and data profiling. Health Care Industry general knowledge. Familiar with HIPAA standards for the electronic exchange, privacy and security of health information.

Experience in using OLEDB, ODBC, DAO and ADO. Solid experience in debugging programs. Work with Quality Assurance to test functional product features and product compliance. Work with Operations on deployment of new releases and application management. Experience of source data analysis and data profiling. Knowledge of ETL and Data Warehousing concepts. Health Care Industry general knowledge. Excellent written and verbal communication skills. Works well with others (strong Collaboration Skills). Good strong data analytical and troubleshooting skills.

WORK EXPERIENCE:

02/2020 to 12/2023 AIS Insurance,CA, Remote

Data Analyst

Responsibilities:

Works with AIS leaders and independently to identify and provide data support to recognize opportunities for process improvement and/or system changes as well as innovation ideas.

Researches and generates specific on demand reports as requested by AIS management and creates standardized reporting templates. Assists in the development and administration of current and future goals within AIS departments as well as supporting the premium leakage initiative to increase profitability.

Supports management and team to present analysis needs; Prepares reports, graphs and charts based on research and analysis. Operate within a project plan to incorporate business objectives, data scope, research methodology, resources and timeframe.

Creates, monitors, audits, and analyzes recurring reports detailing CSR and Sales Agent productivity, system behavior, call handling behavior, and AIS processes to look for opportunities to improve efficiency where available. Prepares reports, graphs and charts based on research and analysis.

Coordinates and executes reporting; directs and supports AIS users/leaders in identifying data needed for reporting using Microsoft Excel, PowerPoint and SQL Server 2017 Data Warehouse.

09/2018 to 12/2019 SEIU, Los Angeles, CA

SQL Server Data Analyst and Report Developer

Responsibilities:

-Creating, update and support tables in the SQL Server database, creating queries, views, stored procedures via MS SQL Server 2017.

-Create complex T-SQL Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications

-Extracting data in various formats from external sources and internal software systems and loading the data into SQL Server (ETL) via SSIS.

-Creating reports via SSRS and RDL, T-SQL, MS Visual Studio 2017.

-Widely using Excel Spreadsheet for inputting and analyzing of report data result.

-Creating, maintaining, optimizing and extracting data using stored procedures, views, functions, jobs.

-Document new and modified DB objects and procedures.

-Worked with SQL Profiler, Tuning Wizard, Execution Plan and Performance Monitor in order to analyze and optimize the queries, procedures.

-Testing application upgrades and changes.

05/2018 to 09/2018 LAHSA, Los Angeles, CA

SQL Server Data Analyst and Application Full Stack Developer

Responsibilities:

-Creating, update and support tables in the SQL Server database, creating queries, views, stored procedures via MS SQL Server 2017.

-Create complex T-SQL Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications

-Extracting data in various formats from external sources and internal software systems and loading the data into SQL Server (ETL) via SSIS.

-Utilize T-SQL in constructing user functions, views, indexes, user profiles, relational database models.

-Creating reports via SSRS and RDL, T-SQL, MS Visual Studio 2017.

-Widely using Excel Spreadsheet for inputting and analyzing of report data result.

-Creating, maintaining, optimizing and extracting data using stored procedures, views, functions, jobs.

-Creating indexes and triggers on the tables.

-Creating and troubleshooting dynamic store procedures. Creating SQL server traces.

-Normalizing data.

-Testing Data Base upgrades and changes.

-Mapping source data to target data model.

-Document new and modified DB objects and procedures.

-Saving daily work to SharePoint website.

-Use SharePoint Migration Tool (SPMT) to migrate files from SharePoint regular file shares and move them to SharePoint Online tenant.

-Worked with SQL Profiler, Tuning Wizard, Execution Plan and Performance Monitor in order to analyze and optimize the queries, procedures.

-Maintaining of WEB application via HTML, CSS, ASP.NET, VB.NET, VBScript, JavaScript, jQuery, AngularJS, C#, MS Visual Studio 2017.

-Testing web application upgrades and changes.

05/2016 to 05/2018 Holman Group, Los Angeles, CA

Data Analyst and Application Full Stack Developer

Responsibilities:

-Maintaining of WEB application via HTML, DHTML, CSS, Classic ASP, ASP.NET, VB.NET, VBScript, JavaScript, jQuery, AngularJS.

-Creating, update and support tables in the database, creating queries, views, stored procedures via MS Access and MS SQL Server 2014.

-Creating reports via SSRS, Crystal Reports, T-SQL, MS Visual Studio 2015.

-Creating and managing Automated File Exchange Processes.

-Creating and managing Data Transferring Processes via SSIS.

-Coding, data preparation, creation of reports and deep dive analysis.

05/2008 to 05/2015 Qcera, Inc., Los Angeles, CA

WEB and Application Full Stack Developer, DBO.

Responsibilities:

-Developing and implementation of WEB applications via HTML, DHTML, Classic ASP, ASP.NET, VB.NET, VBScript, JavaScript, jQuery.

-Converting WEB application from Classic ASP to ASP.NET.

-Developing and implementation of desktop Window Forms applications "Shell Records" via VB.NET.

-Create new web UI to collect user input and save into SQL Server database.

-Modify existing wed UI to add/remove content.

-Optimize speed and performance of web application.

-Validating user input and saving into database.

-Creating, update and support tables in the database, creating queries, stored procedures, and scripts via MS SQL Server2005/08.

-Creating, support and monitoring Jobs via SQL Server agent.

-Creating, update and support automation data extract, transform and load operations to a DB via DTS (Data Transformation Services) packages.

-Tools: MS Visual Studio 2008, SQL Server 2005/08, MS SourceSafe6.0, FileZilla Client, Remote Desktop Connection.

06/2002 to 05/2008 ADULT CARE CENTER “SHIRAS”, Tarzana, CA

DB Administrator, Computer Science Teacher

Responsibilities:

-Creating and support database via MS SQL Server 2000/2005.

-Preparing materials for classes

-Testing of student’s knowledge

12/2001 to 04/2002 SONIC FOUNDRY MEDIA SERVICES, Santa Monica, CA

WEB Developer

Responsibilities:

- Developing and implementation of WEB applications via HTML, DHTML, ASP, VB, VBScript.

05/2001 to 12/2001 CONSILIUM ASSOCIATES, Long Beach, CA

Systems Analyst, WEB Developer

Responsibilities:

- Developing technical specifications, process models and data flow diagrams.

Planning, developing and implementation of WEB applications via HTML, DHTML, ASP, VB, VBScript, JavaScript, and MS SQL Server 7.0.

- Creating relational database via MS SQL Server 7.0.

- Creating database connectivity via OLEDB and ADO.

- Creating and coding Select Statements, Queries and Functions for interacting with databases.

- Uploading and downloading files to/from the WEB server via WS_FTP95 LE.

The WEB application consists of 15 dynamically data-interacting pages, and performed the following functions:

- Login and registration of users;

- Validation of entered information;

- Receiving orders via dynamically changing form;

- Confirmation of successfully submitted information;

- Storing information to the database;

- Getting reports in ". PDF" format;

Tools: MS PWS, MS Visual Studio 6.0 (MS VisualInterDev 6.0), MS Front Page 2000, MS Adobe Acrobat and WS_FTP95 LE.

08/1999 to 03/2001 UTILITY TRAILER MANUFACTURING CO., City of Industry, CA

Application Developer

Planning, developing, implementation and testing of applications. Programming project “Warranty Claim System”. Developing and coding of “Warranty Claim System " project via VB, MS SQL Server 7.0, MS VisualSourceSafe, ADO, AS/400. Design and development 3-tier application with Data Access Layer, Business Logic Layer and User Interface-Layer. Creating custom controls "Warranty Status Bar Control" and "Date Box Control", using TreeView, SSDBGrid and many other controls.

Provide training on the applications.

02/1996 to 07/1999 MVM DIGICOM SYSTEMS, Los Angeles, CA

Application Developer

Developed applications via Visual Basic 5.0. to maintain and continuously update medical records for a local Family Medical Clinic.

Used VB for Access-97 and SQL to design a relational database for Family Medical Clinic.

Responsible for a development of a custom database for a “Family Support Program” project. Designed and implemented a new database browser with flexible input criteria. Duties included field customer support and training.

EDUCATION:

09/2002 to 12/2002 Los Angeles Pierce College, CA

“Client-side programming for the WEB “- Training program

01/1998 to 06/1999 Los Angeles Pierce College, CA

“Visual Basic 5.0” - Extensive training program

05/1997 to 08/1997 Advanced Education Center, Los Angeles, CA

“Visual Basic 4.0 “-Advanced Course. Certificate of completion.

11/1996 to 02/1997 International Career Development Center, Los Angeles, CA

“Client-Server Application Developing“ - Training Program.

Certificate of completion.

06/1987 to 06/1993 State Politechnical Academy - Minsk, Belarus

BS Degree in Engineering. Diploma

REFERENCES AVAILABLE UPON REQUEST

Contact this candidate