SUMMARY

• MS BI Developer and Data Engineer with more than 7 years of experience in Database Design and Business Intelligence Development.
• Has a great knowledge in building high performance data integration and workflow solutions, including extraction, transformation, and loading (ETL) operations for data warehousing and support of OLAP/OLTP/Data warehouse systems, Reporting and Presentation using BI applications Outgoing and articulate communicator who gets along well with clients and coworkers at all levels.
• Highly motivated, well - organized, responsible, and productive team member with excellent analytical mind, quickly reacting and determining the given role and deliver results.
• Expertise in T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Power BI with good knowledge on SQL Server Analysis Services (SSAS) & Azure cloud resources.
• Strong skills in creating and managing Databases, and various database objects like Tables, Views, Indexed Views, Complex Parametrized Stored Procedures, DDL/DML Triggers, Cursors, User Defined Data Types, User Defined Functions and Indexes (clustered, non-clustered, filtered, covering, with included columns, column stored) using T-SQL.
• Experience in Performance Tuning and Optimization using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor, Query Execution Plans and Performance Analyzer.
• Hands on experience in High Level Design of ETL DTS/SSIS packages and ADF pipelines for integrating data using OLE DB connection from heterogeneous sources like (CRM, ERP, API, RDBMS, Excel, CSV, SAS, Oracle, Flat File, Text Format Data) by using multiple transformations such as Data Conversion, Conditional Split, Bulk Insert, Derived Column, Merge and Union All to bring data into a standard, final format that it needs to be in order to be compatible with the final destination database/data warehouse.
• Experience in implementing various SSIS features like Event Handling, Precedence Constraints, Breakpoints, Checkpoints, and Logging for Complex SSIS Packages.
• Strong knowledge of Entity-Relationship concept, Facts and Dimension tables, slowly changing dimensions (SCD) and Dimensional Modeling (Star and Snow Flake Schemas).
• Skillful in report development using SSRS/Power BI and creating various types of reports and dashboards with drill down/through, parameterized, cascading, conditional, slice and dice, bookmark, ad-hoc and sub reports features.
• High-level experience in writing DAX in Power BI and Expert in fine tuning the reports;
• Experience in supporting Microsoft Azure systems including SQL Server hosted on Azure Virtual Machine (IaaS) and Azure SQL Databases (DBaaS).
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflakes Modeling, fact and dimension tables, Pivot Tables, modeling of data at all the three levels: view, logical & physical.

PROFESSIONAL EXPERIENCE

Senior BI Developer

Confidential, Philadelphia, PA

Responsibilities:

• Attended daily scrum meetings, discussed new requested features/user-stories/tasks with Business Analysts and updated the status of tasks assigned on Agile Platform.
• Actively participated in migration of on-premise SQL Server schemas to cloud on Azure SQL Server DB and Azure VM and developed and maintained databases across both on-premise and cloud deployments.
• Built efficient ETL packages, using both SSIS and Azure Data Factory ADF2 pipelines for processing Fact and Dimension tables with complex transforms and SCD type 1/ type 2 changes.
• Created complex stored procedures, triggers, functions (UDF), indexes, tables, views to support the project.
• 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.
• Did various performance tuning techniques by using parameterized queries, Indexing, SQL server profiler, query optimization, IO stats, database engine tuning advisor, execution plans etc.
• Staged data from various sources for future use in building warehouse Dims and Facts.
• Scheduled ETL Packages to routinely deliver data into staging table and prepare the data before loading into Data warehouse.
• Created SQL Server jobs and scheduled them to load data over nightly using SQL server Agent.
• 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.
• Excellent knowledge in Azure SQL stack architecture (SQL Server, Synapse and Azure Data factory). Configured Azure platform for data pipelines, ADF, Azure Blob Storage and data lakes. Build workflows to automate data flow using ADF.
• Did SQL performance monitoring and tuning of reporting data by optimizing indexes and stored procedures. Created and Implemented triggers in T-SQL to facilitate consistent data entry into the database.
• Designed Power BI reports on account information, research reports using ad-hoc reporting to be used by clients and advisors. Created reports on both cascading and standard parameters.
• Built reports for different domains such as Finance, Accounting, Management, and other client teams.
• Designed, developed, maintained and delivered additional new Power BI Dashboards and Reports with complex DAX query measures/columns, drill down/drill through/hyperlink options, dynamic slicing/dicing features.
• Involved in applying Row-Level-Securities in all Power BI Reports, scheduled and monitored data source refreshes accordingly, and created measures and calculated column into reports using DAX.

BI Developer

Confidential, Tampa, FL

Responsibilities:

