Power Bi Sql Server

Sr. Power BI Developer

Raju K

ad5n7e@r.postjobfree.com

PROFESSIONAL SUMMARY

Around 10+ years of experience as MSBI / Power BI developer, database developer, and data analyst with Microsoft SQL Server 2016/2014/2012/2008 R2/2008/2005, SSIS/SSRS/SSAS, OLTP, OLAP (Different environments such as Production, UAT, and development) and MSBI/Power BI in various domains.

Extensive experience with SQL Server Integration Services (SSIS) 2008/2008 R2/2012/2014 and 2016 Data Extraction, Transforming, and Loading (ETL).

Expertise in Scheduling Database tasks - Jobs, Alerts, Emails, and Notifications.

Experience in BI Development and Deployment of DTS, and SSIS packages from MS Access, Excel, Oracle, and Teradata.

Good working experience in implementing Data Warehousing BI Application Development using Cognos 8X,10X, Cognos Analytics 11X, Power BI, MSBI (SSIS, SSAS, SSRS) and Tableau v2018.1.

Developing the Relational and Dimensional Model using Cognos Framework Manager and applied data level and object level securities.

Implementation of various data models including normalized, de-normalized, star, and snowflake schemas, enhancing data retrieval efficiency and analytical capabilities.

Advance data modeling using DAX, power query/edit query in Power BI desktop, and working with custom visuals.

Involved in writing Java API for Amazon Lambda to manage some of the AWS services.

Has very good experience in creating SSIS packages to manage SQL server databases and SQL server objects between instances of SQL server.

Experience in using Nexusand JFrogArtifactory Repository Managerfor Maven, gradle and npm builds.

Has experience on Denodo for Data Visualization and ETL

Worked with the technical team and business users to analyze business requirements and translate them into technical specifications for ETL and reporting.

Experience in the design and development of applications using .NET Framework, C#.NET, ADO.NET, LINQ, Visual Studio 2003/2005/2008, AJAX, SQL Server 2008, and UML.

Experience in developing N-tier distributed .NET applications using Web Forms and WinForms. Good knowledge of .NET Framework features including Reflection and Metadata.

Coordinated and participated in weekly estimation meetings to provide high-level estimates for backlog items.

Power BI Tools – Power BI desktop, power pivot, power query, power view, power map, Power BI dashboard, calculated columns, and calculated measures using DAX, data modeling.

Experience in Object Oriented Design and Programming concepts in Java and Python

Having experience in Agile Methodologies, Scrum stories, and sprints experience in a Python-based environment, along with data analytics, data wrangling, and Excel data extracts.

Experience in developing and deploying a Microservice application utilizing almost all the AWS Stack including S3, EC2, DynamoDB, Kinesis, SNS, and SQS.

Generated complex Transact SQL(T-SQL) queries, Sub queries, Co-related sub-queries, and Dynamic SQL queries. Programming in SQL Server - Using the Stored Procedures, Triggers, User-defined functions and Views, and Common table expressions (CTEs).

Experienced in client requirement Analysis, Logical and Physical design & development of a database (using MS Visio, Erwin, normalization, and SQL Server Enterprise manager), Resource Planning, Coding, Debugging, Testing, Deployment, Support, and Maintenance of business applications using SQL Server 2012/2008R2/2005, DTS, SSIS, SSAS, and SSRS.

Wrote scripts in Python for extracting data from HTML file.

Utilize PyUnit, the Python Unit test framework, for all Python applications.

Experience in Logging, Error handling using Event Handler, and Custom Logging for SSIS Packages. Experience in Performance Tuning in SSIS packages by using Row Transformations, Block, and partial blocking Transformations.

Implemented Copy activity and custom Azure Data Factory Pipeline Activities for On-cloud ETL processing.

Periodic reporting is done daily, weekly, monthly, and quarterly, which helps the client by using the Reporting Services (SSRS), POWER BI.

Hands-on experience in Azure Development worked on Azure web application, App services, Azure storage, Azure SQL Database, Virtual machines, Fabric controller, Azure AD, Azure search, and notification hub.

Good knowledge of Data Marts, Operational Data Store (ODS), OLAP, Dimensional Data Modeling for FACT, and Dimension Tables using SQL Server Analysis Services.

Experience in Azure DevOps, creating pipelines, and usage of ADLS

Implemented User-Defined server roles in SQL Server 2019, default schemas for groups.

Worked extensively in Query analyzer and profiler for tuning queries using variables for characteristics and query costs.

EDUCATION DETAILS:

Bachelor’s From Jawaharlal Nehru Technological University, Kakinada in 2013

TECHNICAL SKILLS

SQL Server Tools:

SQL Server Management Studio, SQL Server Business Intelligence Development Studio, SQL Server Data Tools, SQL Server Integration Service (SSIS)

Databases:

MS SQL Server 2012/2008/20x05/2000, Oracle 10g/9i/8i, DB2, Teradata, MS Access, Denodo

Programming Languages:

C, C#, VB.Net, SQL, T-SQL, Power Shell, Visual Basic

Scripting:

HTML, DHTML, XML, JavaScript

Reporting Tools:

SQL Server Reporting Services (SSRS) 2012/2008, Crystal Reports, Qlik View, Tableau, Power BI, Crystal Reports XI/X/9/8.

Application Packages:

MS Outlook, MS Office

Operating Systems:

Windows 2003/2008, Windows 7, Windows NT, Windows 2000, XP

Version Control:

Team Foundation Server, VSS, SVN

WORK EXPERIENCE

Client: Volute Education, Rhode Island Jan 2023 - Current

Role: Sr. Power BI Developer

Responsibilities:

Active involvement in the architectural and technical design specification sessions.

Provided estimates for the work requirements and planned the assigned activities in detail.

Creating the Procedures, Functions and View in the Azure Data warehouse

Involved in client Meetings to discuss the requirements.

Created SSIS packages to get data from different sources, consolidated and merged into a single source.

Developed the various SSIS components like SCD, Conditional Spilt, Merge, Merge Join, Multicast, Union all, Sort, Derived column, Executed SQL Task, Variables, Parameters, and Error Handling before loading data into Data warehouse.

Managed comprehensive testing cycles for new Cognos releases, fixes, and service packs, including regression, performance, and user acceptance testing (UAT) phases to ensure compliance with business requirements and performance benchmarks.

Experience in build tools like Maven, Ant, Gradle and NPM.

Created Repos in the JFrog Artifactory for storing the generated Maven and npm artifacts from Jenkins.

Designed a normalized database schema for a high-transaction application, ensuring ACID compliance and supporting a 20% increase in concurrent transactions without compromising performance.

Designed and implemented relational databases, data marts and developed the reports to allow users to easily access the data.

Independently led a digital transformation project that resulted in a 40% increase in operational efficiency by automating manual processes, showcasing the ability to manage projects from conception to implementation without direct supervision.

Developing and Improved performance to Cognos Analytics Reports and Dashboards, which are taking longer time

Involved in Code Review, Unit testing, logging, and Custom Logging in SSIS Packages.

Created database objects like Cluster/Non-Cluster Index, Constraints, Views, Stored Procedures, and Triggers as per the requirement.

Designed and implemented relational databases, data marts and developed the reports to allow.

Created the SSRS reports like Tabular, Matrix, Charts, Gauge, and List.

Implemented the SSRS subscriptions.

Managed a diverse workload of simultaneous projects under tight deadlines, effectively prioritizing tasks and leveraging time management skills to deliver all projects on schedule with a 100% completion rate.

Oversaw the administration of a 10TB Oracle database environment, implementing performance tuning practices that reduced query response times by 30% and increased overall system efficiency.

Deployed the SSRS Reports and provided the security to end users.

Worked on technical document preparation for the changes.

Optimized Cognos configuration settings to leverage new features and improvements in releases, contributing to enhanced report generation speed and user experience.

Developed and documented reporting standards and best practices for paginated report design, ensuring consistency, accuracy, and compliance with regulatory requirements across all reports.

Worked on the SSAS cube script and deployed the SSAS cubes.

Implemented SSAS Cube action changes for drill-through reports.

Managed cross-functional teams on database upgrade projects and API development initiatives, delivering on time and within budget while achieving key performance indicators.

Created the Calculated measures using the MDX function in SSAS cubes.

Implemented the Dashboard, Apps, and alerts in the Power BI cloud.

Developed and implemented automated testing frameworks using tools like Selenium and IBM Rational Functional Tester, significantly reducing manual testing efforts and accelerating the release cycles of Cognos reports and dashboards.

Optimized Power BI dashboards for mobile devices, ensuring accessibility and consistent user experience across platforms, which expanded analytics access to 90% of the workforce.

Developed comprehensive training materials and conducted workshops for over 200 project managers and team members, significantly increasing Planisware user adoption and proficiency across the organization.

