Responsible for finding opportunity using external data enrichment source (ISO)Identify 350,000 ISO submissions from 7,000,000 inventory to meet $2,000,000 vendor agreementsCreated complex SQL queries to target opportunity from multiple client’s data feedsCreated complex SQL Stored Procedures that producing and rank inventory averaging 7,000,000 rowsAnalyzed previously unutilized fields in historical data to identify opportunityAnalyzed, documented, and identified improvements to high visibility ISO project to migrate from FTP to XML format that increased open rates from low-20% to mid-60% in top tier requestUse MS SQL to designed reporting tables used to trace data movement through the new ISO systemResearched, identified needed improvements, and documented Work Comp procedure

Configured benefits and payroll in SAP HCM moduleConfigured and tested Year End SAP HCM moduleBuilt interface between SAP and Hansen 8 and WorkeForce Time Management System Built several Business Objects Universes connecting to Hansen 8’s Oracle DB Developed Crystals Reports pulling data from WorkeForce Time Management SystemsResponsible for reporting identifying column changes in upgrade from Hansen 7 to Hansen 8 Upgraded in-house applications from VB to VB.net using Visual StudioGathered requirements, designed, and developed SharePoint Projects sites to meet EPA complianceIdentified and analyzed user needs, gathered requirements, designed, developed, and documented benefits enrollment dashboard

Created training materials for Regional and State DirectorsRecruited and Trained Regional and State DirectorsWorked with teams to develop monthly projects Created email accouts for membersCreated Banners and Profile images for State accounts on both Twitter and Facebook accounts

Liaison between the top five external clients and the development teamIdentified and analyzed external client needs, gathered requirements, and documented scope of projectConfirmed requirements were completed to client satisfaction without increasing scope of projectWorked closely with multiple business partners to gather requirements for enhancement requests and managed expectations in an environment where business partners competed for very limited development resourcesInvestigated and performed troubleshooting duties for reported defectsSupport internal and external business users’ needs for reporting and data analysis PL/SQL Use Business Objects and Sharepoint to support internal and external reporting and communications

Developed complex, multi-canvas forms and sub-systems using Oracle Forms 9i/10g for Troveris, an enterprise-wide application with over 700 local and remote users for both internal and ASP clientsUsed PL/SQL Developer to build stored procedures, functions, packages, triggers and html reports on Oracle Forms 9i/10g databasesModified Oracle Form properties and tuned SQL statements to improve performanceDesigned and scheduled complex Crystal reportsBuilt screen scrapers for six distinct client claims systems using AutoITHandled multiple projects simultaneously at various stages of the development life cycleMet with business partners to gather requirements, manage expectations, and conduct post-installation reviewsCreated and documented designs based on stakeholder requirementsComplied with company QA process and version control using QVCSDeveloped SQL test scripts and created test plans and scenarios