Shailendra Bandari

adig8i@r.postjobfree.com

571-***-****

Professional Summary:

A results driven software professional with 6+ years of progressively responsible experience in Data Analysis, Design, Implementation, Administration and Support of Business Intelligence, OLTP (Batch Processing, Online Processing), OLAP, ETL, Data warehousing, Data mining, DBMS and Data Modeling using Microsoft SQL Server 2016/2014/2012/2008R2 /2008/2005, SSIS, SSRS and SSAS.

Experience in Building End-to-End BI and Visualization Solutions using Microsoft Azure Stack – Azure SQL, Azure Data Factory & Pfower BI Platform.

Ability to work with various types and stages of Software Development Life Cycle (SDLC) processes including Analysis, Design, Development, Testing and Implementation.

Skillful in ETL-Extraction Transformation Loading, Operations Data Store concepts, data marts and OLAP-Online Analytical Processing technologies.

Workshop PLUS - Business Analytics with Power BI / Power BI CLOUD Administration.

Proficient knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes schemas, ETL processes, dimensional modeling and reporting tools.

Domain users management through Active Directory for Microsoft Power BI.

Proficient in writing complex T-SQL (DDL, DML), new features like CTE, Ranking Functions, TOP(n), PIVOT, XML PATH,SQL, physical, logical database design and Performance tuning.

Experience in Query tuning and performance tuning using SQL Profiler, Clustered and Non-Clustered indexes on tables for faster query retrieval.

Strong knowledge of Software Development Life Cycle (SDLC) including requirement analysis, design, development, testing, and implementation. Provided End User Training and Support.

Extensively used factory object in NodeJS to use the common functions in different views.

Developed custom SSIS Packages with C#, VB logic in SSIS Script task and Script Component.

Expertise in designing SSIS packages to import and transform data between databases and external data sources using various transformations like Data conversion, Conditional Split, Derived column, file system task, row counts, OLE DB Source, OLE DB Destination, OLE DB Command, Merge Join, Look up, Sort, Data flow task and so on.

Expertise in generating reports using Power BI, SQL Server Reporting Services, Tableau, MS Excel spreadsheets and Power Pivot.

Experience with business intelligence reporting tools using Business Objects, Cognos and Hyperion.

Worked as liaison between traders, developers, project manager and process/product analyst to understand the business processes and identified enhancements.

Expert on creating Score Cards, Metrics, Power View/MAP and PivotTables using Office 365

Experience in creating Data Modules, Data sets, Dashboards in Cognos Analytics.

Course of Power BI Desktop & Report server - Managing, Modelling, Visualization Data and DB Administration.

Expertise in using Microsoft Azure including Azure CLI, Azure Management, Azure Porta, Azure PowerShell, cloudmonix, Azure Management PowerShell Cmdlets, Red Gate Cloud Services.

Experience in Ad-hoc reports, data driven subscription reports by using Report Builder.

Expert in creating reports with Charts, Gauges, Table, Matrix, Images, Map, Indicators and so on.

Experience in developing Dashboard Report, Parameterized Reports, Linked reports, Sub reports by Region, Year, Quarter, Month and Week.

Developed custom Azure Runbooks and connections to the REST API which will send email/text messages whenever there is a failure in scheduled pipelines at every stage

Expert in all the Latest BI Tools Tableau, Power BI Dashboard Design.

Analysis and troubleshooting Microsoft applications with Microsoft people in the Banca Intesa Sanpaolo headquarters also for the foreign offices (Calls, chat and email in English language)

Created different Power Pivot reports as per the client requirement.

Involved in Automation of ETL processes and jobs using PowerShell to reduce manual intervention.

Worked on creating Azure Data Factory for moving and transforming the data.

Worked with Azure Data Lake Store to capture data of any size, type, and ingestion speed in one single place for different operations

Experience in Migrating databases from SQL 2008 R2 to SQL 2012.

Experienced in all facets of Software Development Life Cycle (Analysis, Design, Development, Testing and maintenance) using Waterfall and Agile methodologies.

Experience in Agile methodology and implementation of enterprise agile practices

Technical skills:

Databases

Microsoft SQL Server (2005/2008/2008R2/2012/2014/2016), Oracle 8i/9i, Oracle 10g/9i DB2,Postgre MS Access, NoSql Databases(Hbase).

Database Tools

MS SQL Server (2005/2008/2008R2/2012), MS-Access, SQL Server Integration Services(SSIS), Data Transformation Services(DTS), SQL Server Reporting Services(SSRS)

Development skills

T-SQL, PL/SQL, SSIS/SSRS, SQL PLUS, Power BI

Languages

VB.net, Linux, Unix

ETL Tools

DTS, SSIS (SQL Server Integration Services), Informatica,COMOS, Kettle,Cognos,Tableau.

Reporting Packages

SQL Server Reporting Services, MS Excel.

Tools/Methodologies

MS Project, SQL Profiler, Toad, TFS 2010, Agile, Jira, Waterfall.

Operating Systems

Windows XP, Windows 7,Windows 8, Win 2003/2008/2008R2

Professional Experience:

Optum,Inc, Latham,NY Jan 2019- Current

Sr. Power BI/SQL Developer

Responsibilities:

Extensive experience in developing Stored Procedures, Views, Cursors, Triggers, Scripts and Complex Queries in MS SQL Server.

Worked on Designing and Implementation of Business Applications using the Oracle/SQL Server Relational Database Management System (RDBMS).

Developed SQL Queries to fetch complex data using Inner/Outer joins, sub-queries, CTE, Tally tables accommodating complex filters and database links.

Developed the automation scripts by using the REST APIs to extract data from blob storage of Cloud Services.

Optimized the performance of queries in T-SQL queries, normalized tables, established joins and created clustered/non-clustered indexes wherever necessary.

Analyzed the NodeJS server structure in legacy project, then mimicked the REST service.

Generating PowerShell scripting to avoid errors and also used for SSRS.

Developed models, reports and dashboards using Microsoft Power BI stack Power Pivot, Power View, Power query.

Imported data from different data sources like SQL Server DB, Azure SQL DB to Power BI for Vetting Business users and published concerned reports to BI portal

Performed ETL operations in Azure Databricks by connecting to different relational database source systems using jdbc connectors.

Created indexes on the tables for faster retrieval of the data to enhance database performance.

Designed, developed and maintained Data extraction and Transformation processes and ensured that data is properly loaded and extracted in and out of our systems.

Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.

Performed most of the SQL Server Enterprise Manager and Management Studio functionality using T-SQL Scripts and Batches.

Performed administration tasks using PowerShell scripting using cmdlets.

Created REST clients to consume data from other partner applications and involved in creating POC’s using MEAN stack and enhancing existing REST API’s developed using Node-JS.

Utilized Power BI - Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports and created reports and dashboards using Power BI.

Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.

Migrated reports from Business Objects to Tableau.

Creating reports using Power BI in a Microsoft Business Intelligence Environment. Created Power BI Templates that are being currently used for daily report generation.

Successfully designed Tabular model in Visual Studio 2012.

Used PowerShell script for SQL Server Maintenance activities.

Worked with MS Excel and used Power pivot and power Query for Data Analysis and create sophisticated data models.

Used SSIS packages to upload files into Azure Data Lake using Shell script and used External tables to retrieve data into data warehouse.

Created Fact and Dimension tables as well as Data Marts and operational data stores and used dimensional modeling. Data warehouses were created for reporting services and creating dashboards.

Worked with Azure Data Lake and SSIS/SSRS for data mapping and data transformation.

Developed Cubes using SQL Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions, and data source view

Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server Analysis Services (SSAS) and Reporting service (SSRS).

Extracted Source data from REST API using UNIX shellscripts.

Developed the packages in Framework manager and published into the Cognos connection server.

Built cubes for production application, Partitioned Cubes to decrease the processing time and increase the performance of the queries running on front end application using SSAS 2008.

Environment: SQL Server 2008R2/2012/2014, Windows Server 2008(x64), SQL Server Management Studio, Visual Studio 2013, T-SQL, VB Script,Azure, REST API, Tableau PowerShell,Cognos, SQL Profiler, Hadoop, Power Pivot, Big Data, No SQL databases, VB.NET.

IMPAQ International llc,Columbia,MD Oct 2016 - Dec 2018

SQL/Power BI Developer

Responsibilities:

Collected business requirements from users and translated them as technical specs and design docs for development.

Created and Modified T-SQL stored procedures/triggers to validate integrity of the data.

Created Typescript reusable components and services to consume REST API's using Component based architecture provided

Worked with Azure SQL Data Warehouse.

Identified various data sources, formulated data dictionaries, design and develop data models (physical/logical data models) based on the given specs and requirements.

