Yashasvi Busa

Email ID: adcpau@r.postjobfree.com

Phone No: 510-***-****

EXECUTIVE SUMMARY:

SQL Developer with 5+ years of IT Professional experience in Development, Client Analysis, Database Design, and Presentation using SQL Server.

Extensive experience in Data Modeling, Database Design, Programming, Development and Implementation of Client-Server Applications & Database systems using MSSQL.

Experience with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development, Implementation and Testing.

Expert in using generating Visual Studio Client Side Report, Tabular Reports, Matrix Reports, Drill down Reports, Parameterized Reports, Ad-hoc Reports, and Stylish Reports using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).

Expertise with DDL and DML statements, RDBMS, data dictionaries and normal forms.

Experience in Designing Data mart and Data Warehouse using Star Schema and Snowflake Schema for implementing Decision Support Systems.

Expertise in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), Data Transform Services (DTS), Bulk Insert, BCP and XML.

Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using BCP, DTS and SSIS.

Experience in SQL Server DTS and SSIS (Integration Services) package design, development, and deployment using SQL advanced features in Control flow, data flow, Error Handling and event handling.

Experience in end-user reporting definition, development and platform support using SQL Server Reporting Services (SSRS) and Performance Point.

Expert in Creating and Deploying SSRS Reports on the portal for user accessibility.

Extensive experience in writing Parameterized Queries for generating Tabular reports, formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS.

Experience in Logical and Physical Database design & development, Normalization and Data modeling using Erwin and SQL Server Enterprise manager.

Involved in developing OLAP dimensions, cubes, measures and calculated members with SQL Server Analysis Services.

Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows performance for monitoring and tuning SQL Server performance.

Highly proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions, User profiles, Relational Database Models and Data Integrity, SQL joins and Query Writing.

Experience in configuring Registered Servers, Linked Servers and Multi Server Administration.

Self-motivated to learn new technology with Excellent verbal and written communication skills combined with interpersonal and conflict resolution and strong analytical skills.

TECHNICAL STACK:

Languages

SQL, T-SQL, PL/SQL, C++,C#

SQL Server Tools & Packages

SQL Server Management Studio, Enterprise Manager, Business Intelligent Studio, Query Analyzer, Query Optimizer, Profiler, Performance Monitor, Database Tuning Wizard, SQL Server Agent, Crystal Reports, ETL

Databases

SQL Server, MS Access, Oracle

BI Tools

SSRS, SSIS, SSAS, BIDS and Visual Studio

Source Control

TFS, GIT hub, SVN

Architecture

RDBMS, OLAP, OLTP

Web Technologies

HTML, XML, Visual Studio

Operating Systems

Windows, UNIX/LINUX, Mac OS

PROFESSIONAL EXPERIENCE:

Client: Health Net, Woodland Hills, CA Feb 2019 - Present

Role: SQL Developer

Job Responsibilities:

Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (Flat files, Excel, Oracle DB2, and SQL Server).

Extract and Transform data into Staging Database and load data into data warehouse to create fact table and dimension table

Performed Loading operation of historical data using full load and incremental load into Enterprise Data Warehouse.

Used try-catch block to handle the errors and to store all the errors in a table to handle them later and to continue the flow of execution.

Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.

Developed Custom Logging so user can know when a row is inserted in custom logging table by every SSIS package that executes.

Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Send Mail Task, Package Execution task to achieve business needs.

Created OLAP cubes on top of the data warehouse basing various fact and dimension tables for analysis purposes using SQL Server Analysis Services (SSAS).

Created and modified various complex Stored Procedures used in the application using T-SQL.

Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.

Wrote complex Expressions for SSRS with Conditional Formatting.

Responsible for Deployment of the report using SSRS and used Report Subscription (Data Driven and Standard) to publish reports.

Tuned SQL query for better performance using SQL Profiler. Documented all work, so user can easily understand the flow of process.

Technologies used: Microsoft SQL Server, SQL Server Integration Services tools (SSMS, BIDS and SQL Server Manager), SSRS, SSAS, BIDS, MS Visio, MS Excel, Oracle, windows.

Client: Hancock Whitney, Gulfport, MS Nov 2017 – Jan 2019

Role: SQL Developer

Job Responsibilities:

Experienced in Data Modeling used to define and analyze data requirements needed to support the business processes within the scope of corresponding information systems in organizations.

Experienced in Team Foundation Server which also includes a data warehouse where data from work item tracking, source control, builds, and testing tools are stored.

Generated Drill down, Drill through, Matrix Reports, and Parameterized reports using expressions to calculate, group, filter, and parameterize report using SSRS.

Review reporting outputs for transparency, consistency, and accuracy.

All team projects are stored and managed with Team Foundation Server.

Developed functions, triggers, stored procedures, views, tables, and SQL scripts to meet the requirements of the business users and application development.

Developed Stored Procedures for the Datasets to build the reports for the client requirements.

Created SQL Joins, sub-queries and other SQL code to implement business rules.

Designed and developed SSIS Packages (.dtsx files) to import and export data from MS Excel, SQL Server, Oracle and Flat files.

SSIS packages to update tables with monthly data and automated it through scheduled jobs for the beginning of every month.

Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS.

Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate and Derived Column.

Developed packages in SSIS with error handling.

Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using BCP in staging database from MS Access, excel.

Participating to create Star Schema, Snow Flake Schema using the concept of data modeling with Team.

Experienced in Dimensional Data Modeling and some of the terms commonly used are Dimension Table, Attributes, Hierarchy, Fact Table, Lookup Table.

Technologies used: MS SQL Server, SQL Server Integration services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), T-SQL, Microsoft Office, OLAP, ORACLE, windows.

Client: VMware Software, INDIA Aug 2014 - Apr 2017

Role: SQL Developer

Job Responsibilities:

Worked with various upstream and downstream customers in interfacing various systems and processes for Data extractions, ETL, Analytics and reporting needs.

Point of contact for all the Data processes, Data Mappings, Data dictionaries, Data pulls and Reporting solutions.

Designed and Developed SSIS Packages to import and export data from MS Excel, XML, SQL Server, Flat files, DB2 and used SSIS Package Configuration, Expressions, passing variables dynamically, logging, Event Handler.

Performing Data source investigation, developed source to destination mappings and data cleansing while loading the data into staging/ODS regions.

Applied various data transformations like Lookup, Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.

Creating SQL Server Agent Jobs to maintain and run various SSIS packages periodically or as scheduled.

Responsible for identify and translate business requirements for the Enterprise Data Warehouse into logical and physical data models.

Integrated SQL Server 2005 reporting services (SSRS) with Microsoft Office Share point Server to automatically deliver reports to the Share Point portal.

Querying, creating stored procedures and writing complex queries and T-SQL Joins to address various reporting operations and also random data requests.

Created Drill-through reports, parameterized reports and linked reports using SSRS and were integrated in the Performance point server.

Creating and maintaining various subscriptions in the Report Manager for the reports.

Developing products by determining what competitors are doing, risk assessments, ratings assessments, pricing and coverage.

Technologies used: MS SQL Server, SQL BI Suite (SSAS, SSIS, SSRS), Visual Studio, Team Foundation Server, C#, Visual Source Safe (VSS), Pl/SQL, Share Point, Oracle, windows.

Contact this candidate