Analysis of data to determine default rate, economic maturity, conversion rate, defaulted transaction-level economic loss rate. Extensive use of Base SAS techniques to generating reports. Executed dashboard setups and data manipulation using DAX. Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily. Created reports using time intelligence calculations and functions. Developed analysis reports and visualization using DAX functions like table function, aggregation function and iteration functions. Scheduled Automatic refresh and scheduling refresh in power bi service. Worked on all types of transformations that are available in Power bi query editor. Developed profit analysis reports and dashboards by products and customers. Creating Row level security with power bi and integration with power bi service portal. Developed Up-selling and Cross-selling reports using DAX functions. Design and develop of reporting data module for Credit Card Marketing Analytics. Converting all operational excel report into Power BI Reports. Integrated custom visuals based on business requirement using power BI desktop. Developing compelling and interactive analysis reports and dashboards for Credit Card Marketing analytics using advanced DAX. WORK EXPERIENCE 1.) Power BI (Credit Cards Analytics) EDUCATION Course (Stream)/ ExaminationĪEM Higher Secondary School- Chennai, Tamil Naduĭaniel Higher Secondary School – Chennai, Tamil Nadu Looking to work with an esteemed organization that gives me an opportunity to utilize my existing analytical skills and help make better business decisions. Power BI Expert with 1.5+ years of rich experience in creating compelling reports and dashboard using advanced DAX. SQL Server Integration Services (SSIS),. Creating Database objects – tables, views, functions and developing procedures for implementing application functionality at the database side for performance improvement.Įnvironment: MS SQL Server 2012, Power BI, ETL, T-SQL, Visual Studio 2010, SQL Server Profiler, Erwin Data Modeler 7.2, Dashboard, SQL Server Management Studio, SQL Server Data Tools ADDITIONAL INFORMATION:. Generated computed tables in Power BI by using Dax. 2) SQL BI DeveloperĬompany Name-Location – June 2013 to May 2014 Undergone Intellipaat’s Power BI certification training.Įnvironment: MS SQL Server 2016, SSIS/SSAS/SSRS, ETL, T-SQL, Visual Studio 2016, SQL Server Profiler, Erwin Data Modeler 7.2, Dashboard, SQL Server Management Studio, SQL Server Data Tools (SSDT), Power BI. Published reports and dashboards using Power BI. 
Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.Used Power BI Gateways to keep the dashboards and reports up to date.Explore data in a Variety of ways and across multiple visualizations using Power BI.Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps.Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.Created Azure Blob Storage for Import/Export data to/from.Involved in creating new stored procedures and optimizing existing queries and stored procedures.Generated computed tables in Power BI by using Dax.Created Dax Queries to generated computed columns in Power BI.Imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports.
Samples of resumes professional#
PROFESSIONAL EXPERIENCE: 1) Power BI DeveloperĬompany Name-Location – February 2017 to Present
Strong Knowledge on Power BI to import data from various sources such as SQL Server, Azure SQL DB, SQL Server Analysis Services (Tabular Model), MS Excel etc.,ĮDUCATIONAL QUALIFICATIONS: Course (Stream)/ Examination. Hands on experience in Performance Tuning, Query Optimization. Strong Knowledge in dimensional Star Schema and Snowflakes Schema. Expertise in enhancing and deploying the SSIS Packages from development server to production server. Experience inRequirement Analysis, Design and Development of Web applications using ASP.NET, VB.NET. 
Extensive hands-on experience in several Data Flow transformations including Derived-Column, Script, Slowly Changing Dimension, Look up, Data Conversion, Conditional-Split techniques, Merge, Multicast, Union All. Developed SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from SQL Server. Having 5+ years of IT experience as Microsoft SQL Server developer implementing SSIS and SSRS using Microsoft Business Intelligence development studio (MSBI), SQL Server data tools (SSDT) and Power BI.
0 kommentar(er)
