SUMMARY:

• Working as BI Developer with Tableau & Power BI reporting tools with over 9 years of IT experience analysis, design, testing, development and implementation of client/server applications.
• Have extensive experience in sourcing, processing, managing, and distributing business - driven and actionable visual reports for key stakeholders in finance, retail, Health Care& insurance domain within omni-channel data-centered environments.
• Extensively worked on Tableau (Desktop, Perp and Server)
• Experience in gathering Requirement, Analysis, Design, Development, Deployment, Testing and Support of rich Interactive Dashboards and Workbooks using Tableau Desktop.
• Worked extensively in several projects in both OLAP and OLTP applications.
• Expertise in Power BI, Power BI Pro, Power BI Mobile . Expert in creating and developing Power BI Dashboards in to rich look.
• Strong experience in cleaning, analyzing and manipulating large dataset and combining multiple data sources from varies source systems: (Data Blending & Cross Database joins)
• Working experience in implementing and reporting of web analytics.
• Experience with the Microsoft BI Stack (SSRS, SSIS, SSAS) - experience with SSAS Analysis Services
• Microsoft Power BI experience (Power BI, Power Pivot, Power Query, Power View). Experience with SQL, T-SQL, MD DAX
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Translated business logic from one system (Excel, etc.) into Alteryx in a quick and accurate manner
• Apply design patterns to develop BI solutions for delivery on web and mobile devices such as tablets and smartphones.
• Experience in Tableau functionalities like Tableau Extracts, Cross Database joins, Parameters, Filters, Contexts, Data Source Filters, Actions, Functions, Sets, Groups, Calculations, Data Blending etc.
• Developed interactive Tableau dashboards and reports with advanced functions, LOD calculations, and extensions
• Experience with creating the Tableau dashboards with relational and multi - dimensional databases including Oracle, MySQL and HIVE, gathering and manipulating data from various sources
• Proficiency in agile, test-driven, iterative, scrum and Waterfall software development life cycle (SDLC)
• Strong experience in designing, developing and maintaining multi-dimensional database and relational model connections to the Informatica Developer Client Tool to import the parquet files and the relation tables.
• Experience in Performance Tuning of reports within Tableau Server and Tableau Dashboards
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of Dashboard Action, Data Source and Context Filters according to the end user requirement.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using Power BI. Good in Analytical thinking for translating data into informative visuals and reports.
• Created various User groups by assigning row and column level security at application level, folder level and user level.
• Experience in Installation, Configuration, Upgradation and Maintenance of Tableau Server as Admin
• Hand-on working experience in Machine learning algorithms and deep knowledge in Statistical Models using R and Python.
• Strong experience in SQL, T-SQL/PL SQL (DDL, DML, DCL and TCL) scripts for reporting, data analysis and ETL validations and to support Ad-hoc business requests.
• Strong experience in creating, testing and maintaining, Views, Triggers, User Defined Functions, Sub-Queries, CTEs, Stored Procedures, error handling, exception handlers and other objects
• Excellent communication skills, with strong analytical, troubleshooting and problem-solving abilities.

TECHNICAL SKILLS:

BI Tools: Tableau Desktop 9.3/10.3/2018.3/2019.2, Tableau Public, Tableau Reader, Tableau Server, QlikView, power BI

ETL Tools: Informatica, Microsoft SQL Server Integrated Services (SSIS), SSRS

Programming: SQL, UNIX Shell, XML, HTML, R, Python.

Utilities: MS Office Suite, MS SharePoint, MS Project

Databases: Oracle 10g/11g, DB2, Teradata, Cloudera Hadoop, SQL Server 2008 R2, MS Access, MS Excel, MS SQL Server 2005, AWS Redshift, Hive, Azure

Data Visualization: Tableau Desktop, Server, Online, Reader, version 8.x 9.x,10.x, PowerBI, Tiger Graph, SSRS, QlikView

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis, MN

BI Developer

Responsibilities:

• Developed Reports/Dashboards with different analytics views like Pivot table, Graph, Column Selector, and View Selector, Action links by using drill and local filters
• Analyzed data successfully and revealed wasteful practices to patient care which helped in bending the cost curve downward around 30%
• Designed Reports in SSRS and Power BI and published into Power BI report server.
• Installed and configured Enterprise gateway and Personal gateway in Power BI Services.
• Provided continued maintenance and development of bug fixes for the existing and new SSRS/Power BI Reports.
• Creates solutions and helps prepare test plans by having solid knowledge of data warehousing concepts, dimensional/cube data modeling techniques, including MDX and DAX scripting
• Design and build supporting framework for reporting utilizing Microsoft toolset: SQL Server, SQL Server Integration Services (SSIS), PowerPivot, Power View, SAS Tabular and DAX
• Experience setting up security for end users to access relational models and cubes
• Review Vendors Status Reports with Project Team and created visualization for budget forecasting.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Designed and created data extracts, supporting SSRS, POWER BI or other visualization tools reporting applications.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.
• Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change that have happened to ensure that the developed dashboards are displaying accurate and up-to-date live data and sent those into production after editing.

