Summary:

• 4 years of Client/Server programming experience with strong programming and debugging skills.
• Over 13 years of IT experience in Requirement Analysis, Data Analysis, Data Modeling, Application Designing/ Development, Implementations, Integration and Testing of Client/Server and Object Oriented Projects.
• Experience working as Lead/ Lead Developer on various internal projects. Experience creating mapping templates, laying out best practice guidelines and creating migration documents.
• Excellent problem solving, analytical and communication skills with ability to work in a team or individually. Skilled in diverse fields, aptly supplemented by various programs and training seminars.

Technical Skills:

• Experience with Oracle 11g and lower versions.
• Designed, developed and maintained applications in Oracle Developer Suit 10g and lower versions .
• Experience in designing and creating database tables, constraints, sequences, synonyms, etc.
• Experience using SQL Loader for moving data from external files to Oracle database.
• Proficient in writing stable and robust PL/SQL code. Experience in handling Exceptions.
• Experience in designing and executing packages, stored procedures, functions and triggers.
• Extensive experience with SQL joins and views.
• Experience in SQL tuning and query optimization.
• Extensive experience using TOAD 10 years and Putty 2 years .
• Experience in ETL using oracle stored procedures.
• Experience with SDLC support that includes Requirement Analysis, Data Analysis, Design, and Development. Testing, Implementation and Post production Support.
• Familiar with Agile Scrum Methodology.

Technical Expertise:

• Operating System: Windows 7 Professional, Windows XP/NT/2000/98/95, UNIX
• Database: Oracle 11g 11.1.0.7.0 /10g/9.2.0.5.0/8.0/7.x, SQL Plus, MS SQL Server .70, Oracle Inter Media 8.1.7.1.0 Oracle Tools: SQL Loader, Oracle SQL Developer 2.1.1.64 , Oracle APEX Oracle Application Express , Oracle Developer Suit Forms 10g 9.0.4.2.0 /6i/5.0/4.5 , Visual Basic 6.0/5.0/4.0, Discoverer 3.1.36.06, Java Servlets, Applets, JDBC , Java Beans, RMI, Perl, Toad 12.1.1.1, Putty V 0.58,
• Reporting Tools: Crystal Reports, Oracle Reports 10g 9.0.4.2.0 /9i/6i/3.0/2.5
• Languages: SQL, PL/SQL, XML, HTML DB 1.5/Oracle FLOWS, VB Scripts, Java Script, C
• Data modeling tools: Erwin 7.2.3.1828
• Version Control: MS Visual Source Safe 6.0d, CVS, Clear Case, Star Team 5.4

Professional Experience:

Sr. Oracle Application Developer/ Project Lead

Confidential are custom built Financial HR applications respectively developed in Oracle Developer Suit 10g that facilitate LBUSD to carry out their daily functionality related to Accounting, Administration, Budget, Purchasing, Reporting, Requisitions, and Risk Management etc.

Responsibilities:

• FINSYS: Successfully updated all the SSN's in the system with Employee ID's as requested by the district. Was single handedly responsible to understand the system, make the vital changes, test and put it in production in a short span of time. Involved validation checks, data checks in addition to adhering to the SSN compliance standards.
• HRMS: Successfully created and implemented multiple NCLB No Child Left Behind reports. Gathered requirements, conducted JAD sessions, designed and developed forms and reports.
• FINSYS: Currently leading the automation of ONRBA On Line Non-Stock Requisitions Budget Adjustment process to eventually make it paperless.

Confidential

Sr. Data Consultant/ Project Lead

Confidential is a custom Visual Basic client-server application that uses Oracle 11g database. PaySR tracks City employee pay rates and their time, correctly computes their pay, tracks authorized positions, supports HR functionality and interfaces with the City's financial system.

Responsibilities:

• To lead and revise the existing interfaces between PaySR and the current Worker's Comp System LINX .
• Make changes related to PaySR screens and batch jobs.
• Append the new functionality to the existing one.
• Requirements gathering and conduct JAD sessions.

Confidential

Sr. Data Consultant/ Project Lead

Confidential is soliciting proposals for a CA WC Outpatient Retail Pharmacy Billing and Collection program that is capable of both paper and electronic billing using Worker's Compensation Universal Claim Form WC UCF . A pharmacy billing solution was developed so that the daily retail pharmacy transaction processing's are taken care of.

Responsibilities:

• To lead the functioning of the process from requirements gathering, designing, deployment and maintenance.
• Aggregate data and develop clean WC Rx Claim Data for submission to Workers Comp Vendor.
• Send and manage clean claims, non-submittal and denied claims between vendor, Occupational Health and Pharmacy Finance.
• Moving data from external files to Oracle database via SQL Loader.
• Support for UAT and go-live deployment.
• Generate monthly weekly finance Write off Reports, Aging Reports and NWC and KP employee reports respectively.
• Automation of Reports and support for maintenance.

Confidential

Sr. Oracle Database Developer / Data Modeler / Business Analyst

• During these 3 plus years, worked with Deloitte Consulting and Bearing Point Inc. on V2 CCMS and V4 CCMS projects.
• V2 CCMS maintains all cases related to Civil, Small Claims, Probate, Mental Health, Family Law and Juvenile along with V2's Traffic and Criminal cases Infractions, Misdemeanors, Felony from the time case is being entered into the system till the case is closed or dismissed.
• V4 system is developed using Java, JSP's, Java Script, XML and Oracle 10g. V2 system is developed using Struts Framework, Java, Servlets, PowerBuilder CORBA components, PowerBuilder 10 and Oracle 10g.
• Played various roles on the project as a Data Architect/ Data Modeler, Sr. Oracle Developer and a Business Analyst adapting to various stages of the project.

Responsibilities:

• Worked as a Data Architect/ Data Modeler for ADR group Alternative Dispute Resolution on V4 CCMS. Responsible for creating database design, adding constraints, indexes, script verifications, merges and release coordination's.
• Worked as a Sr. Oracle Developer on V2 CCMS. Changed various groups to fit as a Business Analyst as well acted as first line of defense for any issues coming from the client post production.
• Maintained and enhanced complex court fiscal processes which include calculating bail, accepting payment and distributing money to different state and local agencies based on various distribution schedules.
• Responsible for writing and executing unit and system test plans for complex processes.
• Responsible for database query optimization to improve performance using indexes and hints.
• Responsible for writing Oracle stored procedures, function and triggers using PL/SQL in TOAD 9.1.0.62
• Maintained shell scripts for executing stored procedures and scheduling jobs.
• Executed various procedures related to DMV and JBSIS using Putty.
• Worked with the client during requirement gathering, design, testing and production support of the application.
• Worked with California courts justice partners and other vendors during design and development of various court applications.

Confidential

Database Developer / Analyst

Confidential Police Department owns an extensive data warehouse from CHRIS which fetches its data from various client server applications. CLEAR is one of the major projects at CPD that has been providing and maintaining tabular and spatial data through the intranet.

Oracle APEX HTML DB/ Oracle FLOWS is designed in Internet Explorer V 6.0.26 . HTML DB helps build database centric interactive Web Applications that deliver exactly the HTML required in a highly efficient declarative programming tool using HTML, Java, JavaScript, SQL and PL/SQL. Applications consist of pages that share a common session state definition and authentication methods.

Responsibilities:

Personnel Performance Suit PPS and Paperless Arrest:

• Designed PPS modules from scratch by gathering information from the users.
• Created flow diagrams representing functional processes, held JAD sessions with the users.
• Presented developed modules for large user groups and higher officials.
• Actively involved and participated in interactive sessions in response to the developed application.
• Team player for the design and development of Paperless Arrest.
• Involved in analysis and study of the existing Arrest module.
• Solely responsible for designing and development of Bike Registrations.
• Executed database procedures, functions in TOAD 8.5.3
• Executed util file packages integrating with HTML DB.
• Extensively used JavaScript and HTML tags for screen designs.
• Designed custom templates for special data display requirements.
• Designed navigation bars, tabs and executed processes, computations, validations and branching.
• Used Collections extensively for multiple database transactions.
• Designed modules with variety of variations as per the existing Arrest forms 5.0.

Achievements:

Awarded Excellence in Technology award from CPD for automating employee's Awards application for Personnel Performance Suit.

Confidential

Database Developer

Confidential is approximately 350 million firm that maintains the functionality of more than 7300 acres of parkland, 552 parks, 33 beaches and 9 museums.

Cash Receipts Database for Chicago Park District maintains the database and functionality of 552 parks and deals with its various operations like scheduling programs for various parks, scheduling batches, fee collections, special deals, etc. These systems were transformed from Forms 4.5 and Reports 2.5 to Forms 6i and Reports 6i.

