SUMMARY:

• Oracle SQL / T - SQL - Expert
• PL/SQL including functions, triggers, procedures - Highly Proficient
• Data Mining / Business Intelligence / Report Analyst / Data Cleansing - Expert
• Debugging / Performance Tuning - Highly Proficient
• ETL - SSIS / SSRS / SSMS development - Highly Proficient
• SQL Server DBA including management of outsourced DBA consulting group - Proficient
• Oracle Database Administration - Proficient
• Data Warehouse - Proficient
• Sharepoint administrator with upgrade to SP 2010 - Proficient
• IFS ERP implementation / configuration / administration / application support - Proficient
• Oracle ERP technical / functional support and configuration - Highly Proficient
• Oracle to SAP conversion / implementation including LSMW data conversion
• SAP FICO and MM support - Beginner
• Streamserve reporting - Oracle and SAP - Proficient
• Oracle Discoverer - Proficient
• ABAP - export interfaces in ECC6 for a custom inventory application, as well as multiple RICE objects for custom finance, logistics, purchasing, and material objects - Beginner
• Team Lead - Highly Proficient
• Math background / Familiar with financial data and concepts
• Previously Obtained federal security clearance and CAC card
• Quick and eager to learn new skills

TECHNICAL SKILLS:

Oracle Experience: CRM, Finance (AP, AR, GL, FA), Supply Chain, EDI, System Administration, Oracle Discoverer, Oracle Forms, Oracle Reports, Oracle XML Reports, PL/SQL, Oracle Portal, RMAN, database admin, OEM 11, OEM 12

SAP Experience: ABAP, Asset Accounting, data migration using LSMW, CO Controlling, CO Cost Center Accounting, FI Accts Receivable, FI Financial Accounting, FI General Ledger, SD Billing, SD Sales & Distribution

Development Tools / Languages/Editors: SQL, PL/SQL, Paradox, MS Access, Streamserve, PowerBuilder, C#, Pascal, SQLLoader, ASP .NET, Visual Studio 2010, Visual Studio 2012, Crystal Reports, SSIS, SSRS, SSMS, T-SQL, InfoPath, Visual Studio 2008 R2, Visual Studio 2012, IDV, vi editor, shell scripting, TOAD, Putty, Cygwin, Dameware, WinSCP, SQLDeveloper

Applications: Sharepoint 2007, Sharepoint 2010, Test-IT, Quorum, Flowcal, IFS, Sage FAS

Hardware / Operating Systems: UNIX, UNIX shell scripting, Win NT/XP/2000, HP-UX, Linux

Middleware / Databases: Oracle8i, Oracle9i, Oracle 10, Oracle 11, Sybase, MS Access, SQLServer 2010, SQLServer 2012

PROFESSIONAL EXPERIENCE:

Confidential

Oracle database administrator

Responsibilities:

• Perform daily systems checks and maintenance including tablespace management, FRA management, monitoring daily jobs, backups, and alerts via OEM 12
• Deploy code to production environments
• Research ways to strengthen database and related environments and objects
• Optimize SQL and PL/SQL
• Configured OEM 12 metrics
• Creating and populating FACT and DIM tables for Data Warehouse
• Leading project to proactively deal with issues experienced with data outgrowing NUMBER(x) column types
• Support user break / fix and data requests
• Create and maintain databases, schemas, users, roles, privileges, partitions, indexes, etc
• Gathered over ½ billion records, analyzed and transformed, and delivered to a potential company business partner who would use our data for advice to investors for evaluation and most likely a new business venture

Confidential

IFS Administration

Responsibilities:

• Participated in implementation
• Administration, configuration, and security management
• Development of BI solutions including but not limited to BI cube reporting
• Applied patches
• Provided Sharepoint support, configuration, and administration
• Developed InfoPath forms
• Developed custom views
• Created dashboards
• Created new content databases for optimized Sharepoint architecture
• Provided light to moderate database admin support
• Created indexes for performance improvement in both SQLServer and Oracle
• Maintained views, tables, packages in both SQLServer and Oracle
• Set up new report server environment and architected new solutions, shared data sources, and shared datasets
• Customized vendor reports in Crystal
• Integrated SSRS reports into IFS
• In process of migrating SSRS environment to 2012
• Provided primary support for the Test-IT and Flowcal applications, working with vendor on issues
• Upgraded Test-IT and Flowcal applications
• Provided primary and backup support for Quorum application including patch application

Confidential

Senior Consultant

Responsibilities:

• Synchronized setup of 30 databases, 9 clients, 3 schemas within SQL-Server; created a master implementation script.
• Developed and supported RICE objects in SAP/ABAP for custom finance, inventory, logistics, purchasing and material objects in ECC5.
• Developed interfaces in SAP/ABAP for custom inventory and material objects in ECC6, utilizing latest SAP object-oriented technology including classes, web dynpro, and remote functions.
• Worked closely with other remote developers and users to create technical specifications, code, and test plans under strict time deadlines and methodology guidelines.
• Developed, enhanced, and supported custom reports utilizing SQL, PL/SQL, Oracle Portal, materialized views, Discoverer.
• Optimized report that ran for over 24 hours to run in under 5 minutes.
• Customized XML Publisher Reports.
• Produced a custom report determined not feasible by three previous contractors.
• Worked with code in the following modules: finance, contracts, wip, finance, install base, and inventory.
• Developed and supported customized reports utilizing C#.NET, SQL Server, and Crystal Reports.
• Designed Support Framework Initiative to educate clients about elements of a successfully designed and implemented Support Organization, and to analyze their Support Organization's readiness to provide this support post-go-live.
• Developed and presented material on SQL, PL/SQL, SQL Tuning, and ABAP Tuning.

Confidential

Systems Analyst

Responsibilities:

• Led team to migrate financial data from Oracle into SAP (AR, AP, GL, and FA).
• Coded PL/SQL programs to extract the data, and utilized LSMW to import into SAP.
• Assisted in SAP FICO implementation and post-go-live support for Canada and US.
• Led team in US Streamserve document development for both Oracle and SAP. Designed and implemented business critical documents including invoices, credit memos, and Dunning letters.
• Created an extract from Oracle that could be called from multiple sources like MS Access or Oracle, and was smart enough to make self modifications based on origin of call.
• Coded driver files to divert files to specific virtual queues on the mailroom printer.
• Developed an understanding of the core business functions in the areas of AR, AP, FA, OE, GL, Inventory, and EDI.
• Utilized functional and technical FA knowledge to resolve data corruption caused by an application user exit that even Oracle support could not resolve.
• Derived PL/SQL fix to correct an Oracle bug in the AR invoice adjustment approval process.
• Produced PL/SQL process to integrate Bellcore files, updating customer database with new area codes for area code splits .
• Co-developed proof of delivery process to ensure external user satisfaction with product delivery time.
• Designed, coded, and implemented intricate triggers and procedures to perform commission splits.
• Developed inventory pricing update logic based on a multitude of factors including customer sales.
• Performed basic UNIX shell scripting, admin functions, and Oracle database administration functions.

Confidential

Programmer Analyst

Responsibilities:

• Utilized PowerBuilder, SQL, and PL/SQL to implement code for both internal and external software.
• Customized reports and interfaces for Oracle Financial systems, including AP and AR.
• Worked closely with end-users to assess needs and assure product satisfaction.
• Analyzed accounting system needs, and developed solutions utilizing Paradox, Applix, Excel, Lotus.
• Modified Illinois Tax Reporting System to reduce input/run time from 2 hours to 10 minutes.

Confidential

Operations Trainee

Responsibilities:

• Tracked trends in operations and customer satisfaction for the Operations department.
• Provided custom solutions to improve internal operations to better serve the external customer.
• Provided support and development solutions to the EEO department.