SLADANA CIROVIC

Highly motivated IT Professional with 20 years of experience as Data Analyst/System Analyst/Application Developer/Business System Consultant. Highly Experienced with Data Analysis, ETL, Database Design, Development and Business Intelligence. Experienced in designing optimal Cubes, dimensions, measures for Data Analytics. Experienced with complete Software Development Life Cycle applications in analysis, design, development, documentation, testing, and support. Exceptional planning, organizational, time management skills, ability to perform multiple projects concurrently. Ability to work effectively as a member of a team, collaboratively with others in a multidisciplinary team environment and work independently, as required. Strong programming and problem analysis skills. Member of Mensa. Experienced business intelligence professional well-versed in mining data, developing databases and generating reports. Detail-oriented and systematic with excellent follow-through and a superior work ethic. Excellent communication, project management and problem-solving abilities.

• 10/01/20, Present, CANADIAN IMPERIAL BANK OF COMMERCE(CIBC), Senior Data Analyst/Application Developer, Create high performing Database layer using dimensional model (Star or Snowflake Schema) for reporting (Tables, Views, Indexes, Stored Procedures (SPs)) in SQL Server, Optimization of existing and creating new SQL queries for Tableau data extract and Cognos Framework, Create and maintain Cognos Dashboards and operational reports, Involved in creating Tableau Dashboards, Involved in development of Power BI reports, Maintain of existing in-house .NET applications, Other team members mentoring, Work closely with non-technical business clients and stakeholders to define and scope requirements
• 09/01/13, 05/01/19, CANADIAN IMPERIAL BANK OF COMMERCE(CIBC), Senior Data Analyst/Application Developer, Involved in requirements gathering with Business Analysts and translate that into technical requirements, Build multiple ETL Packages using SSIS to import/export data from/to various data sources (database, files, etc.), Create SQL queries and stored procedures to extract, transform and clean data from the stage layers, Data analysis, Troubleshooting and performance tuning, Performing and documenting enhancements and changes to the existing queries and applications, Build multiple ETL Packages in Syncsort (DMExpress) using Hive Queries to extract data from Hadoop, Build SSAS cube solution for Reporting with best practices incorporated, Create reporting solutions /dashboards on relational and dimensional databases, Web Application design, development, testing, implementation, documentation, and support in accordance with CIBC standards and procedures, Create technical documentation, Design documents, post implementation documentation, data mapping, data dictionary, Train other developers
• 03/01/11, 10/01/11, BELL, Senior Application Developer, Application design, development, testing, implementation, documentation
• 03/01/10, 03/01/11, CANADIAN IMPERIAL BANK OF COMMERCE(CIBC), Senior Application Developer/System Analyst, Developed several intranet applications for Telephone Banking, Involved in requirements gathering, design, development, testing, implementation, documentation, Design and developed databases for the applications, Create ETLs/SQL queries/.NET code for data migration, Data integration with other systems is done with SSIS packages that are run daily
• 06/01/07, 10/01/08, Orion Technology, a Division of Rolta Canada, Senior SQL Programmer/.NET Programmer, Application design, development, testing, implementation, documentation
• 09/01/05, 05/01/07, Mindscope Staffing Software, Toronto, ETL Specialist and .NET (C#) Programmer, Data conversion for new clients, Data mapping and perform ETL tasks using DTS/SSIS, For data that are not convertible by SQL (e.g. data in HTML format) wrote C# applications, Have improved and sped up the whole data conversion process several times, SSRS custom reports, Communication with clients: In constant communication with clients, help them to gather and clean up their data so they can start with clean data, suggest data format, do data mapping, and present the application to the clients
• 12/01/01, 08/01/05, Public Revenue Agency of the Republic of Serbia, Large Tax Users, Software Developer /IT Manager, ASP, T-SQL, SQL Server2000, ETL, DTS, Data Warehousing, VBA, MS Access, VisualBasic6.0, VisualStudio.NET2003, C#, ASP.NET1.1, ADO.NET1.1, WinForms, UML, CrystalReports10, Access2000, Excel, PL/SQL, HTML, XML-XSL, Visio, JavaScript