Pl/sql programmer analyst

SUMMARY

• *+ years of IT experience in full system development life cycle that includes planning, design, analysis, development, unit & integration testing of the client’s software application systems.

• Experienced in Financial and Manufacturing Industries.

• Experienced in database design, data analysis, development, production support, SQL performance tuning, with knowledge of data warehousing ETL process and data conversions.

• Experienced in working on Oracle database servers 8i/9i/10g.

• Excellent skills in developing both technical and function specs.

• Experienced in developing complex stored procedures, functions, packages, triggers, views.

• Used Oracle Discoverer tool-set for ad-hoc querying, reporting and data analysis.

• Strong programming and debugging skills in PL/SQL, SQL, Dynamic SQL, ProCOBOL.

• Working knowledge of Oracle Apex 3.0

• Experienced in developing complex Forms and Reports using Oracle Forms and Reports 6i/9i/10g.

• Trained and Assisted developers for advanced reporting.

• Experienced in production support and trouble shooting of database applications

• Experienced in extracting data from various sources including flat files, XML files and databases (Oracle and SQL Server).

• Working knowledge of ETL & Data warehouse concepts and tools – DM EXPRESS.

• Knowledge and understanding of JAVA, JDBC, UNIX Shell Scripting.

• Excellent communication, quantitative, analytical skills and ability to work either individually or as a member of a team, delivering cost-effective solutions in a timely and professional manner.

• Involved in group meetings and peer reviews helping generating complex Reports and applications.

• Certified Oracle personnel (Application Developer) with Master’s degree in engineering.

OBJECTIVE

Aspiring to take a challenging role in a reputed organization, providing effective and efficient solutions that would help the organization to achieve the best results, increasing its productivity.

CERTIFICATIONS

Oracle Certified Associate

Introduction to COBOL

SKILL SET

Languages : PL/SQL, SQL, COBOL, JAVA, UNIX Shell Scripting, C, C++.

Databases : Oracle 10g/9i/8i, MS Access, SQL Server 7.0/2000

Operating Systems : MS-Windows 2000/NT/XP, UNIX (Solaris/Linux)

Markup Languages : HTML, XML

Development Tools : Oracle Forms 10g/9i/6i, Oracle Reports 10g/9i/6i, Oracle APEX 3.0, DM EXPRESS, Toad, SQL*Loader, JGrasp, Oracle Developer 2000, Oracle Designer, Microsoft Project, Microsoft Office, Adobe Acrobat, PDF Writer

Data Modeling : ER Diagrams

Data Modeling Tools : MS Visio

Version Control : Visual SourceSafe, CVS

PROFESSIONAL EXPERIENCE

Programmer / Analyst

Accenture / AZ Dept. Of Revenue, AZ January 2007 - Present

The Arizona Department of Revenue (DOR) is reviewing its current business processes, organization structure, and information technology in order to develop a customer-focused department. To achieve its customer-focused vision, the DOR has initiated a Department-wide project called Business Reengineering/Integrated Tax System (BRITS).

This Personal Income Tax project managed by Accenture focuses on: Re-evaluate all current processes and procedures to determine future direction; Focus on essential, core business functions and how DOR can meet the needs of its customers; Simplify DOR organizational structure; Inspire organizational creativity and employee involvement; Change only what needs changing when it needs changing.

Responsibilities:

• Developed Oracle Forms, Reports, Stored Procedures, Packages and batch jobs building a new tax system for the Agency under BRITS (Business Reengineering/Integrated Tax System) project managed by Accenture.

• Responsibilities included design and development of overpayment and underpayment processing, high profile and fraudulent taxpayers, creation of collection cases, case staging functionality and taxpayer demographics.

• Sole Oracle Reports developer on the release team for over four major releases, logging over 950 hours for design, development, and maintenance of 39 Oracle reports.

• Supported resolution of 141 High and Medium priority defects during Release 3.2/3.3/3.4/3.5.

• Analyzed all business functionality related to back end database interfaces.

• Gathering modeling and reporting requirements from Business Analysts and Database leads.

• Developed technical specifications for various back end modules from business requirements.

• Directly involved with the Business Analyst in laying the foundation for applications designs (Reports & Forms 9i/10g).

• Developing new Oracle Forms and Reports from scratch & also modifying developed ones.

• Expertise in converting reports to Postscripts and Postscripts to pdf’s.

