Srinivas Ravikanti

Contact: 732-***-**** (C)

Email: ad29xl@r.postjobfree.com

Summary:

I am a Security+ certified and Secret Cleared professional, quite adroit at Systems design, development, implement and maintain Oracle Applications with an experience spanning over 29 years in IT industry. During the past twenty years, I have provided Oracle E-Business Suite and Oracle-centric expertise for diverse clients including Federal, state, county governments and commercial sectors. Even though Oracle Applications DBA / Solution Architect is my core skill, in recent years, I was providing my expertise in Oracle Fusion Middleware products like OID, OAM, OIM, WebLogic, OBIEE, ODI, SOA administration, Security, Systems Analysis, and Enterprise Solution Design. Because I was involved in different roles throughout my career, I have a strong exposure to Oracle administration and development tools. My varied experience developed the team management and communication skills necessary to ensure successful solution delivery. My customer centric attitude enabled me to make decisions that best fit client needs and strengthens customer relationships. I am viewed as a “solution provider” who will learn new technologies that provide the most value to the customer.

Working as a Sr. Oracle E-Business Suite DBA/Oracle Identity Management administrator and architect at Defense Information Security Agency from March 2020 to till date.

Worked as a Sr. Oracle E-Business Suite DBA/Oracle Fusion Middleware/Solution Architect and Security engineer at United States Army Medical Research Institute of Infectious Deceases (USAMRIID) from April 2016 to February 2020.

Worked as a Lead Oracle Applications DBA, Solution Architect and Security engineer at client, National Rural Electric Cooperative Finance Corporation (NRUCFC) from Feb 2014 to April 2016.

Sr. Oracle E-Business Suite DBA/ Solution Architect and Security engineer at United States Army Medical Research Institute of Infectious Deceases (USAMRIID) from May 2010 to Feb 2014

Sr. Oracle E-Business Applications DBA/Sr. Technical Architect at client, Montgomery County Government, MD from May 2009 to April 2010

Technical Manager and Solution Architect at NJVC, Vienna, VA (end client: NGA: National Geospatial Intelligence Agency) from Jul 2005 to Apr 2009

Oracle E-Business Suite Apps DBA and Technical Architect for Project Symphony at Imagistics International (Pitney Bowes), Shelton, Connecticut from Sep 2003 – Jul 2005

E-Business Suite Technical Development Team Lead/Architect at TennCare project, Tennessee State Government, Nashville from Mar 2002 to Sep 2003

Oracle E-Business Suite Technical Team Lead at client Harvard Pilgrim Health Care, Wellesley, Boston from Mar 2001 to Feb 2002

Oracle E-Business Suite Technical Team Lead at client Keyspan Energy, Brooklyn, NY from Jan 2000 to Mar 2001

Oracle E-Business Suite Team member at client S&B Engineers & Constructors (Oracle Consulting Group), Houston from Jul 1998 to Nov 1999

Sr. Programmer Analyst at Computer Centre, Secunderabad, AP, Indian Railways from Sep 1992 to Jul 1998

Skills:

Oracle Applications : Oracle E-Business Suite Rel. 12.2.9, 12.1.x, 11i, 11.x, 10.7 NCA, 10.7SC

Oracle DB Servers : Oracle 19c (19.8.0.0.0), 12.1.0.x, 11.x, 10.x, 9.x, 8.x, 7.x, 6.x

Oracle Fusion

Middleware products : Weblogic 12.2.1.4, 11.1.2.3.0, OBIEE 12.2.1.4, ODI 12.2.1.4, Oracle Identity

Management (OID, OAM, OIM 12.2.1.4 and 11.2.3.0), OHS, SOA.

Operating Systems : Redhat 7.7, 6.x, HP UX, AIX, SCO UNIX, Sun Solaris, Windows NT

Software /Languages : Oracle Forms 6i & 4.5, Oracle Reports 6i &2.5, SQL*Plus, PL/SQL, C, JAVA, HTML, COBOL and PASCAL

Oracle Tools : Oracle Enterprise Manager, Import /Export, Procedure Builder, SQL*Loader,

Discoverer, Apex admin

Other Tools : Kintana, Harvest, PVCS, Visio, Toad, SQL Navigator, RICE, ERWIN Case

Tool, Data Junction, DBA Artisan, Remedy Request Management tool, Clear

Case, DataLoader, SVN

Professional Experience:

Client: Defense Information Security Agency (DISA, Department of Defense)

March 2020 – Till date

Environment: Oracle EBS Suite 12.2.9, RDBMS 19C (19.18.0.0.0), 12.1.02, 12.2.01, OID 12.2.1.4 and OAM 12.2.1.4 and RHEL7.8.

DISA is a combat support agency of the Department of Defense. The agency provides, operates, and assures command and control, and information-sharing capabilities. It is a globally accessible enterprise information infrastructure in direct support to joint warfighters, national level leaders, and other mission and coalition partners across the full spectrum of military operations.

As a Sr. Oracle E-Business Suite DBA, Identity Management administrator and Architect, I am responsible for managing the systems and providing maximum availability of the same. The following are few of my responsibilities:

Provide numerous system environments required for day-to-day operations, enhancements, implement new functionalities and maintenance of the same.

Perform system administrator responsibilities in EBS and Identity Management.

Perform user/role management, troubleshoot SSO integration issues.

Resolve issues related to TLS, TDE (Transparent Data Encryption), Wallets, Keystores etc.

Implement security patches, product enhancement patches, bug fixes.

Maintain system security.

Performed Server migration, upgraded OS from RHEL 6.10 to RHEL 7.8.

Performed EBS database upgrade from 12.1.0.2 to 19C (19.11.0.0.0).

Deployed Enterprise Command Center (ECC), G-Invoice functionality

Prepare the systems for periodic security audits, mitigate the audit finding/recommendations.

Perform Database management, performance management/ disaster recovery management.

Environments/change management planning.

Client: United States Army Medical Institute of Infectious Deceases (USAMRIID, Department of Defense) April 2016 – Feb 2020

Environment: Oracle EBS Suite 12.2.9, OID 12.2.1.3.0, OAM 12.2.1.3.0, OIM 12.2.1.3.0, OBIEE 12.2.1.4.0, ODI 12.2.1.3.0, OHS 12.2.1.3.0, Webcenter 12.2.1.3.0, UCM, Apex 20.x, Oracle RDBMS -12.1.0.2 and 19.3.0, RHEL6.

United States Army Medical Research Institute of Infectious Deceases (USAMRIID), a Center of Excellence which develops medical solutions - vaccines, drugs, diagnosis, and information – to protect our military members from biological threats. I am working on a sustainment contract to maintain Oracle E-Business Suite 12.2.9 and Oracle Fusion Middleware products.

As a Sr. Oracle E-Business Suite DBA, Fusion Middleware Solution Architect and Security engineer, I am responsible for the smooth running of all systems, make sure all systems are compliant with US Army Information Assurance guidelines. Following were some of the responsbilities:

Planned and executed the following product upgrades.

oOID from 11.1.1.7.0 to 11.1.1.9.0 to 12.2.1.3.0

oOAM from 11.1.2.2.0 to 11.1.2.3.0 to 12.2.1.3.0

oOIM from 11.1.2.2.0 to 11.1.2.3.0 to 12.2.1.3.0

oEBS from 12.1.3 to 12.2.9 (19c db)

oOHS 11.1.1.9 to 12.2.1.3.0

oSplit OBIA to OBIEE 12.2.1.2,0 and ODI 12.2.1.2.0

oOBIEE 12.2.1.2.0 to 12.2.1.4.0

oODI 12.2.1.2.0 to 12.2.1.3.0

RMF audit preparation and implementation of all the STIG requirements in my area

Periodic password sweeps in all my area

Applying the quarterly CPU / Security patches, all interim security alerts related patching, product specific patches identified.

Worked across teams to enhance performance of Oracle database and applications.

