SUMMARY

• Around 7 years of extensive IT experience in Database Design, Development, Test and Production environments and hands on working knowledge in various domains of IT industry as MS SQL Server/BI/SSIS/SSRS/SSAS/MSBI Developer.
• Having 2+ years of Power BI development skill set including visualization development, use of parameters, and report optimization
• Proficient in design and development of various dashboards, reports utilizingTableau VisualizationslikeDual Axis,Bar Graphs,Scatter Plots, Pie - Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualizationand other making use ofactions,otherlocal and global filtersaccording to the end user requirement.
• Explore data in a variety of ways and across multiple visualizations using Power BI.
• Experience in creating and implementinginteractive charts, graphs, and otheruser interface elements.
• Worked on writing the API’s in Python.
• Vast experience in extracting, transforming and loading (ETL) data from OLTP (transactional) databases and other data sources, including heterogeneous and homogeneous sources into Data Warehouse, in SSIS using various tasks and transformations.
• Expert on creating multiple kinds ofPowerBIReports and Dashboards.
• Worked in dimensional modeling with Star & Snowflake schemas and created the Data Source Views (DSV) and SSAS Cubes using the identified Fact and Dimensional Tables.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
• Strong experience in Data warehouse concepts, ETL.
• Very Good Understanding and Experience in SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS)
• Experience in creating and managing fragmentation of Indexes to achieve better query performance. That increases my ability in Performance Tuning, Query Optimization.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Strong development skills withAzure Data Lake,Azure Data Factory, SQL Data Warehouse Azure Blob, Azure Storage Explorer
• Experience managingBig Dataplatform deployed inAzure Cloud
• Implemented Copy activity, CustomAzure Data FactoryPipeline Activities for On-cloud ETL processing.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart, Ad hoc and Sub Reports.
• Highly skilled in creating dynamic and customized packages for ETL from various data sources using SSIS.
• Experienced in performing Incremental Loads and Data cleaning in SSIS. Expert in handling errors, logging using Event Handlers using SSIS.
• Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL
• Expert in defining and deploying Cubes using SQL Server Analysis Services (SSAS).
• Good Knowledge about Extracting, Transforming and Loading (ETL) data using Import/Export Wizard and SSIS.
• Excellent communication skills, analytical skills, understanding business requirements in various domains.

TECHNICAL SKILLS

RDBMS/DBMS: MS SQL Server 2019/2016/2014/2012/2008 R2/2008, MySQL, Oracle 11g/10g, MS Access

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, Azure SQL Database, Azure data warehouse, Azure Data factory

Reporting Tools: Power BI Desktop 2.6, Power BI Service, Power BI Gateway, Power BI Report Server, SQL Server Reporting Services, Crystal Reports, Tableau, Excel.

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

Programming Languages: C, C++, SQL, PL/SQL, T-SQL

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 2013/2010/2008 , SSAS, Business Intelligence Development Studio (BIDS) 2008, MS Data Tools 2012 / Visual Studio Shell, Star Schema, Snowflake schema, Facts and Dimensions tables

ETL Tools: DTS, SSIS, Data Stage

PROFESSIONAL EXPERIENCE

Confidential, Schaumburg, IL

Power BI Developer / MS Azure

Responsibilities:

• Participated in the team business requirements gathering and analyze, understand and convert them into database solutions with solid exposure to architecture, analysis, design, testing, development, deployment, documentation & implementation.
• Import data from different data sources to create Power BI reports and Dashboards.
• Experience in developing Reports, Charts, Dashboards using Power BI Desktop and manage security based on requirements
• Transform, define, navigate the data from data source and performed merge and append queries using Power Query.
• Implemented complex query techniques of passing Multi-Valued parameters and cascading parameters in MDX.
• Performed different types of context like Row context, filter context and query context using Power BI Desktop
• Performed transformations like Pivoting, Unpivoting and Splitting of the columns using Power Query.
• Performed Query Folding using Power Query to filter data in the data source server.
• Created different chart types and drill down reports using Power Bi Desktop (SSRS).
• Involved in defining report layout in SSRS.
• Created complex SSAS cubes with multiple fact measure groups and multiple dimensions hierarchies in SQL server
• Created measures, calculated columns, relationships and performed time series analysis using DAX in Power BI
• Published reports and visualizations to Power BI Service and thereby created dashboards.
• Created hierarchies in Power BI reports using visualizations like Bar chart, Line chart, etc.
• Worked with both live and import data into Power BI for creating reports.
• Managed huge volume of data by creating weekly partitions in SSAS models.
• Used different type of slicers available in Power BI for creating reports.
• Experienced in creating many dashboards by pinning many visualizations in the workspace as per the insights provided.
• Experienced in Data Modeling used to define and analyze data requirements needed to support the business processes within the scope of corresponding information systems in organizations.
• Used Power BI Gateways to keep the dashboards and reports up to date.
• Experience in developing several Details, Summary reports including line and pie charts, trend analysis reports and sub-reports per business requirements.
• Experience in generating on-demand and scheduled reports for business analysis or management decision.
• Used recently introduced Power BI to create self-service BI capabilities and use tabular models.
• Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.
• Shared the created workspace across the organization using Power BI Apps.
• Responsible for creating Row-Level Security (RLS) based on the business requirements.
• Created complex stored procedures and scripts in SQL Server
• 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, Power Shell
• Created C# applications to load data from Azure storage blob to Azure SQL, to load from web API to Azure SQL and scheduled web jobs for daily loads
• Design, Develop, test, and deploy ELT/ETL pipelines using Azure Data Factory.
• Implemented Copy activity, Data flow, triggers in Azure Data Factory Pipeline Activities.
• Developed multiple complex ETL pipelines and activities stores for full and incremental data loads into a Azure SQL DW.

