Home

Siddharth Mentireddi - Data Analyst / Power Bi

[email protected]

Location: Brookeville, Maryland, USA

Relocation:

Visa: H1B

Siddharth Mentireddi Sr Data Analyst/ Power BI Developer +1 5514656544 [email protected] https://www.linkedin.com/in/srmrao/ __________________________________________________________________________________________________ Professional Summary: Over 12+ years of Experience in Database Administration and Business Intelligence applications design, development, Microsoft Dynamics, and Maintenance for Oracle DB, MS SQL Server using BI tools such as Tableau and Power BI. Strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming, and problem-solving skills. Expertise and hands on experience of migrating and upgrading insurance suite solutions to Guidewire solutions as well as integrating third party solutions to Guidewire solutions. Involved in designing SQL programming artifacts such as complex queries, stored procedures, triggers (DDL and DML), indexes, and user-defined functions. Design and build dimensional data models in Power BI Desktop, optimizing performance and scalability. Develop complex data transformations using Power Query M language, handling various data sources and formats. Experience in developing complex applications on Microsoft Dynamics CRM platform with customization of entities, sitemap writing client-side JavaScript. Expertise in disparate reporting needs OLTP, OLAP, interactive, printable, adhoc, canned, summary-detail, hierarchy, time intelligence (MoM, YoY), trend (trend analysis), drill-through (navigational), KPIs, dashboards etc. Implement advanced modeling techniques like calculated columns, measures, and hierarchies. Create and manage relationships between tables to ensure data consistency and accuracy. Design impactful and informative dashboards and reports using Power BI visuals and formatting options. Implement advanced visualization techniques like custom visuals, drilldowns, and storyboards. Apply best practices for data storytelling and user experience optimization. Develop dynamic reports with interactive filters, slicers, and other user controls. Manage Power BI Service workspaces and user access controls. Significant knowledge of Dynamics CRM Online, and the O365 platform as it pertains to feature sets that integrate with Dynamics CRM solutions. Configure gateways and data refresh schedules for automated data updates. Monitor and troubleshoot performance issues in Power BI reports and dashboards. Implement version control for Power BI artifacts using tools like git. Conduct user training and provide ongoing support for Power BI adoption within the organization. Analyze and interpret data using DAX to derive meaningful insights and support decision-making. Connect to various data sources like relational databases, cloud platforms, flat files, and APIs. Develop and maintain data pipelines using Power BI Desktop and other integration tools. Perform data mapping and transformation to ensure data consistency across disparate sources. Troubleshoot connectivity issues and optimize data refresh performance. Leverage knowledge of star and snowflake schemas to optimize data models for efficient querying and analysis. Utilize proficiency in SQL queries, SQL Agent jobs, and stored procedures for data extraction, manipulation, and automation. Expertise in Microsoft Dynamics 365/CRM service programming, development, and Application Integration capabilities such as creating a customer portal solution. Excellent technical skills in SQL to extract, transform and loading data to the database using tools such as Guidewire Data hub. Integrate Power BI with other tools like Power Automate, SharePoint, ServiceNow reports, and AMDB for comprehensive data analysis and reporting workflows. Understand REST APIs and authentication methods and apply data security principles for secure data access and governance. SKILL SET: BusinessIntelligence Tools: Power- BI, MS Dynamics,Tableau MS-BI stack (SSIS, SSRS, SSAS). ETL Tools: Informatica Power Center, SSIS, Alteryx Operating Systems: Windows, Unix, Mac Databases: SQL Server, Oracle11g, Teradata, SAP HANA, DB2, Snowflake, MS SQL Programming Languages: SQL, PL/SQL,Guidewire. Professional Experience Client: Medtronic - Minneapolis, MN Jan 2021 Present Role: Sr. Data Analyst (Power BI) Project Description: Medtronic is a global healthcare solutions company focused on medical devices and therapies to improve patient outcomes. Their innovative technologies span areas such as cardiac and vascular health, diabetes management, neurological disorders, and more Responsibilities Designed and developed interactive and visually appealing Power BI reports and dashboards. Utilized the guidelines and artifacts of the Rational Unified Process (RUP) to develop a detailed implementation process of Guidewire ClaimCenter Integration during different iterations and phases in Software Development Life Cycle (SDLC) Created Custom Entities, Custom attributes for individual Business Units in MS Dynamics CRM as per the Business Process. Configured Dynamics 365 F&O environment to meet requirements. Translated complex business requirements into effective data visualizations to facilitate decision-making. Created and optimized data models within Power BI to ensure accurate and efficient data analysis. Defined relationships between data tables and implemented best practices for data modelling. Responded to Dynamics 365 F&O support tickets, providing troubleshooting, issue resolution , and ticket closure. Extracted data from various sources, performed transformations, and loaded it into Power BI for analysis. Utilized Power Query to clean, shape, and combine data from diverse data sets. Enhancing MS Dynamics CRM 2016 usability by designing and optimizing navigation, forms, and layouts Conduct business analysis to gather and analyze requirements for the project, identify key data elements that need to migrate, business rules governing the data, and any specific reporting or analytics requirements. Collaborated with the business team in the creation and completion of project charters and project scope for Guidewire PolicyCenter Gather and understand the requirements from stakeholders. Developed and maintained Power BI dashboards with interactive visualizations. Segregated Datasets and Reports for complex design Responsible for supporting the Dynamics 365 F&O application to achieve the customer s business requirements. Involving in mapping customer requirements to MS Dynamics CRM 2016 Developed Paginated reports to enable download feature. Create App Workspaces and content packs to share insights. Designing data models and creating relationships between tables using DAX Created custom views, charts, graphs, filters, parameters, and data sources to meet specific user requirements. Created Custom Entities, Custom attributes for individual business units in MS Dynamics CRM, according to their business process Customized Workflows and Plug-in for automated processes, based on requirement from sales and marketing department to increase visibility and efficiency Analyzed large datasets to identify trends, patterns and correlations utilizing advanced analytics techniques in Tableau. Performed unit testing on all created reports and dashboards prior to production deployment. Deployed PBI Server security settings include authentication methods, permissions, and row-level security settings. Provided technical support on existing dashboards and reports by troubleshooting issues related to data accuracy or report functionality. Import and export data within MS Excel and MSFT Dynamics CRM. Validated Rating Algorithms for Schedule Rating, Experience Rating and Retrospective Rating using Guidewire Rating Management components. Responsible for designing and developing paginated reports using tools like Report Builder. Understand the data model and requirements to create appropriate datasets for paginated reports. Ensure pixel-perfect formatting and layout of the reports to meet business needs. Develop DAX formulas to create calculated columns, measures, and calculated tables based on business requirements. Performed data integration and data mapping management along with data cleansing while migrating data from legacy system to Guidewire PolicyCenter. Extensively used Advanced Find functionality and built Fetch XML s in Dynamics CRM. Analyze and interpret data using DAX to derive meaningful insights and support decision-making. Integrated various external APIs with PBI to enable real-time streaming of live data sets. Optimized SQL query execution times by making use of indexes and partitioning techniques to improve report performance. Work with the data governance team to catalog all objects migrated to Snowflake on AXON. Wrote Python scripts to extract data from various sources (e.g., APIs, databases) using libraries like pandas and requests. Provide input and advice regarding Microsoft Dynamics CRM capabilities and functions to client organizations, in relation to current business processes and effort estimation for configuration, customization and documentation. Performed data cleaning and transformation using Python libraries like pandas and NumPy to prepare datasets for analysis. Ensured adherence to relevant HIPAA Privacy and Security Rules for the role. Implemented and followed procedures to protect the confidentiality, integrity, and availability of patient data. Client: Travel Centers of America LLC- Cleveland, OH April 2018 Dec 2020 Role: Data Analyst Project Description: TravelCenters of America LLC (TA) is a leading operator of travel centers and truck service facilities across the United States, offering fueling, dining, convenience stores, and maintenance services for commercial truck drivers and travelers. Responsibilities Utilize the guidelines of Agile to develop a detailed implementation process of Guidewire Claim Center Integration during different iterations and phases in Software Development Life Cycle (SDLC) Developed and maintained Tableau dashboards for clients to visualize data. Provided technical expertise in Tableau development and design. Configured, customized Microsoft Dynamics CRM 2011, 2013 application software multiple times to meet business needs. Collaborated with stakeholders to develop interactive visualizations that met business objectives. Assisted in the creation of Tableau Server architecture, security, and scalability plans. Performed data integration and data mapping and data extraction management along with data cleansing while migrating data from legacy system to Guidewire PolicyCenter with Guidewire Data Hub. Configured user access permissions and managed content publishing workflows. Designed complex custom calculations using various Tableau functions and parameters. Monitored server performance metrics and identified opportunities for optimization. Facilitated JAD session with stake holders to identify new requirements not available within Guide wire and write use case. Develop custom reports in SSRS and attach it with Dynamics CRM. Troubleshot issues related to data refresh, connection errors, and dashboard performance. Created dynamic reports utilizing a combination of multiple data sources including SQL databases, Excel spreadsheets, web services APIs. Analyzed customer requirements to determine the best practices for creating effective visualizations. Utilized advanced analytics techniques such as forecasting, clustering, regression analysis. Worked closely with IT teams to ensure successful integration of new data sources into existing systems. to create insightful views of customer trends. Implemented automated processes for extracting large datasets from multiple sources. Performed regular maintenance on existing dashboards and updated them according to changing customer needs. Identified areas of improvement in current reporting solutions based on customer feedback. Developed custom scripts to automate repetitive tasks associated with report generation. Researched industry best practices for designing intuitive visualizations that enable easy interpretation by end-users. Provided ongoing support for users having trouble navigating or understanding dashboards. Streamlined reporting processes by evaluating data sources, compiling data, and redesigning output. Communicated complex machine learning solutions and concepts to diverse groups of business stakeholders in clear, concise language. Led the development and implementation of interactive dashboards and reports in Tableau, driving actionable insights for key business areas. Created and deployed ETL processes using Informatica and MS Integration Services, ensuring data accuracy and timely delivery. Developed and integrated predictive models into core applications, improving sales forecasting and inventory optimization. Performed root cause analysis on internal and external data, identifying and resolving operational inefficiencies. Collaborated with cross-functional teams to define data requirements, design data solutions, and implement reporting strategies. Managed and maintained relational and NoSQL databases, ensuring data integrity and performance optimization. Client: PenFed Credit Union- Vienna, VA Feb 2017 Feb 2018 Role: Data Analyst Project Description: PenFed Credit Union is a financial institution offering a wide range of banking products and services to its members, including savings accounts, loans, mortgages, credit cards, and investment options. With a focus on serving the military community and their families, PenFed is committed to providing competitive rates, personalized customer service, and innovative financial solutions. Responsibilities Led the entire data analysis journey, from requirement analysis to designing, developing, and supporting data-driven solutions. Provided technical expertise and troubleshooting assistance to developers for data solution design challenges. Enhanced application performance, scalability, and security by leveraging data analysis and optimization techniques. Crafted interactive Power BI visualizations to empower data exploration and informed decision-making. Built compelling Power BI reports and dashboards using SQL Server data, effectively communicating key metrics to stakeholders. Utilized advanced DAX functions, parameters, calculated columns, and measures to construct robust data models within Power BI. Mastered various techniques like pivoting, unpivoting, and transformations in Power BI Query Editor to prepare data for insightful analysis. Published reports and dashboards using Power BI's import and direct query methods, ensuring seamless data access for users. Client: Home Depot. Charlotte, NC 05/2011 - 12/2016 Role: Database Administrator Project Name: Home Depot is a retail giant specializing in home improvement products and services, offering a vast selection of tools, building materials, appliances, and d cor items. Responsibilities Developed and implemented database security measures to ensure data protection. Installed, configured, and maintained Oracle 11g and 12c databases on Linux servers. Created new tablespaces for applications to store their data in the database. Configured user accounts, privileges, roles, profiles. in the database server. Performed daily backups of the databases using RMAN utility. Monitored performance of queries and tuned them as needed using Explain Plan tool. Implemented data replication between two different databases using DataGuard feature of Oracle Database Server. Tested application code changes before deploying them into production environment. Migrated existing databases from one platform to another with minimal downtime. Resolved customer queries related to database issues promptly and accurately. The analyzed system logs regularly to identify any potential problems or suspicious activities. Managed multiple databases running on different platforms including Windows, Linux and UNIX systems. Deployed patches and upgrades on a timely basis to keep up to date with latest software releases. Conducted training sessions for junior DBAs regarding best practices related to database administration. Provided excellent service and attention to customers when face-to-face or through phone conversations. Analyzed the data in the source systems and wrote and maintained PL/SQL code for database applications. Designed and implemented stored procedures, functions, and triggers. Analyzed targets, transformed the data, mapped the data, and loaded the data into targets using Oracle PL/SQL. Optimized SQL queries and database performance. Developed and maintained PL/SQL packages and libraries. Debugged and troubleshooted PL/SQL code and performed code reviews while adhering to coding standards. Education and Training Alabama A & M University | Normal, AL | 05/2009 Master of Science: Computer Science MS Power BI certification Keywords: business intelligence database information technology microsoft procedural language Alabama Minnesota North Carolina Ohio Virginia