E DGAR ROXAS

410-***-****

acz8cb@r.postjobfree.com

SUMMARY

More than 20 years of information technology experience in the financial,

m anufacturing and management consulting industries bringing a broad set of skills

i n IT and project management, data architecture, data warehousing and systems

i mplementation.

TECHNICAL SKILLS SUMMARY

Data Modeling: ER (Conceptual/Logical/Physical), Dimensional (Star Schema and

S nowFlake), Data Flow Diagram, UML, Data Vault

Data Warehouse: DW, ODS, Data Marts, Business Intelligence, OLAP

DBMS: DB2, Oracle, SQL Server, Informix, MySQL, MS Access

ETL - Informatica, Ascential DataStage, SQL Server Integration Services

Reporting Tools -Tableau, SAP Business Objects, Crystal Reports, Hyperion Brio

I ntelligence, SQL Server Analysis and Reporting Services

Project Management: PMBOK, RUP, SDLC, RAD, Waterfall, Agile, MPMM, CBAP, Lean

S ix Sigma

Business Process Management: Systems Analysis and Design, Workflow and Process

I mprovement, Automation, Performance Metrics

Programming Languages: SQL, C, C++, Java, COBOL, PL/SQL, UNIX Shell, DB2

S tored Procedure

Data Profiling/Quality - Talend Data Quality / Open Profiler, DQ Analyzer

Microsoft - Project, Sharepoint, Word, Excel, Visio, Powerpoint, Access

Programming Languages: C, C++, Java, UNIX Shell, Perl, PL/SQL, Visual Basic, XML,

C OBOL, CICS, JCL

Hardware: IBM Mainframes, AS400, RS/6000, Intel servers, UNIX/Linux servers

Other Development Tools - Erwin, SQL Developer, ER Studio, Mercury ITG, Tidal,

A utosys, JIRA

Messaging/File Transfer - FTP, MQ Series, NDM

ERP/CRM Application - MAC-PAC, BPCS, MAPICS, Siebel, Salesforce

ITIL - Incident, Problem, Change, Release, Configuration, Service Desk

Data Analytics: Python, Tableau, Machine Learning, R

EXPERIENCE

Consulting 7 /11 Present

Consulted with companies to provide expertise in the area of data warehousing

a nd business intelligence, strategic planning, project management, business

a nalysis and data quality. Major Engagements:

Citigroup : D ata Architect / DW Specialist for the Enterprise Operational Risk

M anagement Group performing data mart architecture and design, data modeling,

d ata analysis, coding, data quality management and performance tuning. Worked on

O R Strategic Data Warehouse, MCA, Loss Management, and Risk Management

M arketing Workbench project, utilizing Big Data, Oracle, ETL, BI Tools, risk

m anagement, customer segmentation, network mapping and marketing intelligence.

Performed project coordination with global team units in US, UK, China, India, etc.

( 11/15 - Present)

RBS Consulting : Worked on multiple client projects performing data and

d atabase design and development, systems and data analysis, prototype

d evelopment and presentations to support pre-sales projects. Hands-on experience

u sing tableau, python, Informatica ETL, data modeling, etc. (3/15 -10/15)

Resume of Edgar Roxas Page 1 of 5

Sanofi : Worked as project manager / business analyst lead for the Business

I ntelligence Analytics group. Worked on multiple projects managing project teams,

e liciting requirements, scoping and developing project plans, data analysis,

s olutions delivery, monitoring and tracking project progress. Managed onsite and

o ffsite project teams. (6/14 - 3/15)

J Muller Works : Data architect supporting the conversion and migration of

l egacy systems to SalesForce. Performed data requirements gathering, identification

a nd inventory of data sources, data analysis and profiling, and data quality

p rocessing. Designed ETL jobs to extract data (Accounts/Organizations, Contacts,

H ouseholds, Opportunities/Donations, Affiliations, Relationships, etc.), identification

o f business rules and data transformations (data cleansing, deduplication,

s tandardization, enhancement, remediation of data quality issues). (7/13 - 4/14)

Fannie Mae : A s data consultant for the enterprise data strategy group,

p erformed review and analysis of existing enterprise data repositories. Analyzed

i nformation and data requirements, usage of data services, data virtualization and

d ata integration processes. Participated in the development of Fannie Mae's

e nterprise data architecture strategy, roadmap and data framework. Participated in

d evelopment of enterprise approach to master data management, data governance,

d ata warehouse and business intelligence architecture. (11/12 - 7/13)

State of New Jersey : A s data architect, managed and led the strategy, design

a nd development of the Release Recidivism Data Mart project, a shared data

repository for NJ Law and Public Safety agencies - Department of Corrections, State

Parole Board, Juvenile Justice Commission and NJ State Police - for performing

recidivism analysis and reporting to the office of the governor. Developed data

q uality management initiatives to identify and correct data quality issues; data

q uality tasks include data discovery/profiling, cleansing, matching, notification and

s tandardization. Performed data mining and statistical techniques. (11/11 - 8/12)

Glenmede Trust : A s data architect, performed review and validation of the

n ewly created Sungard financial reporting ODS data model that will replace

G lenmede s legacy reporting system. Performed data mappings of financial

reporting ODS to identified data sources including business rules, data

t ransformations and metadata. Designed and developed dimensional data models

f or financial reporting. Set up ETL environment and designed ETL mappings,

w orkflows and processes to source data from OLTP systems (Sungard Global Plus,

O nyx and InvestEdge). (7/11 - 11/11)

Project Lead - Data Center Operations 4 /10 07/11

OAO Tech Services / IBM / Horizon Blue Cross Blue Shield, Farmingdale, NJ

Performed project management, operations and workflow analysis, and production

t echnical support

Documented problems, issues log and problem resolutions in the Problem

M anagement System

Developed procedures and processes for handling system failures, overnight job

p roblems and critical system issues; review and perform updates and revisions to

c urrent process documentation

IT Director 1 /09 04/10

PSG Technology Group, New Brunswick, NJ

Managed and led project management, application development and support,

d atabase and server management, and development of IT policies and procedures

Worked as liaison between technology group and other PSG departments

Managed and led various projects including implementation of ExtraView Issue

M anagement System (Workflows, Dashboards, Analytics), PSGNB Community Portal

( Content Management System), data Integration and reporting

Vice President - Enterprise Data Services 2 /01 8/08

Resume of Edgar Roxas Page 2 of 5

U S Trust Company / Charles Schwab / Bank of America, New York, NY

Worked as Senior Project Manager for the Computer Services Division. Managed the

d ata integration project for the SRA/Mantas Anti-Money Laundering, Siebel CRM

d ata sourcing and integration, Portfolio Investment Optimization and Rebalancing,

C lient Portfolio Transition, Mutual Fund Reporting and Know Your Customer and

E nhanced Due Diligence reporting.

Worked as Head of Database Services beginning 2002. Supported all technology

p rojects and business data users by providing database administration and

d evelopment services, data architecture and administration, data migration, logical

d ata modeling and physical database design, non-public information data masking

a nd data/database standards

Initiated and led the data warehousing group in 2004. Designed and developed the

d ata warehouse architecture, procured DW/BI software tools, developed data

w arehouse standards, performed data profiling and published data

d ictionary/metadata/data quality reports

Managed implementation of several data warehouse projects: Business and Credit

M etrics, Sales Incentives Planning, Portfolio Analytics and Risk Control, Portfolio

Administration and Monitoring, Assets Under Management and Wealth Advisory

M anagement

Performed program/project management, requirements gathering, stakeholder

c ommunication and management, systems investigation and analysis, data

s ourcing and discovery, data modeling, data quality management, ETL

d evelopment, and development of business intelligence

reports/applications/scorecards/dashboards/pivot tables

Assistant Vice President Securities Processing Division 4/97 2/01

The Bank of New York, New York, NY

Managed and led the application development group (12 people) for the Strategic

G lobal Accounting system, designed to create one universal accounting system

o ver the Bank's numerous lines of business.

Responsible for reengineering the design and process of trade transaction

p rocessing from static rule based architecture to a dynamic calculation engine.

T he new design reduced transaction processing time by 25 percent and minimized

a pplication maintenance costs by $500K annually.

Prepared detailed project plans, system analysis documentation, system and data

f low diagrams, project design documentation and functional specifications.

Recipient of incentive and retention bonus awards

1 2/94 4/97

Technology Manager

Andersen Consulting, Florham Park, NJ

Managed and led the Revenue Solutions Center Technical Architecture Group

Provided management and technical services including architecture design and

d evelopment, programming, software configuration, data modeling, change

m anagement, database administration, performance tuning, network and hardware

s upport

Managed and led implementation and customization of Arthur Andersen Tax

Accounting System for the IRS Federal and various state agencies

( NJ/CA/NY/OH/FL/PA/DE/PR)

Managed and led several ERP/MRP system implementation and customization

p rojects (BPCS, MACPAC, MAPICS) for various client engagement projects

Performed requirements gathering, systems investigation, systems and data flow

d iagrams, functional and technical specifications, programming and documentation

Recipient of several employee of the month awards

Data Processing Manager 9 /92 12/94

Resume of Edgar Roxas Page 3 of 5

G reg Manning Auctions, Inc., Parsippany, NJ

Managed and led the IT department for Greg Manning Auctions, Inc. and its

s ubsidiaries - Ivy Shreve & Mader Philatelics - NYC/DALLAS, Greg Manning Galleries

a nd Harmer Rooke Numismatists

Managed the application development of GUI-based Auction, Describing,

Accounting and Billing systems

Spearheaded standardization of workstation machines and builds which led to

$ 200K savings in decreased maintenance contracts, decreased technician support

a nd discounted volume pricing

Business Systems Manager, Superpharm Corp., Bayshore NY 9/92

2 /90

Data Modeler/Programmer/Analyst, DCI, Manila Philippines0/85 1/90

1

EDUCATION

BS in Industrial Engineering / MIS, University of the Philippines

Certificate of completion

Project Management training (PMP)

o

Data Warehousing and Business Intelligence training (CBIP)

o

Business Analysis Professional training (CBAP)

o

Database Administration and SQL Development

o

Six Sigma Green Belt (ASQ)

o

Data Science, Data Analytics, Python, R Programming, Machine Learning

Resume of Edgar Roxas Page 4 of 5

R esume of Edgar Roxas Page 5 of 5

Contact this candidate