Tatiana Varlamova
Senior Consultant, Data Systems Analyst @Norima Consulting Inc.
Signup · Get unlimited contacts
WORK HISTORY
Senior Consultant, Data Systems Analyst @Norima Consulting Inc.
Winnipeg, MB, CA
Worked on various projects, focusing on backend data preparation, ETL processes, data mapping, and data standardization to ensure seamless integration and reliable reporting.> Wealth Management Data Lakehouse project. • Conducted analysis of data feeds from various Custodians and Aggregators to identify and define key fields necessary for displaying accurate transaction details at the account level.• Mapped transactional data from multiple sources to a standardized format, ensuring uniformity, accuracy, and seamless integration into the Data Warehouse.• Classified transactional data into predefined categories to enable accurate reporting and financial analysis.> CRM data migration project from Salesforce to Redtail• Performed analysis of data fields in both Salesforce and Redtail CRM systems ensuring accurate data mapping and seamless migration.• Created and executed SQL queries to export data from the Snowflake data platform.• Performed data validation during the ETL process to maintain the data quality.• Developed and utilized Smartsheet metrics and Azure DevOps process to monitor and track the progress of the migration project.> Advisor Credit Exchange platform• Conducted ETL testing to ensure data integrity and prevent duplicate records and data loss from various sources, including Envestnet.• Revised store procedures to confirm the process of loading the external data to the platform database.• Developed SQL Server database views for standardized data, supporting the creation of Business Intelligence reports.• Utilized Azure Data Catalog for efficient documentation and organization of data assets, including sources, tables, and views.• Created complex SQL queries to extract and analyze data from the SQL Server database.• Created ERD and data flow diagrams to visualize the complex data structure for stakeholders.• Performed comprehensive API testing utilizing Postman to verify the accuracy of requests and responses.
EDUCATION
Baltic State Technical University, St.Petersburg, Russia
Bachelor's degree, Electronic Engineering
RRC Polytech
Certificate with Honours in Business Analyst
ABOUT TATIANA VARLAMOVA
I am a Data Analyst with 10+ years of experience in data analysis and software quality assurance across insurance, compliance, and financial services. My expertise lies in transforming raw data into accurate, meaningful insights through backend data preparation, ETL processes, data mapping, and data standardization.Throughout my career, I’ve worked on integrating data from multiple sources, executing data migrations, and designing models to support analytics and reporting. I have a strong foundation in data structures, ERD modeling, API testing, and business intelligence reporting, ensuring that technical solutions meet business needs.Key Skills: Data Analysis; Data Aggregation & Batch ETL; Custodian Integration; Data Standardization; Data Management; Agile Methodology; User Story Development; End User Application Support; Test Planning & Execution, Defect/Bug Tracking, API & UI TestingDatabases & Platforms: MS SQL Server, Sybase SQL, PostgreSQL, Trino SQL, Snowflake, DBeaver, pgAdmin, Power BI, MS Azure Data CatalogOther Tools & Tech: Postman (API Testing), Claude AI, Smartsheet, JIRA, Confluence, Azure DevOps, MS Visio, Lucidchart
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.