Backup and recovery strategy

Managing the logs as per the retention requirements

Enable auditing in my area as per the STIG requirements.

Maintained and assessed Service Level Agreements and troubleshot and resolved database and performance problems.

Conduct root cause analysis to resolve issues.

Provided 24 7 support to resolve production and development issues on various platforms.

Make sure that all the systems are running smoothly.

Client: National Rural Utilities Cooperative Finance Corporation (NRUCFC), Sterling, VA Mar 2014 – Mar 2016

Environment: Oracle Applications- EBS Rel. 12.1.3, Oracle Identity and Access Management 11gR2 (11.1.2.2.0), OID 11.1.1.7.0 OHS 11.1.1.7.0, Webgate 11.1.2.2.0, Access Gate 11.1.1.7, Weblogic 10.3.6, Oracle RDBMS -11gR2, RHEL6;

NRUCFC is a consortium formed by nearly 1000 electric companies across the United States. NRUCFC is providing unparalleled industry expertise, flexibility and responsiveness to serve the needs of member electric cooperatives.

As a Lead Oracle Applications DBA, Solution Architect and Security engineer, I was responsible for maintaining all Oracle systems, making sure the daily operations run without any issues. Following are some of the responsibilities.

Monitored and maintained Oracle databases and applications.

Plan security architecture, engineer solutions, setup monitoring capabilities

Implemented Single Sign-On using Oracle Identity and Access Management Suite

Plan space management on various servers based on historical growth patterns.

Tune the databases, troubleshoot day-to-day issues.

Perform the Disaster Recovery exercise every six months.

Bring patch levels up to date (DBTier, Apps Tier, Security updates, Java)

Plan, document and perform backup and recovery tasks.

Supported implementation of Accounts Receivables, iProcurement and iExpense modules.

Plan cut-over activities in infrastructure area.

Troubleshoot Single Sign-On login issues, AD syncing issues, WebADI issues.

Resolve issues around third-party interfaces.

Clone lower environments

Setup development standards and make sure development teams adhere to SDLC and Change Management procedures

Client: United States Army Institute of Infectious Deceases (USAMRIID)

(Department of Defense) May 2010 – Mar 2014

Environment: Oracle Applications- Rel. 11.5.10.2, Oracle Collaboration Suite (10g); Oracle discoverer, Apex, Oracle RDBMS -11gR2 and 10G; RHEL5;

USAMRIID is a United States Army Medical Research Center of Excellence which develops medical solutions - vaccines, drugs, diagnosis, and information – to protect our military members from biological threats. I worked on a sustainment contract to maintain Oracle E-Business Suite 11i (11.5.10.2), Oracle Collaboration suite (10g).

As a Sr. Oracle E-Business Suite DBA/ Solution Architect and Security engineer, I was responsible for the smooth running of all systems, make sure all systems are compliant with US Army Information Assurance guidelines. Following are some of the responsbilities:

Installed, patched, and maintained multiple EBS instances in support of configuration control and change management of Oracle Applications and related third party bolt-on components.

Ensured all instances had the appropriate CPU/IAVA patches installed as per Information Assurance guidelines.

Maintained and supported all instances with the use of AD utilities, Enterprise Manager / Grid Control, OAM, and custom scripts.

Enabled the Auditing on Databases and monitoring the audit logs just to make sure that there are no suspicious activities.

Automated the log file cleanup and managing them according to the retention requirements across the systems.

Responsible for running SRR scripts (Security Readyness Review) and successful completion of DIACAP (Defense Information Assurance Certification and Accreditation Process) audit of all of our systems.

Performed periodic password sweeps across the systems as per the Security Techinical Implementation Guides (STIG).

Responsible for planning the backup strategy and automating it.

Responsible for performance tuning support across the technology stack.

Upgraded EBS database from 9i to 11gR1.

Migrated all systems from physical servers to the virtual servers (VMware).

Supported migration of all systems from the offsite hosting facility to the Network Enterprise Center (NEC) in Army Base.

