Alekya Chowdhary
Sr Sql Server Power Bi Developer @Bank of America
Signup · Get unlimited contacts
WORK HISTORY
Sr Sql Server Power Bi Developer @Bank of America
Charlotte, NC, US
Designed, configured, and maintained SQL Server databases, ensuring optimal database design, integrity, and performance for operational and reporting use cases.• Developed custom SQL Server Agent jobs for automated data movement, scheduling, and validation processes across various production environments.• Conducted SQL Server database health checks to identify and resolve performance bottlenecks, ensuring database stability and operational efficiency.• Troubleshoot and fix or recommend solutions for each SQL job that is failing, ensuring minimal downtime for critical systems.• Developed and monitored incremental and idempotent ETL processes using SQL, improving integration of data from various operational sources.• Improved query performance and indexing strategies on SQL databases, significantly enhancing the speed and reliability of operational and reporting queries.• Implemented data pipeline monitoring using Azure Data Factory and SQL Server Integration Services (SSIS).• Deployed Azure SQL Database with geo-replication and configured failover mechanisms to ensure high availability.• Designed and developed interactive dashboards and reports using Power BI to visualize operational and business data for stakeholders, ensuring actionable insights and decision-making.• Created optimized data models in Power BI by establishing relationships between tables and implementing DAX (Data Analysis Expressions) for calculated columns and measures.• Integrated Power BI with Azure SQL Database, Snowflake, and other cloud data sources, ensuring real-time data refresh and accessibility.• Created various SSIS packages to transfer data from OLTP (Tabular) databases to a staging area and then into a data warehouse. Deployed the packages to the appropriate destinations using SSIS and successfully created dynamic package configurations in SSIS.
EDUCATION
Central Michigan University
Master's degree
ABOUT ALEKYA CHOWDHARY
SQL Developer/ Power BI Developer | Master\'s in Information System About Me: I\'m an experienced SQL Server and Power BI Developer with over 5 years of expertise in delivering data-driven solutions for investment banking, finance, and insurance industries. Skilled in MS SQL Server (2019/2017/2016/2014/2012), Power BI, and Azure tools, I specialize in developing ETL pipelines, designing robust data models, and creating interactive dashboards that drive actionable insights. Proficient in tools like SSIS, SSRS, and SSAS, I excel in implementing data warehousing strategies, optimizing database performance, and crafting dynamic reports to meet diverse business needs. My hands-on experience includes advanced data visualization, DAX queries, and ensuring data integrity across complex systems. Passionate about leveraging cutting-edge technologies to enhance business intelligence frameworks and foster data-driven decision-making. A collaborative problem-solver with a proven track record of delivering high-quality solutions on time, I am always eager to embrace new challenges and innovate in the evolving data landscape. Career Aspirations: My ultimate goal is to To leverage my expertise in SQL Server, Power BI, and data analytics to design and implement robust business intelligence. Seeking a challenging role where I can harness my technical proficiency, problem-solving abilities, and passion for innovation to drive organizational success and growth. Networking: I am always eager to connect with professionals, mentors, and fellow enthusiasts in the fields of information systems, data analytics, and technology. Let\'s connect and explore opportunities for collaboration, knowledge sharing, and growth. Strong Communication Skills: I possess excellent verbal and written communication skills, enabling me to convey technical concepts clearly to both technical and non-technical audiences. If you\'re interested in learning more about how I can help your business, feel free to reach out to me at 92••••••09 or via email at a••••••••@gmail.com. Let\'s connect! Technologies: SQL Server Enterprise Manager, Microsoft Management Console, SQL, T-SQL, Data Transformation Services (DTS), OLTP, BCP, SSIS, OLAP. Microsoft Visio, ER Studio, AZURE SQL Database, Azure data warehouse, Azure Data azure data factory, Azure Data Synch, MS SQL Server 2014,2016, MySQL and Oracle12c,Erwin, MS Visio, Rational Rose, T-SQL, PL/SQL, HTML, C#.Net, VB.Net, C++, Java, Java script, CSS, Windows Scripts, Python, Data bricks.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.