Developer Data

BAZAR AYUSHIEV

Phone: 646-***-**** E-mail: *********@*****.***

SQL BI DEVELOPER

SUMMARY:

●Over 6 years of IT Experience in System Design, Development and Support of Microsoft SQL Server in various domains.

●Over 6 years of ETL experience using SSIS.

●Over 6 years of IT experience in BI reporting and data visualization with SSRS, Crystal Reports and Tableau.

●Over 6 years of Microsoft Power BI experience.

●Over 4 years of experience in designing and developing of Data Warehouses in SQL Server.

●Over 3 years of IT experience in Oracle and PL-SQL programming.

●Over 3 years in Netezza developing, Microsoft Azure, MongoDB, Cognos

WORK EXPERIENCE:

Blue Shield of California, San Francisco, CA, Database Developer, September 2017 – July 2020

Analyze business requirements, create technical and design documents for current development activities.

Identify, assess, and create source to target mappings.

Define and apply business rules for transformation processes and develop transformation logic for ETL processes.

Design and develop data transport and population processes for working environment.

Adapt ETL processes to accommodate changes in source systems and new business requirements.

Develop and manage BI dependency plan, job scheduling and cycle management.

Assist in performing system integration testing and user acceptance testing as required by software development lifecycles.

Interface with DBAs and other development teams to deliver proper results on time.

Create, classify, monitor, and track the defects, verify fixes.

Propose best practices and solutions to resolve the engineering problems.

Active participation in all sprint and release related meetings.

State of Pennsylvania, Department of Community and Economic Development, Harrisburg, PA, BI Developer, March 2014 – September 2017

●Involved in writing T-SQL Programming for implementing Stored Procedures and Functions for different tasks.

●Involved in Planning, Defining and Designing data based on business requirements and provided documentation.

●Documentation of business rules and existing processes for development activities.

●Developed complex reports using multiple data providers, user defined objects, charts, and synchronized queries.

●Designed Database, Tables and Views structure for the new data mart.

●Created Tabular reports, Cross Tabs, Drill down, Drill through, Pivot, Charts, Functions and Maps.

●Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions.

●Converted existing reports based on Oracle database to SQL Server. Rewrote all oracle-based queries and stored procedures for these reports to SQL Server based.

●Performed maintenance duties like performance tuning and optimization of queries, functions, and stored procedures.

●SSIS scripting using Script Task and Script Component through utilization on .NET code.

●Enable data usage for business users via SSAS cubes by utilizing MDX, DAX, PowerPivot, and SharePoint.

●Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS.

●Design, implement and support business intelligence reporting using Tableau.

EDUCATION AND TRAINING:

Bachelor’s degree. Mathematics and Computer Science, 2009.

Bachelor’s degree. Biology and Geography Science, 2010.

Contact this candidate