PROFESSIONAL SUMMARY:

• Over 9 years of IT experience as Business Intelligence Engineer that includes Data Analysis, Dashboard and Report Design and Development using Tableau Desktop/Online/Prep Builder, MS SQL Server 2019/2017/2016
• As a Business Intelligence Engineer, I was responsible for data collection, data cleaning, data processing, presentation and data visualization for analysis and reporting in support of ITSM’s Continual Service Improvement based on metric - driven methodology to support business operations, recognize improvement opportunities and accurately measure the influence of those improvement efforts.
• Experience in working with Tableau Desktop/Prep/Online: functionalities like interactive filters, static and dynamic text, calculated fields, data blending, LOD, tooltip and more. Writing SQL queries with operators and using Joins. ServiceNow: Creating work orders and filters to get data dump ready for report analysis, creating maintenance windows for planned outages, using impersonation feature to pull data from another authenticated user, assigning tickets to relevant teams, create LiLo (Log in/out) reports. Other tools and platforms like Salesforce (to map deliverables with defined SLA, OLA and GMSA) Viewpoint, QuickBase (to check event outages for root cause analysis and it’s documentation), Zenoss, ServiceCenter, EDW(OracleBIEE).
• Built data visualization dashboards through analyzing, interpreting data and trends in complex data sets for managing reporting needs using Tableau, MS Excel (charts, graphs, pivot tables etc.) and SQL for larger datasets.
• Created customer reports and dashboards including but not limited to monthly and/or weekly CBRs, QBRs, Ad hoc and White glove report requests and SLA reporting for variously defined service levels of customer.
• Experience in Data Modeling, Database Design, SQL Scripting, Development and Implementation of Client-Server & Business Intelligence (SSIS, SSAS, and SSRS) applications.
• Expertise in scripting T-SQL queries, complex stored procedures, user defined functions (UDF), Database triggers.
• Experience in writing MDX queries while creating and customizing Cubes using SQL server Analysis Services (SSAS).
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts.
• Expertise in writing and debugging Stored Procedures and Triggers in SQL Server and PL/SQL.
• Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, DTS, Bulk Insert, BCP, and XML)
• Expert in creating SSIS packages to manage SQL Server databases and SQL Server objects between instances of SQL Server.
• Experience in PerformanceTuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Creating and deploying parameterized reports using Power BI.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Expert in designing complex reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
• Extensive knowledge of designing, developing and deploying various kinds of reports using SSRS using relational and multidimensional data.
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports and MS-Excel spreadsheets.
• ETL processes include migrating data from a DB2 database to SQL Server. Implemented high availability on the various servers using replication/mirroring.
• Design, develop and test ETL (SSIS) packagesin order to extract, transform and load data from multiple sources into the data warehouse.
• Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Expert in generating Drilldown reports, Parameterized reports, Linked reports, Ad-Hoc reports, Sub reports and filters, charts in SSRS 2012/2008.
• Experience in Performance Tuning, Monitoring and Optimization of T-SQL blocks in both Development and Production environment for SQL server database.
• Experience in Database Mirroring, Log Shipping, Database Replication, CDC and Database Snapshots
• Created & formatted Crosstab, Conditional, Drill-down, Top N, Summary, Form, OLAP, Sub reports, parameterized reports, interactive reports & custom reports
• Created analytical reports and visualizations with Microsoft Excel 2013Power BI tools (Power View, Power pivot and Mapping) for exploratory analysis by data analysts
• Worked in OLTP &OLAP environments that include QA, Production and development, implement maintain database schema and Entity relationship diagrams from business requirements.
• Created stored procedures for generating reports using SQL Server Reporting Services (SSRS), Crystal Reports. Good command in generating on demand and scheduled reports for business Analysis and Management decisions using SSRS.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Exposed to all phases of software development life cycle SDLC including in-depth knowledge of Agile methodology, Enterprise Reporting Life Cycle, SQL Server Migrations, Change control rules, problem management and escalation procedures
• Good SQL Server Administration skills including, Backups, Disaster Recovery Model, database maintenance, user authorizations, Database creation, Tables, indexes.
• ITIL v3 (Foundation Certified)

TECHNICAL SKILLS:

Databases: MS SQL Server 2019, 2017, 2016, 2012, 2008 R2, 2008/2005, PostgreSQL, MySQL, MS-Access 97- 2007.

ETL Tools: SQL Server Integration Services (2005/2008), Data Stage, DTS.

Operating Systems: Windows 2012/2016/2008 Server, Windows 9/10/11

