ETL Architect
Resume:
AAHILA GHOUSE KATHARHUSSAIN
******.*@*****.***
SUMMARY:
• Over 8 years of experience as software engineer in various verticals including Insurance, Banking and Finance, Telecommunication, Media Entertainment and Supply Chain Management mainly involving with clients and business users.
• Over 6 years of Data warehousing and ETL experience using Informatica Power Center 8.1.x/7.1.x/6.2/6.1, Informatica Power Mart 6.2/5.1, PowerConnect, Power Analyzer, Superglue, Metadata Manager, Warehouse Designer, Source Analyzer, mapping Designer, Transformation Developer, Mapplet Designer, OLAP, OLTP, Appworx, Data Quality Workbench, Informatica Data Explorer
• Have extensively worked on Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ) for data and quality analysis.
• Have extensively worked on data conversion projects.
• Over 2 years of experience in Micro Strategy reporting, Reports generated based on the clients business requirements.
• Have extensively worked on Tera Data, DB2, Oracle 9i & 10g, PL/SQL; Having high proficiency in Tera Data & Oracle Performance Tuning Techniques and Analytical Functions.
• Over 4 years of experience in UNIX & Windows environments as an Administrator.
• Over 3 years of experience in administration tasks on ETL Tool, including upgrading, configuration, client installations, deployments, backups, repository management, performance monitoring and improvements, patching, setting up ODBC connectivity to connect to other databases.
• Over 3 years of Dimensional Data Modeling experience using Data modeling, Star Schema/Snowflake modeling, Universal Data Models, FACT & Dimensions tables, Logical & Physical data modeling, ERStudio 7.1/6.1
• Experience in handling XML technologies (DTD, XSD) and worked with XML sources and targets
• Over 3 Years of Business Intelligence experience using Business Objects 6.5/5.0, Designer, Supervisor, BO, WEBI, BCA, ZABO
• Excellent communication and interpersonal skills. Committed and Motivated team player with good analytical skills.
• Highly competent in quantitative and qualitative analysis and critical thinking.
TECHNICAL SKILLS:
Data Warehousing
Informatica PowerCenter 8.1.1/7.1.x/6.2/6.1, Ab-Initio
BI & Reporting
Micro Strategy, Crystal Report
Database
Tera Data, Oracle 10g/9i/8i, MS SQL Server 2005/2000/7.0, UDB DB2 8.x, 9.x, Sybase 12.5, 15.x, PL/SQL, SQL*Loader
Programming
SQL, PL/SQL, Embedded SQL, UML, Unix Shell Scripting, VB
Operating Systems
UNIX (Redhat Linux 5.x/4.x/3.x, Solaris), Windows 98/NT/2000
Testing Tools
Test Director, Quality Center, Load Runner
CERTIFICATIONS:
• Oracle 9i (SQL – PLSQL) Certified Programmer Associate
• TCS Certified Performance Tester.
• Brain bench Certified programmer on RDBMS concepts.
-------------------------------------------------------------------------------------------------------------
PROFESSIONAL EXPERIENCE:
Project Name: Project Underdog Jun 08 – Jan 09
The Walt Disney Company – Consumer Products
Location – Glendale, California
Sr. ETL Architect
Responsibilities:
• Extensively worked on understanding the business requirements and designing Cognos applications.
• Developed ETL scripts to extract and cleanse data from SQL databases for loading into Cognos.
• Created export scripts using Tera data Fast export Utility.
• Created data manipulation and definition scripts using Tera Data Bteq Utility.
• Removed the repository server on windows and installed infa 8 on UNIX.
• Imported all the mapping and workflows to the new repository server on UNIX.
• Have involved in administration tasks including upgrading Informatica, importing/exporting mappings.
• Created and managed the multiple environments, user groups.
• Have done the admin activities like, backup and restore of the repositories
• Have worked on testing and gathering statistics and monitoring the run times for the performances and fixing it.
• Have worked on data analysis to find the data duplication and existed data pattern using a data profiling tool, IDE.
• Have generated few complex business reports/graphs using IDQ, which was being used for understanding, acting and reporting.
Environment:
Informatica PowerCenter 6.2.x & 8.5.1, Teradata, DB2, Sybase, MicroStrategy, SAP R/3
-------------------------------------------------------------------------------------------------------
Project Name: Automated Food Distribution Nov 07 – Jun 08
Target Corporation – Distribution
Location – Minneapolis, Minnesota
ETL Architect
Responsibilities:
• Job role was to collect business process requirements and documentation of requirements.
• Created reports using Cognos and automated scripts to validate the integrity of the data based on end user needs.
• Trained technical and non-technical users on the use of Cognos tools.
• Created load scripts using Teradata Fast load and Mload Utilities.
• Created procedures in Teradata SQL.
• Have prepared the impact analysis document and high-level design for the requirements
• Developed functional and technical specification documents, mappings and exception handler for ETL processes.
• Performed Informatica administration duties including creating users, user groups, and folders, database connections, promoting informatica folders, mappings, sessions and workflows from development to production.
• Have generated few complex business reports/graphs using IDQ, which was being used for understanding, acting and reporting.
• Involved in production support activities including monitoring loads, resolving exceptions and correcting data problems.
• Carried out performance tuning both on informatica side and database side.
• Have involved on performance tuning by collecting statistics and observing explain plan.
• Worked on preparing unit test plans and functional validation.
Environment:
Teradata, Informatica PowerCenter 7.1.2 & 8.1.1, Cognos (Power Play Transformer), AIX, RapidSQL, SAP R/3
-------------------------------------------------------------------------------------------------------
Project Name: Grocery Food Distribution June 06 – Oct 07
Target Corporation – Distribution
Location - India
Offshore Lead - Sr. ETL Developer
Responsibilities:
• Have worked on collecting business process requirements and documentation of requirements.
• Have worked on preparing the impact analysis document and high-level design for the requirements
• Developed functional and technical specification documents, mappings and exception handler for historical conversion, go forward ETL processes and outbound interfaces.
• Interacted with business users and the support team to resolve issues with reports and developed production fixes to rectify the same.
• Involved in Production Support activities including monitoring loads, resolving exceptions and correcting data problems.
• Carried out performance tuning both on informatica side and database side.
• Created Micro Strategy reports.
• Developing mappings to load data from multiple data sources to target.
• Have worked on performance tuning by collecting statistics and observing explain plan.
• Prepared unit test plans and functional validation.
Environment:
Informatica PowerCenter 7.1.2, DB2, MicroStrategy, AIX, RapidSQL
-------------------------------------------------------------------------------------------------------
Project Name: Retail Banking and SME Finance – Public Sector Jan 05- June 06
Industrial Development Bank of India
ETL Developer
Location – India
Responsibilities:
• Worked as data warehouse architect in a public sector company.
• Managed clients’ data in the retail banking to maintain the history.
• Handled the ETL related activates by interacting with other teams on a regular basis.
• Prepared ETL specifications for identifying sources, targets and data transformations.
• Developed mappings to load data from multiple data sources to target.
• Implemented all business related stuffs like portfolio performance, risk management, Asset management using Oracle PL/SQL ,SQL Server TSQL, VB ,ASP and Analytical Function
• Have worked on performance tuning by collecting statistics and observing explain plan.
• Prepared unit test plans and functional validation.
• Designed reports using Crystal Reports 8.0
• Developed business logic using VB and ASP.
Environment:
Oracle 9i, Ab-Initio, SQL-Server2000, VB, ASP and Crystal Reports 8.0
Project Name: Asset Management System & Digital Cockpit Jan 04- June 05
GE Commercial Finance
ETL Developer
Location – India
Responsibilities:
• Handled the ETL related activates by interacting with onsite team on a regular basis.
• Prepared ETL specifications for identifying sources, targets and data transformations.
• Developed mappings to load data from multiple data sources to target.
• Implemented all business related stuffs like portfolio performance, risk management, Asset management using Oracle PL/SQL ,SQL Server TSQL, VB ,ASP and Analytical Function
• Have worked on performance tuning by collecting statistics and observing explain plan.
• Prepared unit test plans and functional validation.
• Designed reports using Crystal Reports 8.0
• Developed business logic using VB and ASP.
Environment:
Oracle 9i, Ab-Initio, SQL-Server2000, VB, ASP and Crystal Reports 8.0
-------------------------------------------------------------------------------------------------------
Project Name: Kintana – Project Management Tool May 02 - Dec 03
GE Commercial Finance
ETL Developer
Location - India
Responsibilities:
• Have worked on requirement gathering and E/R modeling.
• Collected all necessary data for a project to track that particular project.
• Created reports and dashboards in the backend.
• Created and managed workflows for the automated tracking of things.
• Have worked on performance tuning by collecting statistics and observing explain plan.
• Prepared unit test plan (UTP), requirement and system development (RQSD) and functional validation.
Environment
Oracle 9i, JSP & Servlets, SQL-Server2000, ASP and Crystal Reports 8.0
-------------------------------------------------------------------------------------------------------
EDUCATION:
• Bachelor of Engineering - Electronics and Communication - Amrita university, India
PROFESSIONAL REFERENCES:
• Dan Klufas
Sr. Programming Lead, Disney Consumer Products
***.******@******.***
• Paul Cossette
Manager, Disney Consumer Products
****.*******@******.***
Contact this candidate