We provide IT Staff Augmentation Services!

Tableau/sql Developer Resume

Nyc, NY

SUMMARY

  • Highly motivated Professional almost 8 Years of experience in IT includes extensive Functional and Technical experience in Business Intelligence (BI) product development and Reports Generation Experience translating business needs into long - term business intelligence solutions with the Power BI, Business Objects, Crystal Report, Tableau and MS SQL Server platform with SSIS, SSAS and SSRS.
  • Almost 8 years of experience in RDBMS technologies like SQL Server, MySQL and PL/SQL
  • Highly effective Reports Developer with 5 years of experience in Business Intelligence tools like Tableau, Microstrategy, OBIEE, Power BI, Qlikview
  • Worked with end users and business analysts to understand business requirements, recommended technical solutions and documented functional requirements
  • Experience in Extracting, Transforming and Loading (ETL) data flow among different source and destination files formats
  • Experienced in SQL Server 2008, 2012 and 2014
  • Experienced with the Software Development Life Cycle (SDLC) process - performing detailed analysis, collecting business requirements, Design, Development & implementation
  • Worked with T-SQL, DDL and DML Scripts, Joins and established relationships between tables using Primary Keys and Foreign Keys
  • Experienced in MSBI using Business Intelligence Development Studio (BIDS) and SQL Server Development Tools (SSDT) to create packages SSIS and SSRS
  • Extensive experience in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)
  • Proficient in writing complex SQL queries, scripts in Python & automating the data pulling from multiple sources by creating Alteryx ETL workflows
  • Expertise in Microsoft Azure Cloud Services ( PaaS & IaaS ), Application Insights, Document DB, Internet of Things (IoT), Azure Monitoring, Key Vault, Visual Studio Online (VSO) and SQL Azure.
  • Expert in Normalization, Data Conversion, and Data Modeling, Multi-Dimensional Modeling and involved in the creation Dimension Tables, Fact Tables, Star Schema and Snowflake dimensional schema using Erwin Tool and Visual Paradigm
  • Used Alteryx for Data Blending and Analytics.
  • Expertise in creating complex SSIS and DTS packages for ETL purposes
  • Used advanced concepts of SQL including Joins, Sub Queries, Set Operators, Tables, Views, Indexes, T-SQL & PL/SQL Stored Procedures, Triggers, Functions, Packages, Cursors, Exceptions and Dynamic SQL
  • Expert in Database Designing/Modeling for new applications (OLTP & OLAP systems) and Database changes to existing applications
  • Experience in using Tableau functions (Logical, Number, String, Type Conversions, and Table Calculation, LOD) when creating the calculated fields
  • Expert in creating, configuring and fine-tuning ETL workflows designed in Server Integration Services (SSIS)
  • Experience in integrating data as per the requirement from multiple databases like Oracle, DB2 etc (Excel, CSV, flat file, etc.) by using multiple transformations provided by SSIS
  • Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables
  • Strong in Analyzing Business Specifications and in developing appropriate Test Plans, Test Scripts and Test Cases based on customized needs
  • Extensive experience on building dashboards in Tableau and Involved in Performance tuning of reports and resolving issues within Tableau Server and Reports.
  • Proficient in Database performance optimization, debugging and tuning using the Query Analyzer, SQL Profiler and SQL Server Debugger
  • Knowledge of NoSQL databases like MongoDb and Cassandra
  • Excellent verbal and written communication skills with a strong focus on customer facing interaction, customer service, and presentation
  • Ability to work excellently as an individual and also as a proactive team member with minimum amount of supervision
  • An excellent Inter-personal skill with ability to develop creative solutions for challenging client needs using design pattern

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, TSQL

Data Modeling: MS Visio, Visual Paradigm

Databases: MS SQL Server 2014/2012/2008/2005/, Oracle 11g/10g/9i/8i, MS Access, MySQL

BI Tools: Tableau 9x, 10x (Desktop, Server, Reader), Business Intelligence Development Studio (SSIS/SSRS), Web intelligence, Xcelsius 2008 and Crystal Reports 2008 XI, Microstrategy, Cognos and DTS Import/Export, Splunk

Project Management Tools: JIRA, SharePoint, Team Foundation Server, Pivotal

ETL Tools: SQL Server Integration Services (SSIS), Informatica Power Center 7/8, Data Stage

Operating Systems: Linux, Windows, Mac OS X, Android, iOS

NoSql dbs: MongoDb, Cassandra

PROFESSIONAL EXPERIENCE:

Confidential, NYC, NY

Tableau/SQL Developer

  • Extensively worked on querying and debugging SQL scripts including DDL, DML & TCL commands
  • Created stored procedures, table valued functions, triggers and views using base tables
  • Involve in Planning, Defining and Designing data based on business requirements and provide documentation
  • Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports
  • Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business 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
  • Used various dashboard objects like horizontal, vertical, text, image and webpage to integrate all the worksheets together
  • Building, publishing customized interactive reports and dashboards, report scheduling on Tableau server
  • Implement action filters, parameters, calculated filed and set for preparing dashboards and worksheets in Tableau
  • Developed Tableau Data Extracts for dashboards by creating ETL workflows in Alteryx from multiple data sources and customized data
  • Create Tableau scorecards, dashboards using Stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality
  • Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps
  • Accomplished reports deadlines assigned in Workfront and uploaded in Box

Environment: Tableau Desktop 10.x,Tableau Server 10.x, SSRS, SSIS, Alteryx, Oracle 11g, Microsoft Excel 2010, MS Access, Microsoft office 2010

Confidential, Secaucus, NJ

