Oscar Ramos Penny
Verified Expert in Engineering
Database and Software Developer
Santiago de Surco, Peru
Toptal member since February 28, 2023
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
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
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
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.
Enterprise Data Services Lead
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.
Configuration Team Lead
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.
.NET Developer
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.
Process Analyst II
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.
Systems Analyst
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.
Systems Analyst
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”.
Analyst Developer
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.
Developer
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).
Intern
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.
Experience
Implementation of SLA System for Aztec
Implementation of CRM Migration Process
Implementation of an SSRS Default Parameters Management System
Implementation of Interface Between FRACTAL System and AS/400
Implementation of Facebook and Google Analytics interface for Qlikview
Implementation of the Performance, Budget, and News Modules of the Fractal System
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
Bachelor's Degree in Systems Engineering
Universidad Peruana de Ciencias Aplicadas (Peruvian University of Applied Sciences) - Lima, Peru
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
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring