CURRENT RESPONSIBILITIES Onsite/Offshore Model

• Lead a team of 3 to 5 developers depending upon the size of Enhancement request/change request.
• Assist Project Manager with Time estimates
• Gather Business requirements from the Business Analyst. Give feedback and clear doubts with the BA.
• Create a prototype
• Prepare Technical Specifications or give download to the Developer to prepare the Technical Doc.
• Give review comments and sign off on Technical Specs.
• Review Code for Coding standards and from Performance , reusability, modularity, etc. prospective
• Do Tuning of the code such as SQL queries and PLSQL code
• Review/Create/Modify the Reports RDF or Forms in Oracle 10g depending on the work load
• Design/Review process for data cleanup
• Migrate the code in different environments
• Responsible for meeting deadlines for the change request or enhancement
• Responsible for Sign offs from the customer
• Responsible for rollbacks incase of issues in Production
• Responsible for smooth rollout and keeping a check for the first cycle of Production runs

EXPERIENCE SUMMARY

10 Years of IT Experience 6 Yrs USA 4 Yrs India

EXECUTIVE HIGHLIGHTS

• Around 10 years of IT Professional experience as Tech Lead / Application Analyst / Developer in Internet and Client/Server applications using Oracle Database 8.8i and 9i , Oracle 9iAS, Oracle Developer/2000 Forms 6i, Reports 6i/9i , Discoverer 10g, Oracle Warehouse Builder 10g, PL/SQL, SQL, Java Application Programming, Java Applet, Java Servlet, JDBC and JSP on different platforms like SUN Solaris, Unix, Windows NT/2000/98/95.
• Extensively worked with developing reports using Oracle Report 6.0/6i/9i/10g.
• Developed Data Warehouse using Oracle Data warehouse builder for MDOT.
• Worked on Oracle Financial Application 10.7 module such as AP, AR and GL.
• Extensively worked with Financial Reports for the State of Michigan.
• Extensive knowledge of conversion of COBOL to PL/SQL
• Extensive knowledge of POWER BUILDER reports
• Extensive knowledge of Finance Reports of State of Florida / Tennessee.
• Extensive knowledge of Wagner Pyser Program Reports of State of Florida / Tennessee.
• Extensive knowledge of Workers Investment Act WIA Program Reports of State of Florida / Tennessee.
• Extensive knowledge of Welfare Transition WT Program Reports of State of Florida / Tennessee.
• Extensively worked in deploying application into Web-enabled environment using Oracle 9i Application Server.
• Expertise in developing forms using Oracle Forms 6.0/6i
• Expertise in deploying reports on Reports Server and troubleshooting Reports Server.
• Experience in Report Security issues.
• Experience in Leading a Team for development of reports and Backend Development.
• Proven skills in SQL tuning and enhancing application performances.
• Proficient in server side programming like Procedures, Functions, Database Triggers, Packages using PL/SQL and SQL.
• Worked extensively with SQL Loader using control files for data ware housing and data loading into oracle database tables.
• Proficient in Tuning SQL using Explain plan, SQL Trace and Auto Trace utility.
• Experience in using Oracle Utility like Export, Import and SQL Loader
• Experience in Migration and Upgrade Oracle Database
• Experience in all phases of Software Development Life Cycle SDLC like Requirement Capturing, Data Modeling and Designing, Developing, Testing, Quality Assurance, Implementing, Documenting and User Training for various business applications.
• Used Discoverer to create business areas against oracle database
• Experience in developing Internet application using Java Programming, Java Applet, Java Servlet, JDBC, JFC, Java Swing, PL/SQL web toolkit, JSP and JavaScript.
• Proficient in Data Modeling using Rational Rose Data Modeler.
• Experience in Development Database Administration activity such asInstalling and Configuring Oracle Software and Databases like Oracle 8.x and 9i

• Creating and Managing Logical and Physical Structure of the database
• Estimating size and creating schema objects like tables, indexes, views etc.
• Performance Tuning of application
• Managing SQL Net and Net8 for database connectivity
• Team-oriented professional with excellent communication and interpersonal skills.

