Data Engineer
Resume:
SRIKANTH BILLA
Phone: 210-***-****
Email: *********@*****.***
Security Clearance Level: Active Secret Clearance
Professional Summary
• 23 Years of experience in Oracle E-Business Suite and 15 years in Application Express (APEX)
• Expertise in SQL, PL/SQL, APEX, Oracle Reports, Forms, Discoverer.
• Strong experience in HRMS, Advanced Benefits, Self Service, Portal, iLearning, Application Express.
• Strong Experience in Requirements gathering, Analysis, Design, Implementation and testing of applications.
• Excellent communication, interpersonal, and Analytical and problem solving skills.
• Strong functional knowledge in Oracle HRMS, Oracle HCM, Advanced Benefits, iRecruitment, Self Service, OLM, iLearning, Oracle Finance, Crystal Reports. Education
• Master of Business Administration (MBA)
• Bachelor of Commerce
• Post Graduate diploma in Computer Applications
• CompTIA Security+ CE Certified
• ISC2 Security Systems Security Certified Practitioner (SSCP) Work Status
Citizen of United States of America
Active Secret Clearance
Skill Set
Oracle Applications HRMS, Advanced Benefits, Self Service, iRecruitment, OTA, Oracle HCM, OLM, iLearning, Portal, Approvals Management, Workflow Builder Development Tools Application Express APEX/HTMLDB, Oracle development suite, Forms, Reports Reporting Tools Oracle Reports, Discoverer, Crystal Reports, APEX, BI Publisher Oracle Tools SQL * Plus, TOAD, SQL Developer, PL/SQL Developer Languages SQL, PL/SQL, Java, HTML, Cobol, C, C++, Unix, JSP, MySQL Operating System Oracle Linux, Red Hat Linux, Windows server Databases Oracle, MS Access, SQL Server
Other Putty, WinSCP, PFE Compare, FTP Tool, Notepad++, Database XE, WinMerge, SQR, WinRunner, TestDirector, LoadRunner, PVCS Tracker, TeamTracker, Visual Source Safe, CICS, SQL *Loader, Oracle Hosted Services (OHS), Oracle Cloud, Enterprise Manager, Portal Single Sign on (SSO), APEX SSO, AD Admin, Oracle Internet Directory (OID), Samanage, ESCWorks, HTML5 Mobile Apps, OneLogin, Cloud Identity Service
Work Experience Summary
Organization Location Position Duration
Accenture Federal
Services
San Antonio, TX Software Developer Apr, 2019 - Present Education Service Center San Antonio, TX Applications Administrator
Sep, 2002 – Apr, 2019
Extreme Networks Santa Clara, CA Software Engineer Feb, 2002 – July, 2002 Paragon Casino Marksville, LA Software Engineer Dec, 2001 – Jan, 2002 Best Buy Minneapolis, MN Software Developer Apr, 2001 – Nov, 2001 Adaytum Minneapolis, MN Software Engineer Nov, 2000 – Mar, 2001 State of Oregon Salem, OR Developer/Analyst Mar, 2000 – Oct, 2000 Randolph Air force base San Antonio, TX Programmer Jul, 1998 – Jan, 2000 Precision Response
Corporation - PRC
Miami, FL Programmer Nov, 1997 – Jun, 1998
Deloitte and Touché Columbus, OH Programmer Jan, 1997 – Aug, 1997 Professional Experience Details
Accenture Federal Services, TX Software Developer April, 2019 – Present Worked on the largest implementation of Payroll on Federal Government HR system, This has more than 600 thousand active military members for which benefits and payroll was implemented. Responsibilities Included:
• Created hundreds of Fast Formulas for Eligibility, CAGR, Process Calculation and Deductions.
• Worked with Collective Agreement for Process Eligibility fast formulas.
• Created Inbound and Outbound interfaces along with errors being logged into a database to be sent over to different partners
• Worked with Balances and Dimensions to be calculated for deduction elements.
• Worked with AME for custom approval setups.
• Creating migration scripts to capture the setup to be moved into other instances.
• Created Bid application using Oracle APEX, used Faceted Search and added the feature for the images to be stored in Amazon AWS buckets instead of saving them in the database.
• Used Beanstalk repository with TortoiseSVN
Environment: Oracle GHRMS – HR, Payroll, SQL, PL/SQL, Workflow Builder, OBIEE, Jira, Starteam, APEX 20.1, BeanStalk, TortoiseSVN
Education Service Center, TX Applications Administrator Sep, 2002 – April, 2019 Lead a team of developers. Project Involves implementation of HRMS, Oracle HCM, Oracle Advanced Benefits, OTA, Self Service HR Implementation, iRecruitment, Workflow, iLearning and portal on an Oracle Hosted Server(OHS) and Oracle Cloud HCM. Used Oracle APEX to develop custom applications needed in the organization.
Responsibilities included:
• Data Mapping of Legacy to Oracle field
• Managed a team of developers.
• Configured Portal SSO and APEX Single sign on to integrate with Active Directory, E-business Suite, FND Users, Local tables, Third party applications.
• Data Conversion of all the data from legacy to HR and OAB tables
• Coding Inbound and Outbound interfaces.
• Develop Reports using Discoverer Reports, Reports 6i or iLearning Reports, Crystal Reports
• Developed applications on APEX to meet the requirements of the organization. Some of the applications were to related to customization of HRMS module.
• Implementation of iRecruitment, Time and Labor - OTL and Absence Management
• Worked extensively on Dynamic actions, Data load, Authentication and Authorization schemes
• Developed several applications on APEX. For the following purposes: Org Chart, Listserv subscriptions, Staff Directory, Commitments & Contract system, Survey tool, Issue Tracker, Room Reservation system, Digital Signage, eStore, Transportation Database, living science, Braille system, Bid system, Parent call log, workshop registration, TexQuest, iDrive ISD, Centergy Award, Independent Contractor, Standards & Indicators, Adjunct Agreement, FOR-C, PNP Database. Budget info sheet, Counts only Session, Contacts database, Registration system, Employee external Certificate upload. Job Description acceptance, 360 Walkthrough, Accounting Admin, Adult Education & Literacy Registration, eStore, Family & Community Engagement, FSA Call log, Kudos, Living Science, Vendor Bid System.
• Implemented ESCWorks and develop reports for the product.
• Implemented iLearning, iRecruitment, HRMS, Advanced Benefits, Self Service
• Making screen changes through Personalization to Self Service screens, iRecruitment Screens and iLearning screens.
• Applied patches and patch sets performed software updates.
• Managed Oracle Cloud.
Environment: Oracle HRMS – HR, OAB, OTA, SQL, PL/SQL, SQL*Loader, Discoverer, iRecruitment, Oracle Portal, JSP, Oracle iLearning, Oracle Reports, APEX/HTMLDB, Single Sign on, Crystal Reports, ESCWorks.
Extreme Networks, CA Software Engineer Feb, 2002 – Jul, 2002 Project Involves implementation of HRMS, Payroll, Oracle Standard Benefits and Self Service HR Implementation.
Responsibilities included:
• Migration and Data conversion of the Work Structures such as for Organization, Job, Grade, Valid Grade, Location and Position.
• Working on Technical and functional aspects of HRMS
• Data conversion of the employee for loading Employees with Terminations, Postal/Zip Codes, Service Areas, Contractors, Address Conversion, Contacts Conversion, Contact Addresses Conversion, Assignment Conversion with history details, Supervisor Conversion, Salary Conversion with history, Benefits Conversion, Elements Conversion, Work Phones conversion and SIT or Special Information conversion, Salary Proposal Components
• Coding Inbound and Outbound interfaces.
• Building Custom forms for several purposes.
• Writing Fast Formulas
• Writing Database Triggers
• Making changes to the employee personal details information screen in SSHR according to the requirements of the client.
Environment: Oracle HRMS 11i(11.5.4), Oracle 8i(8.1.7), UNIX(Sun SPARC Solaris), SQL, PL/SQL, Forms 6i, Reports 6i, SQL*Loader, Toad(6.3.11), SQL Navigator 4.1 Paragon Casino, LA Software Engineer Dec, 2001 – Jan, 2002 Project involves implementation of HRMS and Payroll for Paragon Casino, Paragon Casino Resorts and Paragon Hotels. History and current data of the employees has to be maintained. Responsibilities included:
• Data conversion for People, addresses, assignments, salaries and Nacha or Direct deposits.
• Loading history as well as the current details
• Data transfer was done using SQL*Loader
• Data extract was done using TOAD
• Writing fast formulas
• Maintaining audits of the records that were loaded and the records that got rejected due to the errors and kept a track of the error records to be processed manually or to change the records and process them again.
Environment: Oracle HRMS 11i, Oracle 8i, UNIX, SQL, PL/SQL, SQL*Loader and Toad on IBM IA64 AIX
Best Buy, MN Software Developer Apr, 2001 – Nov, 2001 Project involves implementation of Oracle Human resources and Payroll at Best Buy. There was a lot of data involved related to the current employees and all the ex-employees. Responsibilities included:
• Providing the users with the Adhoc reports needed from time to time from the HRMS system.
• Data transfer using SQL*Loader.
• Managed all the table spaces allocated to the development and production support databases.
• Managed the System and the Object Privileges across the databases.
• Wrote several PL/SQL Packages, Cursors, Database Triggers, and Form Level Triggers for the implementation, validation and testing valuable business rules of the User.
• Involved in data conversion for HR and data upload for Payroll Modules.
• Using the API's to take data from staging table into the core tables.
• Used Forms 6i for requirements that needed customization.
• Involved in designing the system to provide security for different responsibilities and users.
• Developed several Reports using Reports 6i.
• Used Test Director 7.0i to build Test Cases and for Bug Tracking.
• Mainframe was accessed for data purposes.
• Used Winrunner 6.0/7.0 to Automate the Test Cases. Environment: Forms 6i, Reports 6i, Oracle HRMS 11i, Oracle 8i, UNIX, SQL, PL/SQL, Mainframe, PVCS Tracker, LoadRunner 6.0/7.0, WinRunner 6.0/7.0, Test Director 6.0/7.0, SQL*Loader and MS- Access
Adaytum, MN Software Engineer Nov, 2000 – Mar, 2001 Responsible for design and development of HR and payroll applications using HRMS (11i), Forms 5.0, Reports 3.0, Unix, SQL Loader, SQL and PL/SQL.
Responsibilities Included:
• Analysis and Discussions with the client for capturing additional requirements of the data to be loaded.
• Actively involved in giving training to a large number of users about general applications flow and about the form layouts.
• Involved in creation of both inbound and outbound interfaces.
• Involved in coding many PL/SQL scripts required for data translation from legacy system to applications system.
• Developed a number of fast formulas to do the data input check
• Developed some fast formulas to append to the bonus calculation process for the company.
• Actively participated in the functional meetings during the flex field setups.
• Used many existing API to load the data into the production tables.
• Generated many reports for the users to match and test the loading of the data.
• Coordinating customization activities and production support as one-time queries and data updating.
• Creation of concurrent programs pertaining to the new reports.
• Creation of Database, Rollback Segments, Tables Spaces, Objects for the testing database
• Responsible for unit, functional and Integration testing.
• Used PVCS to Maintain versions of the code and for bug tracking. Environment: Oracle 8.1.7(8i), Unix, HRMS Applications (11i), Forms 5.0, Reports 3.0, SQL, PL/SQL, Visual Source Safe and PVCS Tracker on Windows 2000. State of Oregon, OR Developer/Analyst Mar, 2000 – Oct, 2000 This project involves customization of Oracle Human Resources and Payroll reports for the State of Oregon. Needed to customize all the existing reports. Also created a lot of new reports as required by the HR department in view of a lot of organizational changes in the company. Responsibilities included:
• Analysis and Discussions with the client for capturing additional requirements of the reports to be customized.
• Involved in user meetings regarding the changes required by them.
• Customized and developed several reports in Payroll and HR by using Reports 3.0 and created concurrent programs.
• Creation and Customization of many oracle fast formulas.
• Creation of many data files for the purpose of mail merging.
• Creation of concurrent programs pertaining to the new reports.
• Front end and back end coding for the business requirements done using PL/SQL.
• Involved in writing Batch scripts using Unix.
Environment: Oracle 8.0, Developer (Rel 2.1), Oracle HRMS Applications 10.7 and IBM PC Compatibles, Windows NT, SQL, PL/SQL, Forms 5.0, Reports 3.0, Unix, Designer 2000 (Rel 2.1), Test Director, WinRunner 5.0, LoadRunner 5.0
Randolph Air Force Base, TX Programmer July, 1998 – Feb, 2000 Design and Development of Military Modernization Personnel Data systems for the Department of Defense (DOD) using Oracle 7.3, Oracle HRMS Applications (REL 10.7), Developer 2000 and Designer 2000. And involved in testing using WinRunner 5.0, TestDirector 5.0 and LoadRunner 5.0 Used PVCS tracker to maintain different versions of the software, Network was on Windows NT. Responsibilities included:
• Involved in the development of Military Modernization Personnel Data System for the Department of Defense (DOD) using ORACLE APPLICATION HR MODULE.
• Set up Concurrent Programs, Request sets, Value sets and job scheduling on the Concurrent Manager. Maintain user responsibilities and security in applications.
• Customizing Oracle HRMS Applications and registration of forms in AOL.
• Built Custom report's, registered in AOL as concurrent programs.
• Done Extensive PL/SQL programming for implementing complex business rules.
• Using Application program interfaces (APIs) to call data from existing system to Oracle HR Applications.
• Writing procedures, functions, packages and SQL LOADER Scripts to convert legacy logic
(Samuel edits) into Oracle using Designer/2000 Module logic.
• Creating custom libraries and control programs to call data for particular module. Setting user profile options.
• Prepared Business Flow Diagrams from user specifications & analysis documents.
• Carried out physical data modeling using Designer/2000.
• Worked on reports like Position Hierarchy Reports, Organizational Hierarchy Report High Potential Employee report etc.
• Involved in data conversion of Legacy Data using SQL *Loader and validating using subprograms and packages, this data loaded into temporary tables. API’s were used to load data from temporary tables into core tables.
• Creating UNIX Shell scripts for data loading and data scrubbing
• Writing the test steps in TestDirector, automated some of the tests using WinRunner and did the performance, Volume, Load and stress tests using LoadRunner
• Designed complex algorithms critical to the successful employment of unit moves. Involved in design and development of value sets, quick codes, Alert's etc. Reverse Reengineering Database, Forms and Reports.
Environment: Oracle HRMS APPLICATIONS (Rel 10.7), Oracle Developer 2000, Discoverer, Unix, MS Access, Designer 2000 (Rel. 1.3.2), HP UNIX (Rel 10.X), WinRunner 5.0, TestDirector 5.0, LoadRunner 5.0, VAX/VMS on Windows NT 4.0.
Precision Response Corporation, FL Programmer Nov, 1997 – Jun, 1998 Responsibilities:
• Used SQR to load data from a flat file to the oracle database while checking different business rules and then writing the data back into a flat file to be sent as leads for the representatives.
• Several reports were developed using SQR to be sent to the Users for verifications and the reports consisted of the no of feeds sent, outputs from Reps with customer feedback and other details to be sent to the users.
• Design and development of screens to be used are done using Forms 4.5.
• Designed the Database Schema using Designer /2000.
• Used PL/SQL for checking the business rules by writing Packages, Procedures, Functions, Triggers and libraries.
• Used Unix for writing the shell scripts to kick off different programs to process the feeds to be sent to the reps.
• Crystal Reports were used for the purpose of generating reports that are required by the user.
• Used Pro *C for writing some procedures that had complex calculations. Environment: Oracle 7.3, SQL, PL/SQL, Form 4.5, SQR, Crystal Reports, UNIX and Designer 2000, Pro *C
Deloitte and Touché, OH Programmer Jan, 1997 – Aug, 1997 Responsibilities:
• Developed application to implement new functionality to facilitate business applications.
• Used Fast Formulas for implementing element calculation rules.
• Wrote database triggers and stored procedures to validate the business rules.
• Developed screens using Forms 4.5 and Reports 2.5.
• Used SQL *Loader for loading data from flat files into the staging tables.
• Developed several packages and used API's after validating the business rules to move data from staging tables into the core tables.
Environment: HRMS 10.7, SQL, PL/SQL, Forms 4.5, Reports 2.5, SQL *Loader and UNIX on Windows 95.
Contact this candidate