PROFESSIONAL SUMMARY:

• Over 10 Years of IT Experience in using Microsoft SQL Server IT Projects involving Business Intelligence (BI), Data Warehousing and Data Conversion in System Design, Development and Support of Microsoft SQL Server 2016/2014/2012/2008 R2/2008/2005 in Development, Data warehouse, Test and Production Environments on various business domains like Banking/Financial, Investment, Healthcare, Retail, Manufacturing, Pharmaceutical and Delivery Services.
• Over 3 years of experience developing interactive dashboards using Power BI and Over 5 years of experience working with Tableau using 8.x/9.x/10.x/2019. x.
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting MS SQL Server 2012/ 2008/2008 R2/2014.
• Experienced in using T - SQL for developing Stored Procedures, Triggers, Tables, Indexes, Views and User Defined Functions.
• Expertise in the usage of ETL tools including SSIS, DTS for large-scale Data warehouse implementation Projects involving conversion of data from heterogeneous data sources including SQL Server 2000/2005, DB2 and Oracle.
• Experience in providing Logging, Error handling by using Event Handler, and Performance Tuning in SSISpackages by using Row Transformations, Block and Unblock Transformations.
• Created and organized knowledge supply & knowledge supply Views, Dimensions, Cubes, Measures, Partitions, mistreatment SQL Server 2008/R2 Analysis Services.
• Worked on all the Products in Power BI such as Power BI Desktop, Power BI Pro, Power BI Embedded, Power BI Report Server, Power BI Premium, Power BI Mobile
• Expertise Knowledge in writing DAX Queries and MDX Queries.
• Strong understanding of project life cycle and SDLC methodologies including Waterfall and Agile.
• Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups.
• In depth understanding of the As-Is and To-Be (Gap Analysis) business processes and experience in converting these requirements into Technical Specifications for preparing Test Plans.
• Expertise in Tracking, Documenting, Capturing, Managing and Communicating the Requirements using Requirement Traceability Matrix (RTM)which helped in controlling numerous artifacts produced by the teams across the deliverables for a project.
• Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down menu option and Parameterized using Tableau.
• Expertise in using Tableau Filter, URL and Highlight actions to switch between sheets and navigate to external or internal websites
• Expert in visualizing the data, reporting and analyzing, creating the dashboards and reports in an intelligible pictorial representing like bars, geographic maps, bubbles, pies, lines etc.
• Proficient in creating Tableau scorecards, dashboards using advance Tableau functions like Calculated fields, Sets, bins, Groups, Parameters, Actions, Level of Detail (LOD), Adhoc Calculations, etc.
• Experience in creating various filters like quick filters, data source filters, global filters, context filters and user filters in Tableau.
• Extensive experience in creating users, groups, sites, row level security and monitoring server activities in Tableau Server.
• Hands-on experience Relational Database Modeling and Dimensional Modeling in combination with SSAS to develop OLAP cubes having Star/Snowflake schemas.
• Worked on Power Bi and created reports and dashboards and published them on service.
• Experienced and Created logs forETLload at package level and task level to log number of records processed by each package and each task in a package usingSSIS 2012.
• Expertise working with SSAS Tabular model to produce reports in excel files using pivot tables.
• Excellent T-SQL programming skills and experience in the development of SSIS packages using BIDS, complex Stored Procedures, Configuration Files, Tables, Views, Triggers and Functions.
• Worked on administration tasks such as Data loading, Batch Jobs, Data unloading, Backup & Recovery, User and Application Table Management, upgrades, creating Databases/File groups/Files/Transaction logs.
• Developed Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc Reports and distributed Reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Experience with full development cycle of a Data Warehouse, including requirements gathering, design, UAT, and Deployment
• Stronginterpersonalskills with demonstrableverbalandwrittencommunications to maintain effective work relationships with all levels of personnel.
• Experience working with offshore team.

TECHNICAL SKILLS:

Business Intelligence Tools: SSIS, SSRS, SSAS, Informatica, Power BI, Tableau Desktop/Server/On-Line 10.x/9.x/8.x, Power BI, Dashboard Designer, SQL, Google Analytics

