Lakshmi Gunisetti

Business Intelligence Developer @CertainTeed

Cypress, TX, US

Project Description:\\\\nCertainTeed is a leading North American manufacturer of building materials including roofing, vinyl and fibre cement siding, trim, fence, railing, decking, foundations, insulation, gypsum, ceilings, and pipe products\\\\nThe Project Objective is to help business gain actionable new insights from operational data by using Power BI as analytics solution and to keep track of the project works to improve profitability.\\\\nRoles and Responsibilities:\\\\n Coordinating with BA and business users in analysing business requirements and translating them to technical specifications.\\\\n End to End development from pulling CertainTeed ERP data to into Power BI reports.\\\\n Build and automated Power BI reports for the sales department and for product management and for CSR and customer master teams through which company was able to reduce man hours of data cleansing and creating report in excel for every month. Created and automated reports for\\\\n• Product Inventory.\\\\n• Product Sales.\\\\n• New Customers.\\\\n• Customer Acquisitions.\\\\n• Revenue Reports for Specific Product Lines.\\\\n• Customer Rebates.\\\\n• Customer Incentives.\\\\n Requirement Analysis and data modelling in Power BI.\\\\n Created many complex Query and used them in Power BI Reports directly to generate reports on the fly.\\\\n Published Power BI Reports in the required origination and made Power BI Dashboards available in Web clients and mobile apps.\\\\n Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.\\\\n Created Page Level Filters, Report Level Filters, and Visual Level Filters in Power BI according to the requirements.\\\\n Used One Drive for storing different versions of the Power BI report.\\\\n Used JIRA for Version Control needs task check-ins.\\\\n Responsible for complete maintenance and delivery of scheduled releases.\\\\n Created KPI’s, Partitions, Perspectives, and Calculated Measures, used DAX queries, and Roles.\\\\n Implemented the SAP Business Objects reporting requirement.\\\\n \\\\n\\\\n \\\\n \\\\n\\\\n \\\\n

Periyar University, Salem

Master of Computer Applications - MCA