TECHNICAL SKILLS

Operating Systems: Windows (all versions) and UNIX

Languages: HTML, C++, Visual Basic 6.0, Unix Shell, ASP 3.0, VB script and Core Java.

Scripting: Java Script (Client side), VB script (server side) and Shell script.

Database: ORACLE, Sybase and MySQL

ETL Tools: Informatica 8.6.1

Messaging: MQ series.

Scheduler: Control - M 6.4

Frame work: .Net Frame work basics.

Versioning Tool: Visual Source Safe, SVN and PVCS.

Other Tools: Putty, Notepad ++, FileZilla, RapidSQL 7.6.4, Remedy, Clarity

PROFESSIONAL EXPERIENCE:

Confidential, New York

Production Support Lead

Primary Technology:

ETL: Informatica 8.6

Reporting: Business Objects, Crystal Reports

Scheduler: Control-M scheduler 6.4.01

Database: Sybase and Oracle 10.2.0.4

Tools: Rapid SQL 7.6.4, FileZilla 3.2.7, NotePad ++ 5.5, putty, Remedy, Clarity

Version Tool: Tortoise SVN 1.6.5

Messaging: MQ series

Responsibilities:

• Workflow log monitoring.
• Debugging and Troubleshooting Informatica Mappings.
• Implemented Performance Tuning methods at the Source level, Target level, Mapping Level and Session Level.
• Developed Slowly Changing Dimension for type I and type II (flag, date).
• Made use of mapplets in order to save valuable design time and effort.
• Used Informatica Workflow Manager to create, schedule, execute and monitor sessions, worklets and workflows.
• Data extraction and data Transfer from/ to SQL Server Database using utilities / tools like BCP, and BULK INSERT.
• Used Ctrl M for scheduling jobs to link the Wokflows.
• Supporting Daily, Monthly and critical Day ETL processing and Monitoring.
• Modify and re-develop existing ETL jobs to remove bugs and increase efficiency of the applications.
• Troubleshooting the schedule report issue,
• Trouble shooting the data discrepancy reported with the data of the reports
• Monitoring the scheduled critical jobs.
• Re-run and force ok of the failed jobs as per the business requirements.
• Implementation of changes in the draft files and releasing to production.
• Command file (shell script) file creations and modifications.
• Development of new jobs as per the business requirements.
• Debugging the log files incase of failures.
• Holding and releasing the jobs as per production release changes.
• Involving business discussions to automate the legacy changes.
• Developed real time batch processing and automated logger to generate accurate reports.
• Log service requests and resolve the issues reported by the clients within standard time.
• Application log monitoring searching for errors and issues.
• Releasing the shell script and resource files to the directory.
• Folder creations for the log and resource files.
• Extracting data files from the directory and grep the files.
• FTP files to different servers.
• Extracting data from production for business.
• Providing table schema details to Developers.
• Debug the Stored procedures.
• Implementing enhancements in SP’s.
• Monitoring the message flow.
• Re playing the break messages.
• Playing messages from production to UAT.
• Debugging the message breaks.
• Debugging the SWIFT message breaks.
• Application server re-starts and bounces.
• Provide two tier supports to all applications and provide assistance to all end users and identify any issues in production.
• Maintain schedule jobs and perform troubleshoot on processes and resolve all issues.
• Analyze all vendor applications and provide operational support to same and perform reviews.
• Administer and implement all new systems and ensure transition of plans to production.
• Provide training to various new employees and assist with expert knowledge on all production processes.
• Document all production applications and resolve all application issues and answer all requests.
• Monitor all performance metrics for various production systems and identify root cause for all technical issues and recommend solutions.
• Analyze all applications and recommend necessary upgrades and patches and perform troubleshoot on all issues.
• Maintain effective relationships with various system administrators and development teams.
• Prepare all project requirements and develop all associated projects for various applications.
• Participate in periodic meetings and maintain all applications for productions and plan appropriate various strategies.
• On Call support and 24/5 support activities.
• Managing the offshore team and get the functional changes work done.
• Release management and change management.
• Involved in various PMW/DR activities for JPMCC.

Confidential, Philadelphia, Pennsylvania

Senior Support Engineer and team lead.

Technology: MySQL, VB 6.0, ASP 3.0 and Business Objects.

Responsibilities:

• Modify and re-develop existing ASP pages to fix bugs and increase efficiency of the applications
• Developing VB com component and deploying without causing issues to existing prod environment.
• On Call support and 24/7 support activities.
• Leading offshore team and direct interaction with clients.
• Involved in Release management and change management activities.

Confidential

Support Analyst

Technology: MySQL, VB 6.0, ASP 3.0 and ASP.NET

Responsibilities:

• Modify and re-develop existing ASP pages to fix bugs and increase efficiency of the applications
• Developing COM component and deploying without causing issues to existing prod environment.
• On Call support for Australian hours for critical issues.
• Involved in Release management and change management activities.

Confidential

Analyst

Environment: VBA, VB COM, ASP, HTML, JavaScript, and SQL SERVER 7/2000, MS Access.

Responsibilities:

• Done Analysis for the obsolete VBA Code which works in 97 and not in 2003.
• Developed Data Sync Tool for transferring data from Access 97 data base to
• 2003 database.
• Contributed in writing global test cases on Ms Office applications

Confidential

Trainee Developer

Environment: ASP 3.0,VB COM, ASP.net, VB.NET, HTML, JavaScript, and SQL SERVER 7/2000

Responsibilities:

• Resource Management.
• Project Scheduling.
• Cost Management.
• Client Management.
• Risk Management.
• Issue Management.
• Help Desk .
• Change Management and Document Management at the next level.
• Involved in all the modules at various stages like unit testing, bug fixes, development and implementation support activities.
• I did the Customizations according to the client requirement; to do this I have changed and did the changes in Base functionality of the Product.
• I worked for the conversion of existing Base Product to .Net Technology.