SUMMARY

• 11 years of Experience as SQL Server Developer and Business Intelligence in designing and developing BI applications with SQL Server, MS BI Stack (SSIS, SSRS, SSAS), Power BI, and Tableau. Strong information technology professional with a master’s degree focused on Managing Information Technology from Sullivan University.
• Good understanding of (SDLC) software development life cycle methodologies such as Agile, SCRUM, and waterfall models.
• Good understanding of database and data warehousing concepts (OLTP & OLAP).
• Experienced in creating Tables, Views, Indexes and other SQL joins and query writing.
• Experienced in Installing, Upgrading, and Configuring Microsoft SQL Server and Databases, creating and using Stored Procedures, User Defined Functions, Triggers, Sub - Queries and Joins for complex queries involving multiple tables and Exception Handlers.
• Expert Knowledge of Integration Services (SSIS), Reporting Services (SSRS), Analysis Services, and Power BI.
• Experience in building SSIS packages (.DTSX) involving ETL process, extracting data from Excel files, flat files, legacy systems, and loading into SQL server.
• ETL transformation of OLTP data to the Data Warehouse implementing all transformations using SSIS and SQL commands.
• Expertise in designing Data Flow tasks and Work Flow task on SSIS and creating Dynamic packages for Incremental Loads.
• Experience in enhancing and deploying the SSIS Packages from the development server to the production server by using package configurations.
• Experience in developing User reports, management reports, and dashboards using Power BI, Tableau, and MS SQL Server Reporting Services (SSRS).
• Excellent Report creation skills in developing reports like Tabular Reports, Matrix Reports, Charts, and Custom Reports, using Report Designer in SQL Server Reporting Services in Business Intelligent Development Studio (BIDS).
• Experience in building Power BI reports, KPI scorecards, Dashboards, and Modeling.
• Consumed data from a variety of data sources (SQL Databases, XML, JSON, Web APIs, Salesforce, etc.) and performed required transformations in the Power BI query editor.
• Utilized the navigation features in Power BI (e.g., bookmarks, drill-through) to guide readers through a compelling data-driven story.
• Published reports via the Power BI service, managing them through the distribution of apps and monitoring usage/data refreshes/security access.
• Experience in creating Alteryx workflow and using various transformations for reporting.
• Designed and developed Tableau visualization solutions using Tableau Desktop.
• Created action filters, parameters, and calculated sets, Hierarchy for preparing dashboards and worksheets in Tableau.
• Published customized interactive reports and dashboards, and report scheduling using the Tableau server.
• Excellent communication and interpersonal skills and strong ability and experience in seeking solutions effectively and aggressively in challenging environments.

TECHNICAL SKILLS

Databases: SQL Server 2008R 2/2012/2014/2016/2017 , Microsoft SQL Azure, MS Access, DB2, Teradata, Oracle

Database Tools: SQL Server Management Studio, Business Intelligence Development Studio, Database Tuning Advisor, SQL Profiler, Enterprise Manager, Query Analyzer.

ETL Tools: SSIS 2008/2012/2014/2015/2017 , DTS, BCP (Bulk Copy Program), Alteryx

Reporting Tools: SSRS, Power BI, Tableau v10.3/10.4, Crystal Reports

OLAP Tools: SQL Server Analysis Services 2008/2012, Snowflake

Programming Languages: SQL, T-SQL(SSMS), PL/SQL, C#, SAS, and VB Script

Data Modeling: MS Visio

Operating Systems: Windows

Source Control: TFS 2015

PROFESSIONAL EXPERIENCE

Confidential, Dover, DE

Sr. BI/Datawarehouse Developer

Responsibilities:

