SSRS/ETL developer

Sukruth

SQLBI

*****.*******@*****.***

216-***-****

Summary:

Experienced as a MS SQL Server BI Developer 2014/2012/2008R2/2008/2005/2000 in various Industry verticals like State, Finance and Insurance.

Extensive experience in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions.

Very Good knowledge on C#.

Very good understanding of SQL Server Architecture design and Data-Warehousing Concepts.

Extensive experience in Data-Warehousing projects as a Business Intelligence developer worked in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS)and SQL Server Analysis Services (SSAS) SQL Server 2014/2012/2008R2/2008/2005.

Experience on Performance monitoring using SQL Profiler. Scheduled and monitored all maintenance activities of SQL Server 2014/2012/2008R2/2008/2005/2000 including database consistency checks and index defragmentation.

Experience in SQL Server (2014/2012/2008R2/2008/2005/2000) Installation, Configuration, Performance Tuning, Client/Server Connectivity, Query Optimization, running database consistency check with DBCC Commands.

Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modelling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.

Hands-on working experience with analyzing query plans, using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks.

Expert in developing SSIS Packages to Extract, Transform and Load (ETL)/DTS data into the Data warehouse from Heterogeneous databases such as Oracle, DB2, Sybase, Excel and MS Access.

Experience in creating packages, Jobs, Sending Alerts using SQL Mail.

Expert in creating, configuring and fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).

Experience in designing and developing large number of enterprise reports (SSRS/Business Objects) using the data from ETL loads, SSAS Cubes and various heterogeneous data sources.

Expertise in creating cubes with dimensions and facts tables in MOLAP Warehouse using SQL Server Analysis Services (SSAS).

Experience in using the above query results from Cosmos, creating reports in PowerBI, Adspulse to show the metrics by server and procedure name, by server etc.

Extensively worked with Parameterized Reports, Report Snapshots, and Linked Reports and used Report Manager for deploying reports in SSRS (2008R2/2008/2005).

Strong experience in database installation, capacity planning, implementing backup and recovery strategy for application and database.

Expert in using Performance Tuning tools like MS SQL Profiler, Index Tuning wizard, SQL Server Database Engine Tuning Advisor.

Experience in developing Ad-hoc reports using Business Objects, Data Flow Diagrams, Process Models, ER diagrams, Dimensional Data Models, SDLC concepts.

Experience in designing Power BI reports and Dashboards.

Used Visual Source Safe (VSS)for version control and configuration management.

Strong knowledge working with all the phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.

Experience in using Microsoft Azure Cloud Platform.

Worked in collaborative team environment with other developers, business analysts, and a project management team.

Can do Attitude and ability to effectively communicate with all levels of the organization such as Management, technical and customers.

Involved in creating Design documents of various APIs

Technical Skill Set:

RDBMS

SQL Azure, MS SQL Server2014/2012/2008 R2/2008/2005/2000, Access, Excel.

Database Tools

BIDS 2012/2008 R2/2008/2005, Management Studio, Visual Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Data Transformation Services, SSIS, SSAS, Upgrade Wizard, Replication.

Programming languages

SQL, T-SQL, PL/SQL, VB.NET, C#, Hive, .Net framework 2.0+, .Net development

Scripts

PHP, JavaScript, CSS, VBScript, HTML and XML.

Operating systems

Windows NT/2000/XP/2003/Vista/Windows 7/8.

Reporting Tools

SSRS, Performance Point Server, Report Builder, Focus, Power Pivot, Power BI.

Other

Microsoft Office, Visio, Dream viewer, Team Foundation Server (TFS) and Visual SourceSafe, Hadoop, COSMOS, HDFS.

Professional Experience:

NEW CENTURY HEALTH, BREA, CA Jan 2019- Present

ETL Developer

Responsibilities:

Analyze business processes and requirements, and carry out project tasks required for the design, implementation, testing, and support of new and existing ETL processes and solutions.

Designs, develops and monitors Enterprise Transformation Language (ETL) processes. Creating stored procedures and functions to perform business operations on the back-end using MS SQL Server 2015 database.

Touch base with Business System Analyst to understand the requirements of tasks assigned, involving in Data analysis and profiling and participate in design discussions.

Creating SSIS packages to extract data from OLTP sources like MS SQL Server 2015/2017, Flat Files, Excel and Access to OLAP systems (SQL Server 2015), transforming them according to the business requirements and load into the respective databases.

Creating functional and technical specifications, unit and integration testing, preparing user manuals and training key users. Involving in optimizing queries with Stored Procedures and parameter sniffing to get rid of the performance issues.

Created SSIS packages to clean and load data to Enterprise Data Warehouse.

Extensively worked in developing SSIS packages for EDW – Includes identifying incremental load logic and SCD Type 2 logic for all the Dimensions and Facts.

Performing DDL, DML activities in database to handle the data using Stored Procedures, functions, Triggers and T-SQL queries. Experienced in Error Handling and Troubleshooting the scripts in failure to load the data into database.

Used SSIS to create ETL packages (.DTSX files) to validate, extract, transform and load data to data warehouse databases, data mart databases. Enhancing and deploying the SSIS Packages from development server to production server.

Scheduling jobs for executing the put away SSIS bundles which were created to automate process like refresh the database on Daily premise, load the incoming data from different sources at a particular frequency.

Involved in Unit Testing, Validating Reports and Production Support to determine progressing Production Problems by checking on configuration changes made to create frameworks. Involved in Performance tuning of the SQL Server Queries utilized as a part of SSIS packages.

Creating Tech design and Release documents for QA and Production environment for all the developments done.

Strong knowledge in all the transformations i.e. Lookup, Condition Split, Aggregate, etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, and CSV files to data warehouse.

Performing some Quality Assurance (QA) testing for the code developed by other developers in the team if required.

Collecting and understanding the requirements from the developer and then creating high level test plans for testing in QA environment. Reporting bug fixes to the developer after testing has been carried out.

Environment: MS SQL Server 2015/2017, SSIS, SSAS, T-SQL, PL-SQL, SQL Profiler, HTML, XML, MS Excel, MS Office 2013/2016.

Client: Applied materials, CA Sept 2017 – Dec 2018

SQL/BI SSRS Developer

Responsibilities:

Involved in planning, defining and designing database as per Business requirements.

Created SSIS packages to extract data from OLTP sources like MS SQL Server 2012/2014, Text Files, Excel and Access to OLAP systems (SQL Server 2012/2014).

Involved in Cube Partitioning, Refresh strategy and planning and Dimensional data modeling in Analysis Services (SSAS).

Designed and implemented InfoPath forms

Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases

Good at using shared and global variables across crystal reports

Excellent knowledge of the design and implementation of the Data Warehouse life cycle.

Scheduled jobs to call the packages and stored procedures.

Involved in installation of Tableau desktop 9.3, Tableau server 9.3.

Worked on latest versions of Tableau 10.x.

Transferred data from various sources like MS Excel, MS Access, and SQL Server using SSIS 2012 and then created reports using this data using SSRS 2012

Configured and maintained Report Manager and Report Server for SSRS.

Identified and added the report parameters and created the reports based on the requirements using SSRS 2008.

Identified and worked with Parameters using complex expressions for parameterized reports in SSRS 2005.

Designed the schema in Microstrategy Desktop based on the business requirements.

Developed Query for generating drill down reports in SSRS 2014/2012.

Applied conditional formatting in SSRS to highlight key areas in the report data

Created report links to refer other reports in a particular report. And also created report links for different servers.

Created report snapshots to improve the performance of SSRS.

Implemented logic to control job dependencies between ETLs solely through the use of event-raise and event-wait tasks and entries made by ETLs in pilot database tables.

Generated reports with parameters, sub reports, cross tabs, charts using Crystal Reports

Deployed reports and Power BI dashboards on the reports/SharePoint server; scheduled deployments with subscriptions.

Published reports and dashboards designed in Power BI utilizing, Power BI services and shared it across through Microsoft Office 365.

Involved in designing, reviewing, and creating primary objects like Views, Indexes, Stored procedure, Functions, Triggers based on logical design models, user requirements and physical constraints.

Wrote T-SQL queries, stored procedures and used them to build packages. Extract Transform Load(ETL) development Using SQL server 2012, SQL 2012 Integration Services(SSIS)

Generated several drill down and drill through reports using SSRS.

Designed phased approach for PowerCenter migrations to reduce complexity, mitigate implementation risk and to reduce batch processing outage.

Develop powershell scripts and ARM templates to automate the provisioning and deployment process.

Troubleshoot and identify performance, connectivity and other issues for the applications hosted in Azure platform.

Expert in creating Star schema cubes using SSAS.

Extensively worked on OLAP cubes using SSAS. Responsible for documentation of system related activities. Used Dataset, Data Table, Data Adapter, Data Reader and other ADO.NET connectivity controls

Created stored procedures and functions to perform business operations on the back-end using MS SQL Server 2012 database.

Generated context filters and data source filters while handling huge volume of data in Tableau.

Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.

Experienced in integrating different Microsoft BackOffice Components such as Share Point and IIS with MS SQL Server

Created and Managed OLAP Cubes using SSAS.

Used Performance Point Server to create reports, scorecards and dashboards. Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.

Writing queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder 2.0.

Designed and created Report templates, Bar graphs and Pie charts based on the financial data.

Dealt with huge amount of data and used SSAS in order to retrieve the data

Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008.

Environment: MS SQL Server 2014/2012/2008/2005, SSIS, SSRS, SSAS, SQL Profiler, T-SQL,, ASP.Net, HTML, XML, C#, CSS, ADO.Net, AJAX, VB Script, MS Access, Excel, MS Visio, MS Office 2007/2003,Windows 2003/2000/XP, Power BI

Comsource, OH Oct 2016 to Aug 2017

Sr. SQL BI/Cosmos Developer

Responsibilities:

Developed and changed Branch Reports, Management Reports SSRS Reports according to the prerequisite.

Designed and Developed reports in light of necessities utilizing SQL Server Reporting Services (SSRS) and conveyed them.

Server Reporting Services (SSRS). Made Alerts for fruitful or unsuccessful culmination of Scheduled Jobs.

Extensively chipped away at Cross Tabbed and Matrix reports utilizing SSRS.

Built compelling questions for elite announcing and rendered them to HTML, XML, PDF and Excel organize utilizing SSRS 2012 and 2014.

Developed Query for producing Drill Down and Drill Through Reports in SSRS 2012 and 2008.

Designed and designed SSRS Reports utilizing Parameters and Expressions for the Reports.

Refreshing the required Databases through SSIS bundles.

Monitoring SSIS Jobs nearly and checking the Data in tables

Modified the current SSIS bundles to meet the progressions determined by the clients.

Scheduled Jobs for executing the put away SSIS bundles which were created to refresh the database on Daily premise.

Worked on all activities related to the development, implementation, administration, Installation of SQL Server, SSMS, SSIS, SSRS and support of ETL processes for large-scale Data project which included the claims & policy data of the client.

Involved in building Data Marts and multi-dimensional models like Star Schema and Snowflake schema.

Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances. Experience in using T-SQL for creating stored procedures, indexes, cursors and functions.

Creating tables, indexes and designing constraints and wrote T-SQL statements for retrieval of data and involved in performance tuning of T-SQL Queries and Stored Procedures.

Implemented SSRS solutions, used dashboards and gauges to enhance for the business users.

Deployed and Generated SSRS reports using the Reporting Services, Report Manager and Microsoft SharePoint 2010.

