Data Warehouse Sql Server
Resume:
Alex Treyster
* *** ***** ******, ********, CT **070 • 860-***-****, 860-***-**** • *******@***.***
PROFESSIONAL SUMMARY
Highly talented, hands on, Data Warehouse Architect/DBA/Developer with subject matter
expertise in the development and optimization of large Oracle Data Warehouses, Oracle and SQL
Server Database Administration, Oracle Toolsets, Brio, Business Objects and Informatica.
Leverages over 2 decades of applications development experience including foundational skills in
structured methodology in the former Soviet Union and since 1994, in the United States.
Led and mentored a team of up to 50 developers.
TECHNICAL SUMMARY
Oracle, SQL Server, DB2, Oracle toolsets, PL-SQL, T-SQL, Informatica, SSIS, ERwin, BRIO,
Business Objects, UNIX/XENIX Shell, Perl, Visual Basic, C, Access, FoxBase, PL/1, JCL,
COBOL, SDLC, Data Warehouse, Data Mart, Data Vault, Agile.
PROFESSIONAL EXPERIENCE
Robert Half Technology, KFORCE, TRI, Talus Hartford, Connecticut 2010 to Present
Consulting Services
Data Warehouse Architect / Data Modeler / DBA / Developer
Active provider of consulting services of the development and enhancement of data processing
systems
• Provided analysis, prepared and implemented recommendations on the
development of large systems and Data Warehouses:
• Built methodology for creation a business model as the base for data model
reflecting business components, business events and relations between them.
• Built methodology for creation a Real Time Enterprise Data Warehouse without
staging area.
• Built approach of simplification a complicated data model using meta-entities.
• Builds architecture and all data models of multi-time-zone Real Time Enterprise
Data Warehouse for thousands Housing Authorities all over the country using Data
Vault, Data Mart and Agile methodologies.
• Developed BI for America-Europe Solvency II project in XL Capital insurance
company – including data modeling and integration for General Ledger reports.
• Developed Financial Data Mart using SQL Server, ETL Informatica, ERwin and
SSIS.
• Opened blog “Information Technology Organization” (http://alex-t-ito.blogspot.com/)
which followed by more than 2000 IT architects all over the world.
• Improved performance and efficiency of databases and applications:
• Analyzed sporadically appearing performance issues for Renzulli SQL Server
international learning system with 0.5 million users.
• Prepared recommendations for modification of database parameters necessary to
resolve the performance issue and monitor the operation system and network.
• Enhanced existing systems and designed and developed new applications:
• Provided emergency room and bed management data modeling for Hartford
Hospital based on Sybase and SQL Server data.
• Designed and built Informatica ETL programs for the integration of the Emergency
Department information dashboard at Hartford Hospital.
The Hartford Windsor, Connecticut 1998 to 2010
Group Benefit Division
Data Warehouse Architect / Data Modeler / DBA / Developer
Key member of the Data Warehouse team with the following responsibilities:
• Design, development and support of the Oracle Data Warehouse (7 terabytes),
multiple Data Marts and applications:
• Gather and analyze business requirements. Worked with business partners,
business systems analysts and developers to ensure that selected solutions satisfy the
requirements.
• Design logical and physical data models and data processing infrastructure,
collaborated with data subject matter experts.
• Provide production database support, enhance existing system and design and
develop new systems.
• Monitor the usage of database space and performance.
• Performance optimization of the database and applications.
• Resolve on-call issues for hundreds of production databases.
• Proactively work with other Data Warehouse team members and with the members
of other teams (business customers, analysts, developers, DBA’s and technical support
staff) to create innovative analytical solutions.
• Mentor developers and other DBA’s on the adoption of database standards and
best practices.
Achievements included:
• Methodology Development:
• Created an enhanced methodology for improving database performance that
incorporates analysis of CPU time usage and analysis of data input/output rates.
Adoption of the enhanced methodology has significantly improved performance over
traditional methods (such as SGA resize operations and tuning performance of
queries).
• Detected a pattern where Data Warehouse calculations were increasingly shifting
from regular OLTP to scientific calculations. That finding was used to properly procure
and configure new Data Warehouse servers.
• Modified the Data Warehouse release process to appear seamless to users,
eliminating shutdown and access disruption.
• Database Improvement:
• Routinely resolved some of the most complex and critical Data Warehouse
database performance issues.
• Created and architected the 2010 Plan of Development for Data Warehouse
performance improvement initiatives. The plan was implemented as a multi-project
initiative.
• Improved Oracle Data Warehouse performance issues by eliminating up to 50% of
the 700 Gigabytes generated by Oracle standard CDC staged data.
• Application Performance Improvement:
• Designed new Oracle database views with Optimizer hints that enabled significant
performance improvement within Business Objects reports (in several cases report
runtime changed from 2-3 hours to a minute or less).
• Designed and implemented Oracle logon triggers to embed ‘alter session’
commands into BRIO reports that extended available memory and significantly
reduced the reports’ runtime.
• Utilized Informatica’s powerful data transferring capabilities instead of BRIO
internal tables to significantly improve the performance of the BRIO reports.
• Created a solution based on utilization of Oracle temporary tables that allows
multiple users to run the same BRIO report with different data simultaneously instead
of sequentially.
• Automation:
• Automated process of terminating database users for hundreds of databases that
significantly freed up time for the DBA team.
• Wrote Perl programs that simulated DEC OS indication of file, and simulated the
“at” UNIX command for scheduling jobs in a non-accommodated environment.
• Development of standards:
• Created and facilitated the adoption of a new standard that eliminated database
links between different database environments.
• Modified standard Oracle script allowing automatic purging of StatsPack repository
data.
Equifax / ChoicePoint Hartford, Connecticut 1995 to 1998
Programming Resources Company (PRC)
Senior Programmer
Key member of the Workers Compensation application team in support of over 40 client Insurance
companies:
• Designed, programmed and maintained a front-end Workers Compensation
application in Visual Basic. Trained and mentored new VB programmers.
• Designed the structure of the Oracle and SQL Server databases for Workers
Compensation systems. Played role of a primary PRC interface with the Microsoft team for
SQL Server projects.
• Created programs to populate, store and transfer data between databases.
Personally conceived of and implemented a new process that automated the mapping and
conversion of company source data and saved PRC over 25 million dollars.
Petrovsky Corporation Dnepropetrovsk / Moscow, USSR 1980 to 1994
Architect / Analyst / Data Modeler / Lead Developer / Manager
• Designed, developed and maintained corporate and manufacturing applications systems
and Data Warehouse for Metallurgy, Machinery-Building, Natural Gas and Pharmaceutical
industries.
• Personally developed company SDLC methodology.
• Led and mentored a team of up to 50 developers.
• Published 12 articles on data processing and math modeling in Russian scientific journals.
• Worked as part-time University instructor of Information Technology.
EDUCATION
Data Processing School of the Metallurgical Academy, Dnepropetrovsk, USSR
Masters in Computer Science.
Graduated Summa Cum Laude, ranked first in class.
Contact this candidate