Adept Sr. SQL SERVER BI / Power BI Developer with a proven track record at Uline Accenture, enhancing team productivity through advanced programming and API integration. Excelled in project management and software development, maintaining a 95% deadline adherence. Mentored junior developers, showcasing exceptional leadership and technical prowess.
Successful SQL /Power BI developer offering 10 + years of experience in demanding environments focused on producing cutting-edge designs for IT industry . Skilled in directing development with creative and performance-oriented approach. Well-organized and customer-focused with proven skills in project management and team leadership.
First-rate critical thinking and organizational skills. Excellent understanding of basic development principles and programming for diverse operating systems. Self-motivated Developer adds high level of experience over more than 13 years collaborating and working on multiple web-based projects.
· Used advanced SQL like analytical functions, aggregate functions for mathematical and statistical calculations.
· Written complex SQL statements using joins, sub queries and correlated sub queries.
· SSRS from SQL Server Gathered and documented business requirement from users for I3_CMS and CXOne reporting.
· Generated multiple Enterprise reports using Database (OLTP) , Oracle and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
· Created ETL pipelines using SQL, Azure Synapse, Azure Data bricks, and Azure Data Factory
· Implemented the scheduling in Azure Data Factory using Triggers
Programming
Project Management
Requirements Gathering
Software Development
Technical Support
Code validation
Test-driven development
Code debugging