OBJECTIVE:

To be the most outstanding professionals Contractor with a challenging career in Software Technology where the innovative ideas of computations spirals technology. Looking for a challenging opportunity where my technical and analytical skills are utilized to the optimum, which adds to company and individual growth. Broad experience in Database Development in Oracle PL/SQL, IBM DB2, WebSphere, Datastage with Tibco Programming and hands-on skill in UNIX and RHEL Linux, Shell and Perl Scripting. Ability to analyze an organization's critical support requirements identifies deficiencies and potential opportunities develops innovative solutions for increasing reliability and improving productivity.

PROFESSIONAL SUMMARY:

• Experienced in Oracle PL/SQL programming including development and tuning of packages, stored procedures, functions and Unix/Linux Shell scripting.
• Extensive experience in Oracle 9i/10g/11g and scripting skills in multiple languages including Perl, AWK, SED and basic Shell Scripting Bash, Bourne, Ksh . Automating various jobs and performance processes tasks by creating scripts and cronjobs.
• Proficient and ability to implement robust ETL processes to extract transform and load data from transactional databases to the Data Warehouse. Develop ETL specifications, source to target mapping and other documentation required for ETL development. Implement adequate ETL monitoring, validations, data integrity, data modelling and auditing to accurately measure and trend ETL performance. Fine tune complex queries against very large databases VLDBs .
• Extend and maintain existing ETL processes to accommodate new or changed data feeds. Proactively diagnose research, monitor and resolve database-related faults and performance problems including high CPU, memory, blocking, deadlocking and timeouts.
• Familiarity with ETL tools like Informatica Power Centre to implement ETL processes and also Business intelligence reporting tools like OBIEE
• and Cognos BI, Oracle Hyperion Essbase and Comfortable with multiple database concepts, i.e. RDBMS, OODB, ODS, Warehouse.
• Knowledge in relational database management systems like Microsoft SQL server 2008, T-SQL, SSIS SQL Server Integration Services for data integration and workflow applications , MySQL, Sybase, datastage, DB2 and multidimensional database related concepts like oracle Essabase Hyperion, OLAP and OLTP tools.
• Creation and maintenance of PL/SQL programs and Shell Scripts. Writing ad-hoc queries and change requests queries CR's based on schema knowledge for various reporting requirements.
• Good working knowledge of job scheduling, monitoring tools and analysing logs to resolve issues/bugs using utility tools.
• Excellent client relation skills, forward-thinking and taking the initiative, being accountable, escalating when necessary and following up to meet goals and exceed customer expectations effectively efficiently.
• Highly motivated target oriented team player with a can-do and will-do mind-set who enjoys working with multi-functional teams towards achieving a common goal and as well as an individual contributor.
• Enthusiastic and quick to adapt new technologies that helps to enhance and give the best at work. Proficient in documenting all day-to-day administration procedures, change controls support activities.

TECHNICAL SKILLS:

• Operating Systems : Windows, Solaris, Linux, Cygwin, VMware.
• Languages : PL/SQL, SQL, Shell, Perl, C, Java, JCL, HTML, COBOL
• Database : DB2, Oracle 9i 10g, 11g, Microsoft SQL Server, IBM Datastage, Informatica PowerCenter, MySQL, Sybase, Oracle Hyperion
• Essbase, OBIEE, IBM Cognos reporting tools.
• IT Software : Oracle SQL Server, PL/SQL Developer, TOAD, Putty, WS-FTP Pro, Log Analysers, Diff utilities, Notepad , Editplus,
• MS Word, Excel, Power Point, Outlook, SharePoint.

PROFESSIONAL EXPERIENCE:

Confidential

Position: PL/SQL and Shell Perl Script Developer

Operating System : Linux, Unix, Windows XP Languages: PL/SQL, SQL, Shell/Perl Scripting Software used:, 11g, Oracle 10g, 9i ssh, SQL Loader, PL/SQL Developer, Toad, SQL Navigator, HTML tools, SharePoint

Responsibilities:

• Developing the Custom Extension to the Reston Technology Inc's DbClone and responding to the New Design requirements. Rewriting the PL/SQL packages and adding new Stored procedures.
• Redesign the DbClone Installation shell/perl Script for RHEL 6 Extend and maintain existing processes to accommodate new or changed custom requirements.
• Implemented auto select of Data Pump or Export and Import for Cross Platform Cloning Traction databases to the DbClone Function.
• Developed ETL specifications, source to target mapping and other documentation required for ETL development. Implement adequate ETL monitoring, validations, data integrity, data modelling and auditing to accurately measure and trend ETL performance.
• Analyse business requirements and system specifications to understand the application processing's.
• Updating the changes to QA environment to reflect the new releases. helop in Developing Shell Scripts for Automatic Testing of Functions and monitor of bug fixes.
• Involved in extensive code-walk through and suggest fixes and redesign for client's new requirements and tasks.
• Documenting the daily QA tasks and updating the share point access repository with new types of issues and resolutions. Develop reports and attended Tech support calls
• Updating operational processing times, production incident issues and scenario process tracking based on each application processing in SharePoint.
• Project Description : DbClone empowers DBAs, Developers, Mangers, and Users to smartly migrate, clone, upgrade, refresh and manage Oracle databases. Its Browser-based console makes it easy-to-use without DBA scripts. DbClone Web Console provides features to remotely manage databases, clone schema objects, and create Standby Databases easily with few mouse clicks.DBA Productivity Business Continuity.
• It enables DBAs to securely delegate the repetitive DBA tasks to authorized users, without revealing database passwords. It saves up to 75 of DBA's time spent in manually designing, scripting, implementing, and managing DBA tasks, thus freeing-up DBA for other critical functions like database backups and
• managing Standby Databases. DbClone provides advanced functions and capabilities to automate and schedule common cloning tasks on Oracle databases during off-peak hours, thus eliminating the need for Oracle database outages and application shutdown during prime business hours. Confidential

