OBJECTIVE:

Seeking position as Senior Data warehouse Specialist, this include Architect, Data Model, Analysis or ETL (I am US Citizen)

SUMMARY:

• Worked on all phases of data warehouse development lifecycle (Requirement gathering, Business Analysis, Implementation and Unit and System testing)
• Demonstrated expertise utilizing ETL tools, including Informatica (7.x, 8.x, 9.x), Sagent and DataStage.RDBM systems (Teradata, Oracle, SQL Servers, Informix and Sybase). Very experienced in UNIX command and scripting
• Team lead and player with excellent communication and problem solving Skills

TECHNICAL SKILLS:

Databases: Amazon redshift, TeraData, Oracle (8.i/9.i, 10g, 11g), SQL Server 7.0/2000/2005/2008 , INFORMIX 7.x, INFORMIX SE 4.x, Red Brick 6.x, INFORMIX HPL, MS - ACESS, DB2-UDB, Sybase

ETL Tools: SnapLogic, Informatica (9.0, 8.6, 8.5, 8.1, 8.0, 7.x, 6.x), Informatica B2B Data Exchange (9.1 and 9.5). Sagent (V4.5i), DataStage (4.x, 5.x, 7.x), C/ESQL Programming, light JAVA/JDBC Programming, Paragren-Siebel One By One Suite (Racer)

Languages: C, C/ESQL, C++, JAVA (JDK 1.1.6), Java scripting

Shells: UNIX Scripting (C, KORN, AWK, BOURNE)

Web Personalization: E.Piphany RightPoint 5.x, MS-IIS Server

First Logic: Name and Address Hygiene to standardize and correct addresses, Merge/Purge

Systems/OS: AIX 5L (Ver 5.2), Sun Solaris 2.6, Windows 9x/NT/2000/XP, IRIX 6.x

Network Programming: TCP/IP, UDP, BSD Sockets

Platforms: AIX 5L (Ver 5.2), SUN workstation, SGI, PCs, IBM RISC/6000

Modeling Tools: MS-VISIO, ERwin, Oracle Designer

Applications: MS-VISIO, MS-Office

Configuration Management Tool: UNIX RCS, MS-SourceSafe

QA: Data Warehouse QA. Code and ETL QA. OLTP/OLAP QA. Reports QA

PROFESSIONAL EXPERIENCE:

Confidential, Santa Monica, CA

Sr Data Engineer - Consultant

Responsibilities:

• Working as Senior Data Engineer. Some of the tasks I am working on are Data Quality issues. fact source updated subscriber and subscription data. these changes will be migrated to Snowflake and Hive databases.
• Started Campaign 360 project. Bring extra data for the new campaign the company will run to try to bring cancelled customers.

Environment: Hadoop, SnowFlake, talend

Confidential, San Jose, CA

Sr DW Consultant

Responsibilities:

• Files extracted from Hadoop and dropped on daily hourly basis into S3
• Write code or ETL processes using SnapLogic to load data into redShift tables
• Create code to bulk load or Upsert (Insert/Update) using Redshift and SnapLogic
• Build the data model to load the flat files (Stage)
• QDN project. Build the data model and ETL to move the data from DB2 (DW) to redshift. Include initial load and incremental. implement logic to check RD and load any new records or update
• Move data from MySQL to RS, include built the data model and ETL
• Work on create prod Data Warehouse in Redshift to load QDN data
• Work on HICAP to bring data directly from source instead of S3

Environment: AWS (Amazon Web Service), S3, SnapLogic, RedShift, Linux

Confidential, LOS ANGELES, CA

Senior Data Warehouse/ETL Lead

Responsibilities:

• Worked on Quality Council (CORE) Data Mart
• DW projects to enhance the existing DW
• EPIC 2010, apply all the changes needed in Stage and DW to comply with EPIC 2010 upgrade
• Upgrade the DW with new data feed from EPIC
• Work on EDW data load, involved in the Architect and work on ETL
• Upgrade CSMG data mart to reflect EPIC 2010 changes and apply service area merge
• Work on MCKESSON data feed. Provide MCKESSON with flat file with patient information
• Working on the new EDW project, this include loading all clinical and Professional Billing data into the new EDW
• EDW phase II, Operation data feed
• Work on Various data quality issues
• Work on Fix logic for CSMG
• Work on Optimize Weekly load, runs for 6-10 hours, now 1-1.5 hours. Orders used to run for 45 minutes, optimized and running for 6-7 minutes
• Work on ICD 9 and ICD 10 procedures
• Work on OPTIME project, Bring data from Clarity to EDW, including stage
• EPIC 2012 Upgrade, apply all EPIC 2012 changes to stage, DW, EDW

Environment: Informatica PowerCenter 9.5, Oracle 11g. Modeling tool (Oracle Designer)

Confidential

Senior Data Warehouse/ETL Consultant

Responsibilities:

• Understand the new requirement and provide feedback on the data model for the new project
• Provide tips for the development of the new project
• Support the ETL team when needed

Environment: Informatica PowerCenter 9.x. Teradata (13, 13.10), SQL Server 2008, Oracle 11g. Modeling tool (ERwin)

Confidential

Senior Data Warehouse/ETL Consultant

Responsibilities:

• Create Requirement Document: Understand the business roles, gather the business requirement for the project, then create the project Requirement document System Architect.
• Create the system architect document for the project Data Warehouse Architect.
• Creates the DW architect diagram Logical and Physical Data Models.
• Creates logical and physical model for the Data Warehouse ETL packages.
• Create ETL packages to load the data to stage, then DW using SSIS Optimize the SQL Server DB for best performance Unit test and QA PRODUCTION.
• Copy the DW to create production copy, then migrate the data and ETL Data Marts.
• Create Data Marts and Aggregate table

Environment: SSIS and SQL server DB (2005 and 2008). Modeling tool (MS Visio)

Confidential

Senior Data Warehouse/ETL Consultant

Responsibilities:

• Implemented DW and Informatica best practices
• Developed and Unit test 1.1 release for the EDW, Worked on GL ENTRY process and GL Sources
• Analyze and create ETL Design Document for EDW Release 1.2
• Architect and re-develop GL ENTRY process (Improve the performance and usability)
• Worked on other components for Release 1.2 (GL ACCT, GL BUDGET and others)
• Provided feedback on the DQC process from the DW stand point and ETL
• Support other ETL developers
• QA and set up automated processes to provide DW load quality check

Environment: Informatica PowerCenter 9.x. Teradata (13, 13.10), SQL Server 2008, Oracle 11g. Modeling tool (Erwin)

Confidential, LOS ANGELES, CA

Senior Data Warehouse/ETL Lead

Responsibilities:

• Provided support for Architect or Modeling for new projects
• Architect and Developed (CFS-Patient Satisfaction Dashboard) load into the Data Mart
• Analyze and upgrade Census Data Mart project (Daily Admissions, Daily Patient Movement and Daily Discharge).
• Created automated scripts to test the targets after loading the data
• Developed mechanism to flag records in hospital patient information (Cancelled patients and other logics)
• Analyze and fix existing processes. (Visit Summary, Charge Detail), to improve the performance and the usage of the system resources
• Analyzed and developed CONCUITY project to provide analytical data to third party
• Worked on CS-Link, massive change to the DW source system (Data types and Size)
• Mentor other team members

Environment: Informatica PowerCenter 8.6.1. Oracle 11g. Modeling tool (Oracle Designer)

Confidential, IRVINE, CA

Senior IT Integration Specialist

Responsibilities:

• Worked on Sales revenue Integration Service project at ASP ( Confidential & Confidential ) company.
• Responsibilities
• Analyzed the requirement for the SRIS (Sale Revenue Integration Service) project and provided the system architect
• After getting the approval on the system architect, worked on the DW architect and modeling
• After getting the approval for the Logical and Physical data model, worked on Detailed Design document
• Started the Development of the ETL and Unit Test
• Mentor Sr. ETL developer to take over the project
• Ensure SOX compliance by enforcing corporate CAV process. This included architect and design the CAV process and tables

Environment: Informatica PowerCenter 8.1.1 and 8.6.1. SQL Server 2008 as db. Ensure SOX Compliance. Modeling tool (MS Visio)

Confidential, LOS ANGELES, CA

Senior Data Warehouse/ETL Lead

Responsibilities:

• Analyze and re-architect the existing DW to comply with EPIC project
• Verified all Epic ETL design documents and provide feedback when needed
• Developed and Unit test staging environment (ECODESR, HBSR, Supervise the development of HBSR)
• Performed Admin tasks on the Informatica server, this included (creating accounts, assigning privileges and creating shared and reusable objects).
• Improved the performance of patient process, (was taking 3+ Hours for 500K records, to 20 minutes).
• Improved the transaction process (was taking 2+ hours for 400K records, improved to 18 minutes for the same number of records).
• By applying DW and ETL best practices
• Used Pushdown optimization to improve the performance when loading the DW to push the transformation logic into the Source, Target database.
• Developed UNIX shell scripts to perform various tasks (checks on the trigger files and archive data files.)
• Created migration documents, led the processes of migrating the code from DEV to TEST then PROD
• Recognized for completing tasks in a very timely manner and provide high quality code

Environment: Informatica PowerCenter 8.1.1, Push Down optimizer, Oracle 11g, SQL, PL/SQL, XML, Toad 9.5, Business Objects XI, UNIX, Windows XP, Informatica Data Analyzer.

Confidential, Culver City, CA

Senior ETL Architect

Responsibilities:

• Designed and developed Informatica objects to support the company's needs, this includes Unit testing and QA
• Upgraded from Informatica 7.x to 8.1, then to 8.5
• Analyzed and implemented different projects for different clients. Started by gathering the requirements, writing the design documents and conducting all required development, including the UNIT testing and QA
• Supported development, production and business groups by providing technical tips
• Identified some bottlenecks with the mapping and improve the performance by using Pushdown optimization.

Environment: Informatica PowerCenter 8.1.1, Informatica Power center 8.5x, Sybase, SQL, Push Down optimizer

Confidential, Carlsbad, CA

Lead Informatica Specialist/Data Warehouse Architect

Responsibilities:

• Spearhead creation of complex data model structures focused on imminent organizational development and established architectural frameworks for risk mitigation and ever-changing business needs
• Installed and setup Informatica v 7.x then Upgrade to 8.x, include setting up user accounts, folder, standards and configuring Informatica server to support the company needs
• Perform Admin tasks
• Gathered the requirements for the Data Warehouse projects
• Provided tips and suggestions for both Logical and Physical Data Models
• Completed design and modeling process of the first Phase of the Data Warehouse
• Worked on the design for ETL processes and distributed the work between the ETL developers
• Lead the development team during the development process, this include providing Informatica and ETL support
• Snow flaked some of the dimension tables to support MicroStrategy tool
• Responsible of building and executing QA and code review processes for the ETL team. This includes QA of the logic of the ETL processes when loading data into the dimensions and facts.
• Optimized the data warehouse to achieve the best performance to support loading and reporting

Environment: Informatica PowerCenter 7.X and 8.x and DataStage (7.x), Oracle 10G, SQL and PL/SQL, Push Down optimizer. Windows servers, people Soft DB

Confidential, Santa Monica, CA

Senior Consultant Data Warehouse/ETL

Responsibilities:

• Supported all Informatica daily admin tasks, provided suggestions to improve the server performance. Also provided Production support during the day and at night
• Developed QA process to load the web logs into the Data Warehouse using Informatica. The new processes achieved improvement in the process performance comparing to the existing process (in Sagent), runtime dropped from 3 hours to 45 minutes
• Attended daily and weekly meetings with the business team to discuss all data quality issues and communicated between the marketing team and the Data Warehouse team
• Led and worked on fixing the data quality issues, this includes code fix and data fix. Issues dropped from 60 issues to 5 after 3 weeks
• Performed the design for SuperDog and SuperDog Phase II Projects. provided support for the development team and monitored the development process
• Re-designed Search Engine process. This process caused a lot of issues for the company, so I providedthe team with a better solutions to optimize the process running faster
• Gathered requirements for new projects, created Architect and Design documents
• Used MicroStrategy to QA Informatica processes and find data quality issues

Environment: Sagent, Informatica PowerCenter 8.x, Oracle 11G, SQL Server and Teradata. Push Down optimizer. UNIX. Modeling tool (ERwin)

Confidential, CA

Consultant (Sr. Data Warehouse Architect/ETL Lead)

Responsibilities:

• Installed and setup Informatica 8.x
• Worked as an Admin for Informatica servers (Production, Development, QA and UAT)
• Installed and Admin Informatica reporting tool data analyzer (Similar to MicroStrategy)
• Provided technical lead for the reporting team
• Worked close with the Sr. Data Warehouse manager to gather the requirements for the Data Warehouse projects from the OLTP Oracle source DB
• Analyzed the Source systems and provide tips on building dimensions and fact Tables
• Completed the design and modeling process of the first and second Phases of the Data Warehouse
• Completed ETL design documents, provided supervision for the ETL team.
• Helped in developing Informatica mappings, PL/SQL code to fix issues in production database
• Performed QA and code reviews for the ETL code and provided tips for the DW team to improve the performance of there ETL jobs.
• QA the data warehouse to achieve the best performance for all the reports
• Worked on setting up the infrastructure for the reporting tool (DA), provided technical tips and supervision for the reporting team Environment: Informatica PowerCenter 8.x, Oracle 11G, Data Analyzer, Push Down optimizer. UNIX