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