PROFESSIONAL OBJECTIVE:

Pursuing a challenging Senior Programmer/Analyst position that will utilize my education, skills and experience to achieve maximum organizational efficiency, results and profitability.

SUMMARY:

• Highly motivated, career - committed Software Engineer offering many years successful software design, and implementation.
• Adaptable to widely divergent environments and responsibilities with proven ability to successfully accomplish simultaneous assignments.
• Able to modify, analyze and test codes to enhance systems applications.
• Utilize a variety of analytical techniques to resolve complex problems and efficiently assess customer needs and requirements.
• Work well independently or as strong team player with high active participation.
• Thrive on challenge and increased responsibilities.

TECHNICAL SKILLS:

Operating Systems: MS Window, AIX, Unix, Linux, HP-9000

Software: JAVA, J2EE, JDBC, Spring, Oracle Retail (Retek), SQL, PL/SQL, Pro*C, Stored/Procedures, Report/Forms, SQL Loader, Shell Programming, Kafka, Hadoop, Sqoop, Python, JSP, HTML, XML, C/C++, TCP/IP, Dialogic, Git, Jira, Eclipse, Maven, SAS

Database: Oracle, Vertica, Netezza, Hive, MongoDB, Informix

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

Developer Lead

Responsibilities:

• Experience streaming large set of structured, and semi structured, XML and JSON data file from Kafka and load in to Hive in HDFS system written in Java, and shell scripts
• Ingest large XML file format to Avro format and load into HDFS Hive.
• Responsible for processing all data coming from different source into Kafka and load data to Vertica Data Mart.
• Streaming data from Kafka into HDFS Hive for R user to analyze user shopping habit.

Developer Lead

Confidential

Responsibilities:

• Transform XML data from Legacy system and load into Vertica database, using IBM Integration Bus, Kafka, Java, and shell scripts.
• Reverse engineer of ESQL/C, and Java to shell script and SQL.
• ETL process to consolidate Oracle, Netezza, and Informix database to Vertica Database utilizing vsql and Shell scripts.

SAS Developer

Confidential

Responsibilities:

• Perform tuning and restructure Batch Process.
• Convert SAS base dataset to Netezza database.
• Created and maintained technical documentation.

Confidential, Addison, TX

Responsibilities:

• Created, modified, and enhanced Oracle Retail base form and stored procedure package.
• Developed and enhanced ETL processes using Pro*C programs, SQL, PL/SQL and AIX shell scripts. Successfully tuned various SQL statements. Enhanced several Pro*C programs to include threading and restart logic.
• Designed and developed new custom Mass Price Change Form utilized PL/SQL pricing package.

Confidential, Plano, TX

Oracle Developer

Responsibilities:

• Perform Full life cycle of Surveillance application for Confidential .
• Build Data Warehouse for Surveillance application.
• Develop ETL process using Oracle PL/SQL, Shell Scripts, and SAS to load data from multiple sources into Surveillance Data Warehouse.
• Created and maintained technical documentation.

Confidential

ETL Developer

Responsibilities:

• Work closely with users to help define system requirements and perform analysis.
• Assist and support Managers in development and test business applications.
• Converted Informatica program to Oracle PL/SQL and Shell script.
• Created and maintain technical documentation.

Confidential, Irving, Texas

Sr. Application System Analyst

Responsibilities:

• Perform full life cycle for Retek Upgrade project from Retek 6.6 to Oracle Retail (Retek 12).
• Performed data analysis and data mapping for data conversion
• Created functional design, technical designs and test cases for interface program.
• Designed and implemented ETL program to interface data between Retek 6.6, Oracle Retail 12, and data migration to Netezza Data Warehouse.
• Written ETL program (IBM data staging), PL/SQL, Oracle Database 10G.

Confidential, Dallas, Texas

Programmer/Analyst

Responsibilities:

• Developed and implemented program to interface data between IBM mainframe and Oracle Retail (Retek) system for Army Air Force Exchanges Service ( Confidential ).
• Modified and enhanced Retek base form and store procedure package.
• Developed technical design documents and testing script.
• Provided technical leadership to Developers with identified and implemented of best practices.
• Program written in Oracle Form, Pro*C, PL/SQL, Oracle Database 9i.

Confidential

Programmer/Analyst

Responsibilities:

• Developer of a core team developing Confidential (Standard Management Accounting) application utilizing Java, JSP, Alphablox, HTML, Oracle, and Essbase databases. Responsible for creating OLTP packages, procedures, triggers, user security, and account mappings.
• Developed and enhanced Forms and Reports Developer responsible for airline scheduling system (LINK). Accountable for creation of triggers, packages/procedures, enhancements and trouble shooting in PL/SQL.
• Automated Catering Environment ( Confidential ) for Confidential to schedule food packing processing using JAVA, Oracle Forms/Reports, Oracle 8i Database, and WEB able.
• Enhanced and modified Confidential system for Y2K compliance written in Pro*C, embedded SQL, and Oracle 7.3 and running under Unix.
• Experience UNIX administrator responsible for Korn Shell scripts and maintenance for various client owned applications.

Confidential, Dallas, Texas Software Engineer

Responsibilities:

• Built and maintained database replication for Oracle 7 under HP-UX/9000.