ALEXANDER C. MUKALEL
Email: acqepk@r.postjobfree.com
SUMMARY
Experienced IT professional with strong background in business applications.
* ***** ** ********* *** functional experience in Oracle applications and PL/SQL
Strong analytical skills combined with experience in object oriented programming techniques.
SOFTWARE SKILLS
UNIX
Oracle 11g, 10g, 9i
SQL Server 2008, 2000
Netezza
SSIS
JDA
Oracle Discoverer
PL/SQL
Korn Shell
Perl
C/C++
ASP.NET
PVCS
Toad
Appworx/UC4/Automic
Visual Sudio
Source Safe
HEAT
Cognos
Microstrategy
EXPERIENCE
2006 Feb – Present Speedway LLC (Formerly Hess Corporation)
Application Development Analyst Woodbridge, NJ
Develops and enhances Oracle Retail applications: including Retail Management System (RMS), Retail Data Warehouse (RDW) and Retail Sales Audit (ReSA)
Develops Oracle procedures, functions, packages and triggers
Creates new and modifies existing Oracle packages to optimize performance
Extracts data through UNIX/Perl Scripts
Develops SSIS packages
Loads data through SQL* Loader
Maintains user’s (10000+) access in Retek Applications and complies with SOX audit
Monitors nightly batch processes utilizing Appworx/UC4. Resolves job aborts for RMS, RDW and ReSA
Creates and modifies Active Directory profiles for retail sites, territories, regions including realignments and creation of new retail sites
Daily Production Support
Performs all maintenance tasks Appworx/UC4 database (Oracle 9i and 11g)
Upgraded Appworx (5.1) to Application Manager (v8)
Installed and configured Application Manager on multiple environments
Develops and implements jobs, chain/process flows, schedules and logins and complied with SOX audit
Designs and Develops 50+ Oracle Discoverer reports (RMS) for multiple business units
Enhances performance on existing reports, creates and maintains EUL and business units within Discoverer
Designs and develops in-house Auto Replenishment system for top selling cigarette brand which drove net sales up 20% for 900+ retail sites
Established relationship with multiple vendors (McLane, 4R), develops and implemented auto replenishment system for the entire organization
Designs and develops reports in Cognos
2005 Feb – 2006 Jan
Hess Corporation
Application development Analyst (Internship)
Port Reading, NJ
Developed ASP.NET application for Port Reading Refinery
Developed complex Excel macros (VB) for refinery finance division to extract data from the World Wide Web
2005 June – 2005 Aug
CNA Insurance
Software Development Analyst (Internship)
Monmouth Junction, NJ
Developed and prepared enterprise wide applications
Conducted detailed analyses of all defined system specifications for change in system requirements, client requirements and developed all levels of logic flow charts
Prepared program test data, tested and debugged programs
Worked with other IT staff as appropriate, in overall systems testing
Stayed up to date on trends and developments with the functional area of applications development
Designed and implemented data dictionary with use of Erwin Tool
1999 - 2005
Essex County College
Technical Support Specialist
Newark, NJ
Monitored the development and installation of standard menu systems or desktops; and provide user (500+) access and support, as required
Troubleshot and repaired (Win 9X, 2000, XP Pro systems) on hardware and software issues as well as network issues
Added workstations to Workgroups and Domains on Windows 2000 network and maintained user accounts
Diagnosed problems/conflicts, troubleshot and repaired client software issues, print server, hardware connectivity and configuring LAN and telephony
EDUCATION
2000- 2005
New Jersey Institute of Technology
Bachelor of Science: Computer Science
Newark, NJ