Project Sql Server
Resume:
Mittal Patel
acdz2l@r.postjobfree.com
Weymouth, MA
Summary:
• IT Problem solver highly capable of changing with the technological needs of an
organization and completing IT projects on-time and under budget.
• Thorough technical insight coupled with outstanding IT troubleshooting skills.
• Diverse IT professional adept at thinking critically and communicating effectively with
all cultures.
Education:
Kaplan University – Iowa, USA June 2013
Bs in Information Technology -GPA 3.76
Gujarat University, INDIA April 2004
Bachelor of Science in Computer Science – GPA 3.8
Related Coursework:
Database Concepts Using Microsoft Access, Database Design, SQL Server Database
Administration, Intermediate Query Design and Reporting, Database Management, Software
Applications, Computer Hardware and Operating systems, Foundations of Programming Using
Java, Web Design and Development, Project management.
Project: Java (Coffee shop – Java Programming)(Duration: 9 Weeks)
Project: Web Developing (Personal Website - HTML)
Project: Database Design (St. Joseph School –SQL and .net programming)(Duration: 11 weeks)
Project: Maintaining Database (Finance)
Certificate:
SQL Server 2008 R2 Administration and TSQL Programming
Computer Skill:
Software: MS office 97 and 2000, XP, Netscape, Internet Explorer, MS FrontPage
Programming Languages: C, Access, C++, VB, JAVA, Coble, HTML
Operating Systems: MS-DOS, Windows 3.X, Windows 95, 98, 2000, XP, 7, NT, UNIX
Other Applications and Tools: Oracle Business Intelligence Suite Enterprise Edition (OBIEE), Microsoft
Visual Studio, Adobe Photoshop/Adobe Dreamweaver
Experience:
Premier Research Group Limited
Data Visualization Analyst
Jan 2014 – Present
• Develops and maintains specifications used for programming of metrics reports using
OBIEE.
• Creates, enhances, and decommissions reports and the SQL code used for creating
reports.
• Configures visual component for the output of metrics reports through the use of graphs,
tables, and charts.
• Administers Oracle Clinical Discoverer and Integrated Review users within user groups.
• Administers foreign panels and custom SQL on the database for use by users.
• Administers reports on the database to share, grant, and revoke access for multiple users
to access.
• Provides general support in use of the application.
• Performs additional duties and assignments as requested.
Covidien, MA
AS/400 Computer Operator
August 2012 –December 2013
• Responsible for monitors the operation of various servers, hosts systems and network
components to insure proper function and availability to end-users. Utilizes various
monitoring tools as provided such as directly reviewing system console messages, event logs,
emails alerts, audible alarms from data center environmental/mechanical device monitors, or
automated monitoring tools.
• Provides first-level support following established procedures, to end-users having issues
such as connectivity to various servers or systems, analysis and correction of automated
interfaces or printing issues, analysis and correction of user logon issues.
• Performs backups/restores using BRMS per established schedules and procedures, or as
requested. Mounts and unloads backup media as needed to complete backup/restore
operations. Assists in the management of tapes and other data backup media including
completion of logs, off-site storage manifests, or to insert, remove or move media from
carriers, storage containers and racks.
• Performs regularly scheduled uploads or downloads of data from and to various trading
partner or UHS servers, websites or hosts.
• Serves in the role of Customer Support Coordinator during non-business hours. Opens
appropriate help/work tickets and escalates issues to on-call personnel as needed.
• Responds to error conditions on monitored systems and servers by entering message
responses or operating system commands from the keyboard or performing other actions as
appropriate, such as mounting storage media, per established procedures.
• Maintains various Operational logs as required by supervisor or manager.
• Contacts vendors and assists service personnel to affect repair on damaged or malfunctioning
computing or network equipment, or data center environmental/mechanical systems
• Occasionally lifts pushes or carries of boxes or containers containing data media, general
office supplies, small parts and tools, computing equipment or network equipment may be
required.
• Performs other duties as assigned/required.
South Shore Saving Bank, MA
Database Support Analyst
March 2012-August 2012
Responsibilities:
• Manned database administration and design.
• Developed extract reports and MS Access programming to transform data into required
upload format
• Complete numerous monthly reports and inform and change reports on request
• Conducted research to collect and assemble data for databases – Was responsible for
design/development of relational databases for collecting data.
• Created and extracted reports from existing database
• Changes database system by coding database descriptions.
• Protects database by developing access system; specifying user level of access.
• Maintains user reference by writing and rewriting database descriptions
• Develop new reports where suitable
• Analyzed data, validated against business rules
• Updated documentation for database changes
• Responsible for analysis reports and be accountable to answer any queries, complaints or
proposal
Database Intern
Technology Center, Kaplan University
• Trained on Oracle, SQL and Access database. Worked on their ongoing projects to
understand database implementation across various projects.
• Created SQL queries, stored procedures, and views.
• Creates and documents technical designs.
• Writes technical design and maintenance documentation for websites, databases and
related workflow processes
Contact this candidate