Denis Sergeev Email & Phone Number

Toronto, On, Ca

Toronto, Canada Area

Working with client managers and business teams to develop, review, finalize and document Business Intelligence, including reporting and dashboard requirements based on the identified key performance metrics.Creating source to target mappings and associated business logic for development teams based on business requirements.Architecting, designing and delivering end-user reports based on SQL queries and/or database procedures using Teradata/Oracle client tools and Tableau.Making… Show more Working with client managers and business teams to develop, review, finalize and document Business Intelligence, including reporting and dashboard requirements based on the identified key performance metrics.Creating source to target mappings and associated business logic for development teams based on business requirements.Architecting, designing and delivering end-user reports based on SQL queries and/or database procedures using Teradata/Oracle client tools and Tableau.Making changes in the existing data model as per new business requirements using Erwin 7.3.Developing and implementing Data Quality strategies, data model design, and data quality rules to improve the quality of operational data.Designing, reviewing, and documenting logical and physical data architectures, relational data models for the data warehouse, data marts, and operational data store.Designing, testing, tuning, migrating and documenting database procedures and functions developed in Oracle PL/SQL with TOAD and SQL Developer.Root cause analysis of production issues and fixing of issues.Assisting Quality Assurance/Business Team during system testing and Business Acceptance testing. Show less

Toronto

- Provided system analysis, design, development and deployment of BI applications for the largest bank in Eastern Europe. - Worked directly with customers and analysts to develop, articulate, and document a project approach. - Provided thorough documentation of all BI applications and processes to be used in the event of equipment or system failure. - Assisted in the integration efforts for merging BI platforms with enterprise systems and applications. - Responsible for Release… Show more - Provided system analysis, design, development and deployment of BI applications for the largest bank in Eastern Europe. - Worked directly with customers and analysts to develop, articulate, and document a project approach. - Provided thorough documentation of all BI applications and processes to be used in the event of equipment or system failure. - Assisted in the integration efforts for merging BI platforms with enterprise systems and applications. - Responsible for Release To Production process (RTP) including automation of all processes, data quality and exception handling etc., testing and project documentation, regular communication with Production support team.- Ensured compatibility and interoperability of BI systems. Show less

Moscow, Russian Federation

- Provided system analysis and design of the data warehouse and a few data marts for a large retail bank in Russia (up to 4 million customers). - Worked directly with customers (risks, finance, customer service), analysts and vendors to develop, articulate, and document a project approach. - Assisted in the integration efforts for merging the DWH with banking systems and applications.- Managed Release To Production process (RTP) including automation of all processes.

Moscow, Russian Federation

- Provided development and deployment of Oracle Financial Analyzer system for the finance department (finance reporting data mart). - Provided system analysis, design, development and deployment of ProClarity system for the marketing department (marketing data mart). - Worked directly with internal customers and analysts to document a project approach. - Managed the integration efforts for merging BI platforms with enterprise systems and applications. - Ensured compatibility and… Show more - Provided development and deployment of Oracle Financial Analyzer system for the finance department (finance reporting data mart). - Provided system analysis, design, development and deployment of ProClarity system for the marketing department (marketing data mart). - Worked directly with internal customers and analysts to document a project approach. - Managed the integration efforts for merging BI platforms with enterprise systems and applications. - Ensured compatibility and interoperability of BI systems. Show less

- Provided design, development and deployment of business intelligence applications (Oracle Financial Analyzer) for a large hydro energetic company. - Assisted in the integration efforts for merging the BI platform with enterprise systems and applications. - Provided end user support for day-to-day use of the deployed BI applications.

- Provided system analysis and design of educational software.- Worked with the training department effortlessly and developed training materials.

- Provided development and deployment of reporting applications for customers.- Provided end user support for day-to-day use of the office software.

Bachelor, Computer Science

• Applied Mathematics • Computer Science • DBMS theory

Physics

Professional Diploma In Management, Bachelor

• Business organizations and their environments • Understanding business functions • Business behavior in a changing world