Power Bi Sql Server

Gautam Babu - BI Developer

585-***-**** ***********@*****.***

http://www.linkedin.com/in/gautam-babu-551ba2233

PROFESSIONAL SUMMARY:

Over 9 years of hands-on experience in Business Intelligence (BI) and Data Engineering, specializing in leveraging Power BI for comprehensive data solution architectures, report development, and system administration.

Demonstrated advanced proficiency in crafting Power BI reports and dashboards, applying Data Analysis Expressions (DAX) to manipulate and present data effectively, upholding high standards of data quality and visual presentation.

Mastered dataset ingestion, transformation, and modelling within Power BI, utilizing DAX to conduct sophisticated data analyses that drive strategic business insights.

Gained extensive experience with SQL Server and Oracle, employing Microsoft SQL Server Analysis Services (SSAS) and Integration Services (SSIS) to facilitate complex data integration and ETL processes, ensuring seamless data flow into BI systems.

Exhibited deep expertise in the security models of Power BI, focusing on performance optimization and maintaining the integrity of both the Power BI service and desktop environments, ensuring reliable and secure data analytics platforms.

Excelled in integrating and enriching data from a variety of sources, including both on-premises databases and cloud platforms, to create unified and insightful BI solutions.

Proficient in utilizing DAX for the creation of calculated measures and columns in MS Power BI Desktop, enhancing the analytical depth and flexibility of reports.

Advocated for and implemented BI reporting best practices, focusing on data visualization excellence to empower organizational data-driven decision-making.

Ensured the visual and data quality of all BI deliverables, conducting comprehensive testing and overseeing user acceptance processes to guarantee satisfaction and accuracy.

Provided leadership and governance around Power BI platform architecture and operations, spearheading the requirements gathering, planning, and project management to deliver optimal BI solutions.

Applied Agile methodologies effectively, supporting the iterative design and development of BI solutions, thereby ensuring projects remained flexible to changing requirements and could rapidly deliver value.

Proactively identified project risks and communicated potential roadblocks, offering decisive recommendations to mitigate issues and ensure the successful delivery of BI projects.

Kept abreast of the latest Power BI updates and enhancements, applying new features and best practices to continually enhance the BI services offered to the business.

Holds a Bachelor’s degree in Computer Science and Engineering, underpinning a solid foundation in technical principles, with extensive hands-on experience in Power BI, SQL Server, and adopting data analytics best practices to solve complex business challenges.

TECHNICAL SKILLS

Analytics Tools: Power BI, Tableau (Desktop, Server, Online, Prep, Public, Reader)

Applications: Word, Excel, PowerPoint, SharePoint, Outlook.

Data Modelling: Star Schema Modelling, Snowflake Modelling.

ETL Tools: SSIS, Microsoft SQL Server Integrated.

Database Skills: SQL Server, AWS DB, Snowflake DB, SAP HANA DB.

Programming Languages: Python, R.

EXPERIENCE:

LL Bean, Freeport, ME May 2021– Current

BI developer

Description: L.L. Bean is an iconic American outdoor retail company, offering a wide range of products from clothing to outdoor gear, the company stands as a symbol of durability, reliability, and environmental stewardship.

Led the development and implementation of a robust Power BI architecture, enhancing data visualization and reporting capabilities across the organization.

Led the integration of Power BI with SQL Server and AWS databases, enabling seamless data analytics and insight generation.

Designed and deployed advanced Power BI dashboards and reports, providing dynamic and interactive data visualizations to support strategic decision-making.

Developed complex DAX queries for data modeling, analysis, and reporting, significantly improving data manipulation and insight extraction.

Managed Power BI administration, including configuration, security model optimization, and user access control, ensuring compliance and data security.

Automated data extraction, transformation, and loading (ETL) processes using Microsoft SSIS, enhancing data availability and reporting efficiency.

Collaborated closely with business units to gather requirements and translate business needs into technical specifications for BI solutions.

Conducted data enrichment by integrating SQL Server and Oracle databases, providing a comprehensive data foundation for analytics.

Implemented calculated measures and columns in Power BI using DAX, enhancing the depth and accuracy of data analysis.

Published and scheduled reports on app.powerbi.com, setting up necessary connections and ensuring timely data refreshes for up-to-date insights.

Facilitated user acceptance testing cycles, collaborating with stakeholders to validate reports and dashboards against business requirements.

Provided governance around Power BI platform architecture and operations, establishing best practices and ensuring system reliability.

Led Power BI training sessions for developers and end-users, promoting data literacy and self-service analytics within the organization.

Enhanced, debugged, and performance-tuned Power BI reports and DAX code, ensuring high efficiency and user satisfaction.

Managed concurrent BI projects, effectively prioritizing tasks to meet deadlines and organizational goals.

Developed technical and functional documentation, ensuring clear communication of BI solutions and processes.

Advocated for the use of data visualizations best practices, driving the adoption of effective reporting techniques across teams.

Monitored technical problems and provided decisive recommendations, ensuring the continuous improvement of BI services.

Stayed updated on Power BI desktop, service, and related technology enhancements, integrating new features to drive innovation.

Served as a technical advisor, mentoring team members on Power BI development, DAX, and data integration best practices.

Ecosystem: Power BI, Tableau, SQL Server, AWS DB, Python, SSIS, Snowflake DB, SAP HANA DB, Power Query

Optum, New Jersey Nov 2017 - Apr 2021

BI developer

Description: Optum is a leading health services and innovation company dedicated to helping make the health system work better for everyone. Optum leverages cutting-edge technology, advanced data analytics, and a wealth of health expertise to provide a broad range of services and solutions.