Environment:, MS SQL Server 2012/2, Windows 8/10, Team Foundation, SSIS, SSRS, SSAS, Altrex Designer, Azure SQL, Azure Storage Explorer, Azure Blob, Power BI desktop, Power BI Services, Power BI, DAX, Power BI Gateway, Power Query, Power Pivot, MS Excel.

Confidential, Plano, TX

BI / ETL Developer

Responsibilities:

• Collaborated with Technical Architect to design the Data Warehouse to house data from various data sources and ERPs.
• Created SSIS packages for data extraction from various sources such as Flat Files, oracle provider and IBM provider to SQL Server.
• Designed various staging databases in order to extract and load the data from various sources optimally.
• Involved in creation/review of functional requirement specifications and supporting documents for business systems.
• Performed database design and data modeling.
• Worked on creating packages such as hubs and satellites for the Data Warehouse
• The packages created included a variety of transformations, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
• Used ETL to implement the Type 2 Update, to maintain Historical Data in Data warehouse.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Developed Charts and other visualization using Power View. Filter and Sorting Data using Power View in Excel 2013.
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Successfully deployed SSIS (ETL) packages and scheduled jobs.
• Modified SQL queries according to the business requirements to load the attributes in Data Warehouse.
• Responsible for rebuilding the indexes and tables as part of performance tuning.
• Used SQL Server Agent for scheduling jobs and alerts.
• Remotely interfaced with various team members and functional teams during various stages.

Environment: MS SQL Server 2014/2016, SSRS 2012, SSIS 2012, ETL, DB2, Oracle 11g, TFS, Visual Studio 2013, XML, XSLT, MS Office, Visual source safe.

Confidential, Bloomington, IL.

Power BI - Visualization / Dashboard Developer

Responsibilities:

• Responsible for gathering/refining requirements from the customer for developing reports in Power BI.
• Built Data Analytics or visualization using Power BI (Power View integrated with Share Point).
• Worked with DAX/MDX queries in building expressions for various business calculations.
• Building, publishing customized interactive reports and dashboards, report scheduling using Power BI service.
• Involved in Developing Power BI visualizations and dashboards using Power BI Desktop.
• Created Grouping, sorting columns and writing expressions according to the business requirements.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Involved in creating MDX, DAX, Cubes and Tabular models using SQL Analysis Services (SSAS). Used different types of visualization (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer etc.) in Power BI according to the requirements.
• Implemented metrics, filters, reports, dashboards and created advanced chart types, using calculations to manipulate the data and enable user driven parameters for visualizations and drilled down level of detail using sets.
• Transferred the data using SSIS packages.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Lookup.
• Used SSIS to create ETL packages to validate, extract, transform and load data to Data Warehouse databases.
• Created SSIS packages to Export data from text file to SQL Server Database.
• Created SQL Server Reports and developed query for generating drill down and drill through reports using SSRS.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Identified and worked with Parameters for parameterized reports in SSRS.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Generating Ad-Hoc reports on a timely basis and also to fulfill immediate requirements.
• Used star and snowflake schema in designing cubes for creating SSAS packages.

Environment: MS SQL Server 2012/2014/2016 , Power BI, MS Office Suite, PL/SQL, MS Excel, SQL Server Management Studio (SSMS), Visual Studio, SSAS Tabular Cubes, T- SQL, Excel, DAX, and SSIS.

Confidential, Confidential, WI.

SQL Server / SSRS Developer

Responsibilities:

• Generated Drill down, Drill through, Matrix Reports, and Parameterized reports using expressions to calculate, group, filter, and parameterize report using SSRS
• Developed functions, triggers, stored procedures, views, tables, and SQL scripts to meet the requirements of the business users and application development.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Developed Strored Procedures for the DataSet to build the reports for the client requirements.
• Created SQL Joins, sub-queries and other SQL code to implement business rules.
• Performance tuning, and optimization of procedures and queries.
• Used DBCC commands for Database maintenance (Rebuilding Indexes).
• Installation and configuration of SQL Server 2008 R2
• Designed and developed SSIS Packages (.dtsx files)to import and export data from MS Excel, SQL Server 2008 and Flat files.
• SSIS packages to update tables with monthly data and automated it through scheduled jobs for the beginning of every month.
• Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008 R2.
• Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate and Derived Column.
• Developed packages in SSIS with error handling.
• Created Package Configurations to deploy packages from development to production server.
• Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using BCP in staging database from MS Access, excel.
• Involved in creating report models and applying row level security filters for report model.
• Experienced in participating meetings with business users to gather the requirements.
• Involved in the analysis of existing database structures and creating the new tables and views as per the requirements.
• Worked with development teams in the design of physical databases and in modification.

