SUMMARY:

• 9+ years of experience as BI Developer, Design Extensive focus on Data Warehouse and setting up MS BI, R, ETL, SQL Server / Databases Development and Staging Environments .
• 3.5+ years Tableau Developer, Tableau 10.5 to 9.1 developing and testing analytic and operational dashboards, Data Visualization , R - P rogramming Tableau Server Visual Analytics, BI , Power BI , Qlikview , Qlik Sense , Architecture and Management.
• Used DAX Data Analysis Expression for writing functions and to build formulas and expressions in powerBI
• DAX is powerfull in writing expressions and building reports
• Involved in requirement gathering/analysis, Design, Development, Testing and Production of Reporting and Analytics projects, Data Warehouse , implementation and maintenance of client server applications, providing Business Intelligence and OLAP solutions to Health Care, Insurance and Banking Sectors.
• Collaborate with other Business Users / IT in converting the Business data requirements to Tableau Visualizations and dashboards.
• Working on 1 million rows and 500 GB of data size in Big Query (Google Big Query) Extract Schedule, weekly Extracts scheduling & authentication R-Programming .
• DB : Relational, Columnar, in-Memory DBMS ; Multidimensional Cubes.
• Database replication, Alteryx file & system cloning, remote boot, connecting to Excel, Text Files and Databases using Tableau , Good Understanding of Tableau architecture & Server side concepts.
• Develop and follow established programming, data management , Change Management and SDLC processes and standards, including naming conventions, formatting and program structure
• Building Visual Analytics , Advance Chart/Graph Types using complex calculations . Led Sears’s migration from Tableau 9.0 to Tableau 10.0 Self learning Tableau 2018 .
• Authored Data Visualization Blog for Sears’s Information Analytics Team.
• Dashboards with Trends and Rate of Changes for members of Shop Your Way Program Optimized Tableau Workbooks for Targeted Interactions Analytics and Inventories.
• Improved performance of Operational Dashboards for Teradata -based Data Warehouse.
• Designed 30+ near-real-time monitoring Dashboards for Tableau Server.
• Optimized Data Extracts, Connections and data refreshes for corporate Tableau Server.
• Excellent T-SQL Developer skills including Stored Procedures, Indexed Views, User Defined Functions, Triggers, and Distributed Transactions Microsoft .Net .
• Knowledge in Job Scheduling, Replication , Performance Tuning , Normalization / De-normalization concepts, database design methodology.

TECHNICAL SKILLS:

BI Tools: Tableau, MSBI

ETL Tools: Microsoft SQL Server Integrated Services

Reporting Tools: Tableau 10.x/9.x/8.x/7.x, SSRS, Power BI

Database: SQL, Oracle, DB2, Teradata, SAS, T-SQL

Database GUI: Teradata, SQL Server, SQL assistant, SQL Developer, DB2

Methodologies: Waterfall, Agile

Programming Languages: SQL, Python, R, PL/SQL, HTML, Core Java

IDE s: Eclipse, jGrasp, PyCharm, Dream weaver, Rational Rose

Framework: Hadoop, Django, Flask

Software Packages: Microsoft Visio

PROFESSIONAL EXPERIENCE:

Confidential, Seattle, Washington

BI Developer

Responsibilities:

• Understand the Requirements and Functionality of the application from specifications
• Designing, developing, testing, and maintaining Tableau reports and dashboards based on user requirements.
• Used DAX Data Analysis Expression for writing functions and to build formulas and expressions in powerBI
• Working closely with business in creating dashboards based on the data from various Data sources .
• Utilizing Tableau server to publish and share the reports with the business users.
• Collaborated with the security team to develop various Tableau services.
• Involved in upgrading Tableau Versions.
• By using Tableau Server , providing row level securities to different users to access dashboards.
• Developing Tableau data visualization using Donut charts, Waterfall , Cross Map , Scatter Plots, Geographic Map, Pie Charts , Bar Charts, Dual axis, Triple axis, scorecards , dashboards using stack bars, scattered plots, Gantt charts and various other charts based on the business desired.
• Distributing Tableau reports using techniques like Packaged Workbooks, PDF to different user community.
• Creating New Schedule's and checking the task's daily on the server
• Maintaining server activities , user activity, and customized views on Server Analysis .
• Extracting data from databases like SAS, DB2, SQL server and Excel files for getting data to Tableau for creating various dashboards.
• Creating Business requirement documents and plans for creating dashboards .
• Creating Tableau scorecards , dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Expertise in understanding visual design principles like color, layouts, and graphics.
• Providing customer support to Tableau users.
• Provide guidance to developers and team members on Tableau development, dashboard usability, user experience design and design best practices.
• Expert level capability in Tableau calculations and applying complex, compound calculations to large, complex data sets.
• Strong report/dashboard design experience and passionate practitioner of effective data visualization.
• Implementing ETL best practices and optimizing ETL procedures so-as-to populate data warehouse schemas efficiently and reliably. Emphasis on reusability of ETL objects and procedures in-order-to facilitate ease of maintenance.
• Build various Excel power pivot reports for business users.
• Design & build SSIS ETL (Extract, Transform & Load) process load data from heterogeneous sources like DB2, flat files, SQL Server and to perform complex transformations to derive and load data in Dimension tables , granular and aggregated Fact tables for various SSRS and POWER VIEW , POWER BI reports.
• Implementing ETL best practices and optimizing ETL procedures so-as-to populate data warehouse schemas efficiently and reliably. Emphasis on reusability of ETL objects and procedures in-order-to facilitate ease of maintenance.
• Created multiple reports in SSRS and power BI/Pivot like:-
• Collection Effectiveness Report (to measure the effectiveness of existing collection process).
• Account Phases Report (to track the progress of customer accounts through various phases).
• MRC Final Resolution Report (to classify accounts after they are final/closed).
• Open AiLs by date (to display AiLs pending the longest).
• AiLs 360 Snapshot by Account or Meter (Display all relevant information for AiL accounts or meter).
• Design packages to re-run from point of failure and implement custom error handling.
• Conduct code walkthroughs / peer code reviews to verify that code is scalable, easily maintainable and meets company programming conventions / standards.
• Developed Power Pivot Reports in Excel 2013 by publishing them to SharePoint 2013 for providing ad-hoc reports according to client need.
• Developed data visualization reports and build dashboards using Microsoft Power BI
• Filter and Sorting Data using Power View in Excel 2013.
• Used Team Foundation Server (TFS) for version control, source control and reporting.
• Create a Calculated Column DAX Formula in Calculated Columns, Measures, and Row Filters.

Environment: Tableau Desktop 10, SQL Server 2008, SSIS, SSRS, Power BI, Excel, SAS, SQL Server, Salesforce, DB2, Excel, Access Database, CSV files, CDW, EDW, Windows 8.

Confidential

BI Developer

Responsibilities:

• Involved in gathering business requirements and designing functional Specifications for Tableau dashboards from Business users.
• Used DAX Data Analysis Expression for writing functions and to build formulas and expressions in powerBI
• Used DAX Data Analysis Expression for writing functions and to build formulas and expressions in powerBI
• Worked with business in gathering requirements from the existing reporting tool ( Business Objects ).
• Involved in preparing Functional Specifications, Technical Specifications, Testing Plans and other documentation as required by SDLC.
• Upgraded Tableau version 9.0 to Tableau version 9.1.
• Experienced with Tableau server infrastructure like publishing and row level securities.
• Creating dashboard from various data sources like Oracle, CSV and Excel files.
• Creating Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked on analyzing the requirements and the sources data. Worked on mapping document to map the required columns from the data sources.
• Created Maps to provide the count of providers in different geographic locations. Created drill down capability using the Action filters.
• Extracted raw data from an Oracle and used SAS to read it and run statistical analysis.
• Distributing Tableau reports using techniques like Packaged Workbooks, PDF to different user com-munity.
• Involved in identifying the gaps between Functional and Technical process and giving recommendations for the improvement of deliverable for the business users.
• Analyzed and created dashboards by using Business Objects.
• By using BO, created complex to simple hierarchical levels of reporting as per user requirements.
• Worked closely with the ETL team, to populate the data as per the reporting requirements.
• Providing customer support to Tableau users.
• Involved in writing complex queries using joins and sub-queries.
• Created SSIS packages to load the daily transactional data into the database.
• Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets and Load them into various SQL server tables using different transformations.
• Worked with the business analysts, architects and project manager to understand the new requirements and enhancements.
• Generated documentation of analysis, design, testing in all phases of development
• Working on the SSIS packages for new enhancements, fixes and development. Troubleshooting and managing the development solution provided by vendor.
• Support the existing data warehouse projects and carry out special requests to provide security for reports etc.
• Created SQL Server Reports using SSRS .
• Identified the data source and defined them to build the data source views in SSAS to build the cubes.
• Extract Transform Load (ETL) development using SQL Server 2005, SQL 2008 Integration Services (SSIS).
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.

