OBJECTIVE:

Seekingposition as Senior Data warehouse Specialist, this include Architect, Data Model, Analysis or ETL

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, includingInformatica (7.x, 8.x, 9.x),Sagent,and DataStage.RDBM systems(Teradata,Oracle,SQL Servers,Informix,andSybase). Very experienced in UNIX command and scripting
• Teamlead andplayer 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 , INFORMIX7.x, INFORMIX SE 4.x, Red Brick 6.x, INFORMIX HPL, MS - ACESS, DB2-UDB, SybaseETL Tools SnapLogic, Informatica(9.0,8.6, 8.5, 8.1, 8.0,7.x, 6.x), InformaticaB2B 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 andcorrect 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, PC's, 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, San Jose

Sr 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)
• 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

Sr. Data Warehouse/ETLLead

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 PowerCenter9.5,Oracle 11g. Modeling tool (Oracle Designer), Informatica B2B data exchange (9.1 and 9.5), Informatica Metadata Manager (9.1)

Confidential

Sr. Data Warehouse/ETL Consultant

Responsibilities:

• Understand thenew 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 PowerCenter9.x. Teradata (13, 13.10), SQL Server 2008, Oracle 11g. Modeling tool (ERwin)

Confidential

Sr. Data Warehouse/ETL Consultant

Responsibilities:

• CreateRequirement Document: Understand the business roles, gather the business requirement for the project, then create the project Requirement document
• SystemArchitect. 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
• Optimizethe SQL Server DB for bestperformance
• Unit test and QA
• PRODUCTION. Copy the DW to create production copy, thenmigratethe 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

Sr. Data Warehouse/ETL Consultant

Responsibilities:

• Implemented DW and Informatica bestpractices
• Developed and Unit test1.1releasefor the EDW,Worked onGL ENTRY process andGL Sources
• Analyze and create ETL Design Document for EDWRelease 1.2
• Architect andre-developGL ENTRY process(Improve the performance and usability)
• Worked on othercomponentsfor 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 PowerCenter9.x. Teradata (13, 13.10), SQL Server 2008, Oracle 11g. Modeling tool (ERwin)

Confidential, LOS ANGELES, CA

Sr. Data Warehouse/ETLLead

Responsibilities:

• Providedsupport forArchitect or Modelingfor new projects
• Architect and Developed(CFS-Patient Satisfaction Dashboard)load into theData 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 inhospital patient information (Cancelled patients and other logics)
• Analyze and fixexisting processes.(Visit Summary, Charge Detail),to improve the performance andtheusage of the systemresources
• Analyzedand developedCONCUITYproject 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

Sr. IT Integration Specialist(Architect, Modeling, ETL)

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 onDetailed 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 Archiutec and design the CAV process and tables

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

Confidential, LOS ANGELES, CA

Sr. Data Warehouse/ETL Lead

Responsibilities:

• Analyze and re-architect the existing DW to comply with EPIC project
• Verifiedall EpicETL design documentsandprovide feedback when needed
• Developed and Unit test staging environment (ECODESR, HBSR, Supervise the development of HBSR)
• PerformedAdmintasks on theInformaticaserver,this included (creatingaccounts, assigningprivileges,and creatingsharedand reusableobjects).
• Improvedthe performance of patient process,(was taking3+ 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). Byapplying 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.
• DevelopedUNIX shell scripts to performvarious tasks (checks on the trigger files, and archive data files, etc.)
• 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, California

Sr.ETL Architect

Responsibilities:

• Designedand developedInformatica objectsto support the company'sneeds, this includes Unit testing and QA
• UpgradedfromInformatica 7.x to 8.1, thento 8.5
• Analyzed and implemented different projects for different clients.Startedbygatheringthe requirements, writing the design documents and conducting all requireddevelopment, including the UNIT testing and QA
• Supported development, production andbusinessgroupsby providing technical tips
• Identifiedsome bottlenecks with the mapping and improve theperformanceby using Pushdown optimization.

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

Confidential, Carlsbad, California

LeadInformatica Specialist/ Data Warehouse Architect

Responsibilities:

• Spearhead creation of complex data model structures focused on imminent organizational development and establishedarchitectural frameworks for risk mitigation and ever-changing business needs
• Installedand setupInformaticav 7.xthen Upgrade to 8.x, includesetting up user accounts, folder, standards, and configuringInformatica server to support the companyneeds
• PerformAdmintasks
• Gathered the requirements for the Data Warehouse projects
• Providedtips andsuggestionsfor both Logical and Physical Data Models
• Completed design and modelingprocess of the first Phase of the Data Warehouse
• Worked on thedesignforETL 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 flakedsome of the dimension tables tosupport MicroStrategy tool
• Responsibleofbuilding and executingQA and code review processes for the ETL team.This includesQA of the logic of the ETL processes when loading data into the dimensions and facts.
• Optimizedthe data warehouse toachievethe 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, California

SeniorConsultant Data Warehouse/ETL

Responsibilities:

• Supportedall Informatica daily admin tasks, providedsuggestions to improve the server performance. Also provided Production support during the day and at night
• Developed QAprocessto load the web logs into the Data Warehouseusing Informatica.The new processes achieved improvement in the process performance comparing to the existing process (in Sagent), runtime dropped from3 hoursto45 minutes
• Attended daily and weekly meetingswith the business team to discuss all data quality issuesand communicatedbetween the marketing team and the Data Warehouse team
• Led and worked on fixing the dataquality issues, this includes code fix anddata fix. Issues dropped from 60 issuesto 5 after 3 weeks
• Performed thedesignforSuperDogand SuperDog Phase IIProjects. 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 theprocessrunningfaster
• Gathered requirements for new projects, created Architect and Design documents
• UsedMicroStrategyto QAInformatica 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, California

Consultant (Sr. Data Warehouse Architect/ETL Lead)

Responsibilities:

• Installedand setupInformatica 8.x
• Worked as anAdminforInformatica servers (Production, Development, QA and UAT)
• Installedand AdminInformatica reporting tooldata analyzer(Similar toMicroStrategy)
• Provided technical lead for thereporting team
• Worked close with the Sr. Data Warehouse manager to gather the requirements for the Data Warehouse projectsfrom the OLTPOraclesource DB
• Analyzedthe Source systems and provide tips on building dimensions and fact Tables
• Completed thedesign and modeling process of the firstand secondPhasesof 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

Confidential, California

Sr. ETLConsultant

Responsibilities:

• Worked onMedicare Part D project,this included writing the specs andthedevelopmentof the project
• Developed andQA Claim loadsfrom different vendors(Daily and Cycles)
• Supportedthe {pharmacy teaminData Warehouse Phase IIproject. This includeddeveloping and updating mappings
• Optimizedcurrent processes by applyingInformaticaand SQL skills.Reduced the load time from eight hours to less than an hour by replacing lookup with outer join
• Helped in developing Informatica mappings, PL/SQL code to fix issues in production database
• Provided Date Warehousedesign tips forthe team, include cleaning there dimensions (cleaned half million records were not connected to any fact)
• Provided tips for the DW team to improve the performance oftheirETL jobs.
• QA Medicare Part D and performedcode reviews

Environment: InformaticaPowerCenter 6.x, Oracle 10G,UNIX, HealthCare system