Sql Server Developer
Resume:
LUDMILA KHABAS
E-mail: < *******@*******.***>
Career Objective: Database Designer/Developer/DBA (MS SQL Server),
Data Analyst, Programmer Analyst, BI Developer
Database Development: Microsoft SQL Server 2012/2008/2005/2000/7.x,
SQL Server SSRS/SSIS/SSAS, MDX, PerformancePoint,
Visual Basic 6.0, Transact– SQL, Red Gate SQL,
Oracle 8i, PL/SQL, Informix 7.23,
Stored Procedure Language (SPL),
MS Access, Excel, Crystal Reports 8.5
Database Design/Modeling Tools: ERwin, S – Designer
EMPLOYMENT HISTORY
Senior Database Developer / BI Developer September 14/ – December 15 TD Bank, Collections & Recovery – Business Intelligence & Data Strategy, Toronto
Creating Reporting systems for Manual Queue and RPMS projects (SSRS, SSAS, SSIS, T-SQL, MDX).
Database design, defining metadata schemas, implementation of complex business rules in a database model (SQL Server 2008 R2, SSAS, MDX, T-SQL).
Creating stored procedures and scripts for data loading, data analysis, problem investigation, and reports.
Development and deployment SSAS cubes and creating ETL for cube processing with dynamic cube partition.
Creating and scheduling SSIS packages for loading data into DataWarehouse from different environments.
Error fixing, enhancement, and changes in existing Reports.
Creating technical documentation for Reporting systems.
Senior Database Developer / BI Developer October/13 – September/14 BMO Financial Group, AML Reporting & Compliance – Corporate Data Management, Toronto
Maintenance and development of AML Reporting system (SSRS, SSAS, SSIS, T-SQL, MDX).
Data Modeling, Reverse Engineering, Mapping tasks.
Identifying and fixing report problems. Working and comparison data from cube and from RDBMS (MDX, T-SQL).
Creating stored procedures and scripts for data loading, data analysis and reports.
Daily monitoring and fixing problems in case of failure of SSIS packages for loading data into DataWarehouse.
Creating and scheduling SSIS packages for data loading into different environments.
Structural changes, enhancement, and error fixing for existing AML Reporting system
Creating technical documentation and System Build Guides (SBG) for creating UAT environment for AML reporting system.
Senior Database Developer / BI Developer / Data Analyst January/13 – September/13 Rogers, Toronto
Creating Reporting system for Rogers Cube project (SSRS, SSAS, SSIS).
Consolidating the data warehouse environment.
Database modeling and design for Broadcast Management System.
Creating and scheduling SSIS packages for consolidation and loading data into DataWarehouse.
Building and querying the cubes (SSAS).
Gather information, analyze the data, and creating month end reports for finance department (SSRS).
Creating complex queries for data analysis and reports.
Backup and restoring of the databases, creating jobs, performance tuning (Profiler and Activity Monitor).
Establishing specific performance tuning procedure (fragmentation report, creating defragmentation and update statistics scripts).
Creating technical documentation (Data Dictionary, Metadata schemas, DB Diagrams).
Senior Database Developer / BI Developer April/12 – December/ 12
Ontario Power Authority (OPA), Toronto
Creating Reporting system for Conservation and Demand Management reports.
Database modeling and design.
Gathering and analysis of business rules.
Implementation of Data Load Validation Frame Work (DLVFMW) to validate loaded data into DW (SSIS).
Build and maintain SQL scripts library for data validation (SQL Server 2008).
Loading data from different sources (Flat Files, Excel, SQL Server).
Creation reports about not valid data (SSRS).
Creation SSIS packages to load data into DW (daily loaded files with relations between them).
Creating complex queries and stored procedures for data analysis and data extraction (SQL Server 2008).
Stored Procedures optimization (SQL Server 2008, T– SQL).
Data analysis, data cleaning, data integrity checks.
Creating reports (SQL Server, SSAS, SSRS, MDX).
Creating technical documentation (Report Specification documents, Data Dictionary, DB Diagrams).
Senior Database Developer / BI Developer January/11 – March/12
LS Travel Retail North America, Toronto
Creating Reporting system (business rules clarification, data dictionary, database design).
Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction (SQL Server 2008)
Development and optimization of Stored Procedures (SQL Server 2008, T– SQL).
Data analysis, data integrity checks.
Building, processing, querying the cubes (SSAS).
Creating reports (SSIS, SSAS, SSRS, MDX).
Determine KPIs for product sales and supplier performance (MDX).
Creating technical documentation
Senior Database Developer / Data Analyst May/10 – September/10
BMO, Toronto (Contract)
Upgrading DTS packages to SQL Server Integration Services (SSIS)
Database design (logical/physical models)
Creating stored procedures (SQL Server 2008).
Resolving DTS Packages Migration Issues
SSIS packages deployment
Tuning and performance optimization in ETL flows.
Creating technical documentation.
Senior Programmer Analyst/ Data Analyst/ Database Developer April/09 – May/10
Carlson Marketing, Toronto (Contract)
Design, development, and maintenance of Reporting system: SSRS, SSIS, SSAS, MDX
Creating databases and producing reports for different clients: TD, BMO, Mercedes-Benz
Creating complex queries and stored procedures for reports and data analysis (SQL Server 2008 / 2005).
Database design (logical/physical models, normalization/de-normalization)
Extracting data from different sources, transformation, and loading into files for different clients.
Creating SSIS packages for extraction, transformation, and loading data into the Reporting system and Data Warehouse Database.
Tuning and performance optimization in ETL flows.
Building, deploying, processing, querying, administer the cubes (SSAS)
Development, performance tuning, and optimization of Stored Procedures (Transact– SQL).
Creating technical documentation.
Senior Programmer Analyst/ Data Analyst/ Database Developer/ DBA April/07 – April/09
RBC Capital Mkts and Wealth Management Solutions Global Technology and Operations, Toronto(Contract)
Wealth management services application support, client and account creation and maintenance applications for “Client Source for RBC Dain Rauscher”, “HALO”, “Groundhog” projects
Creating TDDs based on Software Requirements Specifications ( SRS )
Analysis of business requirements and building the entire systems from scratch
Data analysis, preparing recommendations to optimize client/account applications, data integrity checks, problem solving
Development and optimization of Stored Procedures, triggers (SQL Server, Transact– SQL Querying)
Performing the application and database optimization, Index tuning (Profiler)
Consistency checks, minimizing deadlocks, shrinking database (Database Console Commands DBCC)
Building cubes and creating multidimensional Database Reports (SSAS, SSRS, MDX)
Preparing data for builds (MKS Integrity for change management; Mercury Quality Center)
Report automation (MS SQL Server SSRS)
Error handling implementation
QA support during modules testing
Data conversions for new client types (Private Counsel, Estate & Trust)
Creating interfaces allowing to transfer data between different business systems
Extract Client Source client/account information into files which served as a data feed for different systems (DTS, BCP, Jobs, MS SQL Server SSIS)
Archiving files, scheduling jobs to automate the process of sending and receiving files
Database Administrator (MS SQL Server)/Developer April/03 – April/07
Truestar Health, www.truestarhealth.ca, Toronto
Analysis of business requirements and business rules implementation.
Database design (logical/physical models, normalization/de-normalization): Erwin.
Analysis of product sales and on-line store performance: building a data warehouse, ETL (SSIS), cubes (SSAS), BI reports (SSRS).
Tuning of the database on the development server, loading data on production server (Red Gate SQL, DTS, SSIS).
Establishing procedures for Builds.
Special stored procedures for the SQL Server 2000 maintenance (Transact– SQL).
Backup and restoring of the databases. Consistency checks, database preventive maintenance, regular monitoring of capacity, logs.
Establishing user accounts and security.
Index tuning.
Support and maintenance of SQL Server 2000 Cluster (Microsoft Course: Implementing Microsoft Windows 2000 Clustering).
Moving a SQL Server databases from one machine to another.
Establishing and documenting of the database administration and security procedures.
Performing the application and database optimization by working with developers and system support personnel (Profiler, Teratrax Database Manager).
Development and optimization of Stored Procedures (Transact– SQL).
Creating reports (MS SQL Server SSRS)
Providing on-call assistance for database related problems.
Senior Programmer Analyst/ DBA /Database Developer November/02 – March/03
Maxium Financial Services Ltd., Richmond Hill(Contract)
Migration Access databases to MS SQL Server 2000.
Client/Server financial applications (Visual Basic, MS Access 2000, MS SQL Server 7.0, Transact– SQL; Development and optimization of Stored Procedures.)
Modification of existing source code to correct reported defects in the software.
Establishing of the database administration procedures, index tuning.
Development of reports for the Company’s existing and proposed solutions (Crystal Reports 8.5).
Database Administrator (MS SQL Server)/Developer July/02 – November/02
The Marketing Store Worldwide, Toronto(Contract)
Migration of the production databases from the SQL Server 7 to SQL Server 2000.
Special stored procedures for the SQL Server 2000 maintenance (Transact– SQL).
Backup and restoring of the databases. Consistency checks, database preventive maintenance, regular monitoring of capacity, logs.
Index tuning.
Establishing and documenting of the database administration and security procedures.
Performing the application and database optimization by working with developers and system support personnel.
Development and optimization of Stored Procedures (Transact– SQL).
Providing on-call assistance for database related problems.
Creating the documentation for the SQL Server 2000 maintenance.
Database Developer /DBA (MS SQL Server)/Senior Programmer Analyst November/00 – July/02
Toronto Dominion Bank, Toronto(Contract)
Client/Server Database Applications for Retail Real Estate department (Visual Basic, SQL Server 2000, Transact– SQL). Development and optimization of Stored Procedures.
Design and population of the database (ErWin, MS SQL Server, DTS).
Ludmila Khabas Page 2
Tuning of the database on the development server, loading data on production server.
Conversion MS Access 97 to MS Access 2000.
Migration Access databases to MS SQL Server 2000.
DBA functions: Backups and restoring of the databases.
Managing SQL Server security (creating and configuring roles, logins, users).
Consistency checks, database preventive maintenance.
Index tuning (Index tuning Wizard). Linked servers.
Monitoring server and database activity (SQL Profiler).
Intranet database applications for Project module: Active Server Pages (ASP), VBScript, HTML, Visual InterDev.
Using Crystal Reports 8.5 for MS SQL Server/ MS Access.
Creation of the installation package for client computers (MS Package and Deployment Wizard, InstallShield)
Senior Programmer Analyst/Database Developer August/00 – November/00
Arbor Memorial Inc., Toronto(Contract)
Client/Server applications (Visual Basic, MS Access 2000, MS SQL Server 7.0, Transact– SQL; Development and optimization of Stored Procedures.)
Migration Access Jet database to MSDE (Access 2000).
Crystal Reports System.
Senior Programmer Analyst/Database Developer November/99 – July/00
Enghouse, Markham
Three-Tier Client/Server applications for telecommunication, cable, gas, and other utility companies (Object Oriented Programming; COM, DCOM, ActiveX technologies; MS Visual Studio 6.0 Tools; GeoNet).
TelcoWorks project - Three-Tier approach including locating, placing, deleting, and removing facilities.
Development of Query Builder/Query Viewer Components with special features (flashing and highlighting facilities as well as setting graphical information) designed to work with Oracle 8i in the Geographic Information System industry.
Client: Visual Basic 6, GUI, ADO Connection;
Server: Oracle 8i, PL/SQL
Database design (logical/physical models): ERwin
Senior Programmer Analyst/Database Developer June/99 – October/99
Pro/Soft, Scarborough (Contract)
Client/Server applications for MAJIC 2000 system that links all the aspects of part processing (Pricing and Processing modules).
Client: Visual Basic 5/6, GUI, ADO Connection;
MS Access, Crystal Reports
Server: MS SQL Server 7.0, Transact– SQL; Development and optimization of
Stored Procedures.
Database design (logical/physical models): ERwin
Senior Programmer Analyst/Database Developer June/98 – June/99
Phonettix Intelecom, Richmond Hill (Contract)
Software for online quality control monitoring system for the outsourcing
Ludmila Khabas Page 3
Call Centers in Toronto, Montreal and Halifax
Client: Visual Basic 5/6, GUI, ODBC, DAO/RDO/ADO Connection;
MS Access, Crystal Reports
Server: MS SQL, Informix; Development and optimization of
Stored Procedures and Triggers.
Database design (logical/physical models): ERwin, S - Designer
Conversion of MS Access and Informix DB’s to MS SQL Server
Intranet WEB Database applications using Active Server Pages (IIS 4.0)
Object Oriented Programming for Call Center Services-inbound/outbound campaigns
Functional/Technical Specifications
Programmer Analyst October/97 – June/98
KG & B, Mississauga (Contract)
Visual Basic Creating GUI, menus, bound lists, Forms for displaying “master - detail” information, validation of the entered data
Designing Forms for entering, searching, filtering and editing data (SQL, Visual Basic)
Creating and maintaining MS Access database (Ordering Management System)
Conceptual and physical database modeling (S - Designer)
Printing Reports (Crystal Reports)
Programmer Analyst, Database Developer 1994 - 1996
Golan Research Institute, Israel
Visual Basic business, payroll applications
SQL querying and filtering data
MS Access database design, creating Queries, Forms, Crystal Reports
Maintaining and modifying of the databases (“Human Resources”, “Personal Telephone Directory”, “Experiments”, and “Orders”)
Conversion data from text files to MS Access database
Programmer Analyst 1982-1993
Institute of Geology and Geophysics, Russian Academy of Sciences
Institute of the Thermophysics, Russian Academy of Sciences
Basic and Fortran programs for determination of absolute age of rock with a mass-spectrometer (soviet computers “Iskra”, SM4)
Maintaining and extending of the geological databases “Collections”, “Geodata”
Fortran programs for determination of errors of non-standard means of measuring for unique scientific experiments ( IBM 370 ). Development of algorithms and programs for checking of radio measuring devices.
EDUCATION
Master of Science. Specialty in Applied Mathematics. Specialization in
Programming languages and algorithms
Technical University, Novosibirsk, Russia
Contact this candidate