Jen K. Email & Phone Number

Palm Harbor, Fl

Systems Integration Analyst for Nationwide Virtual One Stop job board software.  Design advanced SQL and T-SQL queries and scripts for data migrations and data alters Built data conversions and data migration projects from mapping spec documents. Perform complex source data mapping and workflow diagrams Worked to create a flat file staging database for the client to convert their data into a file format that is seamlessly integrated into VOS Key contributor to UAT and go live events. Capable of making time-sensitive data changes during events Accurately translated business requirements into system functionality requirements Discover, analyze and disclose data discrepancies throughout the data migration  Optimizes and improve SQL integration code for better performance. Modified conversion process applying concurrency and synchronization to data sets. Develop programming specifications through interaction with business unit subject matter experts Perform moderate to complex application integration administration and support. Parse transaction data, triage and resolve application to integration issues  Processes change requests through CRM OPC ticket system, including application-wide data changes Collaborated with application developers to ensure data integrity and data structure to support evolving development Assists Business Analysts, Project Managers and end-users with data reporting needs Completed Agile Training. Department had not yet implemented the use of Agile iterations or SCRUM sprints.  Due to the highly sensitive government data, periodically underwent vigorous background and security checks based on each new client requirement.

Palm Harbor, Fl

Quality Assurance /Spider programmer for Nationwide Virtual One Stop job board software.  Develop and maintain automated data integration applications to query and return employment data from various websites using Kapow Robomaker/Design Maker and Regular expression syntax Moved into Job services Quality Assurance department after 6 months of employment, originally started in Job services programming department  Applied SQL queries on multiple servers to verify extracted data and run status of bots. Review live applications and bots, to ensure all data and performance standards are met and properly applied. Ranked each bot development based on data errors and return to the developer for corrections Update CRM work logs with Quality Assurance results and assist developers in adhering to Quality Assurance data guidelines

Tampa/St. Petersburg, Florida Area

System and Implementation Consultant, Rehired in 2006 handling Payroll/Human Resources software involving full cycle implementation, data collection and conversions into SQL. Directly responsible for coordinating all activities of the software project plan Onsite installation of application, installation and support of SQL 2000/2005, Web Service and Com + components. Maintained SQL servers performance using optimization and transaction log size Created client databases on assigned dedicated SQL server in house and onsite, configured logins and security Converted and verified accuracy/formatting standards of client data using excel spreadsheets and SQL import wizard/ DTS Provided onsite support for go live kick offs and managed go live issues Worked with clients to design and implement customization requirements of the application and worked directly with developers to achieve client results. Including creating custom Crystal reports Conducted end-user training and Tier 3 technical support

Tampa/St. Petersburg, Florida Area

Junior SQL Database Administrator/Computer technician for VAR Reseller of Microsoft Retail Management Point of Sale software.  Migrated product and customer data into MSDE SQL databases Remotely Developed and deploy jobs on SQL servers Provided tier 1 and 2 technical support to end users onsite and offsite. Escalated unresolved issues directly to Microsoft Retail Store Operation team in Fargo, ND for a solution. Implemented solutions provided by Microsoft Researched transaction and accounting issues using SQL Enterprise manager and query analyzer Provide onsite support and training along with supervising go live launches Created custom XML reports

Tampa/St. Petersburg, Florida Area

Information Technology/Support Administrator for a Payroll/Human Resources application that also hosts a web thin client application. 500 + client base  Maintained network of 19 servers, 15 SQL 2000 servers, 1 exchange server, 2 domain controllers and 1 web server involving hardware and software installation and monitor drive space. 98% up time Scheduled and verified server backups. Restored archived client SQL databases upon client request Moved SQL databases to various servers based on client mergers Lead support technician overseeing 1 support personnel Monitor Support queue to ensure tickets are properly processed, coded, and assigned Manage product specific Support ticket escalations through resolution and initiate escalations to L3 Support, if necessary Resolve issues and problems, alone and through collaboration with internal Sales and Sales Operations, Product Teams and customers Respond to emails and phone calls in a professional and timely manner Develop documentation, FAQs and canned responses to improve consistency and accuracy of support responses Researched advanced accounting errors for clients and assisted in financial balancing using query analyzer Complied software updates in WYSE Maker. Tested updates before client release