• Expert in building simple to complex applications using Reports Builder and Forms Builder (Forms/Reports 9i/10g).

• Creating new complex Stored Procedures, Functions, Packages and Triggers.

• Extensively involved in Tuning SQL queries to improve the performance of the applications using Analyze, Explain Plans.

• Created temporary tables and used collection methods in building PL/SQL Packages and Stored Procedures to improve performance and reduce defects.

• Handling exceptions based on business rules.

• Conducting Peer Review meetings with the team.

• Complete system development & testing lifecycle (planning, analysis, design, unit test, integration test, system test, user acceptance).

• Working with DBA to enhance table changes including creating indexes, and triggers.

• Communicating with End Users to understand the business rules and review developed applications.

• Interacting with development and management teams.

• Working in a Production Support team, extensively involved in troubleshooting database applications (Reports, Forms, Packages, and Stored Procedures).

• Design and programming of COBOL applications.

• Developing user documentation for all application modules and responsible for writing test plan documents and unit test packets (cover sheet, standards checklist, narrative, explain plans, test conditions and actual results).

• Provided technical and functional knowledge transfer presentations for High Profile functionality, Correspondence overview to the IT users at Dept. of Revenue.

Environment: Oracle RDBMS, Oracle 9i/10g, Oracle Forms 9i/10g, Oracle Reports 9i/10g, SQL, PL/SQL, SQL*PLUS, ProCOBOL, TOAD 9, UNIX, Visual SourceSafe.

Oracle Developer

Advanced Materials Processing Center, SD August 2004 – December 2006

Advanced Materials Processing (AMP) Center, a prestigious manufacturing plant, is in the process of developing a Multi-Institutional Database for National Science Foundation on Friction Stir Processing started in October 2004. Four leading universities: the South Dakota School of Mines and Technology (SDSM&T), the Brigham Young University (BYU), the University of South Carolina (USC), the University of Missouri- Rolla (UMR), and the Wichita State University (WSU) formed a partnership on Friction Stir Welding and Processing program. Multi-Institutional Database, Inventory Database and applications were developed for the AMP center which shares data between all the four universities. Used Oracle 9i as the backend and JAVA as web front end.

Responsibilities:

• Developed Multi-Institutional database and applications using complex Stored Procedures, Functions, Packages and Triggers, Forms and Reports 9i to handle material inflow vs finished products. Responsible for scheduling jobs for updating financial information based on various sources of funding and generating job logs since Phase II during 2nd quarter of 2005.

• Created financial tables within the database with complex constraints applicable to the business requirements.

• Responsible for designing and developing of task assignment windows using Oracle Forms 9i for NDT inspectors. Involved in developing application for logging data during FSW run.

• Involved in security administration for setting up users and groups based on business requirements and installation of solid works software on selected user’s workstations.

• Developed data scripts to clean up data for irregular runs.

• Involved in directly interacting with the end users to understand Business Requirements.

• Used Oracle Discoverer tool-set for ad-hoc querying, reporting and data analysis.

• Created, updated and modified existing tables.

• Developed backend interfaces using PL/SQL Stored Procedures, Functions, Packages and Triggers to monitor, extract and load data from individual machines implementing business rules into the application.

• Used Bulk Binds and Bulk Collects to enhance performance in PL/SQL.

• Provided maintenance and development support for existing Database Procedures and Functions as per the business needs.

• Wrote generic error packages to handle exceptions.

• Built web-based applications using Oracle Apex 3.0 during the transformation phase.

• Developed new Oracle Reports and Forms, modified existing ones based on the requirements using Forms/Reports 9i.

• Responsible for trouble shooting backend production problems.

• Performance tuning, normalization and de-normalization, partitioning of data and indexing of partitioned tables.

• Tuning SQL queries to improve performance in the applications by using Explain Plans.

• Experienced in working on Production Support team including weekend schedules.

• Provided training to end users and students in the plant and among the four universities involved in the project.

• Responsible for performing code reviews.

• Developed Unit Test documentation including test plan and current results documentation.

• Worked on Data Extraction, Transformations, Loading, conversations and Analysis.

• Loaded data from the files got in different formats into the development and production systems using SQL*Loader.

• Knowledge of using JAVA interfaces to communicate with the backend processes.