Loaded data into data warehouse from multiple sources such as flat files, excel sheets and from different databases.

Worked on enhancing the ETL packages & deploying them to the server from development to production environment.

Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.

Involved in Migrating the data model from one database to oracle database and prepared an oracle staging model.

Involved in extensive movement task to move reports from 2012 to 2014 in SSRS.

Designed SSRS reports with sub reports, dynamic arranging, characterizing information source and subtotals for the report.

Developed specially computed measures utilizing DAX in Power BI to fulfill business prerequisites

Provided proceeded with support and improvement of bug fixes for the current and new Power BI Reports.

Working on extracting the logs from Cosmos using Scope.

Developing the reports using POWER BI, Power Pivot and SSRS and SSIS, SSAS and COSMOS. Adding the feeds and scheduling the jobs

Involving in production deployments for Cosmos and SSAS and Power BI.

Extracting the Data from Different data sources to BigData platform Cosmos, and Transform the data to Dimensions and Facts.

Extract the Data from Cosmos to SQL layer, and Build SSAS Cubes.

Deployed reports, made report timetables and memberships. Overseeing and anchoring reports utilizing SSRS.

Working on new change asks for on SSRS reports. In charge of Scheduling Jobs, Alerting and Maintaining SSIS bundles through Active Batch Job Schedule

Created a SSIS bundle for BULK Copy Program sending out the tables to level record to new NDM shared area.

Worked with different changes like Lookup, Fuzz Lookup, Merge, Sort, Multicast, Conditional Split, Script Component, Loop Containers, Execute SQL Task and parcel all the more utilizing SSIS.

Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases and process SSAS cubes to store data to OLAP databases.

Modified MDX questions to remove information from the information shop

Done Extensive POCs on Cosmos Migration to ADLS using U-SQL, ADLA, AAS and ADF.

Environment: MS SQL Server 2014/2012/2008, SSRS, SSIS, SSAS, T-SQL, ETL, Server Data tools, COSMOS, SharePoint, VB.Net, .Net 4.0/3.5.

Client: HDFC July 2015 - May 2016

SQL BI Developer (SSRS/SSAS)

Responsibilities:

Extracting and Loading data into SQL Server Database using SSIS.

Extensively involved in designing the SSIS packages to export data from flat file source to SQL Server database.

Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2014/2012/2008/2005(SSAS)

Used data modeling tool Erwin for creating Logical, Physical data models and DDL’s.

Created SSIS Packages to migrate slowly changing dimensions

Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).

Experience in creating complex SSIS packages using proper control and data flow elements.

Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.

Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).

Pulling data on a daily basis from OLTP database to OLAP or staging database using the SSIS packages.

Rendering the reports to PDF formats as per the requirement and printing all the reports in a batch process for Monthly Statements.

Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases

Performed the task of data transfer from files in remote server to folders in another server using FTP.

Created database maintenance plans and deleting of history data using SSIS packages.

Scheduling the SSIS packages and Jobs.

Implemented entire ETL job plan through Informatica Scheduler.

Designed SSRS 2008 reports with Cascaded Parameters, Gauges and Interactive Charts, etc.

Excellent report creation skills using Microsoft SQL Server 2012/2008/2005 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.

Created SQL Server Reports based on the requirements using SSRS 2008.

Highly responsible for development and management of PPS, SSAS, SSRS and SSIS projects.

Building KPI reports for the cubes and optimizing the reports.

Designed and developed the most suitable User Interface such as Dashboards, multiple charts types, Trends, KPI's, custom requests for Excel Export and objects for Management Dashboard reporting using Excel Power Pivot and published them using Power BI.

Involved in partitioning of cubes in order to increase the performance of cubes (SSAS).

Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.

Created complex reports which involve more number of groupings and multi-value parameters

Using SQL Server Reporting Services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.