• Worked independently and as part of a team to accomplish critical business objectives and to make decisions under pressure.
• Project includes analysis of complex business requirements, creating and modifying complex stored procedures also worked on performance tuning.
• Largely used T-SQL in supporting Finance Team and constructing User Profiles, Relational Database Models, Data Dictionaries and Data Integrity.
• Created complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application.
• Created the optimal logics to load the data that business rules were based on flat file names or ragged hierarchy.
• Developed slowly changing dimension SCD-Type 0, 1, 2 in SSIS to update the old data in dimension tables when the new source data is loaded. Also automated the process by deploying the packages into SQL server and creating jobs in SQL Server Agent.
• Worked directly with Solution Analysts and Technical Architects to translate business requirements into conceptual and logical data models.
• Created packages using SSIS to extract the data from different flat files (.txt, .csv, .xlsx) and loaded to tables in SQL Server.
• To Import and Export Data across various files and databases created ETL packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Union all and Derived Column and etc.
• Participate in creating calculated members, named set, advanced KPI’S for the SSAS cubes.
• Converted old ETL packages to the new version (did optimization by applying more stored procedures instead of using control flow tasks).
• Design, develop, and support complex integration processes (including interfaces) using SQL Server technology, stored procedures and SQL program code.
• Involved in organizing conceptual data model, logical data model, physical data model, data mapping and data normalization.
• Performance Tuning of Stored Procedures and SQL queries using SQL Profiler and Index Tuning Wizard in SSIS.
• Designed the Data warehouse and done the mappings from Source to the Target tables.
• Did various complex Stored Procedures/execute task, wrote C# hard codes in script task for ETLs, updated/maintained the ETL packages with high performance.
• Created stored procedure using nodes method to load XML file data into SQL server tables. Experienced solving issues raised by QA, UA for database.
• Created interactive, accurate, insightful, and well-organized Power BI reports/dashboards to support businesses in their data driven strategic planning.
• Developed filters, reports, dashboards and also created chart types, visualizations and complex calculations to manipulate the data in Power BI.
• Used various formatting techniques like interactive sorting, grouping to create user friendly reports.

SQL/BI Developer

Confidential, Philadelphia, PA

Responsibilities:

• Interacted with business users and team leads for better understanding of business specifications and requirements, identifying data sources and Development strategies.
• Configured, fine-tuned and optimized T- SQL. Was responsible for performing basic developer task like creating, altering, and updating tables. Developed simple stored procedures, queries, views, joins and indexes by using T-SQL.
• Normalized the tables and maintained Integrity by using Primary and Foreign Keys.
• Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages.
• Created, maintained, and updated ETL packages loading both OLTP and OLAP database tables.
• Tuned the performance of SQL queries and Stored procedures using SQL Profiler. Involved in database and log backups & restoration, backup strategies, scheduling.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load. Created packages in SSIS with error handling and worked with different methods of logging in SSIS.
• Acquired data from primary or secondary data sources and maintain databases/data systems.
• Identified, analyzed, and interpreted trends or patterns in complex data sets.
• Worked closely with management to prioritize business and information needs.
• Located and define new process improvement opportunities.
• Involved in dimensional Modeling of Data Warehouse using Erwin tool.
• Performed debugging and troubleshooting the technical issues while implementing the applications.
• Created SSRS and Power BI reports sourcing from SSAS’s Multidimensional OLAP and Tabular model cubes with MDX and DAX. Developed and Maintained Crystal Reports.
• Worked with building the complex Ad Hoc, Standard Reports using SSRS and worked with tuning the large complex reports on SQL Server Database.
• Created linked, drill through, drill down, cashed, snapshot and sub reports using Report Server Project & Report Model Template in SSRS and was responsible for deploying them.
• Coded T-SQL stored procedures for SSRS reports and deployed the reports for account managers to access via web browser.

SQL/ETL Developer

Confidential, Bloomington, IL

Responsibilities:

• As a key member of BI team, accomplished successful outcomes by working with SQL, SSIS and SSRS.
• Developed ETL solutions for integrating data from multiple sources like Flat Files (delimited, fixed width), Excel, SQL Server, Raw File, DB2, Oracle, and SAP into the data warehouse.
• Performed SSIS Development and support, developed ETL solutions for integrating data from multiple sources like Flat Files (delimited, fixed width), Excel, SQL Server, Raw File, and DB2 into the data warehouse.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• 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.
• Built efficient SSIS packages for processing Fact and Dimension tables with complex transforms and type 1/ type 2 changes.
• Created Stored Procedures for commonly used complex queries involving join and union of multiple tables.
• Created database objects like tables, users, roles, stored procedures, triggers.
• Normalized the tables and maintained Integrity by using Primary and Foreign Keys.
• Created Views to enforce security and data customization.
• Administered the maintenance and movement of more than 200 files through clearinghouse and direct connection.
• Converted old ETL packages to the new version (did optimization by applying more stored procedures instead of using control flow tasks).
• Worked with the team/architect to create logical/physical modeling and created Cubes (fact, dimensions, and calculations)
• Worked on various DAX expressions in Power Pivot based on the business requirement.
• Worked and updated to improve complex issues like Error Handling in SSIS for handling Delta load changes.
• Filtered and cleansed data, and reviewed computer reports, printouts, and performance indicators to locate and correct code problems.
• Hands on Creating Parameterized reports, Cross-Tab reports, drill down reports, Dashboard and Summary reports by using SSRS.
• Designed high level ETL architecture for overall data transfer from the OLTP to Data warehouse with SSIS and prepared ETL mapping processes.
• Created local variables and global variables package configurations and error handling.
• Performed debugging, data analysis, and system analysis as required.