WENDY BEZOTTE
Cell Phone [Send email to request phone number] 08-9248
[Send email using form at bottom]
TECHNICAL SUMMARY
An experienced Data Warehouse Developer and Project Manager with proven skills
in problem solving and database design. I have experience with all stages of
development lifecycle: Requirements gathering, design, development, construction,
documentation, testing and implementation. Good knowledge of multi dimensional
data modeling and relational data modeling, including star and snowflake schemas.
I also have excellent written and verbal communication skills. Ability to
interact with clients at all levels. Demonstrated ability to lead and mentor a
team to provide exceptional service to business partners.
TECHNICAL SKILLS
MS Project, Visio
Informatica PowerCenter 7.0
IBM Data Stage 7.5
Cognos Transformer
Cognos PowerPlay, Upfront
Cognos ReportNet
Hyperion Analyzer Informix XPS
DB2 UDB, DB2 for Windows
Oracle 8i, 10g
Informix 4GL SE, IDS 7.31
Microsoft Office-Word, Excel
MS Power Point
MS Access Unix (AIX), and SUN 4.3
UNIX Korn Shell Scripting
Visual C++, C
Java
AWK and SED
Visual Basic and VBA
ERwin
PROFESSIONAL EXPERIENCE
Pegasys Knowledge Solutions, Inc., Schaumburg, Il 6/2007 Present
Contractor working at Intermatic, Inc., Spring Grove, Il
Information Data Architect Gathered business requirements through meetings
with business sponsors and key business personnel to discover reporting
requirements. Wrote functional requirements and created documentation for use in
data modeling. Designed and maintained data warehouse database. Created
processes to extract data from various sources, iSeries AS/400, Oracle 10g
database, Mincron, Kronos, Agile. Created Backup/recovery procedures for Oracle
10g databases using RMAN scripts. Performed other light DBA duties such as
configuring and setup of Oracle Development and Test Environments, monitoring
databases, user id security and tuning for performance. Performed product
evaluations of databases, ERP products and BI tools and making recommendations
for future Data Warehouse development. Mentored Super Users on use of SQL to
create ad hoc reports. Upgraded DB2 database and Data Warehouse Center from
v8.1.132 to v8.1.6c and then to v8.1.16, by first applying fixpack 6c, then
fixpack 16. Upgraded Oracle Agile PLM software and database from 9.2.2.1 to
9.2.2.3. Installed new Oracle Agile PLM 9.2.2.3 on a new server.
Assurant Health Insurance Company, Milwaukee, WI 12/2006 06/2007
Senior Software Engineer
Responsible for all aspects of ETL processes including design, development and
implementation using Ascential Datastage. Responsible for Production support and
ongoing enhancements to the data warehouse. Demonstrate knowledge of data
warehouse implementation process, from business requirements through logical
modeling, physical database design, data sourcing and data transformation, data
loading, SQL, database and SQL performance tuning. Work closely with data
warehouse architect and business intelligence analyst in developing solutions for
business users. Maintain data model, design and development for the data
warehouse. Analyze source system data structures and map them to target data
warehouse schemas.
Hewitt Associates, LLC., Lincolnshire, IL 10/2000 10/2006
Business Intelligence Data Warehouse Infrastructure Developer
Responsible for systems analysis and infrastructure analysis and design.
Responsible for development of Extract Transformation and Load (ETL) scripts to
extract data from legacy systems and load into the data warehouse and datamarts.
Coordination of the data loads into all environments (Development, QA, QC,
Production). Work with offshore team for coordinating offshore production
support. Informatica administration of security and setup of repository
structures. Provide project management for smaller projects or for pieces of a
project. Estimate tasks and resources required to design and build the code.
Build a schedule that allows enough time for each stage of the process: design,
development, configuration, testing, documentation, migration, and contingencies,
accounting for workload and resource considerations and dependencies. Responsible
for keeping the project team on schedule and meeting release deadlines and
expectations. Note scope changes and work with the Business Analyst and/or
Project Sponsor to make appropriate business decisions and adjust resources and
deadlines accordingly. Communicate team schedule and status information to the
team and development group leader.
PLAN SPONSOR SITE WAREHOUSE PROJECT
Gather requirements
Data modeling
ETL Development
Automate Batch Processing of Cognos processes
Mentoring Junior Developers
MULTI PROCESS HR OUTSOURCING WAREHOUSE PROJECT
Project Management
ETL Analysis and Development
Enhanced Processes for Performance and Efficiency reduced run time of fact
load by 200%.
Created UNIX script used across all clients to load to the Cognos Access
Manager
ETL Administration and Data Management
Act As Mentor For Other Developers
PNC Mortgage Securities Corp., Vernon Hills, IL 4/1991 10/2000
Programmer II-Group Leader 3/1996 10/2000
Successfully lead a team of programmers and data specialist in providing
exceptional support to business partners. Determine work flow priorities,
resource allocation, and assisting in developing best business practices.
Responsible for production support for 6 Unix/Informix based systems. Created
and facilitated SQL classes for end users. Develop and implement small
enhancement projects utilizing Informix 4GL, Ace Reports, UNIX scripting, SQL and
C programming languages. Write and enhance 4GL, Ace Reports, Unix Shell scripts
and C programs to user specifications. Solve daily problems and interact with all
levels of business clients. Write project proposals, detail designs, and develop
and test new system functionality. Act as a business consultant to Master
Servicing and Security Processing Departments.
Data Specialist -Master Servicing Department 1/1992 3/1996
Liaison between I/T, Security Processing and Accounting departments to
coordinate the processing and analysis of loan level data. Insure accurate
loading of bulk and conduit purchases of mortgage loans, thru a series of ad hoc
SQL data cleansing processes I developed. Set up system parameters according to
legal documents. Recommend system enhancements. Perform user acceptance
testing for system projects. Train end users on enhanced versions of the system.
EDUCATION
Bachelor of Science in Economics, December 1988
Northern Illinois University, Dekalb, Illinois
Minor: Psychology
College of Lake County
Grayslake, Illinois 1983-1986
CONTINUING PROFESSIONAL DEVELOPMENT
Triton College, Chicago, Illinois 1994
Illinois Mortgage Bankers Association
Fundamentals of Mortgage Banking
College of Lake County, Illinois 2002-2003
Intro to Java Spring 2003
Intro to Visual C++ Fall 2003
|