I was part of the architecture team to design the new environment for the Oracle products purchased by USAMRIID.

Worked on day-to-day issues and coordinate with Oracle Support in timely resolution of the issues.

Client : Montgomery County Government, MD

(Transform MCG project) May 2009 – April 2010

Environment: Oracle E-Business Suite Rel. 12.1.1 (Financials, Projects, HRMS and Procurement

Suites) and RDBMS 11g Rel. 1, Oracle Fusion Middleware, SOA Suite, BPEL, AIA, OBIEE, ODI, RedHat Linux 5.0.

Transform MCG is Oracle ERP project initiated by Montgomery County Government to transform the way it serves its residents, customers, enhance decision making and operating efficiency throughout the County government.

As a Sr. Oracle E-Business Applications DBA/Sr. Technical Architect, I was responsible for managing all technical and security architecture background including architecting, engineering, implementing, hosting, monitoring, tuning and troubleshooting complex, scalable, highly secure and highly available business solutions utilizing Oracle E-Business Suite Rel. 12.1.1 Applications, Oracle 10g AS, BPEL, Oracle SOA Suite, AIA, OBIEE, and ODI. Involved and led in the proposal writing of second phase of the project to implement additional modules for Montgomery County Department of Liquor.

Following are some of the tasks I was responsible:

Determine the Technical architectural requirement, oracle technologies for data integration, application integration etc., Technical FitGap Analysis, Capacity Planning based on the county requirements.

Document the Application Security Architecture in compliant with the existing county infrastructure.

Install E-Business Suite Rel. 12.1.1, OBIEE, Oracle Application Server 10g

Prepare technical designs to integrate EBS with various third-party systems.

Involved in designing various data conversion tasks

Implemented Oracle Single Sign-On in EBS by integrating EBS, OID, Tivoli Access Manager (Third Party access manager) and Active Directory.

Implemented single Sign-On in OBIEE by integrating EBS- OBIEE

Instance Planning and Cloning EBS instances as and when required.

Maintain applications in intranet and EHI environments (Highly Secure Enterprise Hosting Infrastructure)

Responsible for backup and recovery.

Apply Patches to E-Business Rel 12.1.1 based on the requirement.

Document the coding standards for developers to follow them while developing code.

Coordinated check printing using third party software (Piracle)

Configure printers for various custom reports, standard reports

Responsible to resolve issues, smooth running of Rel 12.1.1 and other integrated software.

Documented all work products.

Client : NJVC, Vienna, VA (End client: NGA: National Geo-Spatial Intelligence Agency) Jul 2005 – April 2009

Environment : Oracle E-Business Suite 11.5.10.2 (Financials, HRMS and Payroll, Procurement, Project Suite), Oracle 10G (RAC), OID, OAM and RHEL OS.

NJVC is one of the largest information technology (IT) solutions providers supporting the United States Department of Defense. The company provides quality IT solutions to the federal government and specializes in supporting intelligence, defense and geospatial organizations, including its largest customer, the National Geospatial-Intelligence Agency (NGA).

As a Technical Manager and Solution Architect, I was responsible for managing all technical and infrastructure tasks for implementing EBS 11.5.10.2.

Following are some of the tasks I was responsible for.

Responsible for all technical tasks pertaining to implementation of E-Business suite and post go-live support.

Responsible for installing the E-Business 11.5.10.2 on Linux environment.

Responsible for applying the patches to a level business requires them.

Responsible for converting the E-Business instance to Multi-Org.

Responsible for Implementing Vertex tax software, Evergreen Check printing software.

Responsible for installing ADI, configure the mail server etc.,

Install, manage and support discoverer on top of EBS.

Define the instance strategy and cloning to suffice needs of the implementation team for CRP, Development, SIT, UAT, GOLD instances etc.,

Planning and defining all custom responsibilities, menus and request groups etc to suffice the needs as per business requirement.

Overall responsible for planning, developing strategies to maintain the security of the system.

Implemented Single Sign-on using OID and OAM.

Performing the change management activities.

Involved in planning and successful execute of CRP, SIT, UAT from infrastructure point of view.

Involved in Production Cutover planning, execution and made sure that Go-Live to Production is seamless.

Responsible for day-to-day support for business and SMEs in postproduction situation.

Responsible for User, Roles management.

Working with oracle support to resolve issues faced by the business and technical team.

Involved in various enhancement activities in different technical/infrastructure areas.

Liaison among development team, functional and business teams.

Project Symphony Sep 2003 – Jul 2005

Client : Imagistics International Inc., (Pitney Bowes), Shelton, CT

Environment : Oracle E-Business Suite 11.5.5 / upgrade to 11.5.8 (Financials, INV, OM, Service Contracts, OIC, Advanced Collections, Advance Pricing, Teleservice), Oracle 8i/9i, Discoverer 4i plus, Kintana and AIX 5.0 OS.

Imagistics International Inc. is a large direct sales and service organization that provides exceptionally reliable document messaging, production and output solutions that improve productivity in business workgroups, departments and enterprises.

As an Oracle E-Business Suite Technical Architect/Apps DBA, I was responsible to provide technical solutions, develop Technical Design Documents. Following are some activities performed at Imagistics.

Responsible for overall availability of Oracle Applications and databases

Troubleshooting & Problem analyzing under high-pressure environments.

Capacity planning for the large-scale data conversions.

Plan, architect and implement security and seamless third-party inbound and outbound interfaces to/from Oracle E-Business Suite.

Responsible for periodic management reporting on technical and infrastructure activities

Responsible for instance planning and making sure that the implementation teams have various environments (CRP, DEV, TEST, UAT, GOLD) as they progress through the implementation project

Refreshing the lower environments as and when required by the team

24x7 and day-to- day Application and DBA support.

Also, responsible for following Change Management Activities:

Defined and enforced Change Control Procedures for Imagistics.

Responsible for successful internal and external audits (PWC) for SOX compliance.

Good at understanding the SOX (Sarbanes and Oxley) key control requirements.

Responsible for implementing the key controls in accordance with SOX compliance.

Responsible for overseeing the deployment of Source code to different instances.

TennCare Project (Medicare and Medicaid), Nashville, Tennessee State Govt.

Mar 2002– Sep 2003

Environment: Oracle Applications Rel. 11i (11.5.8). AP, GL, AR, CM, Sun Solaris OS.

TennCare is to facilitate a system of effective healthcare within a predictable budget for Tennesseans who are Medicaid eligible or who lack access to health insurance.

I was an Oracle E-Business Suite Technical Development Team Lead/Architect Responsible for Analysis/Design/Develop/Deploy and Support for across the modules and to oversee the development activities by developers. I have good functional knowledge in multiple functional areas and interrelationships between various modules. Following are some of the activities performed at TennCare:

Conducting Brain Storming sessions with SMEs to discuss and understand the requirements, various gaps between requirements and functionality of Oracle Applications.

Responsible to understand and translate Functional Specifications into Technical Specifications and set software deliverables.

Developed Technical Design Documents for Customizations, Interfaces, and Data Conversions across the modules.

Followed AIM Methodology for developing/ implementing most of the tasks.

Planning, allocating right resource for various tasks and tracking the development activities with time and percentage of completion using Microsoft Projects.

Arranged / Participated in various meetings for Development / Status review

Conducting Code/Peer Reviews for the code developed by developers and provide suggestions if any.

Responsible for Planning, Developing, Testing, Transitioning phases of the project.

Responsible for Change/Code Control Process as we did not have any version control software.

Good at using PL/SQL, Reports, Packages, Procedure, Functions, Triggers, Oracle Interfaces, APIs, AOL for development activities etc.,

Document Coding and Reporting Standards specific to the client.

Assist developers to understand the functional requirements, develop the code for various processes.

Conducting Unit/System Integration/User Acceptance Test of various tasks.

