Raymond C. Roque

***** *********

Carson, CA ****6

***/***-****

ac5rid@r.postjobfree.com

SKILLS

Database Platforms and spreadsheet programs

Microsoft SQL Server 2012, 2008 R2, 2005, 2000, 7.0 and 6.5. Oracle, MySQL, MariaDB, PostgreSQL and DB2. MS Access, Lotus 123, Microsoft Excel, MS Sharepoint server. Sybase Adaptive server 6.X and 7.X. Informix 5.X.

Amazon Web Services Redshift, Aurora

Enterprise Application:

PowerCerv Distribution and Financial, Peoplesoft - JDE Edwards Oneworld, ADP Etime, Manhattan WMS Scales, TLS, ILS, Softpoint, Truckmate, MAS 90, HealthConnect Epic Chronicles, Clarity, Cogito/Caboodle 15/16.

Microsoft Great Plains, Siemens CPSEE, Sage and Cybersource Payment Gateways, SugarCRM and Drupal Workflow, Kronos Workforce Central, Aderant Expert Billing, Expert Image, Chrome River

Programming, scripting and Web Languages:

Microsoft and Sybase SQL, Pascal, C, XML, SOAP, WSDL, CSS, XHTML, Snobol, HTML, .NET C#, C++, VB and ASP.net, Perl, Java. PHP, Python, Smarty, Ajax, Flash. Zend, Symfony and CakePHP, Agile MVC, Drupal CMS. Visual Studio 2010, Team Foundation Server (TFS) 2010. Open Source CRM Tools, Visual Studio Online.

Report writing and Datawarehousing tools:

Crystal reports, Cognos Transformer and Power Play, Sybase Power Designer data modeler, Embarcadero data modeler and Rapid SQL. MS Integration Services SSIS DTS, Analysis SSAS, Reporting Services SSRS .

Pentaho Data Integration and Analytics, Python CSV toolkit, SQLAlchemy.

Hadoop, Hive, Spark Notebook, Apache Jupyter, Ipython Notebook

Network and Client Operating Systems:

Novell Intranetware, Unix Solaris, Appletalk, MS Windows Server 2003, 2000, 98, 95, Windows NT, Sequent Dynix/Ptx, Sun Openwindows 3.0, Citrix Terminal Server, Sunview, SCO Unix, HP AUX, Ubuntu, Lubuntu, CentOS. VirtualBox, VMWare. Amazon Web Services EC2, S3, EMR, Route 53

WORK EXPERIENCE

KAISER PERMANENTE

HealthConnect Epic Cogito/Caboodle Datawarehouse Support

(Jan 2018 to Apr 2018)

Member of Epic Cogito/Caboodle Core Datawarehouse Team at Kaiser Permanente

Supported Caboodle Implementation in Colorado and Northern California

Help support Daily ETL and Error logs from Caboodle Console for Colorado.

Worked with Caboole DBAs in consulting with Epic Support for Clarity ETL issues.

Participated in Meetings with Epic Clarity Oracle support.

Researched on Epic Chronicles, Clarity and Caboodle data flow.

Associated with various groups and meetings involving TeraData to Exadata Clarity Migration.

Started Proof of Concept Development of Enterprise Data Warehouse for Epic Caboodle.

Joined in Data Modeling, Analysis and Consolidation of Regional data for Patient, Encounter and Provider information.

Collaborated on preliminary data modeling, data mapping and Analyst of Pharmacy and Non-Epic information to Caboodle.

Designed various SSIS Packages for Custom imports from Clarity to Epic Caboodle

Worked on IBM Rational Tool for Document management such as Business and User Functionality and Use Cases.

Performed Business Specification imports from various data sources to IBM Rational/Jazz.

Attended various meeting with PDW and other Datawarehouse Teams in Kaiser

Coordinated with Caboodle Technical Team Leads and Developers for various projects and daily support efforts.

Trained in Caboodle Installation and Upgrade

Attended Skype meetings of Business Intelligence Tool SlicerDicer.

PUBLIC STORAGE/WORKSTATE

Data Analyst Contractor

(Aug 2017 to Oct 2017)

Met with Workstate Ohio Remote development Team for the preliminary requirements of the new Datawarehouse

Worked with Data Architect in Glendale, CA to confer with Application Business Rules and various components of the Projects.

Worked with Data Modeler to provide SQL Analysis on Table relations and group subject matters based on Fact and Dimension modeling.

Provided counts on hundreds of millions of row on Trasactional Tables for data analysis.

Worked with other Datawarehouse Team support for Business rule requirements, JD Edwards data extract processes and deep dive conferences on various aggregated tables.

Provided Data mapping documents from Erwin Data Models to the ETL group.

Worked with various Sprint groups in various Software Life Cycle development processes.

Mentored junior level developers in Datawarehouse Dimensional Modeling, sql scripts, system tables, etc.

Worked on Visual Studio Online Project Management to start user stories, active sprints, setting work alloted periods, status updates and provided Wiki information.

Collaborated with Quality Assurance Team lead on Defect Management, Error detection and various QA processes to determine problem areas.

HALLMARK LABS/GLOBANT

Mysql Contractor

(May 2017 to June 2017)

Documented ETL process from OLTP to staging in Amazon Web Services EC2 EBC and finally to Redshift.

Tracked data flow of compressed file and into 4 way split PSV.gz prior to upload into S3 data Bit Buckets.

Monitored cron jobs for OLTP backups and OLAP restore of various Production host, staging and development servers.

Traced process flow of s3cmd commands to S3 and copy commands of specific database tables to Redshift.

Researched on binlog and Mysql Replication Master-Master, Master-Slave

Configured Putty SSH private and public keys for connecting to Amazon Web Services.

Researched on Mysql Slow running queries and log monitoring.

Researched on Backup and Restore process of numerous Amazon Web Hosted Servers.

Met with the Business Intelligence group and researched on Talend staging tables.

NOSSAMAN LLP

Database Administrator

(December 2016 to Feb 2017)

Supported Aderant Expert Billing Legal Accounting.

Redesigned Import process for 'Client, Matter and Narrative' data into Accounting Application.

Worked with consultants in importing Disbursement data through 'Generic Importer'.

Designed SSIS packages from various clients and vendor into Aderant.

Worked with Team Lead in Database migration for 'Intap' and 'Wallbuilder' Applications.

Tested Expenses and Invoice Imaging Imports using 'Expert Image'.

Coordinated 'Chrome River Accounting' Downloads for Aderant Integration.

Configured VMWare Virtual Servers for SQL Integration Development Environments.

Helped Sharepoint Admin in maintaining Logs, Crawlspace, and Search Databases for inhouse Intranet.

Discussed Legal 'Time Billing' and Accounting Integration with various groups.

Configured and supported ‘Always On Availability Groups and Databases’.

Researched on Amazon Web Services Elastic Computer (EC2), S3 storage and Elastic Map Reduce (EMR).

Researched on ETL applications with Cloud connectivity such as Talend, CloverETL, SnapLogic

and Amazon Data Pipeline.

Researched on Filezilla, Linux secured copy and Amazon REST API for transferring information to Amazon S3

Research on Microsoft Azure and Azure Data Pipeline.

ROBERT HALF SPS CONSULTANT

Towne Allpoints Direct Marketing and Fulfillment

Mysql

(September 2016)

Worked with SPS Team lead in Mysql Database optimization for the Election Voters Slate Marketing Campaign.

Looked at various processes and ways to improve the speed of data imports, exports, aggregation for candidate and voter guides.

Configured numerous guest OS installations on Virtual Environments.

Configured Linux, Apache, Mysql, Php (LAMP) stack on VirtualBox and VMPlayer.

Tested various Linux distros, Ubuntu, Lubuntu and Opensource RHEL CENTos.

Tested various Mysql clients: SQLyog, MysqlWorkbench, HeidiSQL.

Tested various Windows to Linux shells such as OpenSSH and Putty.

Configured installation of Pentaho Data Integration for ETL processes.

Assisted in CSV file data imports to Mysql development environment

Tested python, csvtoolkit, SQLAlchemy and other ETL options.

ROBERT HALF SPS CONSULTANT

PERFORMANCE TEAM

MS SQL Server

(July and August 2016)

Worked with DBAs in supporting Manhattan Warehouse Management System WMS: SCALE, ILS, TLS

Helped DBAs in migrating DB2 tables for Truckmate application into MS SQL Server

for daily refreshes.

Worked with Business Subject Matter Experts in creating and modifying Softpoint (SoftTheon)

Trucking application reports.

Worked on numerous Reports for Fuel Surcharges, LineHaul, Backhaul, Trip Miles, DriverPay,

Start and End zones, Trip LEGs and various other Logistical and Inventory reports.

Processed and automated Access Database VB macro.

These includes Pro Rating computation and researching some Tariff processes.

Worked with Sharepoint Administrator in creating and modifying SSRS reports.

Worked with Electronic Data Interchange (EDI) specialists on data and reporting requests.

Worked with Report Writers in modifying, creating and accommodating numerous daily report

requests in Crystal Enterprise and Sharepoint SSRS.

Started looking at Shipwire Oracle Databases.

Attended regular Group meetings and conference calls on Status updates and proposed

Sharepoint redesign for Workflow Management and Request Tracking.

3M / CERADYNE

MS SQL Server/Mysql Administrator

(Feb 2015 to June 2016)

Managed and Tuned manufacturing databases to acceptable levels.

Configured Development and Staging Database Environments.

Setup tempdb spanning with multi file size monitoring and shrinking for various environments.

Supported Sharepoint Document Management Environments, fixing blob storage issues.

Supported Kronos Time Keeping Administrator in managing and maintaining various database environments such

as month-end-tasks, Java version updates, Application Testing and migration projects.

Wrote Powershell commands to monitor various servers

Worked with Developers in troubleshooting problems with Legacy Application with MS SQL Backend

Implemented Transaction Level Isolation on Database to prevent Application from having deadlock issues.

Tested SQL Server Extended events in 2008 and 2012 environments for Performance Tuning.

Worked with Network Administrators in recovering Mysql Databases Instances

Performed projects for HRIS to reverse engineer Mysql Applications.

Used Toad Data Modeling tool to reinforce business rule and data searches for certain projects

Trained I.T. staff on Database Administration and Development best practices.

Coordinated with .Net developers for Application Enhancements and Backend Database interaction.

Managed SQL account migration projects for Ceradyne as defined by 3M corporate.

Configured Master Slave and Active Passive Replication on development servers.

Configured Mysql multi node Cluster enviroments.

Scanned Logs for Mysql Slow Running Queries.

Installed and configured Docker for Microservices and various controlled development environments.

Tested Python TkInter functions, SQLAlchemy, cvs and json files to and from Mysql.

SOUTHERN CALIFORNIA EDISON

Sybase to MS SQL Server Migration

(April 2014 to Feb 2015)

Migrated various Sybase Databases into MS SQL Server Development Environments as part of the Decommission process

Researched databases with various Developers and support personnel for numerous applications designed more than 15 years back.

Worked with various SCE clients to convert ETL processes and improve data validation and quality issues.

Rewrote Sybase Databases into MS SQL Server syntax which includes data type migration/conversions, triggers, auditing tables,stored procedures, supplemental tables for recompiling/migrating objects and completing staging table routines

Created SSIS packages in SQL Server 2008 R2 and 2012 environments

Created SSIS Transformations and validation employing multiple passes to staging tables for data quality.

Worked on projects with Senior Sybase DBA in reverse engineering Databases and Applications via Embarcadero DBArtisan/Erwin Data Modeler

Worked with Data Architect in researching Legacy Applications and Support Engineers.

Teamed with Unix AIX Engineers and SQL Server Virtual Server Engineers in preparing Sybase to MS SQL Server test environments.

Collaborated with Capacity Planning Team members to research various processes.

Attended meetings with various members in the Oracle, SQL Server, DB2, Sybase and Management groups for projects due dates

Prepared Server/Database Disk Space and Resource estimates and requirements for management.

Ran Hive SQL on Hadoop HDFS data for Aggregation.

Explored Spark Resilient Distributed DataSets

Explored Dataframes in Spark, Python Pandas and Math R.

Imported 27 million rows into Dataframe for Analytics.

Converted/RegisteredTempTable from Dataframes into Hive Tables

Applied Spark SQL Queries on Hive Tables

Tested Spark Notebook, Apache Jupyter, and Ipython Notebook environments for Data Visualization.

BANK OF AMERICA

Database Developer, Loan Servicing Group

(November 2013 through Jan 2014)

Worked with various Developers on Batch upload script prior to CRDE implementation, with logic on Home Affordable Modification Program, Non HAMP and mailers.

Participated in WebEx daily group meetings with various teams for Database Datamodel training on Post Decision Application implementation

Supported 'Do not call' databases.

Designed Production Destination table for 'Escalated Decision' loans.

Trained under the 'Loan Service Group' to flow daily 'Cancel Loan Action' and 'Rules Override' accounts.

Created SSIS package to import consolidated Daily Decisioned 'Pending Review' loans.

Implemented and helped other team members apply Data quality processes on SSIS package for flowed data that does conform to specification.

Coordinated with various design groups for conversion process and successful uploads.

Completed Web Training on various Bank Mandated courses pertaining to Security, Protection, Disaster Recovery, Customer Relation, Home Affordable Loan Program and Loan Underwriting process

DNTG

Dot Net Database Developer

LAX (August and Sept 2013)

Communication Server Programmer using Visual Studio 2012 C# .Net

Supported main client Ria Financial services.

Worked on project coordinating payment information reports on Money Transfer to South American banks and Payment/Receiving Agents.

Tested Web Services Payment Transaction provider on development environmentProgrammed Web Parts on Sharepoint 2005 Application Server

Revised automated tasks to utilized new functionality/methods.

Coordinated with Department head on code reviews and Source Code Management utilizing SVN.

Worked with other developers and Project Managers on Tasks status updates.

Used C# base class and inherited classes to design programs that run automated task for client reports, file exports and uploads.

Developed tasks and Sales reports that interact with automated Communication Server for secured ftp and emailed reportsSupported Automated Server on Encryption and Secured Connectivity

Los Angeles Unified School District (LAUSD) (Jan 2013)

Worked as Reporting Services Developer for the Student Information System. Collaborated with various teams on Data Model Design. Attended SCRUM sprint meetings on various data migration and reporting requirements. Designed stored procedures on SQL Server 2012, and SSRS reports on Team Foundation 2010.

IPOLS Rich Media Advertising (Dec 2012 to March 2013)

Designed a migration plan from Oracle to MySQL Database. Used various Data Modeling Tools for reverse engineering and new project designs. Used Pentaho Data Integration to clean and migrate data. Evaluated Pentaho Reporting. Collaborated with various team projects on Cold Fusion, MS SQL Server Database Designs, PHP, Drupal. Collaborated with Development team on CRM projects. Started Workflow development on Business Processes.

Mount St. Marys College (Dec 2012)

Worked with the Strategic Planning Department as Database Developer to assess their environment and advised on improvements. Evaluated the IBM Datatel to MS SQL Server 2008 Data mappings and requirements. Evaluated VEERA Data Integration.

Cornerstone on Demand (Sept 2012)

Worked on Global Support Team as Database Business Intelligence, ETL

and Team Found Server Developer

Dot Net Database and Business Intelligence Developer

SD&A Teleservices Los Angeles Call Center

LAX (November 2011 - Aug 2012)

Supported Call Center Campaign Configuration.

Wrote numerous reports for campaign status, averages, threads, Gift Pledge, Billing and End-Of-Campaign Summary Report

Supported Automated reporting databases for daily caller reports

Supported 'Do not call' databases.

Programmed Web Parts on Sharepoint 2005 Application Server

Created Sharepoint Intranet WebSites for Environmental and Polical Campaigns

Worked with other Developers and Contractors on .Net projects

Configured Payment Gateways to 'Sage' and 'Cybersource'.

Worked on Payment Credit Card (PCI) Compliance Projects

Supported Automated Server on Encryption and Secured Connectivity

Contracted with Various Companies (June 2011 to October 2011)

MS Integratrack (Simple Mobile)

Business Intelligence Support Mobile Phone Caller Usage Statistics Database

Lender Processing Services

Real Estate Research Database Support

One Stop Internet

Supply Chain EDI Developer

Participated in Scrum meeting and Agile Development processes

SQL DBA and Datawarehouse Developer

Creative Channel Services

Fox Hills, CA (April 2010 – May 2011)

Designed data models, physical schemas for database entities.

Used SSIS packages for data integration; Implemented indexing to optimize transactional and reporting performance.

Created SQL scripts for baseline, test data seeding, pre- and post- deployment SQL scripts for database roll outs and automated DB unit tests for stored procedures and functions.

Produced technical design documents for the schema and stored procedure specifications.

Wrote stored procedures, ad hoc SQL queries, views, and triggers. Optimize existing schemas through normalization and denormalization techniques.

Optimized existing stored procedures by refactoring T-SQL code.

Reviewed SQL code generated by application developers and auto-generated by middle-tier OR frameworks.

Troubleshot production, real-time performance and concurrency issues.

Participated in code walk-throughs as needed to ensure quality.

Delivered software on time and to specification, with minimal supervision

SQL DBA/Datawarehouse Developer

Sega Entertainment/Gameworks

Glendale, CA (Jan 2009 - December2009)

Worked with Upper Management, Business Development, and Information Technology Infrastructure Departments on Project Planning.

Gather requirements for projects, design new tables or column additions and stored procedures.

Document meta data, business rules and changes to data model.

Create scripts and stored procedures to repeated maintenance tasks and application revisions.

Maintained Integration Services and DTS Packages for Data warehouse Extracts and remote site additions, and data cleansing.

Implemented Transformations remapping, staging table validation and data quality processes prior to destination table inserts.

Tune database on job runs and performance issues.

Reviewed data import process into Microsoft Great Plains Accounting application via C# as part of month end closing process.

Researched Reporting Server data export to excel or PDF format via C#

Supported OLAP cubes and reviewed MDX queries

Develop software changes and test on development environments prior to production application.

Monitor server resource requirements by measuring table and indexes sizes ever 6 months

Lead projects life cycle, involved user feedback in product design and agile methodology

Gave status reports to projects members and adhere development time to project schedules

Establishes database standards, and procedures that will optimize database architectures

Gathered requirements, designed data extracts, manipulation and delivered data to users via reporting services

Responsible for developing, implementing, and maintaining data warehouse containing corporate performance and operational information

Systems Analyst/Database Developer

NYK Logistics.

Torrance, CA (Dec 2005 - April 2008)

Supported the PUMA Manhattan Warehouse Management Systems database 24x7 complimenting the Operations Analyst on projects and DTS extracts and Archiving process.

Assisted the team in maintaining the 'TARGET' Trans Load System CrossDocking Database

Supported PUMA E commerce Department with .Net developers in maintaining Web Application.

Provided support on the WHERENET Yard Management Truck and Trailer Parking application

Maintained Warehouse Problem Management application written in C# Asp.Net

Worked with development team for a C# Asp.Net application to display Logistic information of products (picked, packed and shipped) via web page and large LCD screen.

Tuned the Electronic Data Interchange Gentran database disk space performance

Attended group meetings on Gentran EDI Data Quality issues, metrics and various tasks to improve data cleansing.

Applied Software Development Life Cycle (SDLC) processes on projects and tasks

Performed numerous Business Intelligence (BI) processes for various departmental requirements

Configured 'IVIS' Badge printing application interface to other company Databases

Tracked Production database Application disk space usage for the Storage Area Network Migration

Supported the 'Productivity Reports' combining Warehouse Management and Etime employee labor data

Applied Data Quality and Validation processes on ETL data going onto the Productivity Reports

Created datamart for Daily Domestic and Monthly Overtime Hours Crystal reports for upper management

Worked with Analyst to create data extracts from Informix to MS SQL databases for JVC and AMC

Maintained Etime 'Temporary Agency' labor extract and Crystal report 'labor hours' data refresh process

Coordinated Database migration and Replication reconfiguration for the Storage Area Network

Database Administrator

Dermalogica, Inc.

Torrance, CA (Oct 2000 - Aug 2005)

Administered and tuned Microsoft SQL Databases for Manufacturing, Finance, Distribution, Vertex Taxing, IDIRegistrar classes, Reporting and Datawarehousing

Maintained and modified logical and physical design of the datawarehouse

Created various ‘Data Transformation’ packages for (E)xtracting, (T)ransforming, (L)oading, and refreshing sales, address, product and financial information in the datawarehouse.

Participated in manufacturing application conversions from PowerCerv to JDE Edwards

Created and maintained dimension and fact tables based on the ERP application.

Created databases, target and staging tables, stored procedures, massaged and merged data to import datawarehouse information from different sources.

Created and populated summary tables, aggregate and lookup tables for the datawarehouse

Edited stored procedure, maintained views and triggers as required by the datawarehouse and reports.

Implemented Information Resource Management principles and Information Quality Techniques

Worked with developers in tuning the datawarehouse ‘refresh’ and increasing performance

Interviewed end-users for business requirements, new data marts and modifying the datawarehouse

Managed Database replication to offsite web-hosted database

Redesigned and managed Domestic, Canadian, British and Salon Services accounts for web referral

Performed monthly vertex taxing database rates and geocodes updates

Setup servers and databases for Cognos reporting migration.

Created web-based crystal reports for various departments and upper management.

Wrote reports on Forecasting, Inventory management, sales, product category, ranking, etc.

Performed sales reporting reconciliation and troubleshoot datawarehousing issues

Supported in administering Citrix and Intranet to provide remote user access to web reports.

Worked with Web Administrator and developers for implementing ‘outlook’ and web portal information entries to the datawarehouse

Database Administrator, Los Angeles Broadcast Center

DirecTV

Marina Del Ray, CA (Sept 1998 - May 2000)

Sybase Database Administrator for Los Angeles Broadcast Center

Supported Powerbuilder programmers for table structure and stored procedures creation

Assisted in HP AUX unix administration

Managed Database Data Model with Senior DBA in supporting Los Angeles and Colorado.

Imported datas from other departments into main database

Paticipated in application development for Satellite broadcast channel addition, programming outages and new programming promotions.

EDUCATION

1987-1988 University of California, Los Angeles

Took Computer Classes at UCLA (44 units)

Studies Included:

Programming Languages and Methodology Introduction to Artificial Intelligence

Software Systems Programming Computer System Architecture and Organization

Basic Methods of Data Organization Compiler Construction

Local Computer Network Simulation and Models

Formal Language and Automata Theory Unix and C language

Projects: Freeway Tollgate Simulation and an ADA compiler

1982-1986 University of the East, Philippines - B.S., Electronics and Communication

Engineering

Course Outline includes:

Network Analysis Electrical Machinery

Electro Magnetics Transmission Lines and Antennas

Communication Theory Acoustics

Microwaves Servomechanisms

Electronics Design Wireless Electronics

Elect Instrumentation and Control Industrial Electronics

Broadcast Engineering Communications System Analysis & Design

Contact this candidate