Position: IT Analyst PL/SQL Developer

Operating System : Linux, Unix, Windows XP Languages: ETL,PL/SQL, SQL, Shell Scripting Software used: Oracle 10g, 11g, Putty, Excel, SQL Loader, PL/SQL Developer, SQL Navigator, WS FTP Pro, WinSCP tools, SharePoint

Responsibilities:

• Delivering business critical application generate reports on time and responding to the requirements quickly. Receiving the volumes and rates from the Business partners and calculating the costs and make them available in terms of Verification Cross Check Reports.
• Extend and maintain existing ETL processes to accommodate new or changed data feeds.
• Implemented robust ETL processes to extract transform and load data from transactional databases to the Data marts and operational data stores.
• Developed ETL specifications, source to target mapping and other documentation required for ETL development. Implement adequate ETL monitoring, validations, data integrity, data modelling and auditing to accurately measure and trend ETL performance.
• Analyse business requirements and system specifications to understand the application processing's.
• Updating the changes of Companies and cost centre information to reflect all over applications. Application maintenance and scheduled job monitor.
• Involved in extensive code-walk check and organize the client's new requirements and tasks.
• Documenting the daily tasks and updating the share point access repository with new types of issues and resolutions. Prepare daily reports and attend client calls
• Updating operational processing times, production incident issues and scenario process tracking based on each application processing in SharePoint.
• Updating Information related to databases, reports, and business applications in SharePoint and to help team members locate the information they need to make good decisions.

Confidential

Position: Team Leader

• Operating System: Sun Solaris 5.9. Windows 2000/XP
• Languages: PL/SQL, SQL, UNIX Shell Scripting
• Software used: Oracle 9i/10g/11g, TOAD, Oracle Report Builder, SQL Loader, Oracle SQL plus, Report Builder 6i 9i , Edit plus, Excel. Responsibilities:
• Develop reports using Oracle Report Builder and shell scripts for automating report delivery.
• Creation and maintenance of PL/SQL programs and Shell Scripts. Writing ad-hoc queries and change requests queries CR's based on schema knowledge for various reporting requirements.
• Automating various jobs and performance processes tasks by creating scripts and cronjobs.
• Performance tuned many queries and taking back up of cronjobs and shell scripts.
• Debug and optimize SQL queries and stored procedures
• Guiding the co-team members for solution optimization.
• Assist in project planning and scheduling
• Developed Interactive Tool Reports generation for clients
• End-to-End Automation of Metasolv , E-POS CRM module Reports.

Confidential

Position: Team Member

• Operating System: Sun Solaris 5.9. Windows 2000/XP Languages: PL/SQL, SQL, UNIX Shell Scripting
• Software: Oracle 9i, TOAD, Oracle Report Builder, SQL Loader, Report Builder 6i 9i , Edit plus, Excel.

Responsibilities:

• Implemented the data extraction, comparison of data from different Systems like Metasolv, EPOS, HLR, BP, CRM etc and finding the discrepancies by comparing the data with different systems taking Metasolv as the base.
• Finding the route cause analysis for various data descrepancies and fixing the issues in database and clearing the discrepancy data finally.The project involves with below two workflow reconciliations. 1. EPOS-MS-BP-CRM Reconciliation 2. MS-EPOS Reconciliation
• Developed Plsql stored procedures and functions to extract the data from different systems and also code for fixing the route cause of data discrepancies.
• Automated many plsql programs using shell scripts in a such way to get the attached excel sheets of discrepant data to the respective mail Id's.
• Attending meetings and client calls with multi-functional environmental teams.
• Maintaining the repository for issues, incidents and documenting day-to-day tasks.

Confidential

Position: Team Member Operating System: Windows 2000/XP Languages: Mainframes JCL, COBOL, DB2

Responsibilities:

Interaction with client through mails Internal Quality Assessment External Quality Assessment Final Inspection

Confidential

Role: Team Member

Tools and Technology: Mainframes, DB2, COBOL, JCL

Responsibilities : Attending sessions on various Software technologies Programming languages, Operating Systems, Software engineering, TCS proprietary tools etc, Systems Engineering, Requirements Engineering, Testing and Debugging . Performing case studies, assignments on various software technologies. Attending soft skill Session.