SUMMARY

• Over 5+ years of IT experience in T - SQL, SSIS, SSRS, Power BI.
• Worked with Business Owners and Stakeholders to gather requirements for the report and implement those in Power BI and build visuals which shows meaning full insights to the Business.
• Used to Build Power BI reports and publish them to Workspace in Power BI Service and share the reports and Dashboards as App to the end users.
• Experience in Migration SSRS to PowerBI Reports using RDL Migration Tool and developing reports from scratch to meet new business requirements.
• Experience ini Azure Data Factory to load data from Data Lake to Azure SQL Data warehouse
• Experience in Data Modeling, ETL (Extract, Transform and Load), Database Design, Development and Reporting.
• Expert in developing T-SQL (DDL,DML) statements, Data Integrity (constraints), Rules and Validation issues.
• Knowledge in ER Modeling and Dimensional Modeling (Star and Snowflake Schema) building Dimension and Fact tables
• Experience in Database Development, System Analysis, Design, implementation and support of MS SQL Server 2
• Expertise in Azure cloud data migration from various sources.
• Used Azure Runbooks, Azure automation account, Azure Functions to process the tabular models in Azure Analysis Services
• Developing ETL packages using SSIS to extract & load from Source into Azure SQL Server.
• Experience in building pipelines, datasets and creating connections, triggers in Azure SQL Data warehouse.
• Did a POC on Big Data Analysis using Azure Databricks,Azure Syanpse.
• Solid knowledge of Relational Database Management System (RDMS), Data Warehouse Concepts, OLTP and OLAP experience with experience on SSIS,, SSRS, Data Analysis, Data Cleansing/Data Scrubbing and Data Migration
• Performed Test and Deploy code across various SDLC Environments.
• Responsibilities also included creating architecture diagrams, data flows and data models identifying the data to migrate by developing database models
• Involved in loading the partner flat files into the OLTP database.
• Good knowledge and exposure to Database Mirroring, Replication, Log shipping, backup and restore procedures and disaster recovery.
• Developed Scorecards/Reports for the system using SSRS, Power BI.

TECHNICAL SKILLS

Programming Languages: T-SQL, PL/SQL, C#, VB Scripting, DAX

Database: Confidential 10g/11g, TSQL, MS SQL Server 2014//2016

Operating Systems: Confidential Windows, Linux, Windows Server 2012 R2

Methods: Agile, Waterfall, Scrum, UML, Ralph Kimball and Bill Inmon approaches

Database Tools: MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), Power BI, SQL Server Management Studio, SSAS, Azure Data Factory, Azure Data Lake Analytics, Azure Data bricks,Azuree Synapse analytics.

Other: Team Foundation Server, MS Office 2013

PROFESSIONAL EXPERIENCE

Confidential, Pittsburgh, PA

SQL Business Intelligence Developer

Responsibilities:

• Experience in unstructured data into Azure Datalake optimize the clusteres using AzureDataBricks with insights using Azure Synapse Analytics to Integrate reports into PowerBI.
• Experience in Data Ingestion to one or more Azure Services - ( Azure Data Lake, Azure Storage, Azure SQL, Azure DW ) and processing the data in Azure Databricks .
• Created Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform and load data from different sources like Azure SQL, Blob storage, Azure SQL Data warehouse.
• Created SSIS package to load data from XML Files and implementation of data viewers, SSIS Logging, error configurations for error handling the packages, OLTP system to a Data Warehouse for analyzing data.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults user defined data types and functions
• Created schema objects like tables, views and indexes.
• Worked on Deployment of packages into Production servers and managed scheduled SQL jobs
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities
• Experience in Performance Tuning and Query Optimization.
• Experience in creating and managing fragmentation of Indexes to achieve better query performance.
• Managed index, statistics and optimizing queries by using execution plan.
• Responsible for creating and Maintenance of SQL Server Agent jobs in production and Job Monitoring and making sure all jobs run successfully every night .
• Importing data to PowerBI from various sources.
• Created various dashboards in PowerBI desktop using table, matrix, bar, card, gauge, and slicer visualizations.
• Expertise in writing complex DAX functions in Power BI and Power Pivot.
• Responsible for creating some of the Power BI reports based on the user requirements.
• Extract dataset from different data source including SQL Server, excel and flat file prepare datasets for Power BI.
• Developed and maintained multiple Power BI dashboards/reports and content packs.
• Used Power BI Gateways to keep the dashboards and reports up to date.

Confidential, Dallas, TX

ETL Developer

Responsibilities:

• Interacted with technical team and Business users to perform analysis of business requirements and transformed them into technical requirements for ETL and Reporting needs
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS)
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults user defined data types and functions
• Worked on Deployment of packages into Production servers and managed scheduled SQL jobs
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers
• Used Configuration Files in SSIS to ease the process of moving the packages across servers.
• Designed tabular, matrix reports, drill down, drill through, Parameterized and linked reports in SQL Server Reporting Services (SSRS)
• Experience in SQL joins, sub queries, tracing, indexing strategies and query/index tuning and performance tuning for better running of queries.
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler and SQL Analyzer.

Confidential, Boston, MA

SQL BI Developer

Responsibilities:

• Develop and deploy SSIS packages, configuration files, and schedules job to run the packages to generate data in CSV files.
• Create and manage Reports subscriptions and schedules SSRS reports
• Troubleshooting reports issues, ETL job failures, optimizing query performances.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities
• Wrote T-SQL queries with the help of Stored Procedures, Functions, Triggers, Cursors, Views, and Indexes.
• Created jobs to run effectively and send the wast data to several server FTP and SFTP sites
• Configuration and Deployment of all the Reports (RDL, RDS) across various environments
• Created SSIS process design architecting the flow of data from various sources to target.
• Extensively imported data from various sources such as MS Excel and MS Access using Import Export Wizard and also using SSIS, MDS.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Created several reports using SSRS and MDS like parameterized report, drill through reports, linked and sub reports
• Deployed SSRS reports to the reporting server and assisted in troubleshooting deployment problems.
• Developed impactful reports using SSRS, MS Excel and Pivot tables to solve the business requirements
• Used Indexing strategies and query optimization techniques to optimize Stored Procedures and long running queries.