SUMMARY:

To obtain a position as a Support Executive in a challenging environment that utilizes team - work effort for researching, learning and developing new products.

TECHNICAL SKILLS:

• Oracle PL/SQL
• Microsoft SQL Server T-SQL
• UNIX shell scripting and application monitoring
• Certified in Oracle - OCA - 9i (Oracle Certified Associate)
• Certified is ITIL V3 Foundation

SKILLS & ABILITIES:

• Over 12 years of IT experience with emphasis on Application Support, SQL Development and total experience of over 14 years.
• Experience in ORACLE, MS SQL Server with good programming knowledge in PL/SQL and T-SQL.
• Functional proficiency in Auto, Telecom and Financial domain.
• Excellent trouble shooting and issue resolving skills.
• Good all round production environment awareness.
• Proactive and Self-motivated with natural leadership traits and excellent communication skills.

PROFESSIONAL EXPERIENCE:

Business Analyst

Confidential

Environment: Mainframe and DB2

Responsibilities:

• Participate in core internal Ford team to manage daily operations of applications utilizing standard ITIL V3 tools.
• Ensure Critical Success Factor (CSF), Critical to Quality (CTQ) and Key Performance Indicators (KPI) are met for these applications.
• Be a part of change coordination and analyze the impact of the change.
• Liaise with the other team members to ensure handover, continuity and consistency within the team as well as among other teams within the department
• Investigation and perform initial triage of incidents using knowledge articles to guide basic troubleshooting steps.
• Lead the process for maintaining a strong internal Layered Process Auditing system.
• Create and maintain all required documents for Internal and External audits

IT Analyst

Confidential

Environment: Oracle PL/SQL (10g and 11g), Unix

Responsibilities:

• Worked as a Change coordinator and direct contact for change team of Barclays Integrator project.
• Coordinating with business for understanding the requirement for new enhancements.
• Creating and evaluating the Business requirements documents with business for clear understanding and finalizing the requirements
• Raising change request for any changes required for the application using ServiceNow.
• Chasing and completing the approvals required for the change and make any changes required.
• Deployment of task assigned to the team.
• Doing pre and post testing for the change.
• Following up with business users for live proving of the applications after deployments.
• Understanding the payment flow of all types of payments.
• Co-ordinate with L3 (Offshore) team for bug fixes, enhancement requests.

Confidential

Production Support Executive

Environment: Oracle PL/SQL, Unix

Responsibilities:

• Batch Monitoring using Autosys and Batchmon plus.
• Raising tickets for requests and errors via Service Now, Raptor, Falcon.
• Provide 24 x 7 rotational support
• Provide L1 and L2 support for application that includes raising tickets for faults raised by users and carrying out various proactive maintenance activities, to minimize fault levels.
• Wrote complex SQL queries using joins and sub queries to retrieve data from the database.
• Created and maintained PL/SQL scripts and stored procedures.
• UNIX Shell Scripting to automate procedure execution from UNIX box.
• Responsible for the dealing with the problems, bug fixing and troubleshooting
• Responded to all UNIX systems problems 24X7 and resolved them on a timely basis.
• Created shell scripts and updated the scripts as per the requirement.

Senior Software developer

Confidential

Environment: Oracle PL/SQL, Unix

Responsibilities:

• Batch Monitoring using Autosys.
• Raising tickets for requests and errors via Netcool and HPSC.
• Provide 24 x 7 rotational support
• Provide L1 & L2 support for application that includes raising tickets for faults raised by users and carrying out various proactive maintenance activities like alert monitoring and incident management, to minimize fault levels.
• Implemented PL and SQL queries, triggers and Stored Procedures as per the design and development related requirements of the project.
• Designed and created database tables, views and stored procedures.
• Built and maintained SQL scripts, indexes, reports and queries for data analysis and extraction.
• Created shell scripts for database backups, transaction dumps using cron job.

SQL Developer

Confidential

Environment: Microsoft SQL Server 2005

Responsibilities:

• Creating the database tables for the application.
• Creating the T-SQL Stored Procedures and Functions in the database.
• Created procedures and different modules for accruals, considering different requirements and cases.
• Create triggers to keep track of changes to the fields of tables when changes are made.
• Created accruals and was responsible for all modules through which an accrual will be calculated.
• Responsible for creating and scheduling of SQL jobs.
• Created complex DTS Packages for Data Migration and Transformation. Experience in data migration from Access/Excel Sheets to SQL Server 2005
• Reviewed existing business procedures and recommended and implemented changes.
• Responsible for setting preferences for various ad-hoc requests and distribution of tasks.
• MS SQL Server database administration, including configure Scheduled Tasks for regular Database Backup and Maintenance Activities, create and modify tables, stored procedures, various clustered and non-clustered indexes, triggers, check constraints and functions.
• Physical design and implementation SQL Server databases.
• Perform regular reviews of the database to identify performance problems, inadequate programming, and data duplication problems.

Confidential

Production Support Executive

Environment: Sun-Fire-V890, SunOS 5.9, IBM WebSphere MQ 530.8 CSD08, Oracle 10.1.0.4.0

Responsibilities:

• Proactive monitoring of FlowStream application resources (CPU utilization, memory) using built in tools.
• Preparing Shell scripts & PL/SQL scripts to progress orders in bulk.
• Provide 24 X 7 after hours rotational support.
• Support 13 FlowStream servers.
• Attending and chairing various conference calls, to resolve priority faults raised by the users and external components also act as a central coordination point for various support activities.
• Provide second line support for FlowStream application that includes handling faults raised by users and carrying out various proactive maintenance activities, to minimize fault levels.
• Liaison with the SMC’s and help desk to determine nature of fault, fault resolution, etc.
• Dealing with the exceptions that occur during the order life cycle.
• Minimizing the impact on business critical orders in case of system failures by timely decision of load balancing and throttling mechanisms.
• Raising alarm with other system components to get the problems resolved as they occurred with minimal impact on broadband OSS.
• Design and Developing of workflow procedures.
• Interacted with client to gather the requirements and implement the same in the project.
• Building up a very strong customer support and communication structure.