SUMMARY:

• Experienced in design and development of relational database applications, this involved all phases of Software Development Life Cycle (SDLC).
• Proven Skills as an efficient Team Lead/Project Manager in System Analysis, Designing, Development, Customization, Migration and Documentation.
• Solid management skills, demonstrated proficiency in leading and mentoring individuals to maximize levels of productivity, while forming cohesive team environments.
• Technically proficient and possess excellent written and verbal communication skills. Have good team leadership skills and invariably meet client expectations.
• Technically proficient in writing Procedures, Packages, Functions, Triggers, views, records, constraints, synonyms, indexes and other database objects using SQL and PL/SQL for validating the data loads
• Technical Expertise in design and development of Forms, Reports and formulation of complex queries.
• Strong project management, Scheduling, Risk Management, prioritization and customer service skills. Experienced in creating test scripts, quality assurance and gap analysis
• Experience working with version control tools
• Strong analytical, interpersonal and troubleshooting skills and ability to work in a fast - paced and team-oriented environment.. Extensive experience in maintaining development plan, tasks allocation, task monitoring, establishing/monitoring quality process, study/audit of existing business process and preparation of issue logs, requirement gathering, user interaction, gap analysis, technical data mapping and analysis
• Worked on tools like Developer (Forms, and Reports), Discoverer & XML Publisher.
• Worked with Oracle Support, using Metalink, to resolve issues using knowledge base, SR/TAR.
• Worked on building custom reports using APEX.
• Proficient in writing & tuning complex SQL statements.
• Performed Unit testing, Integration testing & User Acceptance testing of the Applications.
• Developed the Documentation Process of the application with end-user training.
• Preparing, Managing design documents and requirements.
• Implementing software development life cycle policies and procedures
• Managing and supporting multiple projects
• Highly adaptable in quickly changing technical environments.

TECHNICAL SKILLS:

Databases: Oracle12c, Oracle 11g, Oracle10g, Oracle9i, Oracle 8i, Developer6i & 9i

Software: Power Builder, Visual Basic, MS Access, Lotus Notes, Office 97, Oracle Designer2000, Oracle discoverer, Crystal Reports, Crystal Enterprise Management, XML DB

Tools: PL/SQL Developer, Toad, PVCS Version control, PVCS tracker, Quick base, TIM, Asset,SVN - Subversion, Remedy, Team Tracker

ETL Tools: APEX, Business Objects Data Integrator

Languages: SQL, PL/SQL, COBOL, HTML, J2EE, PERL

Operating systems: MS-DOS, Windows7, Windows 95&98, Windows2000, Windows NT, LINUX and UNIX

PROFESSIONAL EXPERIENCE:

Confidential

Senior Software Developer

Responsibilities:

• Coded and designed complex FPDS(Federal Procurement Data System) Checklist enhancement for BAM ( Business Acquisiton Management) Project.
• Worked on customization to built extract tool for USCG (United States coast guard) for PRISM product..
• Designed, coded and Setup Scheduler chain jobs for running FPDS adhoc reports for BAM (Business Acquisiton Management) Project.
• Worked on Performance tuning activities to improve performance on the FPDS adhoc reports.
• Carried out Production support and help install the tool for all of the facilities after go-live on USCG ( United States Coast Guard ) data extraction tool.
• Responsible for regression testing of the components, doing data validation and bug fixing for PRISM.
• Worked on several issues related to data transfer from FEDCONNECT to PRISM and PRISM to FEDCONNECT.
• Responsible for the review of the Technical specifications, Code review, Set-Up documents and Technical Design Documents
• Extensively worked with Service team and clients directly to resolve the issues related to PRISM.
• Provided technical support during integration testing, quickly fixed any bugs found.

Environment: Oracle 11G, Oracle Pl/sql, C#, asp.net, vb.net

Oracle Technical Lead

Responsibilities:

• Designed, coded and Developed Subscriptions module from scratch that enables user to subscribe reports during the payroll period.
• Converted C language code from Main Frame systems into pl/sql code.
• Designed, Coded and Developed Badge Maintenance module.
• Worked in Agile Environment as an Oracle Developer to fine tune and optimize the queries in resolving the defects.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Performed data scrubbing that provides routine checks of all inconsistensies in data and, in general, prevention of hardware or software failure
• Performed performance tuning of the SQL queries by eliminating redundant joins, creating functional indexes, removing redundant code.
• Developed PL/SQL packages and procedures for the back end processing of the propose data base design.
• Worked on Forms 11g and Reports 11g in linux environments

