Climber_bannerad_300x250_15s

Want your profile here?

Becoming a member is easy!

Climber.com works with you to help you advance your career by putting you directly in front of tens of thousands of recruiters in your field. Sign up today on Climber.com

RssSenior Oracle Developer

APARNA KASTURI ORACLE DEVELOPER PROFESSIONAL SUMMARY Result-oriented and motivated Oracle consultant offers over Five years experience in business analysis, process design, full life cycle implementation including requirement gathering, design, development, implementation, testing and user training.Proven track record of success in implementing Oracle technical solutions for businesses in a cross section of industries. ORACLE SKILLS EXPERTISE: o Experience in writing, testing and implementing of the triggers, Procedures, Functions at Database level and form level using ORACLE PL/SQL o Customized Forms and Reports 6i and 10g. o Created Custom Reports using XML Publisher and Oracle Discoverer. o Extracted data from Oracle into various flat files using utl_file functionality. o Experience in performance tuning for SQL Queries , Procedure and oracle tables etc using Explain Plan, SQL Trace and Oracle TKPROF. o Gathered requirements from users and prepared documents. o Prepared testing environments for customizations. o Well-versed in Business Flows and AIM Documentation Methodologies. o Developed PL/SQL interfaces for Kronos, Aflac, Ceridian, and ADP payrolls in providing extracts for Benefit Enrollments, Payroll Elements and Assignment Salaries. o Prepared technical documentation and GAP Requirements Documents o Possesses excellent interpersonal skills, able to communicate with staff and clients at all levels in an organization. ORACLE SKILLS SUMMARY Category Skill Name Year Last Used # Years Exp Oracle Technical PL/SQL Wrapper Programs, Data Conversions, Forms, Reports, Interfaces, Extracts, Inbound and Outbound Programs. 2010 7 Environment UNIX, Windows 95/98, 2000, NT, Oracle 8.x, Oracle 9i 2010 7 Tools Sql Plus, Toad, Sql Loader, Developer 2000/6i, Discoverer, XML 2010 7 Methods Oracle AIM for Documentation and Test Scripts preparation 2010 7 CAREER SYNOPSIS National Express Corporation Dec ’08 – Sep ‘09 Sr. Oracle Consultant Responsibilities: • Developed ADP check printing and garnishments interfaces for Canadian Business Group using PL/SQL packages and utl_file functionality. • Developed code for loading contacts and contact relationships into oracle HR tables from flat files using sql*Loader and API’s. • Developed HR Payroll and OAB reports like New Hire Compliance, Payroll Audit, Personnel Changes report, Local Tax Audit, Benefits Enrollment Confirmation, 401k/RRSP using oracle reports 10g. • Developed Database Triggers to enforce Data integrity and additional Referential Integrity. • Created Oracle forms and Reports 10g from scatch and worked on maintenance • Created technical and functional design documents based on the business team’s requirement inputs. • Involved in data mapping of legacy data to Oracle Applications. Wrote Open Interfaces for the Data Conversion and Data Validation using PL/SQL. Created temp tables in Oracle to load the data and wrote control file for the transfer of the data through Sql*Loader. METRO, St Louis, MO Nov ’07 – Nov ‘08 Sr. Oracle Consultant Responsibilities: • Imported data through various environments by using SQL Loader. • Configured position hierarchy for the Metro Organizational Structure. Metro has a shared HR system and needed position hierarchy for costing and reporting purposes. Interfaced directly with the payroll manager to prepare an org chart for each individual department and loaded the hierarchy into Oracle. • Developed custom xml reports using XML Publisher responsibility. • Migrated custom tables and concurrent programs between development and Test instances using FNDLOAD. Documented deployment procedure for every migration. • Developed new forms and reports based on user requirements for client modules in Oracle forms 10g and reports 10g. • Responsible for enhancements and defect correction of accounts receivable standard reports such as billing and report history using Oracle Reports 6i and 10g. The business need was for additional fields and calculations in the existing reports. Interfaced directly with the business user to gather requirements and customize the reports. Tested them in DEV and TEST environment and migrated to production. • Worked on Very Large Database Environment and tuned queries for performance. • Used SQLServer to run scripts for executing Kronos and Cyborg extracts to load data into Oracle. • Wrote SQL programs to run weekly extracts for payroll providers, benefits third party providers like AFLAC. City of Philadelphia, Philadelphia, PA Mar ‘07- Nov ‘07 Oracle Consultant Responsibilities: • Created PL/SQL packages, Stored Procedures, Functions and Triggers • Involved in data mapping of legacy data to Oracle Applications. Wrote Open Interfaces for the data conversion and data validation using PL/SQL. Created temp tables in Oracle to load the data and wrote control file for the transfer of the data through Sql*Loader. • Wrote conversion programs using API”s for Locations, Organizations, Jobs, Positions, Grades, Employees, Addresses, Phones, Contacts, Contracts, Assignments, Extra Information Types, Salary, Personal Payment Methods, SITs, EITs. • Gathered report requirements from business users and developed custom reports in 10g. • Developed forms and reports from scratch based on user requirements for client modules in Oracle forms 10g and reports 10g. • Worked on SQL statement tuning using SQL Trace, Analyze and Explain Plan utilities • Responsible for creating BI reports using Oracle Discoverer ATMOS Energy, Dallas, TX Nov ‘06- Feb ‘07 Oracle Consultant Responsibilities: • Tuning of queries, procedures and functions for better performance using TKPROF and explain plan utilities • Involved in data mapping of legacy data to Oracle Applications. • Wrote Open Interfaces for the Data Conversion and data validation using PL/SQL. Created temp tables in Oracle to load the data and wrote control file for the transfer of the data through Sql*Loader. • Generated a Unix program to autopopulate retired Benefits data from third party vendors into Oracle Pay User Tables. • Developed extracts for payroll providers, benefits third party providers. • Instituted a Payroll PL/SQL package to compute paid hours and wages per each work location. HI-Tech Computers Jan ‘03 - Aug ‘04 Oracle Consultant • Wrote PL/SQL procedures to obtain the data from the Oracle Application Tables and validated them with the business requirements of the clients. This data was being used for business continuity purposes, and involved the data extraction from Oracle Legacy, creation of flat file in Excel, conversion of the data and use of Sql*Loader to load data onto the Oracle Application. • Crafted PL/SQL Inbound and Outbound interface programs in Oracle HR, Payroll and Standard Benefits modules. • Prepared data mapping document of legacy payroll system to Oracle Payroll system for conversion of Payroll Elements and Balances. Forte Hospital Services Apr ‘02 – Dec ‘02 Oracle Consultant • Created PL/SQL procedures to obtain the data from the Oracle Application Tables and validated them with the business requirements of the clients. This data was being used for business continuity purposes, and involved the Data Extraction from Oracle Legacy, creation of Flat file in Excel, and the conversion of the data and use of Sql*Loader to load data onto Oracle Application. • Gathered and stored employees’ emergency contact information in a special system application. • Performed various ad-hoc SQL queries and PL/SQL procedures to extract data from the Apps database. The extracted data was converted to CSV file and later loaded into the System. • Prepared conversion documents such as CV060, CV040, CV050 and TE020s. Customized Reports and Interfaces. Wrote MD 70 documentation for all work. The work involved identifying the interface tables, the data to be populated and processes to be completed. EDUCATION: • Oracle Certified Associate • Masters of Science in Engineering, George Mason University, Fairfax, Virginia • Bachelors Degree in Engineering, Osmania University, India

Developer

Saint Louis, MO

About Me

Industry:

Information Technology

Occupation:

Developer
 

Education level:

Master

Will Relocate:

Yes

Location:

Saint Louis, MO

Keywords