Environment: Tableau 9.0/9.1, SSIS, SSRS, SSAS, SAS, BO XI R4.1, SQL Server 2005, Excel, CSV files, Windows 8.

Confidential, Fermont, CA

BI Developer

Responsibilities:

• Created and implemented Tableau best-practices on migrating and governing the dashboards in multiple environments
• Used DAX Data Analysis Expression for writing functions and to build formulas and expressions in powerBI
• Involved in upgrading the Tableau server from 8.0 to 8.3 versions and involved in maintaining the server heath by regularly taking care of backup and cleanup activities.
• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Created views/reports in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Worked closely with business power users to create reports/dashboards using tableau desktop.
• Designed and Developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
• 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.
• Created customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Collaborated with .NET developers to integrate the dashboards with .NET Framework.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from DB2 and MS Excel.
• Blended data from multiple databases into one report by selecting primary key's from each database for data validation.
• Involved in the migration of OBIEE reports to Tableau and created better visualization in tableau as per the business requirements.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/extract dynamic and static datasets.
• Hands on development of analytics dashboards and working with complex data sets.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• 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.
• By using Tableau server , providing row level securities to different users.
• Working on analyzing the existing BI infrastructure and coordinating with various teams to install and configure single node Tableau server environment.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.

Environment: Tableau Server, Tableau Desktop 8.x, Oracle, DB2, Excel, OBIEE, Windows 2008 R2, .NET, Web API.

Confidential, Tampa, Florida

BI Developer

Responsibilities:

• Gathered user requirements, draft specifications design and create Database objects for performance tuning.
• Developed SSIS packages for different tasks like data cleansing and standardizing, sorting, conditional split, back up and involved in scheduling of SSIS packages
• Involved in Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous systems using SQL tools (SSIS, Bulk Insert)
• Worked on Error Handling and Logging in SSIS packages.
• Created configuration table to set the properties of the objects of SSIS packages at runtime.
• Implemented best practices for performance tuning of SSIS packages
• Involved in error handling of SSIS packages by evaluating error logs
• Successfully extracted transformed and load data into data warehouse.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
• Created tabular, matrix, chart, drill down reports, parametric, cascaded reports and dashboards and score cards reports (SSRS) according to business requirement.
• Created reports by dragging data from cube.
• Worked with T-SQL to create Tables, Views, and stored Procedures.
• Reviewed many T-SQL issues using management studio for better performance.
• Developed stored procedures, triggers and functions and added / changed tables for data extraction and transformation, and data loading using T-SQL statements
• Wrote T-SQL queries, Stored Procedures and used them to build packages.
• Used SSIS 2008 to create ETL packages to validate, extract, transform and load data to data warehouse, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Improved the performance of long running views and stored procedures.
• Improved performance by adding indexes, removing unnecessary columns in the inner views and adding conditions to get only required data.
• Identified slow performing views, stored procedures and queries using SQL Profiler, by running simultaneously while browsing the application.
• Tuned the queries using Execution plan, to get index seek from table scan and index scan.
• Created Database objects including Tables, Views and Stored Procedures.
• Developed User defined functions, stored procedures, and indexes.

Environment: SQL Server 2008, SQL Server Management Studio (SSMS), T-SQL, SQL Server Integration Services (SSIS), SQL Server reporting services (SSRS), SQL Server Analysis Services (SSAS), MS Excel, SQL Profiler.

Confidential

BI Developer

Responsibilities:

• Involved with Business Analysts team in requirements gathering and defined detailed Technical Specification documents.
• Used DAX Data Analysis Expression for writing functions and to build formulas and expressions in powerBI
• Translated business needs into data modelling initiatives.
• Developed visualizations using sets, Parameters, Dynamic sorting, Filtering, Parameter driven analysis.
• Used Tableau features like Data blending, Extracts, Parameters, Filters Calculations, Context Filters, Hierarchies, and Actions Maps etc.
• Design and development of Tableau visualization solutions using operational dashboards.
• Expertise in understanding visual design principles like colour, layouts, and graphics.
• Created Relationships, actions, calculated fields, sorting, groupings, live connections, in-memory in both Tableau and Excel.
• Involved in preparing and executing SQL code deployments (DDL/DML) with application rollout teams into QA/Production environments.
• Created Tables, Views, Constraints, Indexes and developed Complex database objects including Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL with exception handling
• Used SQL extensively by using Joins, Sub Queries, Set Operations, and Advanced OLAP Functions.

Environment: Tableau Desktop, Tableau Server, DB2, MS Excel.