SUMMARY:

• 7 years of experience in supporting the development of analytics solutions leveraging tools like Tableau Desktop and Tableau Online and experience working with SQL, developing complex SQL queries, and leveraging SQL in Tableau.
• Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2016/2014/2012/2008 R2/2008/2005 in Development, Test and Production Environments with various business domains.
• Expert Knowledge of Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).
• Experience leveraging web traffic and consumer analytics tools such as Adobe Analytics, Google Analytics, Mixpanel, etc
• Experience in Design, Development, Integration, Implementation and Maintenance of Business Intelligence with related Database Platforms.
• Extensive Tableau Experience in Enterprise Environment and Tableau Experience including technical support, troubleshooting, report design and monitoring of system usage.
• Knowledge of best practices and principles for data visualization, dashboard and report design, marketing analytics, and data mining.
• Strong development experience with the Microsoft BI Stack - SQL-Server, SSIS, SSRS, SSAS, Power Pivot, Power BI for Office and SharePoint.
• Very Good Understanding and Experience in SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS)
• Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Experience in Analysing Execution Plan and managing indexes and troubleshooting deadlocks.
• Experience in Tuning SQL queries and T-SQL queries, MDX & improving the performance of the queries.
• Worked Extensively on ETL process using SSIS package.
• Experience in using variables, expressions and functions and also defining Query for generating drill down reports in SSRS.
• Experience in writing complex SQL queries involving multiple tables’ inner and outer joins, stored procedures.
• Demonstrated experience with Tableau Server, Informatica, ERwin, PowerBI and other BI applications
• Experience with Data warehouse design and development including logical and physical data modelling, mapping data elements from various data sources and loading DW objects including dimensions, hierarchies, fact tables, and aggregates.
• Understanding of Data Warehouse concepts
• Proficiency in data visualization, dashboard design and workflow Ability to translate requirements into sustainable and efficient visualizations and reporting Experience in creating complex formulas and calculations
• Dashboard performance tuning and optimization.
• Strong experience in design and development of building Tableau reports and dashboards.
• Knowledge on Alteryx transformations and experience in integrating with tableau for extracts.
• Having knowledge in designing Data Mart and Data Warehouse using Schemas cube.
• Developed formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, built- in/custom functions usage, multiple grouping reports in Tableau.
• Advanced Tableau experience from dashboard design and development.
• Expertise with use of action filters, user filters, advanced navigation techniques, Level-of-Detail (LOD) expressions.
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues.
• Involved in all stages of Software Development Life Cycle (SDLC)from analysis, design, development, testing, deployment and maintenance following Agile methodology.
• A strong foundation in Cloud Services, Network Security and Business Intelligence.
• Create and document software tools required by artists or other developers.
• Debug existing source code and polish feature sets.
• Extensive experience developing visualizations using Tableau Desktop and deploying those visualizations to Tableau Server using database platforms like Oracle, Sybase, SQL Server and User Level Security.
• Experience in Tableau tools such as: Tableau Desktop Professional and Tableau Server.
• Strong Analytical skills and attention to detail.
• Strong SQL writing Skills for developing SQL scripts and database platforms like Oracle, Sybase, SQL Server.
• Knowledge of data modelling concepts.
• Demonstrated ability to work in an agile environment working effectively in a team setting, and drive projects forward within a team setting.
• Excellent communication skills and a proven ability to present technical information to both a technical/non-E technical audience.

TECHNICAL SKILLS:

Operating Systems: Windows XP, Windows 7/10

Specialties: Data Visualization, Business Intelligence (BI), Software Management, Data Blending.

Languages: SQL, PL/SQL, JSON, HTML,CSS, Bootstrap

BI Tools: Tableau Desktop/Reader/Public/Server, Qlikview, PowerBI

Data Bases: Oracle 11g/10g, MS SQL Server 2016/2014/2 /2000 , MS Access, Oracle 9i/8i/11g, Teradata, Snowflake

Document Management: SharePoint

Dimensional Data Modelling, Multi: dimensional modelling, Snowflake/Star Schema

Others: MS Word, Excel, Visual Studio, Astah, Rational rose, Notepad++

WORK EXPERIENCE:

Senior SQL BI/Tableau Developer

Confidential, Plano, TX

Responsibilities:

• Works closely with BI subject matter experts and developers to implement best practices for designing, developing and deploying applications in a multi-tenancy environment.
• Assists with application installations, upgrades, and migrations within virtualized environments
• Researches and assists with scaling new data analytics products within the department including, but not limited to R Studio Server, Tableau, and Microsoft Power BI.
• Supports the development, maintenance and configuration of reports/dashboards within Oracle Business Intelligence Enterprise Edition (OBIEE).
• Creating SSIS packages using proper control and data flow elements improving the performance of the package run time and unit test the developed packages as an ETL developer.
• Work on ETL process using Microsoft SQL Server Integration Services (SSIS) process to provide the data quality, data cleansing, business rule transformations, and data loading, support the data loads and transformations using SSIS for the iterative conversion project.
• Involved in migration from SQL Server 2008R2 to Oracle databases using SSIS on CSS Conversion Project.
• Develops and maintains basic workflows, mappings, and sessions within Informatica Power Centre
• Create necessary documentation for all charts and dashboards using multiple data sources
• Write, interpret, and optimize complex queries working with large sets of data
• Develop and maintain tableau visualizations and reports
• Develop ad-hoc Business Objects Web Intelligence Reports
• Developed Packages to Load data from MS SQL server to Oracle Destinations and in the flow created new SSIS packages according to the requirement for the fields.
• Troubleshooting the issues on the SSIS packages.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Provided production support for Tableau users.
• Working on tuning SQL queries and T-SQL according to the desired output.
• Worked on ETL process in SSIS packages and also improved the progress time. Used all different transformations required
• Worked at conceptual/logical/physical data model level using Erwin according to requirements.
• By using cached mode in Tabular Models, integrate data from multiple sources including relational databases, data feeds; excel files and flat text files
• Conduct extensive quality control and record-keeping procedures to ensure the highest levels of data integrity.
• Manage and track end-user requests and troubleshoot Tableau issues.
• Provide best practices in data visualization and business intelligence software, including recent versions of Tableau.
• Provide automation for Tableau dashboards functional and performance testing.
• Works with end users, the team's analysts, technical staff, and project team members to plan, design, develop, implement, and enhance business analytics capabilities using Tableau’s Business Intelligence tools.

Environment: Tableau Desktop 2018.3, Teradata SQL Assistant, Tableau Server, MS Excel, MS SQL Server 2012, SSRS 2012 -MS SQL Server Reporting Services (SSRS), T-SQL, PL-SQL, Oracle SQL Server, SQL Server Integration Services (SSIS).

MS SQL Server BI Developer (SSIS/SSRS/SSAS)

Confidential, Richardson, TX

Responsibilities:

• Created Rich Graphic visualization/dashboards to enable a fast read on claims and key business drivers and to direct attention to key area
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Report creation skills using Microsoft SQL Server 2014 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Created SQL Server Reports based on the requirements using SSRS 2012,2014
• Involved in analysis of Report design requirements and actively participated and interacted with Team Lead, Technical Manager and Lead Business Analyst to understand the Business requirements.
• Migrated DTS packages from SQL Server 2008R2 to SQL Server 2012 as SSIS packages.
• Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2008R2/2008 (SSAS)
• Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Troubleshooting performance issues and fine-tuning queries and stored procedures
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
• Created complex reports which involve more number of groupings and multi-value parameters
• Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining, Data modelling and Architecture.
• Created multiple reports with drop down menu option having complex groupings within the report.
• Published Dashboards onto Tableau Server and from there consumers would choose viewing medium (laptop, pc, iPad)
• Create Parameterized SSRS Reports and PowerPivot Workbooks using data of Tabular model and Cube data model to prove the functionality of database
• Rendering the reports to PDF formats as per the requirement and printing all the reports in a batch process for Monthly Statements.
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyse performance of Strategic Business Units as well as corporate centres
• Construct and maintain an appropriate, scalable, and easy-to-use infrastructure with Tableau to support the development of actionable reports used in decision-making across the org.
• Develop and maintain Business Intelligence reports, dashboards, cubes, and scorecards to deliver information requests and deepen the analytics capabilities of operations, fiscal, and administrative staff.
• Create and/or perform peer review of Business Intelligence reports or ETL code from other analysts and programmers to ensure that all code and reports conform to the org and team's standards and guidelines.
• Migrate Business Intelligence artefact changes between development, test,, and production environments and maintain a proper development cycle.

Environment: Tableau Desktop 10.3, Tableau Server 10.3, Teradata SQL, SQL Server Analysis services (SSAS), MS SQL Server Reporting Services (SSRS) T-SQL, SQL Server Integration Services (SSIS), Power BI, SharePoint, Tabular Models, Data Modelling DTS, SQL Profiler, Erwin VB SCRIPT, OLAP, OLTP, Erwin, Performance Point Sever, Office-2007, MS Excel, C#.NET,VB Script ProClarity Analysis, Power Pivot, Erwin, Python, Snowflake.

MS SQL Server BI/ Data warehouse Developer

Confidential, MO

Responsibilities:

• Develop dashboards in Tableau Desktop and published them on to Tableau Server that allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.
• Worked closely with all teams within the organization to understand business processes, gather requirements, understand complexities and end goals to come up with the best plan of execution.
• Schedule 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
• Worked with Business Analysts and Business users to understand the user requirements, layout of developed applications
• Created various types of charts like Heat Maps, Geo coding, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet Graphs and Histograms in Table Desktop to provide better data visualization.
• Created interactive dashboard and applied actions like filter, highlight and URL to dashboard.
• Developed and reviewed custom SQL queries with use of joins clauses (inner, left, right, full) in Tableau desktop to validate and reconcile data.
• Using Custom SQL for joining the tables and selecting the required Data.
• Involved in new KPI generation for Scorecards.
• Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data
• Took backup of the Tableau server on regular basis by using Tab cmd, Tab admin commands also developed restoration procedures to restore the server during system failures.
• Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards.
• 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 quick filters to filter needed information.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.

Environment : Tableau Desktop v8/v9, Tableau server v8/v9, SQL Server, SSIS, Tabular Data models, Microsoft Business Intelligence Development Studio (BIDS), T-SQL, DTS, OLAP, MS office 2007.

Data Analyst

Confidential

Responsibilities:

• Gathering the requirements from the Business users and understanding the functionality & business rules.
• Responsible for documenting, Provide unit and Integration testing in a Banking project.
• End to end experience in designing, deploying data visualizations by creating dashboards, stories using Tableau based on data collected and data blending from MS Excel and CSV files along with MS SQL Server databases.
• Extract transform and loading data into data warehouse using Data Flow Task and Control flow task.
• Utilizing capabilities of Tableau such as Data extracts, Data blending, Forecasting, Dashboard actions, Table calculations & LODs.
• Deploying and scheduling Reports to generate all daily, weekly, monthly and quarterly Reports including current status.
• Developed and reviewed SQL queries with use of joins clauses (inner, left, right) for data validation.
• Created data joints and blending into one report through selecting primary keys from each database.
• Created SSIS packages to export/import data from various files to database.
• Generated different types of reports using SSRS.
• Highly Proficient in Agile, Test Driven, Iterative software development life cycle (SDLC) and ETL analytics.
• Test and validate Cubes, ETL Packages and Reports to ensure accuracy and quality of data.
• Built, deployed cubes to Analysis services server and analysed data from SSMS by dragging and dropping.
• Remotely connected into end user computer and monitor Network Management System.
• Troubleshoot network issues, risk management and responded to events, alarms and trouble tickets.

Environment: Report Builder, SQL server 2016, SSIS, SSRS, Power BI, Tableau.

SQL/ETL Developer

Confidential

Responsibilities:

• Performed extensive data extraction from web and other sources and handled data preparation - missing values, formatting, transformations using SSIS.
• Written Stored Procedures and SQL scripts both in SQL Server and Oracle to implement business rules for various clients.
• Designed T-SQL scripts to identify long running queries and blocking sessions.
• Writing and Debugging T-SQL, stored procedures, Views and User Defined Functions.
• Data migration (import & export - BCP) from Text to SQL Server
• Error handling using Try-Catch Block
• Normalization and De-Normalization of tables
• Developed Backup and Restore scripts for SQL Server 2005
• Installed and Configured SQL Server 2005 with latest service packs.
• Created database objects like tables, views, indexes, stored-procedures, triggers, and user defined functions
• Written T-SQL queries for the retrieval of the data.
• Developed administrative tasks of SQL Server of performing daily Backups and Recovery procedures.
• Worked with the developing team in the Writing functions in Visual Basic 6.0 for Upload download functionality, Data transfer and migration.
• Prepared daily and weekly status reports and collaborated with other team members
• Created and managed schema objects such as tables, views, constraints, indexes, functions, procedures, and triggers and maintained Referential Integrity.
• Customized the stored procedures and database triggers to meet the changing business rules.
• Implemented indexes for performance tuning.
• Data loaded into the database using SSIS 2005 from flat files.

Environment: SQL Server 2005, SQL Server 2000, Oracle 9i, Visual Basic, Excel, Tableau.