PROFESSIONAL SUMMARY:

• Information Technology professional experienced in various project management methodologies (including Waterfall, Agile and Scrum) to achieve corporate objectives, streamline business processes and increase bottom - line results.
• Having 10.5 years of experience in various domains (comprising Retail, Banking, Mortgage, Telecommunication, and Manufacturing) to successfully design, develop, deploy and support software applications/processes.
• Worked in all aspects of software development life cycle i.e. requirement analysis, design, development, testing, deployment and maintenance.
• Experienced in analyzing functional requirements, interacting with clients/users and preparing relevant technical design documentation.
• Worked in OLTP (Online Transaction Processing) and OLAP (Online Analytical Processing) Environments.
• Proven experience in design, development of relational database applications, data migration processes and ETL processes.
• Well-versed in creating oracle stored procedures, functions, packages, triggers, materialized views, and other database objects using Oracle sql, pl/sql.
• Experienced in troubleshooting and Performance tuning ETL/Transaction processes using explain plan, by creating indexes, sql trace/tkprof, and hints.
• Experienced in creating unix shell scripts to automate the business processes and scheduling using Control-M.
• Created business intelligence reports using Business Objects and oracle reports 6i as per the requirements and automated the execution as per the specified interval (daily, weekly, or monthly).
• Experienced in unit testing, user acceptance testing and creating test cases and resolving the issues by coordinating with the business analysts and end users.
• Good team player, quick learner, target oriented individual with excellent communication and interpersonal skills, also possess the ability to work independently.

TECHNICAL SKILLS:

Operating Systems: AIX 5.3, Windows 7, HP-UX 11i/10, Solaris 10/8/, RHEL 5.0

Programming Languages: SQL, PL/SQL, Unix Shell Scripting

Databases: Oracle 11g/10g, SQL Server 2008 R2

Development Tools: TOAD 10.6.1,SQL Navigator 5.0, SQL Developer.

Reporting Tools: Business Objects, Oracle Reports 6.0.

ETL Tools: Informatica 9.1/9.6.1

ERP Software: Oracle E-Business Suite 11.5.10.

Productivity Tools: Microsoft Office 2010(Word, Excel, Power Point), Ultra Edit, Notepad++

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Sr. Oracle PL/SQL Developer

Responsibilities:

• Designed, Developed interfaces to post the ADP General Ledger, E-commerce General Ledger transactions into the finance application (INFOR) automatically for every financial billing cycle and created html report to display the invalid GL Accounts as per the business validation criteria using Cursors, Oracle PL/SQL Stored Procedures and Packages.
• Designed, Developed and automated the process of loading the currency conversion rates from external source (OANDA) through PL/SQL Stored Procedures/Packages and transmitted to the downstream applications using row level triggers.
• Customized the standard data model by creating a custom database table by maintaining the data integrity. Eg: Upload Cost factors into costing module tables:
• Created an upload process using various cost factors by country and generated required cost sheets, period standard cost for every item in the upload sheet.
• Designed, developed and implemented the reconciliation process for the point of sales (POS) Credit Card/Cash transactions, adjustments using Recon NET and automated the process using Oracle PL/SQL (Stored Procedures, Packages), unix shell script and Control-M.
• Designed and implemented the bank reconciliation process to compare the cheques cleared by the bank with the accounts payable team using Oracle PL/SQL and automated the process using shell script and scheduled them using Control-M job.
• Created views to limit the data manipulation access to the end users and created materialized views to capture the data from the external database.
• Performance tuned SQL queries by using explain plan, Creating function based indexes, b* tree indexes, bitmap indexes for the queries associated with the business objects reports.
• Performance tuned the General Ledger Data Processing using PL/SQL and reduced the processing time from 11 hours to 3 hours by range partitioning the base tables comprising data of about 25 Million rows. Used bulk collect and FORALL programming features to process the data with effective performance and fixed the bottle necks for the existing processes by creating appropriate indexes.
• Modified Existing Process flows by changing the base queries, re-mapped the Source Fields to the New Fields, deleted the unwanted Fields from the Mappings, Modified the Server Connections, and tested the workflow as part of Upgrade of the Sales Audit Application (APTOS).
• Extensively worked on scheduling and DWH batch processing of workflows through Control-M.
• Created Business Objects Reports and modified existing ones as per the business requirements and automated them to execute as per the specified interval (Daily, Weekly, and monthly).
• Used Analytical Functions like SUM, AVG, RANK, LEAD and LAG to create bobj reports as per the business requirements.
• Created Adhoc Excel Reports (Related to Accounts Payable and Accounts Receivables) using Oracle SQL and PL/SQL as per the Business Requirements.
• Created Change Requests and got approvals from the Managers, Directors by performing the Unit Testing and User Acceptance Testing (UAT) for all the applications, documented the Test Case Scenarios and assigned the tasks to the concerned groups to get the code deployed in production.
• Interacted with the Cross Functional teams such as the Migration team, Integration team, Business Analysts, DBA Team, Unix Admin Team, IT Security Team, to resolve miscellaneous tasks like FTP,SFTP set up(with external clients), setting up business account for rendering services of external clients, creating database links to extract data from external servers etc.
• Developed Migration Scripts to migrate the data from Legacy Finance Applications (INFOR, COMPUTRON) into SAP.
• Provided extensive production support by monitoring, managing, communicating the critical issues to the appropriate user group and fixing them with approval from the business after testing.

Environment: Infor, Computron, Jesta, Recon NET, AIX 6.3, Oracle 11g/10g, TOAD 10.3, SQL Server 2008 R2, Informatica 9.1/9.6.1, Control-M, Business Objects, SAP.

Confidential, Charlotte, NC

Sr. Oracle PL/SQL Developer

Responsibilities:

• Participated in the walk through the existing application code to understand the business process flow.
• Created/documented test cases for the existing application to understand the business process, data flow and captured all the results into a table.
• Converted the functional requirements into the technical requirements and created a technical design document.
• Created stored procedures to extract the data from source table, transformed as per the business logic and loaded into the target table.
• Created stored functions to perform calculations on the raw data and accessed through procedures while processing the data as per the business logic.
• Created Packages comprising of stored procedures and functions as per business requirements to process the data requests from the front end (Java).
• Performance tuned sql queries using explain plan, indexes, and tweaked the order of the filter conditions to reduce the execution time.
• Unit tested the code in the development environment and deployed them in the UAT Environments.

Environment: UNIX, Oracle 11g, PL/SQL, TOAD 10.0, Autosys, Datastage, SVN, Share-Point.

Confidential, Lewisville, TX

Sr. Oracle PL/SQL Developer

Responsibilities:

• Involved in re-architecture of the existing data model to drive the existing application Confidential the Meta data level.
• Created the ER Diagram by reverse engineering of the database objects using toad data modeler.
• Created/updated conceptual, logical and physical data models using OLTP best practices and according to company standards.
• Created DDL scripts as per the data model and implemented them in the database.
• Worked with the Application Development team to implement data strategies and build data flows.
• Analyzed the functional requirements and prepared the technical design document for various change requests.
• Translated business processes into Informatica mappings for building data marts.
• Developed code to extract, transform, and load (ETL) data from inbound flat files and various databases into various outbound files involving complex business logic using Informatica Designer/Power Centre.
• Used Informatica Power Center for conversion of the data, transforming, reconciling the different data types and delivering that data to the downstream system decreasing the risk and also minimizing the errors associated.
• Created stored procedures, functions and packages as per the business requirements and used them to populate the data into the master table and generated XML out of it which was the source file for downstream application.
• Used bulk collect and FORALL programming features to process the data with effective performance.
• Created row level triggers to auto-number the data while inserting, to capture the historical data into archive tables during any insert/update operations on the tables.
• Created complex views and performance tuned them which were the sources to the downstream applications.
• Used analytical functions extensively like XML ELEMENT, STRAGG, and RANK to generate adhoc reports as per the business requirements.
• Created shell scripts to automate the process of generating the XML's after successful verification by the business analysts.
• Created Implementation plans to deploy the code in database in UAT and production environments.
• Coordinated with QA and UAT teams to test the modifications made to the existing application, and resolved the defects rose in HPQC tool.
• Provided production support to resolve issues and address the unique needs of the business users.

Environment: Unix, Oracle 11g, PL/SQL, HPQC 10.0, TOAD 10.0, Informatica 9.1, SVN, SharePoint.

Confidential, Atlanta, GA

