Oscar Ramos Penny, Developer in Santiago de Surco, Peru
Oscar is available for hire
Hire Oscar

Oscar Ramos Penny

Verified Expert  in Engineering

Database and Software Developer

Santiago de Surco, Peru

Toptal member since February 28, 2023

Bio

Oscar is a data specialist and software developer with expertise in ETL extraction, optimization, migration, and web application development. Oscar has spearheaded the delivery and SLA compliance of automated reports, mentored team members, and participated in the design and implementation of company-wide initiatives. He's an expert in SQL, SQL Server, SSIS and SSRS. Previous roles include senior enterprise data services lead, configuration team lead, .NET developer, and process analyst.

Portfolio

Cignium Technologies
Azure SQL, SQL, SQL Server Integration Services (SSIS)...
Cignium Technologies
SQL, Apache Airflow, SQL Server Management Studio (SSMS), Confluence, Jira...
Cignium Technologies
SQL, Azure SQL, SQL Server Management Studio (SSMS), Visual FoxPro...

Experience

  • SQL Server Management Studio (SSMS) - 13 years
  • SQL - 13 years
  • Data Modeling - 10 years
  • Software Design - 8 years
  • Software Implementation - 8 years
  • SQL Server Integration Services (SSIS) - 6 years
  • SQL Server Reporting Services (SSRS) - 5 years
  • Python - 2 years

Availability

Part-time

Preferred Environment

SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), C#, VB.NET, Data Modeling

The most amazing...

...accounting reconciliation process I've redesigned reduced its runtime from 6.5 to three hours.

Work Experience

Senior Enterprise Data Services Lead

2022 - PRESENT
Cignium Technologies
  • Ensured the delivery and SLA compliance on automated reports.
  • Coached, trained, and mentored new team members.
  • Participated in the design and the solution of company-wide initiatives.
Technologies: Azure SQL, SQL, SQL Server Integration Services (SSIS), SQL Server Management Studio (SSMS), Apache Airflow, Python 3, Jira, Bitbucket, Confluence, Databases, Data Engineering, T-SQL (Transact-SQL)

Enterprise Data Services Lead

2018 - 2022
Cignium Technologies
  • Migrated the automated reporting tool to Apache Airflow.
  • Implemented the SLA system for Aztec (an automated reporting tool).
  • Implemented the DRTV Media reporting solution.
  • Oversaw the training and onboarding of new team members.
Technologies: SQL, Apache Airflow, SQL Server Management Studio (SSMS), Confluence, Jira, Bitbucket, Databases, Data Engineering, T-SQL (Transact-SQL), Data Migration

Configuration Team Lead

2016 - 2018
Cignium Technologies
  • Designed the data extraction strategy and implemented its transition from Strata to the new CRM.
  • Developed the new automated call center reports on an inhouse-developed automated reports solution.
  • Implemented new marketing telephony campaigns.
Technologies: SQL, Azure SQL, SQL Server Management Studio (SSMS), Visual FoxPro, SQL Server 2016, SQL Server Integration Services (SSIS), Jira, Bitbucket, Confluence, Databases, Data Engineering, T-SQL (Transact-SQL), ETL, Data Migration

.NET Developer

2015 - 2016
Cignium Technologies
  • Implemented the Invoca and Google Docs data extraction pipeline.
  • Implemented an SSRS default parameters management system.
  • Migrated customer acquisition reports from Excel to SSRS.
Technologies: SQL Server 2014, SQL, SQL Server Management Studio (SSMS), SQL Server Data Tools (SSDT), C#, C#.NET, Databases, Data Engineering, T-SQL (Transact-SQL)

Process Analyst II

2013 - 2015
Empresa Editora El Comercio
  • Analyzed and developed ETL extraction packages from Google Analytics and MongoDB.
  • Reviewed and optimized ETL extraction packages for the Data Warehouse unit.
  • Created a new accounting conciliation solution. The conciliation process time was reduced by 50% (from 6:30 to three hours).
  • Directed the data conciliation between El Comercio's SIEBEL CRM, Subscribers System, and Subscribers club website for the customer's 2013 data update campaign.
  • Spearheaded improvements for the bill compensation interface between El Comercio's SAP ERP and Subscribers System.
Technologies: Business Intelligence Development Studio, SQL Server 2012, SQL Server Integration Services (SSIS), SSIS Custom Components, MongoDB, QlikView 11, SQL Server 2008 R2, SQL, SQL Server Management Studio (SSMS), IBM Informix, WinSQL, Visual Studio 2005, Visual Studio 2008, Databases, Data Engineering, T-SQL (Transact-SQL), ETL

Systems Analyst

2012 - 2013
Orbis Ventures S.A.C
  • Reviewed and designed improvements for the Subscribers system of El Comercio.
  • Built the web service interface between Ofertop's Sale system and El Comercio's SAP ERP.
  • Maintained El Comercio corporate's intranet.
Technologies: Visual Studio 2005, WinSQL, IBM Informix, SQL Server 2005, SQL, C#, C#.NET, VB.NET, Databases, Data Engineering

Systems Analyst

2012 - 2012
Perucomsultores
  • Delivered improvements for the Credit Notes module of the Subscribers system of “El Comercio”.
  • Modified the Subscribers system's interface with SIEBEL CRM.
  • Optimized the Subscribers system of “El Comercio”.
Technologies: Visual Studio 2005, WinSQL, IBM Informix, Web Services, Databases, Data Engineering

