Professional Skills |
- Multiple major implementations serving as Technical/Project/Team Lead for projects Integrating Oracle CRM 11.5.10 with online service scheduling and third party vendor applications including front end and back end modification
|
- End-to-end full lifecycle software development using technical project management including specifications, QA process, release management, implementation and reporting with iterative and incremental software development based on SEI/CMMI standards.
|
- Excellent analytical skills allowing for thorough consideration of all aspects associated with project implementation s including interaction with the end user through vice presidents in a matrix team environment allowing for effective translation of customer requirements int functional technical specifications.
|
- Experience with application database design and database platforms including 10g Industry verticals including insurance, retail, call center, health care and federal government
|
- Lead off shore and on shore development team including on boarding, knowledge transfer and daily touch point calls
|
- Working with various Vendors' Offshore teams and Integration teams for Project delivery
|
- Very good Team player and Excellent communication skills with Business Teams, End Users and Training Teams
|
Software Skills |
Enterprise Business Systems Oracle E-Business Suite Release 11.5.10 CRM Suite of Applications Core Contracts Service Contracts Tele Service Field Service Depot Repair TCA Oracle Trading Community Architecture |
Development Tools Oracle Application Object Library Oracle System Administrator Oracle Forms 10g, Reports 10g Oracle Workflow Builder Oracle Discoverer Oracle Desginer 6i Oracle JDeveloper SqlDeveloper TOAD |
Database, Modeling Performance Oracle 11g Release 11.2.0.3 ODBC, JDBC Rational Rose ERWin Explain Plan TKProf |
Business Tools MS Office MS Project 2003 MS Visio MS Access |
Development Methodology Agile Oracle AIM 3.1 |
Release Management QuickBase JIRA Visual Source Safe Perforce Subversion PVCS Dimesion |
Programming Languages PL/SQL, SQL Pro C,C, C JavaScript, CSS, XML, JSP, HTML, DHTML Unix Shell scripting |
Integration Tools | WebMethods 6.1 7.0 Suites |
Hardware | IBM AS/400, IBM Mainframe, IBM PC Compatibles, SUN Enterprise 3000, HP 9000/D series HP-847 E-45, VAX-VMS |
Systems | OS/400, MVS, MS-DOS, MS-Windows 95/ 98/2000/NT/XP/7, HP-UX Release 10.20/11.0,Sun Solaris 2.6/2.8, AIX/UNIX for IBM ES/9000 , MVS / TSO / ISPF / CICS and OS/2 |
Concept | OOA/OOD UML Design pattern , RUP, Unit, module and system level testing |
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.
|