SUMMARY

• 8+ years of professional experience in development, implementation and administration of database systems using MS - SQL Server 2016/2014/2008 R2/2008 for both OLTP & Data Warehousing Systems applications.
• Experienced in Software Development Life Cycle (SDLC) processes including Analysis, Design, Programming, Testing and Documentation.
• Well-developed skills in SQL Server Integration Services 2005/2008/2012 for data extraction, transformation and loading using different heterogeneous source systems like flat files, Excel, SQL Server.
• Strong knowledge of Data Warehousing methodologies and concepts including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.
• Adept in RDBMS concepts and constructs along with Objects creation such as Database, Table, Normalization, UDF, User Defined Data Type, Indexes, Stored Procedures, Views, Cursors and Triggers.
• Experienced in using SSIS, SSAS & SSRS for various BI requirements.
• Extensive experience with various data processing platforms and languages including Oracle PL/SQL, SQL Server T-SQL, MySQL and PostgreSQL.
• Experienced in Data Extraction, Transforming and Loading (ETL) using DTS package in MS SQL Server and SQL Server Integration Services (SSIS) in MS SQL Server with .NET, Import/Export data, Bulk insert and BCP.
• Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, flat files using connectors, tasks and transformations provided by SSIS.
• Experienced in SSIS script transformations and scheduling complex SSIS Packages for transferring data automatically from multiple data sources to SQL server.
• Experienced in creating jobs, Alerts and scheduling the SSIS Packages using SQL Agent.
• Extensive experience with SQL and SQL scripting for relational databases such as Oracle and PostgreSQL.
• Expert in Database Normalization, Optimization, Tuning, Backup/Restore, Data Import/Export, Troubleshooting and Database Objects authorization.
• Strong experience in creating various reports like Drill Down, Drill through and Ad-hoc according to the user requirement using SQL Server Reporting Services (SSRS).
• Experienced in building Tabular Model Cube from Scratch in Databases with different Measures and Dimensions.
• Possess detailed knowledge of aggregation using OLAP analysis services cube.
• Strong development skills with Azure Data Lake, Azure Data Factory, SQL Data Warehouse Azure Blob, Azure Storage Explorer.
• Extensive experience in implementing Copy activity, Custom Azure Data Factory Pipeline Activities for On-cloud ETL processing.
• Experience in implement ETL and data movement solutions using Azure Data Factory (ADF), SSIS.
• Experience in Azure SQL Data warehouse by following all the best Practices like Group Inserts, Poly Base to load, Hash Distribute tables, Minimizing transaction size etc.
• Extensive experience in Design and Develop ETL Processes data from external sources like Azure blob Storage, Azure Data Lake Gen2 and ORC/Parquet/Text Files into Azure SQL Data Warehouse (Azure Synapse).
• Extensive experience using Azure Key vault to Encrypt keys and Password.
• Experience creating scheduling and monitoring Spark Jobs in Azure Data Bricks.
• Experienced in developing Logical and Physical data models using data modeling tools such as Erwin and MS Visio.
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports and MS Excel spreadsheets.
• Create Power BI dashboard reports as per the business requirements from the legacy reports.
• Monitor and maintain SQL jobs and Power BI reports for data accuracy and worked on performance improvement of the reports.
• Developed dashboards and key Performance Indicators (KPI) with SQL Server Reporting Services (SSRS) and Power BI.
• Worked on Power BI and prepared dashboards using Tableau to make it more attractive.
• Used Microsoft Power BI Power Query to extract data from external sources.
• Worked extensively on Data visualization and Data analyzation using Power BI.
• Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.
• Knowledge of developing cubes in SSAS and Analyzing Dimensions and Measures.
• Worked on SharePoint development and scheduling reports using it.
• Expertise in Power BI, Power BI Pro, Power BI Mobile.
• Expert in creating and developing Power BI Dashboards into rich look.
• Knowledge of Power BI Desktop & report performance optimization.
• Expert in automation of creating jobs, error reporting using Alerts, SQL Mail Agent.
• Experience in Interacting with Business users to analyze the business process and transforming requirements into screens, performing ETL, documenting and rolling out.
• Ability to quickly adapt to new environment and work with variety of people at various levels.
• Ability to work in environments with fluctuating priorities and deadlines, foresight to handle upcoming issues and dedication to solve complex problems with experience and research.
• Excellent communication skills, bridging Client Interaction and Team player.
• Organized professional with excellent oral and written communication skills, excellent presentation and interpersonal skills, problem solving skills, and a fast learner who also adapts quickly to new technologies with the ability to take new roles in minimum time with little training.

