Tableau Developer, MS SQL Server Developer Resume Dallas, TX - Hire IT People

SUMMARY

Over 6 years of experience in Information Technology primarily in Design, Development, Reporting & Data Visualization using Microsoft Business Intelligence tools & Tableau Data visualization tool.
Very strong experience in Requirement Analysis, designing, deploying Microsoft SQL Server Reporting Services (SSRS), ETL using SSIS & Tableau Recurring Reports.
Good at SQL Server, SQL, Visual Studio 2008, Tableau 8.2 Desktop Professional and Base SAS.
Good experience in building proof of concepts for the onshore team using Tableau and SSRS reports to enable ongoing reporting projects.
Experienced in building reports accessing live data/extract static data using Custom SQL in Tableau.
Have worked on creating numerous Dashboards uing Tableau 8.2 for call center site VPs and Service Delivery Managers on different KPIs & Call Center Metrics.
Good experience in creating SSIS packages using various Transformations in the Dataflow tasks.
Extensive experience in creating SQL Server Agent jobs using SQL Server 2008 R2.
Trained & helped setup a Team in Personal Investments business vertical by training them in Base SAS and helped them transition work from on - shore.

TECHNICAL SKILLS

Technical/Language Skills: SAS (Certified), SQL, Hyperion Intelligence Designer, MS Excel, VBA(Macro)

Databases: SQL Server 2005/2008 R2

Data Visualization: Tableau 8.2

ETL Tools: SSIS

Reporting Tools: SSRS, Tableau

Additional Skills: Statistics, VLSI Design, Data Structures & HTML.

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Tableau Developer, MS SQL Server Developer

Environment: SQL Server 2008 & Tableau Desktop/Reporting Server

Responsibilities:

Actively participated in interaction with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
Participated in identifying report migration from exiting KPI, Green Client, Metrics, SLA SSRS reports to potential Tableau reports.
Built POC on Tableau for the existing Self service reports and building the features present in them on Tableau.
Designed & Deployed Tableau dashboards using Where/Action filters, conditional formatting, calculated fields, geocoding for call center sites across US,etc
Created T-SQL scripts involving Joins, correlated and non correlated sub-queries for complex business queries involving multiple tables.
Created views to restrict access to data in tables for security.
Scheduled the monthly/weekly/daily reports to run automatically.
Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the Workplace Participant Services (WPS) tables from various source systems feeds using SSIS transformations such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union all, lookup.
Involved in Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality, Linked reports, Sub reports and Graphical presentations such as Charts and Dashboard type metrics using SSRS
Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.

Confidential

MS SQL Server Developer, SSRS

Environment: SQL Server 2005

Responsibilities:

Involved in generating different kinds of reports like Tabular, Drill-Down and Matrix reports using SSRS.
Ad-hoc reporting came in as tickets were expedited to the Chicago loan operations team by designing them in Excel by querying the data from SQL Server Databases.
Worked in Confidential group, where I queried (SQL Server 2005), designed and produced insightful reports for payment transactions that include unapplied funds, Posting Rejects, Non Post Report, Surveillance Report, and Auto-pay & ACH Report, which helped in identifying the stale funds.
Initiated exploratory data analysis on Loan Wash - General Ledger data reporting. Created dashboards from the processed data using SSRS and delivered any adhoc on GL using Excel.

We provide IT Staff Augmentation Services!

Tableau Developer, Ms Sql Server Developer Resume

Dallas, TX

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship