Jorge Eder Gonzalez Plascencia

• Analyzed complex data sets to identify trends, leading to improved decision-making and strategic planning initiatives.
• Developed and implemented data models that enhanced forecasting accuracy and supported operational efficiency across departments.
• Collaborated with cross-functional teams to streamline reporting processes, reducing turnaround times and increasing data accessibility.
• Utilized advanced analytical tools to generate actionable insights, driving process improvements and optimizing resource allocation.

ACHIEVEMENTS

• Developed custom algorithms to optimize data mining, increasing the effectiveness of analytical insights.
• Led initiatives to automate data collection processes, resulting in increased accuracy and reduced manual errors in reporting.
• Provided mentorship and training to junior analysts, fostering skill development and enhancing team productivity and performance.

• Coordinate with the ETL team new developments that according to the analysis the Company needs to have in the database.
• Unit and integration tests to improve ETL quality and reliability and development of new ETL cycles with Control-M tool.
• Optimize jobs in DataStage, and ensured data integrity across various systems.
• Manage the data in different Databases as SQL Server, Oracle, Google Cloud including BigQuery.
• As ETL developer I have the opportunity to create new projects in DataStage according to the customer requirements, also modify and expand existing jobs.
• Creation and modification of the parameters and configuration files for new and existing Jobs in the Git lab environment.
• As QA Analyst I had the opportunity to validate several ETL Jobs, including their Data requirements, S2T, Data Models and UTP documentations, their databases in Dev, Test and Production environments.

ACHIEVEMENTS

• Creation of more than 30 executive reports in Power BI that are now in use for Managers monthly decisions and actions.
• Implement solutions to improve efficiency on the team including the creation of several A&D Documentation for every single development.
• Become the POC of Business for my projects support as ETL developer.
• Optimization in the performance for several Jobs, generating the best timing of the data Flow for more than 50 jobs.

• Creation of new mappings and workflows in Informatica Intelligence Cloud Services according to the customer requirements, also modify and expand existing ones.
• Migration of several repositories from Informatica Power Center to IICS.
• I leveraged Informatica to develop and maintain complex ETL workflows, integrating data from various internal and external sources.
• Migration of several Databases from PostgreSQL to Google BigQuery.
• Building of efficient data pipelines, automating recurring tasks, and ensuring accurate and timely data processing in IICS.

ACHIEVEMENTS

• Lead the nearshore team.
• Successfully migration of all the repositories and Databases to the new Cloud Services.

• Employed Informatica Power Center to design and implement robust ETL solutions, focusing on data extraction, transformation, and loading processes.
• Collaborated closely with cross-functional teams to integrate IISC solutions with existing systems, ensuring seamless data flow and system interoperability.
• Work closely with analysts and stakeholders to optimize data integration strategies, troubleshoot performance bottlenecks, and improve the overall efficiency of data management processes.

ACHIEVEMENTS

• Become the Lead for the nearshore team.
• Creation of new Databases and mappings for all the new efforts successfully including its documentation and data modeling.

• Coordinate with the ETL team new developments that according to the analysis the Company needs to have in the database.
• As ETL developer I had the opportunity to create new projects in DataStage according to the customer requirements, also modify and expand existing jobs.
• Unit and integration tests to improve ETL quality and reliability and development of new ETL cycles with Control-M tool.
• Synthesize current business intelligence or trend data to support recommendations for action.
• Analyze business needs in order to generate standard or custom reports summarizing business, financial, or economic data for review by executives, managers, clients, and other stakeholders.
• As QA Analyst I had the opportunity to validate several ETL Jobs, including their Data requirements, S2T, Data Models and UTP documentations, their databases in Dev, Test and Production environments.

ACHIEVEMENTS

• Lead the Nearshore QA team, supervising more than 15 people and their activities, escalations, meetings, reports and assignation to their teams.
• Implement solutions to improve efficiency on the team including the creation of several A&D Documentation for every single development.
• Become the POC of Business for my projects support as ETL developer.
• Lead the Nearshore QA team as Transition and Project Manager.

• Bring solutions to US Channel Managers to increase the efficiency in planning, forecast, trending in the sales and revenue for several partners in US, focused on the ORCA system and all its domains.
• I utilized SQL Server Integration Services (SSIS) to design and implement ETL processes for data extraction, transformation, and loading from multiple sources into our data warehouse.
• Build brand new domains in the ORCA system, starting with the database, homologation, structure of the data and testing in order to have the information ready to generate new reports on demand, based on the Omnichannel requirements.
• Creation of fresh and easy to use reports helping the US Managers with a faster decision making.

ACHIEVEMENTS

• Became Program manager of the OmniChannel project for ORCA system.
• The Creation of the Major retail Scorecard, developed in Power BI with connections to ONYX database, used for several managers and directors.
• The Creation and analysis of the Scanjets Report for US, with this the management of the shipments and inventory was handled perfectly.

• Analyze business needs in order to generate standard or custom reports summarizing business, financial, or economic data for review by executives, managers, clients, and other stakeholders.
• Synthesize current business intelligence or trend data to support recommendations for action.
• Creation of Business Objects Universes based in the company needs and with this have the information ready for its use in all kind of reports.
• Coordinate with the ETL team new developments that according to the analysis the Company needs to have in the database.
• As ETL developer I had the opportunity to create new projects in DataStage according to the customer requirements also modify and expand existing jobs.
• Unit and integration tests to improve ETL quality and reliability and Development of new ETL cycles with Control-M tool.
• Administration of the BO Infrastructure including access and permissions to all the BO Universes and Reports and provide technical support for existing reports, dashboards, and other tools.

ACHIEVEMENTS

• Implement solutions to improve efficiency on the team as the Development of 'how to solve several type of issues and requests' documentation, several Sources to Target and Analysis and Design documentation for all the projects that I was involved.
• Become the trainer for new resources in the team.
• Become the POC of the BO support team.

• Develop and update project plans for projects including information such as project objectives, technologies, systems, information specifications, schedules, funding, and staffing.
• Bring solutions to all the US Channel Managers to increase the efficiency in planning, forecast, trending in the sales and revenue for more than 20,000 partners in US.
• Creation of fresh and easy to use reports helping the US Managers with a faster decision making.
• Build an historical repository database for all the dashboards and reports in all the different teams in US Channel division.
• Manage and monitor the performance of the US Channel roster database and team members, increasing the efficiency in quota assignment, MDF budget and several points of decision.

ACHIEVEMENTS

• Became the Business Planner for all the US Channel teams.
• The Creation of more than 10 automated reports that today are the best tools for all the US Channel Managers decisions.
• The Creation of more than 4 repository Share points with all the US Channel dashboards and reports.

• Develop and support IT solutions for Personal System Group on Latin America region.
• Support Business operation with applications and data systems that ensure productivity and goal achievements.
• Analyze Business needs and develop tools to make easy road to hit goals set by Management team using VB for applications and SQL.
• Collect business intelligence data from available industry reports, public information, field reports, or purchased sources.
• Create business intelligence tools or systems, including design of related databases, spreadsheets, or outputs.

ACHIEVEMENTS

• Become the Information Management support leader.
• Implement solutions to improve support time response.