TECHNICAL SKILLS

RDBMS/DBMS: MS SQL Server 2016/2014/2012/2008 R 2/2008/2005/2000 , MySQL, Oracle 11g/10g/9i/8i, and MS Access 2003/2000/97

Database Technologies/Tools: SQL Server Entreprise Manager, Microsoft Management Console, SQL, T-SQL, Data Transformation Services (DTS), OLTP, BCP, SSIS, OLAP. Microsoft Visio, ER Studio

Databases: Azure SQL Database, Azure data warehouse, Azure Data azure data factory, Azure Data Synch, MS SQL Server 2008 R2, 2012, 2014,2016, MySQL and Oracle12c.

Azure Cloud: Azure SQL Database, Azure Data Lake, Azure Data Factory (ADF), Azure SQL Data Warehouse, Azure Service Bus, Azure Analysis Service (AAS), Azure Blob Storage. Cache using Pipeline and SSIS, Data Migration Service (DMS), Azure SQL Data.

Reporting Tools: Power BI, SQL Server Reporting Services, Crystal Reports, Excel.

Operating Systems: Windows XP, 2000, NT, 98, 95, Windows 2003, Windows Vista, Windows 7

Programming Languages: T-SQL, PL/SQL, HTML, C#.Net, VB.Net, C++, Java, Java script, CSS, Windows Scripts

Design Technologies/Tools: Erwin, MS Visio, Rational Rose

Data Warehouse / Business Intelligence Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Visual Studio 2016/2014/2013/2010/2008 , SSAS, Business Intelligence Development Studio (BIDS) 2008, MS Data Tools 2012 / Visual Studio Shell

PROFESSIONAL EXPERIENCE

Confidential - Tampa, FL

Sr. Power BI Developer / MSBI Developer

Responsibilities:

• Extensively involved in Development, Implementation and Reporting in MS SQL Server 2016/ 2014/2012/2008 R2/2008 with Business Intelligence in SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
• Proficient in Creating, Configuring and Fine-tuning SSIS packages, SSRS reports and T-SQL queries using tools like SQL Profiler, Performance Monitor and Database Engine Tuning advisor.
• Involved in Database Administration operations like Backup, Recovery, Replication and using SQL Profiler and excellent knowledge of DDL and DML in T-SQL.
• Responsible for creating reports such as Cascading, Drill down/Drill through Reports, Conditional, Table, Matrix, Charts, Ad-hoc Specialized in using Relational data warehouse and OLAP Cubes for producing Sub Reports.
• Involved in generating Drill through and Drill down reports with Drop down menu option, sorting the data, defining subtotals in SSRS.
• Worked extensively on Data visualization and Data analyzation using Power BI
• Designing and Developing the Dashboard Reports in Power BI using DAX.
• Developing the reports using Power BI, Power Pivot and SSRS.
• Implementing Drill Through & Hyperlinks in Power BI report.
• Developed and maintained multiple Power BI dashboards/reports and content packs.
• Responsible for building Power BI Dashboards 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.
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel and created SSIS packages to load excel sheets from PC to database.
• Responsible for identifying, designing and implementing processes related to predictive / analytical modeling, data mining and complex data sets using statistical and text mining using python scripts.
• Worked on Power BI and prepared dashboards using Tableau to make it more attractive.
• Installed On premise data gateway and scheduled daily data refresh in Power BI.
• Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.
• Wrote and modified various Stored Procedures used in the application using T-SQL.
• Extensive experience in different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports.
• Performed DAX (Data Analysis Expressions) & MDX functions for the creation of calculations and measures in the Tabular Mode & multi-dimensional Cubes.
• Built a Tabular Model cube from scratch data and by MDX and DAX queries fetched data to SSRS and Power BI reports.
• Writing MDX queries to get the data from a tabular model.
• Create PowerPivot models and PowerPivot reports, publish reports onto SharePoint, and deploy models into SQL Server SSAS instance. Create Parameterized SSRS Reports and PowerPivot Workbooks using data of Tabular model and Cube data model to prove the functionality of database.
• Implemented Copy activity, Custom Azure Data Factory Pipeline Activities
• Primarily involved in Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory, SSIS, PowerShell.
• Designed and Developed ETL Frame that extract, transform, Audit and load data in Azure SQL Datawarehouse.
• Performed database backup and deployment to the production server.
• Extensively involved in Designing and Developing ETL Processes data from external sources like Azure blob Storage, Azure Data lake Gen2 and ORC/Parquet/Text Files into Azure SQL Data Warehouse (Azure Synapse).
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data marts.
• Created SSIS packages using .NET and C# as a custom code in Script task.
• Added new business logic, fixed defects using C#, and used TFS to check in those changes.
• Implemented multiple connection managers to connect to different data sources using C#.Net/script components.
• Generating SSRS reports using drill down, drill through and other functionalities.
• Developed reports with charts, matrixes, and sub report. Deployed reports on web server for user viewing.
• Involved in unit testing against the developed packages and reports.
• Deployed and scheduled Report subscriptions using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Performed unit and system testing, troubleshooting and bug fixing in Prod and QA environments.
• Optimized the performance of reports by using various techniques like optimizing datasets, making use of less number of input parameters along with caching and taking snapshot of reports.
• Implemented security on reports at Server Level, Report Level and Item Level according to the hierarchy in the organization and business requirement.
• Performed configuration and deployment of various reports using SQL Server Reporting Services (SSRS) on the report server.
• Extensively involved in deploying SSIS Packages, SSRS Reports and SSAS Cubes using command line utilities.
• Extensively involved in Data Warehouse Star Schema Modeling, Snow-Flake Modeling, FACT& Dimension Tables, Physical and Logical Data Modeling.

Environment: MS SQL Server 2016/2014/2008 , SSIS/SSAS/SSRS, T-SQL, Visual Studio 2014/2013/2012 , C#, SQL Server Profiler, Azure Cloud, Azure SQL Database, Azure Data lake, Azure Blob, Power BI, Power Query, Power Pivot, Power Designer, Tabular Models, SQL Server Management Studio, Team Foundation Server (TFS), Business Intelligence Development Studio (BIDS), Business Objects, Jasper Soft Studio.

Confidential - Dallas, TX

Sr. Power BI Developer / Sr. MSBI Developer

Responsibilities:

• Responsible for Deploying the SSIS packages and scheduling the package, setting the Configuration files which is done in the specified tables and created technical specs documents for all the enhancements.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Imported data from text files and excel spread sheets into SQL Server 2008 using SSIS package.
• Worked with T-SQL to create Tables, Views, Triggers and Stored Procedures.
• Used Script task for Data Flow and Error Handling in SSIS.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Created/Updated database objects like tables, views and stored procedures
• Involved in creating views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Generated Drill down, Drill through, Ad-hoc, Matrix Reports, parameterized reports using SSRS.
• Converted existing multidimensional cubes to tabular model, recreated all existing measures using DAX and release to azure cloud analysis service.
• Design and Develop ETL SSIS packages for Loading data from azure data warehouse to SQL server data mart.
• Developed multiple complex ETL pipelines and activities stores for full and incremental data loads into a Azure SQL DW.
• Utilized Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper level management.
• Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.
• Designed complex data intensive reports in Power BI utilizing various graph features such as gauge, funnel, line better business analysis.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.
• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
• Built a Tabular Model cube from scratch data.
• Built Measures in tabular model using DAX queries and created partitions in tabular model.
• Designed and developed monthly, quarterly and yearly reports.
• Involved in table and index partitioning for performance and Manageability.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Monitored the overall performance of the database to recommend and initiate actions to improve/optimize Performance.
• Used SQL Server Profiler to trace the slow running queries and the server activity.
• Automated and enhanced daily administrative tasks including database backup and recovery.
• Involved in setting up SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.