Performance tuning, query optimization and execution plan of queries for better performance.

Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints on various database objects to obtain the required results.

Automated Power Query refresh using Powershell script and windows task scheduler.

Scheduled data refresh on Tableau Server for weekly and monthly increments based on the new changes to ensure that the views and dashboards were displaying the changed data accurately.

Developed SSIS packages for extract/load/transformation of source data into data warehouse/OLAP cubes as per the functional/technical design and conforming to the data mapping/transforming rules.

Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.

Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.

Performed data cleansing, enrichment, mapping tasks and automated data validation processes to ensure meaningful and accurate data was reported efficiently.

Developed free-form reports using SSRS for consolidating multiple reports into single report delivered in .pdf format to the power users.

Developed parameterized reports, drill down, drill through reports, sub reports as per the report specifications and functionality.

Implemented complex business logic through T-SQL stored procedures, Functions, Views and advance query concepts .

Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.

Directly involved into requirement gathering and understanding business functions with the end users.

Provided valuable suggestions to users in terms of database design and new application implementation to overcome existing performance and reliability issues.

Created report schedules and subscriptions. Created data driven subscriptions, reports that run on demand, cached the Reports, Snapshot of the Reports. Deployed reports both to the SharePoint server, IIS Server, Integrated SharePoint server with Report Server.

Performance tuned long running lengthy SSRS reports and optimized rendering time by 10 times of the actual time.

Integrated Custom Visuals based on business requirements using Power BI desktop.

Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.

Developed complex calculated measures using Data Analysis Expression language (DAX).

Embedded Power BI reports on SharePoint portal page and also managed access of reports and data for individual users using Roles.

Successfully redesigned and migrated complex applications from Access to SharePoint and SQL Server 2008 by evaluating database structures and data movements.

Provided 24X7 production support to ensure timely and error free delivery of reports.

Performed performance tuning and optimization of SQL queries to improve query performance and to reduce runtime.

Extensively worked on enhancements and performance issues of the existing data import processes.

Developed Multi-dimensional, OLAP cubes as per the specifications using SQL Server Data Tools. Participated in the design, development of hierarchies, dimensions, attributes, properties, calculation and allocation routines for delivering the desired KPI’s in the Cubes.

Independently worked on different stages of SDLC by gathering requirements, managing development, providing support and documentation processes thereby ensuring timely deliverables and uninterrupted continuity of business.

Developed meta-data structure and configuration for storing/preserving database connection and security parameters using SQL Server configurations, XML configurations .

Created hierarchies in Power BI reports using visualizations like Bar chart, Line chart, etc.

Worked with both live and import data in to Power BI for creating reports.

Managed relationship between tables in Power BI using star schema.

Used different type of slicers available in Power BI for creating reports.

Assisted users in creating and modifying worksheets and data visualization dashboards

Created Data Visualization, Data modeling, Data Warehousing, visualization reports and dashboards

Created POWER BI Reports from POWER BI Desktop to POWER BI Service .

Responsible Publishing for building POWER BI Dashboards for 3M Digital Marketing team using Tabular and Multi-dimensional Models.

Design and model data sets with POWER BI desktop based on measure and dimension requested by customer and dashboard needs

Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc. to SQL Server using SSIS/DTS using various features like data conversion etc.

Created report models and deployed on report server.

Integrated backend services using REST API's (web API) with identity Database.

Designed and implemented several complex reports and administration modules

Created Reports with latest features provided by SSRS like dynamic navigation, hyperlinks, different set of graphs in tabular format etc.

Designed SSAS cube to hold summary data for Target dashboards. Developed Cube with Star Schema. Experience in creating OLAP cubes, OLTP, identifying dimensions, attributes, hierarchies and calculating measures and dimensions using SQL Server Analysis Services (SSAS).

Expertise in OLAP and OLTP and Data warehouse Concepts.

Environment: T-SQL, MSSQL Server 2012/2008/2005, Visual Studio 2008/2005. BI tools –Reporting Services (SSRS 2000/2005/2008), Business Intelligence Development Studio (BIDS), Power Pivot,Crystal Reports, Office 2007, MS Access, Tableau, ETL, MS Excel, REST APIs, Powershell, TFS (Team Foundation Server 2010), SQL Server Integration Services (SSIS), Azure Data Lake Source Control, Red Gate tool,OLAP,OLTP etc.

CareFirst BCBS, Baltimore,MD Oct’ 2015 –Aug’ 2016