Managed a portfolio of over 50 projects using Planisware, optimizing resource allocation, budget tracking, and milestone achievement, which improved project completion rates by 25% and reduced budget overruns by 15%.

Worked on migration from SSRS reports to Power BI and Paginated reports as per requirements.

Created the Power BI Reports and Dashboard as per the Client's Requirements

Created the apps and alerts in Power BI Service

Developing the Relational and Dimensional Model using Cognos Framework Manager and applied data level and object level securities.

Designed and implemented a high-availability cluster using Microsoft SQL Server Always On, achieving 99.99% uptime and minimizing business disruptions during maintenance periods.

Publish the Power BI reports and provide access to end-users.

Self-taught advanced Python programming to automate routine data analysis tasks, increasing personal productivity by 35% and contributing to more efficient data processing workflows within the team.

Created the Power Automate to automate the jobs for dataset refresh.

Provided production support for the customers by troubleshooting the issues.

Interacted with the team members based in diverse global locations.

Environment: Power BI, SQL Server 2016, Teradata, Cognos, SSIS, SSRS, SSAS and Power BI, MySQL,TFS, Windows Server 2016, CMDB

Client: Openet (Amdocs) Herndon, VA Mar 2021 - Dec 2022

Role: Power BI Developer

Responsibilities:

Collaborated extensively with business stakeholders to gain a comprehensive understanding of their reporting needs and validate the current reporting functionalities in place.

Created stored procedures and SQL queries to pull data into the power pivot model.

Developed custom-calculated measures using DAX in PowerBI based on business needs.

Designed, developed, and maintained Power BI graphical and visualization solutions with business requirement documents and interactive dashboards.

Work closely with business stakeholders to identify opportunities for process improvement through the development of reporting and analytics.

Utilized Planisware to generate insightful reports and dashboards for senior management, providing critical data on project performance, resource utilization, and ROI, supporting strategic decision-making.

Automated the generation of real-time performance dashboards using API data feeds, providing executives with key metrics and trends.

Demonstrated ability to extract critical data from SSAS cubes, a vital asset in the project. Proficiency to drive data-driven strategies and enhance decision-making processes in financial projects.

Provide expert-level guidance on operational process implementation and continually refine analytics to drive operational excellence.

Developed and optimized star schema-based data warehouses for multiple business intelligence projects, significantly enhancing report generation speed by 50%.

Ensured new Cognos releases maintained compatibility with integrated systems, including ERP, CRM, and data warehouses, preserving data flow and integrity across the ecosystem.

Developed comprehensive disaster recovery plans for critical databases, successfully conducting quarterly drills that demonstrated recovery time objectives (RTOs) and recovery point objectives (RPOs) compliance.

Proficiently employed Tableau to support critical data-driven decisions in our project. Developed dynamic dashboards and reports to visualize complex banking data, enhancing transparency and facilitating strategic insights for risk assessment, customer analytics, and operational efficiency improvements.

Implemented security measures in Power BI reports and T-SQL database operations, ensuring compliance with data governance and privacy standards.

Optimized report performance by implementing efficient data retrieval strategies, Paginated report generation time by up to 50%, which significantly improved user satisfaction and report accessibility.

Independently developed and proposed a customer feedback analysis tool that improved product development strategies, highlighting innovative thinking and the ability to execute ideas without external assistance.

Utilized QlikView in this project, revolutionizing data analysis and reporting to drive informed financial decisions and optimize customer experiences.

Collaborated with cross-functional teams, including BI developers, system administrators, and business analysts, to align testing strategies with organizational goals and user expectations.

Led the integration of third-party APIs (including payment gateways and CRM systems) with internal databases, streamlining data flow and improving process efficiency by 20%.

Establish a quality assurance process pertaining to business intelligence reporting.

Using PowerBuilder applications with their RAD features and user-friendly GUI, they enable the rapid development of custom solutions for tasks like account management, transaction processing, and customer interaction, enhancing efficiency and adaptability in the banking sector.

Conduct thorough reviews of output and consult with end users to address any deficiencies, implementing effective resolutions.

Optimized resource management using Planisware, effectively balancing workload across teams, reducing burnout, and improving overall team productivity and morale.

PowerBuilder applications, with their RAD capabilities and user-friendly GUI, are indispensable in financial projects. They enable the swift development of customized solutions for data analysis, reporting, and portfolio management, making them essential tools for efficiency and adaptability in the financial sector.

Extensive Unix/Linux scripting and Autosys proficiency are used in automation for data processes, ensuring accuracy and efficiency in financial analytics.

Implemented database activity monitoring tools, detecting and mitigating potential security threats in real-time.

Design and implement reporting audits to ensure accuracy and compliance. Collaborate with cross-functional teams and senior stakeholders to identify and comprehend key business challenges.

implemented dynamic Power BI dashboards and reports that provided real-time insights into key business metrics, driving a data-driven decision-making culture across the organization.

Implemented several DAX functions for various calculations for efficient data visualization in PowerBI

Utilized PowerBI gateway to keep dashboards and reports up to date on the company’s data sources.

Designed complex data-intensive reports in PowerBI using various graph features like gauge and funnel.

Utilized Power BI (Power Pivot/View) to design multiple dashboards to display information required by different departments.

Excellently adapted to remote work environment, maintaining and often exceeding productivity standards without in-person supervision, illustrating strong self-discipline and adaptability.

Collaborated with front-end developers to design GraphQL APIs that improved data retrieval efficiency by 40% and enhanced the end-user experience.

Managed the integration of Planisware with ERP, CRM, and HR systems, enabling seamless data flow and providing a unified view of project and business performance metrics.

Scheduled refresh and scheduling refresh in PowerBI service.

Developed calculated columns and measures queries in PowerBI desktop to perform analytical requirements.

Performed transformations in the PowerBI query editor to shape and model data.

Ensure deliverable compliance with all Commonwealth, DOH, BOL, and HHSDC, standards and procedures.

Environment: MS SQL Server 2017/2016/2012/2008 R2 Enterprise Edition, PowerBuilder applications (RAD, GUI), T-SQL, SSIS, SSRS, SSAS, C#, VB.NET, Qlik View, database, Unix/Linux, Power BI, Tableau, SQL, .Net, HDInsight Hadoop, Snowflake.

Client: Altice, USA-New York Jun2017 – Feb 2021

Role: Power BI/SQL Developer

Responsibilities:

Involved in the creation of various Business Intelligence/ Analytical Dashboards utilizing Power BI with global filters, calculated columns and measures using complex DAX calculations and transformations using Query Editor & Power Query Formula Language (M).

Worked extensively building Power BI Dashboards with quick insights into KPIs and Advanced analysis actions, Calculations, Parameters, Maps and Scatter plots, and Predictive Analysis using Python and R integration.

Used Trend Lines Statistics and Log Axes, Group hierarchies, and time intelligence to create detailed and summary-level reports and Dashboards with KPIs using Power BI.

Have replaced the Java Messaging Service (JMS) calls with AWS SQS and used AWS SDK to connect with Amazon SQS for bulk email processing.

Strengthened database security by enforcing encryption for data at rest and in transit, role-based access control (RBAC), and regular audits, ensuring compliance with GDPR and HIPAA regulations.

Worked on Power BI dashboards using stacked bars, bar graphs, scattered plots, waterfall charts, geographical maps, and Gantt charts using show me functionality.

Publishing of various kinds of live interactive data visualization dashboard reports and workbooks from Power BI Desktop to Power BI servers.

Experience in implementing and working on the python code using shell scripting. Performed troubleshooting, fixed and deployed many Python bug fixes.

Developed and maintained RESTful APIs serving as the backbone for a web application's data exchange, handling over 10,000 requests per minute with 99.95% availability.

Worked with installing, designing, and managing MS SQL Server 2012

Managed a repository of reusable data visualization templates and views.

Supported the Business Intelligence/Analytics data analyst with an understanding of business and data requirements and iteratively designed visualizations for initial concepts and prototypes that can be presented to customers for feedback.

Subscribed SQL Server Azure Cloud Services.

Created Database(s) on SQL AZURE.

Worked on Setting up SQL Azure Firewall.

Setting up Connection Strings and connecting SQL Server AZURE Databases from locally Installed SQL Server Management Studio (SSMS) for Developers

Applied snowflake schema techniques to segregate data effectively in a multi-tenant SaaS application, improving data security and access speed by 25%..

Worked on Incremental loading with Merge statements in Stored Procedures.

Scheduled SSIS packages with SQL Agent Job.

Developed complex T-SQL queries for data manipulation and transformation, enhancing data analysis processes and supporting advanced analytics projects, resulting in a 20% increase in reporting efficiency.

Conducted Training sessions for Power BI users and created the documents for end-user support.

Worked on all activities related to the development, implementation, administration, and support of ETL processes.

Used SSIS to create ETL packages to validate, extract, transform, and load data to data warehouse databases.

Contributed to developing and modifying coding standards for the team to ensure consistency, efficiency, and accuracy in reporting and data analysis. Performed capacity planning and growth prediction for client audit data.

Query tuning based on query execution plans, statistics, and profiling.

Created code-based solutions for application errors involving composite key manipulation.

Coded optimization objects including hierarchical flattening functions, strategic indexes, and staging tables as well as data and file partitioning.

Implemented best practices in data normalization to ensure data integrity and consistency across enterprise-level databases, minimizing data anomalies and redundancy.

Developed complex SSAS cubes with multiple fact measures groups and multiple dimension hierarchies based on the OLAP reporting needs.

Environment: Power BI, Power BI Pro, Power BI Desktop, Power BI Service, Power BI Gateway, SharePoint, Microsoft Office, Outlook, Microsoft Teams, Skype for Business, SQL Server 2017, SQL Server Analysis Services (SSAS 2019), DAX, T SQL, SQL Profiler, XMLA, MS Excel, Excess, Windows 8.

Client: Westliesoft Technologies, India Jan 2016- Mar 2017

Role: Power BI Developer

Responsibilities:

Worked closely with various teams across the company to identify and solve business challenges.

Gathering and Analysing requirements of clients, understanding and converting them into solutions with solid exposure to architecture, analysis, design, testing, development, deployment, documentation, and implementation.

Import Data from different data sources to create Power BI reports and Dashboards.

Experience in developing Reports, Charts, and Dashboards using Power BI Desktop and managing security based on requirements.

Worked on WAMP (Windows, Apache, MYSQL, Python/PHP) and LAMP (Linux, Apache, MySQL, Python /PHP) Architecture.

Created and worked with various SQL and NoSQL databases such as AWS RDS Aurora DB cluster, MySQL, DynamoDB, and MongoDB and connected to the database through DB Instances using the AWS Java SDK.

Transform, define, and navigate the data from the data source and perform merge and append queries using Power Query.

Performed transformations like Pivoting, Unpivoting, and Splitting of Columns using Power Query.

Created different drill-down reports using Power BI Desktop.

Created measures, calculated columns, and relationships, and performed time series analysis using DAX in Power BI.

Created hierarchies in Power BI Reports using visualizations like Bar charts and line charts.

Worked with both Import and Direct query modes to import data into Power BI for creating reports.

Used Power BI Gateways to keep the dashboards and reports up to date.

Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.

Created measures, and calculated columns in Power BI Desktop to show good data analysis techniques.

Created Power BI Reports using the Tabular SSAS models as source data in Power BI Desktop and published service reports.

Created reports utilizing SSRS, Excel services, and Power BI and deployed them on SharePoint Server as per business requirements.

Experienced in creating many dashboards by pinning many visualizations in the workspace as per the insights provided.

Troubleshoot and support reports in Power BI workspaces whenever there are issues in production.

Environment: Power BI, DAX, Power BI Gateway, Power Query, MS SQL Server 2016/2014/2012. MS Excel, Windows 8/10, Team Foundation, SQL Server Integration Services (SSIS), Service Now, SQL Server Analysis Services (SSAS)

Client:Mouri Tech, Hyd, India June 2013 - Dec 2015

Role: Power BI Developer

Responsibilities:

Working with Power query for intrinsic and Reusable Parameters with Static/ Dynamic dropdown values.

Involved in requirements analysis and data analysis to derive the business logic, and validation of data mappings.

As a Power BI developer responsible for the design, development, and production support of interactive data visualizations.

Created Power BI Dashboards using different types of Slicers and different visualizations like Bar Charts, Line Charts, Pie Charts, Clustered charts, etc.

Created stored procedures, SQL Joins, and T-SQL Queries to implement business rules and created data sets required for Power BI reports. Also used Azure data cubes data to import data to Power BI.

Responsible for building reports in Power BI from Scratch.

Handled data coming from various data sources and destinations like Excel, flat files, and CSV files.

Hosted SSIS, SSRS knowledge transfer, and data quality issue meetings with the client on a weekly/biweekly basis.

Implemented parameters in reports for user input fields as per business requirements.

Created the Dashboards with Tiles and pins from reports, and insights and shared it to user groups using Power BI Apps.

Performed various complex calculations and created custom measures using Data Analysis expression (DAX).

Worked with Power BI Report Server for Paginated reports and using Report Builder tool.

Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.

Environment: Power BI Desktop, Power BI Service, DAX, Power BI Gateway, Power Query, MS SQL Server 2012, SQL Server Management Studio, MS Excel, Windows 8.

Contact this candidate