Anuj Pandya
******.******@*****.***
Houston TX
ACCOMPLISHMENTS:
4+ years of experience working on Microsoft SQL and relational database systems
5+ years of experience working in IT division
4+ years of experience supporting Servers BTIL(Full form of BTIL)
4+ years of experience supporting 24/7 service on site and on call.
Proficient in relational database management systems
Design and administrator of MS SQL
Experience in developing and tuning SQL Server Integration Services (SSIS) packages & SSRS reports.
Experience in planning and implementing Database Security by creating Logins, Users, Roles and assigning permissions according to the requirement.
Coordinated physical changes to computer data bases; and codes, tested and implemented SQL data base, applying knowledge of data base management system.
Strong Implementation and Development expertise in User Interface planning & external databases.
Manager over 2 Data Centers nationwide.
Led a team of 16 core and application DBAs, responsible for the day-to-day operations of the single global instance.
Enhanced end users' understanding of database systems by conducting pre-implementation workshops, delivering group and individual training sessions and creating user-friendly training materials.
Improved vital processing jobs by reducing process duration by 60%.
Enrolled users, maintained system security, and controlled and monitored user access to the database, operating 24/7, with 40-50 concurrent users at any given time.
Eliminated months of production server issues by systematically troubleshooting and resolving the problem with no further downtime.
Maintain logical and physical database structures including tables, views, partitioning, index, capacity planning, database links, tablespaces and metadata
Extensive experience performing and managing technical as well as functional aspect financial reporting processes
Experienced in preparing detailed documents and reports while managing complex internal and external data analysis responsibilities.
Administrator as well as developer of Apache and OSIsoft databases EDUCATION:
BS in Computer Science, University of Houston – Downtown December 2013 Technical Skills:
Database: SQL Server 2008R2/2008/2005, MSSQL, MS Access
Software: Microsoft Excel, Access, (More SQL related software), SSIS, SSRS & Outlook, Microsoft Visual Studio, Pi
Language Skills: iOS Development (Swift), SQL, TSQL
Server Admin: Firewalls, routing, VPNs, Switching, VLANs, DNS, and DHCP in Windows, Linux and Unix, Windows BAT Scripting
Anuj Pandya
******.******@*****.***
Houston TX
WORK EXPERIENCE:
Hewlett-Packard Enterprise, Austin and Houston, TX March 2015 – January 2017 SQL Administrator & IT Specialist
Installing and maintaining SQL Server 2000/2005/2008.
Developing stored procedures, triggers, views and adding/changing tables for data load and transformation, and data extraction.
Used Query hints to Tune the SQL queries for maximum efficiency and performance.
Working on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
Performance testing on stored procedures, indexes, and triggers.
Creating DTS Packages for data import, export, scrubbing and scheduled jobs for backups.
Worked in active/active and active/passive cluster environment
Data migration using bulk copy program and DTS.
Helping the front-end application developers with their queries.
Job Monitoring and making sure all jobs run successfully every night.
Performing low-level scripting, fixing of codes and software enhancement process.
Developing Crystal Reports used to generate all daily, weekly, monthly and quarterly Reports including current status.
Development of various reports and reporting interfaces utilizing Microsoft SQL Reporting Services.
Suggest Replication techniques to meet business needs.
Scheduled and monitored all maintenance activities including databases consistency check and index fragmentation.
Analyzed execution plans, and tuned queries and databases for better optimal performance.
Fixing Missing Indexes and Excess indexes.
Generated script files when changes applied to stored procedures and functions.
Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
Exported data from external server into Excel with SQL Query.
Matched two different database to compare values and turned into monthly usage reports.
Successfully implemented TSA project moving remaining HPI devices to separate networks at Both US Data Centers
Created and maintained spreadsheets with collected data of the all VLS, Decomm Drives and Break fix drives additionally to Media tapes.
Linqup App for iOS, Houston, TX July 2014 – January 2017 App Developer & App Database Developer
Designed and developed a geo-location based social network app focusing on nearby social events.
Designed and implemented User Interface for the mobile app and website.
Coordinating events to promote the product across university campuses.
Designed a database to store user information.
Developed and designed fully functional app using SWIFT and Xcode
Connected application with external database Github to store data. Anuj Pandya
******.******@*****.***
Houston TX
REFERENCES:
Robbin Dennis – Supervisor at Hewlett Packard March 2015 – November 2016 407-***-****
Clint Gage – IT Engineer Manager at Hewlett Packard Enterprise October 2015 – December 2015 281-***-****