Environment: Microsoft SQL Server 2016/2014/2008 , T-SQL, SSIS, SSRS, Power BI, Power Pivot, SSAS, Azure Cloud, Azure SQL Database, Azure Data Lake, Erwin, Windows server 2008, Microsoft Office Share Point Server, Visual Source Safe, SQL Profiler, Business Intelligence Development Studio, Visual Studio 2014/2013/2012 .

Confidential - Rochester, MN

SQL Server BI Developer (SSIS/SSAS/SSRS/Power BI Developer)

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC).
• Identified and prioritized requirements from stakeholders through brainstorming, documented and developed an ongoing process of gaining consensus into the requirements process.
• Defined and documented problem definition, scope and project objectives by collaborating with stakeholders.
• Involved in Planning, Defining and Designing data base using Erwin on business requirement and provided documentation.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2008 and Flat files.
• Involved in daily loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2008.
• Designed and developed ETL packages using SQL Server Integration Services (SSIS) to load the data from SQL server, XML files to SQL Server database through custom C# script tasks.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers, and Fuzzy Lookups etc.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Created SSIS packages for Data Conversion using data conversion transformation.
• Configured the loading of data into slowly changing dimensions using slowly Changing Dimension Wizard. Also implemented checksum SCD method to load the data into date warehouse.
• Developed complex SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs
• Involved in building Data Marts and multi-dimensional models like Star Schema and Snowflake Schema. Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Enhancing and deploying the SSIS packages from development server to production server.
• Designed and built OLAP cubes to meet reporting needs.
• Performed Documentation for all kinds of reports and DTS and SSIS packages.
• •Designed Cubes with Star Schema using SQL Server Analysis Services 2008 (SSAS), created several Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server 2005 Analysis Services (SSAS).
• Understanding OLAP process for changing and maintaining the Warehouse, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Created Packages in SSIS with error handling.
• Provide input in implementing, maintaining change control and testing processes for modifications to databases.
• Used various ETL tools like SSIS/DTS for data flow from source files like XML, Excel, Tables and views to other databases or files with proper mapping.
• Data reporting experience with Crystal Reports, SSRS.
• Create, or support creation of required reports in response to business user needs.
• Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.
• Utilized Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper level management.
• Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.
• Designed complex data intensive reports in Power BI utilizing various graph features such as gauge, funnel, line better business analysis.
• Developed Tabular model and generates Power BI dash boards on top of that.
• Worked on R programming to create custom visual in Power BI.
• Perform database coding and security reviews.
• Created Time Dimensions on OLAP Cubes using SSAS.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2005 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Involved in preparing test cases for SQL Server 2008 BI Database Testing.
• Extensively used T-SQL in constructing User defined Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
• Prepared Test plans for DW Database Testing.
• Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Data development experience with SQL Server Integration Services
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Created complex SSIS packages using proper Control and Data flow elements.
• Used System Tables, System Stored Procedure, DBCC commands for Database maintenance.
• Migrated DTS packages from SQL Server 2005 to SQL Server 2008 as SSIS Packages.

Environment: MS SQL Server 2014/2012/2008/2005 , Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS 2014), SQL Server Analysis Services (SSAS 2014), SQL Server Reporting Services (SSRS 2014), Power BI, Power Pivot, Windows 2010, MS Excel, SQL Server Profiler.

Confidential - Austin, TX

MSBI Developer (SSIS/SSRS/Power BI Developer)

Responsibilities:

• Designed and developed packages for Data warehouse using Integration Services (SSIS) SQL Server 2014.
• Created Packages which includes Control flow tasks, Data flow tasks, Event Handlers, Breakpoints and Checkpoints in SSIS.
• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuring of SSIS packages.
• Developed SQL Scripts to dynamically manipulate data and generate well-formatted reports based on user requirements.
• Good understanding of Data Marts, Data warehousing, Operational Data Store (ODS) and OLAP.
• Automate the generation of various dynamic reports on a daily and weekly basis.
• Optimize SQL 2014 stored procedures for enhanced performance and robustness.
• Worked with T-SQL to create Tables, Views, Stored Procedures, CTE and Temp tables.
• Responsible for testing and debugging the SQL Scripts.
• Efficiently identified business user needs. Created complex Stored Procedures, DTS packages, triggers, cursors, tables, views and SQL joins and statements for applications.
• Experienced in developing T-SQL (DDL, DML) statements using dynamically generated SQL.
• Generated reports using SSRS 2014 as per business requirements.
• Expertise in writing complex DAX functions in Power BI and Power Pivot.
• Automated Power Query refresh using power shell script and windows task scheduler.
• Installed and configured Enterprise gateway and Personal gateway in Power bi service.
• Created Workspace and content packs for business users to view the developed reports.
• Scheduled Automatic refresh and scheduling refresh in power bi service.
• Wrote calculated columns, Measures query’s in power bi desktop to show good data analysis techniques.
• Managed and monitored the system utilization by using the query optimizer and checking the execution plan.
• Created packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split, Execute SQL Task) and more.
• Used Breakpoints & Event Handlers to debug packages & capture errors.
• Designed SSIS Packages to transfer data from various sources like Text Files, SQL Server, Excel and Access to SQL Server using Business Intelligence Development Studio.
• Closely worked with DBA’s and Business Needs team for deploying the packages.
• Used Merge statement to update rows, to insert new rows, and to delete invalid rows in destination table.
• Loaded Fact/Dimension Tables using Lookups, and Conditional Splits.
• Developed objects (i.e. tables, views and stored procedures, functions, indexes) in SQL Server 2014 to get a better and faster performance.
• Optimized long running Stored Procedures and Queries for effective data retrieval.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases.

Environment: Microsoft SQL Server 2014/2012, Visual Studio 2013/2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Power BI, Power Pivot.

Confidential

MSBI Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Prepared the complete data mapping for all the migrated jobs using SSIS
• Responsible for creating and designing SSIS package
• Designed Extraction Transformation and Loading (ETL) process using SSIS to extract data from flat files, excel files and SQL server database
• Based on business requirement, developed the Complex SQL queries with Joins and T-SQL, Stored procedure, Views, Trigger to implementing the business rules and transformations
• Use different control flow control like for each loop container, sequence container, execute SQL task, send email task
• Use package configuration to migrate SSIS package from one environment to other.
• Use event handing to send e-mail on error events at the time of transformation
• Use login feature for analysis purpose
• Added intelligent system in SSIS to identify actual change and new change in dimension
• Involved in gathering business requirements and development of data modelling to facilitate business and operational needs.
• Database and Log Backup, Restoration, Backup Strategies, Scheduling Backups.
• Improved the performance of the SQL server queries using query plan, covering index, indexed views and by rebuilding and reorganizing the indexes.
• Perform tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Defined Indexes, Views, Constraints and Triggers to implement business rules.
• Involved in Writing Complex T-SQL Queries.
• Backing up master & system databases and restoring them.
• Developed Stored Procedures and Functions to implement necessary business logic for interface and reports.
• Involved in testing and debugging stored procedures.
• Designed, built and tested SSAS Cubes on SQL Server.
• Created Excel workbooks to enable Cube (SSAS) access for business users.
• Process the cubes (SSAS), partitions as and when required.
• Writing the DAX statements for Cube

Environment: MS SQL Server 2012/2008R2/2008, SSIS, SSAS, TFS, Windows 2003/2008, Deployment Wizard, Visual Studio 2010, Business Intelligence Development Studio (BIDS), SQL Server Profiler, MS Excel 2007, Tableau, C#, ASP .Net