Andre Lee Email & Phone Number

Westborough, Ma, Us

Demonstrate expertise in creating and implementing complex ETL pipelines using IICS as well as architecting various integrations between Salesforce, Zuora, Snowflake, and SQL Server.Formulate and update an archival data process to store migrated data and metadata to Snowflake and build a GitHub CI/CD workflow for Snowflake.Conduct a wide array of data engineering activities in addition to collaborating with other team members to complete monthly data migrations to Salesforce and participate in daily standups.Produce detailed mapping and solution documents for a broad range of integration projects while supporting current integrations to Salesforce and legacy software.Identify, troubleshoot, diagnose, and fully resolve complex data issues, such as missing data, data integrity problems, and flow of data.Obtain, review, and analyze vital requirements, such as the ability to cancel orders/subscriptions or send logging data to Datadog, for data migrations and integrations. Establish and report on integration development plans and strategies and coordinate with other developers to ensure that integration projects are completed on time. Create RESTful APIs based on systems business rules and formulate strategies for system integrationReview and correct conflicts in data configurations and overlaps while maintaining the integrity and smooth functioning of the company's integration architecture.

Overland Park, Kansas, Us

Directed and oversaw all daily activities related to solution design, solution architecture, architecture roadmaps, prototypes, and proof-of-concepts.Played a key role in current and new projects that required integration with enterprise systems and applications by conducting critical development tasks.Generated comprehensive mapping and solution documents for large-scale integration projects and designed integration solutions for use between Salesforce and other CRM software or the client’s in-house application(s).Served as primary liaison for the technical team, functional team, and applicable business functions to ensure successful implementations.Developed RESTful APIs for clients using MuleSoft Anypoint Platform and collaborated with clients on the architectural design for data Integration, applying an API-led connectivity approach with MuleSoft methodology.Built prototypes, proof-of-concepts, and performed development tasks in support of current and new projects which require integration with enterprise systems and applicationsServed as the Integration SME in iPaaS technologies and common integration design patterns. Identified and communicated technology standards, frameworks, and principles to be used throughout the IT organization to guide technology decisions and leverage efficiency opportunities.

Atlanta, Georgia, Us

Atlanta, Georgia, Us

Design and develop ETL structures to extract, transform and load data from multiple data sources into data warehouse and other databases based on requirementsProvide technical knowledge of ETL solutions for application integration Collaborate with Business Analysts and Project Managers to convert functional specifications into technical specificationsContribute to the design process of Integration/ETL activities for assigned projectsDevelop the task plan for Integration/ETL design and development activities for assigned projectsPerform unit and integration testing activities and participate in user acceptance testing as neededProvides status updates to appropriate levels of managementCoordinate activities of IT and non-IT personnelWork closely with client community at all levelsProvide support to troubleshoot, diagnose, and resolve complex Integration and/or environmental issuesProvide support from intake through resolution and closure for application and integration, data issues, and other systems as identified and/or requiredProvide off hours support Collaborate on highly complex issue resolution with the functional, development, and integration IT teams as necessaryIdentify enhancements to improve supportability, operability, or performance of integrationCreate a POC to rewrite an existing Informatica ETL mapping to using Python for ETL processing

Bonn, De

• Created scripts for database releases• Created technical documentation and document processes• Maintained existing transactional replication system• Tested and maintained data integrity across multiple databases and environments• Supported existing physical data model• Analyzed database structures to meet customer data requirements • Made recommendations to improve queries for performance• Created new tables, views, procedures, triggers and foreign keys• Troubleshoot data integrity issues• Worked with an offshore team to help provide support to overnight database processes• Continued to be the SME and support Data Exchange and previous projects that were worked on

Bonn, De

• Produced a module that effectively downloads files from an FTP site and loads the contents of the file to a series of tables in Oracle using SQL Server DTS package and PL/SQL• Optimized existing queries for performance• Supported the existing production database code• Created Oracle packages to automate daily tasks

Bonn, De

• Developed ETL logic for Data Warehouse to load data into fact and dimension tables• Worked with an international team on ETL projects

Bonn, De

• Install SOA Suite 10G middleware• Design and implement an inbound file retrieval system that utilizes Oracle SOA suite/BPEL process• Develop and install various BPEL processes which utilize FTP Adapter, File Adapter, and DB Adapter• Implement and support procedure that schedules the recovery of files and invokes a BPEL process to download files to FTP sites• Monitor BPEL processes using BPEL manager and log files to provide continuous support in the production environment• Became the SME on Data Exchange (the in-house data retrieve process using Oracle SOA/BPEL)

Bonn, De

• Analyzed data for the business and operations• Maintained and modified existing code in the legacy application written in Java and PL/SQL• Created report modules to extract database into flat file format • Provided application support• Created Ad-Hoc queries for reports requested by GM’s and Operation Managers• Wrote sql statement to analyze data and data inconsistency • Created DTS packages to do minor ETL processing to satisfy the immediate business needs

Indianapolis, Indiana, Us

Supported the ongoing operations including installations and product development while providing excellent customer support, training and consultation Answered all Tier 3 technical and functional support questions for call-in customersSolved problems with code and determined the cause of program failuresDocumented and entered all identifiable problematic issues into tracking system and expediently informed the development team Revised web interface including ASP code to facilitate seamless installations at user sites utilizing different claims systemsModified Visual Basic and SQL code and stored procedures to facilitate seamless installations at user sites for different claims systemsImplemented code changes within documented version control processes to identify and resolve various bugsMonitored daily loads to ensure data from the client site transferred to the Healthx system with minimal errors

Supported latest application system written in Java, Oracle 8i and 9iPerformed routine administrative tasks for remote databases and wrote ad-hoc queries providing support for operational requirements Developed archival procedures to collect and transfer data from remote databases to central database Created packages and triggers to execute a series of data manipulations and enhancementsAssisted developers with implementation and supervision of new stored proceduresContributed in the identification and modification of stored procedures that improved performance issuesFacilitated testing for bugs in stored procedures and in application systems when an unforeseen variation occurred Created a series of Excel spreadsheets to import data from Oracle databases Implemented a series of ad-hoc queries for accurate reporting and troubleshootingCreated DTS for reporting and transferring dataDesigned and monitored weekly ad-hoc reports

Bs, Information Technology

Associates, Computer Information Systems