PL/SQL DevelopmentProduction DeploymentDatabase RefreshDatabase Maintenance

IFS Administration• Participated in implementation• Administration, configuration, and security management• Development of BI solutions including but not limited to BI cube reporting• Applied patches Sharepoint Administrator• Upgraded Sharepoint 2007 to 2010• Provided Sharepoint support, configuration, and administration• Developed InfoPath forms• Developed custom views• Created dashboards • Created new content databases for optimized Sharepoint architecture Database Administrator (Oracle and SQL Server)• 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• Performed SQL Server backup and restore operations• Migrated database files to new server BI Reports Development• Developed custom solutions utilizing SSIS, SSRS, and SSMS, and BI Cubes in boths SSRS 2008R2 and 2012 BI• 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 Oil & Gas Software Support• 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

SQL Server Database syncSynchronized setup of 30 databases, 9 clients, 3 schemas within SQL-Server; created a master implementation script. SAP Clients (Federal, Aviation)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. Oracle Clients (Federal, Software, Manufacturing)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. C#.NET, Crystal Reports Clients (Health Care)Developed and supported customized reports utilizing C#.NET, SQL Server, and Crystal Reports.Methodology DevelopmentDesigned 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. TrainerDeveloped and presented material on SQL, PL/SQL, SQL Tuning, and ABAP Tuning.

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 criticaldocuments 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.