Sr Software Engineer

PRERNA GOEL

Fremont, CA 510-***-**** (H)

*.******@*****.***

OBJECTIVE:

A self-motivated, team player with good organizational skills and outgoing personality seeks a position of responsibility and hands-on software development engineer for database and web application software.

SUMMARY:

10+ years of IT experience in database/web application development.

Involved in software development lifecycle (SDLC) participating in requirements gathering, design, development and maintenance of production systems.

Implemented custom web applications using Web PL/SQL, JavaScript, jQuery, HTML and CSS to automate departmental processes.

Extensive experience with writing packages, stored procedures, functions and database triggers using SQL and PL/SQL in Oracle.

Experience in weekend support for production systems with troubleshooting and resolving issues which may include modifications to database schema/data, programming logic, and/or business processes.

Multitasked with excellent track record of interfacing with clients on executing concurrent multi-technology projects.

Excellent communication skills, self-motivated, ability to work independently or cooperatively in a team, eager to learn, ability to grasp quickly.

SKILLS:

Languages: SQL, PL/SQL, JavaScript, CSS, HTML, jQuery.

Software: Oracle 11g/9i/8i, IFS ERP, Oracle Financial Applications 11i,

Microsoft SharePoint, Microsoft InfoPath Form Services, DocuSign

Operating Systems: Windows NT/XP, Unix – HP/UX, Solaris

Others: Toad, SQL*Plus, SQL*Loader, Crystal Reports, Shell Script,

Microsoft Visio, RCS.

Oracle PL/SQL Developer Certified Associate. Passed exams –

Introduction to Oracle: SQL and Program with PL/SQL.

WORK EXPERIENCE:

Company: Space Systems Loral (SSL), Palo Alto, CA. June, 06 - Current

Title: Senior Software Specialist

Key member of IT team experienced in designing and implementing solutions for various functional groups such as Manufacturing, Finance, and HR, using Microsoft SharePoint, Oracle database programming for creating interfaces and reports, and Web application development.

Project: Implementation of packages for migration from IFS to Oracle Financials 11i.

Environment: IFS, SQL, PL/SQL, Oracle 11i, Toad, Windows, Unix Shell.

Role: Financials and Applications Development Team Developer.

Singlehandedly responsible for the development, from the ground up, the corporation's first automated Cost Movement Inventory Reconciliation that led to head count reductions in the Finance/Inventory.

Implemented the entire application/interfaces for Corporate Financials to support actual costing including Non-labor Actuals, and Price Variances from newly implemented Manufacturing ERP System (IFS).

Responsibilities:

Implemented interfaces using PL/SQL packages to collect data from Ceridian Payroll, T&A, Oracle Financial Analyzer (OFA) and Oracle 11i Financials, perform validations, data conversions and calculations, to ingest into IFS using published API.

Analyzed and tuned queries utilizing hints and rewriting queries and cursors, utilizing BULK Collections for performance enhancement.

Utilized PL/SQL Exception handling for debugging support in production.

Project: Classified Ads Web Application

Environment: SQL, PL/SQL, Web PL/SQL, JavaScript, jQuery, HTML, CSS, YUI

Role: Oracle Database/Web Developer (Full Stack development).

Implemented a company internal marketplace for employees to place personal classifieds and announcements. The web based application included HR approval process, and user & administrator consoles for managing (adding/deleting/approving/rejecting etc.) the classifieds.

Responsibilities:

Coordinated with Multimedia and HR teams to gather and define requirements. Designed the architecture to utilize Oracle Web PL/SQL gateway.

Designed Entity/Relationship (E/R) models and implemented the database schema. Integrated with corporate Active Directory (AD) to authenticate employee profile.

Implemented a web form and grid display for collecting/displaying information for a classified; including three image uploads, and showing their thumbnails on the form.

Implemented front-end web flow and backend logic for HR approval process. Created front-end web flow for an employee to view its approved, or pending listings.

Images are managed as BLOBs, accessed in web application via Oracle DAD.

Project: Costed Bill Of Materials Hierarchical Report

Environment: SQL, PL/SQL, Oracle 9i, Toad, Crystal Reports.

Role: Oracle database/report developer.

The report pulls the ERP requirements from nightly explosion and traces through a very complex series of requirement levels from the top of the Satellite down to its lowest levels. This helped the company in their proposals and estimate the cost of building a Satellite.

Responsibilities:

Created Stack API to implement functions like initialize, push, pop, copy, search etc by utilizing Records and PL/SQL collections.

Created PL/SQL procedures utilizing the custom Stack API to traverse complex Satellite parts hierarchy, performing validations, assigning quantities and dollars at every level.

Created PL/SQL procedures to be used as Crystal Report dataset. Performed additional calculations, summarization as per the requirement.

Involved with ongoing support and performance enhancements for a faster execution.

Project: Electronic Signature for Capital Expenditure Requests.

Environment: Microsoft Visual Studio, SharePoint Designer, InfoPath, XML, DocuSign.

Role: SharePoint Developer.

Automated the approval process for Capital Expenditure Request (CER) form by replacing multi tier annual with electronic signature flow using DocuSign and Microsoft SharePoint Designer.

Responsibilities:

Designed List workflow to route approval request based on complex logic including expenditure amount and org types.

Designed a CER form with collapsible sections and rules for conditional formatting using Microsoft InfoPath Form Services.

Implemented custom action in SharePoint Designer to connect and send XML payload to DocuSign for electronic signature.

Create/support multiple SharePoint sites for requirements from different departmental groups. Involved in creating custom lists/libraries, web parts, workflows, permissions levels, etc.

Project: Automation of Tuition Reimbursement.

Environment: SQL, PL/SQL, Web PL/SQL, JavaScript, jQuery, HTML, CSS, YUI

Role: Oracle Database/Web Developer (Full Stack development).

Implemented a company internal web application to automate the process for employees to request and get reimbursed for allocated education expenses. The application comprised of Manager/HR approval process, and included user, manager and HR consoles for viewing active/approved/rejected requests.

Responsibilities:

Designed Entity/Relationship (E/R) models and implemented the database schema.

Implemented web forms/layouts for collecting information for an education intent request. The employee and manager profile is pulled from Corporate Active Directory.

Utilized third party widgets such as YUI autocomplete, calendar and slider widgets. Implemented input validations and length restrictions using JavaScript/jQuery.

Implemented front-end web flow and backend logic for Manager and HR approval process. Created front-end web flow for employee, manager, HR to view approved, rejected or pending requests.

Generated a HTML report for HR team to view the total reimbursements made, number of participants, and number of approvals/rejections for given time period.

Company: State Compensation Insurance Fund (SCIF), San Francisco, CA. Jan’04 – Apr’06

Environment: SQL, PL/SQL, Oracle 9i, Toad, Shell Scripts, HP UNIX,

Project: Electronics Claims File (ECF)

Role: Oracle Database Developer

ECF Project is an outgrowth of the Claims Imaging and Claims Re-engineering systems projects. ECF is designed to consolidate existing claims processes and databases into a single integrated system that processes all claims data and facilitate data sharing as well as external access for clients and business partners.

Responsibilities:

Developed procedures to identify the records that need to be reconciled between staging table and application tables.

Developed PL/SQL packages for migrating data from staging table to business logic tables --parties, claims, and customers, etc. Performed validation, extraction of multi field values and populating it in application tables.

Developed complex queries using inline views, correlated sub-queries, complex joins, merge, cursors and grouping/ aggregation functionality.

EDUCATION:

Master of Science in Computer Science, California State University, Hayward, CA (3.7/4.0)

Contact this candidate