Designed and implemented data-rich Tableau dashboards, integrating them with SQL Server and Snowflake DB to offer deeper insights into healthcare analytics.

Automated complex data workflows in Tableau, leveraging Python and SQL to enhance data integrity and preparation for visual analytics.

Enhanced Tableau Server user access management, drawing from experience in managing Power BI Service to streamline dashboard access and security.

Conducted advanced data blending and extraction with Tableau Prep, using Power Query expertise to enrich the analytics platform with multifaceted data sources.

Performed extensive performance tuning of Tableau dashboards, employing Python scripts for data optimization and paralleling techniques in Power BI for efficiency.

Customized SQL queries to bolster data analysis capabilities, enabling enriched data visualization in Tableau, akin to practices in Power BI development.

Led the development of interconnected Tableau dashboards, enhancing cross-departmental reporting and leveraging SQL Server data for comprehensive insights.

Orchestrated Tableau Desktop and Server training programs, highlighting Python for data analysis and SQL Server for robust database management.

Applied agile project management principles using Jira, supervising Tableau projects with an emphasis on adaptive planning and efficient execution.

Instituted a streamlined data governance process in Tableau Server, incorporating SQL Server and Power BI management best practices to uphold data quality.

Optimized Tableau and Power BI reports for superior performance, utilizing Python and SQL for accelerated data processing and visualization.

Advanced the automation of reporting processes in Tableau, integrating dynamic data sourcing from SQL Server and Snowflake DB, reflecting Power BI automation practices.

Championed the integration of cloud databases like AWS DB with Tableau, ensuring up-to-date data for analytics, mirroring Power BI strategies for cloud integration.

Pioneered predictive analytics within Tableau, employing Python for sophisticated data analysis, thereby enhancing the analytics capabilities already established in Power BI.

Developed highly interactive Tableau dashboards, incorporating SQL and Python to implement drill-down features, similar to Power BI solutions for enhanced user engagement.

Established best practices for Tableau report creation, focusing on data integrity and visualization quality, informed by extensive experience with Power BI.

Set up automated data refresh schedules in Tableau, utilizing Python and SQL to maintain data accuracy and timeliness, akin to practices in Power BI.

Facilitated collaboration with business analysts, translating complex data requirements into actionable BI solutions, leveraging SQL and Python for effective data manipulation.

Promoted the widespread adoption of Tableau Prep within data teams, highlighting the tool's efficiency in data preparation, paralleling the use of Power Query in Power BI workflows.

Advocated for continuous learning and exploration of new features in both Tableau and Power BI, supported by advancements in Python and SQL, to foster a culture of innovation and constant improvement.

Ecosystem: Power BI, Tableau, SQL Server, Snowflake DB, Python, Tableau Prep, Power Query

eCLOUD LABS, India. Jul 2014 - Aug 2017 Data Engineer

Description: eCLOUD Labs Inc. is a forefront provider of innovative IT consulting and solutions, specializing in cloud-based technologies, data analytics, and digital transformation strategies.

Designed the Power BI architecture to support complex healthcare analytics and reporting needs at Optum.

Developed and maintained a suite of Power BI reports and dashboards, turning vast datasets into actionable insights for healthcare optimization.

Expertly crafted DAX expressions to build advanced data models within Power BI, enabling sophisticated data analysis and reporting functionalities.

Led the administration of the Power BI environment, ensuring optimal performance, secure data access, and compliance with healthcare data standards.

Streamlined ETL processes using Microsoft SSIS, facilitating the efficient integration and transformation of data from SQL Server and Oracle databases.

Implemented security measures within Power BI, designing a robust security model to protect sensitive healthcare data while enabling necessary access.

Integrated Power BI with various on-premises and cloud data sources, including Oracle and AWS, enhancing data accessibility and analytics flexibility.

Automated report scheduling and publishing on app.powerbi.com, ensuring stakeholders had regular access to updated healthcare analytics insights.

Utilized DAX to create calculated measures and columns, enriching Power BI reports with dynamic analytics and deeper data exploration capabilities.

Collaborated with business stakeholders to gather and define requirements, translating complex healthcare operations into technical BI specifications.

Conducted thorough unit testing and facilitated user acceptance testing (UAT) for BI deliverables, ensuring accuracy and user satisfaction.

Established governance protocols for Power BI platform architecture, setting standards for development, deployment, and maintenance.

Provided mentorship and technical guidance to junior Power BI developers, fostering a culture of learning and professional growth within the team.

Enhanced and optimized existing Power BI reports and DAX scripts for better performance and user experience, addressing specific healthcare analytics needs.

Managed multiple BI projects concurrently, prioritizing based on organizational impact and stakeholder needs, while navigating a fast-paced healthcare environment.

Created comprehensive technical and functional documentation for BI projects, ensuring clarity and sustainability of Power BI solutions.

Promoted best practices in data visualization and report design, emphasizing clarity, accuracy, and relevance of healthcare data presented.

Proactively identified and resolved technical issues in Power BI implementations, applying root cause analysis to prevent recurrence.

Kept abreast of the latest developments in Power BI and related technologies, applying updates and enhancements to Optum's BI solutions.

Led workshops and training sessions on Power BI and DAX, enhancing the data analytics skills of technical staff and power users within the healthcare domain.

Ecosystem: Ecosystem: SQL Server, Python, AWS DB, Snowflake DB, ETL Tools (SSIS, Talend), Apache Spark, Hadoop, MongoDB, Git, Jupyter Notebook, Tableau, Power BI

Education:

Bachelor of Technology in Computer Science and Engineering

Karunya Institute of Technology and Sciences

Contact this candidate