Responsibilities:

• Involved in analysis and study of the existing Cash Receipts Database.
• Designed user interactive screens with complex features and online help facility for the end users.
• Created stored procedures and custom packages for minimizing the redundancy of data along with multilevel triggers for cascading functionality in Toad 6.4.0.0
• Researched and effectively used GET HASH VALUE function and WEB.SHOW DOCUMENT procedure.
• Created dynamic and static record groups and LOVs created menu toolbars.
• Extensively used SRW package with its functions, procedures and exceptions to trap various report activities.
• Designed customized region reports and summary reports in Discoverer 3.1 and Reports 6i as per client requirements to provide more friendly access to the users.

Oracle Financials

Responsibilities:

• Assisted Oracle Applications V11.0.3 support team troubleshooting reports, forms, SQL scripts and procedures for modules like General Ledger, Human Resources, Purchasing and Payroll.
• Troubleshooted problems from 2-HELP , Unisys Help Desk involving user interaction.
• Analyzed business needs and requirements, identifying the gaps and issues for General Ledger and Human Resources working together with client in developing the solutions.
• Assisted DBA applying payroll patches.
• Researched and Installed Noetix views 4.0.0. and Noetix EUL

Confidential

Developer

Confidential is one of the most influential consulting firms in the world. FPIS Firm Practice Information System is a restricted, searchable database that contains the cumulative history of the Firm's client relationships since 1975. Designed originally as a mainframe system in 1987 FPIS migrated to the Windows client/server environment in the last quarter of 1997. Users were predominantly satisfied with the functionality but were frustrated with inconsistent application availability. To provide stability and improve ability to support the indexing component, options implemented were to replace Fulcrum with Oracle Inter Media and tweak Fulcrum area to reduce code complexity and outsource maintenance.

Responsibilities:

• Involved in analysis and study of the existing FPIS system.
• Research on Oracle Inter Media indexes, composite indexes, creating pseudo columns, field level searches and materialized views.
• Research on live indexing and indexing on demand, DBMS JOB, UTL SMTP and DBMS OLAP package to support advisory functions.
• PL/SQL scripts implemented in Toad 6.4.0.0. Wrote procedure and cursors for data loads.
• Written and executed PL/SQL scripts for Oracle Inter Media indexes, section groups and sections for performing Inter Media search which reads formatted document text and returns section offsets and plain document text.
• Monitored ctx user index errors view to track the rowid of the failed document during indexing. Created preferences, sections and section groups using ctx ddl package.
• Designed and developed FPIS reports in Visual Basic with Spread 3.0.16 for customized report display.

Confidential

Consultant

Hands on experience of the full system life cycle for the Banking and Sales Management project development.

Net Banking Software

The Net Banking Software provides an easy access for the account holders to keep a track of account details along with schemes and attractive offers. The package helps developing a Server module, which allows multiple clients to login and have access to databases in order for maintaining current, savings and recurring accounts details.

Sales Management Systems

The Sales Management System takes care of the interdepartmental processing of bills provides the acknowledgement to various vendors. Categorizes the products and performs the billing. Sales reports, bills and statements could be generated on daily, monthly, and quarterly, half yearly and annual schedules.

Responsibilities:

• Executed database triggers for modifying related tables and stored procedures in PL/SQL.
• Designed normalized tables and indexed table, taking into consideration all the integrity constraints.
• Designed user interfaces using Layout Managers, Applets, AWT's and Swings.
• Involved in coding of inter applet communication and thread synchronization.
• Effectively used java.io, java.sql and java.net packages.
• Designed custom class libraries for minimizing the redundancy of data.
• Handled bank transactions achieved by java.io package using the different types of input /output streams.
• Effectively used the Object Oriented features like inheritance, polymorphism encapsulation.
• Worked on Servlets chaining in order to introduce the dynamic data.
• Developed and tested various forms using the features of Forms 5.0 Involved in defining GUI standards for the system.
• Executed front-end triggers, LOVs, cursors, packages, procedures and functions.
• Created multiple menus and popup menus for easy access of options on the screen.
• Designed custom toolbar for various forms. Integrated Excel file using OLE in the form.
• Designed various types of report layouts. Created lexical and bind parameters for reports to meet the requirement of the end user.