PROFESSIONAL SUMMARY:

• Highly Motivated BI developer with 7+ years of experience in solutions using Tableau, Power BI, SQL, and SSIS
• Programming experience in DDL, DML, DCL commands, stored procedure for various Business process applications.
• Responsible for documenting design documents, functional specifications and deployment documents, sharing operational metrics on the project to respective managers
• Created Dashboards for Sales, products and customer KPIs using Tableau 8, 9 and 10
• Developed Tableau workbooks to perform various yearly, quarterly and monthly analysis of the financial performance
• Use of heterogeneous sources to collect data such as SQL Server, Hadoop, flat files and excel files
• Created advanced charts, custom visualizations and complex calculated fields for worksheets and dashboards to represent the global and local performance of various products across various regions
• Developed high performance dashboards for what if analysis, score cards and metrics, drill down reports, interconnected charts for better overall view of the status of business
• Setting up user permissions, creating/modifying policies, rules, backups and schedules for data lifecycle and load balancing to ensure optimum performance Confidential all times
• Built Data integration solutions, workflow solutions and ETL (Extract - Transform-Load) solutions for Data warehouse using SSIS
• Working knowledge of Data marts, Operational data source (ODS), OLAP, dimensional data modeling, Star schema modeling, snow flake modeling for Facts and Dimension tables using analysis services
• Created Dashboards for inventory planning and forecasting, performance measurement
• Use of heterogeneous sources to collect data such as SQL Server, Oracle, Hadoop, Teradata, flat files and excel files
• Creating user filters, for tableau level and row level security to ensure secure access to the dashboard based on the user login using impersonation
• Performing data validation, data blending, use of SQL queries and creating empty extracts to transfer performance load on Tableau servers instead of Tableau desktop
• Use of filters, transformations, calculated fields, LODs, sets, groups and parameters
• Creating performance metrics, score cards, what if analysis, forecasting models based on in built and custom statistical analysis
• Creating custom maps and visualization to give a comprehensive view of the business across various regions and products/services
• Providing drill down functionality to all the maps, charts and other visualizations as well as making them interactive and applying filters across worksheets
• Creating story boards to deliver a complete picture of the status of business and compelling dashboards for actionable insights
• Managing server resources on Tableau Server by appropriating different amounts of resources to Vizql, Cache and Background servers
• Managing SSL, SAML authentication processes on Tableau Server
• Creating subscriptions and alerts for various levels of user groups for dashboard administration, alerts, and updated views
• Publishing Dashboards on the server, creating packaged workbooks
• Setting up permissions for various levels of user accessing the published Dashboards
• Scheduling updates of the Tableau dashboards on the Tableau server
• Interactive visual report created for quick digestible report summarizing company performance
• Use of parameters, transformations, custom visual charts
• Scheduling updates of the Power BI dashboards
• Creating and managing power bi gateways.
• Performed powerBI admin jobs in maintaining powerBI environment
• Setting up user permissions and data access privileges
• SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, Unique and similar
• Confidential -SQL Queries, sub queries, co-related sub queries, dynamic SQL queries and similar
• SQL Server - Stored procedures, triggers, user defined functions, views and cursors
• Merging data from heterogeneous sources such as SQL server, Oracle, excel, text files and similar

TECHNICAL KNOWLEDGE:

RDBMS: Microsoft SQL Server 2012/2008R2/2008/2005, Oracle

Programming: Confidential -SQL, PL/SQL, Dynamic SQL, Python

Databases: MS SQL Server, Hadoop/Hive, MS Access, Oracle 10g, Star Schema, Snowflake Schema, OLAP

BI Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Data tools, SQL Server Analysis Services(SSAS)

Reporting Tools: SSRS, Tableau Certified, Power BI, SAS visual analytics, SAT Visor

Tools: SQL Server Management Studio, SQL Server Data tools

Operating Systems: Windows 10, Windows 8.1, Windows 7, Windows 2000, Server 2003, Server 2008, Server 2012

Other tools: MS Office, MS Visio, MS Access

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, Georgia

BI developer

Responsibilities:

• Have worked as BI developer creating PowerBI reports and dashboards to Vice president of the organization.
• Built reports from scratch by taking the requirements from the director and project managers and generated meaningful dashboards and reports using PowerBI.
• Used Teradata SQL assistant to connect to Hive to bring the data from data lake and store them in local databases for daily usage.
• Worked as powerBI Administrator and managed the gateways and the network spaces in power BI pro.
• Created and maintained PowerBI gateways also performed scheduled refresh’s on daily, weekly and monthly basis based on the requirement
• Have created complex SQL queries, procedures & views to satisfy the business needs.
• Extensively worked with Hadoop Hive, HQL, Teradata SQL assistant, oracle, SSIS, SQL server and multiple different databases and tools to clean the data and generate reports from the customers data.
• Have Built and maintained unauthorized tethering project from scratch - this is a project that detects the unauthorized data users who does tethering using mobile hotspots through which company loses billions of dollars per annum.
• I have written a few complex SQL queries and procedures which will detect these users and will create a process to track them on regular basis and send them warning messages and in case if they would not change their behavior we used to suspend their services and in turn cancel their subscription.
• I alone used to handle this project along with this project I am involved in several other projects in which I acted as a developer, analyst, lead and took all kinds of challenges that came up my way.
• I have created multiple reports and dashboards to show the data usage by the customers based on the regions, zones and based on the price plans also several different factors.
• I have worked with the top-level management chain taking up their AD-HOC requests to resolve them using tools like PowerBI, tableau, SSIS, SQl server and satisfy their data needs.
• Created SSIS to clean the data and from multiple sources and store them in on premise databases.
• Worked extensively on PowerBI using multiple data sources like excel, sql server, oracle, Teradata, cloud, Vertica, flat files and also used Live and Import connection to build reports and dashboards.
• Used DAX, measures, filters, parameters, row level security and also used data modeling to create connections between tables using one to many and many to one relationship to establish connections between tables and make use of data efficiently.
• Used tableau to replicate the dashboards from the different data tools like griphana, Pivot charts also some of the powerBI reports from prepaid and postpaid teams.
• Worked on the customers call volume, network usage, billing information, plan details and many more details and created reports that are easy for the product owners to understand.
• Worked closely with the project managers and carefully gathered requirements and changes their business needs into requirements and then created useful reporting out of it.
• Have worked in network and reporting team where got great exposure to cellphone networking and courage, roaming, data usage, signal drops and spikes, throttling, tethering and many more useful information which made me built reports to specific department according to their usage and needs.

Environment: SSIS, SSAS, PowerBI, Excel, Sql server 2015, Teradata sql assistant 16, Hadoop Hive, Unix, Putty, Kerberos, ODBC & JDBC connectors, Oracle

Confidential, Houston, TX

Tableau- Developer

Responsibilities:

• Build the Tableau dashboards based on the data received from SAS & WMS cubes.
• Gathered data from different databases, data warehouses & cubes which we use inside the organization and visualize the data according to the Product Owner’s insights.
• Publish the dashboards and validate the data on weekly bases.
• Receive the updated data from SAS team, WMS and from SAT tool and validate the data and then publish to tableau server.
• Creating the PowerBI reports, dashboards based on the customer data and the data from WIB and
• SAT visor, CLOUD9, Qtools and several other data sources and share the dashboards with developers.
• Created dashboards on Tableau and PowerBI according to the client requirements.
• Created dashboards in SAS to replicate the social media data and make adjustments when required.
• Created PowerBI reports to build reports & dashboards from CPS Compass data and show reports that’s easy for the client to understand and published with other developers.
• Created dashboards in SAS and tableau depending on the requirement.
• Written SQL queries, procedures and triggers to pull the data from the databases and visualize it on tableau.
• Worked on SQL integration tool to pull the information from the database and transform the database according to the PO’s requirements.
• Build the dashboards using SAS tool and compare it with tableau dashboards to check the performance of both tools.
• Used several databases like WMS, SAS, SAT, Q-tools, Cloud9 and many other internal databases and data warehouses for organizations use.
• Used Amazon redshift to connect to tableau and use the data to build the dashboards and perform the analysis and validate the data.
• Also gathered social media data from sources like amazon, best buy, google and few other websites to understand the product quality and estimate the health of the laptops, desktops, Hard Drives, etc.
• Created dashboard on the customer call data and to track the frequency of the calls and do the service count based on the time frames and remove duplications.
• Created a dashboard from WIB to estimate the health of laptops, desktops, hard drives, monitors and all other HP products to give an estimated date on the failure.
• Track the performance life cycle of all HP products and the replacement products and maintain the most updated information of the product.
• Fix data issues and find the root cause by doing reverse engineering.
• Create and modify the database tables and make changes to the procedures and triggers upon requirement.
• Worked on DAAS tool for analysis service and to create dashboards from the results of this tool.