My Team was responsible for Analysis/Design/Develop/Test/Deploy and Support the following tasks.

AP Invoice Interface from STARS to Oracle Accounts Payables.

Interface process to load Vendors (Providers) every month.

Developing a process to Create Payments in Account Payables.

Process to Create Additional GL entries to sync STARS and Oracle GL.

GL Journals Import Interface Process to load journals from STARS to Oracle GL.

Interface process to load Budgets into Oracle GL Module.

Forms for maintaining Transaction Codes, GL Accounts Mapping between STARS and Oracle AP, AR and GL modules.

Purge Process to purge the Operating System files and various other tables used in different interfaces periodically.

Developing various Forms like Premium Rate Maintenance form, Message Maintenance Form for Invoice Printing, Case / Customer History Form for AR (Premium Management) Module.

Developing AutoLock Box, Custom Dunning Process for Collections.

Developing various Outbound Interface processes like AP, GL, AR extracts to send to STARS. These extracts contain all transactions done everyday. This is to sync STARS and Oracle Apps.

Working with Oracle Support and Opening TARs for the issues and problems.

DBA and System Administration Activities:

Involved in Instance Planning and backup strategies.

Applying various patches required to different instances.

Tuning the database to improve the performance for heavy data loads.

Running Explain Plan and understanding the output of TKPRO, recommend tuning tips.

Good at using Database and Applications monitoring tools like Spotlight for Database and Spotlight for Applications.

Setting Custom Application, printers and various profiles (system and personal).

Define Data Groups, Responsibilities, Request Groups, Concurrent Executables, Programs and registering them to different responsibilities.

Harvard Pilgrim Health Care, Wellesley, Boston. Mar 2001 – Feb 2002

Environment: Oracle Apps 11i (11.5.5 upgraded to 11.5.6), AP, PO, FA, INV,

AR, GL, PA, ABM and ADI, HP 9000 Sever, HPUX OS.

Worked as an Oracle E-Business Suite Technical Team Lead (Financials and Supply Chain Suites) for the Support, Development and overall responsible for the smooth running of Oracle Apps. Accounts Receivables was implemented after I joined the team. Following were some of the activities:

Developing new Enhancements, Requests, and technical/functional tasks from business.

Understanding the Business needs and Developing Functional and Technical Documents.

Developed Pseudo Code and Code for the tasks.

Planning Change Control and Code Control strategies.

Customized various reports in AP, AR, FA, and INV.

Responsible to assign tasks to developers and assist them in technical issues / development.

Arranging Team meetings to discuss the problems and check the status of different activities.

Arranging regular meetings with Business people and satisfying their needs.

Worked with Oracle Support on TARS, Problem tracking and resolving the issues.

Planning different Conc. Mgrs, create new Conc. Mgrs to avoid performance problems.

Perform SysAdmin activities and Planning Security.

Designed process to import Customers, AR Invoices, Address validations, sales tax rates and other transactions using AutoInvoice process.

KeySpan Energy, Brooklyn, NYC. Jan 2000 – Mar 2001

Environment : Oracle Applications Rel. 11i (11.5.3) and 10.7 SC, AIX 4.0, Dell Clients.

As an Oracle E-Business Suite Technical Team Lead, I was responsible to Customize and implement the Oracle Financials, Oracle Supply Chain, Manufacturing and HRMS applications suites. Used AIM Methodology for implementing 10.7SC and EMM Methodology for Migrating from 10.7 SC to Rel. 11i (11.5.3). The following are the some of the activities.

Participated in Brain Storming Sessions with Clients to collect the requirements, prepare the Functional and Technical Design Documents.

Developed Inbound Interface to Load Master Items, Organization Items, Item Locators (Area, Row, Bins), Item Categories, Item Onhand Quantities and Costing information from Legacy System into Oracle Inventory Module using Item Interface Import Process, SQL * Loader and PL/SQL.

Developed a process to load the Manufacturers and their Part numbers to attach to Inventory Items.

Developed the process to attach the Item Long Descriptions as documents.

