Carlota Esteban
CEO, Dirección
INGENIERO INFORMÁTICO
PROGRAMACIÓN DE BASES DE DATOS
Summary:
More than 11 years as IT professional experienced in implementing end-to-end mega data warehouse and business applications solutions, SQL development, data analysis, reporting, and project management with expertise in data migration, and data integration. Experience working with data stored within multiple databases, and with QA and UAT testing. Fluent in English and Spanish.
Technical Skills:
Platforms: Microsoft Windows, Mac OS.
Databases: MS SQL Server (Any version), MS Access.
Tools: Visual Studio, DOMO, BIRST, Microsoft Office, Acrobat Reader, Dropbox, Remote Desktop.
Primary Languages: SQL, Transact-SQL (T-SQL), PowerShell.
Can Read Languages: VB.Net, C#, C++, JavaScript, Pascal, XML, HTTP.
Professional Experience:
Citrix – Feb 2020 to Jun 2020 (Project)
Data Engineer
- Giving support with the database consolidation project. Responsible for accessing data stored within multiple databases and building out the structure behind a singular database.
- Working comfortable consuming large amounts of data and reporting back on it.
- Conducting unit testing as well as User Acceptance Testing to make sure the data being pulled is accurate.
- Data visualization and reporting tools.
The Legacy Companies – Aug 2018 to Feb 2020
Full Stack Developer (Syspro System Database Analyst)
- Provide day to day support to the Syspro (ERP/Financial) and MS SQL 2016 Server database.
- Ad Hoc reporting and development as needed including Syspro and SQL Server
- Mine data and provide periodic ad-hoc reporting to accounting and operations.
- Perform the function of SQL2016 database admin, SQL backups, user security, database maintenance, etc.
- Write reports using DOMO, users can see the data live via online, print reports or export to Excel or PDF format.
- Responsible for responding to Syspro user request Essential Requirements for Syspro System Analyst
- 2 years of ERP application administration with MS SQL Server administration and development
- Developing queries for data warehouse and data migration in an environment with several Servers, VMs, Databases, and different Divisions
- Coding automatization server jobs in PowerShell.
The Responsive Auto Insurance Group – Apr 2017 to Jul 2018
SQL Developer
- Project Management in two projects, from the beginning to the launch and implementation in Production.
- Documentation of the functioning of the Stingray system.
- Reports for the executive team, as well as for the Under Written, Finance and Claims and QA departments.
- Arrangements, updates, and improvements to the system used by the company.
- Identification and correction of live errors at the production level.
- Add new features to the company’s website.
Hygea Holdings Corp. – Sep 2015 to Mar 2017
Data Analyst / SQL Developer
- Built and maintained Data Analysis, SQL scripts, indexes, and complex queries for data macro analysis and data migration.
- Performed analysis using SQL, MS Access, Excel.
- Imported, exported, and manipulated large data sets under tight deadlines.
- Automated tools and scripts to increase departmental efficiency and automate tasks.
All 4 Carrier – Jul 2015 to Jan 2017
DBA / Data Analyst / SQL Developer
- Developed and maintained reports for company analytics.
- Aided in development, and maintenance of disaster recovery plans for all data services. Implemented application database code objects, such as stored procedures and views.
- Database Transformation Services (Design, Development, Deployment, and Administration)
4 Global Corp. – Dec 2013 to Jun 2015
DBA / Data Analyst / SQL Developer
- Built and maintained SQL scripts, indexes, and complex queries for data analysis and extraction.
- Documented and maintained database system specifications, and diagrams.
- Diagnosed and addressed operational data issues.
- Identified data issues and provide recommendations for resolution to ensure performance.
Charter High School – Arts & Minds – Jun 2013 to Nov 2013 (Project)
DBA / Data Analyst / SQL Developer
- Developed SQL scripts, indexes, and complex queries.
- Developed and supported analysis solutions, data transformations, and reports.
- Manipulated data files for rapid delivery to clients or loading onto internal databases. Collaborated with project managers, and other team members to gather data for projects.
INECO – Apr 2009 to Feb 2013
Data Analyst / SQL Developer
- Wrote database scripts and SQL stored procedures, functions, and triggers.
- Participated in the development of an automated testing strategy and deliverables.
- Worked with business stakeholders, application developers, and production teams across functional units to identify business needs and discuss solution options.
Education:
- Bachelor’s Degree in Computer Science – 2009.
- Certificate of High School in Modality of Technology – 2003.
Other:
- US Citizen.
- Recommendation letters on request.