Engineer Manager

Neeraj Wadhwani **, Summer St, Apt# *,

Westborough, MA

Phone No: 774-***-****

**************@*****.***

Summary:

• MS in Computer Science.

• 4+ years of experience in MySQL on Windows and Linux.

• Highly experienced on all versions of MySQL RDBMS.

My areas of experience include Design, Installation, Creation, Maintenance of

•

Databases, Performance Tuning, Backup and Recovery, Optimization and

Database Security.

Worked on performance and fine-tuning Linux and Windows servers.

•

Installed and configured Apache/Tomcat/Java/MySQL/MSSQL Server

•

Management Studio.

Upgraded MySQL server using yum and rpm package Manager.

•

Designed and optimized lot of MySQL applications.

•

Ability to work at MySQL binary logs level used by disaster recovery planning.

•

Monitored/Repaired MyISAM and InnoDB tables. Good understanding of the

•

tradeoff of using table engines based on client applications requirements.

Ability to work at MySQL Binary logs level and recovering data for the clients by

•

using Binary logs.

Wrote scripts to backup data using mysqldump and MySQLHotCopy, knowledge

•

of working with snapshots for InnoDB databases.

• Worked on third party tools like Cognos for reporting needs, SQLYog and

MSSQL Server management studio for quick results.

• Installing Cognos, deploying packages and configuring it with the given MySQL

or MSSQL database.

• Experience on report studio and query studio within Cognos tool.

• Supporting application on MSSQL.

Wrote custom scripts/reports for enterprise clients using JSP and JAVA.

•

• Highly adaptable in quickly changing technical environments with very strong

organizational and analytical skills.

• Managing and documenting requirements and the resolutions to the known issues.

• Handled projects and efficiently delivered the required applications in a very

systematic way.

• Mentoring and leading the new joiners.

• Coordinating and interacting with team members and development team.

• Managing and supporting multiple projects.

• Highly adaptable in quickly changing technical environments with very strong

organizational and analytical skills.

• Excellent Communicator with the ability to deal with issues with precision and

accuracy.

• Ability to work flexible hours.

Employment:

eClinicalWorks June 2007 – Present

Role: MySQL DBA / Application Support Engineer.

Location: Westborough, MA

This is a healthcare software company providing the users with a product that

coordinates a network between the practices, clearinghouses, insurance companies

and their patients. Its product covers both EMR and Billing needs of the practice and

communicates electronically with clearinghouses and insurance companies/patients.

• MySQL DBA for the enterprise clients.

a.) Installing MySQL and configuring replications.

b.) Setting up Replication Monitor.

c.) Performance Tuning, optimizing queries and expertise in data recovery.

d.) Writing backup Scripts.

e.) Assisted with sizing, query optimization, buffer tuning, backup and recovery,

installations, upgrades and security including other administration functions as

part of profiling plan.

f.) Experience in both MyISAM and InnoDB Engines, migrating database to and

fro.

• Experience on COGNOS Reporting Tools.

a.) Installing Cognos application.

b.) Configuring the application according to MySQL and MSSQL databases.

c.) Installing new packages.

d.) Creating custom reports using Report Studio.

e.) Working with users and coordinating with application developers to

understand and capture data/reporting requirements

• Tier-3 level Application/Database support for all the clients.

a.) Installing Tomcat Application server and Ftp servers like Titan ftp, MS IIS Ftp

Service.

b.) Supporting Billing Features of the application.

c.) Coordinating with clients and developers for their custom requirements.

d.) Responsible for Knowledge Transfer from development to the technical

support.

e.) Coordinating with the clearinghouses.

• Mentoring the new recruits.

a.) Documenting the resolutions to the existing issues.

b.) Training the new comers.

c.) Bringing them up to speed.

• Projects.

a.) Automation of claim creation.

b.) AR management report for Family Health Services, Minnesota.

f.) Pioneer’s financial report using Beginning and Ending A/R.

g.) Billing Bugs Utility for the Billing Team.

h.) Patient Statement lookup using the claim collection cycle for TARGET.

i.) Group NPI utility for TARGET.

j.) Billing Utility for ICD/CPT deployment.

• Leading the offshore tier-1 support.

a.) Managing the resources.

b.) Training the techs to Tier-2 level.

• Account manager for enterprise clients like FHSM, FCPC, SUMMA and

Memorial Herman.

a.) Managing Requirements before Go-Live and future upgrades.

b.) Monitoring the database servers.

Environment: MySQL 4.1, MySQL 5.0, MSSQL, Cognos 8, Jsp, Java, Windows XP,

Windows Vista, Linux, Putty, WinScp, Leech FTP, SQLYOG, FILEZILLA, Cisco system

VPN Client, Team Viewer, GoToMeeting, Tight VNC.

Linux Solutions July 2005- June 2006

Role: Network Engineer

Location: Bhopal, India

• Configuring and managing networks on Linux platforms.

• Installing MySQL, configuring it for the client’s application. Clients include local

banks, universities and schools.

• Database support for reporting tools.

• Monitoring replication.

Environment: MySQL 4.1, Windows XP, Windows Vista, Linux, Putty, Leech FTP,

SQLYOG, Cisco system VPN Client, Team Viewer, GoToMeeting, Tight VNC.

Skill set:

MySQL, MSSQL, Jsp, Java, Cognos 8, VB6.0, HTML, HTML Kit, Visual Source Safe,

Microsoft Access. MySQLGUI Tools. Linux, Windows NT/XP/2000/2003. Replication,

Clustering, Tuning, Sizing, Monitoring, Backup, Recovery, High Volume Databases,

Database sharing.

Academic Qualifications:

• Masters in Computer Science (MS), 2007

New Jersey Institute of Technology

Newark, NJ

Contact this candidate