OBJECTIVE:

To contribute strong technical skills with 5+ years of experience in Production Support, System Admin and Control - M Scheduling Tool and worked in Both Windows and Linux environment to provide the best quality SLA service for clients

SUMMARY OF QUALIFICATIONS

• 5+ years of experience in designing, developing and implementing database applications and creating jobs on control-M Scheduling Tool.
• Involved in Ordering/Loading/Forcing of jobs or tables into the schedule, monitoring of schedule to include fixes or escalation
• Involved in installing in installing control-M agent
• Worked extensively on Deploying the DB and App code
• Developed ad hoc reports using Control-M Scheduling Tool.
• Handling BMC SDE incident tickets on daily basis in various SDE queues -- Control-M, FTP and L1 Support.
• Manage and monitor production backups using Symantec Backup Exec
• Configured ASP.NET websites using IIS 6.0 and IIS 7.0
• Involved in working on SCCM.
• Installed and managed Active Directory on windows 2003 and 2008 server.
• Extensively involved in creating Group Policy objects.
• Installing and Configuring Web servers.
• Involved in working on TCP/IP
• Worked in various levels of SDLC (System Development Life Cycle)
• Experience in interacting with Business/Technology groups and analyzing business needs.
• Involved in setting up new servers and Setup of ICES and HSS system for new clients.
• Extensively involved in SQL Server database administration taking backups, Upgrades, new setups and installations
• Application Support experience with MS SQL Server, Oracle and IIS.
• Used SQL Developer to accurately assess the efficiency of the SQL statements.
• Expertise in PL/SQL programming involved in creating and testing of stored procedures, packages and triggers
• Wrote complex SQL queries.
• Developed SQL * loader scripts to load data into the database tables
• Experience in working on XML scripting.
• Good knowledge on Oracle tools like PL/ SQL Developer and used TOAD in many projects.
• Experience in working on Unix Environment.
• Experience in writing Shell and Perl scripts for application oriented tasks.
• Experience in writing Windows batch scripts for application oriented tasks
• Worked on different data transfer utilities such as FTP (File Transfer Protocol), SFTP.
• Good Knowledge in RDBMS concepts and worked extensively on Oracle databases like Oracle 8i/9i/10g/11g.
• In addition to excellent technical abilities possesses strong oral and written communication skills, analytical and interpersonal skills.

TECHNICAL SKILLS:

OS: Windows Server 2003/2008/2012 , HP-UX 11.00, UNIX

Database: Oracle 8i/9i/10g/11g

Tools: SQL*Plus, iSQL*Plus, Toad 9.1, SQL Developer, Control-M

File Transfer: FTP, Ipswich

Languages: SQL, PL/SQL, Shell Scripting,C,C++

Monitoring Tools: Solar winds Orion, Whatsup Gold, Watchour

Ticketing Tool: BMC SDE, Ilient

PROFESSIONAL EXPERIENCE

Confidential, Southborough, MA

System Engineer

Responsibilities:

• Designing, developing and scheduling BMC Control-M jobs using various components such as AFT, Database and batch in Control-M.
• Extensively involved in Ordering/Loading/Forcing of jobs or tables into the schedule, monitoring of schedule to include fixes or escalation.
• Involved in Monitoring Control-M Server/Agent and troubleshooting the issues found
• Extensively Involved in Handling the SDE Incident and Helpdesk Requests Assigned to control-M, FTP and Production Support group.
• Involved in implementing and providing Production support for Optum claims processing system to clients.
• Extensively Involved in SQL Server database administration taking backups, Upgrades, Installations and performance tuning.
• Extensively involved in deploying the DB scripts in Linux Environment.
• Extensively involved in working on SCCM
• Monitoring websites, webservers and database servers and resolving issues.
• Extensively involved in managing application and DB backups before deployments.
• Involved in monitoring system resources to ensure network availability to all system users.
• Installed and managed Active Directory on windows 2003 and 2008 server.
• Planned, scheduled and deployed OS, security patches and upgrades in test and production environment on windows servers, laptops and desktops using windows server update services (WSUS)
• Created Unix Shell Scripts for automating the execution process.
• Worked extensively on .Net application and Oracle/SQL server code deployments for both patch and full releases.
• Extensively involved in writing shell scripts.
• Used SQL Developer to accurately assess the efficiency of the SQL statements.
• Wrote complex SQL queries. Including inline queries and sub queries for faster data retrieval from multiple tables
• Involved directly with client for there technical issues, logging the issues in SDE and resolving the issues also escalating the same to other teams if required in a timely manner. .
• Extensively involved in Generating monthly report for all clients using Control-M.
• Expertise in creating the Technical Documentation for various projects
• Installed OS windows 2003, 2008, on Dell hardware
• Expertise in creating and running Batch files on regular basis.
• Involved in error handling of Various scheduled jobs
• Customized number of reports according to the client requirements using Control-M reporting Facility
• Expertise in FTP process and was involved in FTP from one agency to other agency.

System Engineer

Confidential

Responsibilities:

• Extensively involved in maintenance for Ingenix Claims Editing Systems (ICES) and HSS.
• Setup up new servers and install ICES and HSS for new clients.
• Installed and managed Active Directory on windows 2003 and 2008 server.
• Installed and Configured SQL server 2005 /2008 and SQL reporting server 2008
• Manage and monitor production backups using Symantec Backup Exec and HSS.
• Troubleshoot ICES/HSS related issues with Ingenix support team.
• Install and setup SSL certificates for new ICES applications for secure access by clients.
• Train new recruits regarding the current processes, technologies and daily workflows
• Generated monthly report for all clients using Control-M.
• Execute DB scripts using PL/SQL developer.
• Deploy new adjudication scripts using shell scripts for various clients as per client requirements.

Environment: Oracle 9i/10g/11g, SQL, PL/SQL, UNIX.