Chanikya Konda

***** ****** ******

Parker CO ***34

Phone: 801-***-****

Email: adcp8o@r.postjobfree.com

SUMMARY:

8+ years of Oracle EBS experience focusing on analysis, design, development, customization and implementation of various businesses applications using Oracle Applications E Business Suite 11i / R12/ HCM.

Well experienced in the following modules:

oFinancials: Accounts Payable (AP), Accounts Receivables (AR), General ledger (GL), Project Accounts (PA), Fixed Assets (FA), Cash Management (CM)

oSupply Chain Management (SCM): Inventory (INV), Purchasing (PO), Order Management (OM), Advanced Pricing (QP), Shipping (WSH)

oOthers: iExpenses, iProcurement, Human Resources Management Systems (HRMS), Install Base, Workflow, Application Data Interface (ADI) and Electronic Data Interface (EDI) modules

Experienced in full life cycle implementations, conversions, upgrades and support of Oracle E-Business Suite 11i / R12 environments

Experience in Oracle HCM Implementation.

Experience in Procure to Pay (P2P) and Order to Cash (O2C) cycles

Expertise in designing functional & technical specification documents

Expertise in developing MD-50, MD-70, BR-100, CV-60 documents using AIM methodology

Proficient in performing FIT / GAP analysis, designing Reports, Interfaces, Conversions and Extensions (RICE) Objects. Expertise in Forms and Form Personalization’s

Commendable experience in data conversions, interfaces, migrations, import and export using tools like SQL*Loader

Excellent verbal and written communication skills. Work well under pressure. Meet ambitious deadlines. Works well in a team as well as by self

SKILLS

Oracle Applications

HCM, OIC, Oracle Applications R12, 11i, 11.0.3, 10.7

Operating Systems

HP UNIX, Sun Solaris, Windows 7, XP/2000/NT, MS-DOS

Programming

C, C++, C#, VB.NET, ASP.NET, Unix Shell Scripting, PL/SQL, Python,VB, Silverlight, WCF, WPF

Web Specific lang.

ASP.NET, PHP, XML, DHTML, HTML, PHP, JavaScript, JSP(JDeveloper)

RDBMS

Oracle 11g/10g/9i/8i, MS SQL Server

Tools

Toad, SQL*PLUS, SQL*Loader, Oracle Workflow 2.0.3/2.5/2.6

Internet Tools

TCP/IP, FTP, Telnet, Gopher, Microsoft Front Page, Netscape Composer

Version Control Tools

Clearcase, Visual Source Safe, PVCS

Reporting Tools

Reports 2.5/ 6i, Oracle Discoverer 3i/4i, Crystal Reports

Methodology

AIM 3.0

Development Tools

Developer 2000, Oracle Forms 4.5 and Visual Studio

Oracle Applications Modules

Account Receivables (AR), Accounts Payables (AP), Project Accounting (PA), Purchasing (PO), Fixed Assets (FA), General Ledger (GL), Cash Management (CM), Human Resources(HRMS), iProcurement, iExpense, Order Management (OM), Work in Process (WIP), Inventory (INV), Quality (QA)

EXPERIENCE

Staff Engineer - Software, Aug 2017 – Present

Dish Network, Englewood, CO

As a Staff Engineer at Dish Network, my job duties include technical design, development and unit testing on integrations, reports, workflow, extensions and customizations the following modules AP, AR, FA, PO, i-Procurement, OM, QA, INV, BOM modules. Following are the list of projects that I worked on at Dish Network:

Worked on several conversions of Work Structures like Grade, Grade Rate, and Locations for HCM Implementation from R12.

Worked on Oracle Integration Cloud to develop integrations for Fidelity 401k, ADP, Success Factors, FurstPerson and TextRecruit.

Worked on Fast Formulas used in Extracts for Work Structures in Oracle HCM.

Developed PL/SQL interface to load FA Locations automatically in to R12 and developed XML Publisher reports to generate daily reports for locations created using the custom interface.

Developed custom workflow for Cycle Count Approval for non-serialized items in Inventory.

Developed custom OAF webpages for Vendor Creation in AP Module. Also, developed a custom workflow for the approval process for vendor creation.

Developed custom PL/SQL interface to load Dish One Vendors from a csv file and to generate reports for successfully loaded and rejected vendors.

