Akhrorbek B.
BI Developer/Data Engineer
- Role
- Etl Report Developer at Voya Financial
- Location
- Brooklyn, NY, US
- LinkedIn followers
- 500 followers
About Akhrorbek B.
Enthusiastic and dedicated Database and Report Developer, bringing over 7 years of specialized expertise in the Microsoft BI stack, including proficiency in MS SQL, SSIS, Azure Stack, and advanced reporting tools such as SSRS and Power BI. Proven experience spans across diverse industries, including healthcare, services, leasing, and insurance. Recognized for consistently delivering end-to-end data solutions, I am committed to leveraging my skills to drive efficiency, enhance data-driven decision-making, and contribute to the success of organizations.
Experience
Etl Report Developer
Apr 2021 — Present · New York, NY, US
Responsibilities:• Developed SQL components including Tables, Views, User-Defined Functions, user profiles, data dictionaries, and ensured data integrity through Table Normalization. Implemented Performance tuning, Indexes, and Triggers to enhance data manipulation efficiency and consistency.• Enhanced query performance by creating clustered, non-clustered indexes, and indexed views. Implemented database server performance tuning to optimize intricate SQL queries, including Stored Procedures, Views, and User-Defined Functions.• Utilized SSIS Transformations such as Conditional Split, Lookup, Merge Join, Sort, and Derived Column to transform unstructured data from various sources, ensuring data cleanliness and validation.• Crafted SSIS Packages employing Fuzzy Lookup, Derived Columns, Pivot Transformation, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task. These packages generated underlying data for reports and exported cleaned data to the data warehouse from Excel Spreadsheets, Text files, MS Access, and CSV files.• Developed Power BI dashboards and reports from scratch, including parameterized reports and predictive analysis. Created dashboards with Combination Charts and Custom Charts based on specific requirements.• Deployed and managed user permissions for reports and dashboards on the Power BI web portal.• Leveraged Power BI to create complex calculated columns and measures using DAX. Identified Relationships between tables and enforced referential integrity through foreign key constraints.• Executed a lift and shift of SSIS packages to the cloud using Azure Data Factory (ADF). Loaded data using various ADF activities such as Copy, Lookup, DataFlow, Web activity, Metadata activity, Foreach, etc.• Configured linked services for various data sources and destinations in ADF, including Flat file, Cosmos DB, SQL database, Azure SQL database, CSV. Created respective datasets in ADF.
Education
Community college of Information Technology
Associate's degree, IT
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.