Professional Experience |
Confidential | Sr. DBA/Sr. Tech Lead |
Responsibilities | - Worked as part of development team to perform the database tasks related to
- application enhancements, such as creating new tables and/or columns,
- writing and tuning PL/SQL, SQL scripts and stored procedure, database
- triggers, audit trail issues and debugging production database issues.
- Builds and unit tests database scripts and works with Configuration
- Management to ensure the builds are successfully and accurately promoted
- to QA/UAT environment for testing and then to the production environment
- using Agile Software Development practices.
- Worked with clients to gather requirements and responsible for
- designing and building Oracle database that comply with existing database
- standards and established design patterns.
- Monitored the database for performance issues.
- Performed complex Oracle database administration assignments essential to
- the production and development of Database Management Systems DBMS
- applications.
- Demonstrated the ability to interface equally well with various levels of
- Technical personnel, web portal developers, Subject Matter Experts SMEs , and senior level stakeholders as required.
- Implemented all assigned patches for all supported environments within
- assigned timeframes t mitigate all security vulnerability alerts
|
Confidential | Sr. IT Specialist |
Responsibilities | - Lead this very massive effort to convert all the forms, reports, supporting
- database objects and load routines in AFS.
- Analyzed old data structure and developed the protocol and format for new development.
- Lead Quality Assurance team t prepare test cases and review test data t validate specific requirements.
- Involved in UAT process.
- Responsible for Change Management Requests and version control process.
- Gathered business requirement from various NPS centers.
|
Confidential | Technical Team Lead |
Responsibilities | Technical Team Leadership - Lead design, development and implementation of Oracle CRM module modifications, enhancements and integration
- Lead the conversion from legacy t oracle. TCA was the major part of the data conversion form legacy t Oracle CRM. There were few organization type clients. They had buy products in bulk but their point of contact will same but for different locations. S heavily worked on mapping on TCA t setup the one account for specific organization but have different site and location. Using hz-parties, locations, sites tables.
- Technical lead in charge of new enhancement request development and ongoing production support/maintenance of Service Contracts and Service Request applications that are part of Oracle's CRM suite of 11i Applications.
- Lead Quality Assurance team t prepare test cases and review test data t validate specific requirements.
- Perform code reviews, make performance recommendations, and provide test case scenarios.
Communication - Advise business team on the system impact and technical difficulties based on review of business requirements.
- Create System Specification and Technical Design Documents.
- Gather business requirements
- Lead and mentor off shore team daily t update requirement changes, review code in a structured way and give timely feedback.
Development - Design, develop, lead and implement customized Online Dispatching application integrating with Oracle 11.5.10 CRM Applications with webMethods.
- Create custom interfaces t Oracle Applications and web services.
- Build enhancements t the CRM applications writing packages procedures and functions .
- Modified Existing Discoverer reports and created new discoverer reports as part of Archiving project.
- Writing a custom Workflow process t aut adjudicate and process the claims.
Configuration - CRM configuration, Service Requests and Tasks, creating and modifying descriptive flex fields and value sets, creating and assigning responsibilities, menus, registering forms, reports, functions and concurrent programs.
- Module configuration, setting profile options, list of values
|
Confidential | Sr. Oracle Developer Technical Analyst |
Responsibilities | - Developed the Pre-Enrollment Certification PEC form t facilitate CTSU patient registrars t validate site/investigator eligibility, add/link the contact person for the accrual and enroll patients for any study, in the CTSU menu.
- Used Designer 6i and Oracle Forms 6i to develop the form using Oracle8i database
- Enrollment Validation Rules If one of the validation rules does not pass, then the specified error text will be included in the disapproval comments.
- This was done via PL/SQL packages and triggers
- Various reports were created using Oracle Reports to report on patient enrollment, clinical data management and investigator/site roster management
- Developed Technical Design Document based on NCI guidelines and regulations.
- Periodically met users from NCI t make the application robust.
- Managed the project schedule and mentor junior developer.
|
Confidential | Sr. Oracle Developer |
Responsibilities | - Responsible for developing and implementing Oracle form used by US Custom boarder officer t import/export commodities.
- Designed user friendly forms using Designer 6i and Developer 6i based on sensitive data.
- Gathered requirements and Developed Technical Design Document
- Developed complex system in a configuration-managed environment
- Validated QA test data
- Prepared documentation for deployment under US Customs guidelines.
|
Confidential | Oracle Developer |
Responsibilities | - Developed ledger forms and reports for Federal Navy using Oracle forms.
- Designed complex Crystal Reports t show the data in graphs.
- Worked on MS Excel t generate ad hoc reports.
- Developed documentation for change management.
- Worked on simulation protocol for Federal Navy using Object Oriented methodology.
|