Environment: Oracle RDBMS, Oracle 9i, Forms/Reports 9i, Oracle Apex 3.0, SQL, PL/SQL, UNIX, JAVA, SQL*Plus, SQL Loader, Toad, MS Office tools.

Database Engineer II

Visakhapatnam Steel Plant, India January 2004 – June 2004

Inventory Database was created and maintained using Oracle 9i for the Steel Melting Foundry in Visakhapatnam Steel Plant – a leading steel manufacturer in India. Applications were built using Oracle Forms 6i and invoice were created using Oracle Reports 6i. Being a part of National data availability module was involved in design, development and implementation of client’s software application system.

Responsibilities:

• Developed front end applications using Oracle Forms 9i and inventory invoices using Reports 9i, maintaining Inventory Database adhering to business specifications. Designed and developed user-level security for providing access based on the division codes and working shifts for over 400 users.

• Responsibilities include design and development of approval/denial task orders processing including automatic generation of letters/ list reports for client orders within 24hr time period using various Stored Procedures, Functions, Packages and Database Triggers.

• Supported fixing of top priority issues during modifications on supply-management chain functionality during 3rd release. Also provided knowledge transfer presentations to end users within dept on RINL formation day.

• Worked night shifts during production week, as a part of production support team.

• Responsible for developing technical specifications from business requirements

• Creating tables and build database designs as per the project specifications.

• Extensively involved in the development & maintenance of various Stored Procedures, Functions, Packages and Database Triggers.

• Responsible for training end users in the plant.

• Created Temporary Tables in procedure to achieve performance issues.

• Configured roles to prevent non-admin users from accessing database objects outside context of application.

• Developed forms for setting up users and administering user-level security for Access to various applications on the Intranet Site.

• Handled Production issues

• Written and Tested applications for loading inventory data into database tables.

• Performed User Acceptance Testing and end user training

• Responsible for creating User Interface using Oracle Forms and publishing reports using Oracle Reports

• Responsible for peer reviewing of the code developed by team members

• Unit testing of the developed modules and detailed documentation of each for end user review

Environment: Oracle Forms/Reports 9i, SQL, PL/SQL, UNIX, Toad, Oracle DB, MS Office, MS Visio.

Analyst

Infotek Consultants, India July 2003 – December 2003

Infotek Consultants is a reputed consulting and out sourcing company in the southern part of India. Work as Analyst, involved in creating, developing and designing a Payroll System for a Client company with 6000+ employees nationwide. Worked as a Database Analyst in the Information Systems Department developing applications using Oracle 0i depending on Clients requirements. Oracle 6i DB, TOAD, PL/SQL, SQL*Plus, Macro Attachments, JAVA, Windows 2000, SQL *Loader etc., were some of the tools used.

Responsibilities:

• Responsible for design and development of time tracking application, tax estimation processing module, and vacation generation module, using PL/SQL technologies for a client company with 600+ employees.

• Developed COBOL jobs to run monthly generating paycheck’s for employees using oracle reports at vendor’s location. Responsible for transferring functional knowledge and providing training to new developers in team.

• Awarded as the best team to meet deadlines resulting free training to new oracle technologies.

• Responsible for creating detailed module documentation to verify adherence to business requirements.

• Analyze business requirements and create project specification.

• Created, Tested and debugged the Stored Procedures, Functions, Packages, Cursors and triggers using PL/SQL.

• Used SQL queries to modify data in the tables and designed PL/SQL Stored Procedures and Functions to gather data and modify the payroll package depending on business requirements and rules.

• Responsible for coding and modifications to enforce business rules and to improve performance of the system.

• Writing SQL Queries for data load and transformation, and data extraction.

• Maintained all documentation and spreadsheets for Oracle Database operations.

• Development & maintenance of Oracle Forms and Reports using Forms/Reports 6i

• Developed various Complex Queries, Views for Generating Reports in Oracle 9i.

• Imported data with validation from flat-files to Oracle database using SQL*Loader

• Troubleshooting issues and handling development problems during testing phase

• Involved in production support team handling production issues

• Added Exception Handling to some of the modules in order to handle exceptions

Environment: Oracle DB, Oracle Forms/Reports Builder 6i, SQL, PL/SQL, SQL*Plus, JAVA, UNIX, Toad, SQL Loader, Windows 2000, MS Office.

EDUCATION

Master’s in Engineering

REFERENCES

Available on request

Contact this candidate