SUMMARY

• 10+ years of IT industry experience encompassing a wide range of skill set, roles and industry verticals.
• Extensive experience with analysis, design, development, customization, implementation, supporting and troubleshooting of software applications.
• Proficient in analyzing and translating business requirements to technical requirements and architecture.
• Strong database skills, Unix shell scripting skills, Object Oriented Programming and development knowledge
• Handled multiple roles - Developer, Subject Matter Expert, System Engineer and Production support lead
• Good experience in understanding and implementing SDLC (Software Development Life Cycle).
• Executed software projects for Electronics and Health care domains.
• Good communication skills, interpersonal skills, self-motivated, quick learner, team player.
• Ability to work under strict deadlines.
• Excellent Client/Business interaction skills, working in client location for last four and half years.

TECHNICAL SKILLS

RDBMS: Oracle 12c/11g/10g/9i, SQL Server 2005/2008/2012 , MS-Access 2003/2007/2010.

Languages: SQL , PL/SQL, UNIX shell scripting, AlX-Unix, C#.Net, Visual Basic 6.0 O/S UNIX (Solaris 9/10), Windows 2000/XP/Windows 7/Windows 2010

Tools: SQL Developer, Toad, Visual Studio, Clear Case, MS Visio, Jitterbit Studio

PROFESSIONAL EXPERIENCE

Confidential, Rochester, NY

Onshore Tech Lead- Production

Responsibilities:

• Resolved all the technical issues reported by Business users, provided investigative support for functional users on interfaces, defects, change requests and adhoc report requirements.
• Performed defect fixes and Minor enhancements as per Business needs.
• Performed deployments in staging/production environments for all the M&S applications.
• Migrated application servers from legacy environments to new environments (example: Solaris 5.9 to 5.10 and Windows 2003 to Windows 2012)
• Created Disaster recovery environments (ITSC drill environments) for M&S applications and supporting client in needed application drill testing.
• Automated few standard services which were manually executed by Business in M&S applications.
• Worked with interfacing teams to setup new connections for feeds transfer(inbound/outbound) through SFTP;
• Involved in setting up integration with salesforce.com for M&S applications through Jitterbit processes.
• Monitored all day to day application/batch logs and resolved any issues with batch processing.
• Monitored application/batch processing through precise monitoring tool, discussed opportunities for improvements with M&S architect teams and incorporated changes
• Ensured all the latest patches applied on to application servers and databases.
• Responsible for analyzing the existing system and the feasibility of incorporating the new functionality in the existing system.
• Responsible for executing year end activities in support of M&S applications for Confidential .
• Responsible for managing scope, planning, tracking and change control aspects of the project.
• Translate customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results for Minor enhancements.
• Responsible for monthly and quarterly outage report generation and discussing with client.
• Co-ordinate with Interfacing applications and solve interfacing issues.
• Continued support for production issues as tier 2 production support specialist.

Confidential

Senior System Engineer

Environment: UNIX (Solaris 9/10), Oracle 12c/11g, Java, SQL server 2008/2012, Microsoft .Net Technologies

Responsibilities:

• Responsible for performing daily batch monitoring and solving any issues reported during batch process.
• Monitor batch logs (Unix/Java/database) and resolve any issues identified.
• Resolve issues reported by Business users and perform defect fixing.
• Interact with interfacing teams and resolve any issues with interfacing feeds/data/ Message transfers;
• Direct Client Support and Regular Application Health Monitoring.
• Support client in Application Recovery Exercise and in monthly and quarterly outage report generation.
• Co-ordinate with Interfacing applications and solve interfacing issues.
• Provide technical and investigative support for functional users on interfaces, defects and change requests
• Performing quarterly scrub for the M&S applications and support client in Audit exercises.
• Continued support for production issues as tier 2 production support specialist.

Confidential

Application Developer

Environment: UNIX, Oracle 10g, VB6.0, MS-Access 2003/2007.

Responsibilities:

• Facilitate client in writing Business requirements and translate Business requirements into Functional Requirements Document and to Detailed Design Documents
• Lead analysis sessions, gather requirements and write specification and functional design documents for enhancements and customization
• Analyze product impact
• Present product designs and application flow to clients
• Coordinate and communicate tasks with developers.
• Ensure that development is performed as per requirements
• Work with QA to create test scripts and scenarios for enhancements and customizations to the core product
• Communicate activities/progress to project managers, business development, business analysts and clients
• Develop implementation and test plans, build software acceptance criteria, coordinate and work with clients to oversee the acceptance and dissemination process
• Developed and supported three applications namely Total Cost of Ownership, Tables Automation- Contracts and Sale Range Pricing.

Confidential

Application Programmer

Environment: SQL Server 2005, Microsoft .Net Technologies, Oracle 9i

Responsibilities:

• Writing stored procedures required for changing routes in server.
• Mapping of all the routes from back-end and dumping SCM/PMS data to server.
• Creating jobs.
• Assisting the development team while hosting the application in the production server.
• Retrieving reports from server on daily-basis and sending to Client in a pre-defined format.
• Making changes in routes as requested by client from back-end.
• Trained the Tech Support Team of Confidential on basic SQL SERVER and taking backups and restoring Databases.
• Monitoring the jobs and error logs.
• Assisting the N&S and Tech support team in trouble shooting.

Confidential

Application Programmer

Environment: Microsoft .Net Technologies, SQL Server 2005

Responsibilities:

• Created all the required tables, stored procedures and functions.
• Coding in C#.net
• Defect fixing and tracking.
• Ensuring that the module is working as per the requirement.
• Ensuring that the changed requirements are captured properly.

Confidential

Software Engineer-Trainee

Environment: ORACLE 9i, PL/SQL, Forms and Reports.

Responsibilities:

• Designing the front end using D2k Tool.
• Database design, creating all the required tables with constraints.
• Writing the required scripts using SQL/PLSQL, Creating stored procedures
• Coordinating the testing activity, handling exceptions in the code.
• Monitoring the production regularly and fixing production issues.
• Analyzing the data and designing the solution to correct corrupted data.
• Developing PL/SQL blocks to correct the corrupted data.
• Ad-hoc Reports generation using PL/SQL.