Andres Hernandez

-Successfully developed and executed multiple ETL workflows to support the creation and maintenance of a robust data warehouse. Assumed full responsibility for the entire ETL process, including data extraction, transformation, and loading, ensuring data integrity and accuracy throughout the pipeline.
-Developed a Python framework to automatically generate 1) ETL workflows based on Confluence descriptions written by analysts and 2) SQL scripts for the orchestrator.
-Worked with various data formats, including XML, XLSX, DB data, TXT, and JSON.
-Refactored and edited the Python CI/CD pipeline code.
-Troubleshot and corrected bugs and performance bottlenecks.
-Implemented JAVA scripts in various ETL pipelines.
-Collaborated with business analysts to understand and define requirements, and performed data and systems analysis using a variety of computer languages and procedures.
-Worked closely with product owners and enterprise architects to understand project requirements and implement business logic parameters for model execution.
-Mapped data between different source systems and warehouses, and created UNIX scripts to run Informatica workflows and control the ETL flow.
-Conducted quality reviews of workflows and codes.

-Spearheaded the design and creation of ETL pipelines to facilitate seamless transitions from one data warehouse to another, optimizing data management and quality.
-Designed and implemented PL/SQL stored procedures and integrated them into the IPC system, ensuring seamless data flow and processing.
-Proactively addressed data quality issues during ETL processes, utilizing strong problem-solving skills to direct solutions to the team lead for resolution.
-Verified the performance and reliability of database transformation solutions through thorough simulation testing, ensuring optimal results and end-user satisfaction.
-Refactored a complex C#-based ETL process, streamlining and improving performance and efficiency.
-Contributed as an ETL developer on a high-impact project for a top Russian Bank.

-Created and maintained ETL pipelines to support data warehousing. Designed, developed, and tested data integration processes to gather and integrate large and complex data sets.
-Contributed to a high-impact project as an ETL developer for the top Siberian Bank.

-Parsed and analyzed large sets of market data from various sources, including company websites, financial reports, and industry reports.
-Conducted extensive market surveys, utilizing both primary and secondary research methods, to gain in-depth insights into market trends, consumer behavior, and competitor analysis.

• Directed software (IT) integration.
• Directed additional services.

• Partnered with business teams and IT personnel to align project goals with business strategy and define project milestones.
• Directed product development efforts using industry-specific tools to increase sales and overall company productivity.
• Directed company international tenders (we won 1 huge contract).

ETC.