| | | 20,000+ Fresh Resumes Monthly | |
|
|
| | Related Resumes Sql Server Data Entry Denver, CO Data Science, SQL,Python, PowerBI, Tableau Boulder, CO Data Science Software Developer Denver, CO Tech Lead Data Center Longmont, CO senior big data engineer Aurora, CO Sr. Staff Data Scientist Longmont, CO Data Scientist Machine Learning Windsor, CO |
|
Click here or scroll down to respond to this candidateCandidate's Name
EMAIL AVAILABLEPHONE NUMBER AVAILABLESummaryExtensive experience in the IT industry as Software Specialist; Designer, Developer, Data Analyst and Data ModelerExperience in Sales, Accounting, Financial, Mortgage, Loan, Legal, and Pharmaceutical and Insurance methodologiesExperience in all aspects of OLTP and OLAP system design approaches; Data Analysis, profiling and gathering of requirements and specifications, reporting, and implementation of processes, with expertise in the creation and implementation of deliverablesTechnical SkillsAWS Cloud DB, Oracle 19c, 18c, 12c, 11g, 10g and 9i, PL/SQL, Oracle Designer, Oracle Data Integrator 12.2.1, Oracle Warehouse Builder, PERL, SQL 2008, SQL 2012, Informatica PowerAnalyzer 4, Informatica PowerCenter 10, Unix, Unix Shell Scripting, MongoDB, AWS Cloud, Teradata DB, Assure development for Oracle, NT Server, Win2000, Cognos PowerPlay & Impromptu Reporting Tools, VI Editor, Awk, RCS, OAS for the Web, ASP, JavaScript, HTML, DHTML, HomeSite, SQL Plus, Oracle Designer 2000, Java, Oracle PeopleSoft Financial SQL Navigator, Erwin Modeling Tool, Delphi 7, DataStage, Oracle Warehouse Builder, Oracle Model Builder, Visual Studio and Visual Basic 6.0, FrontPage Interdev, Crystal Reports, MicroStrategy Reports, Actuate, ACBS, Enterprise Crystal Reports, CodeWright, Visio, XML DeveloperEducation/Training/CertificationsCertifications:Scrum Master Accredited Certification 2016NYU Oracle 11g DBA I Training & Certification 2009Oracle 9i SQL Certification 2009Oracle Hyperion Essbase Certification 2009Training:Snowflake Pro Certification Training 2024AWS Certified Solutions Architect Associate, 2019Data Modeling and Relational Database Design using Erwin, 2016Oracle Performance Tuning with SQLTExtract Oracle OTP, 2014Oracle Enterprise Manager 10g class at Oracle University, June 2008Report Creation with Informatica PowerAnalyzer, Informatica, January 2004Using Informatica PowerAnalyzer, Informatica, January 2004Oracle Seminar Data Warehouse Development Discover/Builder, Spring 2003Business Objects 6, Report Development Training, Fall 2002Web Programming, BEI/Fairfield University, Spring 2000Oracle PL/SQL Programming Computer Based TrainingJava 2 Programming, BEI/Fairfield University, Fall 1999Actuate (OOP tool) Report Development, Fall 1999ACBS (Loan System) Administration, Fall 1999Oracle - Advanced PL/SQL and SQL Development, Oracle Corporation, June 1998Oracle - Implementing the Oracle Database, BEI/Fairfield University, Fall 1998Advanced Visual Basic Development, BEI/Fairfield University, Summer 1998Cognos Impromptu Administration, Cognos Corporation, Spring 1998Cognos PowerPlay Administration, Cognos Corporation, Spring 1998Cognos Impromptu Report Development, Cognos Corporation, Spring 1998Bachelors degree in Business Banking, University of Bridgeport, CT 1992Professional ExperienceEmpower Retirement, Englewood CO February 2019 PresentSr. Data Integration Engineer & Performance Tuning SpecialistResponsible for the design, data mapping, data analysis, development and tuning of Oracle 19c Data Views and XML Statements for the Data Lake.Convert Informatica PC into IICS and PC into ODI in an AWS environmentResponsible for the design of Oracle Database Objects & PL/SQL code in a cloud environmentResponsible for data migration to Salesforce and PeopleSoft Financials via PeopleCode scriiptsResponsible for Physical and Logical data modeling for the new data designSr. ETL Data Warehouse Developer and performance tuningResponsible for the migration of Informatica AWS Workflows for the Teradata DW using Oracle Data Integration (ODI) and Oracle Data Warehouse systemResponsible for Unit and Performance testing, Jenkins Git and Bamboo code migrations, and QA SupportRaymond James Financial, Centennial, CO February 2018 February 2019Sr. Data Engineer Data Performance TunerResponsible for the design, data modeling, data mapping, data analysis, development and tuning of Oracle 12c, Oracle Data Integrator (ODI) 12.2 for an ELT Financial Trading Data Warehouse and a Company-wide Data Store, in an Agile-Oracle Cloud environment with many Compute InstancesResponsible for the development and testing of Linux & Perl scripts to validate, modify and combine data filesResponsible for tuning and maintenance of inter-departmental data structures in and Integrated Oracle Cloud environmentResponsible for data modeling utilizing Erwin and for the reverse Engineering of ODI packages into Informatica mappingsBank of America, New York, NY September 2014 December 2018Sr. Data Warehouse Programmer Analyst & Data ModelerResponsible for the design, data modeling, data mapping, data analysis, development and tuning of Oracle, Informatica, MongoDB and SQL Server objects for a Security and Background Screening System, utilizing Oracle 11g/12c, SQL Server 2012, MongoDB 3.0, Subversion, Unix, Rally with Agile Methodology.Responsible for the data analysis of multiple database (Oracle, SQL Server and MongoDB) systemsResponsible for the development and mapping of MongoDB classes, XSDs, JSON, and the database data type conversions.Responsible for the conversion of MS ISSIS integration packages to PL/SQL procedures and Perl tasks.Responsible for the design, development, performance tuning and troubleshooting of Informatica mappings and lookups and for the analysis of Informatica MDM metadataResponsible for the data modeling utilizing Erwin and analysis of data mart and the creation of reports utilizing MicroStrategy 10.9.Credit Suisse, New York, NY April 2009 October 2014Sr. Oracle Data Warehouse Architect LeadDB Upgrades and Rebuilds: Responsible for the design, development, tuning and troubleshooting of PL/SQL objects and procedures for the Corporate Treasury and Financial System (CTS) CDW data warehouse; Designed and Developed data mart modules, system objects, tables-paces, partitions, materialized views; Responsible for version control utilizing Tortoise SVN. Responsible for supervising DB releases to Production.Lead Oracle Developer and Batch/Informatica Developer: Responsible for the preparation, monitoring and troubleshooting of the batch process; Responsible for the development of File Watcher, Staging and Presentation jobs for the Corporate Treasury System (CTS) CDW data warehouse; Responsible for the design and development of PL/SQL and xml scripts for the creation of batch processes. Responsible for setting up the environment for the batch process; setting connection strings in shell scripts, development of Informatica load jobs, validating Informatica connections, setting up the Oracle database partitions and space management; Responsible for script sourcing utilizing Tortoise SubversionResponsible for maintaining Coding and Naming Standards and Deployments to ProductionResponsible for all UNIX an Perl coding for several batches as the lead Unix developerResponsible for Informatica 9.6 Administration design and setupResponsible for the development of Mappings & Workflows for data loadingGE Capital Treasury, Stamford, CT February 2008 February 2009Oracle DBA Monitoring and TuningHP Archiving Project PL/SQL DeveloperMonitoring: Responsible for the design, tuning and development of an enterprise financial Monitoring system utilizing Oracle Enterprise Manager Grid Control 10g and PL/SQLDesigned and developed systems and services for Bancware, Wall Street Systems (WSS) DDS and ICL applications, Webcash, Panorama and the GE Treasury CMS data warehouse. Created user defined metrics, setup metric thresholds and notifications.Tuned CMS data warehouse ETL scripts overloaded with new financial GE Money transaction dataDesigned and developed Performance Dashboards for applications utilizing ADDM (diagnostics), Access Advisor and SQL Advisor.Designed and supervised the installation of Oracle Grid Control, agents and third-party plug-ins and connectors for SQL Server and Oracle databases, NetApp storage, EMC Clariion storage and 3Par storage software, Java applications (Apache and third-party), SQL Server 2003 and 2005 applications, .NET and IIS applications and web servers.Analyzed, setup and trained developers on the AD4J Console - an Oracle Java Diagnostics toolHP Archiving: Responsible for design of ETL process and PL/SQL packages to fulfill user needed business requirements. HP Archiving is a searching tool that allows business users to search for data for auditing purposes.VS & Software Consulting Inc., New York, NY June 2004 December 2007Senior Oracle DeveloperResponsible for the design, modeling, development, performance tuning and implementation of programs utilizing Oracle 9i and 10g and Oracle PL/SQLDeveloped prototype code and reports utilizing Oracle Warehouse Builder and designed ERWIN data modelsReverse engineer current Erwin models and subject areas.Responsible for daily PVCS Administration, redesign security and database projects, installed and migrated to PVCS Version Manager 8x.Responsible for the creation and implementation of release methodologies and standardsResponsible for developing and implementing Oracle Programming Standards and naming conventionsClient: ASCAP Developer DBAResponsible for trouble-shooting and performance tuning PL/SQL programsResponsible for the design and creation of ETL packages utilizing DataStage for Crystal ReportsResponsible as developer DBA trainee for the promotion of Oracle releases on a daily basisResponsible for the creation and modification of Tech Specs and documentationData Analyst .Net Stamford, CT OfficeResponsible for the design, modeling, development, performance tuning and implementation of programs utilizing SQL Server, Cognos Decision Stream and Embarcadero ERStudioRedesign and reverse engineer current projects written in SQL DTS and Cognos Decision Stream, MS .NET and ASP .NET, C#, XML, and JavaAnalyze and design database models. Interview users and develop Business Specifications and Requirements. Setup Standards and Naming ConventionsDocument Business Rules and Datawarehouse processes.Prudential Financial, Shelton CT March 2003 June 2004ETL DeveloperResponsible for the design, development and implementation of programs for a migration system utilizing shell scripting, SQL and PL/SQL.Responsible for the creation requirements and specificationsCreated DDL scripts and deploy scripts into production utilizing Oracle DesignerWorked with several Mutual Funds and Fixed Asset applications developed in JavaDeveloped and maintain Oracle Warehouse Builder processesDeveloped entity and business models utilizing Oracle DesignerUnited Nations, New York, NY January 2002 December 2002Oracle PL/SQL Data Warehouse DeveloperResponsible for the migration, design and development of a Data Warehouse System, utilizing Perl and PL/SQLResponsible for the conversion of a Sybase IQSL reporting system into OracleDesigned Perl/PLSQL Modules for Extract, Load, and Transformation processesInstalled and set up of software in developer machines.Designed development processDeveloped package infrastructure and standards for developersDeveloped packages for batch job logging and alert scriptsDesigned and developed Cognos OLAP Cubes, PowerCubes, Impromptu Catalogs, and Cognos Impromptu reports for the Programme and field offices.Designed catalogs, templates, categories, dimensions, and measuresDesigned and developed Oracle OLAP cubes and tables to facilitate Cognos and Crystal Reports development.Responsible for the modeling of new user requirementsResponsible for the administration of the server and the overall system configuration as the only Oracle/Perl Programmer/DBA in the groupVoyant.com, New York, NY June 2000 December 2001Oracle Database Developer (Startup Co, closed 2001)Responsible for design, modeling, development and implementation of PL/SQL packages and database performance tuning for a web based application system, as the only Oracle and ERWIN programmer in house.Developed programs in Awk, Perl and Shell scriptsResponsible for the design and development of a data warehouse utilizing PL/SQL and CognosResponsible for the installation and data retrieval for the Data Warehouse and reporting toolsResponsible for the extract, transformation and load of data from other systemsResponsible for the designing and initial development of product and customer reports in OLAP Enterprise Crystal Reports and Cognos Impromptu, Cubes, Powercubes reports.Developed over 50 Complex Purchasing and Sales reports in PowerPlay and ImpromptuDeveloped reports for all aspects of the business (Sales, Marketing, Order Processing, Inventory and Financials) as the only Oracle/Cognos developer in housePriceline, Stamford, CT February 1999 June 2000Oracle PL/SQL Developer (Company IPO)Responsible for all aspects of system development: analysis, modeling, data conversion, normalization, validation and population of Promotions & Referrals/Affiliates modules of a web based Airline Ticketing system. These modules perform promotion & referral/affiliates tracking and calculations.Analyzed and designed database models, script generation to create oracle objects utilizing Erwin. Converted data from web servers into oracle serversDeveloped PL/SQL packages, procedures, functions and triggersPerformed production support and performance tuningResponsible for Analysis, Modeling, Development, and Implementation web based applications on OAS (Oracle Web Application Server) and Microsoft IIS ServersDeveloped dynamic front and back end programs in PL/SQL, HTML and JavaScript to generate Web pagesDeveloped ASP based pages utilizing ASP, HTML and JavaScriptDeveloped VB 6.0 Applications for in-house administrative purposes and DHTML on local serversBoehringer Ingelheim Pharmaceuticals, Inc., Ridgefield, CT January 1997 January 1998Data Warehouse Developer (Co-op Work)Responsible for the analysis and conversion of Roxanes (one of three sister companies) AS400 data for reporting purposesResponsibilities included analysis of the data warehouse model and data integrity, development of new user specifications and requirementsConversion and loading of flat files from mainframe, AS400 and other PC applications utilizing Visual Basic 5.0 and SQL LoaderCreation of Oracle tables, views and indexes, the development of PL/SQL update procedures, the creation and tuning of reports utilizing SQL PlusCreation and modeling of Cognos Impromptu catalogs and reportsCreated over 50 advanced reports utilizing Cognos ImpromptuCreated OLAP cubes utilizing PowerPlay (a multidimensional model) for the sales and product metadataDownload and conversion of data from the server and PCs to Access, VB, VBA Excel and other user tools and applicationsDevelopment of user interfaces utilizing VB classesReport DevelopingResponsible for the design, analysis, and development of 42 regional and national reports, for an Expert Advisor Helpdesk system utilizing Crystal Reports 6.0 and Visual Basic 5.0.Oxford Health Plans, Inc., Trumbull, CT November 1996 - December 1997Data Modeling/Oracle Developer (Co-op Work)Worked as a team member redesigning some Oracle modules of their complex Health Care application (Pulse) using Designer 2000Analyzed Pulse sub-applications and build ER diagrams along with data information in Designer 2000.Developed Oracle SQL code and shell scripts to analyze table design and business rulesUsed Oracle CASE tools to implement new applicationsAnalyzed several modeling methodologiesModeled test cases for Pulse applicationsHyperion Software, Stamford, CT May 1995 - September 1996Data Analyst/QA Analyst (Co-op Work)ConsultantDesigned application, regression, and performance test cases for an accounting/financial applicationAnalyzed and trouble shot Visual Basic and C code utilizing CodeWright.Trouble shot security and profiles.Verified backend Sybase and Oracle databases utilizing DBArtisan and AccessCorrected base data utilizing SQL Commander to drop triggers and indexes and modify database.Designed automated test cases in QAPartnerCartier, Inc., Shelton, CT August 1993 - April 1995System Analyst/Programmer (Permanent)Developed complex AS/400 queriesDesigned and analyzed a wholesale systemDesigned test data to trouble shoot RPG programs and design training scenariosTrained and supported application end usersMaintain system security and integrityDeveloped a Paradox application for the MIS DepartmentDeveloped automated templates and macros in ExcelChase Manhattan Bank, Bridgeport, CT November 1990 - July 1993Software Developer (Co-op Work)Designed, developed and implemented a FDIC Loan Performance Tracking System and a Vendor Tracking System application utilizing FoxPro 2.5a.Worked closely with loan officers to develop two multi-user applications on a Novell environmentPerformed data conversion, backup and trainingResponsible for maintaining and implementing several accounting applications on a Wang system Performed weekly system backups utilizing FastBack, data conversions, and reports. |
