SUMMARY:

• Highly motivated MSBI Developer with over 6+ Years of IT Experience in Database and Business Intelligence Technologies (TSQL, SSIS, ADF v2, SSRS, Power BI, SSAS). Leveraging the power SQL Server, Azure cloud services and Power BI business intelligence/analytics platform, delivered actionable insights and modern - data visualization solutions to various business stakeholders.
• Hands on Experience in optimizing the queries by creating various clustered, non-clustered indexes and indexed views.
• Proficient in creating objects such as Stored Procedures, Views, Triggers, User defined functions, cursors, derived tables, common table expressions (CTEs) and Complex Queries on Microsoft SQL Server .
• Strong analytical knowledge coupled with excellent communication and interpersonal skills. Proficient in developing clear and concise documentation of all work performed.
• Worked well independently and on a team to solve problems.
• Served as a friendly, hardworking, and punctual employee. Organized and prioritized work to complete assignments in a timely, efficient manner.
• Responded to problems with excellent troubleshooting abilities. Consistently exhibited loyalty and passion for success. Helped the Business Analysis team in preparing documentation such as data mapping files and data analysis forms.
• Excellent knowledge in creating databases, tables, writing complex T-SQL codes, Stored Procedures, Functions, Indexes (clustered, non-clustered, column stored), CTE's, Views, Joins and DDL/DML Triggers
• Expert in Performance Tuning/query optimization and troubleshooting of complex T-SQL Stored Procedure and slow running queries.
• Always keeping up to date with new Microsoft tools such as SQL Server 2019, Power BI, Azure and etc.
• Excellent understanding of design goals of ER Modeling for OLTP and dimensional modeling for OLAP and Data Warehouse Systems
• Knowledge in developing visual reports, dashboards and KPI’s (ADR, REVPAR, AAR, OCC, LOS, ARI etc.) by using both Power BI desktop and Power BI Services platforms and in uploading them into Report Server and Cloud Services with establishing necessary row level security settings. Hands on experience in writing complex DAX for tabular cubes and MDX queries for Multidimensional cubes in Power BI desktop
• Applied row level securities in all Power BI reports and assigned Active Directory AAD Groups, scheduled and monitored data sources to be refreshed accordingly, Row Level Security RLS data security techniques.
• Experience in both on-prem and cloud solutions. Extensive experience with Microsoft Azure ecosystem such as: Power Bi Service, ADF2, Azure SQL Server, Azure SQL IAAS/SAAS/PAAS, Azure SQL DW, Azure Blob, Datal Lakes, Azure Synapse, Databricks, Azure Analysis, AKV Management.
• Hands-on AWS cloud solutions such as AWS RDS SQL server, MySQL, Amazon Redshift, AWS EC2, AWS S3 buckets, etc.
• Experience in implementing various SSIS features like Event Handling, Precedence Constraints, Breakpoints, Checkpoints, and Logging for Complex SSIS Packages
• Experience in various kinds of SSIS Deployments like File Based Deployment, and SQL Server Deployment
• Solid understanding in maintenance and administration of SSIS packages by creating SQL Agent Jobs, Alerts, Mail Notifications, and schedule DTS/SSIS Packages by SQL Agent, Windows Scheduler, and other third-party tools.
• Experience with Lift & Shift of SSIS packages into Microsoft Azure using Azure Data Factory (ADF2) to create ADF pipelines with Copy Data and Data Flow Activities. Hands-on experience with ADF linked services, Integration Runtime, Tumbling Window Triggers and debugging ELTs using ADF Monitors.
• Strong skills on deploy and operate large scale cloud infrastructure and application services in global data centers on Amazon Web Services (AWS), Microsoft Azure and other Cloud providers.
• Hands on experience in designing and creating Star and Snowflake Schemas for Data Warehouse systems for various data domains such as healthcare/finance/hr/acouting/manufacturing/ecommerce/supply-chain.

TECHNICAL SKILLS:

Cloud: Azure, Power BI, AWS

Databases: SQL Server, Oracle, MySQL, Azure SQL.

DevOps Tools: Azure DevOps, JIRA, GITHUB, Microsoft TFS.

ETL & Reporting: SQL Server Integration Services, Azure DataBricksAzure Data Factory (ADF), Azure Cosmos DB

SQL Server Analysis Services (SSAS), Informatica: Power BI Desktop, Power BI Services, Tableau, SQL Server Reporting Services (SSRS), Crystal Reports SAP Business Objects, Crystal Reports XI, DataStage

Programming languages: T-SQL, Oracle, MySQL, C++, Python, JavaScript, Power, Scala, Shell, DAX, C#, NET Framework, HTML.

Microsoft Products: Microsoft Outlook, Excel, Word, PowerPoint and Access.

WORK EXPERIENCE:

BI Developer

Confidential

Responsibilities:

• Wrote T-SQL scripts to validate and correct inconsistent data in the staging database before loading data into database. Converted various SQL statements into Stored Procedures theirby reducing the Number of database accesses (since Stored Procedures passes the whole block at one time).
• Performed tune to optimize SQL queries using SQL profiler and query analyzer. Involved in performance tuning of the database and T-SQL queries using Explain Plan. Created Indexes, Constraints and Rules on database objects.
• Created and modified Clustered and Non-Clustered Indexes to optimize the queries using Index Tuning Wizard. Designed and developed MS SQL Server Stored Procedures using T-SQL statements from scratch. Developed Triggers on Views to populate base tables.
• Rigorously tested and debugged the Stored Procedures and used Triggers to test the validity of the data after the insert, update or delete.
• Created Jobs dat called Stored Procedure dat automatically populated tables with Proc Date column. dis allowed us to use Merge Replication when we needed to transfer data to History Database.
• Create stored procedures and user defines functions to supports efficient data storage and manipulation. Handling database objects with Enterprise Manager. Provided Technical Documentation for future enhancements.
• Gatheird, analyzed, and documented the business requirements and business rules by directly working with end users/clients. Created and maintained documents like Documentation Roadmap, DATA Models, ETL Execution Plan, Configuration Management Procedures, and Project Plan.
• Created database applications utilizing multitier ideas with the utilization of SQL statement and Store Procedure to fetch, update, and control databases on SQL Server 2012 and Oracle 11g.
• Expert at checking, rebuilding, and reorganizing internal and external fragmentation in SQL.
• Structured and created plenty of SSIS packages using Data Flow Task, Execute SQL Task, Script Task for ETL projects.
• Designed several For Loop containers, Foreach Loop, and Sequence containers in SSIS.
• Profound knowledge in understanding ERDs and Database Models.
• Skilled in using Synchronous (Data Conversion and Derived Column, Multicast, Row count, etc.) and Asynchronous transformation (including Sort, Fuzzy Lookup, etc.) to perform various transformations to SSIS package.
• Utilized complex UDF, Store Procedure, Views, and Triggers for solving different business requirements.
• Used DML triggers (such as after/instead of Update, Delete, and Insert) to maintain the referential integrity of data.
• Assisted Data Architects in building data warehouse entities like fact tables, dimensions dat are involved in Snowflake Schemas.
• Used Breakpoint and Checkpoints to debug/troubleshoot the package while loading into the data warehouse.
• Performed continuously incremental loads to load data OLTP environment to OLAP environment.
• Built many OLAP cubes in SSAS.
• Created perspectives for Finance, Operational Management, Accounting, Sales departments using OLAP cubes.
• Wrote complex DAX queries in SSAS to generate computed columns according to business requirements before pushing it to GitHub.
• Deployed many SSIS packages into the SSIS catalog. Scheduled several jobs to run SSIS packages into the SSIS catalog.
• Experience in both on-prem and cloud solutions. Extensive experience with Microsoft Azure ecosystem such as: Power Bi Service, ADF2, Azure SQL Server, Azure SQL IAAS/SAAS/PAAS, Azure SQL DW, Azure Blob, Datal Lakes, Azure Synapse, Databricks, Azure Analysis, Cosmos DB, Poly-Base, AKV Management
• Also, hands-on experience with AWS cloud solutions such as AWS RDS SQL server, MySQL, Amazon Redshift, AWS EC2, AWS S3 buckets.
• Created Azure Data Factory (ADF v2) ELT structure dataflow pipelines utilizing Copy data, Data Flows, Databricks, Scheduled / Tumbling Window and Event based triggers, linked servers, Azure Key Vaults
• Worked with all departments such as management, hiring, accounting, dispatching, maintenance, and safety teams to implement row-level security and policies.
• Hands-on experience in creating summary reports and ad-hoc reports using SQL Server Reporting Services.
• Created reports using Power BI Desktop and deployed to Power BI Service to share with end users via Workspaces and Apps which implemented Row Level Security and User Group management.
• Deployed a lot of custom PowerBI, SSRS and Tableau reports, parameterized reports, drill down and drill through reports, as well as, created numerous subscriptions for Management.

SQL BI Developer/SSRS/SSIS

Confidential

Responsibilities:

• Communicated Data team project status information to team members and analyst team to understand / analyze the requirements of business need and achieved the successful results.
• Developed complex T-SQL Stored Procedures, UDFs, CTEs, Indexed Views, and Staging Tables to process the data and populate them into the appropriate destination tables.
• Worked on Report generation using SQL Server Reporting Services (SSRS) dat could be used to send information to Compliance Group, Order Flow management (OFO) Group, Network Planning Group, TN Management Group etc.
• Performed reverse engineering of physical data models from databases and SQL scripts.
• Optimized queries, improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures, and performing other maintenance tasks. Tuned and improved application by finding optimal solutions for slow running queries and procedures using SQL profiler and performance monitor.
• Created SSIS Packages using such tasks on control flow as Execute SQL task, Execute Package Task, Bulk Insert task etc. On Data flow level extracted data from different sources like ODBC, OLE DB, Excel, Flat file, XML File and etc. Used transformations as Aggregate, Derived Columns, Condition Split, Merge, Union all and etc. to generate data for the reports and to export cleaned data to data warehouse.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Extensively created, worked, managed OLAP cubes using SSAS and in adding calculations using MDX.
• Created Incremental Load ETL packages using Look up transformation, Merge statement, CDC Control task etc. Built efficient SSIS packages for processing Fact and Dimension tables with complex transforms and type 1/ type 2 changes;
• Created dynamic SSIS Packages to transfer data between servers, load data into database and tuned the existing packages. Worked on Error handling by using checkpoints, configure error outputs and president constraints and event handlers.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server. Integrated ASP.Net pages with SQL server Database. Designing and building data load procedures using MS SQL Server.
• Generated Sales Ranking reports using SQL Server Reporting Services for different subjects. Documented all the procedures and processes for future s.

SQL BI (SSIS/SSRS/Power BI) Developer

Confidential

Responsibilities:

• Utilized SSIS and extracting, transforming and loading (ETL) tool of SQL Server to populate data from different data sources, making packages for various data loading tasks for application,enhancing existing ETLs and creating some new ETL procedures;
• Expanded SSIS functionality having designed custom SSIS elements for SharePoint;
• Using SSIS, extracted, transformed and loaded SharePoint Lists and Surveys Data into SQL Server Database;
• Deployed SSIS packages through the package Bids Deployment, installation wizard, Management Studio Import for automatization of data processes;
• Generated SSRS and Power BI reports getting source from SSAS’s Multidimensional OLAP and Tabular model cubes with DAX and MDX;
• Built performance tuning of SQL queries and stored procedures using Index Tuning Wizard and SQL Profiler;
• Worked extensively on system analysis, design, development, testing and implementation of projects;
• Automated Data by using SSIS to automate data processes for input of information;
• Configured SSIS packages with XML configuration file, Registry entry, Parent package variables and SQL Server tables;
• Generated sophisticated Stored Procedures, Tables, Triggers, SQL Joins, Views and other statements to support referential integrity and implement complex business logic;
• Improved the performance of packages by updating statistics and restructuring the indexes to perform the server efficiency in SQL Server 2014/2017;
• Participated in creating the Relational Database design. Composed T-SQL queries to halp different transactions;
• Created data-driven workflows for controlling data movement and transforming data at scale with the halp of Azure Data Factory.

BI Developer

Confidential, San Antonio, TX

Responsibilities:

• Developed SSIS packages for loading data using Shell Scripting and BCP;Created Complex ETL Packages using SSIS for extraction, cleaning, transformation and loading data from staging tables to partitioned tables with incremental load;
• Developed, deployed, and monitored SSIS Packages with different workflow / data flow components such as Execute SQL Task, Script Tasks, Lookups, File System Tasks, FTP Tasks, Merge Joins, Azure Blob Sources and Send Mail Tasks;
• Performed Data Cleaning and Quality Check using Lookups and Fuzzy lookup;
• Implemented data validation using T-SQL queries in order to make sure reports in SSRS are returning correct result set;
• Created and maintained complex T-SQL queries, Stored Procedures and Views using SQL commands such as Lead, Lag, CTEs, Recursive CTEs Bulk Insert and Merge;
• Developed data warehouse process models, such as sourcing, loading, transformation, and extraction of data (from Oracle, excel files and flat files);
• Monitored SSIS packages execution and sent notifications through SQL Mail for Success/Fail confirmation;
• Developed SQL Scripts on Oracle linked server (OPENQUERY) to validate the data at destination after it was loaded from source Oracle database;
• Used Data Transforms, Lookups, Merge, Joins, Aggregate, Sort, Filter and Remove duplicates extensively to Clean/Transform the data extracted from multiple sources into staging database;
• Created, modified and tested PL/SQL stored procedures in oracle.
• Worked with client’s business exports in order to prepare source to target data mapping documents for the data migration project;
• Performed Data Modeling and Designed the Data warehouse (Star and Snowflake);
• Performed Data Mappings from different Sources to the Staging and then Destination tables;
• Developed complex T-SQL queries and Stored Procedures using Merge, Joins, Window Functions such as Lead and Lag and Bulk insert;
• Scheduled SSIS Packages execution using SQL Server Job on Daily, Weekly, and Monthly basis;
• Deployed SSIS packages to different Environments (Development, User Acceptance Testing, and Production) using Deployment Utility;
• Monitored and managed SSIS package security, execution, deployment and configuration using different methods (SQL Server table, XML file and Parent-Child);
• Created SSRS reports and deployed them in SharePoint;
• Developed SSIS Packages to Extract data from Multiple Flat Files, Multiple Sheets in Excel Files and Archiving them;
• Developed reports using Drill through, Drop Down and Hyperlinks to move to other reports and web pages using Microsoft SQL Server Reporting Services (SSRS);
• Developed interactive reports and dashboards using Power BI;
• Created dashboards using Power BI desktop (using M Query Advanced Dax), deployed them into Power BI Services;
• Worked on various DAX expressions in Power Pivot based on the business requirement.