RAINBOW DATA SYSTEMS, INC.

Government secret stuff - if I told you... well, you know.

Subject Matter Expert

Robert Half

* Develop, troubleshoot, repair, and migrate SQL Server databases solutions for on-prem and Azure databases utilizing diverse sources such as blob storage, file, and other db types (Sybase, DB2 etc)
* SQL Server/Query Performance Tuning
* Develop, troubleshoot, repair solutions in Azure Data Factory
* Develop, troubleshoot, repair solutions is Azure Logic Apps

Information Technology Consultant

Shield Compliance

* Design, build and maintain database solutions using best practices for data warehousing for specific
client requirements. This will involve Microsoft SQL Server Database programming (stored
procedures and database design).
* Design, build and maintain ETL routines from SFTP, Azure Storage, SQL Services, Azure Data Factory, Function App, Logic App, and other services as appropriate.
* Create exception reporting.
* Create and maintain reports using OLAP and OLTP databases, and Power BI.
* Optimize database schemas, indices, queries, and reports for scalable performance.
* Implement complex business logic requirements.
* Data analysis to verify solutions are correct.
* Database partitioning, archiving and purging.
* Implement new technology, plug-ins, and APIs.
* Design and maintain SQL code source control repository and deployment process covering multiple
environments.

Sr. Developer / SQL Database Engineer

DIVERSE BUSINESS SYSTEMS, INC

Software Engineer

Debruin Consulting

Provide on location training in the Fundamentals of WebSphere Transformation Extender (WTX)
Course provides customized training examples to get the attendee up and running with skills and expertise they can use.
 * Type Tree definition
 * Type Tree importing from XSD, XML, WSDL, Copybook
 * Type Tree pack - EDI/HIPAA tree trimming
 * Mapping concepts, functional maps, tips
 * Troubleshooting
 * Error Handling
 * Hands on Lab Exercises tailored to ensure success

WTX Trainer

Marquis Data

Architect, create, enhance and maintain custom integrations with Logic Apps in Azure to 3rd party solution providers
Create custom ETL to solve business problems for large manufacturing client
Architect and implement new data mart tables into the data lake
Maintain and enhance integrations to the Data Lake for consolidated reporting and analysis 
Mentor junior members in ETL solutions

Senior Technical Consultant

MedCost

On contract through TEKsystems
Responsibilities included:
* Ad hoc query development and data discovery for new reports as well as recreation/migration of core reports in the new ERP: HealthEdge from the HRP Data Warehouse
* SSRS Report development
* SSIS/ETL development to assist reporting
* DML development in support of reporting needs
* Reporting Consultant advising on
  -Best Practices for report development, security and deployment
  -Template creation for reporting standard look and feel
  -Documentation, mentoring and training on SSRS and completed solutions

Developer

Terex AWP (Genie Industries)

- Responsible for a team of 6 BI developers and one part time SharePoint developer for BI data gathering and reporting
- Lead the development and mentoring of team members in creating ad hoc reporting solutions for AWP business reports and metrics
- Drive the architecture and development of our data warehouse and expansion of data
- Lead the team to be the center of excellence for quality BI solutions
- Improved data warehouse performance of ETL and ad hoc queries enabling faster, more efficient and reliable delivery to business stakeholders
- Key resource in migrating our on prem development stack to AWS EC2 servers
- Managed, mentored, and developed with the team to successfully test, refactor, and deliver hundreds of reports and ETL processes in connection with the Oracle 11g to 12c ERP upgrade while still being able to deliver key new reporting and BI solutions
- Promoted to Manager of the Business Intelligence Team in March 2018
- Transitioned to Business Intelligence Team as the Software Architect / Lead January 2, 2016
- Certified Scrum Master
- Enhanced our BizTalk solutions with an updated canonical model using OAGIS 10 for ProcessSalesOrder and adding new processes for raw materials purchasing using  ProcessPurchaseOrder, ChangePurchaseOrder and NotifyReceiveDelivery BODs for both individual suppliers and for integration with Kuehne + Nagel logistics integration.
- Migrated BizTalk 2006 R2 to BizTalk 2010 and .NET 4.0 web services in a TFS virtual Lab environment.
- Cognos BI Reporting and Data Warehouse team / developer with ODI 11g
- Design and build integration from legacy system to Vertex Tax System via webservices, MQ, and BizTalk
- Enhanced security applications in C# for credit card transactions within BizTalk and associated CyberSource web services
- Develop/Debug EDI maps and Trading Partner definitions
- Develop/Debug other messages, maps. orchestrations, and piplines
Additional skills to support project included SQL, C# programming language

Software Architect - Business Intelligence Manager

Group Health Cooperative

Contracted through The Tyken Group for:
* Modification of existing Message Broker flows to correct or enhance problems for HIPAA transactions
* Testing and debugging of message flows prior to production release
* Conferred with systems analysts, engineers, programmers and others to design system and to obtain information on project limitations and capabilities, performance requirements and interfaces.
* Analyzed user needs and software requirements to determine feasibility of design within time and cost constraints.
* Documented process flow as it exits currently to aid in process redesign and training.
* Mentored team members with difficult solutions as necessary.
* Provide suggestions for process improvement and/or process redesign and architecture enhancements
* Provided troubleshooting and problem solving on production issues as necessary.

WebSphere Message Broker Developer / Transformation Extender Developer

Weyerhaeuser

Primarily responsible for developing, enhancing, or repairing code and programs that enabled its users to work with various FileNet applications in a more efficient or customized manner.  Other duties included the care, feeding, and maintenance of our build server to ensure that our team always provided the latest build of quality code when deploying our solutions.

FileNet Developer / Software Engineer

Software Architect/Engineer, Business Intelligence Architect, Developer and Manager, Integration Architect/Engineer/Developer - I have worn many hats and performed many roles over the years in my career however they all have one thing in common:  providing technical solutions to business problems. 

Specialties: Data Architecture/Data Warehousing: T/SQL, SSIS, SSRS, Microsoft SQL Server (2000-2016), P/SQL, Oracle 11g/12c eBusiness Suite,  DB2, ANSI SQL, Snowflake, QlikSense/View
Integration Architecture and Development: Electronic Data Interchange (EDI), HIPPA, OAGIS and canonical message formats, BizTalk 2004-2013, Mercator/DataStage TX, Websphere Transformation Extender (WTX/ITX) - multiple versions, WebSphere Message Broker, MQSeries, Dell Boomi
Software Architect/Engineer: Continuous Integration, Automated Deployment, Test Driven Development, Change Control, SOX Compliance, PCI Compliance: .Net development, C#, C++, C, HTML, ASP.NET, javascript, vbscript, java, APIs, Web Services
Scrum Master Certification, Agile Coach, ITIL Certification

Taplio

Lisa Edwards's Linkedin Analytics

Want to drive more opportunities from LinkedIn?

Taplio

.css-1jgreyo{background-image:linear-gradient(284deg, rgba(39,43,72,1) 0%, rgba(33,47,183,1) 100%);color:transparent;-webkit-background-clip:text;background-clip:text;}Lisa Edwards's Linkedin Analytics

Want to drive more opportunities from LinkedIn?

Lisa Edwards's Linkedin Analytics