Patel Consulting
18943 Whitcomb Place
Noblesville, Indiana 46062
317-773-2727
contractor@patelconsulting.com

SUMMARY OF QUALIFICATIONS

• SQL Server development
• SQL Server Integration Services development
• SQL Server Reporting Services development
• SQL Server database administration
• Linux administration
• MySQL development
• PHP development
• Python development
• IOS development

TECHNICAL SKILLS

Technologies: TSQL, SSRS, SSIS, C#, XML, JSON, PHP, Python, IOS, MySQL, Debian Linux
Databases: SQL Server 2000 / 2005 / 2008R2 / 2012 / 2014 / 2016, MySQL 5.5, SQLite

EDUCATION

Bachelor of Science (Computer Technology, Purdue University, 1995)

CERTIFICATIONS

MCSE
MCDBA

CONSULTING EXPERIENCE

Patel Consulting
Noblesville, Indiana
June 2012 – present

SQL Server

• Installing and upgrading the database server and/or application tools.
• Planning for and allocating the database system’s physical requirements
  • physical memory
  • disk space
  • network requirements
• Modifying the database structure using information provided by application developers.
• Creating user accounts and profiles and ensuring system security by careful allocation of user permissions.
• Creating a backup and recovery strategy for the database, and regularly testing the backups to ensure usability.
  • Full backup
  • Differential backup
  • Transaction log backup
  • Copy only backup
  • Point-in-time recovery
• Creating reports by querying from database. These reports are in the form of custom-made ad hoc reports by the database administrator.
  • SSRS / Power BI Desktop
  • HTML results via DB Mail
• Monitoring and optimizing the database’s performance using either manual or automated tools
  • DMV’s
  • SQL Server Management Studio
• Writing optimized SQL queries for integration with other applications
  • Execution plan evaluation
• Maintaining data quality and overseeing database security
  • Data cleansing
  • Check constraints
  • Server roles
  • User mappings
  • Database object permissions
  • Linked servers
• Strong proficiency with TSQL logic programming
  • Case statements
  • String manipulation
  • Joins
  • Aggregation
  • Table design
  • View design
  • Function design
  • Stored procedure design
  • Triggers
  • XPath
  • XQuery
  • Data encryption
• Skilled at optimizing large complicated SQL statements
  • Temporary tables
  • Table variables
  • cursors
• Knowledge of best practices when dealing with relational databases
  • Backup strategies
• Ability to plan resource requirements from high level specifications
• Capable of troubleshooting common database issues
  • Blocking
  • Query optimization
• Familiar with tools that can aid with profiling server resource usage and optimizing it
  • Activity monitor
  • SQL profiler
• Proficient with SSIS system and user-defined variables
• Efficient use of SSIS expressions in conjunction with SSIS variable use
• Development of SSIS ETL processes using:
  • Precedence constraints
  • Staging tables
  • Conditional processing logic via scripting
  • Data transformations
  • Sequence containers
  • Loop processing

Linux

• installing, updating and maintaining core Debian Linux systems
• administration and configuration of network printing, network fax and shared disk volumes
• administration and configuration of various network services
• installation, configuration and maintenance of Apache
• installation, configuration and maintenance of MySQL / MariaDB
• installation, configuration and maintenance of PHP scripts
• development and maintenance of OS level automated operational processes
  • MySQL maintenance
  • disk space monitoring
  • network node availability

Python

• development and maintenance of python scripts
  • MySQL automation
  • serial connections data transfer
  • graphical file manipulation
  • secure file transfer
  • graphing (numpy, matplotlib)

MySQL

• development and maintenance of MySQL databases
  • backup
  • restore
  • data import
  • data export
  • data migration
  • table index creation and maintenance
  • stored procedure development and maintenance

IOS

• development and maintenance of IOS Swift applications
  • MySQL reporting
  • CoreLocation services
  • JSON parsing
  • UIKit
  • WebSockets
  • Git repositories
  • SQLite

QNXT

• development and maintenance of QNXT SSRS reports and SSIS processes
  • Claims
  • Enrollment
  • Providers
  • HEDIS reporting

Team Foundation Server

GIT / Bitbucket

Crystal Reports

Jira

Confluence

PostgreSQL

Java / JDBC