We provide IT Staff Augmentation Services!

Sql And Shell & Perl Script Developer Resume

Reston, VirginiA

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++, EditplusMS Word, Excel, Power Point, Outlook, SharePoint.

Areas/Applications: Customer Relationship Management (CRM), E-POS, TIBCO, Banking and Financial Services, Telecommunication Services, Metasolv reporting module, Interactive Reporting Tool, Oracle Report Builder, ETL, Informatica PowerCentre, PL/SQL Developer, TOAD

PROFESSIONAL EXPERIENCE:

Confidential, Reston, Virginia

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.

Confidential

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

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

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.
  • 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

Team Member

Operating System: Windows 2000/XP

Languages: Mainframes (JCL, COBOL, DB2)

Responsibilities:

  • Interaction with client through mails
  • Confidential Quality Assessment
  • External Quality Assessment
  • Final Inspection

Confidential

Team Member

Tools: 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.

Hire Now