Data Warehouse
Resume:
ALBERT AYNLENDER
Encino, CA 91316
****************@*****.***
SUMMARY:
. 22 years in Computer Science related positions.
. 15+ years expert level experience working with databases ( Oracle / SQL
server / DB2 / Sybase / Netezza )
. 15+ years of development using SQL, PL/SQL, T-SQL, NZ/SQL.
. 11+ years of ETL development ( primarily Informatica) . Expert level.
. 11+ years as Lead Data Warehouse Developer /Data Warehouse Architect
including 2 years as a Data Warehouse Manager
. 11+ years designing and implementing Decision Support Systems, Marketing
Databases, Data Warehouses, Data Marts.
. Expert in SQL and performance tuning for Data Warehousing queries.
. Experience in UNIX/Linux and Shell Scripting
. Experience in MicroStrategy..
. 11+ years experience in Full Project Life Cycle of Data Warehouse and
Database design using Ralph Kimball's dimensional model (Star schema and
Snow flake schema)
. 2+ years of experience working in Agile environment.
. 10+ years experience in using Data Modeling tools Erwin,ER/studio, etc
. Comfortable working independently or as part of an integrated team;
Ability to work under pressure and time constraints.
. Self-motivated and results oriented collaborative thinking, experienced
in managing multiple competing priorities and tasks effectively across
multiple functional tracks.
. Strong Communication and Documentation skills .
SOFTWARE: INFORMATICA POWERMART/POWERCENTER ORACLE, PL/SQL,
Netezza, NZSQL MicroStrategy, SYBASE, TRANSACT-SQL,,SQL
Server, stored procedures, triggers, DTS,, ARDENT
DATASTAGE, ETL, Erwin / ERX, UNIX, UNIX Shell Scripting,
HTML, Actuate, OLAP (dbProbe), POWERBUILDER, SQR, SP-
Debugger, DBArtisan, Utilities (vi editor, oracle
export/import oracle sqlplus, bcp, ftp, isql), Word, Excel,
Powerpoint, Visio, VSS, Perforce,Business Objects, First
Logic, DB2 / UDB Stored Procedures, COBOL2, DB2, CICS,
JCL, VSAM, TSO/ISPF, File-Aid, SPUFI, QMF, INTERTEST,
FORTRAN, FOXPRO, Foxbase, Dbase.
PROFESSIONAL EXPERIENCE:
Technicolor.
02/13 - current BI MANAGER (Temp position)
Actively participated in support, enhancement and new
development for the existing subject areas of the BI systems .
Major BI systems are HES NA (home entertainment data for various
clients) and TPR (related to DTV product testing). The "Chart
9" project was an extension to the SPC system (statistical
process control) system already in place for the Quality and
Operations departments of Technicolor. Data warehouse is Oracle-
based and Informatica is being used as a main ETL tool.
. Managed two offshore ETL developers.
. Defined process flows for ETL applications based on
requirements.
. Coded complex Informatica mappings, sessions and
workflows.
. Tuned SQL queries and Informatica workflows for optimal
performance.
. Developed and implemented test plans for ETL.
. Provided guidance to team members
Harbor Freight Tools.
02/12 - 02/13 Consultant
Client is a large retail company with over 400 stores.
ETL (Informatica 9 ) is being used as a main tool to
create interfaces between multiple applications ( different
flavors of WMS, POS systems, Legacy applications, DWH,
etc.) ; Infornatica-based mapping/sessions/workflows provide
data transformation synchronization, validation and
reconciliation, basically enabling different subsystems to
"talk" to each other.
Information resides in multiple databases (Oracle / SQL
server / UDB / Netezza) as well as XML and flat files
. Analyzed and clarified the business requirements with
business analysts and Users.
. Created technical specifications.
. Defined process flows for ETL applications based on
requirements.
. Coded complex Informatica mappings,sessions and
workflows.
. Tuned SQL queries and Informatica workflows for optimal
performance.
. Developed and implemented test plans for ETL.
. Provided guidance to team members
. Conducted technical interviews.
Oversee.net
11/10 -02/12 Senior Data Warehouse Developer/
. For "Sales Dashboard" project
Front end ( Microstrategy ) :
Designed and built Microstrategy schema objects .
Developed logical model, building hierarchies, attributes and
facts, extracting tables from warehouse.
Created Application Objects like Metrics, Filters, Custom Groups, etc.
Created Transformations (table based, formula based) for using
in comparative reports
Created various Microstrategy reports and dashboards ( including
complex freeform SQL based reports)
Managed User groups, assigned privileges to the users
Back end ( Netezza Twinfin) :
Created and populated support tables to be used in Microstrategy
transformations
Created db views to improve report performance ( by reducing
number of steps in microstategy generated SQL)
Additional responsibilities included support and maintenance of
existing Netezza-based data warehouse,
Data modeling and redesign..
Edmunds.com
05/05 - 09/10 Senior Data Warehouse Developer/ Data Architect /
Manager of Data Warehouse.
For the last 5 years acted as a Senior Architect in the design,
build & implementation of most Data
Warehouse Projects / subject areas such as "Leads", "OEM
report card", "Offermatica", "Advanced Traffic
Reporting", "InsideLine redesign Edmunds2.0",etc .
. Led the Architecture and design of the data warehouse.
. Evaluated design alternatives.
. Created comprehensive test cases and led departmental effort
in POC of different appliance solutions ( Netezza,
Greenplum, Vertica etc
. Created Netezza NZSQL stored procedures to dynamically create
views based on user-defined metadata
tables to enable/simplify ad-hoc access for business
analytics group.
. Analyzed and clarified the business requirements with
business analysts and Users.
. Analyzed the source systems for data warehouse.
. Participated in requirements gathering, design process, and
code reviews.
. Created technical specifications to address business
requirements and functional documentations.
. Defined process flows for ETL applications based on
requirements.
. Defined and allocated tasks for the teams members.
. Coded complex Informatica mappings and workflows for DIMs and
FACT table loads.
. Coded PL/SQL procedures, functions, views.
. Tuned SQL queries and Informatica workflows for optimal
performance.
. Evaluated/Compared Netezza NZ/SQL functionality VS Oracle
PL/SQL.
. Participated in Implementation of Netezza TwinFin appliance
into the DWH.
. Managed and led the performance tuning and query
optimization.
. Developed and implemented test plans for ETL.
. Anticipated potential problems and proactively recommended
creative "big picture" solutions.
. Provided guidance to team members
. Conducted technical interviews..
Disney. Buena Vista Home Entertainment
03/04 - 04/05 Consultant
Worked on Informatica mappings and workflows to create
multiple inbound and outbound interfaces for Siebel system.
Developed DB2 /UDB stored procedures and Siebel EIM scripts,
coded Unix shell scripts. Combined DB2/UDB database stored
procedures, Informatica workflows and Unix shell scripts to
provide process automation. Participated in the full cycle
system testing for release 2.0. Supported ad-hoc user requests
and provided production support for existing interfaces.
Pfizer (Agouron Pharmaceuticals), La Jolla CA
01/02 - 12/03 Senior Programmer / Analyst
Worked with team to develop and rollout Agouron's Commercial
Sales and Marketing Operational Data Store (ODS), Data
Warehouse, and Data Marts using Oracle, Informatica, and
firstLOGIC (data cleansing and match/merge). This complex system
includes full cycle integration with Dendrite's Webforce Sales
Force Automation (SFA) system, and interfaces with Pfizer's
PeopleSoft, XMS and Livelink systems. The environment
incorporates 5 different external and internal sources, and
contains more than 15 facts and 20 dimensions in the data
warehouse, 50 tables in the ODS, and over 350 ETL mappings.
. Performed four major successful ETL enhancements to a sales
operational data store, data warehouse and data
marts. Wrote detailed design specifications, test plans and
turnover documents.
. Developed and maintained interfaces to corporate PeopleSoft
human resources data as well as the sales force
automation system based on Dendrite's WebForce, permitting
Agouron to create a comprehensive view of the employee
and customer data for detailed business analyses.
. Engineered key interfaces to MAPS software, allowing
incentive compensation to perform major sales
force territory re-alignments.
. Implemented FirstLogic address-cleansing design improvements
resulting in increased cleansing
efficiency.
. Played lead role in consolidating all release enhancements
for entire development team and migrating them
between environments, following SDLC guidelines.
. Helped with design and maintenance of the Business Objects
universes for reporting. Created and
optimized SQL -override queries for several very complex BO
reports.
. Participated in data modeling using ERWIN.
Walt Disney Internet Group, North Hollywood CA
03/01 - 11/01 Senior Engineer
Developed new functionality and supported production
processing for Global Customer Database (GCD) system. This is a
central in-house CRM data-mart, which allows marketing
department to cross- reference customers registered with
different Disney' affiliated web sites . GCD feeds both Epiphany
and Business Objects front end systems . GCD consists of about
40 tables. The largest table has about 35 million rows. For
different parts of the load process developed very complex
Informatica's mappings/sessions/batches, multiple DTS packages
and heavy stored procedures. Actively participated in data
analysis, design and process optimization.
InterWorld New York, NY
06/99-12/99 Consultant
01/00 - 03/01 Senior Engineer
All development is done simultaneously on both platforms
supported by InterWorld - ORACLE/UNIX and SQL server /NT. As a
hands-on Lead Developer participated in a full project life
cycles of two chronologically
overlapped projects:
Datawarehouse / Datamart project
Over 150 tables, about 200 INFORMATICA mapping/sessions.
Commerce Intelligence 3.0 (GA second quarter 2000) and Commerce
Intelligence 4.0 (GA fourth quarter 2000)
Source data resides in 5 Oracle schemas (or 5 SQL Server
databases) plus extended web log files and
additional files from the search engine.
INFORMATICA ETL is used as a primary tool for data extraction,
transformation/cleansing, full and
Incremental update of the tables in centralized data warehouse.
Designed Informatica Mappings. Coded most complex ones (about
60). For remaining mappings, provided
specifications to the team members, coordinated and validated
their work. Created sessions and batches using INFORMATICA
Server manager. Maintained base Erwin diagrams and SQL scripts,
generated DDL. Was responsible for version control.
Dataextraction / Datamigration project
Over 300 tables / 350 mapping/sessions
Migration from Commerce Exchange 2.5 to Commerce Exchange 3.0
Ardent's Datastage ETL tool (similar in functionality to
INFORMATICA) has been used for the migration process.
Performed ORACLE SQL optimization and tuning.
Coded UNIX scripts and performed Export / Import of the data.
Created Dblinks and synonyms to provide coding transparency for
developers.
Performed heavy customizations for one of the Interworld's major
clients - DISNEY.COM . During 3 months worked at client location
( North Hollywood). Coded over a 100 custom mappings. Coded
Additional ORACLE (PL/SQL) stored procedures in order to achieve
a better performance. As of end of August new Disney's site went
live with a big success. (About 15 million rows were migrated
under 6 hours)
. As a lead SQL expert conducted all technical interviews for
the department.
. Closely worked with ACTUATE and MICROSTRATEGY developers,
reviewed and optimized SQL used for reports,
identified additional tables and views for the Data Warehouse
needed to reduce reports development time and
speed up data access.
. Participated in various meeting to evaluate vendor's software
.
. Converted high-level user requirements from Marketing into
technical Requirements for use by
Engineering.
. Produced various prototype reports to identify and illustrate
customer's purchasing trends. (using
Actuate)
. Created multi-dimensional Cubes using OLAP tool (dbProbe).
. Developed stored procedures for data migration ( ORACLE and
SQL Server )
. Fully supported QA organization. Having insight of the data -
Proposed special naming conventions for test data
elements and integrated testing plan for regression testing.
A.I Credit Corp. (AIG). New York, NY
09/98 - 05/99 Consultant
Participated in design, development and implementation of
Leasing System.
System supports both domestic and international leasing, creates
bills and invoices, handles Transaction
Processing such as buyouts, refinancing and renewals; and also
provides asset management reporting.
. Performed data analysis and database design.
. Developed SYBASE stored procedures and triggers.
. Created UNIX Shell Scripts for batch processing.
. Developed GUI user interface using POWERBUILDER.
. Created batch reports and maintenance programs using SQR.
. Communicated with users.
. Wrote system documentation and on-line help.
. Performed testing, debugging and troubleshooting.
Societe Generale (SG COWEN), New York, NY
10/96 - 09/98 Assistant Treasurer. IT ( Senior Programmer)
Designed, developed and implemented "Netting" processing with
GSCC (First implementation for International Bank in United
States). System provided a convenient way to process "end-legs"
of the
Repo trades, and allowed to significantly increase trading
activity with other GSCC participants. Sybase, stored
procedures, triggers, Powerbuiler, Unix Shell scripting and
scheduling were used.
Participated in development, modifications, enhancements and
production support of Real Time In-house developed Internal
Clearance System (ICS). This system supported back-office
operations. System is used to send trade information to the
Federal Reserve Bank, receive back advices, match them with
original instructions, maintain real time box position, etc.
System utilized Powerbuilder, Sybase, stored procedured,
Triggers, Unix Shell Scripting and SQR.
Analyzed data flow, designed and developed various
Reconciliation reports between ICS, General Ledger and Traders
Database.
Responsibility included data base analysis, design,
implementation, performance tuning, heavy user interactions,
user training and production support.
Participated in development of Credit Risk Monitoring System.
Powerbuilder, Sybase.
Participated in remediation of Powerbuilder applications, Sybase
stored procedures and SQR reports for Y2K compliance.
Smith Barney Inc., New York, NY
01/94 - 10/96 Senior Programmer Analyst
Performed full project life cycle of Reaction System for
Technical Research Group.The system scans Reaction stock
universe, flagging stocks with important technical signals.
For each client's account system creates a copy of Reaction
report on a weekly basis. Online part provides GUI interface
to maintain support and resistance levels, trend changes,
opinions, comments as well as client accounts and Reaction
stocks universe. System is based on Sybase, stored
procedures, Triggers Powerbuilder, SQR.
Designed, developed and implement Close-End Funds and Close-
End Country Funds Systems. The systems provided various
calculations, reports and recommendations. Powerbuilder,
Sybase, stored procedures were utilizedParticipated in
development and implementation of the external data feeds for
different applications for the Research department from
various vendors such as IDD, Lipper Analytical Sevices,
First Call, etc.
Utilized Unix Shell Scripting and tools such as BCP, FTP and
ISQL
Designed, developed and implemented mainframe programs to
create data feed for client/server systems such as Earnings
Estimates, Statistical Summary and Model Portfolio Systems.
Performed enhancement and modifications to the Equity
Research Distribution System in COBOL2/DB2/CICS environment.
Ellipse Consulting, New York, NY
02/92-12/93 Programmer/Analyst
Participated in development and implementation of Cash
Management Account System using
COBOL, CICS and DB2. The system provides ability to open and
maintain customer's account.
Account reporting subsystem allows users to produce reports
showing all transactions including stocks,
options bought and sold, interest on a account cash balances
earned and interest on margin amount charged
Teza Inc., Chisinau, Moldova
08/87-10/91 Programmer/Analyst
Participated in creating and development
of an on-line Materials Supply & Inventory Management
System, which
allows users to receive a complete
information about products manufacturing, distribution,
prices and availability.
The system utilized COBOL, CICS, DB2 and
VSAM.
Participated in various projects using
FoxPro, Foxbase, Dbase .
Education:
1982 - 1987 Chisinau Polytechnic University, B.S. in
Mathematics.
References: Available upon request.
Contact this candidate