Specialization: Oracle 8/8i/9i/10g / Developer d2k 6/6i/9i/10g / Oracle Warehouse Builder 10g

PROJECTS SUMMARY

Confidential

Technical Team Lead Code Architect

Confidential

Role: Technical Team Lead Code Architect

Technical Environment: Oracle Database 9i, Oracle Forms and Reports in an Unix Environment and Oracle 10g Application Server.

Description:

• Postsale application primarily provides the following functionality
• Postsale application is one of the applications residing in the National Accounts Database NADB along with other applications such as Presale, TPA and venture.
• Provide billing functionality forLoss Reimbursement Billing

• Claims Service Billing
• Retro Billing
• Loss Control Billing
• MIS Billing
• Calculate HIG and Non HIG liability
• Send feeds to HIG internal and external systems/recipients
• Generate Invoices

Responsibilities

• My overall responsibilities were to lead the team from the Technical aspect of the Project. It included the following day-to-day activities
• Lead a team of 3 to 5 developers depending upon the size of Enhancement request/change request.
• Assist Project Manager with Time estimates
• Gather Business requirements from the Business Analyst. Give feedback and clear doubts with the BA.
• Create a prototype
• Prepare Technical Specifications or give download to the Developer to prepare the Technical Doc.
• Give review comments and sign off on Technical Specs.
• Review Code for Coding standards and from Performance , reusability, modularity, etc. prospective
• Do Tuning of the code such as SQL queries and PLSQL code
• Review/Create/Modify the Reports RDF or Forms in Oracle 10g depending on the work load
• Design/Review process for data cleanup
• Migrate the code in different environments
• Responsible for meeting deadlines for the change request or enhancement
• Responsible for Sign offs from the customer
• Responsible for rollbacks incase of issues in Production
• Responsible for smooth rollout and keeping a check for the first cycle of Production runs

Confidential

Role: Technical Team Lead Code Architect

Technical Environment: Oracle Database 9i release 2, Oracle Forms/Reports 6i/10g in Unix Environment and Oracle 10g Application Server.

Description:

As a part of Hardware upgrade, Postsale, Presale, TPA and Venture which were a part of NADB were upgraded to newer versions of Oracle and its toolsets. All the Forms and Reports developed in 6/6i were upgraded to 10g. As for the database which was Rule based could only be upgraded to release 2 of 9i database. All the UNIX shell scripts were upgraded to hardware specific.

Responsibilities

• Lead a team of 2 developers
• Assist Project Manager with Time estimates
• Give review comments on the coding and layout
• Convert all the forms which were creating excel files from 6i to 10g
• Convert report RDFs from 6i to 10g
• Responsible for Comparison testing and delivery.

Confidential

Software Engineer Reports / Data Warehouse Architect

Confidential

Role: Software Engineer

Technical Environment: Oracle Database 10g, Crystal Reports, PowerBuilder 9

Description:

Project Accounting and Billing System PAB exists in legacy which is intended to be replaced with a client/server based system by the Department of Transportation. This software system will be an addition to the existing MAP Financial Obligation System MFOS client/server system

Responsibilities

• Gather Requirements from the User
• Create Documentation
• Create Reports in Crystal Reports
• Create Technical Specs for Power Builder Programmers
• Convert Crystal Reports to Power Builder Reports
• Create/Review PLSQL process, scripts for Data cleanup
• Create/Review Procedure/Functions/Triggers

Confidential

Role: Data Warehouse Architect

Technical Environment: Oracle Database 10g, Oracle Warehouse Builder, Oracle Discoverer, Oracle Reports,

Description:

In addition to the OLTP System a separate Database for Data warehouse was proposed. This data warehouse would contain data from different systems used by the State of Michigan. The PAB system was integrated with reports that were generated from this Data Warehouse

Responsibilities

• Trained myself on Oracle Data warehouse Tool and gave other Team members training to create resource backup.
• Captured Requirements and Designed Data warehouse database Tables, Views and Dimensions and Cubes etc.
• Developed Oracle mappings, Process flows and deployed them on Oracle Workflow.
• Involved in direct discussion with the Functional/End-Users to study the system requirement and develop Functional and Technical specifications to meet their requirements
• Developed Reports using Reports 10g, PL/SQL and SQL, Discoverer 10g and Crystal reports.

Confidential

Role: Software Engineer

Technical Environment: Oracle Database 10g, SQL, PL/SQL, Mainframe COBOL, Crystal Reports.

Description:

As part of the Main PAB system, there was a process which was developed in COBOL on the Mainframe system. To complete the processing of the PAB system the mainframe process was executed monthly. The process would take 1 day for execution and 3 days for total turn around time. MDOT would pay thousands of dollars to maintain this project on Mainframe. This system was also prone to bugs and errors. The Oracle system was created to do away the maintenance of the Mainframe system and reduce the turn around time. The process in oracle would take less than 15 minutes to execute and the turn around time was less than 2 hours. The oracle process also turned out to be more accurate as some of the records were skipped in the Mainframe process due to data entry error.

Responsibilities

• Analyzed COBOL Mainframe system.
• Designed the Oracle Process
• Created ER Diagram using ERWin.
• Created Documents
• Created Proof of Concept
• Created Objects and PLSQL procedures in Oracle 10g
• Migrated the old Data from Mainframe to Oracle Database
• Created Reports in Crystal
• Supported the system for 3 cycles of Production run.
• Reponsible for Production Sign off.

Confidential

Role: Applications Architect

Technical Environment: Oracle 9i Application Server, Apache Web Server, Oracle 8i Database Server, Rational Rose Enterprise 2000 for UML Design and code generation, Rational Test Suite for Functional load testing

Description:

• One-Stop Management Information System OSMIS Project is developed for the Agency for Workforce Innovation AWI . It will provide assistance for the State Officials, participants and the service providers actively involved in workforce related programs and services for the people of Florida.
• The primary objective of this project was to increase the efficiency, ensure an effective operation and facilitate management of the workforce development system for service providers, participants, program and agency management, legislature etc, across the state. Co-sponsored by AWI and Workforce Florida, Inc., OSMIS is designed to maximize public access to data, focus on self-service, provide a single point of entry , and replace Tallahassee based legacy systems and all existing scattered, standalone Regional Workforce Boards systems.

Responsibilities

• Captured Requirements and Designed database tables, views, indexes etc.
• Created schema objects like partitioned tables, views, indexes etc.
• Developed store procedures to move data from staging table into online tables using PL/SQL
• Interacting with users to gather requirements and mapping the same with PL/SQL, Stored Procedures and Functions and Triggers for various validations in the application.
• Lead the team of four as Lead Developer for reports
• Handled the deployment of reports on the reports server and made the necessary changes to the CGIcmd file.
• Involved in data correction and Process corrections of the application.
• Handled the reports security and issues related to calling of reports on web.
• Tuned SQL for performance improvement using Explain plan and SQL Trace.
• Developed application reports using Reports 6.0/6i/9i/10g, PL/SQL and SQL
• Developed SQL scripts to create database tables, synonyms, sequences and created users, roles and granting privileges for them
• Written several Procedures, Functions and Packages using PL/SQL.
• Written Scripts for Loading ASCII/Flat files onto the Oracle database using SQL Loader.
• Utilized tools TOAD during development of the application.
• Involved in direct discussion with the Functional/End-Users to study the system requirement and develop Functional and Technical specifications to meet their requirements.

Confidential

Role: Analyst Programmer

Description:

HCLT designed and developed a web-based Case Management and Activity Tracking System eCMATS for Tennessee's WIA Implementation initiative. The application was initially developed on NetDynamics environment with Oracle as the database, called as CMATS. The eCMATS project is an amendment to the CMATS contract. The eCMATS solution was developed after reengineering the case tracking and management processes across the agencies to helping them focus on evaluating the participant's career needs in terms of the skills, talents, and interests within the context of the local or regional labor market. The system integrates with other program areas providing needed services such as job services, unemployment insurance, DHS' Support Services, and other job training services.

Technical Environment: Oracle 8i, EJB1.1, JSP 1.0, OC4J 1.0.2.2

The reports were made in developer Reports 6i and deployed on Reports Server.

Responsibilities

• Created schema objects like partitioned tables, views, indexes etc.
• Developed store procedures to move data from staging table into online tables using PL/SQL
• Interacting with users to gather requirements and mapping the same with PL/SQL, Stored Procedures and Functions and Triggers for various validations in the application.
• Lead the team as Lead Developer for reports and back end procedure and functions and triggers.
• Handled the deployment of reports on the reports server and made the necessary changes to the CGIcmd file.
• Tuned SQL for performance improvement using Explain plan and SQL Trace.
• Developed application reports using Reports 6.0, PL/SQL and SQL
• Developed SQL scripts to create database tables, synonyms, sequences and created users, roles and granting privileges for them
• Written several Procedures, Functions and Packages using PL/SQL.
• Written Scripts for Loading ASCII/Flat files onto the Oracle database using SQL Loader.
• Utilized tools TOAD during development of the application.

Confidential

Role: Analyst Programmer

Description:

Confidential is an accounting package developed for the clients in Dubai to replace the existing legacy system. The product supports multiple organization, location and multi currency accounting. The system comprises of General Ledger Module, Accounts Payable, Account receivable and budgeting modules. The system supports multiple cost centers and enables generation of reports based on the cost center. The user can customize the system to generate reports up to any level the organization requires. The system also enables generation of Balance sheet, Profit and Loss account and customizable reports. The system can take care of the accounting requirements of the entire group as an entity with various reporting features.

Technical Environment: Oracle Form Server 6i, Developer 2000 Release 6, Oracle 8i 8.1.6 Database Server, Designer 2000 Release 6, Windows NT workstation, Sun Solaris 2.6.

Responsibilities

• Created schema objects like partitioned tables, views, indexes etc.
• Interacting with users to gather requirements and mapping the same with PL/SQL, Stored Procedures and Functions and Triggers for various validations in the application.
• Developed application reports using Reports 6.0, PL/SQL and SQL
• Developed SQL scripts to create database tables, synonyms, sequences and created users, roles and granting privileges for them
• Written several Procedures, Functions and Packages using PL/SQL.
• Utilized tools TOAD during development of the application.

Role: Programmer

Description:

As the Company was engaged in developing different projects, a system was developed to keep track of the Problems and defects of different Phases of Life Cycle of projects. The Tester during the Quality Check of the Project could feed in the suggestions and Defects/Problems of a particular module in the system. Hence the Overall DAS system could be used for Unit Testing and Quality Checking. It was a three Tier system where Oracle 8i was used as the Backend the Application developed on Developer 6i was installed on Forms Server 6i. The User could access the System from his Browser. I had developed all the 5 reports, which was used by the management to scrutinize the different projects in the company. The Project also helped the company in getting CMM-Level 4 certification.

Confidential

Technical Environment

Oracle 8i and Forms and Reports 6i on Windows NT

Responsibilities

• Created schema objects like partitioned tables, views, indexes etc.
• Interacting with users to gather requirements and mapping the same with PL/SQL, Stored Procedures and Functions and Triggers for various validations in the application.
• Developed application reports using Reports 6.0, PL/SQL and SQL
• Developed SQL scripts to create database tables, synonyms, sequences and created users, roles and granting privileges for them
• Written several Procedures, Functions and Packages using PL/SQL.
• Utilized tools TOAD during development of the application.

Project: Oracle Financials System 10.7 Modules: AP, AR and GL

Confidential

Technical Environment

Responsibilities

• Dumped the Data provided in a spreadsheet .csv and then into a staging table. PL/SQL script is written to validate the data in the staging table and insert into interface tables. Then run the API and send the Error logs the users
• Extraction of Data from GL as flat files to send to 3rd party systems.
• Developed application reports using Reports , PL/SQL and SQL
• Developed SQL scripts to create database tables, synonyms, sequences and created users, roles and granting privileges for them
• Written several Procedures, Functions and Packages using PL/SQL.
• Utilized tools TOAD during development of the application.

Professional Course/Certifications