MSBI/Tableau Developer

  • Used SQL Server Reporting Services (SSRS) for all reporting purposes, creation of new and modification of existing reports
  • Developed rich interactive graphics and data visualizations of large structured data in browser-friendly formats.
  • Gathered functional and non-functional client requirements in order to optimize the design of BI deliverables (reports, dashboards, alerts, visualizations).
  • Planned, Defined and Designed data based on business requirement and provided documentation
  • Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Tabular, Matrix, Drill Down, Drill Through and web reporting by customizing URL Access
  • Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by Using SSRS
  • Created new Data source and replaced with existed Data source. Created Schedules and Extracted the data into Tableau Data Engine.
  • 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.
  • Moderate and contribute to the support forums (specific to Azure Networking, Azure Virtual Machines, Azure Active Directory, Azure Storage ) for Microsoft Developers Network including Partners and MVP
  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
  • Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
  • Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps
  • Effectively used data blending feature in tableau. Defined best practices for Tableau report development.
  • Generated parameterized reports, sub reports, tabular reports using SSRS 2012
  • Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2012
  • Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS in Business Intelligence Development Studio
  • Created various SSRS Reports involving variety of features like Charts, Filters, Sub-Reports, Multi-valued parameters and also understanding of the tablix control and Dashboard reporting, Share Point with Power View tool etc

Environment: Tableau Desktop 9.x, SSRS, SSIS, Tableau Server, Oracle SQL Database, Informatica, Azure Cloud, PL/SQL, MS-Access, Agile, MS Excel, Business Objects, Salesforce, Microstrategy, Javascript API, Supply Chain

Confidential, San Francisco, CA

MSBI/Tableau Developer

  • Actively participated in interaction with users, team lead, DBA and technical manager to fully understand the requirements of the system
  • Scheduled Complex Stored Procedures using SQL Server Agent
  • Monitored and modified Performance using execution plans and Index tuning
  • Involved in project planning, also schedule for database module with project managers
  • Responsible for writing T-SQL code for creating cursor and handling data validations
  • Designed and Developed Database Objects like Tables, Stored Procedures, Triggers, Rules, Defaults, user defined data types and functions for the project
  • Developed, tested and implemented Referential Integrity rules and regulations through constraints, triggers and views, partitioned views
  • Administered user, user groups, and scheduled instances for reports in Tableau Server.
  • Involved in license management SLA's with Tableau support.
  • Performed super user trainings in Basic and Advanced Tableau Desktop. Participated and organized various super user symposiums to promote the usage of Tableau.
  • Created dashboards by using Alteryx and drive time calculations by using it.
  • Defined best practices for Tableau report development
  • Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio
  • Created SSIS Packages user data from the Flat files on monthly and weekly basis
  • Created Database objects views, and functions and developing procedures for implementing application functionality at the database side for performance improvement
  • Defined constraints, rules and defaults and developed SQL scripts to Insert/Update and Delete data in MS SQL database tables
  • Created views as required by front end developer for easier implementations on web pages, and triggers on those views to provide efficient data manipulation
  • Created reports using SQL Server 20012(SSRS) and integrated into the web front end
  • Involved in generating Matrix reports, Sub reports and complex reports with multi value parameters for the analysis of Performance

Environment: SQL Server 2008 R2 Enterprise Edition, Tableau Server, Tableau Desktop, SSIS, SSRS, MS Project, MS Access 2003, Oracle, SharePoint, PL/SQL, C#, Visual Studio 2008 & 2005, MS Visio 2007.

Confidential, Burlingame, CA

SQL Database Developer

  • Writing queries for retrieving data from the database
  • Developed solutions for ETL systems, data models, and reports
  • Experience in writing complex stored procedures, user defined functions, triggers, views and indexes
  • Efficient in creating joins and sub-queries for complex queries involving multiple tables
  • Worked with different teams such as DBAs and Data owners during the business rules and data validation process
  • Experienced in creating SSIS package to extract and load data from the different sources and destination
  • Worked on creating ad hoc reports creating and running SQL queries and providing reports out to different departments in Excel and Access
  • Gathered requirements to identify and create database objects such as tables, views, triggers and indexes
  • Involved in Normalization of the database and bringing it to 3NF
  • Involved in creating the constraints, rules, defaults and triggers to maintain the data and referential integrity
  • Created ER diagrams using Visio
  • Created Views to enforce security and data customization
  • Created Non-Clustered indexes to improve query performance and query optimization
  • Involved in the performance tuning and optimization of T-SQL queries
  • Created Stored Procedures for commonly used complex queries involving join and union of multiple tables

Confidential

Data Analyst

  • Involved in the entire project lifecycle and communicated with the project teams
  • Designed and developed complex active reports and dashboards with various data visualizations using Tableau desktop on customer data.
  • Documented the Requirements for assigned projects and designed conceptual process models.
  • Developed the key indicators for appropriate tracking reports with graphical and written summations to help in quality improving initiatives.
  • Created interactive dashboards with views and actions, drill downs, trends, and created sets to show progress in the fields based on the success rate.
  • Provided better insights using Mark types and Mark properties for huge data sets and perform ad-hoc analysis to report the performance monthly and weekly
  • Designed the reports with user level security with best practices and different visualizations, built complex calculations using advanced functions.
  • Implemented the features of Tableau such as Data blending, Data extracts, Forecasting, Dashboard actions, calculations, views/dashboards, and statistical data analysis for end users.
  • Tested the SQL scripts to develop the reports, dashboards, scorecards, and handled the performance issues very effectively.
  • Published the developed dashboards, reports on to the Tableau Server allowing the end users to access and view the data from server.
  • Monitored the project performance to be on-time and on-budget with the assigned efforts for the satisfaction of the authorities.

Environment: Tableau 10.4, MS Access, MS Excel, MS-SQL Server, Oracle, SQL, PL/SQL, T-SQL, Microsoft office 2012

Hire Now