Oscar is available for hire
Hire OscarOscar 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
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
Experience
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
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
Education
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
Skills
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