Environment: MS SQL Server 2012/2014/2016 , SQL Server Integration services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS),T-SQL, Microsoft Office, OLAP, Oracle 10g, ASP.Net, VB.net, MS Visio.

Confidential, Roseland, NJ

MS SQL Server Developer (SSIS/SSRS)

Responsibilities:

• Worked closely with business users to congregate and comprehend requirements.
• Preparation of documentationfor all the requirements and enhancements to reports.
• Design and develop SSIS packages, Store Procedures, configuration files, tables, views, functions and to implement best practices to maintain optimal performance.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms.
• Developed SSIS Templates, which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Created SSIS packages to copy tables, schemas and views and to extract data from Excel and Oracle.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Built and maintained T-SQL scripts, indexes, and complex queries for data analysis and extraction.
• Wrote T-SQL queries to validate the error reports being given to the client and prepared T-SQL scripts for the Application team, Reports team during development
• Created T-SQL scripts, which generated tables, relationships, based on the finalized ER-diagram
• Perform T-SQL tuning and optimizing queries for Reports which take longer time in execution SQL Server 2008R2
• Physical Implementation of database into SQL Server 2012 using T-SQL.
• Designing, Creating & maintenance of ReportsinSSRS.
• Created, maintained & scheduled various reports in SSRS like Ad-hoc Reports, Canned Reports, Master Reports & Parameterized Reports using SQL Server Reporting Services SSRS.
• Created different chart reports helped in analyzing perform counters using SSRS.
• Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Interacted with customers to analyze business needs. Provide software product design and developed technical roadmap for the solution through the project lifecycle and beyond.
• Determined the SQL Server Installation. Installed SQL Server Management tools using SQL Server Setup Program.
• Tested the Installation of SQL Server.
• Logical Data Modeling using ER-Win to fit business requirement.
• Implemented Triggers for checking complex business conditions, providing security for the tables.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server.
• Created check constraints to maintain data integrity.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Created Business-Crucial stored procedures and functions to support efficient data storage and manipulation.
• Worked on DTS Package, DTS Import/Export for transferring data from heterogeneous database.
• Data migration (import & export/BCP) from different sources to SQL Server.
• Coordinating post-implementation events such as testing.

Environment: MS SQL Server 2012/2014/2016 , SSIS, SSRS, SSAS, DTS, VSS, VBScript, XHTML, XML, MS Access, Windows Server, IIS5.0, 6.0, 7.0.

Confidential

MS SQL DBA/Developer

Responsibilities:

• Worked with Business Analysts in gathering requirements and translating them to technical specifications.
• Involved in the analysis and profiling of source data, creating prototypes and sample reports to halp with requirements and design.
• Using SQL Server Reporting Services (SSRS) delivering enterprise, web-enabled reporting to create reports that draw content from a variety of data sources.
• Created jobs for automatically running stored procedures for day-end operations using SQL Server agent such as index rebuild, data loads and summary reports
• Involved in Performance Tuning of Code using execution plan and SQL profiler and added Indexes to improve performance on tables
• Generated Reports using Global Variables, Expressions and Functions for the reports usingSSRS2008.
• Participating in defining ETL strategies, preparing transformation rules and mapping data from source to target
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Implemented security to restrict the access to users and to allow them to use only certain reports.
• Designed and developed efficient SSIS packages for processing fact and dimension tables with complex transformations.
• Extracted large volumes of data from various data sources and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Created SSIS packages for Uploading of different formats of files (Excel, Access, dbf) and databases (SQL server, Flat files) into the SQL Server data warehouse using SQL Server Integration Services (SSIS).
• SQL Server Index Maintenance and Performance Tuning for Large Tables
• Rewrote and tuned long-running SQL queries to cut execution time, ease database load and improve scalability.
• Used Script task to write custom code using C#
• Experience in ETL Data Warehouse environment. Created Jobs in SSIS and was responsible for ETL job scheduled to run daily.
• Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Developed, monitored and deployed SSIS packages.
• Creating Reports as per user requirements using SQL Server Reporting Services 2008 R2.
• Created different types of reports such as Cross-Tab, Drill-down, Drill Through, OLAP and Sub reports, and formatting them using bothSSRS2008 R2.
• Written complex T-SQL queries and created Stored Procedures, Triggers, Functions and Views.
• Created data driven subscriptions for different users using Report Manager.

Environment: MS SQL Server 2008/2008R2/2012, Team Foundation Server, Microsoft SharePoint Server(MOSS 2007), Crystal Reports, SQL Server Integration Services (SSIS), C#, SQL Server Reporting Services (SSRS), Visual Studio 2010, Windows 7,T-, Erwin v8.0, ASP.Net, C#.