SUMMARY

• Tableau Consultant with 7 years of total IT experience in full life cycle Development including the Requirement Gathering, Software Design, Integration, Implementation and Maintenance of Business Intelligence Solutions and Database Platforms and worked with Health care, Finance, Auto Mobile domains.
• Experience of 5 years in working and providing support with Agile development on designing complex visualizations using various tools such as Power BI, Tableau, Teradata, SAP BO, Crystal Reports.
• Experience in data extraction, analysis, modelling, migration, cleansing, transformation, Integration and loading using ETL tools.
• Experience in analyzing functional and technical specifications per business needs and analyzing the market trends.
• Experience in Performance Tuning and Optimization of the rendering time on the interactive visualization dashboards with In - Memory OLAP/OLTP processing.
• Hands-on experience on Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes using Key Performance Indicators (KPI's).
• Good knowledge on Data Blending operations in optimizing the performance of dashboard using the extracts.
• Expertise in Mapping workflows from source to target, generating customized analytical reports in a mixed work environment.
• Strong knowledge on Power BI to import data from various sources such as MySQL, Flat files and MS excel etc. to generate extensive reports and visualizations that give meaningful insights to the business.
• Experience in Implementation of Microsoft Business Intelligence (BI) platforms including SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) with good Knowledge on SQL Server Analysis Services (SSAS).
• Experienced in building Data Integration, Workflow Solutions, and Extract, Transform, and Load (ETL) solutions using SQL Server Integration Service (SSIS)
• Expertise in SQL Server Reporting Services (SSRS) with Report authoring, Report management, Report delivery and Report Security.
• Extensive working experience in usage of SSIS Control Flow items and Proficient in implementing all transformations available on the SSIS toolbox.
• Experience in enhancing and deploying SSIS Packages from development server to production server.
• Experience in working with various development tools such as Tableau, MySQL, Oracle, DB2, SQL Developer, MS Access, Excel, MS SQL Server and Relational Database Management System (RDBMS).
• Experience working with different Enterprise Data sources like PDF, Flat Files, SAP HANA, SSAS Cubes, Teradata, Hadoop and HDFS.
• Expert in writing complex SQL Statements and Validation of the output data.
• Experience in documenting reports, procedures, data definitions, understanding of dimensions, attributes and facts.
• Knowledge of Tableau Server Activities such as creating report schedules, data connections, projects, and groups.
• Knowledge in designing the reviews for the prototypes, and applications before the implementation.
• Experience in writing SQL Queries, dynamic-queries, sub-queries and complex joins for generating complex stored procedures, triggers, user-defined functions, views, normalization, constraints, keys, indexes, and cursors.
• Tuned Oracle queries for better performance. Optimized query performance by using oracle hints, forcing indexes, working with constraint-based loading and few other approaches.
• Supporting peers, stakeholders as Subject Matter Expert (SME) through troubleshooting and analysis of results.
• Possess excellent writing skills to develop/help in the development of documentation and other product deliverables.
• Highly motivated with the ability to work effectively in teams as well as independently and host presentations.

PROFESSIONAL EXPERIENCE

BI / Power BI Developer

Confidential, Raleigh, NC

Responsibilities:

• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for optimized performance.
• Developed and build the Reports, Dashboards and deployed into Power BI Service.
• Writing SQL queries, Created, Updated and joined SQL tables.
• Create a SQL script for the deployment of the package and schedule the job in SQL Server Agent and Tidal job
• Worked on all activities related to the development, implementation, administration and support of ETL processes.
• Published Power BI reports to Power BI server and scheduling the dataset to Automatic refresh using Gateways.
• Developed SQL queries using views, stored procedures, common table expressions (CTEs), and temporary table to support Power BI reports.
• Created and scheduled Various SQL Jobs, using SQL Server Agent to perform various tasks such as data loading
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Designed and deployed monthly sales reports for the business users using SSRS.
• Built SSIS packages to extract and integrate data coming from raw files and SQL Server database with error checking to staging database then to data warehouse.
• Build Data Sync job on Windows Azure to synchronize data from SQL 2012 databases to SQL Azure
• Experience Migrating the SSIS Packages to SQL Azure using Azure data factory.
• Develop new SSIS packages and modify the existing packages depending on the requirements to deliver flat files to the business on a weekly, Monthly and Annual basis.
• Build SSIS packages to transfer data between different data sources and perform other data transformations; scheduled same SSIS packages by developing corresponding job tasks.
• Manually create tags in Subversion (SVN) to store the scripts in the repository.

Power BI Developer

Confidential, Boston, MA

Responsibilities:

• Implemented acquisition processes to fetch the data from the desperate sources.
• Implemented the SQL queries to tune the data per requirements using the SQL Developer.
• Extracted data from Teradata Data Warehouses, SQL Servers to excel sheet, flat files, CSV files.
• Creating Row level security with power BI and integration with Power BI Service Portal
• Built analysis reports and visualizations using DAX functions like table function, aggregation function and iteration functions. Also, Developed Up-selling and cross-selling reports using DAX functions.
• Executed dashboard setups and data manipulation using DAX.
• Created scorecards, dashboards using stack bars, Gantt charts, filters, parameters, sets, bins and complex calculations to orchestrate the data.
• Used Power BI Gateways to keep the dashboards and reports up to date.
• Integrated custom visuals based on business requirements using power BI desktop.
• Converted all the existing operational excel reports into power BI reports.
• Used Power BI Gateways to keep the dashboards and reports up to date.
• Designed advanced LOD, Table Calculations, viz best practices to drive creation of insightful dashboards.
• Used Power BI, Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports.
• Published Power BI reports in the required originations and made the Power BI dashboards available in web clients and mobile apps.
• Tested dashboards using unit testing procedures to ensure data was satisfying the business needs.
• Created database objects like tables, views, procedures, triggers and functions to provide definition, structure and to maintain data efficiency.
• Expert in generating complex dashboard reports for ad hoc business views along with user acceptance test and data accuracy test.
• Involved in maintenance of ETL Packages in SSIS according to changing business requirements to support the existing ETL strategy.
• Worked on Data Transformation Services (DTS) in SSIS or transferring data from Heterogeneous Database
• Review and troubleshoot SSIS packages and T- SQL queries to address errors that occur during nightly and ad hoc processing.
• Enhanced the Reports by updating the embedded Scripts in SSRS to the Stored Procedures
• Created SSRS Reports: involving variety of features like Charts, Filters, Sub-Reports, Drill Down, Drill-Through, Multi-valued parameters Tablix control and also involved in Dashboard reporting, Share Point with Power View tool, TFS etc.
• Designed and created Report templates, bar graphs and pie charts based on the financial data using SSRS 2014.
• Created incremental refreshes for data sources on Tableau server.
• Coordinated, resolved database middleware issues with DBA's, and data warehouse issues with data architects.
• Interacting with the end users and gathering, documenting the requirements and suggesting them the capabilities.
• Maintaining the existing Tableau Supply Chain dashboards and optimize/streamline informational lining and feeds to implement new Tableau dashboards to support day to day decision making process.
• Worked on quickly turning around prototypes and incorporating feedback from users.

Environment: Tableau Desktop 9.0/8.0, Teradata 14.10, Oracle 11g, Power BI, Power BI Service Portal, MS SQL Server, SQL Developer, MS Visio, Toad, Agile Methodology, Windows 2010, MS Excel, MS Access, Flat Files, Data Architect, Power Designer, Visual Source Safe.

BI Developer

Confidential, Arlington, TX

Responsibilities:

• Involved in analysis, design and implementation of data warehousing servers like SQL Server, Oracle, IBM DB2, and Teradata.
• Design and development of various dashboards, reports utilizing Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization using actions, other local and global filters according to the end user requirement.
• Representing complex databases and data models in the form of pivot charts, tables, histograms using BI Tools.
• Developed Tableau workbooks and dashboards from multiple sources using data blending to perform year over year, year over quarter, quarter over quarter, YTD, QTD and MTD type of analysis.
• Created Tableau worksheet which involves schema importing, implementing the business logic by customization.
• Analyzed the metric dashboard reports and identified the formulas and functionality of the dashboard reports and digitized the metric dashboards.
• Combined views and logics into interactive dashboards using Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Worked with the SAP Universe cubes.
• Produce standard monthly reports using Tableau meeting the SLAs
• Performance tuning of reports by creating linked universes, joins, contexts, aliases for resolving loops and checked the integrity of the universes.
• Performed ETL using T- SQL by understanding weak business requirements to build working solutions.
• Published the dashboard reports to Tableau Server for navigating the developed dashboards in web.
• Managed the sites, defined extract schedule for previously published dashboards from Tableau Server on weekly basis.
• Resolved various performance issues and analyzed the best process distribution for different projects.
• Implemented requirement analysis, design, development, testing and production rollover of reporting projects in the Capital Markets according to the business trends and analysis.

Environment: SAP BO, Cognos, QlikView, Tableau, Teradata 14, Oracle 10g, MS SQL Server, Oracle, IBM DB2, SQL Developer, MS Visio, Toad, Agile Methodology, Windows 2008, MS Project, MS Excel, Erwin, Data Architect, Share Point.

BI/ SQL Developer

Confidential, Columbus, OH

Responsibilities:

• Design and create data visualizations as required to support user stories.
• Perform detailed data analysis to determine the structure, content, design, and quality of the data through examination of source systems and data samples.
• Used diverse data sources like excel sheet, MS SQL Server, Oracle Server to pull out the data.
• Define, execute and interpret complex/nested SQL queries to model/train the data.
• Generated dashboards with quick filters, parameters and sets to handle views more efficiently.
• Embedded various designed BI views into Share Point for presentations.
• Analyzed source data and handled large amount of data efficiently by modifying the data types.
• Generated context filters, sales with forecast and reference lines. and used performance actions.
• Generated combination MS Power Point slides presentations using various BI views designed to present to users.
• Support activities to document, evolve, and communicate artifacts developed using various BI Tools.
• Collaborating with other BI Analysts and Engineers around the table structures to optimize the views and other self-service needs.
• Documenting and communicating technical specifications to ensure that proper and optimized techniques, queries, and final deliverables are understood and incorporated into data and analytics processes.
• Handled admin activities for granting access to different users, and manage multiple designs and views.
• Assisting the organization with technical planning and implementation of BI Tools and Server upgrades.

Environment: Tableau Desktop 6, Cognos, QlikView, Crystal Report, SQL Server 2008, Oracle 10g, Share Point, MS Office Suite, Quality Center 9.2, Putty, MS Excel, MS PowerPivot, MS Power Point, Windows 2008, Front Page 2000.

Jr. Tableau Report Designer

Confidential

Responsibilities:

• Experienced 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 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.
• 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 parameters, customized calculations, sets, groups and filters for various analytical reports and dashboards.
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Developed User Business Requirement Document (BRD), Technical Requirement Specification and Functional Requirement Specification (FRS) using Requisite Pro, Rational Rose and MS Visio.
• Designed and developed Use Cases, Class Diagrams, Activity Diagrams, Sequence Diagrams and End to End Scenarios using UML.

Environment: Tableau Desktop 4, Rational Requisite Pro, Java, MS SQL Server, Rational Rose, MS Visio, MS Office, Requisite Pro, Putty, QTP.

Jr. SQL Server BI

Confidential

Responsibilities:

• Participated in Review Meeting for coordinating with the business, development and test team.
• Created Database objects such as tables, views, stored procedures, Triggers etc.
• Maintained referential integrity, domain integrity and column integrity by using the available options such as constraints etc.
• Experience using ER Win Data modeling tool to design and implement logical and physical models of various Relational Databases.
• Practiced Data Warehouse methodologies, including Dimensional Data Modelling, Star Schema, snowflake Schema, Fact and dimensions Tables.
• Wrote T- SQL queries for creating tables, stored procedures, views, Indexes, Triggers, User defined Functions, Relational database Models and data Integrity in observing Business Rules.
• Encapsulated frequently used SQL Statements into stored Procedures there by Reducing the Query execution time.
• Optimized the performance of Queries with modification in TSQL code, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and create Indexes wherever necessary.
• Worked on mapping documents creation as well as development for data migration, data import, initial and incremental load.
• Used SQL server integration services (SSIS) to build data integration and workflow solutions, Extract, Transform and Load (ETL) solutions for data warehouse applications.
• Create and optimized OLAP cubes by creating partitions, designing aggregations, KPI's, calculated members, defining proper attribute relationships and hierarchies.
• Generated complex reports like Drill- Down reports, Drill- Through Reports, Parameterized Reports, Sub Reports, Ad-hoc reports using SSRS based on client requirement.

Environment: SQL Developer, MS Office Suite, MS Visio, MS SQL Server 2005, SAP BO, Crystal Reports, Putty, Windows Vista.