Design and create report models based on users’ requirements, explain and train users to use report builder to generate their own personalized reports.

Worked very closely with Business Customers, End Users and resolved any business process related issues.

Environment: SQL Server 2012 Enterprise Edition, SSAS, SSIS, T-SQL, SSRS, Windows Server 2008, Oracle 9i, Ms excel 2003, Microsoft Visual Studio 2008, Power BI.

Worksphere Technologies, India Feb 2013 to Jun 2015

SSIS/SSRS Developer

Responsibilities:

Gathering detailing prerequisites from clients and business experts and investigating necessities.

Generated reports utilizing SSRS that could be utilized to send data to various Primary sellers, customers and supervisors.

Designed and executed put away methodology and triggers for computerizing assignments.

Involved in making SSRS Reports, which are, exceed expectations well-disposed to perform different activities like rotate.

Created SSIS Packages for Import/Export information to/from SQL Server.

Developed Operational reports to help complex client necessities utilizing SSRS.

Worked on SSIS execution tuning utilizing counters, mistake dealing with, occasion taking care of, re-running of fizzled SSIS bundles utilizing checkpoints.

Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances. Experience in using T-SQL for creating stored procedures, indexes, cursors and functions.

Creating tables, indexes and designing constraints and wrote T-SQL statements for retrieval of data and involved in performance tuning of T-SQL Queries and Stored Procedures.

Created SSIS DB catalog with SQL Server 2012 to support SSIS package deployments in SSMS with Environment variables respective to each environment. Used Batch Files to Import Data from other Data Base.

Used SSIS to create ETL packages (.DTSX files) to validate, extract, transform and load data to data warehouse databases, data mart databases. Enhancing and deploying the SSIS Packages from development server to production server.

Wrote the ETL scripts to load the data into database from various source files. Experienced in error handling and troubleshooting the scripts in failure to load the data into database.

Responsible for designing different Data warehouse schemas like Start and Snowflake using ERwin.

Involved in developing Logical and Physical Data Models.

Created Tableau scorecards, dashboards utilizing stack bars, structured presentations, scattered plots, land maps, Gantt graphs utilizing show me usefulness.

Creating Database objects – tables, perspectives, and capacities and creating methods for executing application usefulness at the database side for execution change. Performing question designs and ensuring every single inquiry is utilizing fitting valuable lists.

Involved in taking care of live site creation issues. Giving a hot fix to the issue.

Create distinctive SSRS Reports in view of the client's necessity. Different sorts like specially appointed reports,

Created Tablix Reports, Matrix Reports, Parameterized Reports, Sub-reports, Charts, Grids utilizing Sql Server Reporting Services 2008 R2, 2012 and COGNO's.

Designed tabular, matrix reports, drilldown, drill through, Parameterized and linked reports in SQL Reporting Services (SSRS).Designed Cubes with Star Schema using SQL Server Analysis Services 2012 (SSAS).

Involved in Dimensional Data displaying.

Involved in Unit Testing, Validating Reports and Production Support to determine progressing Production Problems by checking on configuration changes made to creation frameworks Involved in Performance tuning the SQL Server Queries utilized as a part of SSRS Reports.

Bug settles in SSRS and put away systems as vital.

Played parts underway help for SSRS occupations.

Modified figured measures and measurement individuals utilizing Multi-Dimensional Expressions (MDX).

Optimized long running put away techniques and inquiries for powerful information recovery.

Involved in Dimensional Data demonstrating.

Created content assignments and segments with C# and VB.NET in SSIS as a major aspect of ETL stack.

Use of SharePoint and TFS for rendition controlling, putting away and report the same by making Tasks in TFS.

Developed Dashboards to investigate deals, inventory network.

Environment: MS SQL Server 2014/2012, SSRS, SSIS, SSAS, T-SQL, ETL, Server Data tools, Star Schema, SharePoint 2012, VB.Net, .Net 3.5, SCOM.

Contact this candidate