Project Data Warehouse
Resume:
Jiten Thakkar
Data Warehouse Developer/System Analyst
*******.*****@*****.***
Professional Experience Summary:
. Senior Data Warehouse Developer. ETL developer using Perl/Oracle PL-
SQL. Web Reports developer using PHP/HTML
. Experience working with multiple databases (Oracle /MySql /Informix
/Ingres)
. Experience working with Semiconductor Test Floor and Supply Chain Data
Automation
. Experience in business requirements gathering and analysis
. Developing Use Cases for the Application, converting use cases into
precise requirements for technical team, QA and UAT of the application
. Experience in architecture, design and implementation of software
solutions,
. Strong advocate of coding standards and enterprise library patterns
. Excellent communication and reporting skills to update management on
project status
. Rich experience of working with global IT companies like Accenture and
EDS.
. Have worked in both onshore as well as offshore model
Education:
Portland State University: Masters in Software Engineering (2008)
Mumbai University: Bachelors in Electronics Engineering
Technical Skills Summary:
Languages: Perl, Shell Scripts, AWK, Hyper Script, SQL, PL/SQL, C,
Databases: Oracle 10G, Informix 9.2/7.x, MySQL
4.1,Ingres
Platforms: Sun-Solaris, Linux, Windows 2000/2003 Server, Citrix, Windows
Vista/XP
Tools and Utilities: Oracle Enterprise Manager, Informix Server
Administrator SharePoint 2007, Apache, IIS 6.0, SQL
Server 2005 Enterprise Manager, MS Office 2003/2007,
MS Visio 2003, MS Project 2003
Distributed Computing: Perl Web Services, SOAP, WSDL
Professional Experience:
Technical Analyst at ON Semiconductor May 2006 to Present
Software Engineer at LSI LOGIC Jan 2001 to May 2006
Database Programmer at Providian Bank Aug 1999 to Jan 2001
Project Details:
Project Name: ON Semi Global Yield Data Warehouse Project
Client: ON Semiconductor
Duration: May 2006 to Present
This project includes studying various yield solutions at different fabs
and setting up common data warehouse for test data to improve yield and
connecting to third party front end BI tool. The project involved
evaluating ETL tools and BI tools and identifying the best tool et for
project.
Project Goals
. Identifying test data from different sites
. Standardizing file formats
. Managing Metadata in smaller database
. Designing and implementing Transformation scripts
. Extracting MES information from Oracle MES database
. Loading data in data warehouse
. Supporting and Training
Platforms & Technologies
. Oracle PL/SQL
. Oracle Normalized and Star database design
. Perl DBI/DBD
. PHP Web Reports
. Perl Web Services
. Apache Web Server
. Unix Korn shell and Perl scripts
Roles and Responsibilities
. Evaluating the tool set for the project for ETL and BI tools.
. Meeting with yield engineers and managers to gather requirements.
. Document file formats from different sites
. Document MES relevant ERD Diagrams
. Discuss with technical team
. Develop QA plan for testing the system.
. 24*7 support
Project Name: LSI Logic
Client: LSI Logic
Duration: Jan 2001 to May 2006
LSI Logic had data warehouse to store LEH/Metrology/Bin/Parametric data
from different test and assembly sites using Informatica as ETL tool. The
project included to replace Informatica with in-house ETL tools develop in
Perl and Informix because of performance issues.
Project Goals
. Load Inline and EOL test data in DW
. Replace Informatica with in house ETL tools
. Replace Informix with Oracle as DW database
Platforms & Technologies
. Perl DBI/DBD
. Informix Star database design
. Informatica
. MS Visio to document the Informatica mappings
. Informix Server Administrator
. Unix and Perl Admin Script
Project Role
. Documenting existing Informatica Scripts
. Develop Perl ETL script developer
. Informix database administrator
Project Name: Customer Credit Score Rating Project
Client: Providian bank, CA
Duration: Aug 1999 to Jan 2001
Providian bank wanted to create a data warehouse to store details about the
customer applying for their credit card. The project received data files
from multiple external data suppliers. The contents of the file were
validated and then loaded in Informix data warehouse. The ETL scripts were
written using Informatica tool.
Platforms & Technologies
. Informatica
. Informix database design
. Informix Stored Procedures
. Visio
. Perl Scripting
Project Role
. Developing and Implementing Informatica Mappings
. Informix Stored Procedures
. Informix High performance Loaders
. Designing Star DW schema
Contact this candidate