Hari Haran
E-mail: hariharan@gmail.com
Mobile: +91 9912345678

JOB OBJECTIVE:
                 As a professional I believe in intellectually stimulating work process, to excel and succeed through smart work, thus enhancing value addition to my job, the organization and myself. Have the ability to work independently as well as good team contributor on group projects.
PROFESSIONAL SUMMARY
•	4 years of programming experience as an Oracle Developer/ PL/SQL Developer in Monitoring, Analysis and troubleshooting.
•	Working experience in rotational shifts 24/7 Production Support.
•	Working experience in rotational shifts and L1 and L2 Production support.
•	Working as Production Support, attending production calls, troubleshooting the application and resolving bugs.
•	Good understanding of ITIL and ITSM operational processes like Incident Management, Change Management, Problem Management, Release Management and Service Improvements.
•	Working Used UNIX shell scripts to automate and systemize the load process at nightly cycles.
•	Provided support and inputs in Agile software deployments.
•	Work with QA, Release Management and L2 Support teams to ensure Quality Rollouts
•	Interacted with the business users, collected the requirements, analyse the requirements, design and recommend solutions.
•	Vast Experience in Oracle advance SQL Programming Using Analytical functions, Sub Queries, indexes and so on.
•	Proficient in creation, modification and effectively use of database objects like Tables, Constraint, Sequences, Indexes, Group Functions, and Views .
•	Experience and Excellent Exposure in Query tuning using Bulk collect, Materialized Views, Indexes.
•	Expertise in Client-Server application development using Oracle 11g/10g, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
•	I have involved in all phases of the SDLC (Software Development Life Cycle).
•	Experience in handling ITIL Methodologies
•	Experience in handling AGILE Methodologies

PROFESSIONAL EXPERIENCE:

•	Working as Senior Software Engineer at Company Name from November 2011 to till date.

EDUCATION QUALIFICATION:
•	University of Madras – Chennai INDIA
            Bachelors of Commerce, Corporate Secretary ship.

TECHNICAL SKILLS:
	Database		: Oracle 10g / 11g
Language		: SQL, PL/SQL, Unix
Operating System	: windows XP, 7, Linux
Tools			: SQL Developer, Toad, SQL PLUS
PROJECT EXPERIENCE SUMMARY:
Project#1
	Title			: BANKING IN TRADING
	Clients			: Westpac Banking Corporation (NZ)
	Tools & Utilities		: SQL Developer, SQL Plus, Toad
	Domain			: Banking
	Period			: NOVEMBER’ 2013 – Till Date	
Roles & Responsibility:										
•	Involved in development of interface programs to import parts information to inventory base tables.
•	Interacted with Business Analysts and participated in user requirement sessions to analyze and gather business requirements.
•	Built complex queries using SQL and wrote stored procedures using PL/SQL.
•	Performing Root Cause analysis and submitted Known errors (KB Process).  
•	Working experience in rotational shifts and L1 and L2 Production support.
•	Loaded the data into database tables using SQL*loader from text and excel files.
•	Participate in projects related to Projects and peripheral applications, as requested. 
•	Worked on UNIX shell scripts to automate and systemize the load process at nightly cycles.
•	Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
•	Monitoring the Database performance and take necessary action to optimize the database performance
•	Responsible for developing technical specifications from business requirements.
•	Developed interface for item data conversion to load items from flat file to Oracle Inventory using SQL* Loader, PL/SQL and import items program.
Environment: Oracle 10g/11g, PL/SQL, SQL* PLUS, UNIX Shell Scripting, TOAD, OOAD.

Project #2
Project name	: Information Enrichment Schemes
Clients		: Clydesdale Bank Plc, UK.
Domain		: Banking
Duration		: NOV’ 2011 to OCT’ 2013
Roles & Responsibility:
•	Developed Stored Procedures, Functions, Packages and SQL Scripts using Pl/SQL.
•	Converted open purchase orders from legacy system to Oracle Purchasing using SQL* Loader, PL/SQL, Packages/Procedures
•	Involved in development of shell scripts to send invoices to customer through mailing.
•	Designed and developed various custom packages triggers and forms.
•	Involved in creation of Conceptual Modelling covering all the business requirements.
•	Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
•	Extensively used for all and bulk collect to fetch large volumes of data from table.
•	Optimizing the SQL*Plus, PL/SQL and SQL*Loader scripts for data conversions.
•	Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.
Environment: Oracle 10g, SQL*PLUS, PL/SQL, TOAD.  
PERSONAL PROFILE:

Name					: Name
Father’s Name			: Father Name
DOB					: DOB
Address for Communication        : Address

DECLARATION:	

           I hereby declare that the information furnished above is true to the best of my knowledge and belief.

PLACE:Chennai								

DATE: