SUMMARY

• 9+ years of IT experience as a Programmer Analyst, Developer and Tech Lead includes development, analysis and maintenance of applications using Oracle 11g, 10g, 9i, 8i, PL/SQL Developer, SQL Server, MYSQL, Power Builder, Web Application Server, by I Want This">Java and Web Tools
• Worked on all stages of SDLC (Software Development Life Cycle) including requirement analysis, design, development, testing and implementation.
• Acquired sound knowledge of ORACLE PL/SQL Engine Architecture.
• Possesses expert skills in the development of applications utilizing Oracle tools including Oracle PL/SQL, SQL Plus, SQL Loader, SQL Server, MYSQL, Forms and Reports, and experience with PL/SQL back - end programming - Database Triggers, Views, Packages, Stored Procedures, Cursors, Functions and Management of Schema Objects.
• Strong experience in using UNIX platform with shell scripting and sqlldr scripts.
• Extensive experience in system development, implementation, maintenance and conversion of varied information systems and testing tools.
• Thorough understanding of Data Warehousing ETL Concepts
• Intermediate level skills of Java Programming and Power Builder.
• Fair knowledge on web based software development and usage of programming tool Java such as JDBC connection and establishing relationship with Oracle databases.
• Possesses thorough understanding of RDBMS architecture, data warehousing, Logical and Physical design of the databases, expertise in SQL - DML and DDL
• Acquired intermediate level DBA skills including - Oracle installations, upgrades and migrations, creation and management of tablespaces, data files, users, roles and privileges
• Designed and developed Technical design documents using Oracle AIM Method.
• Conversant with SOX Compliance Procedures & Standards, ISO 9001 quality procedures, while executing projects.
• Highly flexible and capable of learning new tools and applications. Well versed with business analysis and end-user requirement analysis.
• Excellent communication and interpersonal skills, with the ability to manage responsibilities individually or as part of a team environment

TECHNICAL SKILLS

Skills: Oracle 8i/9i/10g/11g, PL-SQL, SQL Server 2008, MY SQL, Power builder, Perl Script, Java-J2EE, MS Access 2003, IIS as .Net Framework 2.0, Visual Interdev6.0, Visual Source Safe 6.0, HTML/XML, Unix Shell Scripting, Linux, C

Web Servers: Apache Tomcat Server, Internet Information Server 4.0/5.0

Operating Systems: Windows 95/98/NT/2000/XP/2003, MS-DOS, UNIX, Linux

Web Tools: HTML, XML, JavaScript, UML

Other tools: MSOffice 2000, TOAD, SQL* Plus, PL/SQL Developer, Microsoft Access, SQL Server, MySQL, SQL* Loader, Notepad++,WINMERGE, XML, & TEXTPAD, Oracle AIM, UML, Remedy

Trained Skills: C, C++, OS concepts, RDBMS, QMS - OOAD, Oracle, Unix, Linux

Domain Skills: Energy, Oil & Gas (downstream)

Linguistic Skills: English, Hindi, Telugu

PROFESSIONAL EXPERIENCE

Confidential, Waukegan, IL

PL/SQL Developer

Responsibilities:

• Involved in gathering requirements, analysis, developing, testing and providing post production support
• Developed PL/SQL objects that include stored procedures, packages, functions, views and triggers to regulate and maintain data in Oracle database.
• Modified the existing objects as per the requirements to separate the Abbott divisions from Confidential divisions.
• Have done database objects and data verification for the database migration from v11.1.0 to v11.2.0.
• UNIX Shell scripting to automate the manual activities in sending data to other interfaces.
• Migrated shell scripting from UNIX to LINUX environment.
• Developed and tuned complex SQL queries, PL/SQL procedures.
• Validated test cases and test results to ensure integrity after incorporating the changes.

Environment: Oracle 11g, SQL, PL/SQL, UNIX, LINUX, TOAD, SQL Developer, WINMERGE, MKS

Confidential, Warrenville, IL

Technical Lead

Responsibilities:

• Involved in gathering requirements, analysis, QA and providing post production support
• Replaced the TMS 5 system with the TMS 6 system for each of the 23 terminals that went live under this project.
• Combined the TMS Host East and west host to single host, replicated current system functionality with the new system.
• Implemented data migration from SCDB code set to SAP Code set.
• Interacted and coordinated with Development and Technical leads for daily status and any a follow up of outstanding issues.
• Created Objects for Integration project and Data Warehouse - Fact tables, dimension tables, table partitions, sub-partitions, B-Tree and Bitmap indexes, summary tables, materialized views, stored procedures, packages, functions and procedures with parallel queries
• Developed PL/SQL objects that include over 400 stored procedures, packages functions and triggers to regulate and maintain data in Oracle database.
• Refreshed Oracle schemas between various non production environments and ensured databases are synchronized during development phase.
• Built Unix Shell Scripts for archiving tables for a particular run & automated scripts to RUN STATS(ANALYZE) on various tables & create reports on the same.
• Developed a tool to Use UTL FILE Package to create processed data file for the clients.
• Migrated large tables using Oracle Data pump export and import methods.
• Created Indexes and Materialized Views to improve the overall system performance.
• Developed and tuned complex SQL queries, PL/SQL procedures.
• Validated test scenarios and test cases to ensure integrity after incorporating the changes

Environment: Oracle 11g, SQL, PL/SQL, UNIX, Perl, TMS software provided by Toptech, MYSQL, TOAD, SQL Developer, WINMERGE, XML, Oracle AIM, UML, TMS underlying operating system (QNX)

Confidential, Warrenville, IL

Team Lead

Responsibilities:

• Provided primary and secondary support to Confidential platinum and pricing applications including Pricing Revenue Optimization software (PROS), Amoco light Oil Pricing system (ALPS), Amoco retails pricing system (ARPS) and Pricing website.
• Developed several database PL/SQL objects - Triggers, procedures, packages, functions, And integrity constraints for application development, maintaining data consistency
• Performed version upgrades and installed patches of PROS product.
• Migrated and Converted PROS application from SQL Server to Oracle RDBMS.
• Coordinated and scheduled changes to database based on requirements.
• Monitored performance, established a process to monitor existing systems for performance problems, documented outage processes and systems migration plan for future.
• Participated and handled external SOX audits each quarter. As a Primary support, responsible to allocate and look forward to the work of 5 associates from PROS perspective.
• Developed application program code in Oracle, SQL Server 2008
• Provided estimates and carried out all project activities related to Pricing applications like Upgrades, enhancements and testing.
• Involved in QA, performance tuning, production support and break fixes.
• Verified the implementation and ensured that the delivered processes are consistent with the design consensus and met the requirements.
• Worked as a Security Administrator for the Confidential platinum applications and was responsible for managing user access for Pricing applications front end and data security on the database.
• Resolved problems accessing applications; keep current with ongoing security changes, upgrades, policies and procedures.
• Provided primary support to day-to-day PROS and Pricing application activities by resolving various issues/tickets posed by the client from time to time.
• Documented technical procedures as part of application development for junior associates

Environment: UNIX, Windows 2000/2003, SQL,PL/SQL, Power Builder 10, Perl Script, Java, IIS as .Net Framework 2.0, Visual Interdev6.0, Visual Source Safe 6.0, Unix Shell Scripting, Perl, C, PROS, Oracle 10g/11g, SQL server 2008, TOAD, WINMERGE, XML,UML, Oracle AIM

Confidential, Warrenville, IL

Test Lead

Responsibilities:

• Designed, created and modified Database objects including Tables, Indexes, Packages, Procedures, Functions and Exceptions.
• Extensively worked on creating UML diagrams including Use Case Diagrams, Class Diagrams, Sequence Diagrams and Activity Diagrams.
• Designed a workflow management system to streamline the process.
• Analyzed and coordinated the business requirements of the project by studying the Business Requirement Specification document.
• Gathered the requirements from the users and analyzed their business needs and created SRS documents.
• Involved in SDLC including designing, coding and testing.
• Extracted data from Flat files and transformed it in accordance with the Business logic mentioned by the client using SQL*Loader.
• Modified existing codes and developed PL/SQL packages to perform Certain Specialized functions/enhancement on Application.
• Analyzed explain plans for the SQL queries and improved performance by tuning them
• Developed complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables.
• Built UNIX Shell Scripts to Schedule jobs in CRON tab to automate tasks of loading data into Tables.

Environment: UNIX, Oracle 11g, SQL, PL/SQL, MS Office, TOAD, WINMERGE, XML, Oracle AIM, UML

Confidential, Warrenville, IL

Software Developer

Responsibilities:

• Provided support and maintenance to the Confidential platinum pricing applications
• Designed, developed and tested business process components for providing stability and integration of the environment for the applications
• Coordinated closely with Quality Control, Change Management and Quality Assurance team
• Involved in QA, performance tuning, and production support and break fixes
• Worked as a Security Administrator for the Confidential platinum applications.
• Regulated business sensitive data for pricing applications in SOX compliant application strictly adhering to security rules undergoing SOX security audit every quarter.
• Administered creation and deletion of Ids for employees and leased workers of Confidential Review groups and application access for people changing jobs.
• Participated and handled external SOX audits each quarter.
• Implemented and conducted audits, participated in technical walkthroughs of other team members, component test plans and results.
• Provided estimates and carried out all project activities related to Pricing applications like Upgrades, enhancements and testing.
• Adhered to the business standards and improved quality procedures related to the project.

Environment: UNIX, Windows 2000/2003, PL/SQL, PowerBuilder 10, Unix Shell Scripting, Perl Scripting, Java, IIS as .Net Framework 2.0, Visual Interdev6.0, Visual Source Safe 6.0, Perl, XML, UML

Confidential

Oracle Developer

Responsibilities:

• Built SQL scripts to create new database objects - tables, views, indexes, integrity constraints as part of application enhancements using SQL*Plus, TOAD.
• Created indexes on the tables to avoid full table scans and for faster retrieval of data.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.
• Developed SQL*Loader Script to load staging area using data from flat files (CSV files).
• Involved in validating the data while data migration by creating PL/SQL Packages, Procedures, Functions, Triggers.
• Created Unix Shell Scripts for automating the execution process

Environment: UNIX, Windows 98/2000/2003/ XP, SQL, PL/SQL, Oracle 9i, Forms 6i