Reporting Tools: Tableau, SQL Server Reporting Services (SSRS), Micro strategy, Crystal Reports 8/9/10.

Database Tools: MS SQL Server Enterprise Manager, SQL Profiler, Query Analyzer, Profiler Database Engine Tuning Advisor (DTA).

Other Tools: Microsoft Office 2003/2007

Version Control Tools: Visual Source Safe 6.0, Source gear Vault, SVN, Subversion and TFS.

Data Modeling Tools: Erwin, Red gate, Lite Speed

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

PROFESSIONAL EXPERIENCE:

Confidential

Sr. SQL BI Developer (Tableau/Power BI)

Responsibilities:

• Created Tableau visualizations for ad-hoc reporting against various Data Sources like Flat Files (Excel, Access) and Experience in working with Tableau Desktop/Server: functionalities like interactive filters, static and dynamic text, calculated fields, data blending, LOD, tooltip and more.
• Understand the Requirements and Functionality of the application from specifications
• Designed, developed, tested and maintained Tableau functional reports based on user requirements.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameters using Tableau
• Converted existing BO reports to tableau dashboards
• Created different KPI using calculated key figures and parameters.
• Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts. Scatter Plots. Geographic Map. Pie Charts and Bar Charts and Density Chart.
• Developed donut charts and implemented complex features in charts like creating barcharts in tooltip.
• Worked extensively with Advance analysis Actions Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.
• Hands on building Groups, hierarchies Sets to create detail level summary reports and Dashboard using KPI's
• Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around Visualization and design Provided Production support to Tableau users and Wrote Custom SOL to support business requirements.
• Utilized Tableau server to publish and share the reports with the business users.
• Also involved in administration tasks such as Setting permissions, managing ownerships and providing access to the users and adding them to the specific group.
• Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community
• Extensively worked on Data Flow tasks like foreach Loop Container, execute process task, Transfer SQL Server Objects task, Transfer Jobs task, Transfer Logins task.
• Deployed and configured the reports in the Report Server.
• Created EntityRelationship (ER) diagrams for the proposed database utilizing conceptual, logical and physical data models.
• Worked with SSIS packages involved FTP tasks, Fuzzy Grouping, Merge, and Merge joining, Pivot and Un pivot Control Flow Transformations.
• Experienced in Developing Power BI Reports and Dashboards from multiple data sources using DataBlending.
• Created various kinds of reports using Power BI and Tableau, SSRS, Excel, and PowerPivot based on the client's needs.
• Hands on experience in creating ETL packages to build data marts using SQL Server Integration Services (SSIS) and creating OLAP cubes using SQL Server Analysis services (SSAS).
• Extensively Worked on Extraction, Transformation and Load (ETL) process using PL/SQL to populate the tables in OLTP and OLAP Datawarehouse environment.
• Used Text Files/ SQL Server Table Logging for all SSIS packages.
• MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services were developed.
• Used SQL Server Package Configuration technique to make Dynamic configurations.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Created ETL packages using SSIS to extract data from relational database and then transform and load into the data mart.
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Created SSIS/ETL packages for moving data from OLTP database to operational database (ODS) for reporting.
• Deployed SSIS packages with a simple one-click deployment to the integration server.
• Maintaining Tableau reports and analysis and work on enhancements to existing reports or creating new reports based on business needs
• Used Dynamic SQL extensively in T- SQL increasing usability of code and used dynamic query to create SSRS reports
• Extracted Data from various Heterogeneous Databases such as Oracle and Access database, DB2, flat files to SQL server 2012/2008R2 using SSIS.
• Used SSIS to create ETL packages to validate, extract, transform and load data into data warehouse and data marts.
• Created SSIS packages for extracting data from data bases like SQL, Oracle and load those data into tables in SQL server.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Worked with various SSIS packages which involve Transactions, restart ability and roll backtechniques.
• Created Data Source and Dataset using OLAP Cube to create Tabular and Matrix reports as per user requirements.
• Configured SQL mail agent for sending automatic emails when SSIS packages fails or succeeds.
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.
• Optimizing Stored Procedures and long running SQL queries using indexing strategies and query optimization techniques.
• Created SSIS packages (ETL) to migrate data from heterogeneous sources such as MS Excel, Flat Files, .CSV files.
• Used .NET code in script task to perform some business requirements when dealing with images.
• Operate data capture technology to import digitized documents into document management system.
• Propose recommendations for improving content management system capabilities.
• Built cubes for production application, Partitioned Cubes to decrease the processing time and increase the performance of the queries running on front end application.
• Created user defined functions in SSRS.