Environment: Tableau Desktop 10.5, Tableau server 10.5, SQL Server 2015, SAS, SAT Visor, DAAS, Amazon Redshift.

Confidential, Jacksonville, FL

BI Developer

Responsibilities:

• Creating dashboard for performance review of the sales team and products using multiple data sources
• Setting up new views and filters to get data from the Oracle DB
• Created database objects such as Tables, Procedures, Functions, Indexes and Views utilizing Confidential -SQL.
• Implemented DML scripts to perform modification tasks such as Insert, update and Delete data in database tables.
• Creating new tables in SQL Server to accommodate the reporting requirements
• Modifying existing stored procedures in SQL Server to accommodate business changes to take in the new hierarchy and add columns
• Creating ETL packages for the sales team to accommodate new tableau reports
• Setting up row level security through views and using data source filters in tableau when creating compensation estimators for the sales team
• Performing data validation and setting up best practices and procedures for data validation of Tableau reports
• Setting up best practices for data visualization, standardizing format and color schemes, security measures, and data extraction practices
• Published dashboards with appropriate user filters to ensure only authorized users have access to the reports
• Performing data validation, data blending, use of SQL queries and creating empty extracts to transfer performance load on Tableau servers instead of Tableau desktop
• Use of filters, transformations, calculated fields, LODs, sets, groups and parameters
• Creating performance metrics, score cards, what if analysis, forecasting models based on in built and custom statistical analysis
• Proficient in using SQL Server Integration Services (SSIS) to build Data Integration and Workflow Solutions, Extract, Transform and Load (ETL) solutions for Data warehousing applications.
• Proficient in usage of SSIS Control Flow items (For Each Loop, For Loop & Sequence container, execute package, execute SQL tasks, Script task, send mail task) and transformations (Conditional Split, Data Conversion lookup, Derived Column, Aggregate, Multicast). handled the extracts and data transformation Confidential the source level wherever needed
• Implemented checkpoint, logging, custom logging, and error handing utilizing event handlers and precedence constraints within SSIS packages.
• Constructed various OLAP cubes and performed data mining on the data with the fact table and the dimension utilizing SSAS.
• Designed and optimized SSAS cubes by creating partitions, aggregations, and defining appropriate storage modes.
• Transferred data between SQL Server and flat files utilizing BCP bulk utility and bulk insert
• Deployed and processed SSIS packages and SSRS reports weekly to update information (As per business logic) utilizing SQL Server agent and windows scheduler.
• Creating drill down reports, interactive graphs and visuals for a comprehensive report
• Write Confidential -SQL statements for retrieval of data and involved in performance tuning of Confidential -SQL.
• Created joins and sub-queries for complex queries involving multiple tables.
• Developed complex stored procedures, Confidential -SQL functions, Joins, triggers and views using SQL Server Management Studio.
• Exported and imported data from text files and Excel Confidential -SQL Server database using bulk copy insert and BCP utility.
• Maintaining database connections, ensuring smooth transfer of data, troubleshooting data errors such as formatting, data type errors and null values
• Joining tables from different database to create reports to cater to specific departments and their needs
• Connected Tableau online with share-point portal and setup auto-refresh feature.
• Generated and shared monthly claim status reports and trend forecasting dashboards on Tableau 9.3 online

Confidential, Aliso Viejo, CA

BI Developer

Responsibilities:

