SUMMARY:

• Excellent problem solving, analytical, designing, developing, debugging and testing skills
• Extensive programming experience in high level languages (PL/SQL, SQL, Perl, JAVA, 4GL, C)
• Proficient in modeling, designing, implementing and maintaining databases (Certified Informix - Database Specialist and 4GL developer).
• Extensive experience with packages, stored procedures, and triggers.
• Experience in Agile and Waterfall methodologies.
• Worked in various phases of Software Development Life Cycle (SDLC) including requirements gathering, design, developing and implementation of various systems.
• Experience in UNIX shell scripting, UNIX system administration.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, Perl, JAVA, UNIX Shell Programming, HTML, JavaScript, C, C++, Informix-4GL

Databases: Oracle 12c, Mysql 5.6, Informix 11.50, Netezza 4.x/3.x, Sybase 10.0.2, SQLServer 2012

Operating Systems: SOLARIS 2.8, HP-UX 11.x, AIX 4.1, True64 UNIX, LINUXMachines: Netezza, NeXT, IBM/RS 6000, DEC Alpha/Compaq, HP, SUN, PCs

Software: SQLPLUS, SQL Developer, QAPartner3.0, Visio, Forte, Netezza 3.x/4.x, Informatica 7.x

Version Control Systems: Perforce, CVS, SCCS, RCS, ClearCase

PROFESSIONAL EXPERIENCE:

Confidential

Software Developer III

• Developed database applications, PL/SQL packages, stored procedures, triggers and other database objects needed for Order Entry and Billing Systems
• Developed interfaces to allow data exchange between Order Entry System and other external systems
• Developed UNIX/Linux shell scripts and Perl scripts for batch jobs
• Developed dynamic UI screens to maintain orders, items and customer schedules
• Provided round the clock support for Order Entry Systems

Environment: PL/SQL, Oracle 12c, MySQL 5.6, Informix 11.5, JAVA, Perl, JavaScript, HTML, Linux 2.6, AIX 3.5 Shell scripts, D-Series & Tidal Schedulers

Confidential , Glendale, CA

BI Consultant

• Worked on implementation of first phase of the data warehouse for the Nationwide Better Health project. Served as the Netezza DBA and ETL developer for the project.
• Worked on migrating Walmart.com Oracle data warehouse to Netezza. Served as Netezza DBA, ETL developer for the project. ETL work involved converting PL/SQL programs to Informatica Mappings
• Worked as Netezza DBA at Michaels
• Worked on proof of concept (POC) projects for CitySearch and ABDC to test the feasibility of replacing their existing Oracle based data warehouse with Netezza Performance Server. Work involved migrating Oracle DDL to Netezza DDL, porting complex queries from Oracle SQL to Netezza SQL, benchmarking query times and data load times. This effort led to the sale of Netezza High Performance Server to CitySearch

Environment: PL/SQL, Oracle9i, Netezza, Informatica 7.x, Linux, Hp-UX 11.x, Shell scripts

Confidential, Detroit, MI

Consultant

• Developed outbound interfaces to nMarket system to receive information. The interface connects to nMarket outbound API servlet and writes a query in specified XML format and receives query results in XML format. The query results which are in XML are transformed using XSL and stored into staging tables.
• Business rules are applied on the data in the staging tables using PL/SQL procedures and the processed information is stored in other tables

Environment: PL/SQL, JAVA, XML, XSL, JDBC, HP-UX 11.0, Oracle9i, Shell scripts

Confidential, Seattle, Washington

Software Consultant

• Worked on proof of concept (POC) projects for Albertsons, ATT Wireless to test the feasibility of replacing their existing Terradata, Oracle data warehouses respectively with Netezza Performance Server.
• POC work involved porting complex queries from Terradata SQL & Oracle SQL to Netezza SQL, benchmarking query times and data load times.
• Designed and developed a Data Migration Tool for Kaman Music Corporation that allows for archiving data from one database to another and also allows for purging the data from the source database.
• The data migration process uses two-phase commit approach and runs in a distributed transaction
• Added Kitting functionality to Kaman’s existing supply chain management system.
• Kitting allows for grouping of items (components) into kits, ordering, planning, picking, packing and shipping kits.
• Modified order entry to allow for ordering of kits and modified back order processing to release kits when the components are received

Environment: Informix, Informix-4GL, True64 UNIX

Confidential, Seattle, WA

Sr. Software Engineer

• Developed a workflow CORBA service for our Web Server that allows user to set up a process work plan and its associated set of activities.
• If any of the activities fail to complete in the specified time or in the specified order, the service will pro-actively notify the user

Environment: JAVA, Visibroker, XML, JBuilder, Rational Rose, WINNT/2000, CVS, Informix

Confidential, Seattle, WA

Software Engineer

• Designed and implemented marketing campaign feature into Order Entry. Marketing campaign allows companies to provide additional discounts for items, conditional discounts, giving away free items and future discounts.
• Developed discount definition program that is used to specify discounts on an item. Modified Order Entry to use the new program logic for determining the selling price of an item
• Developed landed cost application, which determines all the costs, associated with purchasing an item from an overseas vendor.
• Developed interfaces to move data from external/legacy systems into the enterprise system

Environment: Informix-4GL, UNIX (SOLARIS, HP-UX), Informix, Oracle

Confidential, Seattle, WA

Software Engineer

• Developed Informix-4GL applications and reports for Accounting, HR and QA departments of Pioneer Industries
• Designed, implemented, administered and fine-tuned databases of Pioneer Industries
• Performed system administration tasks on an IBM RS 6000 and a Windows NT Server

Environment: Informix-4GL, UNIX (AIX), Informix, Windows NT network

Confidential, Lenexa, KS

Software Engineer

• Ported Informix NewEra (Written in C and C++) & ViewPointPro (Written in C) from Solaris to various UNIX platforms.
• ViewPointPro tool allows for building simple database applications where as NewEra allows for building more complex applications on ODBC compliant databases.
• Created and maintained databases that are used in testing NewEra and ViewPoint Pro.