TECHNICAL SKILLS

Software: Informatica PowerCenter 8.x and 9.x, PowerExchange 8.x and 9.x, Data Quality(IDQ), Talend 4, Ab inito, ORACLE 10 and 11 and its analytic functions, OBIEE/Siebel Analytics, Teradata 13 and V2R6 (Fastload, Mload and TPUMP), IBM DB2 UDB EE &EEE and 9.x, 10.x, Nettzza 6.x, MSSQL 2005 and 2008, SSIS, Sybase ASE13, Business Object XI R3, Toad, ER/Studio, ORACLE SQL Developer, Saleforce, SAS, Oracle Designer, ERWin, Weblogic, WebSphere, Microsoft Visual C++, Visual Basic, ProModel, Extend, ClearQuest, Frame Maker, MS Project, Control M, AUTOSYS

Computer languages: C/C++, SQL & PL/SQL, MFC, VBasic, Perl, Visual C++, JAVA, Unix shell scripts, OSF/Motif, XML, HTML V/V+(Robotics)

Operating systems: Windows (Win 7 and XP), HP - UX, Sun Solaris, IBM AIX and Linux RedHat

PROFESSIONAL EXPERIENCE

Confidential - Redwood City, CA

Senior DW/ETL Developer

Responsibilities:

• Responsible for the support and continuous improvement of Marketing, Sales and Reporting applications.
• Played lead role in the definition of cross functional business requirements by analyzing the current transactional data (sell-in, sell-through and promotion).
• Analyzed the solutions, and created a scalable DW Data Model for data analysis & reporting.
• Helped create ETL solution for data consolidation and fed data into the Corporate Data Warehouse and the OBIEE application.
• Responsible for Informatica Administration to support the whole development team.
• Held lead role in integrating the current DW and Siebel to Oracle MDM Cloud.

Confidential - Concord, CA

Senior ETL/DW Specialist

Responsibilities:

• Leadership for all efforts to build various Data Warehouse & Data Marts for financial analysis & reporting with Decision Support, Dash-boarding, Web/Data Services
• Forecasting, Predictive Modeling and Optimization (Informatica software suites).
• Responsible for bringing various types of data to our data marts using multiple technologies with duties as follows: data modeling/data analysis, data integration
• ETL, master data management, data distribution & replication approaches, high availability, SOA, SAS/Cloud computing, data security, plus performance & tuning.
• Handled evaluation, identification and diagnosis of data quality issues, data mapping, and loading performance.
• Managed the migration and loading of data across all various platforms & applications (VSAM, midstream XML, Saleforce and SAS, B2B…).
• Responsible for making sure that solutions met ETL architecture, data loading, data quality and metadata management requirements.

Confidential - Universal City, CA

ETL/DW Architecture

Responsibilities:

• Leadership in all aspects of the delivery of the DW/BI solutions
• Resolved business challenges by translating them into requirements/solutions with Informatica/BO tool sets
• Implemented/designed the scalable ETL processes in a production data warehouse
• Coordinated the efforts between the onsite development team and off-shore team
• Built relational and multidimensional data modeling, to perform across business/technology teams to ensure alignment between business solution definition & systems architecture for the organization.

Confidential - Santa Ana, CA

Senior ETL specialist

Responsibilities:

• Worked for Confidential data management group, assuming team lead role in a small team to migrate from DB2 database to Oracle 10G for the internal applications
• Coordinated the data architect/application developers to implement the physical data models, develop and deploy the data warehouse & data marts solutions for the different departments
• Was responsible for all data quality projects (it includes data cleansing and data profiling) with Informatica Web Services/Business Objects.
• Assisted with the analysis and preparation mapping specifications;
• Participated e in the walkthroughs of data models and ETL specifications; and code and QA ETL mapping scripts; maintain the ETL production servers for our company data warehouses.

Confidential - Redwood City, CA

Lead Support Engineer

Responsibilities:

• Assisted customers in resolution of issues on architecture, logical design and physical star schema data models, map design, stored procedures & UNIX shell scripts, performance tuning and system integration
• Provided Business Intelligence solutions with Informatica’s web-based reporting tool
• Power Analyzer (reporting with OLAP technology), helping customers to quickly assess the impact of changes in the business and gain greater confidence in the data driving business decisions.
• Worked through full software development cycle (SDLC) with customers.
• Reproduced ‘bugs’ found and assisted in fixing the ‘bugs’ for the development team.

Confidential - Mountain View, CA

Software Engineer

Responsibilities:

• Performed database maintenance (Oracle, Informix and RDB),
• Provided enhancements and fixed ‘bugs’.
• Helped all customers to solve application problems in support of factory automation/operations.
• Duties included system & database analysis plus system performance evaluation.
• Participated in the rollout of the new product FAB300 and functionality development.