Worked on custom OAF workbench in Oracle QA module used for inspecting items based on sample inspection plans.

Developed XML Publisher reports for QA Inspection and Black hole reports.

Create a PL/SQL interface for making mass changes to part number GL coding across organizational units.

Created new GL and responsibilities for Echostar merger with Dish.

Worked on custom PL/SQL interfaces and conversions for managing warranty information for Set Top Boxes manufactured by contract manufacturers.

Performed ERP production support environment for the Oracle AP, AR, SCM, HR application modules.

Worked on Customer conversion to import data from Legacy System into Oracle Account Receivables by using Customer Interface. Created SQL*Loader control programs and validation procedures to execute along with Customer Interface (AR).

Worked on UTL_PACKAGE and SQL*LOADER for the interfaces and conversions.

Created personalization's on the order management form to show values in the field dynamically, as per the requirement.

Modified the custom form for Serialized Items to add functionalities as per the business requirements using form builder.

Actively participated in SQL statements tuning using Explain Plan, SQL Trace, and TKPROF.

Developed technical documents for the extensions using functional documents and trained end users in detail.

Environment: Oracle Applications - AP, AR, GL, OM, PO, INV, HRMS, OA Framework, iProcurement, Work Flow, Oracle 10g/12i, Forms 9i/6i, Reports 9i/6i, SQL*Loader, XML Publisher, PL/SQL, TOAD, Hyperion.

Programmer Analyst, Feb 2012 – Aug 2017

Nitya Software Solutions, Salt Lake City, UT

As a programmer Analyst at Nitya Software Solutions, my job duties include technical design, development and unit testing on integrations, reports, workflow, extensions and customizations for client requirements. Also, my duties include design, develop, test and document software applications to meet client requirements.

Client: Echostar LLC, Englewood, CO

As Oracle ERP Financials/SCM Developer at Echostar LLC, my job duties include delivering enhancements, customizations in Oracle Applications 11i for AP, AR, GL, OM, INV, Cash Management, PO, FA modules. Below is a list of projects that I worked on:

Performed Tier II system troubleshooting in a production support environment for the Oracle SCM, HR, Financials application modules.

Build a custom RTF document type for printable view of Purchase Orders in iSupplier.

Developed Custom Oracle Forms for entering Trading Partners and raise custom business event to validate trading partners for sales orders and purchase orders using SAP GTS system.

Developed XML Publisher Reports for the Custom QA Collections report.

Worked on Unix Shell scripts to load files into database using CTL, SQLLOADER.

Worked on modifying several Oracle Custom Reports in Purchasing, Inventory, HRMS modules.

Worked on converting RDF reports to XML Publisher Reports to generate Excel and PDF output files.

Customized forms using CUSTOM.PLL file to meet the specific requirements.

Developed custom PL SQL Package to Finally Close and Close old Standard PO, Purchase Agreement, Releases to clean up the system.

Developed custom PL SQL Packages to generate XML, text files and SFTP the files to corresponding SFTP locations.

Written several MD70s for all the above projects at EchoStar.

Converted many custom forms, reports, PL SQL objects from single Org to multi Org.

Designed and created financial and accounting reports using Hyperion Financial Reporting Studio on a monthly and quarterly basis.

Personalized OAF Form for iSupplier.

Customized seeded OAF Form for Quality collections form.

Built custom OAF Forms for Quality.

Developed Custom OAF search and entry page for entering PROFORMA invoices for corresponding sales orders and sending the invoices to validate using SAP GTS system.

Environment: Oracle Applications - AP, AR, GL, OM, PO, INV, HRMS, OA Framework, iSupplier, Work Flow, Oracle 10g/12i, Forms 9i/6i, Reports 9i/6i, SQL*Loader, XML Publisher, PL/SQL, TOAD, Hyperion.

Client: Boeing, Renton, WA

As an Oracle Technical Consultant at Boeing, my job duties include develop interfaces, conversions, reports, and customizing work flow. Below is a list of projects that I worked on:

Designed and developed an interface custom package to create and Update vendor/vendor sites implementation according to BR which is not provided by standard API’s.

Communication from legacy to Oracle applications were established through IBM MQ series using data contracts which were signed off for both parties integrating the applications.

Designed and developed the Reconciliation process for GL module.

Provided hands on training to business user community for Post- Production support issues & daily and month-end closing of accounting periods for GL.

Written an API for Converting the Invoice Payments (AP) and was able to convert all the Historical Invoice Payment History into Production.

Written an Interface for Account Payables (AP) Invoice Upload, which creates invoices from a CSV file.

Created Asset categories and assigned the assets to that particular category in Fixed Assets.

Invoked standard API’s within custom packages for creating and updating Customer, Sites and Contacts.

Developed PL/SQL Procedures for Customer interface in Accounts Receivables (AR).

Analyzed, developed, configured and tested the AT&T customer model into the Oracle 11i TCA (Trading Community Architecture) framework.

Involved in System Analysis, Design, Development, Testing, Documentation and Implementation of AP, AR, GL modules.

Prepared Functional and Technical Specification documents.

Environment: Oracle Applications - AP, AR, GL, OM, PO, INV, Service Contracts, OA Framework, iExpense, Work Flow, Oracle 10g, Forms 9i/6i, Reports 9i/6i, SQL*Loader, XML Publisher, BPEL, PL/SQL developer, TOAD, OA Framework, Java, JSP/Servlets, JDK, J2EE, Crystal Reports, .net, MS SQL Server.

Client: Eli Lilly & Company, Indianapolis, IN

As Oracle Apps Developer at Eli Lilly & Company, my job duties include implementing, customizing and upgrading Oracle Applications 11i to R12 modules: Account Payables (AP), Account Receivables (AR), General Ledger (GL), Fixed Assets (FA), Cash Management (CM) Human Resources (HRMS) and Order Management (OM). Below is a list of projects that I worked on:

Designed customizations, interface/conversion mapping, pre-production testing, and related documentation.

Developed and customized Financial Modules (GL, AR, AP, PO), Interacted with end users to gather requirements and Draft specifications for development Phase.

Written an API for Converting the Invoice Payments (AP) and was able to convert all the Historical Invoice Payment History into Production.

Worked on Order import using Order Management OE_ORDER_PUB API to import data into Oracle. Developed PL/SQL Packages for Validations of data. And populated the data into base tables.

Prepared Functional and Technical Specification documents.

Built the custom screens for the Benefits to show the Employees and Assignment history, Leave information and ESM using OAF.

Modified the Seeded Forms Contact & Employee Balances forms to show from the Benefit Service Center

Environment: UNIX, Oracle Applications (R12) – AP, AR, Purchasing, GL, FA, HRMS, Cash Management, OM, INV, TCA, Procurement (I-Procurement, I-Supplier Portal, Purchasing, Payables), OA Framework, Work Flow, Oracle Approvals Management (AME), Oracle 10g, Forms 9i, Reports 9i, Discoverer 4.1/9.0.2, XML publisher, SQL*Loader, PL/SQL developer, UNIX, Java, JSP/Servlets, Crystal Reports, JDK, J2EE, TOAD, .net, MS SQL Server.

Client: Towers Watson, Arlington, VA

As Oracle Techno Consultant at Towers Watson, my job duties include implementing Oracle Applications 11i (11.5.10) and then upgrading to R12 (12.0.4). Below is a list of projects that I worked on:

Designed and developed a procedure to capture the existing metrics in Legacy system and make them available with Oracle as Advanced Collection Notes.

Customized HR Payroll changes Report using XML/BI Publisher.

Developed HR Termination Report using XML/BI Publisher.

Customized OTL Missing Timecard Report using XML/BI Publisher.

Customized OTL Timesheet Review Report using XML/BI Publisher. Basically this report gives the information of Project Name, Task, and Expenditure etc.

Prepared Functional and Technical Specification documents.

Designed and developed a process to provide an Extract File at the end of each GL period, with general ledger summary details of invoicing and cash activities for that period.

Developed SQL Loader Programs and PL/SQL procedures to load

oInvoice data into Oracle from various feeder systems

oReceipts data from the Bank files into AR tables using AUTO LOCKBOX

oLegacy systems data into Project Accounting interface tables.

Environment: Oracle Application EBS 11i/R12 (AR, GL, HRMS, IEX, OM), Toad 9, UNIX, SQL, PL/SQL, Oracle 10g, Workflow Builder 2.6, Developer 6i, Crystal Reports, ASP.NET, C#, MS SQL Server

Web and Application Developer, April 2008 – January 2012

iFreedom Direct Corporation, Salt Lake City, Utah

As Web and Application developer, at iFreedom Direct Corporation (mortgage services) my job duties include developing, testing and maintaining several Websites and Windows applications for Corporate, Lead Management, and Intranet using Microsoft technologies like C#, ASP.NET and MS SQL Server. Below is a list of projects that I worked on:

Reporting and Dash boards site for generating charts, dashboards and reports for managing, planning and improving productivity of loan officers. Developed using Silverlight, MS SQL Server

Developed and Maintained Lead Management website using C#, ASP.NET 2.0 and MS SQL Server.

Developed and Maintained Intranet site which includes web pages, reports and charts for Accounting, IT, HR and Quality Assurance departments using Silverlight and MS SQL Server

Online Customer Center Website where in which borrowers can upload loan documents and fill online forms for loan applications. Developed in C#, ASP.NET MVC 2.0, MS SQL Server.

Credit Reporting (part of Lead Management website) to assess the credit worthiness of mortgage loan applicants. Used C#, ASP.NET 2.0, MS SQL Server for developing the site and to consume Kroll Factual Data’s web service.

Credit Card Processing (Bill payment site) for making appraisals and other loan application charges. Used C#, ASP.NET 2.0 and MS SQL Server for developing the site.

BIDS projects to transfer large data from text files to SQL Server databases.

SQL Server jobs for daily maintenance of databases.

Worked on Replication of data from one SQL Server to another.

Upgraded MS SQL Server database from 2003 to 2005.

Upgraded several web applications from ASP.NET 1.0 to 2.0.

Managed IIS.

Created Actuate, LogiXML Reports

Environment: XML, ASP.NET, MS SQL Server, C# and Visual Studio 2008, TFS Oracle 10g,.

Software Engineer, August 2007 – April 2008

Navigator Business Solutions, Pleasant Grove, Utah

Develop SAP Business One Add-ons using its Software Development Kit, and Microsoft technologies like VB.NET and MS SQL Server. Below is a list of projects that I worked on:

Developed and successfully implemented Add-on software named Bin One for SAP Business One. Bin One is a software for managing Bin locations in a warehouse. By using Bin One, the inventory distributor can keep track of items up to a bin location, thus giving extra level of control and improving operational efficiency of an organization. As part of the job duties, I interacted with customers and gave technical support in installing and using the software.

Developed Add – on software named Unit Of Measure for SAP Business One. This software is used to change the unit of measure in the sales, purchasing and inventory transactions. This helps the user to select alternate unit of measures and manage the stock accordingly. As part of the job duties, I designed, developed, and tested the software. Also, I provided technical, maintenance and installation support for the customers.

Developed Add – on software named Distribution One for SAP Business One. This software enhances SAP B1 features in planning, sales and distribution modules. As part of the job duties, I designed, developed, and tested the software. Also, I provided technical, maintenance and installation support for the customers.

Environment: VB.NET, MS SQL Server, C# and Visual Studio 2005, TFS.

Research Assistant August 2005 – July 2007

University of Utah, Salt Lake City, Utah

Developed and successfully implemented a program for syllable Recognition. The job duties include doing research for finding unique patterns for separating the syllables and coding the algorithms for developing the software for automatic syllable recognition. This software was developed under the guidance of Dr. Gary Rose.

Environment: Oracle 9i, C#, ASP.NET, PL/SQL, JavaScript and VB script.

EDUCATION

Computational Science, Master of Science and Technology August 2005 – May 2008

University of Utah, Salt Lake City, Utah

Graduated with a master’s degree in computational science and worked on several course related projects and research projects at the University of Utah. In addition to computer science courses I also, attended several professional courses like Six Sigma for Managers, Business Fundamentals, Management Fundamentals and Data Mining and Regression in the David Eccles School of Business, University of Utah.

Computer Science and Engineering, Bachelor of Technology August 2001 – May 2005

JNTU, Hyderabad, Andhra Pradesh, India

Graduated with a bachelor’s degree in computer science and technology with studies focused on software development, software management and other programming skills.

REFERENCES

References will be provided upon requested.

Contact this candidate