SUMMARY:

• Oracle PL SQL Developer with nearly 7.5 years of extensive experience in Oracle 9i/10g/11g, MySQL, MS Access, DB2 8.1, 9.5, TOAD, Oracle Sql Developer, SQL
• Plus, PL SQL Developer, SQL Monitoring, SQL Loader, UNIX (HP - UX), Solaris 9, 10, AIX 5.3, 5.4, SuSe Linux 10.2, Redhat Linux 5.4, Windows XP, server 2003 and server 2008, Eclipse, IRAD, Dimensions, MS-VSS, Clearcase, Vignette 7.3, Documentum 5.3, 6,5, FAST search for SharePoint, IRM 3.4, IBM ClearQuest, Rational
• Team Concert, Infinys Rating and Billing, Java, C/C++, Shell scripting, Perl, SSH, Java, Servlet, JSP, JDBC, Java Scripts, HTML, DHTML, CSS, XSLT, XML, Tomcat 5.0, Websphere application server 5, 6, 7, IIS, HIS, CA Siteminder, Solaris LDAP, MS-Active Directory, DNS, Load balancers- ACE10, GSS
• Over 7.5 years of expertise in UNIX shell scripting and Oracle PL/SQL Programming.
• Expert in Query analysis, performance tuning and optimization with strong hands-on expertise on PLSQL development of packages, stored procedures, functions and triggers.
• Extensively worked on Backend Programming using PL/SQL Stored Procedures, Functions, Packages, Database triggers for Oracle 10g/ 9i/8i, and also SQL queries and scripts.
• Specialized in customization, Interfaces, extensions etc.
• Experience working on Oracle 9i, 10g and 11g database.
• Thrives when managing complex projects and working to tight deadlines.
• Handled multiple projects for various clients in US and other places across the Globe.
• Possess Strong analytical and excellent Communication, planning and organizational skills.
• Possess Strong commitment to team environment with the ability to contribute expertise and follow leadership directives.
• Leveraged diverse, cross functional teams in the fulfillment of corporate productivity.
• Ability to lead change, be personally adaptable, & perform well under pressure.

TECHNICAL SKILLS:

Database: Oracle 9i/10g/11g, MySQL, MS Access, DB2 8.1, 9.5

Database Tools: TOAD, Oracle Sql Developer, SQL Plus, PL SQL Developer, SQL Monitoring, SQL Loader.

Reporting Tools: Cognos, Qlikview

Operating Systems: UNIX (HP - UX), Solaris 9, 10, AIX 5.3, 5.4, SuSe Linux 10.2, Redhat Linux 5.4, Windows XP, server 2003 and server 2008

Languages: Java, C/C++, Shell scripting, perl, SSH

Web Programming: Java, Servlet, JSP, JDBC, Java Scripts, HTML, DHTML, CSS, XSLT, XML

WebServers/AppServers: Tomcat 5.0, Websphere application server 5, 6, 7, IIS, IHS

Development Environment: Eclipse, IRAD

Version control Tools: Dimensions, MS-VSS, Clearcase

Other Products: Vignette 7.3, Documentum 5.3, 6,5, FAST search for SharePoint, IRM 3.4, IBM ClearQuest, Rational Team Concert, Infinys Rating and BillingCA Siteminder, Solaris LDAP, MS-Active Directory, DNS, Loadbalancers- ACE10, GSS

PROFESSIONAL EXPERIENCE:

Confidential, MI

PL / SQL Developer

Responsibilities:

• Involved in LOGICAL and PHYSICAL Modeling for ECM environment
• Design, Develop and Implement SQL, PL/SQL procedures in Oracle and DB2
• Implement and Manage complex report/SQL Queries
• Oracle Query performance tuning using EXPLAINPLAN
• Performance Monitoring and enhancements of legacy reports
• Re-architect application to use advanced shell programming methods and batch programming. This enabled discovering 200 % more software products on remote hosts
• Design and develop UNIX Shell scripts and python scripts for execution on remote hosts using SSH connections
• Design and develop platform independent scripts in python, Perl and expect scripts for automatic software detection on thousands of Unix servers in the company
• Developed WMI and batch scripts for auto detection of software on windows server and client platforms
• Data reconciliation and reporting for the discovered software products using scheduled shell scripts
• Manage preventive maintenance activities on the servers and software products to avoid system outage in product environment
• Design and architect enterprise content management servers using load balancers, ACE devices, web, application and database servers, middleware components like Siteminder, LDAP, WAS and IHS
• Design and implement content management and delivery services to various applications for Confidential that includes test plan preparation, execution and performance analysis.
• Maintenance of various software products and their implementation environment which include managing server refreshes, DNS cutovers with Load Balancer Configurations, webservers, proxies, load balancers, databases and application servers.
• Assessed resource utilization on AIX, Solaris, Linux and Windows platforms using scheduled monitoring shell scripts
• Implemented elegant and easy-to-use hardware monitoring system to provide detailed reports

Environment: Oracle SQL/PLSQL programming, DB2 PL/SQL programming, SQL loader, Qlikview, Cognos and SharePoint integration, SSH, AIX, Linux, Solaris, Bash, ksh, awk, sed scripting, Perl scripting, python and expect coding.

Confidential

Systems Engineer

Responsibilities:

• Design billing and mediation services for corporate services provided by Confidential
• Develop Data stream Decoder scripts for AIX platform for mediation services for communication between the billing system and network devices
• Design test plans and use cases to ensure system functionality
• Configuration of the Rating and Billing software to bill real time usage of telecom services
• Customize the product using PL/SQL Procedures to make the product a best fit to user requirements
• Design and develop customized datamodel to meet the customer requirements
• Adhere to corporate SLAs while handling the support issues
• Developed the web interface to expose the billing system to the customers thus making it useable to end users before the complete OSS/BSS integrated environment is ready

Environment: Oracle SQL/PLSQL programming, DB2 PL/SQL programming, Data stream Decoder (DSD) programming, Tivoli Server Monitoring, Geneva Rating and Billing.

Confidential

Systems Engineer

Responsibilities:

• Configuration of the Rating and Billing software to bill real time usage of telecom services
• Customize the product using PL/SQL Procedures to make the product a best fit to user requirements
• Develop UNIX shell scripts and Data stream Decoders for real time rating and billing of the services offered by Confidential
• Coordination between various teams with in Confidential for end to end OSS/BSS solution testing.
• Used remedy and a custom trouble ticket tracking system for addressing customer issues
• Involved in troubleshooting the system to figure out the problem and root cause
• Worked with auditors to adhere to the SOX and other quality standards

Environment: Oracle SQL/PLSQL programming, DB2 PL/SQL programming, Data stream Decoder (DSD) programming, Tivoli Server Monitoring, Geneva Rating and Billing.