Oracle Certified Associate (91)
Resume:
Chanderkala K Anand
Carmel, Indiana 46032 hje0k5@r.postjobfree.com
SUMMARY
Oracle Certified Associate (9i) with over ten years of Data Processing experience in Design, Development and Implementation of data software packages. Extensive experience in developing Interfaces and modules that feed data streams into the Oracle host system. Broad industry experience with functional/data requirement analysis, systems analysis, programming, trouble shooting, unit testing and documentation preparation.
SOFTWARE CONSULTING EXPERIENCE
Cyberdata Technology, Inc. Mar 2009 – Sep 2009
Indianapolis, Indiana
Oracle Developer/Analyst
Responsible for analysis of business and technical requirements for the Recovery Act for Business Transformation Agency (BTA). This project provides the means for Accountability and Transparency for the DOD mandated processes in the President’s directive.
Developed views and a package from business requirements to provide data for Business Intelligence Oracle data warehouse. This data consists of the associated contract, contract modifications and the DCD line of accounting, which meets the identifying criteria, specified in the Recovery Act. Implemented reporting Interface data structures incorporated XML data sources and used external tables to populate reporting tables.
Modified the code for the Travel Pay System to prevent the overwriting of the error files when the incoming files had errors.
Added a cognizant accounting center to the existing Travel Pay System to process travel data from various services. (Marines, Army, Navy & Air Force)
Indecon, Inc. Jun 2008 – Jan 2009
Indianapolis, Indiana
Oracle Developer/Analyst
Responsible for writing and creating design documents for ICWIS system for DCS (Department of Child Services). Caseworkers and their supervisors mainly use ICWIS for Investigation Assessment and for creating a Case Plan for the child in effort for prevention and treatment of child abuse and child neglect. It also deals with child support, adoption and foster care. The final goal of the ICWIS System is to partner with families and communities to provide safe, nurturing and stable homes.
Worked on Case Plan and Case Plan Details for the child in question.
Extracted requirements from the existing power builder application, and also gathered requirements from caseworkers for the new application with the infragestics as the front end.
Analyzed the requirements for enhancements and worked with Infragestics developers for crating the application.
Created PL/SQL packages for Infragestics front end application.
Altered oracle tables to accommodate the changes in design.
Used sys_refcursors for populating the front-end screens.
Synectics, Inc. Jun 2006 –May 2008
Indianapolis, Indiana
Oracle Developer
Responsible for writing technical requirements and creating design documents for JAM. Creating, troubleshooting and enhancing complex forms and reports for JAM. The application (JAM) is AT&T’s Construction and Management tool. In a single application JAM provides a standard platform for creating high level preliminary cost estimates, creating detailed project cost estimates, ordering and inventorying material and services, reporting construction time and material disbursement and tracing job progress
Created Database triggers, and also wrote database triggers to avoid mutation of tables.
Wrote a procedure to skip a locked record while performing DML operations on a table.
Designed and created new admin forms to meet the new requirements due to the merger with other telecom companies.
State of Indiana, Department Of Revenue Apr 2004 –Jun 2006
Indianapolis, Indiana
Application System Analyst/Programmer - Specialist
Responsible for determining system requirements, creating technical specifications/designing applications, estimating hours needed for developing various modules and developing / maintaining large complex modules critical to the application.
Designed PL/SQL packages for Contract Procurement, Not for Profit Organizations, Non Gaming Tax Refunds and Warrants Staging for Non Payment of Taxes for Taxpayers change of residence.
Enhanced forms for Tax accounting and Tax registration.
Created the new Tax Form IT-40PNR (2005). Modified several existing procedures for posting
of individual returns.
Ran Explain Plans and optimized SQL statements in the existing and new programs.
Modified and maintained forms and procedures for the Refunds to individuals, trusts and corporations. The process was re-designed to overcome inconsistencies in the system, which resulted in reducing the number of suspended transactions. This also reduced the penalties and interest paid to the taxpayers.
Enhanced the form BT-1 to accommodate different counties and townships for registration of food and beverage tax. Modified the same form to include the Tire Fee Tax. (TIF)
Modified large existing Cobol module, which posts various tax types to the Financial Tables.
Worked with the SQA group to assist them in solving system problems and enhancing the applications to increase the efficiency of the users.
Mentored co-workers in using and writing Oracle packages. Active in Peer assistance.
Kforce, Inc. Aug 1999 – Oct 2003
Indianapolis, Indiana
Software Engineer
Responsible for determining system requirements, creating technical specifications/design, data modeling, estimating hours needed for developing various modules and developing / maintaining large complex modules critical to the application.
Developer/Programmer for sub systems Sysadmin (System Administration) and Interfaces, a $10.0M deployable disbursing system, for the US Army. The new software will replace a DOS based system. It will provide a significant improvement in efficiency in tracking accountability and carrying out financial transactions at main and field sites. The application uses Personal Oracle 8i as the database and Forms as the GUI interface to carryout the transactions along with Reports for presenting data.
Translated the functional (business) requirements into design documents during the initial phase of the project. Created process flow diagrams using Designer (6.0) and technical designs that were formally presented to the functional staff for their approval in a CDR (Comprehensive Design Review).
Participated in peer reviews for the assigned sub-system of the application to enhance, optimize and improve the functionality of various parts of the application. Helped in devising the technical design for the Interface and Sysadmin sub-systems.
During the development phase created PL/SQL packages, PLLs (PL/SQL Libraries), olbs (object libraries), server & client side procedures, packages and functions for the assigned SCRs. Developed a module (object group), accounting line component that was used for various collection/disbursing operations. The use of which significantly reduced the development time for other modules in the application and provided the same look and feel to the screens using this component. The form used auto reduction of queries using LOVs and pop lists. Also developed a common function to assign voucher numbers to the main and remote sites.
As a member of the Interface team developed forms that Uploaded, Downloaded and Recreated already downloaded files. Used SQL loader to upload files through the forms. For the download, data was extracted and formatted into flat files for paid and rejected transactions. Used PLLs (Win_Api), sever side packages, program units and triggers to meet the system requirements.
Developed a form for assigning vaults to users, with appropriate privileges, belonging to a particular site. During install this form denominated the amount in different currencies and calculate the US equivalent based upon the exchange rate for that day. This module automated many manual steps that were carried out with the old system.
Worked as a member of the NSA interface team where legacy data was loaded into non-standard tables. Reviewed and analyzed system specifications and actively interacted with the functional staff (business partners). In addition participated in RRA (Requirements Review Analysis). For analyzing requirements SCR used CMIS, FHD (Function Hierarchy Diagram) and Process Flow Diagrams in Oracle designer. SQL* Loader was employed for loading legacy data. Created the required control files for the loading and analyzed/modified existing Unix scripts for reusability benefits.
Developed Oracle packages, procedures and functions for loading legacy data in non-standard staging tables. Oracle utility UTL file, arrays were also used to complete the job. Finalized the server model (adding constraints, primary keys, unique keys, foreign keys, indexes, sequences, triggers, table-API, synonyms, roles, grants, table space assignment). Generated all the above objects into the development database. Performed unit testing and resolved TDRs (Technical Deficiencies Reports) during all the stages of Testing SIT (System Integration Test), FVT (Functional Validation Test), EIT (Enterprise Integration Test), SAT (Software Acceptance Test). Participated in Peer Reviews offering valuable suggestions to enhance and improve the functionality of the application.
Served in the capacity of a mentor to the people in the software development team.
CTG, Inc. Feb 1998 – Jul 1999
Indianapolis, Indiana
Programmer/Analyst
Worked on the Subscription team of the Commercialize Data Foundation at Eli Lilly. Responsible for data mapping per end user requests. Other functions included creating snapshots, views, indexes, primary constraints, cron jobs, test data, test scripts, hands on coding, extensive unit and system testing using ORACLE 7.3 on Unix platform. Generated reports of views and snapshots using Designer 2000. Created documentation of subscriptions for Validation Documents.
Programmer / Analyst in the development of a system process for tracking new and existing businesses for collection of unemployment insurance for the State of Indiana. The system captured the audited information, assigned auditors for businesses and tracked correspondence with businesses. REPORTS 3.0 were used to generate documents for correspondence with employers. Used SQL loader to convert data from FOXPRO to ORACLE for the NEW-HIRES tracking system.
IndoBosch Sept 1996 – Apr 1997
India
Programmer/Analyst
Programmer / Analyst for IndoBosch of Sweden, a jewelry maker in India. The work involved developing a payroll system for the employees, development of export system, and suppliers. The core of this system was to create and maintain invoices, inventory, and purchase orders. Extensive use of PL/SQL triggers, LOVs, toolbars, etc. in creating various forms (Forms 4.5, Developer 2000). Report 2.5 was used to track expenses, profits on a monthly basis.
Bal Bharti Public School Jul 1978 – Jul 1990
New Delhi, India
High school biology teacher. Supervised a group of junior school science teachers and participated in setting up the curriculum.
EDUCATION & TRAINING
IUPUI Indianapolis IN
Took courses in UNIX Administration, Reports 6.0 and Introductory Java.
Butler University – Indianapolis, IN
Completed 18 credit hours towards an MBA program.
BS Education, University of Delhi
Delhi, India
MS Zoology, University of Agra
Agra, India
B S Life Sciences
Delhi, India
CMM Completed Training
COMPUTER SKILLS
Hardware HP-UX9000, IBM-PC
Software Developer 2000, Forms 4.5/5.0/6.0/6i/10g, Reports 2.5/3.0/6.0/6i/10g,Designer 2.1.2/6.0 , 10.1.2.2, Oracle v7/8.0/8i/9i(OCA 9i)/10g, PL/SQL, SQL Loader, Java,XML (Introductory), MS Word, MS Excel, MS Project, Fortran, Lotus Notes, Toad, MS Windows 95/NT/2000/XP/Vista.
US CITIZEN
REFERENCES AVAILABLE UPON REQUEST
Contact this candidate