Resume

Sign in

Data Manager

Location:
West Palm Beach, Florida, United States
Posted:
January 04, 2018

Contact this candidate

Resume:

Resume of: Tracy Webb

Tracy Webb

West Palm Bch Fla. 33401

ac3wte@r.postjobfree.com

561-***-****

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