Customized process to print the Manufacturer name and Numbers on Purchase Order Documents.

Developed Conversion process to load 3 years of Item Usage history used for Item Forecast.

Designed custom process to restrict inventory items to specific Sub-inventories and Locators.

Designed Use Tax report to find the difference in the Use Tax when an item is transferred from one organization location to another.

Designed conversion process to load Payable Invoices into AP, Customers and AR Invoice in to AR.

Designed Outbound Interface to send item issues to the Works Management System (MAXIMO).

Designed various interfaces to Projects, AP and GL to other Non Oracle Systems.

Developed complex SQL queries for reconciliation and management reports

Planning instances for configuration, development, Integration Testing, User Acceptance Testing.

Defined Concurrent Executables, Programs and register them to different responsibilities.

Performing some System Administration and Data Base Administration Activities.

Good understanding over Multi-Org Setup in applications.

Migration from 10.7 to Rel.11i

Analyzing all customizations done in 10.7 SC according to EMM templates.

Recommended changes required for the database and custom programs before migrating to Rel. 11i.

Made changes database objects and custom programs, interfaces developed in 10.7 SC.

Developed new custom reports using Discoverer 3.0 in place of SQL*PLUS reports.

Worked with Oracle Consulting Group at Client Place

S & B Engineers and Constructors, Houston, Texas from Jul 1998 to Nov 1999.

Environment: Oracle Apps Rel. 11.0.3, GL, AP, AR, PA, CM, BOM, HR, Sun Solaris 2.6

As an Oracle E-Business Suite Technical Team member, I was responsible for developing Interfaces and converting Legacy data into Oracle Apps, customizing various reports, forms using PL/SQL, Sql*Loader, Shell Scripts, Developer 2000 and some DBA Activities. Used AIM methodology for implementation.

Prepared Functional and Technical design documents for the various tasks.

Developed an Outbound Interface for Positive Pay, to load Employees, addresses to populate data into the HR base tables using Pl/Sql, Sql*Loader and Shell Scripts.

Developed Process to load Payroll Checks, Bank Statements into CM for recon.

Developed Conversion Programs to load Legacy Customers, AP Invoices, AR Invoices, AP Checks, Outstanding Payroll Checks, Payroll GL Distributions, Inventory Items into AP, AR, Cash Management, GL and Inventory modules.

Customized reports like Employee Summary, Group Life Insurance Premium, Job and Position Skills Matching Reports in HR

Defining Printers, Styles, Creating Custom Drivers and adding drivers etc.

Assisting Database Administrators in Database designing and administration.

Indian Railways, Hyderabad, India Sep 1992 to Jul 1998

I worked as a Sr. Programmer Analyst for Indian Railways. I was involved in various In-House projects during my tenure at Indian Railways. Following are brief description of the projects in which I was involved.

Rolling Stock Management System:

Environment: Oracle 7.1, Developer/2000, SQL*PLUS, PL/SQL, SQL*Loader, HP UX and Windows95.

This project is a conversion project from COBOL to Oracle 7.1. It deals with the maintenance of Bogies, Carriages and Boxns.

Traction Control System (TCS):

Environment: Oracle 7.1 server, Developer/2000 tool kit, SQL * PLUS, PL/SQL, HP UX, Windows 95.

TCS is an online multi-user decision support system which was designed to solve the problems of interruptions in electric supply caused due to tripping.

Freight Operating System (FOPS):

Environment: Oracle7.1, Sql*Plus, Pl/Sql, Forms 4.5, Reports 2.5, and Windows 95, HPUX, Windows 95.

Freight Operating System is enterprise wide software for the Indian Railways. It was developed to computerize the freight operations of Indian Railways.

Leave Accounting System (LAS):

Environment: COBOL and SCO UNIX.

Manpower Planning Information System (MPIS):

Environment: COBOL and SCO UNIX.

Education: Bachelor’s degree from Osmania University, Hyderabad, AP, India.

Work Authorization: US Citizen

References: Available upon request

Contact this candidate