Summary:

• 6 years of IT experience in Banking, Manufacturing, Telecommunication, HealthCare and Pharmaceutical Client/Server based Enterprise applications using high-end databases such as Oracle 11g/10g/9i on UNIX, Linux and Windows environments.
• Experienced working in full-cycle project implementations and all aspects of SDLC viz., Requirement Analysis, Design, Development, Testing and Maintenance.
• Proficient in analyzing business requirements and preparing relevant technical project documentation.
• Experienced in creating stored procedures, Packages, Functions, triggers, materialized views, and other database objects using SQL, PL/SQL.
• Proficient in Oracle Import and Export Utilities and converting legacy data into Oracle Applications using SQL* Loader and PL/ SQL.
• Experienced in troubleshooting and fine tuning SQL using Explain Plan.
• Experienced in Performance tuning SQL, creating indexes, utilizing SQL Trace, TKProf.
• Good understanding of Oracle Data Dictionary, ER Diagrams and RDBMS.
• Skillful in working with the tools like SQL Navigator, SQL Developer, TOAD, Oracle Forms 6i/10g, Oracle Reports 6i/10g for development and customization.
• Experienced in writing UNIX Shell (Korn, BASH) scripts.
• Experience in Unit Testing, System Testing and User Acceptance Testing and creating test cases.
• Target oriented individual with Excellent Communication (both verbal and Written) and Interpersonal skills.
• Good team player, quick learner, self-motivated and possesses the ability to work independently.

Technical Skills:

Operating Systems: HP-UX 11i/10, Solaris 10/8/, RHEL 4.0/5.0, Windows XP/Vista
Languages: SQL, PL/SQL
Scripting Languages: Bourne, Korn Shell Scripting.
Databases: Oracle 11g/10g/9i/8i, SQL Server 2000
Data Modeling Tools: Erwin 4.1
Development Tools: Oracle Forms 9i, Oracle Reports 9i, TOAD 8.0/8.6.
Oracle SQL Developer, SQL Navigator 5.0.
Productivity Tools: Microsoft Office 2003/XP/2000 (Word, Excel, Access)

Client: Confidential, Atlanta, GA May`09 - present
Oracle Developer
Environment: UNIX, Linux, Oracle 11g/10g, SQL, PL/SQL, Data Stage,ETL, Korn Shell, Cognos, SQL Navigator, TOAD, Cognos, Ultra Edit.

Description:
Confidential, a Subsidiary of Confidential, entirely focuses on delivering reliable and secure payment solutions to help businesses succeed in an increasingly complex global marketplace by serving as a single source for payment processing worldwide. It provides powerful payment solutions, flexible connectivity, and effective fraud monitoring tools to customers around the globe, from smaller retail merchants to the largest organizations in segments such as healthcare, hospitality, and the public sector.
Visa Authorization Fees is about the service charge levied by the VISA association to process the merchant transactions based on the volume and type of transactions per billing cycle. The data received from the merchant is analyzed, processed and a merchant bill summary report is generated and billed accordingly.

Responsibilities

• Involved in scoping requirements, preparing technical specification documents by interacting with Business Analysts and end-users
• Participated in code walk through and review sessions with development team.
• Created Mappings to load the data files into dimension tables applying business logic.
• Extensively used Oracle External Tables to write data from various file formats like EBCDIC, .CSV, flat files to Oracle Database to support the ETL process.
• Developed Stored Procedures, Functions, Packages and triggers using PL/SQL to populate the data into various application tables.
• Used collections with bulk collect for accessing complex data resulted from joining of large number of tables to extract data from data warehouse. Generated SQL and PL/SQL scripts to create and drop database objects including Tables, Views.
• Wrote UNIX shell scripts in VI Editor to kick start the loading process and automated jobs crontab.
• Fine tuned application Using Hints, Explain Plan and SQL Trace.
• Used Exception Handling extensively for the ease of debugging and displaying the error messages.
• Developed adhoc reports using COGNOS 8 Report net basing upon the business requirements.

Description:
Confidential, a world leader in micro imaging technology, manufactures photo masks which are an integral component in the lithographic process of semiconductor manufacturing.
E-Mask View is a web based interface that provides quick, reliable and easy to use pattern viewing and job deck viewing of photo masks remotely. The interface is designed to provide customers with the ability to view job layouts prior to manufacturing without having to invest in specialized viewing software or training. It also automates the customer order, provides a reusable and a flexible way for customers to enhance the order processing, order specification validity, streamlining of orders and also lowers the risk of human errors within the organization.

Responsibilities:

• Involved in defining system requirements, developing, testing, training and implementation of the Applications.
• Wrote Oracle stored Procedures, and Packages to meet new features to be incorporated in the System to implement business rules.
• Tuning the application using SQL-TRACE, TKPROF and EXPLAIN PLAN facilities.
• Used Oracle External tables for loading data from Flat files
• Wrote Unix Shell Scripts and scheduled them using cron tab.
• Created Stored Procedures, Packages, Functions to transform the data and worked extensively in PL/SQL
• for various needs of the transformations while loading the data.
• Involved in creating SQL*Loader scripts to load legacy data into oracle staging tables
• Developed an interface in Forms 6i to transmit data on a daily basis from the existing application to
• Developed various complex Reports like Matrix, Summary based on the user requirement.
• Wrote queries to extract data in XML format from tables.
• Generated various statistical reports using Reports 6i based on the migrated data for the review of the Management.
• Developed group, tabular and form Reports, Menus, Object Libraries and PL/SQL LibraryusingOracle Reports Developer 6i.
• Design of User Interface forms for reports to provide user with a selection criteria using forms6i/Reports 6i.

Client: Confidential, Clinton, MS Mar`07- Mar`08
Oracle Developer
Environment: Solaris 10, Korn Shell, Perl, Oracle10g,AIX,Oracle SQL Developer, SQL Navigator 5.0, PVCS, SQL*Loader, Erwin 4.1

Confidential is one of three operating units of Confidential which delivers advanced IP, data, voice and wireless solutions to large business and government. Four way match is a web based reporting tool(system) that provides the functionality to obtain, track and validate data regarding circuit counts across revenue billing, LEC billing(cost) ,provisioning and order entry systems which is critical to Telco cost management. It provides automated, accurate reporting on circuit based costs and circuit based revenue as well as determines the relation between them. The tool furnishes production level reports that can be acted upon to see the impact of non-revenue generating circuits that still have LEC costs.

Responsibilities:

• Involved in translating functional requirements into detailed design requirements.
• Involved in the upgrading of the existing logical and physical data model and
• Created various relational database tables, index organized tables and Partitioned tables.
• Configured the java file extraction process to migrate the data from different databases.
• Wrote shell scripts and scheduled in the crontab to startup the extraction processes per source system.
• Extensively used UTL_FILE package, External tables to write data from flat files to Oracle Database.
• Created SQL*Loader scripts for loading the legacy data into database tables.
• Developed PL/SQL Packages, Stored Procedures and Functions to populate the data in the database tables, generated revenue stream audit reports in Excel Sheets.
• Fine Tuned (performance tuning) SQL queries and PL/SQL blocks for the maximum efficiency and fast response using Oracle Hints, Explain plans and Trace sessions.
• Wrote test plan, test cases, test scripts and prepared the documentation.
• Modified several existing SQL statements for better performance using Explain Plan.
• Created and modified materialized views to enhance the existing reports as per the business requirements.
  

Description:
Confidential is one of the top eye health companies that manufacture soft and rigid gas permeable contact lenses and lens care products and ophthalmic surgical and pharmaceutical products. B&L is currently implementing PeopleSoft SCM (Supply Chain Management) across its global sites in Europe and Asia-Pacific. The Data management group was responsible for gathering, cleaning and standardizing Product SKU’s and maintaining a repository for conversion and reporting activities. It was also entrusted with gathering and cleansing Customer data.

Responsibilities:

• Involved gathering, coordinating and collating inventory SKU’s from ELC, France and Hong Kong sites.
• Creating physical and logical data models for rationalizing items, products and Customer data.
• Created SQL *Loader scripts for populating data in custom tables
• Coding and Performance Tuning number of PL/SQL programs and Packages for assisting the PeopleSoft conversion team in populating Inventory item, product, customer tables
• Wrote Database Triggers and Stored Procedures using PL/SQL to enforce business rules
• Creating partitioned custom tables for generating adhoc reports using SQL queries for cross-verifying data with site managers.
• Setup runtime environment, creating and maintaining Shell script to run Oracle stored Procedures, Packages to populate the data in staging tables.
• Maintaining Rationalized tables in Development, Conversion, Testing and QA environments.
• Extensively used Cursors, Ref Cursors and Exceptions.

Confidential, India Sept`04 - Oct`05
PL/SQL Developer
Environment:Solaris 8, SQL, PLSQL, Oracle 8.0, Oracle Forms 6i,Oracle Reports 6i,Windows 98, MS-Office 2000.

Description:
ILAS is a Client/Server software application designed for the Pharmacy Analytical Research Division (PARD) of the client. Its primary goal was to provide PARD with increased capabilities to track, retrieve, share and compare-regulated data like Lots, Sub lots, Compounds, Service Requests, Projects and finally the results.

Responsibilities:

• Analyzed the Functional requirements using Scenarios and DDD (Detailed Design Document)
• Prepared technical specification document outlining required oracle structures for data capture, process and reporting purpose
• Generated SQL Scripts to create relevant tables, views, synonyms, indexes, sequences for staging, development, test environments
• Coded Interface source, capture and transform logic using PL/SQL Packages, Stored Procedures and Functions.
• Involved in preparing test plans, test cases and manual test scripts to perform data validations
• Coordinated with other team members in Unit, Regression and System testing of backend processing logic
• Generated the detailed reports of the Bugs, Pass-Fail report and comparison chart to fine tune data capture process
• Assisted in setting up Test and Production batch jobs to collate various lab instruments data
• Prepared detailed documentation of the system, specifications, processes and maintenance.

Confidential, India Aug`03- Sep`04
Order-to-Cash System
Application Developer

Environment: SunOS 5.7, Oracle 8i/8.0, Oracle Designer 2000, Developer 2000 (Forms 4.5, Reports 2.5), SQL, PL/SQL, TOAD, Windows NT

Confidential is one of the biggest Transport companies in Andhra Pradesh State, India. This System deals with purchasing, Invoicing, stock calculation, re-order level, etc.,

Responsibilities:

• Performed System Study, Design, Development and Implementation of the system.
• Created various Database Triggers for the system.
• Created various (Back-end) PL/SQL code to implement business rules through triggers, procedures, functions, and packages using SQL*Plus Editor or TOAD.
• Designing Flow charts, F-R Diagrams, E-R Diagrams and partly Server Model Diagram.
• Developed Forms like Invoicing, Delivery Order, Quotation, Stock Inwards, Stock outwards, adjustments etc.,
• Developed Reports like Weekly reports, Daily Stock status report, Weekly, Monthly, and Periodical Reports.
• Fixing Bugs in Forms and Reports previously designed.
• Enabling and Disabling of roles at runtime, based on user responsibility.
• Writing Unix shell scripts to execute the back-end programs on periodic intervals like daily, weekly, fortnight, monthly and yearly basis to update the database.
• Designed menus and responsibilities to different level of users in the organization.
• Documented the business flowchart, user manual and technical manual.
  

Education:
Bachelors in Engineering.