Data Manager
Resume:
Resume of: Tracy Webb
Tracy Webb
West Palm Bch Fla. 33401
*********@***.***
Professional Summary
This candidate is experienced in the complete life cycle for creating and developing the B2B and A2A business solutions and has developed tested and implemented strategies for migration of legacy data systems into new data structure environments. This includes project planning, system analysis, system design and as well as requirements gathering, development, testing, and implementation. She is also experienced with the Mercator applications and is proficient in data mapping techniques, integration flow design, xml solutions, database solutions and commerce manager. She has worked with both real-time and asynchronous data transfers. Her business background is in programming, web design, database design, system modeling, database reporting and business requirements gathering and documentation. Her business experience and communication and analysis skills are exceptional, and she is experienced in the following industries: Healthcare, Insurance, Claims, Banking, Data Warehousing, Logistics, Manufacturing, Telecommunications, Media and Marketing.
Technical Skills:
OS Systems: Programming Languages: Databases:
AIX C/C++/C# Access 2.0 / 7.0 / 8.0
DOS Crystal Formulas DB2
OS2/Warp Visual Basic 5.0 / 6.0 DTS / ETL/ SSIS / SSRS/SSAS
Windows NT 4.0 Active X Oracle
MSxp MS Visual Studio.net 2005/2010/2015 Visual Fox Pro 5.0 / 6.0
UNIX MS SQL Server 2005/2008/2012
EDI Mapping Applications:
General Applications: Boomi 3.1/3.3 Atomsphere
Mercator 1.4.03 / 5.0 /6.0 / 6.5 Database Reporting Apps & Tools:
Install Shield 5.5 Atomsphere Crystal Reports 9
Lotus Erwin 3.5
MS Excel EDI Editing Formats: PSQL
MS Explore SQL 2005/ MS Enterprise Mgr
MS Power Point Delphi Edifd97 SQL Scrip/Query Analyzer
MS Project HIPAA / Logistic Warehousing T.O.A.D. / T-SQL
MS Word Proprietary
MQ Series X12 Web Applications:
Seagate (Backup XML
Visio Cold Fusion 4.0
Visual Source Safe 6.0 EDI Editing Tools: Dream Weaver
Zeta Fax 5.5 HTML / XML
Ultra Edit OAG
XML Spy WS_FTP Pro / WinSCP
Company Robert Half Technology WPB, Fla.
Title: Senior BI Developer
Dates: March 2017 – December 2017
Updated and Monitored SSIS and SSRS packages in SQL Server 2016
Provided analytical data for business reports and client applications using SSAS
Created SSIS packages to load data from .xls and .cvs files and from Oracle and SQL Server
Used MS Visual Studio .net 2015, and MS SQL 2016 software
Creation of technical documentation for processes
Developed queries in SQL 2016 and retrieved data from multiple relational tables, temporal tables and data warehouses
Performed unit testing of application modifications to assure accuracy and performed documentation of changes
Performed data analysis, peer reviews and coding signoffs
Queried multidimensional objects, such as cubes, and return multidimensional cell sets that contain the cube's data
Performed unit testing of application modifications to assure accuracy and best practices
Creation of technical documentation for processes for data models within agile environment
Used TFS source safe to check in and out application in development.
Promoted ETL / EDI Processes into Production and performed monitoring
Resolved ETL / EDI mapping issues and reporting issues / updates
Translated business requirements into technical solutions
Used TFS source safe to check in and out application in development
Creation of technical, function and procedure documentation for mapping processes and data flow design
Company Kroger-Axium Orlando, Fla.
Title: Senior Application Developer – Contractor
Dates: May 2016 – February 2017
Updated and Monitored SSIS and SSRS packages in SQL Server 2016
Used MS Visual Studio .net 2013, and MS SQL 2012 software.
Worked with star schema and dimensions
Performed peer reviews and coding signoffs
Worked with QA for solution testing and setups
Developed stored procedures, functions, queries and automatic jobs for data retrieval in SQL 2012
Used TFS source safe to check in and out application in development.
Promoted ETL / EDI Processes into Production and performed monitoring
Resolved ETL / EDI mapping issues and reporting issues / updates
Created applications using C# in visual studio .net 2013.
Company DM Warehouse, West Palm Bch, Fla.
Title: Senior Application Developer
Dates: November 2014 – May 2016
Update and eliminate redundant systems/processes and streamline workflow and administrative operations.
Created applications using SSIS and SSRS packages in SQL Server 2012.
Developed using T-SQL, MS Enterprise mgr, MS Visual Studio .net 2010/2013, and MS SQL 2012 software.
Creation of technical, function and procedure documentation for processes and data flow design
Performed unit testing of application modifications to assure accuracy and performed documentation of changes
Performed peer reviews and coding signoffs
Updated and Monitored SSIS and SSRS packages in SQL Server 2008/2012
Used MS Visual Studio .net 2010, and MS SQL 2008/2012 software.
Creation of technical documentation for processes
Developed queries in SQL 2008/2012
Architected DB tables Infrastructure for Warehousing ETL Data Storage / Reporting and Adjudications
Development and implemented various software modules, including T-SQL, SSIS, Boomi 3.3, Boomi AtomSphere apps
Created in house reporting and alerting system using SSIS and Boomi Atomsphere
Used TFS source safe to check in and out application in development
Company Global Health, West Palm Bch, Fla.
Title: Senior Application Developer - Contractor
Dates: August 2013 – November 2014
Updated and Monitored SSIS and SSRS packages in SQL Server 2008
Used MS Visual Studio .net 2010, and MS SQL 2008 software.
Creation of technical documentation for processes
Performed unit testing of application modifications to assure accuracy and performed documentation of changes
Performed peer reviews and coding signoffs
Developed queries in SQL 2008
Used TFS source safe to check in and out application in development.
Promoted ETL / EDI Processes into Production and performed monitoring
Resolved ETL / EDI mapping issues and reporting issues / updates
Created data parsing applications using C# in visual studio .net 2010/2013.
Created data parsing applications using Visual Basic in visual studio .net 2010
Created data loading application using Visual Basic in visual studio .net 2010.
Used TFS source safe to check in and out application in development
Creation of technical, function and procedure documentation for mapping processes and data flow design
Wrote replacement code in SQL 2010 and C# for Visual Fox Pro module
Created applications using C# in visual studio .net 2010/2013.
Company Nordic, Atlanta, GA
Title: ETL Application Developer
Dates: November 2010 – August 2013
As an ETL Application Developer at Nordic I performed the following task:
Recommended system improvements and enhancements.
Architected DB tables Infrastructure for Warehousing ETL Data Storage / Reporting and Adjudications
Development and implemented various software modules, including T-SQL, SSIS, Boomi 3.3, Boomi AtomSphere apps
Created in house reporting and alerting system using SSIS and Boomi Atomsphere
Developed using T-SQL, MS Enterprise mgr, MS Visual Studio20056/ WS SCP, and MS SQL 2005 software.
Update and eliminate redundant systems/processes and streamline workflow and administrative operations.
Created applications using SSIS and SSRS packages in SQL Server 2005.
Ran analysis using SSAS
Creation of technical, function and procedure documentation for mapping processes and data flow design
Performed unit testing of application modifications to assure accuracy and performed documentation of changes
Performed peer reviews and coding signoffs
Designed, developed, tested and documented logistic maps.
Developed map migration documentation for production
Promoted ETL Processes into Production and performed monitoring
Resolved EDI mapping issues and reporting issues / updates
Developed and managed the following logistics maps:
Logistics Maps:
ID: Version: Name:
940 v4010 Warehouse Shipping Order
945 v4010 Warehouse Shipping Advice
943 v4010 Warehouse Stock Transfer Shipment Advice
944 v4010 Warehouse Stock Transfer Receipt Advice
947 v4010 Warehouse Inventory Adjustment Advice
846 v4010 Inventory Inquiry/Advice
856 v4010 Ship Notice Manifest
Company MSC, Jacksonville, FL
Title: Application Developer
Dates: September 2004 – October 2010
As an Application Developer at MSCI performed the following task:
Recommended system improvements and enhancements.
Development and implementation of various software modules, including SSRS, SSAS, SSIS DTS, Boomi 3.3,
VB, MS Enterprise mgr, MS Visual Studio 6/ WS FTP Pro, and MS SQL 2005 software.
Update and eliminate redundant systems/processes and streamline workflow and administrative operations.
Created applications using Visual Basic 6, Boomi 3.3, and MS SQL.
Company Crossmatch, West Palm Bch, FL
Title: Consultant
Dates: March 2004 – September 2004
As a Consultant at Crossmatch Technologies I performed the following task:
Conduct business process reviews, and recommend workplace, interviews and system improvements.
Collaborate with clients to determine current and future needs.
Manage implementation of various software modules, including Mercator 5.0, DB2 and SQL 2000 software.
Provide effective training and change management options and alternatives.
Advised and aid clients with cost accounting issues and systems.
Created applications using VB.net and C++ visual studio.
Company ACS, Tallahassee, FL
Title: Consultant
Dates: February 2003 – February 2004
As a Consultant at ACS I performed the following task:
Planned and coordinated the system design, and migrations strategies.
Implementation directory services systems within the IBM AIX productions environment using DB2 as the target environment for data warehousing.
Deployed system applications into the production environment.
Once in production I monitored the systems using UNIX command and the management console utility.
Used vi, crystal reports, Erwin, SQL DBMS and Access for reporting tools.
Resolved issues and implemented system enhance while the system ran parallel with the legacy system for two weeks.
Ensured that all systems operations were running as planned and all errors were resolved. After the two-week period ended the legacy system was suspended.
Created documentation for system design and application process flow in production. Created and updated business rules specs for EDI X12, EBCDIC, XML and HIPAA transactions.
Queried database tables using SQL statements.
Wrote results of SQL queries into Excel spreadsheets for distributing and review.
Helped to identify client’s needs, interpreted development issues and questions.
Created database reports using both Access and Crystal reports.
Provided data summery reports using crystal reports.
Acted as a liaison between BA’s and Developers to help resolve issues and implement development updates.
Performed Epiphany analysis.
Participated in and coordinated weekly status meeting.
Mercator 6.7 integration flow designer, event server for triggers and design studio for data translations in both real-time and asynchronous data transfer modes.
Used .Net systems and MSMQ was used for file storage in messaging queues. Also used FTP for file transfers.
Was accountable for application accuracy and time constraints of applications deliverable.
Used Mercator commerce manager and compliance check to verify trade links, generate 997’s and to insure that all data was HIPAA compliant.
Interfaced the Mercator database application with the DB2 database on the AIX server to store operational technical metadata for data warehousing components.
Provided all application deliverable before scheduled time.
Identified, analyzed and corrected system design errors with minimum system downtime.
Used visual source safe to check in and out application in development.
Used Erwin / DB2 connect / Ultra Edit and XML spy for editing tools.
Provided technical documentation for systems design, audits and process flow.
Managed systems in the production environment after migrations and integrations were complete.
Monitored system performance and performed system updates and enhancement.
Mercator Software, Inc., Wilton, CT / Technical Consultant
August 2000 – February 2003
Mercator Training Classes: January 2003 – February 2003 – while employed at Mercator
State of Illinois in Springfield IL. At the State of Illinois, conducted several “Fundamentals of Data Transformation” and “Mercator for EDI” training classes for the Department of Labor employees.
Healthcare / Insurance / Claims: April 2002 – January 2003 - while employed at Mercator
Highmark Logistics - The purpose of this assignment was to assist Highmark Logistics in Camp Hill, PA, with the following services;
Modifications of existing 277U type trees to accommodate Highmark’s proprietary HIPAA Implementation standards.
Unit testing of modifications to assure accuracy and documentation of changes made.
My participation also included designing, developing, testing and documenting the below HIPAA map translations:
HIPAA Maps:
ID: Version: Name:
837P/I v4010 Health Care Claim
834 v4010 Benefit Enrollment
276/277 v4010 Claim Status Request/Acknowledgement
270/271 v4010 Eligibility Coverage/Benefit Information
i/p277u v4010 Acknowledgement Response
277 v4010 Health Care Claim Status Notification
835i/p/ v4010 Health Care Claim Payment Advise834
Healthcare / Insurance / Claims: April 2002 – April 2002 - while employed at Mercator
United Healthcare - The purpose of this assignment was for me to be of assistance to the on site senior consultant at UHC in Basking Ridge, NJ. My task consisted of providing mentoring; mapping and knowledge transfer services to the client’s mapping team.
Healthcare / Insurance / Claims: February 2002 – April 2002 - while employed at Mercator
EMC / Acord Insurance - Participated in the development of the EMC / Acord Insurance Standard Web Demo. My responsibilities involved developing maps that translated XML data into a flat file format and then sending that flat file to a server via HTTP adapter for corresponding data information. Next, translating the returned data from server back into XML and then displaying this returned data via web page for client response.
My involvement also included testing, troubleshooting, and documenting these demo maps.
Warehousing / Logistics: November 2001 – February 2002 - while employed at Mercator
Excel Logistics – The purpose of this assignment was to assist Excel Logistics in Mechanicsburg, PA, with the following services: Development of the three X12 EDI to XML and three XML to X12 EDI maps. Creation of a 997 map for acknowledgements and development of five Edifd99.B maps which translated Edifd99.B to XML as well as XML to Edifd99.B.
My participation also included mentoring and coaching the client throughout this development process as well as designing, developing, testing and documenting the below EDI, Edifd99.B and XML map translations:
EDI Maps:
ID: Version: Name:
EDI to XML
856o v4010 Ship Notice
862o v4010 Planning Schedule
888o v4010 Item Maintenance
997 v4010 Acknowledgement
XML to EDI
846i v4010 Inventory Inquiry
856i v4010 Ship Notice
861i v4010 Receiving Advice
Edifact Maps:
ID: Version: Name:
Edifd99.B to XML
856o v99b/DESADV Ship Notice
862o v99b/DELJIT Shipping Schedule
XML to Edifd99.B
846i v99b/RECADV Inventory Inquiry
856i v99b/DELFOR Ship Notice
861i v99b/INVRPT Receiving Advice
Healthcare / Insurance / Claims: August 2001 - November 2001 - while employed at Mercator
Humana Corporation – Assisted with the integration and creation of approximately 70 maps at Humana Corporation of Louisville, KY. These maps formats were XML to EBCDIC and EBCDIC to XML. Helped resolve comp-3 field issues in mapping translation and provided client with knowledge in Mercator mapping, configuration and design.
Also provided assistance with their Integration Flow Design scheme and helped trouble shoot errors with their routing map functionality. Assisted with the development of their 70 maps, which enable them to meet their development deadline.
My involvement also included testing, troubleshooting, documenting and peer reviewing these maps.
Manufacturing July 2001 - August 2001 - while employed at Mercator
Covisint –Provided a proof-of-concept for client at Covisint in Southfield, MI, illustrating the Delphi Edifd97.A and XML system maps. Covisint was in their final phase of Delphi to XML and XML to Delphi map development. My role in this process included the following: Providing a good faith estimate for hours required to complete this final phase. Creating a technical assessment of their system architecture to ensure that standard requirements were met. Development of their Delphi Edifd97.A and XML system maps
My involvement also included designing, developing, testing and provided a proof of concept for the below Delphi Edifd97.A and XML map translations:
ID: Version: Name:
856 v3010/DESADV Ship Notice
830 v3010/DELFOR Planning Schedule
862 v3010/DELJIT Shipping Schedule
Healthcare / Insurance / Claims: June 2001 – July 2001 - while employed at Mercator
Blue Cross Blue Shield of Alabama – Provided assistance in helping client generate a 997 transaction in Enterprise Broker. Also, trained client in the development process of creating a test.msd system in the Integration Flow Designer by instructing them through the process of designing a system map, building a system, setting events in the Event Server, deploying the created test system along with the .msl and finally viewing the results through the Event Monitor and Event Server status windows. I also provided a test system for their future reference.
Telephone / Communications: September 2000 – June 2001 - while employed at Mercator
Bell South – Participated in the Mercator/EDI replacement project at BellSouth in Birmingham, AL. This replacement implementation process was incorporated to perform EDI translations and provide a new UNIX vendor product to replace the pre-existing Harbinger application.
My role in this process involved the creation of technical, functional and procedure documentation for mapping processes and the development of client specific maps, which included designing, construction, testing and peer reviewing the following map types:
ID: Version: Name:
504 v4010 Transaction Information
810 v2000 - v3030 - v3050 Detailed Billing and Purchase Statements
811 v3040 - v4010 Consolidated Service Invoice Statements
820 v3020 - v3030 Remittance Advice
821 v3050 Reconciled Account Information
830 v3030 Forecast
850 v2000 - v3020 - v3050 Purchase Orders
855 v2000 - v2003 - v3050 Purchase Order Acknowledgement
860 v2000 - v3050 Purchase Order Change
865 v2000 - v3020 - v3050 Purchase Order Change Acknowledgement
In addition my involvement in this project also included the development of a proprietary error report to meet the client’s specific error handling needs and participation in the construction and design of the blob text file used to write to the client’s database.
I also assisted in mentoring and provided technical training for client team members in the design and development of the above Mercator maps and ensured that each team member understood the process used to implement the Mercator mapping tool.
Media: September 2000 – September 2000 - while employed at Mercator
The New York Times – Designed a map to enable unit testing and development with client’s People Soft EDI Manager application. This involved creating an 811 map to produce desired formatted ANSI data to ensure compatibility with the People Soft EDI Manager. This assignment also involved mentoring the client in the design and development of Mercator applications.
Warehousing/Material Handling: August 2000 – September 2000
{While employed at Mercator}
Vendor B2B Vendor Challenge - Participated in the B2B Vendor Challenge in Cambridge, MA. Over 50 members of the press and analyst communities attended this event. My participation included working with a team to present A2A and B2B integration using both OMG and OAGI standards and also interoperability with legacy B2B standards. I also assisted in the XML and EDI map creation and data development for the integration testing and implementation phases of the Mercator Solution.
Cybear Inc, Boca Raton, FL
October 1999 - August 2000
Applications Developer
October 1999 until Present
As an Applications Developer my responsibilities included:
Running and testing SQL queries using T.O.A.D
Writing and running using Oracle SQL plus
Creating Network templates in Cold Fusion
Creating Reports using Crystal Report
Creating Analysis Profiles in Web Trends
Proxymed Inc, Ft Lauderdale, FL
December 1996 - October 1999
Programmer-Specialist / Mercator Mapper / Operations Technician
As a Programmer Specialist my responsibilities included:
April 1999 - October 1999
Error Handling and Documentation
Distributing and creating software flow charts using Visio
Editing and debugging coded applications
Creating Crystal Reports as distributing
Developing applications using C/C++
Controlling applications development using Visual Source Safe
Access Data Base programming using Visual Basic 5.0 / 6.0
Creating installable application using Install Shield for disk media
Showing Data Base relationships in Erwin
Creating HTML applications
Altering Install Shield script language
As a Mercator Mapper my responsibilities included:
July 1998 - April 1999
Testing maps and data content for quality assurance
Creating maps to translate inbound EDI format into variant outbound format
Resolving EDI mapping issues
Creating application flow charts
Map implementations, documentation and migration into Production
Creating interfaces application for EDI communication Zeta fax product
Parsing and manipulating EDI data through Mercator application
Creating DSN and MDQ's for table referencing and look-ups
Using Ultra Edit to troubleshoot and translate EDI data packet errors in hexadecimal.
As an Operations Technician my responsibilities included:
December 1996 - July 1998
Monitoring client network activity on Windows NT 3.51 and 4.0 operating system
Implementation and documentation of new software in Production
Monitoring SQL applications and database
Documenting and correcting network data packet errors / Protocols: TCPIP - SNA and FTP
Backing up and archiving network data in access and performing nightly server tape backups
Running reports and queries in access on network daily activity
Creating access macros to run all daily monitoring and nightly back up procedures
Climate Control Services, Delray Bch. FL
January 1995 - December 1996
Contract Analyst
As a Contract Analyst at Climate Control Service duties included:
Updating and billing Customer accounts
Opening and closing Customer accounts
Creating company applications using Apha-write
Keane, Inc. Boca Raton, FL
January 1994 - January 1995
OS2 Warp Consultant
As an OS2 Warp Consultant for Keane, Inc. assigned to IBM Boca Raton, was responsible for:
Editing and reconfiguring system, config.sys & loading device drivers for computer hardware
Displaying and reconfiguring IRQ's. Accessing BBs to download fix pak for system debugging
Partitioning and reconfiguring hard drives and adding boot-manager sections.
Creating utility disk and performing tape back-ups and restores.
Specialized in OS2 / Warp installation application
Dell Boomi Atomsphere Atlanta, GA.
Atomsphere Training
Studies: Event Server, XML Data Transformation
Finished: June 2012
TSI International Danbury, CT.
Mercator Training 6.0 version
Studies: Event Server, XML Data Transformation
Finished: May 2001
TSI International Danbury, CT.
Mercator Training 6.0 version
Studies: Fundamentals of Data Transformation, Mercator for EDI, Using Mercator Commerce Manager, Using Mercator Database Adapters, Event Server, XML Transformations, HIPPA
Finished: January 2002
New England Institute of Technology at West Palm Bch, Fla.
Degree: Specialized Associates Degree in Computer Programming
Studies included: UNIX, Windows NT 4.0, Novell Networking System, Visual Fox Pro 5.0 / 6.0, C and C++ programming.
Graduated: June 1999
TSI International Danbury, CT.
Mercator Training 1.4 version
Studies: Mercator for EDI Mapping, System Editor, Functions & Expression, Type Tree and Map Editor and Into to Mercator
Finished: August 1998
Palm Beach Jr. College in Boca Raton Fla.
Degree: Associates Degree in Business Admin
Studies included: General Studies
Graduated: June 1992
Contact this candidate