• Actively interacted with end-user to gather business requirements, system specifications, and enhancements.
• Performed system study and requirements analysis, prepared Data Flow Diagrams, Entity Relationship Diagrams, Data Diagrams, and Table Structures.
• Designed, implemented, and Supported Business intelligence systems for Elections Department.
• Designed and Developed complex SSIS packages for performing ETL processes using SQL Server Integration Services.
• Developed mappings to load Fact and Dimension tables, Slowly Changing Dimension (SCD) techniques and Incremental loading and unit tested the mappings.
• Implemented modularity and parallel execution with parent-child package utilizing execute package task in SSIS for Datawarehouse load.
• Created a Data Mart with Snowflake schema from an existing data warehouse.
• Extensively worked in the performance tuning of T-SQL, ETL, and other processes to optimize session performance
• Worked on SSIS logging, Error Handling, and Package configurations.
• Deployed SSIS packages to stage and production using environmental variables and created SQL server agent jobs for scheduling.
• Imported data from SQL Server Database, Azure SQL Database, and other resources to Power BI to generate reports.
• Implemented Power BI integration with ServiceNow API.
• Registered Power BI Report as an Application in Azure Active Directory and Secure Embed Power BI report to Elections Delaware website.
• Published Power BI Reports in the required originations and made Power BI Dashboards available in Web clients and mobile apps.
• Created DAX Queries to generate computed columns in Power BI.
• Implemented Row-Level Security (RLS), Restricting Sharing and Publishing, Restricting Export.
• Installed and Configured Enterprise Gateway and Personal Gateway in Power BI Services.
• Responsible for Power BI Administration like creating workspaces, granting permissions to users, Power BI admin portal, and monitoring usage metric reports.

Environment: MS SQL Server 2017, Visual Studio, SQL Server Data Tools (SSMS, SSIS, SSRS), Power BI Desktop, Power BI Online, ServiceNow, and TFS.

Confidential, Conshohocken, PA

BI/Datawarehouse Developer

Responsibilities:

• Involved in all phases of SDLC from requirement, design, development, testing, and support for the production environment.
• Full lifecycle exposure to Data Warehouse projects and Data marts with Star and Snowflake Schemas.
• Designed and developed Extract Database architecture using Azure SQL Database.
• Built numerous complex SSIS packages to pull data from different sources (SQL Server, CSV, Flat Files, XML) and loaded it into Datawarehouse by using SSIS.
• Used ETL to implement the SCD (slowly changing Dimension) transformation to maintain historical data in the data warehouse.
• Configured the SSIS Package for run time Parameters and Configuration file.
• Developed the Generic ETL that calls child SSIS objects, to be used for multiple clients.
• Implemented the Business rules and Extracted the data from various sources such as SQL Server, SharePoint, and FTP site and loaded the required data into Extract database and Flat files as per the specifications.
• Formulated complex SQL queries, derived tables, CTEs, stored procedures, views, and User Defined Functions (UDF).
• Analyzed issues with SSIS packages utilizing loggings, data viewers, and breakpoints.
• Involved in Power BI modeling and relationships.
• Created reports, visualizations, and dashboards in Power BI as per the client’s requirements. Proficient in making DAX queries in Power BI desktop.
• Involved in publishing and scheduling Power BI reports as per the business requirements.
• Delivered on-demand and scheduled reports for business analyses in Power BI and SSRS.
• Involved in Data profiling technique used to examine the source data
• Responsible for Unit Testing, Integration Testing, and helped with User Acceptance Testing.

Environment: MS SQL Azure, MS SQL Server 2016, Visual Studio, SQL Server Data Tools (SSMS, SSIS, SSRS), Power BI Desktop, Power BI Online, JIRA, and TFS.

Confidential, Phoenix, AZ

BI Developer/Data Analyst

Responsibilities:

• Involved in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure, and maintain data efficiently.
• Extensively worked with SSIS tool, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast, and Derived Column.
• Designed dynamic SSIS to transfer data crossing different platforms, validated data during transferring, and archived data files for different RDBMS.
• Developed SSIS Templates that can be used to develop SSIS Packages in such a way that they can be dynamically deployed into Dev, Test, and Production Environments.
• Expertise knowledge on variables to make package dynamic and scheduled the package using SQL Server Agent as per the business requirement.
• Implemented the BI Database in SQL Server for reporting and created Fact & Dimensional tables and data is populated using SSIS ETL from different sources like DB2, SharePoint, and CSV files.
• Wrote Stored Procedures, Views, and User Define scalar Functions (UDFs) to be used in the SSIS packages and in Tableau reports.
• Involved in Migrating the MS Access Reports to Tableau reports using Tableau Desktop.
• Extensively used Tableau Business Intelligence/Business Analytics software for development.
• Created ad-hoc reports to users in Tableau by connecting various data sources.
• Generated Dashboards with Quick filters, Parameters, and sets to handle views more efficiently.
• Published Workbooks by creating user filters so that only appropriate teams can view them.
• Creating Extracts and scheduling them to increase the performance of the Tableau dashboards and views.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Used Execution Plan, and SQL Server Profiler to trace the slow-running queries and tried to Optimize SQL queries for improved performance and availability.

Environment: SQL Server 2012/2014, SQL Server Business Intelligence Development Studio (SSIS, SSRS, Tableau 10.3/10.4, Power BI), MS-ACCESS, and TFS 2015.

Confidential, Tampa FL

SQL BI Developer

Responsibilities:

• Involved in Requirement Analysis, Providing Estimation and preparing the Technical design documents for SSIS Packages and SSRS Reports, and Power BI dashboards.
• Understanding the Business requirements, designing of SSIS packages, SSRS, Power BI reports, and as per Ad-hoc Business Requirements.
• Development of Queries, Functions, Procedures for Reports, and ETL.
• Involved in the enhancement of SSAS cubes.
• Unit testing of the reports after the code fix and troubleshooting the issues and resolving them on time.
• Working on Critical SLA Bound Reliability & Critical tickets and providing support during QA/UAT.
• Scheduling of SSIS packages, SSRS reports SSAS cubes via SQL Server Agent and TIDAL jobs.
• Performed roles of Data Analyst with the Data profiling tasks for validation of Reports.
• Code/ETL production deployment preparations including the Implementation plans and executions.

Environment: SQL Server 2012/2014, SQL Server Business Intelligence Development Studio (SSIS, SSRS, SSAS, Power BI), Teradata, and JIRA.

Confidential, Deerfield IL

SQL BI Developer

Responsibilities:

• Involved in understanding business requirements and designing a solution for it.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user-defined data types, and user-defined functions in SQL Server.
• Modified existing stored procedures, and functions using joins following SQL Standards to enhance the performance of the reports.
• Analyzed execution plan and optimized some complex queries by creating indexes and using some SQL best practices.
• Worked with various upstream and downstream systems and customers in interfacing various systems for data extractions, ETL, Analytics, and Reporting needs.
• Created SSIS Packages using Pivot Transformation, Execute SQL Task, Data Flow task, etc. to import the data into Datawarehouse.
• Developed SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts
• Implemented Logging and Error Handling in SSIS packages
• Responsible for Deploying the SSIS packages and scheduling the package through Jobs in all Tiers including Dev, UAT, and Prod, Setting the Configuration files which is done in the specified tables.
• Written Detail design documentation to describe program development, logic, coding, testing, changes, and corrections.
• Designed different type of SSRS reports including Tabular forms, Matrix (cross Tab report) form, List items, Charts, and Linked reports.
• Designed SSRS reports using table filters, single value parameters, multi-value parameters, and Cascading Parameters.
• Created Sub-Reports, Drilldown-Reports, and Cross Tab report using MS SQL Reporting Services (SSRS).
• Involved in migrating SSRS RDLs from 2008R2 to 2012 server.
• Involved in the Development & Deployment of SSAS Cubes and Monitor Full and Incremental loads and supporting any issues.
• Provide QA analysis and support to Data Processing and Analysis team.
• Analyze samples of client data for quality before and after processing, checking data cleanliness and ensuring the ability to use data in existing processes.
• Assists Data Processing and Analysis Team in constructing data cleaning, loading, and distribution requirements as well as building processes to transfer and integrate new data development projects into the existing maintenance project schedule.

Environment: SQL Server 2008 R2/2012, SQL Server Business Intelligence Development Studio (SSIS, SSRS, SSAS), SQL Profile and TFS 2014.