Environment: SQL Server 2017/ 2016/2012/2008 R2/2008, SSRS 2008, SSIS 2008, Power Pivot, Tableau, DB2, MS Office and Visual source safe, Visual Studio 2012.

Confidential

Sr. Tableau BI Developer (SSRS /SSIS/SSAS)

Responsibilities:

• Extensively worked on Data Flow tasks like for each Loop Container, Execute process task, Transfer SQL Server Objects task, Transfer Jobs task, Transfer Logins task.
• Migrated data from heterogeneous data sources (Data mart, Access, Excel, Flat file) to centralized SQL server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Implemented C# code in Script tasks to implement customized requirements.
• Migrated DTS packages from SQL Server 2012 to SQL Server 2016 as SSIS packages.
• Responsible for developing and maintaining Tableau dashboards
• Created dashboards for analyzing POS data using Tableau 10.2, 10.3
• Consistently attended meetings with the client subject matter experts to acquire functional business requirements.
• Developed case studies to understand new product launch, promotion effectiveness, trend detections, Seasonal forecasting.
• Created Scatter Plots, Stacked Bars, Box and Whisker plots using, Bullet charts, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications. Expert level capability in Tableau calculations and applying complex, compound calculations to large, complex data sets
• Created custom Function's Date range, Time functions, array functions, and Conditional formatting functions in the reports.
• Scheduled extract refresh for weekly and monthly reports.
• Worked on workbook Permissions, Ownerships and User filters.
• Extracted data from various sources like MS SQLServer 2012/2008, DB2, flat files, Excelspreadsheets, Oracle and XML files and loaded into the oracle database.
• Excellent report creation skills using Microsoft SQL Server 2012 ReportingServices (SSRS) with proficiency in using Report Designer as well as Report Builder and MS SharePoint.
• Created calculated members and KeyPerformanceIndicators (KPIs), perspectives and partitions with existing SSAS cube objects for better analysis.
• Implemented report manager to set up roles, security, and subscripts (data driven/standard) on the existing SSRSreports.
• Extract and analyze data using Power Query, PivotTables, MS Excel, POWER BI and SSAS.
• Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard utilizing Power BI.
• Creating and deploying parameterized reports using Power BI and Tableau.
• Transferring the data (ETL) to Data warehouse with SQL Server 2005 and 2008R2 Integration Services.
• Good Knowledge on data visualization tools PowerBI and Power Pivot.
• Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
• Created complex reports which involve a greater number of groupings and multi-value parameters.
• Developed reports like Claim Statements, Fee Bills Transactions and some end request user reports on periodic basis.
• Restructuring the stored procedure, designing, coding and developing using the T-SQL Programming.
• Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.
• Created multiple reports with drop down menu option having complex groupings within the report.
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Wrote multi-Dimensional Queries (MDX) to generate reports for analysis of data.
• Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2012/2008(SSAS).
• 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 cube partitions and aggregations to improve the MDX query performance.
• Developed complex packages which takes data from various sources like excel, Flat file, DB2, oracle using AS400 IBM and ODBC drivers, calling reporting service within the package to create SSRS reports on fly and calling web service to transfer data of XML type.
• Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
• Created various complex reports using Crystal Reports XI R2 and worked on existing reports toenhance/modify by creating new Parameters, Formulas.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Worked on T-SQL programming, stored procedures, user-defined functions, cursors, views setup and management of linked servers to Non- SQL-Server databases.
• Used Dynamic SQL extensively in T- SQL queries and stored procedures increasing usability of code.
• Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Rendering the reports to PDF formats as per the requirement and printing all the reports in a batch process for Monthly Statements.
• Conduct needs assessments to identify document management requirements of departments or end users.
• Working experience with ASP .NET to display reports and experience using C# in SSIS scrip task.
• Worked very closely with Business Customers, End Users and resolved any business process related issues.

Environment: PowerBI, Tableau Server, Windows server, IIS 6.0, MS SQL Server- 2016/2012/2008 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, Power BI, Erwin VB.NET, OLAP, OLTP, Erwin, UNIX, Performance Point Server, Office-2007, MS Excel, C#.NET, ProClarity Analysis, MS SharePoint.

Confidential

SQL BI Developer

Responsibilities:

• Designed and developed SQL Server Reporting Services (SSRS)SQL Server 2012/2008.
• Involved in Report writing per business requirement usingSSRS and Crystal Reports.
• Generated database monitering and data validation reports in SSRS.
• Expert in creating Tabular reports, Matrix reports, List report, Parameterized reports, Sub reports, Ad-hoc reports (SSRS).
• Wrote the complex queries using joints, Sub-queries, common table expressions (CTE) in T-SQL.
• Experienced on creating multiple kinds of Reports in Power BI, Ad-hoc and present it using Story Points.
• Configure the Report Server and generated the Report Models for user interactions.
• Involved in Partition of cubes to increase the performance of cubes.
• Sound Experience and understanding of SSAS, OLAP cube, Data mining and Architecture.
• Involved in Performance Optimization of Microsoft SQL Server stored procedures, Analysis Services and cubes.
• Deployed SSRS Reports in SharePoint for web-based access for multiple end users.
• Usedwindows Power Shell Script to automate application deployment process.
• Generated dynamic stored procedures, triggers, Cursors, Joins for the database deveblopment.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Interacting with Business users and BA’s to gather requirements for creating ETL Packages and Reports.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file to MS SQL Server by using BCP utility, SSIS services.
• Creating SSIS Packages using different type’s task and with Error Handling.
• Developed many scripts while designing the SSIS package using C#, VB.NET
• Experience in creating complex SSIS Packages with error handling using control and dataflow elements.
• AzureStorage development and design utilizing Blobs, Pages, Queues, Tables and VM's
• Experience in creating complex SSIS packages using proper control and data flow elements.
• MigratedDTS packages from SQL Server 2000 to SQL Server 2005 as SSIS Packages.
• Created SSIS Packages to migrate slowly changing dimensions. Scheduling the SSIS packages and Jobs.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• 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.
• Created SSIS Packages to migrate slowly changing dimensions. Scheduling the SSIS packages and Jobs.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2005.
• Successfully deployed reports in various sources like XML, Web browser and PDF.
• Understanding the OLAP processing for changing and maintaining the warehousing, optimizing Dimensions, Hierarchies and adding the Aggregations to the cube.
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Designing OLAP cubes, Data Modeling, Dashboard Reports, and scorecards according to the business requirement.
• Built and maintained SQL scripts, indexes, and complex queries for data analysis and extraction.
• Experience writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers, SQLCMD, and SMO.
• Expert in writing stored procedures, user-defined types, triggers, table valued functions, and aggregates using a .NET managed language
• CreatedSQL Server Profiler traces and used with Database Tuning Advisor (DTA) for optimum performance of T-SQL and MDX queries.
• Improved the MDX query performance by changing the dimension structure and measure group properties.
• Wrote MDX queries according to the business requirements.
• Experience in Designing and Building the Dimensions and cubes with star schema and snowflake schema using SQL Server Analysis Services (SSAS).
• Created Analytical reports by ProClarity tool.
• Designing Cubes, Star Schema and Data models for Data Warehousing Applications.
• Involved in Unit testing process.

Environment: MS SQL Server 2005/2008/2012, Management Studio(SSMS), ETL, DTS, Azure, Notification Services, Crystal Reports9.0, Data Modeling, OLAP, Data ware Housing, MDX, C#, ASP.NET,Share point (2003/2007), Asp.Net, T-SQL, SQL Profiler, IIS 6.0, Windows 2003 Advanced Server, SSAS, SSIS, SSRS 2005/2008, community server, Erwin.

Confidential

Jr. Tableau Developer

Responsibilities:

• Upgraded to latest version from SQLServer 7.0 to 2005.
• Developed User Defined Functions for giving Scores and views for the application
• Developed, monitored and deployed SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database
• Performed Full load & Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS
• Wrote various Stored Procedures for application development
• Tuned SQL statements (e.g.: using Indexes) and Stored Procedures
• Worked on replication of data (Transactional method used)
• Designed and implemented data access stored procedures and triggers for automating tasks
• Created SSIS package to Export and Import data from SQL Server to Access, Text and Excel files and Configured SQL mail agent for sending automatic mails
• Configured Connection Manager files for SSIS packages to dynamically execute on Quality Analysis server and Production server
• Developed Parameterized, Drill-through, and Drill-down Reports to get monthly customers account details and profits using SSRS
• Involved in deploying, configuring and managing reports using Report Manager and Report Builder
• Formatted the reports using the Global variables and expressions
• Performed job scheduling and alerts
• Designed and implemented user log in and security
• Resolved any deadlocks issues with the databases/servers on a real-time basis

Environment: MS SQL Server 2005/2008, Management Studio(SSMS), ETL, DTS, Azure, Notification Services, Crystal Reports9.0, Data Modeling, OLAP, Data ware Housing, MDX