SUMMARY:

• Around 8 years of professional experience in working with projects driven on SQL Microsoft Business Intelligence tools, Data Warehousing and ETL processes.
• 3+ years of Experience in creating reports, dashboards using POWER BI Desktop and Server and maintaining POWER BI dashboards on servers.
• Expert on creating multiple kinds of Power BI Reports and Dashboards.
• Expertise gathering functional specification requirements for the development of dashboards and reports
• Interactive data visualization products focused on business intelligence such as MICROSOFT POWER BI
• Proficient in creating Power BI Dashboards and visualizations.
• Created custom visualizations using R - Script and Synoptic Panels.
• Extract and analyze data using PowerQuery, PivotTables, MS Excel, POWER BI and SSAS.
• Developed confidential proprietary analytical tools and reports with Microsoft Excel, and POWER Pivot, and POWER Points.
• Experience with management of data to produce accurate and consistent longitudinal datasets.
• Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Models.
• Building and publishing POWER BI reports utilizing complex calculated fields, table calculations, filters, parameters.
• Expert in T-SQL (DDL, DML): functions, views, triggers, cursors, stored procedures on SQL Server
• Strong Experience in SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), and SQL Server Reporting Services (SSRS).
• Experiencedin ETL processes, worked extensively on data extraction, data integration and loading from different data sources using SSIS.
• Skilled in Tableau Desktop for data visualization, Reporting and Analysis; Cross tab, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Charts
• Designed, developed and implemented various SSIS Packages and deployed using Deployment wizard.
• Excellent Knowledge in Dimensional Data Modeling and analyze Data warehouse by building multidimensional cubes using SQL Server Analysis Services (SSAS).
• Good experience in writing MDX queries to access cubes data in SSAS.
• Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.
• Expertise conducting statistical analyses of data using standard statistical techniques.
• Expert in developing parameterized, linked, matrix, drill down and aggregation reports with various parameters and filters using SSRS.
• Expert in creating Power pivots, Power views and SSRS reports using tabular model (DAX), Cubes (MDX) and SQL queries.
• Extracted data from various sources like SQL Server 2008/2012/2014/2016, Oracle, CSV, Excel and Text file from Client servers and through FTP.
• Working knowledge in Agile/Scrum Environments.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau servers.
• Restricted data for particular users using Row level security and User filters.
• Developed Tableau visualizations and dashboards using Tableau Desktops.
• Provided 24/7-production support for Tableau users.
• Hands on experience on Tableau 7/8/9/10 and Tableau Readers.
• Involved in Troubleshooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.s
• Set-up Enterprise Gateway and SSAS Connector on Azure VM for POWER BI Report Deployments
• Publishing POWER BI reports from POWER BI Desktop to POWER BI services.
• Hands on experience in using version control software like VSS, Rational clear case and (TFS) Team Foundation Servers.
• Experienced in designing and developing interactive User Interfaces, usability, web and client / server applications using HTML5, CSS, JavaScripts.
• Experience with data security and privacy by datasets.

TECHNICAL SKILLS:

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studios.

SQL Server Tools&Packages/BI tools: SQL Server Management Studio, Enterprise Manager, Business Intelligent Studio, Query Analyzer, Profiler, Performance Monitor, Database Tuning Wizard, SQL Server Agent, MDX, ETL, SSIS, SSAS, SSRS, Micro strategy, Erwin Data modeler, IBM Rational Rose, Crystal Reports 11, Tableau Desktop v7/v8, Tableau Server v7/v8, Power Center 9.1.0/9.0.1, 8.6.1,8,Cognos.

Languages: C# ASP. NET, T-SQL, My SQL, VB.NET, HTML, XML, C/C++, CSS, DHTML, Java Scripts.

Operating Systems: Windows 95/2000/2003/2008/ XP/VISTA/7, UNIX (Sun Solar), LINUX

Databases: MS-SQL Server 2008R 2/2008/2005/2000

ETL Tools: Data Transformation Services, SQL Server Integration Services (SSIS)Scripting: Shell Scriptings

DB Utilities: SQL Server Management Utility, Query Analyzers

Application Software: Visual Studio 2010/2012/2014, Visual Source Safe, TFS, MS Office Suites

Data Modeling Tools: Erwin, Red gate, Lite Speeds

Programming Languages: SQL, T-SQL, PL/SQL, C, C++, VB 6.0, CSS, HTML5, XML, JavaScript, ASP.Net

Design Methodologies: Logical and Physical Database Design, UML (Unified Modeling Language), Database Design and Normalization, Data Modeling, 1.1 using Rational Roses.

Other Software: MS Office 2010/2007/2003/2000, Adobe Professional, SharePoint, Power BI, Report Builders

PROFESSIONAL EXPERIENCE:

Confidential, Charleston

