Jesse Corral
Senior Developer at Kroll Government Solutions- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
English Native or bilingual proficiency
-
Spanish Native or bilingual proficiency
Topline Score
Bio
Experience
-
Kroll Government Solutions
-
Management Consulting
-
1 - 100 Employee
-
Senior Developer
-
Oct 2012 - Present
Senior Developer using Oracle PL/SQL and Python for development of Unclaimed Property and Unemployment Insurance auditing applications. Senior Developer using Oracle PL/SQL and Python for development of Unclaimed Property and Unemployment Insurance auditing applications.
-
-
-
NT Affiliated
-
IT Services and IT Consulting
-
Independent contractor
-
Sep 2011 - Oct 2012
Oracle PL/SQL development and mid-level Oracle DBA work for Unclaimed Property applications (sub-contracted through NT Affiliated). Oracle PL/SQL development and mid-level Oracle DBA work for Unclaimed Property applications (sub-contracted through NT Affiliated).
-
-
-
Technisource
-
United States
-
Information Technology & Services
-
400 - 500 Employee
-
Data Analyst/Sr. Analyst
-
Nov 2010 - Jun 2011
Data AnalystClient:Warner Bros.Performed analysis of Warner Home Video title distribution data using complex Teradata SQL queries and refactoring of SQL views to help with modularization, re-usability and code maintenance.Sr. AnalystClient: Warner Bros.Designed and developed a VBA in Excel application to forecast the appropriate share of Warner Home Video DVD and Blue-Ray title distribution per retail store using past Point of Sale share data for approximately 4000 stores. Used Holt-Winters forecasting algorithm. Application built with User Forms with options to exclude certain past titles from calculations, options to use a seasonality component, and options to find a best fit for Holt-Winters smoothing constants or have them fixed. Used full object-oriented capabilities of VBA.
-
-
-
-
Data Warehouse Developer
-
Feb 2007 - Dec 2009
Responsible for analysis, troubleshooting and maintenance of Usage and Subscription Data Warehouse using Oracle 10g PL/SQL stored procedures on Unix platform.Developed Marketing Data Mart, using Data Integrator ETL data flows and supporting Oracle 10g PL/SQL stored procedures.Performed some Oracle 10g database administration, including data migration tasks using Oracle Export/Import.Brought two of my managers hired after me up to speed on the Data Warehouse and provided training in Data Integrator to one of them.
-
-
-
Asolva, Inc.
-
United States
-
IT Services and IT Consulting
-
1 - 100 Employee
-
Business Intelligence Lead
-
Sep 2008 - Dec 2008
Re-architected Clinical Data Model used for health care related software applications, including adding ability to track change history.Designed and developed stored procedures in MS SQL Server Transact SQL for loading and managing workload allocation of data load process into Clinical Operational Data Store. Created and enhanced ad hoc Clinical Data Web reports using T-SQL and ASP. Re-architected Clinical Data Model used for health care related software applications, including adding ability to track change history.Designed and developed stored procedures in MS SQL Server Transact SQL for loading and managing workload allocation of data load process into Clinical Operational Data Store. Created and enhanced ad hoc Clinical Data Web reports using T-SQL and ASP.
-
-
-
ACC Capital Holdings
-
Financial Services
-
100 - 200 Employee
-
Programmer/Analyst II
-
Oct 2004 - Feb 2007
Used Informatica to perform ETL, and in addition, designed and coded supporting Oracle 10g PL/SQL on Unix and MS Transact SQL stored procedures and performed some Oracle database administration for Operational Data Store. Mentored and trained junior level Informatica developers.Also performed some Oracle database administration. Made use of Oracle Export/Import for data migration tasks. Used Informatica to perform ETL, and in addition, designed and coded supporting Oracle 10g PL/SQL on Unix and MS Transact SQL stored procedures and performed some Oracle database administration for Operational Data Store. Mentored and trained junior level Informatica developers.Also performed some Oracle database administration. Made use of Oracle Export/Import for data migration tasks.
-
-
-
iBASEt
-
United States
-
1 - 100 Employee
-
Software Engineer
-
Jan 2004 - Jul 2004
Oracle PL/SQL development. Oracle PL/SQL development.
-
-
-
RemoteNet Corporation
-
Software Development
-
1 - 100 Employee
-
Developer/Oracle DBA
-
Dec 2000 - Aug 2003
Oracle PL/SQL, MS SQL Server T-SQL, C#.Net and Java development. Mid-level Oracle DBA. Oracle PL/SQL, MS SQL Server T-SQL, C#.Net and Java development. Mid-level Oracle DBA.
-
-
Education
-
University of California, Los Angeles
BS, Applied Mathematics w/Specialization in Computing