Sr. Oracle Developer/Release Coordinator

Responsibilities:

• Application monitoring using introscope to resolve the alerts and correlating it to the impact of business and customers.
• Created and deployed the SQL Scripts in production as per the adhoc business requirements.
• Created an automated process to export the database objects from one schema to the other to in building a production like test environment.
• Provided on-call support and created Trouble Tickets (AOTS TT’s) for Production issues of the application and coordinated with teams which were being impacted by the issue to resolve it.
• Created change requests (AOTS CR’s) as per business requirements and coordinated with the teams for successful deployment of the Release.
• Triaged calls to find out the root cause of the issue and generated the reports of impact to the applications to the higher management.
• Was responsible for coordinating on-site/offshore for Release Deployments and Knowledge Transfer.

Environment: Solaris, UNIX, Oracle 10g, Introscope, AOTS, SharePoint, TOAD, SQL, PL/SQL, Web logic.

Confidential, Tampa, FL

Mid-Level Oracle PL/SQL Developer

Responsibilities:

• Participated in code walk through of the existing applications and review sessions with development team.
• Involved in the design calls to understand the new business requirements.
• Created E-R diagram by reverse engineering the existing table structures, enhanced it with new tables to support the business requirements of the application.
• Developed ETL process using stored procedures, functions and packages to migrate the data from SQL Server to Oracle Database.
• Performance tuned sql queries and pl/sql code for the better performance using explain plans and by creating the indexes.
• Used export, import and oracle data pump to replicate the schemas for creating test environment.
• Involved in testing the custom applications, created test plan, documented the test cases and coordinated with the business and the development teams in resolving the issues.
• Provided extensive production support for applications and resolved the bug fixes by coordinating with the business users.

Environment: Solaris, Oracle 10g, SQL Server 2005, TOAD, SQL Navigator, Clear case, Erwin.

Confidential, Atlanta, GA

Mid-Level Oracle PL/SQL Developer

Responsibilities:

• Participated in code walk through and review sessions with development team.
• Involved in scoping requirements, preparing technical specification documents by interacting with business analysts and end-users.
• Created source to target mappings to load the data from data files into dimension tables applying business logic.
• Extensively used oracle external tables to read data from various file formats like EBCDIC, .CSV, flat files and load it into database tables.
• 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.
• Used exception handling extensively for the ease of debugging and displaying the error messages.
• Developed adhoc reports using cognos to display the number of transactions of a given merchant on weekly, monthly and quarterly basis.
• Used oracle data pump to export some tables from one schema to the other for replicating the data in order to test the application.

Environment: Unix, Oracle 11g, Data stage, Cognos, SQL Navigator, TOAD, Clear case, Ultra Edit.

Confidential, Round Rock, TX

Jr. Oracle EBS Developer

Responsibilities:

• Involved in gathering business requirements, analysis and defining technical requirements.
• Created technical design documentation as per the functional requirements.
• Created stored procedures, packages, and functions to transform the source data files and loaded into the target tables.
• Created unix shell scripts to automate the business processes and scheduled them using cron tab.
• Performance tuned the processes using explain plan, creating indexes, using sql trace and tkprof.
• Developed an interface to transmit data on a daily basis from the mainstream application to downstream applications.
• Developed complex matrix reports, html reports, adhoc excel reports as per the business requirements.
• Generated various statistical reports using oracle reports builder based on the migrated data for the review of the management.
• Developed group, tabular and form reports, menus, and object libraries using oracle reports developer.
• Designed user interface forms using oracle forms builder to provide user with a column selection criteria to generate reports.

Environment: Solaris,Oracle10g, Java, Oracle Forms/Reports,Oracle EBS 11.5.10, TOAD 9.0.

Confidential, Clinton, MS

Jr. Oracle PL/SQL Developer

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.
• Created and modified materialized views by adding new fields to enhance the existing business reports as per the requirements.
• Created SQL*Loader scripts, external tables to load the date from source files 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.
• Created test plan, test scripts, documented the test scenarios, and coordinated with the business users on resolution.
• Performance tuned sql queries and pl/sql blocks for the maximum efficiency and fast response using explain plan, using indexes and hints.

Environment: Solaris 10, Oracle10g, Java, PL/SQL, SQL Navigator 5.0, PVCS, Erwin 4.1