Lead POWER BI Developer

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Created POWER BI Visualizations and Dashboards as per the requirements
• Created custom visualizations using R-Script and Synoptic Panels
• Created many calculated columns and measures using DAX in POWER BI based on report requirements.
• Involved in UI Design for POWER BI Reports and designed effective layouts.
• Created effective reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map etc. in POWER BI
• Created Roles and implemented Row level security for user Authentication in POWER BI
• Created effective Dashboards in POWER BI Service and made the reports user friendly and interactive
• Worked with POWER BI mobile app and created mobile layouts to view reports and dashboards effectively
• Custom visuals built using vanilla HTML5, CSS3, JavaScripts
• Installed On premise data gateway and scheduled daily data refresh in POWER BI
• Involved in development and debugging of complex T-SQL procedures and functions
• Designed and developed SSIS Packages to import data and export data from MS Excel, flat files, SQL Server and transform and load data into SQL Server database
• Worked on Data Analysis Expressions (DAX) for accessing data directly from tabular SSAS database
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2014 and Flat files.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production)
• Implemented Event Handlers and Error Handling in SSIS packages
• Advanced extensible reporting skills using SQL Server 2014/2016 Reporting Services (SSRS).
• Created SSIS packages to Extract, Transformation and Load ETL user data and other data from OLTP to OLAP.
• Used SSIS for each loop to implement data updates from various sources to data warehouse.
• Created and Managed OLAP Cubes using SSAS and created different KPIs to perform analysis based on business requirements.
• Worked with SSAS cubes using multiple dimensions, perspectives, hierarchies, measures groups to analyze marketing efforts and prospective customers.
• Developed reports such as tables, matrix, Gauges, Charts, parameter reports, cascading parameter reports using SSRS 2012 and exported to EXCEL, CSV and PDF formats bypassing the report manager screen running the reports from ASP.NET application. Microsoft report view control
• Deployed SSRS reports into a reporting server and implemented security measures at report server by implementing authentication and authorization methods

Environment: SQL Server 2014/2016, SAP BW, Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), Power Map, Power Pivot, Power View, Power BI 2016, .Net framework, MDX,OLAP, Microsoft Office Share Point Server, XML, MS Visual Source Safe.

Sr. POWER BI Developer / Admin

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes
• Expert in developing reports using SSRS and designingSSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2012/2014 and Flat files
• Created SSIS packages (ETL) to migrate data from heterogeneous sources such as MS Excel, Flat Files, .CSV files
• Used Visual Team Foundation server for version control, source control and reporting.
• Write Complex Queries, stored procedures,Batch Scripts, Triggers, indexes and Functions using T-SQL for SQL Server 2008R2/2012
• Involved in daily batch loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS)
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Implemented Event Handlers and Error Handling in SSIS packages.
• Mining models and deploying and processing SSAS objects
• Used Microsoft POWER BI POWER Query to extract data from external sources and modify data to
• Used POWER BI POWER Pivot to develop data analysis prototype, and used POWER View and POWER Map to visualize reports
• Used POWER BI for developing reports, data marts, KPI's and charts for the organization and departments
• Publishing POWER BI Reports from POWER BI Desktop to POWER BI Service
• Responsible for building POWER BI Dashboards for 3M Digital Marketing team 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
• Created custom visualizations using R-Script and Synoptic Panel
• Created calculated Measures for dashboard KPI's using DAX and Direct Query, build custom attributes for dashboard slicers and other filters using DAX
• Build Marketing Dashboards in agile iterative, incremental method without hard requirements and based on daily customer feedback
• Import Data into POWER BI using different ETL methods, SQL Azure, Direct Query, Restful API Generator, build relational model with in POWER BI to generate Marketing Campaigns metrics related to landing pages, Email Analysis and Visitors. Slice data by Month, Campaigns and Area dimensions
• Build Tabular, line charts Graph charts visuals for Marketing KPI's metrics based on fields brought in and transform using POWER Query functions and DAX calculated Measures
• Design Percentage, Month over Month and Year over Year measures after importing data into POWER BI desktop using DAX and POWER Query functions. Slice measure in POWER BI tile using calculated Dimension fields in POWER BI

Environment: SQL Server 2008/2005, Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), Power Map, Power Pivot, Power View, Power BI 2015, .Net framework, MDX,OLAP, Microsoft Office Share Point Server, XML, MS Visual Source Safe and Windows Server 2008.

Sr. POWER BI Developer

Responsibilities:

• Interacted with Business Users and Analyzed user requirements and built reporting solutions such as relational database reports, OLAP reporting,dashboards, and scorecards
• Involved in the dimensional modeling of Data warehouse using Erwin tool
• Involved in Data Modeling to develop the database design using Erwin and created database diagram in MS Visio and SQL Server Management Studio (SSMS)
• Designed and implemented a variety of SSRS reports such as Parameterized, Drill Down, Snapshot, Cached, Drill Through, Ad-hoc and Sub-Reports using Report Designer and Report Builder based on the business requirements using both Tabular and Matrix report formats
• Worked on various types Chart Reports such Lines, Columns, Bars with both 2D and 2D views in order to display cumulative totals based on day to day requirement
• Designed complex T-SQL queries, User Defined Functions
• Stored Procedures and Triggers followed by thorough analysis and testing of those database objects before deployment to the production server
• Maintained Change Control and Release Management process for all database objects like Tables, Views, Procedures and Triggers.
• Actively involved in design of a new normalized data store (NDS) based on Data Vault Methodology as well as a De - normalized Data Store (DDS) per Dimensional Model.
• Created SSIS Packages to import the data from Oracle databases, XML, text files, Excel files.
• Used Data Flow task, Execute package task, Execute SQL Task, for each loop container in SSIS for transformation of the data.
• Created SSIS packages to SQL Server instances in SSIS2012 using CDC feature
• Created several SSIS packages for performing ETL operations to transform data from NDS to DDS systems
• Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) has assigned
• Developed DTSX packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server Integration Services (SSIS).
• Experience in Developing and Extending OLAPCubes, Dimensions and data source view.
• Assisted in production OLAPcubes, wrote queries to produce reports using SQL Server 2008/2012/2014 Analysis Services (SSAS) and Reporting service (SSRS)
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Involved in migration from SQL Server2005 to SQL Server2012 and 2014.
• Designed the ETL for merge operation as migration was to be done in phases with the view of shutting down old processes as transition happens to new data warehouse, old becoming void eventually
• Designed, developed, tested, and maintained Tableau functional reports based on user requirements
• Mastered the ability to design and deploy rich Graphic visualizations using Tableau
• Converted existing BO 5x reports into tableau dashboards
• Developed Tableau data visualization using Pareto's, Combo charts, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Cross tabs, Histograms
• Designed and developed the reports according to the requirements using Tableau and Power Map.
• 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
• Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
• Created Reports using Power BI
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
• Scheduled the Reports to run on daily and weekly basis in Report Manager

Environment: SQLServer 2008 R2/2012, Business Intelligence Studio (SSAS, SSIS, SSRS), Tableau 8.2, Performance Point Server, Power Map, Power Pivot, Power View, Power BI, SharePoint 2010, XML, T SQL, Erwin, Oracle 10g, Talend, MS Excel, ASP.NET, ETL, OLAP

Sr. BI (POWER BI ) Developer

Responsibilities:

• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development
• Designed and development of Tableau visualization solutions
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2012.
• Assisted users in creating and modifying worksheets and data visualization dashboards
• Generated various dashboards in Tableau server using various sources such as SQL Server/Teradata
• Created users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks
• Created cubes and dimensions and measures and calculated measures according to the business requirements
• Created drill down and drill up in worksheets in tableau
• Created report schedules on Tableau server
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Processing the cubes and dimensions on a daily basis using the SSIS tasks .
• Created SSIS packages to Oracle and other SQL Server instances in SSIS 2012.
• Created several SSIS packages for performing ETL operations to transform data from OLTP to OLAP systems.
• Performed the task of data transfer from files in remote server to folders in another server using FTP.
• Created database maintenance plans and deleting of history data using SSIS packages.
• Performing the tasks of data conversions, adding derived columns, sending results in mails is done by making use of various tasks in SSIS.
• Created Data warehouse Cubes in SQL Server Analysis Service (SSAS).
• Designed Cubes with Star Schema using SQL Server Analysis Services 2008 (SSAS).
• Created several SSIS packages for performing ETL operations to transform data from a cube using MDX
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2008 to MS SQL 2012 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Worked on T-SQL programming, stored procedures, user-defined functions, cursors, views setup and management of linked servers to Non-SQL-Server databases.
• Extracting the data from the different sources (CSV files, oracle, and MS SQL 2012) and stored the data into the intermediate Staging Database using the SSIS ETL tool.
• Transform the data from the staging database and perform the transformation using the Data Flow Tasks.
• Operations and perform the Different required transformation in the Staging Database and make the data ready to load in the Data Warehouse Database.
• Knowledge on integration of BI suite of products with Microsoft Office range of products like MOSS (SharePoint), Business Scorecard Manager, Dashboards, Performance Point Server
• Developed reports in SSRS 2012 and deployed reports into SharePoint Server 2010 (MOSS).
• Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
• Build database queries and test cases for the testing team to test the reports.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, and XML etc.

Environment: SQLServer 2008 R2/2012, Business Intelligence Studio (SSAS, SSIS, SSRS), Performance Point Server, SharePoint 2007, Proclarity, T SQL, Erwin, Oracle 10g, Tableau Desktop 7 8.1, Tableau Server, MS Excel, ASP.NET, ETL, OLAP, MDX.

BI Developer

Responsibilities:

• Administering and maintaining large SQL Server 2008, 2005 and 2000 databases with more than 100 million records in individual tables.
• Data Analysis and BI Reports against OLAP/MDX Data cubes using SSRS
• Disaster Recovery planning and implementation - Database mirroring, Log shipping, Active Passive clustering.
• Creating SQL agent maintenance jobs for purging data, maintaining indexes, archival operations
• Creating SSIS package based jobs for bulk data loading, updating and exporting.
• Moving / copying / migrating CUBES (SSAS) from one server to another Server and reprocessing the Cubes.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server
• Effectively used data blending feature in tableau
• Defined best practices for Tableau report development
• Administered user, user groups, and scheduled instances for reports in Tableau
• Executed and tested required queries and reports before publishing
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications
• Consistently attended meetings with the Client subject matter experts to acquire functional business requirements in order to build SQL queries that would be used in dashboards to satisfy the business's needs
• Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards, Tableau suite
• Provided support for Tableau developed objects and understand tool administration.
• Supporting production issues during work and after hours as required.
• Using new features of SQL Server 2008 like Log compression, transparent data encryption TDE, Policies, Performance data collector, Auditing.
• Performance tuning, trouble shooting and monitoring using Performance Dashboard reports, Database Tuning Advisor, SQL Profiler, Dynamic Management views (DMV).
• Experience in Microsoft SQL Server CLUSTERING.
• Database Design and maintenance for trading data services and collaboration services for users of financial community (traders, bankers, hedge fund managers).
• Migrated DTS packages from SQL Server 2000 to SQL Server 2005 as SSIS packages
• Using SQL Server Service Broker to create async. message based database update services.
• Maintaining database security and application security framework using security matrix, windows based group memberships and database roles.
• Extensively using XML for input and export operations.
• Created and Implemented SSIS Packages for importing and exporting data to other data storage like Postgre-SQL, FoxPro, and DB2.

Environment: SQL Server 2008, SQL Server 2005, Windows Server 2008, Windows Server 2003, Transact-SQL, SSIS, SSAS, SQL Server Reporting Services, Tableau Server, Tableau Desktop 6 & 7, SQL Sentry, VMware.

BI Developer

Responsibilities:

• Created tables with Cluster/Non-Cluster Index, Stored Procedures, and Triggers; programmed and designed reports off transactional databases
• Monitored performance and optimized SQL queries; and created and modified T-SQL stored procedures.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults user defined data types and functions
• Scheduled batch jobs; ran daily SSRS reports
• Designed Reports that had complex SQL, PL/SQL code and stored procedures using Reports 10g.
• Tracked and resolved issues of JIRA Issue Tracking System application with multiple features and capability like data upload, work flow, various reports, dashboards and filters that enable to get data for required criteria.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package
• Extracted data from many operational systems, including flat files, spread sheets and RDBMSs like SQL Server and Oracle.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production)
• Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse
• Designed Forms that had complex stored procedures and PL/SQL code using Forms 10g and did some personalization's
• Tuned PL/SQL Stored Procedures/Functions to improve the performance by creating function-based Index, Optimizer Hints, Explainplan and analyzing the tables.
• Involved in creating DYNAMIC SQL that will update or insert data into the tables on the run.
• Exporting and Importing the data into the database as and when user provided the data and do analysis.
• Configuring SSIS packages using package configuration wizard to allow packages run on different environments.
• Developed and Maintained MS Access Database.
• Created views, SQL joins DTS packages and statements for applications
• Develop SSIS packages to load the data into data marts
• Extensively using SSIS for Transformations, Aggregations and Lookups

Environment: SQL Server 2005/2008/2012, T-SQL, Windows XP, Visual Studio, Report Builder, SQL Profiler, SSIS, SSRS, SSAS.

Database Developer/DBA

Responsibilities:

• Installation, configuration the MS SQL Server 2000 and maintenance of servers in various environments.
• Performance and tuning of SQL servers and application issues related to migration.
• Testing of applications for performance, data integrity and validation issues.
• Data Transfers between various servers using BCP and Managing Disk space on NT systems.
• Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.
• Writing the stored procedures, checking the code for efficiency. Routine backups and restoration.
• Develop and maintain in-house utilities to automate problem determination, change implementation and monitoring activities.
• Administrative and Production support for various applications in all environments.
• Database Backup Procedures, Restoration Procedures,Disaster Recovery procedures and Contingency plans. Testing and implementing these procedures

Environment: SQL Server 2000, Query Analyzer, SQL Profiler, Windows 2000 Server, Import & Export Data.