Sally Bolotbekova
AUSTIN,TEXAS
Summary
Experienced Senior BI Developer with 7+ years of expertise in Database and Business Intelligence technologies. Proficient in the compete BI lifecycle, including analysis, design, development, testing, deployment, support, and documentation. Skilled in using BI tools like SSMS, SSIS, SSRS, and Power BI across various environment. Extensive industry experience in healthcare, insurance, and services. Strong in data modeling, ETL processes, dimensional modeling, and data visualization. Proficient in SQL Scripting, stored procedures, performance tuning, and optimization for large-scale databases. Excellent problem-solving and communication skills. Capable of working independently or as part of a team to deliver high-quality BI solutions for informed decision-making.
Overview
8
8
years of professional experience
Work History
Senior SQL/BI Developer
Covenant Consulting
02.2022 - Current
- Created complex stored procedures, triggers, functions (UDF), indexes, tables, views and other T-SQL code and SQL joins for SSIS packages and SSRS reports.
- Designed and developed customized extract, transform and load (ETL) applications per client specifications.
- Demonstrated advanced expertise in Azure SQL stack architecture, encompassing SQL Server, Azure
Synapse, and Azure Data Factory. Proficiently configure Azure platform to establish efficient data pipelines,
leverage Azure Blob Storage and data lakes. Develop and implement workflows within Azure Data Factory
(ADF) to automate data flow processes effectively. - Played active role in migrating on-premises SQL Server schemas to Azure SQL Server DB and Azure VM, ensuring smooth transition to cloud environment.
- Leveraged Power BI to implement semantic model, simplifying analysis of business data and relationships.
Loaded pertinent data from Azure Synapse data warehouse to enhance reporting and visualization
capabilities within Power BI. - Executed migration of on-premises SQL Server schemas to Azure cloud, specifically Azure SQL Server, while ensuring successful transition of databases.
- Created numerous Power BI reports leveraging Power BI Desktop and Power BI Service. These reports
include Performance Reports, Profit Reports, Sales Reports, Score Card Summaries, Annual Expenses Reports, Cost Comparison Reports, and more. - Reports have been designed for account information and research purposes, utilizing ad-hoc reporting capabilities to cater to needs of clients and advisors. These reports provide essential information and insights to support decision-making and facilitate effective communication between clients and advisors.
- Resolved complex business issues, proposing long-term solutions to avoid repeat problems.
- Managed workload independently but collaborated with colleagues to complete larger scale tasks in distributed team environment.
Data Engineer
Wipro Technologies
01.2020 - 01.2022
- Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
- Developed database architectural strategies at modeling, design and implementation stages to address business or industry requirements.
- Designed compliance frameworks for multi-site data warehousing efforts to verify conformity with state and federal data security guidelines.
- Built databases and table structures for web applications.
- Performed SSIS Development and support, developed ETL solutions for integrating data from multiple sources like Flat
Files (delimited, fixed width), Excel, SQL Server, Raw File, and DB2 into data warehouse. - Created, maintained, and updated ETL packages loading both OLTP and OLAP database tables.
- Utilized Azure Data Factory and SSIS (SQL Server Integration Services) to extract data from legacy on- premise databases, including SQL Server and Oracle. Extracted data was then loaded into Azure SQL Data Warehouse, enabling efficient data storage and analysis within cloud environment.
- Azure storage (blob), Azure Data Lake Store, Azure Data Factory, and Azure SQL Data Warehouse, along with associated server, have been meticulously organized. This includes configuring and structuring these components in coordinated manner, implementing appropriate access controls, and establishing optimized data ecosystem within Azure environment.
- Designed AWS Cloud formation templates to create custom sized VPc, subnets, Nat to ensure successful deployment of Web applications and database templates.
- Collaborated with system architects, design analysts and others to understand business and industry requirements.
- Documented data warehouse architecture to guarantee capacity met current and forecasted needs.
SQL Developer
NBSNY, Beekeeper Group
08.2015 - 01.2018
- Created reports on both cascading and standard parameters
- Actively involved in gathering Business Requirements and System Specification
- Participated in implementing logical design to physical design by creating tables
- Generated and optimized SQL statements to assist business intelligence practices
- Developing several behavioral reports and data points creating complex SQL queries and stored procedures using SSRS, Excel
- Created complex T-SQL Queries, Stored Procedures, Functions, Indexes, CTE's, Views, Joins and Triggers
- Converted design and user specifications into appropriate reports
- Configured SSIS packages with XML configuration file, Environment variable, Registry entry, Parent package variable and SQL Server table
- Built and presented PowerPoint to directors in Finance and CS.
- Construct user interfaces to client interfacing teams to access item cleansing data and manage incoming client requests
- Trained via Insperity, in Business Intelligence, ITIL, Project Management for non-PMP's Designed and structured standard guidelines and procedures for company's new internship program, alongside three other interns.
Education
Bachelor’s degree - Mathematics And Computer Science
KRSU
07.2014
Skills
- ETL Tools & Reporting Tools: SQL Server Integration Services (SSIS), Power BI Desktop/Services, Report Builder, Tableau, SQL Server Analysis Services (SSAS), SSRS
- Cloud Technologies: Azure Data Lake, Azure Data Factory, Azure Data Warehouse, Azure SQL Database, Azure VM and Azure Data Bricks, Amazon Redshift
- Web Tools: ASPNet, VBNet, Visual StudioNet, C#Net
- Architecture: Relational DBMS, Client-server architecture, OLTP, OLAP
- Databases: SQL Server, Oracle, MS Access, Teradata, DB2
- Languages: PL/SQL, T-SQL, MDX, DAX, C#, VBNET, XML, MYSQL, HTML, C, C, JavaScript, Python, JSON
- Others: MS Office, Git, Clinical Analytics, MS Visual, EHR, SAS Business Intelligence, MicroStrategy, SQL Server Notification Services, Jira, Hadoop, SPSS, ER-Studio, Internal Tools
Timeline
Senior SQL/BI Developer
Covenant Consulting
02.2022 - Current
Data Engineer
Wipro Technologies
01.2020 - 01.2022
SQL Developer
NBSNY, Beekeeper Group
08.2015 - 01.2018
Bachelor’s degree - Mathematics And Computer Science
KRSU
Similar Profiles
Carrie LonesCarrie Lones
Licensed Professional Counselor at Covenant Counseling and ConsultingLicensed Professional Counselor at Covenant Counseling and Consulting
Isaiah ManbodeIsaiah Manbode
Cleaner/Designer Assistant at The New Covenant Church of Jesus Christ (Apostolic)Cleaner/Designer Assistant at The New Covenant Church of Jesus Christ (Apostolic)
Jennifer MooreJennifer Moore
Manager at Covenant living of Keene-Keene, NHManager at Covenant living of Keene-Keene, NH
Claire LewisClaire Lewis
Senior Client Implementation & Onboarding Consultant– Enterprise Accounts at PopmenuSenior Client Implementation & Onboarding Consultant– Enterprise Accounts at Popmenu
LISA HERNANDEZLISA HERNANDEZ
Warehouse Associate at AmazonWarehouse Associate at Amazon