• Analyzed frequently executed queries and designed covering indexes to avoid bookmarks, keys, and RID lookups.
• Designed system requirement gathering documents based on extensive JRD and JAD sessions as per need.
• Utilized Azure cloud for migrating data from Microsoft Azure cloud platform to on-premises data servers.
• Implemented Dynamic SQL for user customizable queries to be answered by the SQL Server.
• Created Confidential -SQL scripts for ad hoc requests from Business Analysts and Management.
• Wrote stored procedures using dynamic SQL to populate data into temp tables from fact and dimensional tables for reporting purpose.
• Written and executed complex Confidential -SQL queries using SQL Server Management Studio for back end data validation testing.
• Responsible for pushing Tableau as major BI tool, setting up Tableau server in the organization
• Managing user activity permissions when sharing dashboards, limiting visibility to data, assigning roles in Tableau and Power BI dashboards
• Design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Pie-Charts, Heat Maps, Bubble Charts and Geographic Visualization according to the end user requirement.
• Constructed various OLAP cubes and performed data mining on the data with the fact table and the dimension utilizing SSAS.
• Designed and optimized SSAS cubes by creating partitions, aggregations, and defining appropriate storage modes.
• Extensively implemented system as well as User-Defined functions to enhance the functionality of Confidential -SQL code.
• Deployed reports and Power BI dashboards on the reports/SharePoint server; scheduled deployments with subscriptions.
• Used Excel sheet, flat files, MS SQL Server 2012, Oracle Server to generate Tableau ad-hoc reports.
• Created different type of Tableau reports including: histogram, Control charts, bar in bar, Donut charts and Pareto charts.
• Created Tableau story boards through Web data connector using XML data, REST APIs and internal web services.
• Conducted sessions for Tableau & Power users and created the documents for end user support.
• Managed user permissions, subscriptions and alerts on Tableau Server
• Fetched data from Azure SQL environment as source in Power BI environment.
• Converted many SQL Procedures and SSIS packages into Hadoop
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Migration of some ETL processes from Microsoft SQL Server to Hadoop utilizing pig as data pipe line for easy data manipulation
• Created Power Map in Power BI and maps in Tableau (heat and polygon report) for reporting purposes
• Maintenance and Scheduling of reports (Tabular reports, matrix reports) in Power BI and Tableau
• Created interactive dashboards in Power BI and Tableau with page level filters, contextual filters, and complex LODs
• Experienced in Developing Power BI Reports and Dashboards from multiple data sources using Data Blending.
• Created report snapshots and caches to improve performance, deployment, scheduling of reports.

Confidential

SQL/ETL Developer

Responsibilities:

• Collected business requirements from users and translated them as technical specs and design documents.
• Extensively utilized Confidential -SQL in constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Implemented views utilizing Confidential -SQL in development and production environment for SQL Server 2008 R2.
• Analyzed existing OLTP to locate and determine dimensions and facts for the OLAP database.
• Incorporated analyzing Confidential /SQL scripts which produce tables and relationships based on defined ER-Diagram.
• Shared the dashboards among multiple users in the group.
• Extensive knowledge on SSAS Tabular model.
• Experience in Designing, Creating, Deploying and Processing of Cubes using SSAS
• Adapted to defining d relationships and calculated members in SSAS and used MDX/DMX and DAX queries.
• Expertise in designing complex reports like Drill-Down Reports, Drill-Through Reports and Parameterized Reports using SQL Server Reporting Services (SSRS) based on client requirement
• Experience in integrating the SSRS reports into web applications using Report viewer control.
• Designed and developed different reports like Matrix and Tabular reports, Cascaded, Parameterized, and pie chart reports using SSRS.
• Involved in analyzing SQL queries to fetch data utilizing stored procedures and CTE to combine datasets for multiple applications in Confidential -SQL.
• Analyzed an ETL architecture for data migration from the OLTP to OLAP utilizing SSIS.
• Analyzed complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Analyzed SSIS Packages for ETL process to load and transform data from flat files to the data warehouse.
• Published Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.
• Formatted and extended SSRS reports with parameters within reports, multi-value parameters, expressions, and embedded functions.
• Designed and deployed ad-hoc, parameterized, drill down, and drill through reports with standard/data subscriptions.

Confidential

SQL Developer

Responsibilities:

• Created database objects such as Tables, Procedures, Functions, Indexes and Views utilizing Confidential -SQL.
• Implemented DML scripts to perform modification tasks such as Insert, update and Delete data in database tables.
• Extensively implemented system as well as User-Defined functions to enhance the functionality of Confidential -SQL code.
• Implemented Dynamic SQL for user customizable queries to be answered by the SQL Server.
• Created Confidential SQL scripts for ad hoc requests from Business Analysts and Management.
• Wrote stored procedures using dynamic SQL to populate data into temp tables from fact and dimensional tables for reporting purpose.
• Written and executed complex Confidential -SQL queries using SQL Server Management Studio for back end data validation testing.
• Actively involved in gathering and analyzing requirements.
• Implemented indexes, constraints and rules on tables for optimization of queries.
• Used SQL Server Agent to create jobs, SQL Mail, Alerts and SSIS Packages schedule.
• Created DTS Packages for migration of data between SQL Server and other databases like MS Access, MS Excel and Flat files.