SQL BI Developer (SSIS/SSRS)

Responsibilities:

Designed, deployed, and maintained various SSRS Reports in SQL Server 2005

Created Sub-Reports, ad-hoc reports, Drilldown-Reports, Summary reports, and Cross Tab reports

Actively participated in gathering Business Requirements that are focused on providing a user friendly System usage or ambience

Created ETL metadata reports using SSRS, reports include like execution times for the SSIS packages, Failure reports with error description

Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.

Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.

Developed and published reports and dashboards using Power BI and written effective DAX formulas /expressions.

Used Power BI Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports.

Dealt with the Customer Registration module, ticket search, ticket booking, Home page configuration.

Imported data from various sources like csv, excel and directquery to sql server/analysis database and used good visualizations and industry standards for creating Power BI reports and dashboards. And implemented Row-level security (RLS).

Using IBM Cognos engine to write complex queries and report to business units.

Used different Control Flow Tasks and Data flow Task for Creating SSIS Packages. Used different types of Transformations for Data Conversion, Sorting and cleaning the data from different Sources into Company Format

Creating active directory groups, importing them to Tableau server, syncing the groups on daily basis.

Configuring Power BI Gateway for SSAS Live connection.

Used Power BI Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports

Created SSIS packages to download data from FTP sites and populating into different databases and tables.

Created SSIS packages to import data from MS Access, Excel to SQL 2008R2.

Designed various screens required for the ticket information and bookings.

Optimized the query performance with modification in T-SQL queries, removing unnecessary columns, eliminating redundant and inconsistent data.

Effectively created and used views in SQL Server to prevent unauthorized access

Performed tuning of databases by normalizing database, establishing necessary joins, creating useful clustered index and non-clustered indexes.

Developed and created the new database objects including tables, views, indexes, stored procedures and functions, advanced queries and also updated statistics using Query Analyzer

Worked on complex data loading (implemented the batch data cleansing and data loading

Meeting with Business Analyst and data modelling team to understand requirements and existing

Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard

Data conversion from Text File into SQL Server Table and Database recovery and database maintenance plan

Assisted in designing and implementing database logical and physical schemas and document the testing and maintenance of system corrections

Environment: SQL Server 2008R2, SQL Services Integration Services 2008R2, Visual Studio, T-SQL, XML, MS SQL Reporting Services 2008R2, Power BI, SQL Profiler, MS Office, DB2, Windows Server 2008.

Digital Webber, Hyderabad, India Jan’ 2014 – Dec’2014

SQL SSIS SSRS Developer

Responsibilities

Involved in system analysis & design of the Enterprise data warehouse implementation, Requirements gathering and understanding the business flow.

Designed the Functional Requirements and Mapping Technical Specifications on the basis of Functional Requirements.

Creating Index, Views, Complex Stored Procedures, Triggers, Cursors and appropriate User defined functions to implement the business logic.

Creation of database tables and procedures to update and clean the old data.

Transferred data from flat files, Excel spreadsheets, and XML Source data to SQL Server using SSIS and also used BCP and Bulk Insert.

Designed dashboards, including scorecards and reporting with the Dashboard Designer delivered via MOSS (Microsoft Office SharePoint Server).

Involved in data modeling for the application and created ER diagram using Erwin.

Created, Maintained & scheduled various reports in SSRS like Ad-hoc Reports, Canned Reports, and Master Reports & Parameterized Reports, Drill Down Report, Drill Through Report usingSQL Server Reporting Services SSIS 2005.

Proficient on and designing Data Mart and Data Warehouse using Erwin in Star and Snowflake Schemas.

Helped Database administrators with powershell in building robust administration scripts.

Responsible for support of MOLAP structures using Analysis Services 2005 and reporting structures in MS EXCEL and Reporting Services 2005.

Designed and Maintained SSIS Packages for Importing and Exporting Data Migration and Conversion from Legacy Systems to SQL Server 2005.

Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.

Created document for Self-Service Deployment and Execution process for SSIS packages

Interacting with the users and troubleshooting the problems involved with the development of stored Procedures, triggers and problems related to the privileges.

Responsible to tune ETL procedures and schemas to optimize load and query Performance.

Environment: Microsoft SQL Server 2005, MS Access, SSIS, SSRS, Query Analyzer, ERWIN, Windows server 2003, DTS, T-SQL, SQL Profiler, DTS

Contact this candidate