SUMMARY

• Over 9 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 working as Project Manager & Technical Lead, managing multiple IT projects through out the project life cycle.
• Experienced in Retail, Financial, Higher Education and Manufacturing Industries.
• Mentoring and providing Technical guidance to junior developer.
• Experienced in database design, data analysis, development, production support, Database & Application tuning, with knowledge of data warehousing ETL process and data conversions.
• Experienced in working with Relational Database Management Systems on Oracle database servers 8i/9i/10g in RAC environment with SOA application functionality.
• Excellent skills in developing, debugging and testing SOA services using SoapUI Pro. Setting companywide coding and UAT standards, as well as refine Technical documentation.
• Experienced in translating Business requirements to Technical requirements.
• Experienced in developing complex stored procedures, functions, packages, triggers, views.
• Experienced in Software Automation Test Framework.
• Used Oracle Discoverer tool - set for ad-hoc querying, reporting and data analysis.
• Strong programming and debugging skills in SQL, PL/SQL, SQL* Plus, Dynamic SQL, Pro C.
• Experienced working in Agile/Scrum methodologies involving in Sprint planning, Backlog Management, Acceptance Criteria and user story definition.
• Experienced in developing BANNER Modules and 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.
• 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 Associate in Project Management (CAPM); Oracle 11g Certified Database Administrator (OCA) & Oracle 11g PL/SQL Certified Professional (OCP) with Master’s degree in engineering.
• Six Sigma/Lean Management course completion.

TECHNICAL SKILLS

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

Databases: Oracle 11g/10g/9i/8i, MS Access, SQL Server 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, PLSQL Developer, Toad, SQL*Loader, JGrasp, Oracle Developer 2000, Oracle Designer, Microsoft Project, Microsoft Office, Adobe PDF Writer

Data Modeling: ER Diagrams

Data Modeling Tools: MS Visio

Version Control: PVCS, Visual SourceSafe, CVS, Tortoise SVN

PROFESSIONAL EXPERIENCE

Team Lead/Project Manager

Confidential, TX

Responsibilities:

• Worked as Project Manager on Chain 3 Consolidation & Ecommerce Re-platform projects managing a team of 5 developers and 1 Tech Lead.
• Leaded team of 2-6 developers on projects like Size Optimization, Sales Processing Enhancements, CAMS (Ecommerce), PCMS (Price Changes), and Allocations and many more throughout SDLC.
• Awarded best employee for Production Support on Sales Interface that handles 1.6Billion yearly.
• Designs, codes, tests documents, debugs, and installs the most complex programming logic for existing or new applications and may require to provide guidance on the most complex.
• Knowledge of UNIX as well as Oracle database, PL/SQL and Oracle Forms is required.
• Supports and maintains several production systems.
• Regularly provides guidance to and assists in training less experienced programmers.
• Under very general direction, gathers and analyzes technical information for designing new systems, changing existing systems, resolving problems, and answering questions.
• Responsible for the development of standards for unit test plans. Participates in the development of overall system test plans and their execution.
• On new projects and modifications of moderate scope, interacts with user staff directly to define and develop appropriate approach to business solutions and alternatives.
• Establishes construction time frames and estimates of effort. Schedules and conducts internal design reviews.
• Prepares and conducts review of production turnover. For assigned production systems, assures that incidents are resolved on a timely basis and assists operations in meeting production schedules.

Environment: Oracle RAC, Oracle 9i/11g, Oracle ATG, Unix, Shell Scripting, PL/SQL Developer, SQL, PL/SQL, SQL*PLUS, PVCS, MS Visio.

IT Engineer II

Confidential, AZ

Responsibilities:

