| | | 20,000+ Fresh Resumes Monthly | |
|
|
| | Related Resumes Power Bi Sql Server Cumming, GA SAS Programmer, Power Bi, SQL, Python, Pharmacy Technician Alpharetta, GA Power Bi & Sql Server Cumming, GA Sql Server Power Bi Snellville, GA Data Analyst Power Bi Atlanta, GA Power Bi Business Intelligence Atlanta, GA Data Engineer Power Bi Marietta, GA |
|
Click here or scroll down to respond to this candidateCandidate's Name
Email: EMAIL AVAILABLEPh: PHONE NUMBER AVAILABLELinkedIn: LINKEDIN LINK AVAILABLEProfessional Summary:9+ years of extensive working experience in Data Warehouse, Microsoft SQL Server, End to End reporting solution using Power BI, MicroStrategy, Tableau, Snow Flake & Business ObjectsHands on experience in migrating reporting solution from one to other notably from Business Objects to MicroStrategyExcellent written and verbal communication skills to articulate, and professional speaking abilitiesPython skills that are required for data transformations and data analysisExpertise in writing complex advanced SQL using window functions and multiple join clausesWorked with different data sources like Oracle, SQL Server, MySQL, MySQL, TeradataStrong working experience on DAX functions including Time intelligence, Date and Time, Filter, information, logical, statistical and text to create more complex analytic reports.Used DAX functions for the creation of calculations and measures.Strong knowledge of Data Warehousing methodologies and concepts including star schemas, snowflakes, ETL processes, dimensional modeling, and reporting tools.Created complex DAX calculations in Power BI, created data models and implemented one to many relationships.Proficient in applying transformation rules - Data Conversion, Data Cleansing, Data Aggregation, Data Merging and Data splitting.Experience on publishing Power BI reports into Power BI server and scheduling the dataset refresh for getting latest data into power BI server.Experience in report performance tuning of Power BI reports and enhancing user experience with end-to-end reporting life cycle and complex visualization techniques.Good knowledge in Business Intelligence (BI)/ data warehouse (DWH) concepts and project implementations.Created hierarchies in Power BI reports using Data visualizations like Bar chart, Line chart, pie charts, waterfall charts.Expertise in handling multi-sourcing data sources onto the reporting solutionExperienced working proactively in identifying the issues, escalating, and communicating the issues to the stakeholders.Expertise in tuning performance of the reporting solutionVery proactive and took initiative in taking up additional responsibilities in every project worked.Have 3 US PATENTs on my name - Query Generation from natural language inputTechnical Skills & ToolsProgramming LanguagesPython, Advanced SQLReporting ToolsPower BI, MicroStrategy, Tableau, Business ObjectsCloud PlatformAzureToolsInformatica, Horizon JIRA, SQL Toad, RemedyBig DataSparkDatabaseSnowflake, SQL Server, Teradata, OracleProfessional Experience:Ericsson, Plano, TX July 2019 to PresentBI Reporting DeveloperResponsibilities:Technology Stack: Power BI, Tableau, Power Query, Snow Flake, SQL Server, JIRA, Python, MicroStrategy.Work on Data Modeling, create reporting solution using Power BIHands on experience with database Stored Procedures, tables, Views, indexes, and DAXHands on experience with Calculate, Calculate all, Related, Recursive functions in DAX.Extensive experience in Data Analysis Expressions (DAX) language with thorough understanding of ROW and FILTER contexts.Experience in Data Warehouse Star Schema Modeling, Snow-Flake Modeling, FACT& Dimension Tables, Physical and Logical Data Modeling.Strong working experience on DAX functions including Time intelligence, Date and Time, Filter, information.Developed advanced visualizations in Tableau, such as heat maps, scatter plots, and geographical maps, to represent data trends and patterns.Developed and managed ETL pipelines using Google Cloud Dataflow and Data prep to prepare data for Power BI reports and dashboards.Integrated Power BI with Google Big Query to enable real-time and large-scale data analysis and reporting.Designed and implemented data warehouses and data lakes on GCP, leveraging Big Query and Cloud Storage to store and manage large datasets for analysis in Power BI.Logical, statistical and text to create more complex analytic reports.Various forms of dashboard development performed including Data from SAP BW through Bex Queries, Data from Universe using QAAWS, Data from Web reports, Crystal Reports using Live Office etc.Developed SSRS reports integrated into a Power BI dashboard, offering a unified view of operational metrics and performance indicators.Designed and implemented OLAP cubes using SSAS to support enterprise-wide data reporting and analytics. Developed complex data models and integrated them with Power BI for real-time data visualization.Conducted regular performance tuning and optimization of SSAS models to ensure high efficiency and accuracy of data analysis.Skilled in using MicroStrategy for business intelligence and data analysis tasks.Experience in designing and building interactive dashboards for data visualization and analysis purposes.Managed end-to-end Power BI projects integrating data from SQL Server, including requirement gathering, data modeling, report development, and deployment.Used SQL Server Integration Services (SSIS) to extract, transform, and load data from various sources into SQL Server.Developed data models in SQL Server to support analytical needs and reporting in Power BI.Managed and maintained SQL Server databases, ensuring data integrity, security, and performance optimizationDeveloped complex SQL queries to extract, manipulate, and analyze data from SQL Server databases, supporting various business intelligence needs.Integrated data from multiple sources into SQL Server, performed data cleansing and transformation, and built Power BI reports for visualization.Developed and maintained ETL processes using Informatica to support the data warehousing and business intelligence initiatives.Developed data models and schemas in SQL Server to support reporting and analytics, ensuring data consistency and accuracy.Connected Tableau to various data sources, including SQL Server, to create comprehensive and real-time data visualizations.Conducted performance tuning and optimization of SQL Server databases and queries to enhance data retrieval speeds and overall system performance.Designed and developed interactive dashboards and visualizations in Tableau, providing actionable insights for stakeholders.Developed and maintained a wide range of SSRS reports, providing detailed and actionable insights for various departments.Developed and maintained SSAS cubes with complex aggregations and calculations to support business intelligence (BI) reporting needs.Designed and developed OLAP cubes and tabular models using SSAS to facilitate multidimensional data analysis and reporting.Improved the performance of existing ETL processes by optimizing Informatica workflows and mappings.Proficient in generating and customizing reports to extract actionable insights from data.knowledge about integrating MicroStrategy with various data sources and systems for comprehensive analytics.Managed the deployment and scheduling of SSRS reports, ensuring timely delivery and accessibility for stakeholders.Experience working with other ETL tools and platforms, such as SSIS and Power Query, in addition to Informatica.Proficient in documenting MicroStrategy projects, including requirements, design, and implementation details.Skilled in troubleshooting issues and providing solutions to ensure the smooth operation of MicroStrategy implementations.Skilled in using Domo's ETL capabilities to clean, transform, and load data into the platform.Improved dashboard performance by optimizing data flows and ensuring efficient data processing within Domo.Work closely with product owners to understand the requirements, KPIs and the needed business data logic.Participate in data modeling discussions and design schemas and tables for the new requirements.Participating in daily scrum call to update and understand the status of the development.Provided training and support to team members on using Tableau, enabling them to leverage the tool for their own data analysis needs.Lead and mentor a team of 8 BI developers, 2 data analysts. Assign tasks and help them perform the necessary actions to meet the timelines.Connect Power BI to Snow Flake and build reports on top.Perform ETL using Snow FlakeMicron, NY Jan 2018 Jun 2019Power BI DeveloperResponsibilities:Technology Stack: MicroStrategy, Power BI, Tableau, Snowflake, SQL Server, JIRA, PythonWorked as Data Engineer and built reporting solution for Customer Incentives System project and Federal Deposit Insurance Corporation (FDIC)Created complex dashboards and dossiers.Worked closely with product owners to understand the requirements, KPIs and the needed business data logic.Experience in integrating SSRS reports into Power BI, allowing for a comprehensive and seamless reporting and analytics solution.Optimized SQL queries to improve the performance and efficiency of data retrieval processes.Participated in data modeling discussions and designed schemas.Implemented data quality checks and validations within SQL Server to maintain high standards of data accuracy and reliability.Skilled in using Google Cloud Dataflow for data extraction, transformation, and loading (ETL) processes to prepare data for Power BI reports.Experience in developing and managing ETL pipelines using Google Cloud Data prep to cleanse, transform, and enrich data before loading into Power BI.Experienced in managing SSRS report deployment, scheduling, and delivery.Fine-tuned the solution as underlying database is huge which required creating materialized views.Executed the project using AGILE methodology.Conducted performance tuning and optimization of Snowflake queries and data pipelines to ensure efficient data retrieval and processing.Built and optimized SSAS tabular models to support customer incentives reporting. Integrated SSAS models with Power BI to provide comprehensive insights into customer data.Proficient in designing and developing OLAP cubes and tabular models in SSAS.Skilled in performance tuning and optimization of SSAS models for efficient data processing and query performance.Conducted performance tuning and troubleshooting of SQL Server databases to resolve bottlenecks and enhance system performance.Developed and deployed business intelligence solutions using Power BI and SQL Server, leading to improved decision-making processes for stakeholders.Conducted a thorough review and optimization of existing Informatica ETL processes, resulting in a significant reduction in data processing times.Automated data workflows using Snowflake's features such as tasks, streams, and Snow pipe, leading to a more efficient and reliable data pipelineFiled Different Operational Excellence projects/automations for improving the teams utilization.Filed 3 Patents of which 1 is approved with USPTO and 2 are in review.Trained stakeholders in understanding the BI tools environment, different options involved in creating ad-hoc reporting.Performed data blending in Tableau to combine data from multiple sources, providing a comprehensive view for analysis.Optimized data sources in Tableau by managing extracts, implementing incremental refreshes, and using live connections where appropriate.Created Tableau story points to present data narratives, guiding stakeholders through key insights and analyses.Developed complex, efficient SQL queries to support various business reporting needs in Power BI, leveraging Snowflake's processing power.Integrated complex data sources from Data Lake and Databricks into Power BI dashboards.Automated workflows using Databricks notebooks and jobs scheduler to ensure timely data processing.Used Databricks notebooks for collaborative data exploration and analysis before integrating with Power BI.Conducted big data analysis in Data Lake and visualized the results using Power BI dashboards.Worked closely with data engineers, analysts, and business stakeholders to gather requirements and deliver tailored data solutions using Snowflake and Power BI.Organized sessions with Line of Business tech teams to explain the newest options in the BI tools and implemented the same in the solution.While design the Power Bi reports and dashboards, the measures are created using DAX programming language.Developed and maintained Power BI and Tableau dashboards to track city KPIs, providing real-time insights for executive leaders.Created detailed reports on CRM data for various departments, enabling better customer relationship management and targeted marketing strategies.Writing all the calculations using DAX formulas.Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.Utilized advanced Excel functions and formulas to perform in-depth data analysis, complementing Power BIs capabilities.Integrated Excel data with Power BI, allowing for seamless updates and real-time data visualization.Implemented incremental refresh at Power BI Desktop level and scheduled the data refresh for dashboards and reports to show the updated data.Client: SIFY Technologies, India Apr 2015 Nov 2017Power BI DeveloperResponsibilities:Technology Stack: MicroStrategy, Power BI, Tableau, SQL Server, Snowflake, JIRA, PythonWorked as Senior Analyst and supported Enterprise Data Registry project.Created management reports, dashboards.Worked closely with product owners to understand the requirements, KPIs and the needed business data logic.Integrated CRM systems with Power BI to streamline data flow and ensure accurate, real-time reporting on customer interactions and sales metrics.Created comprehensive documentation for Power BI reports and dashboards, including user guides, technical specifications, and data dictionaries.Developed and managed data ingestion pipelines to load structured and unstructured data into the data lake.Developed and maintained Power BI datasets and reports based on data lake sourcesDeveloped Power BI dashboards that provide insights into CRM data, including sales performance, customer satisfaction, and pipeline management.Developed and maintained ETL/ELT processes using Snowflake's native capabilities, integrating data from various sources.Designed and developed custom visuals and interactive reports in Power BI based on data from Databricks.Performed data cleaning and preprocessing in Databricks to ensure high-quality data for Power BI.Documented ETL processes, data models, and governance policies in Microsoft Word to support data management and compliance efforts.Created and maintained dashboards and reports in Power BI using data processed in Databricks.Utilized advanced SQL for complex data transformations, querying, and reporting within Snowflake.Participated in data modeling discussions and designed schemas in MicroStrategy.Executed the project using AGILE methodology.Connected and integrated Snowflake with Power BI to create dynamic, real-time dashboards and reports.Created a One-Stop tool using HTML, CSS, and JavaScript as part of Operational Excellence.Educational Qualifications:Bachelor of Engineering in Information Technology from Osmania University Hyderabad, India |
