We provide IT Staff Augmentation Services!

Sr. Sql Developer (ssrs And Tableau) Resume

Lewisville, TX

SUMMARY

  • 8 Years of IT experience primarily working with databases
  • Helping customers to solve their enterprise ETL and Reporting needs
  • Designed, developed custom reports, scorecards and dashboards using SSRS, SSAS and Tableau
  • Designed and developed reusable / scalable SSIS packages
  • Working knowledge of indexes, index management, and statistics
  • Ability to normalize and denormalize databases
  • Experience in managing very large databases of size up to 1.5 TB
  • Worked closely with developers to tune slow running queries
  • Testing backups to make sure we meet the business Recovery Time Objectives (RTO)
  • Making sure critical databases are backed up to meet the business Recovery Point Objectives (RPO)
  • Worked on Installations, upgrades, testing and deployments
  • Familiar with TSQL best practices and not so conflicting naming conventions
  • Capacity planning and support to 24X7 live Production environment
  • Created documentation for processes and procedures, data dictionaries and database diagrams
  • Familiar with Red Gate tools and other popular scripts written by SQL MVP's
  • Worked with and managed offshore teams
  • Active participant in local SQL server user community group (NTSSUG), attend PASS webinars
  • Volunteered to teach SQL Server concepts to business analysts and other job seekers
  • Well - organized professional with strong written and oral communication skills

PROFESSIONAL EXPERIENCE

Confidential, Lewisville, TX

Sr. SQL Developer (SSRS and Tableau)

Environment: MS SQL Server 2012, SSRS 2012, TFS, Red Gate Tools, Visual Studio 2015

Responsibilities:

  • Created and deployed new SSRS and Tableau reports
  • Tuned long running reports and long running queries
  • Gathering requirements from clients and creating user stories
  • Followed scrum to manage product development and to deliver user stories

Confidential, Houston, TX

SQL DBA / BI Developer

Environment: MS SQL Server 2014/2012/2008 , SSIS 2012, SSRS 2012, TFS, Red Gate Tools

Responsibilities:

  • Performing On Call 24X7 prod support for SQL Server 2012 environment
  • Tuning long running queries, resolving timeouts, dead locks and blocking issues
  • Created maintenance plan, database alerts and setup process failure notifications
  • Responsible for capacity planning and low disk space resolutions
  • Performed Installation of SQL 2014 and upgrade from SQL 2008/2012 to SQL 2014
  • Created reports and ETL solutions using SSRS 2012 and SSIS 2012

Confidential, Irving, Texas

SQL DBA / Report Developer

Environment: MS SQL Server 2012/2008R2/2008, SSIS 2008, SSRS 2008, Tableau 9.0, SSAS 2008, Teradata 13.0, TFS, SharePoint, Visio, Clear Quest, Hadoop 2.0

Responsibilities:

  • Ensuring all nightly backup jobs are successful
  • Monitoring success and failure of automated jobs
  • Work closely with developers to perform Query tuning
  • Handling user's permissions and disk space issues on Production server
  • Designed email notifications in case of job failures across all servers
  • Created over 20 reports using Tableau/SSRS/ SSAS cube based reports and maintained over 60 reports
  • Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots and Gantts
  • Prepared dashboards using calculations, parameters in Tableau
  • Created calculated fields, groups, sets and hierarchies and built formulas etc. in Tableau
  • Written MDX query’s to create datasets for both SSRS and SSAS reports

Confidential, Duluth, Georgia

SQL Developer

Environment: MS SQL Server 2008, SSIS 2008, Tableau 8.0, SSRS 2008, MDM, GnuPG Mail Manager LE (NCOA), Map Marker (Pitney Bowes)

Responsibilities:

  • Design, Modify, Deploy and Tuning of reports using SSRS and Tableau
  • Worked on Encrypting and Decrypting files on FTP and SMTP sites using GnuPG
  • Created a process to collect data from multiple sources to create a golden record using MDM
  • Designed SSIS packages to download files from FTP, unzip them, decrypt, then load them in to our tables and move the files to archiving folder

Confidential, Cincinnati, Ohio

SQL DBA / BI Developer

Environment: MS SQL Server 2005/ 2008, SSIS 2005, SSRS 2008, ColdFusion

Responsibilities:

  • Created Timeout Analysis reports to track down the root cause of the timeouts in the applications
  • Identified and worked towards minimizing blocks and deadlocks
  • Used sql profiler to track down slow running queries
  • Worked on optimizing and improving the performance of queries
  • Performed database backup and restore operations

Confidential, Foresthill, MD

Reporting & Integration Developer

Environment: MS SQL Server 2008, 2008 R2, SSRS 2008 R2, SVN Tortoise, JIRA Studio, Responsys

Responsibilities:

  • Used JIRA Studio to track progress and to create tickets
  • Followed Agile methodology
  • Created various kinds of reports including Parameterized reports, Linked reports, Ad hoc reports,

Confidential, Mequon, WI

ETL Developer

Environment: MS SQL Server 2008 R2, SSIS 2008, SSRS 2008, Team Foundation Server, Share Point Visual Studio 2008, SQL Prompt (Red Gate Tool), T-SQL, PL/SQL, Oracle 10g

Responsibilities:

  • Reviewed T-SQL code written by junior developers
  • Written Dynamic SQL, cursors, triggers, views and functions
  • Closely work with the client to come up with business requirements and Technical Design Document

Confidential, Marshfield, WI

SSIS Developer / Interface & Extract Developer

Environment: MS SQL Server 2008 R2, SSIS 2008, .NET, Team Foundation Server, Share Point Visual Studio 2008, SQL Prompt, QNXT product of Trizetto

Responsibilities:

  • Involved in error handling, performance tuning of stored procedures
  • Implemented logging and worked with package configuration variables in SSIS
  • Involved in performance tuning, unit testing and error handling of SSIS Packages
  • Involved in complete SSIS life cycle process

Confidential, Southborough, MA

Software Engineer (SSRS)

Environment: MS SQL Server 2008/2005, SSRS 2008/2005, VSS

Responsibilities:

  • Gather and Analyze business requirements by interacting with end users
  • Created various complex reports and managed them using SSRS 2008/2005
  • Responsible for debugging of stored procedures
  • Involved in testing and data validation of reports
  • Responsible for scheduling the subscription reports with the subscription report wizard

Hire Now