• Design, Code, Debug and Document operating system software applications as per Confidential ’s guidelines and technology standards supporting Oracle databases in RAC platform architecture.
• Support Galaxy, OSIRIS, Campus Tracking, IS3 Enrollment, Profile databases as core, linked to Platform services via SOA calls along with 5 more databases.
• Build new databases and decommissioning of legacy databases as a part of new architecture being implemented.
• Supported 135 critical, major and minor tasks (till date) including resolution of multiple Production issues in a two-week to Production environment.
• Develop, debug and test SOA and BPEL services using SoapUI Pro.
• Work on BPEL workflow developing web services for platform service applications
• Working in the Sprint team supporting Profile & Galaxy applications with daily status meetings as a part of Agile methodology.
• Working on Software Automation for major corporate applications, to run around 1250+ test cases every night, automating the work of 59 developers.
• Built automation framework for Galaxy database student registration applications to run nightly, involving multiple validations across databases via SOA calls eventually resulting in 99.96% of database uptime.
• Provided direction and support to less experience IT Engineers to orient them and increase their understanding of software engineering.
• Participated in testing process through test review and analysis, test witnessing and certification of software.
• Maintain and increase professional and technical knowledge by attending workshops, reviewing technical publications, establishing personal networks and participating in professional societies.

Environment: Oracle RAC, Oracle 11g, SOA, SoapUI Pro, PL/SQL Developer, SQL, PL/SQL, SQL*PLUS, BPEL, UNIX, SVN, VersionOne, MS Visio.

Sr. Oracle Developer/Project Manager

Confidential, UT

Responsibilities:

• Review, analyze, and modify the programming systems including encoding, testing, debugging, and documenting programs to support an organization's Enterprise Resource Planning (ERP) applications - BANNER 8.3, provided by Sun Guard.
• Maintain and support administrative systems and data within the Enterprise Resource Planning environment.
• Work as Project Manager, assigning the projects to other resources, tracking their status and communicating with other dept. managers on IPEDS Race/Ethnicity, SSID, ODS Third week Views Projects.
• Managed IPEDS Race/Ethnicity, SSID, ODS Third week Views Projects through the project life cycle from Project Initiation to Closure.
• Developed new Oracle Forms for the Release 102010 (Spring 2010) including maintenance of existing ones.
• Enhancements and supporting current WEBFOCUS reports pertaining to the Student Retention and Institutional Research program.
• Schedule daily, weekly reports for IRI using Report Caster.
• Responsible for creating detailed module documentation to verify adherence to business requirements.
• Data structures, data manipulation, and implementation of software applications based on the requirements provided by the State Board for 40/2010 (Fall 2010).
• Analyze business requirements and create project specification.
• Created, Tested and debugged the Stored Procedures, Functions, Packages, Views and triggers using PL/SQL.
• Imported data with validation from flat-files to Oracle database using SQL*Loader
• Work with DBA’s to enhance database changes and internal customers to signoff requirements.
• Collaborate with departments, administrative and academic officers, and other public agencies to determine their current and future system needs.
• Develop, administer, and maintain peripheral systems as necessary.
• Disney standards of excellence in organization and team qualities and principles.
• Project documentation of all the modules being enhanced or developed.
• Awarded as the best team to meet deadlines resulting free training to Disney’s Excellence seminar.

Environment: Oracle RDBMS, Oracle 10g, Sun Guard BANNER 8.3, Oracle Forms 10g, WEBFOCUS, SQL, PL/SQL, SQL*PLUS, TOAD 9, UNIX, SVN, MS Visio.

Programmer Analyst

Confidential, AZ

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 Confidential .
• 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.
• Responsible for Extracting, Transforming and Loading the data obtained from different agencies into the database.
• Responsible for running daily and weekly jobs to update the collection accounts in the database.
• 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.
• Involved in Upgrading Oracle Forms and Reports from Oracle 9i to 10g.
• 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.
• Used multiple DBMS Packages in developing PL/SQL applications.
• 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, Pro COBOL, TOAD 9, UNIX, Visual SourceSafe, MS Visio, Control-M Scheduling software.

Graduate Assistant

Confidential, SD

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.
• 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.
• Provided training to end users and students in the plant and among the four universities involved in the project.
• 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.