Environment: Oracle 11G, Oracle Pl/sql, Oracle forms, Oracle Reports, UNIX

Oracle Lead

Responsibilities:

• Designed, coded and developed Quarterly Data Extract files and statics reports conforming to the guidelines of the International Conference on Harmonisation (ICH) using XMLDB, Oracle 11G, Oracle Forms 11G and Oracle Reports 11G that are published on the FDA website.
• Designed, coded, developed and implemented crucial batch printing interface using Oracle 11G and Oracle Reports and merged it into the COTS tool (FAERS) that led to successful production release .
• Designed, coded and developed Barcode Report and several other reports using Oracle 10G. Performance wise Barcode Report is the fastest report in the system.
• Worked on Performance tuning on several reports and database objects and enhanced the performance
• Collaborate with senior management and test teams on project development, pre-release meetings with clients.
• Interact with customers to resolve day to day issues
• Helped develop detailed project plans for multiple simultaneous projects, resulting in increased visibility of inter-project dependencies and improved development efficiency
• Design the Data Mart for faster performance of the reports.
• Partitioned the fact tables and materialized views to enhance the performance.

Environment: Oracle 11G, XMLDB, XML, Oracle Pl/sql, Oracle forms, Oracle Reports

Development Team Lead

Responsibilities:

• Designed and bulit inventory management web application using Java Script and Oracle application express
• Designed and built custom reports using APEX.
• As a inventory management application administrator configured and installed the inventory User Interface on the client machines.
• Designed and built General Coding system application using Oracle10G which was used for 2010 census using Oracle10G
• MTAIP Portal administrator - resolving the user access and other issues related to the MTAIP Portal.
• Working on the TEAM TRACK application in incorporating changes requested by the users.
• Created Security, Inventory, Verification and several Report using Oracle Reports that provides the entire inventory software and hardware maintained by the company.
• Created and provided detail design document, process flow charts and test plan to the clients.
• Working on PERL installer scripts to fix the bugs related to a PSMQ project.
• Secondary backup administrator for DMD Portal Application.
• Worked on several different projects with PSS group (Census).
• Worked on Peformance Tuning and Optimized SQL queries for Oracle reports .
• Performed Unit testing on all the modules developed .
• Performed backend database programming to support Oracle forms and reports application development.

Environment: Oracle 10G, Oracle Application Express ( APEX ), Java, Unix, Oraclewebtool kit, Oracle Forms, Oracle Reports, Perl, HTML

Confidential, Scottsdale, AZ

Senior Software Developer

Responsibilities:

• Designed, Developed, tested and Released Financial Reports in Oracle 9i which calculated periodic revenue generated, refunds, unapplied payments and payment ledger activity
• Designed and Developed Detailed and Summary Statistical reports for Chicago Toll Way system, which recorded violations and calculated violator activity, user activity and recorded image data.
• Optimized production reports, applied performance tuning methods and improved report performance.
• Collected and documented functional requirements from customer and converted into technical specifications and functional design documents; and developed a custom application in Oracle 9i
• Automated data loading and Report scheduling by developing PERL scripts
• Improved functionality of production reports by 60% by developing customized enhancements to suit customer requirements.
• Created a Front End System in J2EE for Forte.
• Provide customer support and testing all the modules in the application.
• Designed and Developed Revenue Reports for HCTRA (Harris County Toll Road Authority)

Environment: Oracle 9i, J2EE, Java, Unix, Perl, Oracle forms, Oracle Reports, Crystal Enterprize manager, Power Builder, Crystal Reports, Business objects (Data Integrator )

Software Engineer/Project Lead

Responsibilities:

• Collected user inputs requirements and converted into technical specifications, and automated the system using Oracle Developer Suite (Forms, Reports)
• Maintained, Customized and released (Asset Management Enterprise System) product, which included major enhancements and bug fixes based on customer requirements
• Managed migration/transition of forms and the pl/sql code from 7i to 9i.
• Coded enhancements and fixed major bugs for latest version release of software.
• Designed and Developed, Tested and released Asset Enterprise Management System using Oracle8i, Developer6i,9i and Developer 2000 which led to successful generalrelease of the product to customers.
• Administrator for Version manager source control and code management.
• Coded and designed complex enhancements for the latest release of the (Asset Enterprise Management System) product - using PL/SQL, Forms, Reports, triggers,views and stored procedures, which has led to improved product functionality,customization and enabled successful release of the version.
• Performed regression and unit testing on all the customizations and enhancements.

Environment: Oracle 10G, Oracle Forms, Oracle Reports, Java, Unix, Oracle webtool kit.