Tech Team Lead
Data Warehousing Team Lead
Highlights of my professional career include:
- 12 years of experience in software development
- Direct leadership of up to 6 person teams, including technical and personal development
- Strong Experience in data modelling and developing for DW and OLTP on Oracle and IBM PureData (Netezza) for Banking and Retail.
- Proven track record of successful project management
- Hands on experience in Client Communication, end user training
Led a number of successful development projects of a 48TB data warehouse for a major retailer.
Applied and evolved an Agile SDLC for rapid, accurate delivery of client requirements
Acted as Scrum Master on client calls, ensuring a smooth communication flow with the client
Gained strong experience in Dimensional (Ralph Kimball) methodology. Designed Marketing subject area; contributed to evolution of Retail and Clickstream warehouse and mart models.
Directly managed a team of up to 6 people. Coached and groomed a successor for myself.
As a technical leader, performed a range of tasks from technical design to code reviews.
Gained an expert understanding of Netezza platform, achieved a Developer certification.
Devised and executed training classes on MPP query optimization, other best practices.
Designed and developed an ETL flow around IBM DataStage, decreasing update cycle by 40%.
Designed and oversaw development of a regression test environment for the DW implementation, enabling a successful iterative delivery model.
Organized and delivered client-facing multiple training session
Successfully worked with clients from top of 20 Ukrainian Banks several projects resulted in the brand new products in Banking
Acted on different positions in projects:
Investigated business flow and collected requirements as a business analyst.
Created requirement specification and decomposed requirement specification into tasks for developers.
Planned projects and oversaw
Led team to successful product delivery to clients
Acted as experienced Oracle PLSQL and Delphi developer
Successfully supported clients remotely and on-site.
Long and short term onsite works for application maintaining, end users training and support.
Gained experience of working on different positions in Bank.
Modeled data for Banking, implemented design and business logic. Designed database structure, created database objects and wrote of server-side PLSQL-code and SQL-queries for OLTP systems on Oracle Databases.
Successfully solved performance problems by query performance analyzing and optimization.
Developed front-end parts using Delphi 7
Successfully designed architecture of GL-data (General Ledger data) migration engine from one bank branch into another and implemented it in PLSQL. This let to optimize clients business and increase revenue by collecting separated GL-data into one database. It was used by more than 10 clients to rollup branch network or to transfer data for analytics into DWH
Led development of
“Client Service Wizard” subsystem. Its purpose was to optimize and speed-up client service in banks. It was used by more than 5 clients(banks with branch network)
“Exchange Monitor” application – automated data input\output in different formats into\out of ABS (Automated Banking System). It used more than 20 clients for loading data in and unloading data out of the database.
Specific testing framework for testing PLSQL core of the financial statements (reports) of the Bank. These reports were highly important and were sent to National Bank on daily bases. Failure in report results in fines and penalties.
Developed custom process on PLSQL and Java to transfer and load data from several branches into Data Warehouse built on Oracle RDBMS. Developed procedures for data transformation and tracing data integrity. It was successfully used by client with more than 24 branches all over the country.
Collected requirements, investigated workflow, modeled data, managed project, led development and developed of LegalDB module: automating legal cases management, handling dispute resolution and claims, resource management for the Legal Department of the Bank.
Led team of the UI and Oracle developers, acted as Project Manager, successfully delivered product which integrated processing centre and Bank
Led and successfully delivered product for management, accounting of the cards in Bank