Romeo De Leon

• Develop, optimize and maintain the data warehouse

• Builds data pipelines and can construct complex queries on large volumes of data using SQL

• Builds automation workflows and ensures job uptime and performance

• Standardize different queries and optimize them to speed up query times

• Maintain uptime for different automation tasks

• Identify automation opportunities and implement workflows

• Ensure data security practices in different pipelines.

• Execute data and report migration from one platform to another

• Can perform source to target analysis during data/report migrations

• Excellent team player

• Work closely with colleagues to try and identify data related problems and solve them

• Work closely with clients and our other consultants to deliver project requirements
• Work closely with Salesforce developers in end to end orchestration and testing of integration
• Design and perform data migration and integration using ETL/ELT concepts.
• Perform data manipulations using SQL scripts in the database.
• Analyze, design, and execute plan for MDM, data cleanup/cleansing, salesforce org merge, data
  archival/backup.
• Create data migration documents: data dictionary, mapping document, data model and architecture using
  ERD.

• Take direction from more senior team members
• Interact directly with customers to extract their needs
• Analyze customer needs, design, configure, and test customer solutions
• Resolve technical issues through debugging, research, and investigation
• Assist with production support issues as required
• Maintain effective working relationships with team members
• Contribute to project and team documentation
• Stay current with latest Salesforce technologies and best practices within the industry
• Demonstrate Strong Time Management & Prioritization Skills
• Work both collaboratively in a team environment and independently

• Develop program modules based on highly complex software requirement specifications.
• Manage resources, project deliverables, and review testing output of developers and designers.
• Raise and resolve issues from requirement reviews, code and test results.
• Support User applications, analyze root causes and provide resolutions
• Provide on call support for emergency and urgent issues.
• Develop test plans and expected test results.
• Review code development and unit test plan.
• Perform integration testing and system testing. Debugs programs
• Develop functional and technical designs.
• Document application-related information, such as transition manuals
• Develop and enhance programs and systems as specified by Users
• Discuss the work plan, schedule, estimate of effort, milestone and deliverables with the PM/TL. Provide inputs to the work estimates of assigned tasks.
• Provide inputs to impact analysis and in the development of solutions to requirements.
• Provide guidance and assistance to less senior programmers. Performs code review.

• Responsibilities includes analyzing, importing, cleaning, transforming and validating or testing the data in sandbox to make sure that this data is not corrupt or inaccurate during migration to production.
• Responsible for data migration activities such as transferring existing data to the data store and relates old data formats to the new system's formats and requirements and perform field mapping.
• Conduct Quality Assurance and reports any data that does not meet standards.
• Collaborate with team to implement Extract, Transformation, and Load (ETL) process.
• Data verification to determine whether data was accurately translated and supports processes in the new system.
• Transforming data through SQL Server Management Studio.
• Investigation of errors if the data affect any workflows, triggers or any developer requirements and through analyzing the source data.
• Data cleaning to improve data quality eliminate redundant or obsolete information and match the requirements of the new system.
• Coordinate with Project Managers, Technical Architect and Business Analyst by gathering requirements of data migration concept
• Go-to-person when it comes to Jitterbit Operation.

• Data Migration
• Provided Data Extraction, Transformation, and Loading (ETL) for Salesforce and other platforms & databases
• Ensured data integrity and quality by performing deduplication, merging, cleansing, transformation, etc.
• Involved in numerous global Salesforce builds and provided effective solutions and designs.