Environment: Power BI, SSIS, SSRS, Oracle SQL Server, MS Office Suite

Confidential, Seattle, WA

BI Developer

Responsibilities:

• Projected and forecasted future growth in terms of number of subscribers based on upgrading to LTE by developing Area Maps to show details on which states were connected the most.
• Responsible for development of Tableau reports in accordance with business requirements. Use multiple data sources like Salesforce, SAP, SQL Server, Oracle.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Synthesize analytical and modeling findings/insights to conceptualize and communicate key drivers and relationships between multiple data sets to support strategic decisions
• 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/dynamic and static datasets.
• 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.
• Developed SSIS packages using various Control and Data Flow items to Transform and Load Data using SSIS.
• 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.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Collaborate with development team on data approach for coding Understand data guidelines, and understand data sources available, what is new based on requirements, and how the project will impact common data stores
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.

Environment: Tableau Desktop 10.4/2018.3, SSIS, SSRS, Tableau Server, MS Office Suite, Oracle SQL Server R2, MS Excel

Confidential, Milpitas, CA

Sr.BI Developer

Responsibilities:

• Worked with Business lines to gather the requirements and document Business Requirement for carry out system design, gathering data sources and approach with optimal technical design.
• Develop and strategize methods where dashboard would allow users to understand and analyze data facts with real time attributes.
• Facilitated and Participated in regular Technical Reviews, Defect review and walkthrough meetings with important project & business stakeholders throughout the project life cycle and to meet S&C Standards.
• Created dashboards in Tableau/Power BI connecting to various sources like HANA, SQL Azure Cloud, SQL Server, Excel, Oracle and Snowflake, Amazon Redshift (AWS).
• Migrated Tableau Dashboards to GCP connecting data from Azure.
• Perform combine, shape and clean operations in Tableau Prep using filter, split, rename, pivot, join, union to clean and shape the data
• Created complex dashboard using parameters, sets, groups and calculations and drill down and drill up in worksheets and customization using filters and actions in tableau
• Developed 10+ interactive Tableau dashboards and reports with advanced functions, LOD calculations, and extensions
• Tuned Tableau report performance and decreased 70% of executing time by optimizing DataMart and writing stored procedures.
• Work with the Tableau Admin team to ensure the stability and performance of the Tableau Server
• Presented reports to internal stakeholders and trained users to have better utilization of the interactive dashboards
• Extensively involved in designing and developing the power BI Data models using multiple DAX expressions to build calculated columns and calculated measures.
• Supported team as a subject matter expert (SME) through troubleshooting and identified opportunities to solve business problems through BI
• Publish the Power BI Desktop models to Power BI Service to create highly informative dashboards, collaborate using workspaces, apps, and to get quick insights about datasets.
• Used Power Query to acquire data and Power BI desktop for designing rich visuals.
• Build compelling, robust, effective interactive dashboards in Tableau that answer key business questions.
• Created various User groups by assigning row and column level security at application level, folder level and user level.
• Creating web data connector for extracting the data from the URL for building the dashboards.
• Unit testing and the regression testing of the reports and the data formats for the discrepancies of the data.
• Creating the different project folders on the tableau server for the publishing dashboards for the different departments.
• Worked with Software Development Life Cycle, RDBMS, and Data Warehouse & Data Modeling concepts and acquired knowledge of in Informatica Power Center 8.6 9.1.
• Managing the sites and projects on the tableau server.
• Managing reports and solving the UI/UX defects on the reports.
• Used commands in Tabcmd and Tabadmin utility tool for Tableau Server maintains and configurations

Environment: SQL Server, Tableau Desktop and Server 2019.2, Power BI, Informatica, Alteryx

Confidential

MS SQL Server / Data Analyst

Responsibilities:

• Installed SQL server 2008R2 with latest service pack and established connectivity with the database, created, configured and maintained databases
• Created and handled maintenance plans for various tasks
• Maintained course addition and status update SSIS packages of daily feeds to source system via third party SQL server application
• Created packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Pivot, Union all etc.
• Created, tested and deployed SSIS packages for data migration into facts and dimensions tables in the Data Mart from the source data warehouse tables
• Developed complex SSIS packages using various tasks, containers, data transformation like fuzzy lookup, for each loop and for loop sequence container.
• Responsible for logical and physical data modeling, database design, star schema, data analysis, programming, documentation and implementation
• Created SSIS packages for incremental loading, slowly changing dimensions, data conversion, cleansing tasks
• Performed the tuning of existing ETL packages and reduced process time from 8 hours to approx.6 hours, a 25% gain in performance
• Defined report layouts for formatting the report design as per the need and identified and defined the data sets for report generation using SSRS 2008

Environment: MS SQL Server 2005/2008/2008 R2, SQL Server Reporting Services (SSRS) 2005/2008, SQL Server Integration Services (SSIS) 2005/2008, MS Office