ETL Tools: Informatica Power Center 9.x, SQL Server Integration Services (SSIS), Tableau Prep.

Languages: SQL, Custom SQL, Stored Procedure, ANSI 89/92, PL/SQL, HTML, PythonData Modeling: Star Schema/Snowflake Schema model, Fact & Dimensions tables, SCD Type 1/2/3, OLAP, OLTP, Conformed Dimensions

Databases: Oracle 10g/11g/12C, MS SQL Server 2008/2012/2014, Teradata, MS Access, Salesforce, MySQL, DB2, PostgreSQL, Hive.

Operating Systems: Windows XP/Vista/7/8/10, MAC OS X, Linux, Unix

Microsoft Tools: MS Outlook, Visio, MS Project, MS-Excel, Power Pivot 2010, MS-Access

Industries: Banking/Financial, Investment, Healthcare, Retail, Manufacturing, Pharmaceutical and Delivery Services.

Document Management: JIRA, Share Point, Version One

PROFESSIONAL EXPERIENCE:

Confidential

Senior Power Bi Developer

Responsibilities:

• Developed Rich looking Analytical Dashboards and Reports in Power BI for Business Executives to take better decision.
• Worked with Data Sources such as Amazon Redshift and Azure SQL Data Warehouse.
• Developed Power BI Custom Visual custom table bars with D3 Java Script and Type Script.
• Familiar with DAX Functions Such as SUMX, CALCULATE, ALLEXCEPT, FILTER, RANK.
• Created Drilldowns, Drill throughs and Bookmarks in Power BI Reports for easy navigation and storytelling.
• Worked in ‘M’ Language and Power Query for data cleansing in Power bi desktop query editor.
• Created and Managed Parameters in Power BI Desktop for changing the source with different environments such as development, test and production.
• Created Dynamic Dropdown measures in slicer with the help of DAX in Power BI Desktop.
• Developed Measures, Calculated Columns, Conditional Columns, Custom Columns in Power BI.
• Developed different types of reports such as Descriptive, Predictive, Prescriptive for end-users.
• Created and developed Dynamic and Static Row-Level-Security in Power BI Desktop according to the roles assigned to the users
• Created various visualizations such as Scatter Charts, Bubble chart, Slicers, Stacked Charts, Pie Charts, Donut Chart. Cards according to business requirements.
• Installed and Configured Power BI gateway (Personal/Enterprise) to schedule daily jobs to refresh reports/dashboards in Power BI Service.
• Wrote SQL Queries in Amazon Redshift & Azure SQL Datawarehouse to test the data and verify the quality of data.
• Designed Data Models in Power Bi Designer by using schemas such as STAR, SNOWFLAKE and GALAXY.
• Handled Relationships in Power Bi desktop such as MANY-MANY, ONE-MANY, MANY-ONE, ONE-ONE.
• Developed and deployed reports for the internal users in Power BI Report Server.
• Embedded Power BI Reports in to our own .Net Application via REST API’s for giving better access and flexibility to the end-users
• Worked with both the modes of connection in power bi such as Direct/Import Query Modes.
• Created, Managed, Scheduled Pipelines in Azure Data Factory.
• Worked with both the version in Azure Data Factory such as V1 & V2
• Development level experience in MicrosoftAzureprovidingdatamovement and scheduling functionality to cloud-based technologies such asAzureBlob Storage andAzureSQL Database.
• Wrote U-SQL Scripts to transform RAW Data in to meaningful data stores and data lakes
• Created Copy activities and linked service for both source and destination Databases.
• Worked on all the different activities such as Data Movement, Data Transformation and Control activities.
• Installed and Configured Integration runtime for Data Source.
• Worked on backing up and restoring theAzureDataFactoryV2.
• Used Poly base for loading data into the destination of copy activity.

Environment: Power Bi Desktop, Power Bi pro, Azure Data Lake, Power BI Premium, Power BI Embedded

Confidential, Houston TX

Power BI Developer

Responsibilities:

• Generated periodic reports for Marketing, Logistics in Tesoro.
• Data Sources Used: SAP BW, Salesforce and Excel Files
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Hands-on working on dummy projects with creating solution driven views and dashboards by developing different chart types including Heat Maps, Geo Maps, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, and Histograms in Power BI.
• Developed Custom Visualization in Power Bi such as Fuel tank, Liquid fill Gauge, Charts.
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required.
• Used Import Theme Concept such as custom theme to color the report in meaningful way using JSON files.
• Familiar with Apps workspaces and Embedding power bi reports from Power BI Service.
• Published Power Bi reports to end user via mobile and content packs.
• Worked on various Conditional formatting in power bi visuals to define the data in appropriate way.
• Designed trend by Year, Quarter and Month by using visuals such as Line & Stacked column chart, Line & Clustered column chart, Combo chart
• Showcased the Geography data in Power BI using visuals such as MAP, Field Map, Shape Map, ArcGIS and Globe Map.
• Worked with Longitude and Latitude data to plot the locations exactly and give insights of particular location to show the progress.
• Weekly Presentation of Power Bi Prototype and wireframe reports to business users and stake holders and also provide how to use and navigate power bi report.
• Worked on Data Cleansing Part in Power BI desktop using concepts such as, Merge Columns, Merge Queries with necessary joins, Pivot, Unpivot and Transpose columns and rows in query editor
• Created the KPI to show the difference between actual, budget and forecast data using visuals such as DUAL KPI, KPI and Power KPI
• Created and Presented Power point presentation to business users on Prototype and Wireframe of Power bi reports visually every week.
• Created Several User Roles and Groups to the end - user and provided row level security to them
• Analyzed all the SAP BW data dimensions, Measures and created data dictionary for all the data elements needed for report
• Worked on Type script, D3 Java script, html, CSS and developed custom visualization in Power BI
• Created KPI, Gauges, Clustered column chart, Slicers for better understanding of the report
• Developed Operational Reports for the Marketing in Tesoro Corporation such as daily reports

Environment: Power Bi Desktop, Power Bi pro, office 365, SAP BW, Salesforce, MS Excel, txt file, SAP HANA

Confidential, Minnetonka, MN

Tableau Developer/BI Analyst

Responsibilities:

• Requirement gathering for various users, interviewing them, and satisfying their exact needs.
• Involved in the completeLife cycle of the Project and in thedata analysis process
• Gather the various requirement matrices from the business analysts.
• Assisted the DBA in converting the logical models to physical.
• Conduct Design discussions and meetings to come out with the appropriate Data Mart using Kimball Methodology.
• Created technical designs for the various reporting requirements.
• Developed complex SQL scripts for Teradata database for creating BI layer on DW for tableau reporting.
• Identify new metrics and enhance the existing KPI's.
• Dashboard Visualization through Tableau BI application.
• Effectively used data blending, filters, actions, Hierarchies feature in tableau.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Designed different BI Dashboardsfor the Company Executives, through an efficient use of Tableau Report Services.
• Created all possibleMetrics, for enabling the end users to generate customized reports by creating their ownTemplatesandFilters.
• Built Complex Reports using advanced reporting functions like with YTD calculations, percentage differences, sets and groups etc.,
• Involved in report tuning, caching, specifying query governing thresholds, and report optimizations.
• 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.
• Helped end users with integration of their front-end application with tableau server by establishing trusted authentication.
• Created rich dashboards using tableau desktop and prepared user stories to create compelling dashboards to deliver actionable insights
• Maintained Test Log and wrote Test Evaluation, Summary Reports.
• Setup and Deployed tableau server to publish dashboard to a central location for portal integration
• Implemented row level security and windows AD authentication for Tableau reports
• Worked with the tableau community to extensive test the tableau 8 beta version

Environment: Tableau 8.x (Desktop/Server), Teradata, Oracle, SQL Server, Power Designer, MS Visio, JIRA Microsoft Office Suite (Word, Excel, Power Point, Visio).

Confidential, Houston TX

Tableau Developer/Data Analyst

Responsibilities:

• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures.
• Developed and maintained high level overview of the project and design flows using MS Visio.
• Created dashboard using parameters, sets, groups and calculations.
• Created interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Utilized advance features ofTableausoftware like to link data from different data sources together on one dashboard to filter data in multiple views.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau 8 desktop/Server.
• Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
• Created incremental refreshes for data sources on Tableau server.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Created report schedules, data connections, projects, groups in Tableau online.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Involved in creating complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Involved in creation and updates of several SQL Index, Views, Complex Stored Procedures, triggers and appropriate User defined functions.
• Migrated reports from Business Objects to Tableau 8.
• Worked on Framework Manager Models Relational DMR for Standard Reporting and Adhoc Analysis
• Validated the Data Loads in the Cube using Analysis Studio
• Developed numerous multi tab multi page dashboard reports based on the existing remedy database incident management system with drill through functionality to the detail reports.

Environment: Tableau Desktop/Server 6.x, Business Objects, SQL Server 2008, SQL Server Management Studio, Oracle11g, DB2, Clear Case, Excel, Linux.

Confidential

Oracle DBA/Data Technician

Responsibilities:

• Creation of roles, privileges, profiles policies for group of users and assigns roles to proper end users.
• Perform daily routine dba tasks. Managing tablespace, data files, reading alert performance tuning using reports with 3rd party software.
• Controlling and monitoring user access to the database.
• Creation and management of multiple instances for testing and development.
• Take care and troubleshoot, if any problem occurs in computer labs, making sure all the computers are in running condition and all of the hosts have live connection to DB.
• Tuned theoraclememory structure (Buffer cache, library cache, Shared spool, sort area).
• Implementation of Database Monitoring scripts to monitor the Space usage of various tablespaces, Memory tuning, I/O and network traffic.
• Have performed Oracle RAC & ASM Admin/Installation.
• Created, upgraded, and clonedOracledatabases for Development and testing environments.
• Tested database performance issues (monitoring and tuning) to ensure database optimization.
• Implemented RAC and Physical Standby databases for High availability and disaster recovery.
• Performance monitoring using explain Plan, STATS PACK, AWR, ADDM, and Oracle Enterprise Manager.
• Implemented Oracle database backup & recovery solutions using RMAN as well as conventional backup methods.
• Retrofitted HR and Payroll based on new requirements and customizations.
• Worked on Data Mover Scripts (DMS Scripts) on HR and Benefits tables to validate in different environments
• Worked on PeopleSoft Security by creating and testing user roles and permission list.
• Identify gaps in business processes not met by delivered solutions in PeopleSoft HCM 8.8 system.

Confidential

Oracle Database Administrator/OBIEE developer

Responsibilities:

• Performed Database Performance Tuning and Monitoring of Databases.
• Designed and implemented Security Policies.
• Configuring the Auditing of database at DB or OS level, to monitor illegal use of database.
• Utilized Oracle Export and Import utilities to perform logical database backup and recovery, to move Oracle data from one machine, database or schemas to another and to detect database corruption
• Controlling and monitoring user access to the database.
• Used File Transfer Protocol to transfer files from one location to another on local disks and across the Internet.
• Created schemas with partitioned external tables for a production environment, using SQL Plus.
• Using Hints in Select Statements for Best Execution Plans. (After gathering statistics through Explain Plan, Analyzing the Table, Indexes).
• Configured the database for maximization of disk space utilization and memory utilization and minimizing the disk I/O to make the application faster.
• Administered Oracle 9i and Infrastructure support using Oracle OEM.
• Performed requirement analysis, capacity planning for databases and system infrastructure.
• Populated Oracle tables with data from external and non- oracle files using SQL*Loader utility.
• Used Stored Procedures for performing complex business logic involving database access and for validating information.
• Support the database with logical backup as well as cold and hot backups.
• Design variety of Triggers for object create, alter, drop, server errors, startup/shutdown and for logon/logoff.
• Built Databases and refreshed them by executing the scripts.
• Developed shell scripts for day to day database administration activities.
• Developed validation procedures and error reporting on the data in the intermediate tables.
• Written SQL Loader Scripts for data extraction and transformation.