Cynthia Luff Email & Phone Number

Costa Mesa, Ca, Us

Satisfied business requirement with various b2b vendors. Accomplished in development and support of Data Engineering using AWS toolset. Data Warehouse using ETL for Reporting. Technologies used are: Informatica Power Center v10.2.0, AWS Redshift v4.2, AWS EC2, AWS S3. MS SQL server v2010, Netezza database, Control-M scheduler, Alteryx ETL, Tableau reporting, Denodo virtualization server and Linux.• Installed and migrated Informatica Power Center to AWS EC2 Redhat Linux in order to move out of on premise data center to the cloud.• Stand up Denodo virtualization server on AWS EC2 Amazon Linux to facilitate data availability to business self service data virtualization. • Preserved Informatica administration for migrations, database connection, security permission and conduct code review to confirm to best practice and standards.• Enriched Informatica ETL as the data integration tool. Writing and supporting Informatica code with mapping, workflows. Creating parameter files to create seamless environment promotion.• Coordinated the Informatica ETL using tools such as: AWS Redshift, Microsoft SQL and Netezza database. Planned testing cycles, parallel testing tasks with outsourced staff.• Produced enterprise solution scheduling in Control-M instead of crontab, Informatica scheduler.• Participated in daily stand up of Agile/Scrum team to provide transparent task management. Utilizing task tracking using JIRA. Partake in iteration planning with grooming and planning sessions.• Communicate with Business to clarify requirements then derive unit test case data. Derive business requirements document (BRD) to help manage expectations to new data sets.

Costa Mesa, Ca, Us

Costa Mesa, Ca, Us

Costa Mesa, Ca, Us

Costa Mesa, California, Us

Achieve development and support of Business Intelligence and Data Warehouse ETL for Reporting initiatives. Technologies used are: Informatica v9.1.0 and SSIS 2008. Teradata and MS SQL server v2005, v2008 Fast Track. Control-M scheduler.• Streamlined performance and tuning of ETL batch jobs for Claims Data Marts. Achieving 3 minutes table materialization instead of 30 minutes.• Improved ETL and database support in area of coding standards. Standards achieved reliability, maintainability as well as rapid development of code. Improved a 2 days process to 2 hours.• Analyzed and identified 15 subject areas jobs to satisfy Software Level Agreement (SLA) for business management team, hence providing proper business continuity.• Demonstrated business requirements gathering base on business Test Case Design. This help development team to satisfy requirements, therefore putting desired code in front of the business the 1st time.

Database Developer at Aurora Bank Commercial Services Client SiteRetained to facilitate the Information Technology support of this commercial services office.• Improved SSIS ETL job performances 60% with recognition the bottlenecks. Techniques include utilize reduced buffer size in asynchronous transformations and minimizing logging data with bulk mode instead of row by row.• Increase business productivity 95% by improving SSIS ETL architecture of intraday delta loads. Approach was to enable data high availability by using pointer references during the long load times.• Eliminate monthly emergency change tickets needs by planning and standardizing the business process. Proactively mitigate the weakest links with redundancy and alternatives steps to critical processes.

Primary focus is to sustain BI/DW ETL initiatives for mortgage investment firm to allow for maximize return company investment. • Accomplished an automated BI/DW ETL framework environment in MS SQL Server Integration Services (SSIS) in just two months to reduce the vulnerability of business by half. • Interfaced with business stakeholders to rectify erroneous workflow management database in MS SQL v2008 R2. The improved implementation simplified the metadata grouping relationship to fit current business needs with less overhead. Resulting in single instead of double reconciliation.

New Braunfels, Texas, Us

MCITP education – Microsoft Certified IT Professional DB Developer for SQL Server 2008 with Business Intelligence (SSIS, SSAS, SSRS) Training Program with Instructor Led Training.

Los Angeles, Ca, Us

Experience with BI ETL integration processing to provide Human Resource data to internal application and outside vendors with quality and punctual implementation.• Hands-on development/architecture of BI/ODS ETL transfers to relay dependable data from heterogeneous sources such as Oracle 10g, Sybase v12.5, and MS SQL v2008 to targets with flat files, pgp encrypted file or XML.• Analyzed and identified 15 priority jobs to satisfy Software Level Agreement (SLA) for business management team.• Achieved positive user experience by using Test Cases to create reliability in SAP upgrade deployment project.

Los Angeles, Ca, Us

Engaged as an Infrastructure BI ETL Database Developer to support Investment Systems DSS application team with reliability and productivity.• Segregated conjoined software application into 2 supporting lines of business in 6 months adhering to Software Development Life Cycle (SDLC) and Sarbanes-Oxley (SOX) rules.• Integrated heterogeneous technology stack with cohesive tools to facilitate data transfers with minimal maintenance and maximum scalability. Databases are Sybase v12.5.0.3 and Oracle 10g. Operating system is HP UNIX 11i and Solaris. ETL tools are Informatica Power Center v7.1.2, and Unix Ksh scripting. Enterprise scheduling with AutoSys and source control in Perforce. • Created and enhanced database architecture Entity Relationship Diagrams (ERD) to satisfy increase business needs via Erwin and adhering to Kimball BI/DW methods. • Streamlined liaison communication between cross IT teams by creating request templates that provided clarity and efficiency with sustainable results.

Responsibilities included Database Development and Administration along with objective to ensure database integrity, performance and tuning to ensure business continuity.

El Segundo, California, Us

Key roles are to support Advertising Systems team operations. This position spans SQL development, architecture and administration. Leading a five members team of developers in all administrative, development and functional operations to allow for highest advertising revenue.

Sybase Database Administrator supporting Smalltalk front end systems on Unix platform.

Sybase Database Administrator in Unix platform