Business Intelligence Sql Server
Resume:
Vijay Babu Madhineni
*****.*********@*****.***
https://www.linkedin.com/in/vijay-babu/
Summary:
12.5 years of Professional experience in the IT industry, involved in working on Tableau and in MSBI & PowerBI projects with extensive usage of ETL & Reporting tools like SQL Server Integration Services (SSIS) and SQL Server Reporting Service (SSRS).
Working in Agile methodologies and conducting standup meetings and collating deliverables.
Experience in Business Intelligence, Banking, Sales & Marketing,
Extensive working skills with different reporting tools for all deliverable projects through the projects delivered.
Leading a team of 4 and previously lead a team of 5 in earlier projects.
Strong knowledge of Power BI and Paginated Reports
Experience leading a team of 8+ members onshore & offshore assigning and taking care of the deliverables in time.
Using different sources form web API’s and build extract the source data from API’s and use it for reporting
Implementing different query parameters and working with different data sources in Power Bi.
Creating calculated columns using Data Blending and implements and using live query analysis in Tableau to create effective visualization.
As a business analyst working closely with stakeholders to understand their needs, document requirements, and analyze them to ensure they align with the business objectives based on Requirement Gathering and Analysis
As a Business analyst Examining existing business processes, identify areas for improvement, and recommend solutions to streamline operations and increase efficiency Business Process Analysis.
Managing the Azure subscription, including provisioning resources required for Azure Data Factory.
Monitoring Azure Data Factory resource usage and optimizing costs.
Implementing security measures and access controls for Azure Data Factory resources.
Managing backups, disaster recovery, and high availability configurations.
Data Analyst/Data Scientist: Proficient in writing queries and converting business requirements into visualization.
Proficient in DAX, SQL and Power Query, M-Query.
Working With Users to provide unlimited access to all management features for the organization depending on their role levels.
Working on Scheduling the Report refreshes and subscriptions based on the user requirement.
Query Optimization Tuning SQL queries to ensure efficient data retrieval and processing. Data Integration Building and maintaining pipelines to ingest and transform data from various sources into Snowflake.
Designing the overall data architecture and data flow within Azure Data Factory.
Defining data models, schemas, and metadata.
Ensuring data governance and compliance standards are adhered to.
Collaborating with other teams to integrate data pipelines with other systems and applications.
Worked with Microsoft Power BI, DAX expressions, Power View and Power Query integrated with share point.
Installation and configuration: Installing and configuring SharePoint servers and services according to organizational requirements.
User management: Managing user accounts, permissions, and access levels within SharePoint sites and content.
Security Implementation Implementing and maintaining security policies, access controls, and encryption within Snowflake.
Performance Monitoring Monitoring system performance and resource utilization and making recommendations for optimization.
Disaster Recovery Planning Developing and implementing backup and recovery strategies to ensure data integrity and availability.
Manage user permission to the capacity, manage workloads to configure memory usage.
Creating Gateways and assigning them to the datasets for the Refresh Schedule.
Education:
Bachelor of Technology Graduate in Computer Science as a specialization from Jawaharlal Nehru Technological University, 2012, Andhra Pradesh, India.
Technical Skills:
Operating System : Windows family.
Technologies : Microsoft Business Intelligence Tools (MSBI),Fabric
Databases : SQL Server (2008R2/2012), Snowflake.
ETL Tools : SQL Server Integration Services
Reporting Tools : SQL Server Reporting Services, Tableau, PowerBi
Methodologies : Agile, Waterfall
Power Tools : Power Apps,Power Automate
Professional Experience:
McLane, Temple, TX Jul 2024 to Present
Description:
McLane combines unmatched distribution expertise and scale, a proven history of strategic partnerships, and leading innovation to help retail and restaurant businesses of all sizes compete and grow. We’re trusted to distribute and serve America’s most beloved brands, earning their partnership–every day.
Sr. PowerBI Consultant
Responsibilities:
Development of dashboards on Power BI.
Creating Semantic models in Fabric and using them to create dashboards.
Working with Data Engineers and working on fabric on creation of Notebooks & Semantic models.
Working on building Lakehouse models in fabric environment and working on data.
Developing visual reports, dashboards and KPI scorecards using Power BI desktop.
Documenting changes and implementing them in new different environments like PROD, SIT, UAT.
Implementing Drill Through & Hyperlinks in Power BI report.
Worked with Microsoft Power BI, DAX expressions, Power View and Power Query integrated with share point.
Working with different data sources and accumulating the data for the creation of dashboards.
Creating paginated reports with cascading parameters for accurate filtering.
Creating grouping mechanism to segregate data in paginated reports.
Working on drilldowns and drill throughs in paginated reports to hide complexity of the data.
Converts existing SSRS reports to Power BI reports, considering differences in visualization capabilities and layout.
Implements interactive features such as drill-down, drill-through, and slicers to enhance user experience.
Collaborates with business users to validate report designs and ensure they meet requirements.
Conduct accessibility audits and make recommendations for improving the accessibility of designs.
Query Optimization Tuning SQL queries to ensure efficient data retrieval and processing. Data Integration Building and maintaining pipelines to ingest and transform data from various sources into Snowflake.
Develop wireframes, prototypes, and mockups to visualize and communicate design concepts.
Define interaction patterns, navigation structures, and information hierarchies to guide users through the interface.
Creating research reports and presentations to communicate findings to stakeholders.
Builds Power BI dashboards and reports based on the defined requirements.
Utilizes Power BI's advanced analytics features, such as forecasting and clustering, to provide deeper insights.
Performs testing to validate report accuracy and performance.
Configures app user interfaces, data connections, and logic using low-code/no-code development tools.
Create wireframes, prototypes, and mockups to visualize and communicate design concepts.
Define interaction patterns, navigation structures, and information hierarchies to guide users through the interface.
Develops training materials and conducts training sessions for end users on how to use Power BI.
Provides ongoing support and guidance to users as they transition from SSRS to Power BI.
Environnent: SQL, POWER BI, SSRS,Fabric,Agile,Paginated Reports,SSIS
Zachry Construction, San Antonio, TX Jul 2021 to June 2024
Description:
Zachry Construction is one of the leading Construction in San Antonio USA.
Zachry Group is North America's pacesetter in turnkey construction, engineering, maintenance, turnaround and fabrication services to the power, energy, chemicals, manufacturing, and industrial sectors
Sr. PowerBI Lead
Responsibilities:
Development of dashboards on Power BI.
Developing visual reports, dashboards and KPI scorecards using Power BI desktop.
Documenting changes and implementing them in new different environments like PROD, SIT, UAT.
Implementing Drill Through & Hyperlinks in Power BI report.
Worked with Microsoft Power BI, DAX expressions, Power View and Power Query integrated with share point.
Working with different data sources and accumulating the data for the creation of dashboards.
Creating paginated reports with cascading parameters for accurate filtering.
Creating grouping mechanism to segregate data in paginated reports.
Working on drilldowns and drill throughs in paginated reports to hide complexity of the data.
Converts existing SSRS reports to Power BI reports, considering differences in visualization capabilities and layout.
Implements interactive features such as drill-down, drill-through, and slicers to enhance user experience.
Collaborates with business users to validate report designs and ensure they meet requirements.
Conduct accessibility audits and make recommendations for improving the accessibility of designs.
Query Optimization Tuning SQL queries to ensure efficient data retrieval and processing. Data Integration Building and maintaining pipelines to ingest and transform data from various sources into Snowflake.
Develop wireframes, prototypes, and mockups to visualize and communicate design concepts.
Define interaction patterns, navigation structures, and information hierarchies to guide users through the interface.
Leading a Team of 5 working with in assigning and proposing solutions.
Creating research reports and presentations to communicate findings to stakeholders.
Builds Power BI dashboards and reports based on the defined requirements.
Utilizes Power BI's advanced analytics features, such as forecasting and clustering, to provide deeper insights.
Performs testing to validate report accuracy and performance.
Configures app user interfaces, data connections, and logic using low-code/no-code development tools.
Create wireframes, prototypes, and mockups to visualize and communicate design concepts.
Define interaction patterns, navigation structures, and information hierarchies to guide users through the interface.
Develops training materials and conducts training sessions for end users on how to use Power BI.
Provides ongoing support and guidance to users as they transition from SSRS to Power BI.
Collects feedback from users to identify areas for improvement and additional training needs.
Designing the overall data architecture and data flow within Azure Data Factory.
Defining data models, schemas, and metadata.
Ensuring data governance and compliance standards are adhered to.
Collaborating with other teams to integrate data pipelines with other systems and applications.
Environnent: SQL, POWER BI, SSRS,Agile,Paginated Reports,SSIS,Power Apps,Power Automate
AIA-Health, Malaysia
Nov 2020 to Mar 2021
Application Developer Specialist
Description:
Working with AIA SYSTEMS by collating all the data of almost 18 BU’s of all the Insurance domains related data and collating the data and from there transforming the data and analyzing on different systems and converting into meaningful visualizations that helps end users to relay on that and check the KPI’s accordingly.
Responsibilities:
On boarding of new data sets into data warehouse
Developing visual reports, dashboards and KPI scorecards using Power BI desktop.
Created the Power BI Reports for the Financial Data and embedding the reports in Web Application.
Involved in Architecting and developing the Azure data factory pipelines by creating the datasets and source and destination connections to move the data from oracle database to Azure Data Lake Data Lake Store Raw Zone.
Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.
Manages access control and permissions for Power Apps and Power Automate environments.
Monitors app and workflow performance, security, and compliance.
Creates automated workflows using Power Automate.
Designs and implements automation solutions to streamline business processes.
Integrates Power Automate workflows with other applications and services.
Configures triggers, actions, and conditions to automate tasks and processes.
Provides technical support and troubleshooting for users encountering issues with apps or workflows.
Manages licensing, updates, and version control for Power Platform components.
Collaborates with other IT teams to ensure integration and compatibility with existing systems and infrastructure.
Designing, building, and maintaining data pipelines within Azure Data Factory.
Developing Extract, Transform, Load (ETL) processes to move data from various sources to target destinations.
Implementing data transformations and data cleansing operations.
Monitoring pipeline performance and troubleshooting issues.
Developing, publishing and scheduling Power BI reports as per the business requirements.
To understand the business requirements and develop the reports accordingly.
Environnent: SQL, POWER BI,Waterfall,SSIS, Power Apps,Power Automate
GENCO, Malaysia Jun 2020 to Oct 2020
Senior Application Engineer
Description:
Working with Genco Systems for the data reconciliation and migrating the data from different other systems to SQL Servers by using ETL. Once data into servers calculating the usage and generating the power bill Invoices based on the use age and plans. Applying promotions and several offers based on eligibility and creating the account details and tracking the usage. Once the usage is into db’s creating the power bi dashboards and calculating based on different KPI’s.
Responsibilities:
Development & Maintenance of Data-Warehouse with MS SQL Server & SSIS
Trouble Shooting ETL workflow and working on the databases that bug has been raised.
Involved in creating power BI reports in Direct Query Mode.
On boarding of new data sets into data warehouse.
Used complex SQL queries and Excel for data cleaning, transformation, profiling the customer data, which is extracted from various data sources.
Extensive experience on SOAP & REST APIs for remotely interacting with Data Relationship Management server, Planning and Essbase instances.
Performed DAX (Data Analysis Expressions) & MDX functions for the creation of calculations and measures in the Tabular Mode & multi-dimensional Cubes.
Familiarity with data modeling, data warehousing, and ETL processes
Understanding of data governance and security best practices
Proficiency in SQL and data query languages (e.g., DAX, MDX)
Experience with migration and integration projects
Developing visual reports, dashboards and KPI scorecards using Power BI desktop.
Documenting the new changes and implementing them in new different environments like PROD, SIT, UAT.
Sharing of Power BI reports and managing workspaces in Power BI service.
Built a Tabular Model cube from scratch data and by MDX and DAX queries fetched data to SSRS and Power BI reports.
Developing, publishing and scheduling Power BI reports as per the business requirements.
Strong knowledge of both TIBCO Cognos and Microsoft Power BI
Experience with data visualization, reporting, and business intelligence
Environnent: SQL, POWER BI,Waterfall,SSIS,Paginated Reporting,SSRS
PETRONAS, Malaysia
Dec 2019 to Jun 2020
Senior BI Developer
Description:
Working with GP Systems for the data reconciliation and migrating the data from different other systems to SQL Servers and embedding the data in the API with the help of .Net team working with Power bi desktop for the creation of Dashboards and helping on Maintenance of Data. Working on the daily subscriptions. Working around with direct Stake holders and gathering the requirements and developing the Power Bi desktop creating the dashboards and publishing them. Tracking the master data and the data of the systems that are requesting for the purchases and even embedding the billing information of the purchases and tracking the errors raised during this process been tracked with in the dashboard with the complete information in the reports.
Responsibilities:
Development & Maintenance of Data-Warehouse with MS SQL Server & SSIS.
Power BI development and administration.
On boarding of new data sets into data warehouse
Worked with DAX/MDX queries in building expressions for various business calculations.
Developing visual reports, dashboards and KPI scorecards using Power BI desktop.
Connecting to data sources, importing data, and transforming data for Business Intelligence.
Developed complex reports in Crystal Reports from multiple data sources like Universes and SQL queries.
Worked in Creating Calculations using MDX and Supported DAX expressions which were using Pivot table reports.
Developing, publishing and scheduling Power BI reports as per the business requirements.
To understand the business requirements and develop the reports accordingly.
Involved in designing and analyzing the requirement analysis.
Developing reports with report builder.
Environnent: Power Bi, SQL Server, SSIS,Agile
DUTCH LADY, Malaysia Mar 2019 to Nov 2019
Business Intelligence/Analyst Developer
Description:
Working with DMS Systems for the data reconciliation and migrating the data from different other systems to SQL Servers by using ETL’s and working with Tableau server for the creation of Dashboards and helping on Maintenance of Data. Working on the daily jobs. Working around with direct Stake holders and gathering the requirements and developing the Tableau Dashboards and ETL’s they will be efficient in retrieving the data and scheduling the jobs to acquire the data
Responsibilities
Development & Maintenance of Data-Warehouse with MS SQL Server & SSIS
Creating the Dashboards in Tableau for the data representation in the form of dashboards for stake holders.
Scheduling the data refresh in the Tableau server once the data source systems are populated with the data.
Working on the Enhancements of Tableau dashboards as per the change Request
Creating users adding users to the tableau dashboards and maintaining them
Working on and creating ETL packages to load the data.
Designing and implementing of ETL Transformations with SSIS.
As a Business analyst Examining existing business processes, identify areas for improvement, and recommend solutions to streamline operations and increase efficiency Business Process Analysis.
As a Business analyst need to analyze data to identify trends, patterns, and insights that can inform decision-making and drive business strategy based on Data Analysis
creating detailed documentation such as business requirements documents, functional specifications, and process flows to communicate requirements and solutions to stakeholders and development teams Documentation & Stakeholder Management
As a business analyst will be working on continuously monitoring and evaluating business processes and systems to identify opportunities for improvement and innovation for Continuous Improvement,Domain Knowledge & Effective communication skills
Environnent : SSIS, TABLEAU, Power Bi, SQL Server, Agile
PETRONAS, Malaysia
Aug 2018 to Mar 2019
Business Intelligence Specialist
Description:
PETRONAS, short for Petroliam Nasional Berhad (National Petroleum, Limited), is a Malaysian oil and gas company. I am Working on the Project named IPPM (INTEGRATED PRODUCTION PERFORMANCE MANAGEMENT) which integrates the production data to the current data and forecast the future production of oil and gas and will be working on the data retrieving from other systems handling through ETL processing through below roles.
Responsibilities:
Development & Maintenance of Data-Warehouse with MS SQL Server & SSIS.
Solution design and implementation
Creation, Testing of ETL jobs.
Working on and creating ETL packages to load the data.
Designing and implementing of ETL Transformations with SSIS.
Review test scenarios for UT, SIT, UAT and Production and Support team on defect analysis and resolution.
Designed SSIS ETL Packages for extracting data from heterogeneous source systems, transforming and finally loading into the Target Tables.
The packages created included a variety of transformations, for Execute SQL Task, Lookup, Aggregate, Derived Column, Conditional Split and Data Conversion.
Expertise in providing Logging, Error handling by using Event Handler, for SSIS packages.
Environnent : SSIS, Power BI, SQL Server,Waterfall
Mindtree
Oct 2017 to Aug 2018
Module Lead
Description:
Commercial Investment Trust and went by the initials of C.I.T. By that time, the company provided financing for wholesale suppliers and producers of consumer goods. The company added automobile financing to its product line in 1916, through an agreement with Studebaker, the first of its kind in the auto industry. During World War I, CIT financed the manufacture of 150 submarine chasers. It also added consumer financing of radios through an agreement with Thomas Edison, Inc. During the Roaring 20s following the war, consumer spending rose dramatically, and CIT prospered in its consumer appliance, furniture, and automobile financing groups.
Responsibilities:
Working on Denodo Sources to create the flow of the data.
Working with Sql data sources by using the flow in Denodo.
Working with sql server data to check the data flow and data sources.
Checking the breakage of the data and work on data flow is successful from data source to destinations.
Working on project Requirements BRD’s delivering the deliverables as per the sprint time lines.
Working on creating jobs for the data load
Writing SQL Queries to user requirements
Strong knowledge of both TIBCO Cognos and Microsoft Power BI
Experience with data visualization, reporting, and business intelligence
Converting Cognos analytics and data connections to equivalent Power BI components
Optimizing data models and queries for Power BI performance
Implementing new visualizations and features in Power BI to enhance reporting capabilities
Collaborating with stakeholders to understand reporting requirements and ensure successful migration
Manages data integration and preparation tasks within Cognos.
Implements data pipelines to extract, transform, and load (ETL) data into Cognos from various sources.
Optimizes data models and structures for efficient analysis and visualization.
Collaborates with Cognos developers and administrators to ensure data availability and quality.
Understanding of data governance and security best practices
Environment: SQL Server,Agile,denodo,Cognos
Accenture Jun 2016 to Oct 2017
Application Development Analyst
Description:
Best Buy formed Redline Entertainment, an independent music label and action-sports video distributor. The Project will be able to provide the information of business of the client. The system helps in improving the sales of the business of audio-video, electronic goods all over the geographic locations by providing information of customer details according to sales and the report will be generated and supplied accordingly.
Responsibilities:
Designing the Reports as per client Requirement and created the reports using Excel file and SQL Server database.
Analyzing user requirements, validate available data and propose usable designs.
Experience in end-to-end development of a new set of reports, dashboards & KPI Scorecards.
Mainly design and develop Tableau dashboards from scratch to support.
Experience in connecting and extracting data from different data sources.
Data blending to create views combining data from multiple data sources.
Highlighted the views by Annotations (Point, Mark, and Area) wherever it requires.
Designing and developing reports using Power BI Paginated Reports (formerly known as Power BI Report Builder)
Ensuring reports are optimized for printing and exporting
Collaborating with data analysts and business stakeholders to understand reporting requirements
Troubleshooting report rendering and data issues in Power Bi paginated reports
Keeping up-to-date with new features and best practices in Power Bi Paginated Reports
Creating a grouping mechanism to segregate data in paginated reports.
Working on drilldowns and drill throughs in paginated reports to hide complexity of the data.
Environment: Power BI, Tableau, SQL Server, Paginated Reporting
Accenture May 2015 to May 2016
Application Development Analyst
Description:
TGP for BPO is the internal Client of Accenture Which handles most of all the Bpo clients of Accenture. These projects are handled by Avanade which works for all Microsoft technologies in Accenture.
Responsibilities:
Deployment and Job Scheduling of SSIS Packages based on Business Requirement using SQL Server Agent Job.
Creating Tabular, Parameterized, Drill Through, Drill Down, Matrix and Sub Reports in
SSRS.
Doing Unit Testing and Data Validation to make sure the output data of the report is.
exactly matching with Data Base Queries.
using various control flow items for each loop, for loop and data Flow transformations
conditional split, multicast, derived column, lookup, union all, Merge, Merge join.
Analyzing user requirements, validate available data and propose usable designs.
Experience in end-to-end development of a new set of reports, dashboards & KPI Scorecards.
Creation, Testing of ETL jobs.
Working on and creating ETL packages to load the data.
Designing and implementing ETL Transformations with SSIS.
Review test scenarios for UT, SIT, UAT and Production and Support team on defect analysis and resolution.
Working on RDL’s for paginated reports.
Creating a grouping mechanism to segregate data in paginated reports.
Working on drilldowns and drill throughs in paginated reports to hide complexity of the data.
Environment: SQL, SSIS, SSRS, Paginated Reporting
Unilever Ltd (Saswin Consulting), India May 2012 to May 2015
BI Developer
Description:
The Project will be able to provide the information of business of the client. The system helps in improving the sales of the business by providing information on customer details according to the location. As the business of our client is expanding, he wanted to understand better about the business and to analyze the trend
Responsibilities:
Create and Modify SQL scripts to cater to the requirements.
Creation and modification of SSRS reports meeting business requirements.
Support and Resolve production incidents.
Development of ETL packages
Support for parallel run in Merge file comparisons.
Comparing the data files generated with the actual live data.
Creating Paginated reports and deploying them.
Creating paginated reports with cascading parameters for accurate filtering.
Assigning security to paginated reports which helps to provide access only to particular group
Environment: SQL, SSIS, SSRS, MSBI, Paginated Reportin, Waterfall
Contact this candidate