SUMMARY:

• Visionary, intuitive and resourceful professional, offering extensive years of experience in full system development lifecycle, encompassing systems integration, systems implementation, custom application development, system testing, and data modeling techniques.
• Display proven expertise in business intelligence, enterprise performance management, data warehousing, ETL, human resource management, payroll, billing, accounts receivable, accounts payable and general ledger systems.
• Leverage keen attention to detail in providing a wide range of services, including system administration, user acceptance testing, user training, system troubleshooting, data conversion, data modeling, and custom interface development.
• Powered with excellent leadership in the areas of project development and project team supervision, complemented with proven success in conceiving and implementing innovative IT delivery practices across large enterprise business clients within rapidly changing environments
• Adept at analyzing technical details and providing significant technical contributions
• Reliably efficient and quick learner, with solid oral and written communication abilities, as well as interpersonal skills crucial in fostering productive relationships with all business and technical levels

TECHNICAL PROFICIENCY:

Programming Languages: Application Engine, C, COBOL, Pascal, PeopleCode, PL/SQL, R/Basic, SQL, SQR

Databases and Software Packages: Access, Advanced Revelation, Ariba Buyer, Ascential DataStage 8.7, Canvas LMS, Cognos 10 ERwin, IBM DB2, Informatica 5.1, Oracle 11g, PeopleSoft, Tableau, TIBCO Adaptor, Visio

Others: Accounts Payable, Accounts Receivable, Benefits, Billing, Campus Solutions, Customer Relationship Management (CRM), Enterprise Human Capital Management (HCM), General Ledger, Enterprise Performance Management ( Confidential ), Oracle Business Intelligence (OBIEE) 11g, Payroll, PeopleTools 8.52

PROFESSIONAL EXPERIENCE:

Confidential, Northridge, CA

Business Intelligence and Data Warehouse Developer /Analyst

Responsibilities:

• Data Modeling, design, development to build data structures and ETL jobs to extract and capture data into custom international student warehouse module.
• Develop and build international student dashboards including OBIEE RPD development.
• Design, develop and implement dashboard security based on college level affiliation.
• Perform cleanup and data validity testing on current PeopleSoft Confidential 9.1 Campus Solutions data warehouse.
• Develop a plan for cleansing and validating current data warehouse and maintaining data integrity.
• Document development standards and provided template documents to assist in future data modeling and development efforts.
• Implement delete strategy logic to handle source system deletes in the warehouse.
• Implement data validation and error handling to monitor warehouse load performance and issues.
• Import Canvas LMS data to custom Oracle Fact and Dimension tables to integrate with existing and custom data warehouse structures for reporting through Tableau and OBIEE.

Confidential, San Jose, CA

Business Intelligence and Data Warehouse Architect

Responsibilities:

• Design, develop, test and implement a delete strategy for custom DataStage ETL jobs staging table jobs.
• In corporate logic to handle re - entry of previously delete data rows into Oracle transaction tables.
• Data modeling to capture student test score data and integrate with existing data structures.

Confidential, Fullerton, CA

Business Intelligence and Data Warehouse Architect

Responsibilities:

• Load and validate data sourced from PeopleSoft Human Capital Management system into a PeopleSoft Confidential Human Capital Management data warehouse.
• Perform necessary development and customization to source data for OBIEE Business Intelligence Payroll, Benefits and Workforce Analytics data marts.
• Data modeling and development to support custom workforce snapshot data for year to year data comparison business intelligence reporting.

Confidential, Miami, FL

Business Intelligence and Data Warehouse Developer /Analyst

Responsibilities:

• Troubleshooting issues during the implementation and setup of the development, test and production environments
• Trained technical staff to implement, customize, develop, run and maintain all areas of the PeopleSoft Confidential 9.1 Campus Solutions Warehouse and DataStge 8.5
• Designed, developed and implemented a custom snapshot module for institutional research to support Integrated Postsecondary Education Data System (IPEDS) reporting
• Design and implement row level data warehouse security based on user affiliation with the university in Confidential 9.1 and OBIEE 11g
• Provided post implementation support, training and documentation

Confidential, Columbus, OH

Business Intelligence and Data Warehouse Analyst

Responsibilities:

• Supported PeopleSoft Confidential 9.0 Human Capital and Financial data warehouse and Cognos 10 Reporting
• Meet with user groups to conduct data gap and fit analysis
• Analyzed and addressed data, reporting and business intelligence issues
• Designed, built, tested and implemented data warehousing solutions

Confidential, Fort Lauderdale, FL

Manager

Responsibilities:

• Played an integral role in the project planning, scoping, and architectural design for a global financial system implementation at a large worldwide insurance company.
• Established high level current and future state architecture diagrams, project charters, high level project plans, and prioritized project timelines.
• Forecasting and analyzing fiscal impact of various management decisions and established policies.
• Supervised and coordinated direct reports, as well as accurately assigned projects, set career goals, and offered necessary resources to accomplish tasks within time constraints without compromise on quality.
• Proficiently acted as the testing lead for a Basel II data warehouse rollout for a mid-market investment and corporate bank
• Managed and streamlined user acceptance testing between custom-built portfolio risk rating system, defaulted loan database and Basel II compliant database to ensure data integrity between each data source

Confidential, Miami, FL

Manager/Senior Consultant

Responsibilities:

• Assumed the roles of a technical and functional project manager in directing the development and implementation in Confidential, DataStage 7.5 ETL, and Oracle Business Intelligence Enterprise Edition (OBIEE) 10.1.3.2
• Conducted comprehensive research and analysis to identify relevant data from PeopleSoft CRM 9.0 and PeopleSoft 9.0 Campus Solutions on Oracle 10g databases in support to college admission process
• Leveraged solid leadership skills in providing technical and functional support to an Oracle PeopleSoft Confidential 9.0 Campus Solutions Data Warehouse implementation
• Oversaw the custom development and database design of the PeopleSoft Confidential Application for a mid-market investment and corporate bank to support Basel I Capital Accord compliance
• Designed and implemented a database and online transaction system, which enabled users to risk rate commercial loan portfolios