Boris Mogilevsky
e-mail: [Send email using form at bottom]
cell : (248)910-8327
home : (248)932-9759
EXPERIENCE Data Warehouse Developer/Analyst Last ten years spent in Data
Warehousing field designing and building Data Warehousing applications using
TERADATA, ORACLE, SYBASE SQL SERVER databases and various BI
tools.Responsibilities included: ETL, Database Design and Administration,
Business Intelligence
KEY SKILLS Design, development, implementation and project leadership of
Teradata, Oracle, Sybase SQL Server, Sybase IQ Server, INFORMIX, IMAGE, IMS,
DB/2, ADABASE, PARADOX,CLIPPER, FOXBASE, TURBO PASCAL systems. Business
intelligence tools used – Business Objects, COGNOS, S-DESIGNOROther software
tools used – DATASTAGE, DEVELOPER 2000, COBOL, PL/1, EDI WINDOWS, POWERHOUSE.
CERTIFICATIONS TERADATA V2R5 Certified ProfessionalTERADATA V2R5 Certified SQL
SpecialistTERADATA V2R5 Certified Implementation SpecialistTERADATA V2R5
Certified Application DeveloperTERADATA V2R5 Certified Design Architect
EDUCATION Polytechnic Institute, Bachelors Degree in Computer Science. Riga,
Latvia
VISA STATUS US Citizen
WORK HISTORY NCR – Teradata (April 2006 – February 2009) Teradata
ConsultantIntercontinental Hotels GroupORACLE to TERADATA Data Warehouse
conversion project which included:· Converted reporting environment from ORACLE
to TERADATA, which included 50 Universes and 30 Reports· Performed DBA tasks on
TERADATA Data Warehouse(table and view creation, perm and spool space management,
PPI and SI design, user permission assignment)· Technical project management of
the offshore resource team(requirements definition, test plan definition, unit
test result review, integration testing) for Business Objects and DBA
tasksVERIZON BusinessWorked on developing interfaces from Financial Data
Warehouse to Profitability Analysis application which included:· Project
definition · Program and project requirements gathering and documentation
· Database design specifications for existing and new tables· Software
development and implementation using TERADATA BTEQ utility NBC Universal
Studios(proof of concept)· Worked on Business Objects Implementation· Converted
reporting environment from Oracle to Teradata. This included migrating existing
Universes and Reports. · Conducted performance benchmarking of Business Objects
queries. Worked on Business Objects SQL optimization.· Managed offshore resource
team engaged for Unit Testing.Nissan· Developed reports for Early Warning System
– Nissan POC using TERADATA and Business Objects. Nationwide Insurance· Worked on
a data mining initiative - software development and implementation of analytical
data sets and customer scoring models from Customer Knowledge System (CKS) data
warehouse using TERADATA BTEQ, FASTLOAD and MULTILOAD utilities and Teradata
Warehouse Miner software tool.Wellpoint· Assessed of the existing Account
Reporting system for the areas of Claims and Membership. Developed a proposal
with a set measures for performance improvement on the TERADATA database and
Business Objects reporting sides. Hershey Company· Worked on Point of Sale
Enterprise Data Warehouse ETL process including unit and integration testing
using TERADATA BTEQ, FASTLOAD utilities, KORNE SHELL and MERCURY Test Director,
sourcing data from SAP/R3 and SAP BW. Resource Technologies Corporation (February
2000 – April 2006)Data Warehouse DeveloperFord Motor Company· Developed and
supported batch processes for various FORD Authorized Dealer Parts Sales
Reporting applications using TERADATA SQL, MULTILOAD, FASTLOAD, FASTEXPORT
utilities and COBOL.· Development and supported batch processes for various
Marketing and Sales Retail Incentive Programs (Medallion Elite Club, RMI/RPM, Be
the Best, Keep it Genuine, Big Summer Brake, A/C Compressor Cool Cash) using
TERADATA SQL, MULTILOAD, FASTLOAD, FASTEXPORT utilities.· Developed star schema
data model and developed ETL process for Unit in Operations data
using TERADATA SQL, MULTILOAD, FASTLOAD, FASTEXPORT
utilities.· Developed new ETL processes for Unified Database Data Warehouse using
TERADATA SQL, MULTILOAD, FASTLOAD, FASTEXPORT utilities, COBOL and KORNE
SHELL.· Developed new universes and reports for Unified Database Data Warehouse
and eReact program using BUSINESS OBJECTS.· Documented existing load processes
using SDM methodology.· Gathered information for 2004 Sarbanes-Oxly Compliance
program - Control Process and Corporate Standard categories.· Participated in
regression testing for V2R5 TERADATA implementation.· Performed daily and monthly
batch process restructuring for the performance enhancement purposes.Chrysler
Corporation· Supported existing batch processes on UNIX SUN SOLARIS platform from
SYBASE database servers and IBM DB/2, using COBOL, KORNE SHELL, SYBASE SQL SERVER
and SYBASE IQ SERVER stored procedures.· Supported user reporting requirements -
administered COGNOS IMPROMPTU catalogues.Dataspace Corporation (November 1998 –
January 2000)Data Warehouse DeveloperVolkswagen of America· Developed Claims
Warranty reporting subsystem including: - Report specifications development using
existing COBOL and FOCUS reports, reports and extracts for client/server
application using DEVELOPER 2000, SQL and PERL. - Reports
development for Claims Warranty Data Warehouse using Business Objects. Detroit
Medical Center· Developed ETL jobs for Purchasing History Data Warehouse using
DATASTAGE.Complete Business Solutions(COVANSYS) (November 1997 – November
1998)Technical LeaderFirst Chicago NBD· Defined requirements for various
interfaces-data warehouse, funds transfer pricing, match funded, transfer rate,
teller strip, central files for HOGAN, lockbox, SAP ISB.· Developed TRANSACT SQL
scripts.· Developed conversion programs for the abovementioned interfaces on IBM
mainframe side using COBOL.· Tested results of Year 2000 conversion project for
Leasing application using PL/1, COBOL/VSAM, JCL, FILEAID, XPEDITOR, PLAYBACK,
VIADUCT and DATEFIND.Perot Systems Corporation(April 1995 – November
1997)Business Analyst/Systems Engineer IIRouge Steel· Developed EDI system for
outside processors using GENTRAN:EXCEL, GENTRAN:SERVER, PERL and
COBOL/IMS.· Developed and maintained application software for outside processing
and customer service departments using COBOL/IMS. Hayes Wheels· Developed
shipping/receiving front-end system using PARADOX, ORACLE, ORACLE
APPLICATIONS INVENTORY module.Cadillac Plastic· Developed EDI Purchasing system
using GENTRAN:MENTOR, COMMERCE:CONNECTION, COBOL/IMS, COBOL/CICS.· Maintained
accounts receivable and order entry systems using COBOL/IMS and
COBOL/CICS.· Participated in implementation of ORACLE INVENTORY for
Australia-New Zealand and USA divisions using ORACLE, SQL, SQL*LOADER,
COBOL/IMS/VSAM/CICS.· Consulted CADILLAC PLASTIC customers on bar coding
hardware/software acquisition and implementation.I&E Inc.(Independent
Contractor)(October 1994 – March 1995)Programmer AnalystDomtar Gypsum· Maintained
order processing, accounts receivable, accounts payable and sales history
application systems using IMAGE and POWERHOUSE.· Performed EDI maintenance duties
for order processing application systems using EDI WINDOWS.Trinary
Systems(September 1993 – October 1994)Programmer AnalystRyken Tube
Manufacturing· Developed direct ship system using IMAGE, POWERHOUSE and
FORTRAN.United States Medical Laboratories· Developed physical data model of
Month End lookup system using MS ACCESS and
S-DESIGNORMetpath· Maintained laboratory claims processing system using IMAGE
database, COBOL and POWERHOUSE.HealthPlus of Michigan(May 1992 – September
1993)Programmer AnalystHealthPlus of Michigan· Generated reports for claims
processing, membership, provider, prescription drugs and referral application
systems using IMAGE, POWERHOUSE and COBOL.BASPOL(September 1990 – March
1992)Senior Programmer Analyst/Project LeaderElgava and Kraslava Milk Processing
Plants · Designed, developed and maintained general ledger, payroll and accounts
payable applications using FOXBASE, TURBO PASCAL and CLIPPER.Grain Industries
Computing Center(April 1988 – September 1990)Senior Programmer Analyst/Project
Leader· Designed, developed and maintained accounts payable and accounts
receivable application systems for various grain processors using ADABASE and
NATURAL.SYSTEM Corporation(March 1987 – April 1988)Senior Programmer
Analyst/Project Leader· Designed a major warehouse inventory management project,
which included shipping/receiving, accounts payable, accounts receivable and
inventory material management.Light Industries Research Laboratories(January 1980
– February 1987)Programmer Analyst· Developed and maintained application software
for inventory material management using PL/1/VSAM.
|
