LOVEPREET S. BRAR
*** ****** ***, **********, **-95834
E m a i l : l o v e p r e e t b@y a h o o . c o m, P h o n e : 9 2 5 - 4 1 3 - 9045 Profile
• Passionate technology leader with 17 plus years of experience in leading, designing, architecting software products for enterprises in product organizations.
• Extensive knowledge of software development lifecycle, expertise as Oracle Applications Consultant in implementation, upgrade and customization of Oracle EBS, Oracle Cloud ERP / Fusion.
• Strong understanding of Financial business flows, underlying technical architecture of Oracle E-Business Finance Suite, Oracle Integration Cloud (OIC), Oracle Cloud Infrastructure (OCI)
• Extensive experience in Implementation, Migration, Customization, Production and Support of various modules in Oracle Applications with hands-on experience in Data Conversion, Data Migration, Report Generation and Developing Interfaces within several modules in Oracle Applications.
• Experience in migration of Oracle EBS applications to Oracle Cloud (Paas / Saas)
• Experience in SODA APIs for access to JSON data stored in the database.
• Hands-on Database Performance and Scalability experience with design knowledge of physical and logical database schemas and tables.
• Excellent Agile/project management skills with in-depth understanding of business and IT processes
Work Experience
July 2006 – July 2023
Senior System Engineer, AT&T Inc., San Ramon, CA.
• Responsibilities include being Requirements Lead, Lead Developer and Tester on various projects while maintaining, enhancing, and customizing of the Fixed Assets, Projects Accounting, General Ledger, Cost Allocation bolt on application in Oracle Applications, the company’s Corporate Financial Application Suite (CFAS). This includes creating detail design, technical design, test plans, implementation, and work on enhancements in customizations for Oracle Applications. (FA, PA, GL, AP, CWO).
• Migration of Oracle Applications (EBS) to Oracle Cloud. (Fixed Assets, General Ledger, Project Accounting, Cost Allocations).
• Upgraded Oracle Applications from 11i to R12 and Database 11g upgrades in AT&T.
• For BellSouth to CFAS project, as a Lead architect, was responsible for design, development, testing and implementation of new Cost Allocation process in Oracle Applications. Implemented process to handle new inbound-outbound files to Project Accounting, General Ledger.
• Designed and implemented a new database in Oracle 10g for MATREX (CDT) team project, which allowed team members to share their interests in various technical fields on web.
• For ATT to CFAS project, was responsible for development and testing for the new process for custom Oracle Applications Cost Allocations and Custom Work Order.
• For NPE-Mobility project, as a Lead architect, created detail design, technical design, test plans and implemented the new database structure and programmed new Mobility process, which also includes handing of new inbound and outbound to Project Accounting and General Ledger.
• For EPA-OSP project, designed and implemented the process for Outside Plant entities and created process to handle new inbound –outbound from Project Accounting to General Ledger. Created packages (PL/SQL), SQL scripts, shell scripts, Oracle forms and Reports.
• Redesign the existing Oracle Forms for Manual Bill and Joint Pole process for CWO
(Custom Work order) to make it more user friendly and make it more efficient.
• Migrated UNIX based application THESYS into Oracle Applications, designed and implemented the THESYS database in Oracle 10g and designed concurrent programs and their automation.
• Work as a mentor for members on the development team and provide technical assistance to other engineering functions within CFAS team.
June-2003 – Dec 2004
Oracle Developer, CIC, Chandigarh, (India)
• Member of a team responsible for developing applications using Developer Forms 6i and database ORACLE 9i for clients.
Jan-2002 –June 2002
Student Intern, Drish Info Tech Ltd., Chandigarh (India)
• Responsibilities include Palm OS programming in C and design applications for Palm Handheld devices using Palm OS Developer Suite and Code Warrior. Created applications for Palm devices for Electricity Board for automated billing entries. Programming and Software Skills
• Programming Languages : C, C++, Java, JSON, SQL, PL/SQL, XML, HTML, UNIX shell Script, Python, PHP, R,COBOL
• Operating System : Windows, LINUX, UNIX, macOS, Ubuntu
• Database System : ORACLE 19c, JSON, MS SQL server 2000, MS Access, MySQL.
• Packages/Tools : OCI, Oracle Applications E-Business Suite, SQL Developer, TOAD, SQL Loader, JDeveloper (OAF), OS Developer Suite. GIT, SVN, SoapUI, JiRA, Oracle BI Publisher.
Education
• MS in Computer Science (Software Engineering) May - 2007 California State University, Sacramento-CA
• BS in Computer Science and Engineering June – 2003 Punjab Technical University, Jalandhar (India)
Reference Available upon request.