* ** *

Natalia Mavrody

Business Intelligence: Hands-on Leader & Developer

**** *. ******** ***.

Chicago, Illinois 60610

ac21e1@r.postjobfree.com

Synopsis

§ 10+ years of extensive database and reporting development experience including SQL Server BI tools: SSRS 2005/2008/2012, SSIS; Business Objects 4.1/6.5/XIR2 Reporter/Designer/Supervisor

§ 10+ years of experience in RDBMS: SQL Server, Oracle

§ Experience working in multiple environments (test/production/development).

§ Exposure to various industries: financial, banking, legal, government, software, real estate

§ Experience supervising employees, performance review and professional development

§ Proven hands-on leadership track record of successful project implementations from start to finish, including gathering requirements, design, implementation, testing & documentation.

§ Exposure to the latest concepts and tools, including Erwin, HTML, Tableau, QlikView & Big Data concepts.

Employment History

2014 – Current: Senior BI Developer - JP Morgan Chase. Chicago Implementation of reporting solutions using SSRS: executive reporting, scorecards and dashboards, conversion of existing manual Access/Excel reports to SSRS; addressing immediate business requirements by assessing and automating business processes: creating ETL packages, scheduling reports via standard or data-driven subscriptions; in SSRS: utilizing linked & drill through reports, multi-valued multiple parameters, parametrized displays, graphs, lists, advanced grouping. SQL server development: create complex stored procedures, functions and scripts to serve as a back-end to parametrized, drill- through reporting.

2011 – 2014: Senior BI Developer,

Yield Technologies/Real Page, Inc. Chicago

SSIS/SSRS 2008/2012; extensive report development with SSRS and T-SQL: dashboards, drill-through functionality, multiple values multiple parametrized reporting, linked reports, graphs, parametrized reporting displays; building reporting data mart with SSIS, creating/analyzing/troubleshooting various of stored procedures, conversion of multiple .NET reports into SSRS. SQL programming: complex stored procedures, functions, triggers. 2 of 3

2010 – 2011: BI Analyst, Equity Residential - Chicago SSIS/SSRS 2005; implementation of reporting utilizing SQL Server Reporting Services & T-SQL, conversion and automation of existing processes from MS Access and Excel to SQL Server, building data repository with stored procedures, analyzing/troubleshooting financial data; VBA programming. SQL programming: triggers, stored procedures/scripts, Backup/Recovery, Maintenance Plans, Security, creating new objects; data conversion/refresh. 2006 – 2010: Data Analyst, ABN AMRO - Royal Bank of Scotland, Regional Due Diligence of North America. Chicago

Extensive reporting with Business Objects 6.5/XI, SSRS, Excel, MS Access; Process automation with MS Office, Business Objects/SSIS/DTS; SQL programming: triggers, stored procedures/scripts, complex DTS/SSIS packages; Database Administration: Backup/Recovery, Maintenance Plans, Security, Tuning/Optimization; Installation of new SQL servers, modifying existing databases, creating new databases and objects; data conversion/refresh. 2003 – 2006: Illinois Attorney General Office - Chicago 2003-2006, Database Administrator: Business Objects 6.5 environment setup for the SQL Server office-wide database. Designed universe to comply with new SQL Server environment; created process and lead modification of existing 500 Business Objects reports; administered security. SQL Server 7/2000 on Windows 2000 platform: DBA responsibility include: security, database maintenance plans and job management, performance, setting up new instances of SQL Server, and new databases. SQL server programming: complex views, stored procedures, DTS packages and query optimizer. Oracle8i/9i on Windows 2000 platform: DBA for 600 users of the office-wide database. Performing all needed functions to maintain and support three instances for multiple departments. Created copies of production database for testing, implemented advanced replication environment on the test servers along with the data guard environment.

Employment Related Responsibilities, Activities & Technologies

§ SSIS and SSRS

– Acted as a lead implementing reporting solution, building reporting data mart with SSIS

– Collaborated extensively with business users; prepared manuals and documentation for new and existing processes.

– Created project status dashboard/score cards report to be run on periodically.

§ SQL Server Development, Server 7/2000/2005/2008/2012

– Implemented new and modified existing objects in SQL Server database: triggers, views, stored procedures.

– Monitor performance, setting up security, jobs, maintenance plans in SQL Server 3 of 3

– Tested Business Objects reports, by validating data values, by running parallel SQL statements in SQL Server Query Analyzer or SQL Server Management Studio.

§ Oracle 8i, Oracle9i

– Created complex materialized views on the production Oracle environment to optimize the searches, implemented a batch job to refresh views on the daily basis.

– Troubleshoot and maintain Oracle front-end application (legal case management), setting up the security, adding new users, screen's design changes.

§ Business Objects 4.1/6.5/XIR2, Supervisor, Designer, Reporter

– Business Objects development including Universes, Classes, Objects, Hierarchies Created complex reports by using Slice and Dice, Drill Down, Filters, Master Details, Crosstabs, complex formulas and complex variables, multiple breaks and sorts.

– Acted as a lead in migration of Oracle BO environment into SQL Server BO environment including project planning, universe modification, migration of 500 reports, and testing. Training & Education

Microsoft SQL Server Certification Training, Chicago: SQL Server 2008 - Business Intelligence, SQL Server Administration SQL Server 2000 - Programming, Administration, and Advanced Querying. Oracle Corporation delivered courses, Chicago:

DB Administration I, DB Administration II, Advanced Replication, PL/SQL. Business Objects Corporation Training, Chicago:

Reporting, Designer, Supervisor, Advanced Reporting College of DuPage: Microsoft Visual Basic,

DeVry Institute of Technology, Chicago: Cobol, DB2, SQL, Bachelor of Science. Ivanovo College of Technology, Russian Federation

Contact this candidate