Analyst Developer

2010 - 2012
FRACTAL S.A.C
  • Analyzed and developed the Accounting, Commissions, and Business Partners interfaces to communicate the fractal system with InVitas’ AS/400 (InVita was an organization dedicated to selling life insurance).
  • Optimized the El Comercio Subscribers system, migrating web functions to a desktop application and DTSX package development for the Subscriber's website.
  • Spearheaded the FRACTAL system certification process on Microsoft platforms. Obtained credentials: Web Services and .NET Framework, Windows 2008 Server, and SQL Server.
Technologies: SQL, SQL Server 2008, SQL Server 2008 R2, SQL CLR, Business Intelligence Development Studio, WinSQL, SQL Server 2005, IBM Informix, Databases, Data Engineering, T-SQL (Transact-SQL), ETL, Data Migration

Developer

2009 - 2010
FRACTAL S.A.C
  • Analyzed and developed the Performance Management module for the FRACTAL system (HR management and payroll).
  • Implemented the FRACTAL system on ABB Peru, an organization dedicated to electric energy generation and industrial automation.
  • Optimized the Budget module for the FRACTAL system (HR management and Payroll).
  • Developed the Employee's Portal News module of the FRACTAL system (HR management and Payroll).
Technologies: SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server Profiler, SQL Server Management Studio (SSMS), C#, C#.NET, VB.NET, Databases, Data Engineering, T-SQL (Transact-SQL), ETL

Intern

2008 - 2009
FRACTAL S.A.C
  • Analyzed and developed the business analysis module for FRACTAL (HR management and payroll system).
  • Migrated the PrePago Virtual Advanced Edition" system from Visual Basic and the desktop platform to Java and the web platform.
  • Conducted maintenance tasks for the FRACTAL suite, Webforms modifications, and non-critical bug fixes.
Technologies: SQL, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Management Studio (SSMS), Visual Studio 2005, SQL Server 2005, Business Intelligence Development Studio, SQL Server Analysis Services (SSAS), Eclipse, Spring, Hibernate, Seam, Databases, Data Engineering, T-SQL (Transact-SQL), ETL

Implementation of SLA System for Aztec

A SQL-based solution that monitored automated file generation logs and raised notifications if an agreed SLA was missed. Depending on the configuration, this notification would alert development, business, and third-party teams via email.

Implementation of CRM Migration Process

A set of SQL-stored procedures and functions was leveraged by a .NET application used to migrate customers from the CRM legacy system to a new in-house built one. The stored procedures and configuration allowed us to determine how many records would be migrated at a time and contained a mechanism to prevent records from being sent multiple times. The stored procedures followed business rules and criteria for considering the records that would be migrated.

Implementation of an SSRS Default Parameters Management System

A .NET-based solution used to manage the default parameters of all the SSRS reports of the company. The application would sync the SSRS report catalog and the respective reports filters into its database. Then users could define the default values on a given report to display when it opens. This application enabled two different types of values for the report parameters "available values" and "default values."

Implementation of Interface Between FRACTAL System and AS/400

A SQL-based solution used to register new FRACTAL employees into the AS/400 system and sync the employee ID back from AS/400 to FRACTAL. Interacted with the AS/400 technician to implement a compliant solution with the company's policies.

Implementation of Facebook and Google Analytics interface for Qlikview

A .NET-based application that created a local web service that allowed Qlikview to connect to Facebook and Google Analytics and use their APIs to extract data. This was a self-generated initiative to eliminate manual tasks of going into the Google Analytics platform and pulling data for different sites; and, on the Facebook side, pulling the number of likes/fans of some pages.

Implementation of the Performance, Budget, and News Modules of the Fractal System

Developed the following .NET-based applications that served as modules for the HR software.

Performance module: Allowed the user to set up different kinds of metrics and competencies and create forms that used for a company's annual performance review process

Budget module: Allowed the user to set up different kinds of items and goals, and limits which would then be compared against a file the user would upload in the system and show a report that would display the status of each item

News module: A small CMS-type of application that would allow a user to set up news and articles to display on the employee company portal
2010 - 2014

Bachelor's Degree in Systems Engineering

Universidad Peruana de Ciencias Aplicadas (Peruvian University of Applied Sciences) - Lima, Peru

2006 - 2009

Associate's Degree in Computing and Informatics

STI Cibertec - Lima, Peru

Libraries/APIs

ODBC, Google Analytics API, Facebook API

Tools

Confluence, Jira, Bitbucket, IBM Rational Rose, Apache Airflow, SQL Server Profiler, WinSQL, Visual Studio 2008

Languages

SQL, T-SQL (Transact-SQL), C#.NET, C#, VB.NET, Java, UML, Python, Visual FoxPro, Python 3

Storage

SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Databases, SQL Server 2005, SQL Server Analysis Services (SSAS), SQL Server 2008, SQL Server 2008 R2, SQL CLR, IBM Informix, SQL Server 2012, MongoDB, SQL Server 2014, SQL Server Data Tools (SSDT), Azure SQL, SQL Server 2016, DB2/400, Dynamic SQL, SQL Server Agent

Paradigms

ETL

Frameworks

VB.NET WinForms, Spring, Hibernate, Seam

Platforms

Eclipse, QlikView 11, QlikView

Other

Data Modeling, Software Design, Software Implementation, Data Engineering, Visual Studio 2005, Business Intelligence Development Studio, Web Services, SSIS Custom Components, Data Migration

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring