Power BI consultant Available
N Chandu
V T
SUMMARY:
· Over 8+ years of IT experience in the Analysis, Design, Development, Implementing and Testing, Administrating Client/server applications.
· Experience in Power BI for design, build and deployment of Power BI Solution and analytical reports from diverse data sources.
· Experience in Tableau/OBIEE for design, build and analytical reports.
· Expertise in Microsoft Business Intelligence Services like SQL Server Integration Services, SQL Server Analysis Services and designing reports using SQL Server Reporting Services.
· Working knowledge of Extraction, Transformation and Loading (ETL) using Informatica tool.
· Working experience with OLTP and OLAP databases in MS SQL Server (2016/2014/2012/2008R2/2005).
· Proficient in creating dynamic packages for Incremental Loads and Data Cleaning in Data Warehouse using Informatica.
- Expertise in writing complex DAX functions in Power BI and Power Pivot.
· Wrote calculated columns, Measures query’s in power bi desktop to show good data analysis techniques
· Experience in creating Paginated Reports.
· Excellent knowledge in creating custom specific and schedule reports using SSRS
· Proficient in the SSAS storage and partitions, aggregations, calculation of queries and developing reports using MDX and T-SQL.
· Utilized power BI(power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours along with slicers and dicers enabling end-user to make filters.
· Implemented Power BI gateway different source to matching analysis criteria and further modeling for power pivot and power view.
· Expertise in modifying and developing multidimensional cubes using SQL Server Analysis Services (SSAS).
· Experience in working with Normalization and DE normalization databases for reducing redundancies and dependencies.
· Excellent knowledge in data ware housing concepts and implementation.
· Experience in Agile Methodology using Jira.
· Attending Daily Scrum meetings to update work status/issues and Sprint ceremonies.
|
TECHNICAL SKILLS |
|
Languages |
C, C++, PL/SQL, T/SQL, HTML, Java Script, XML, VB.net, ASP.net |
|
RDBMS |
MS SQL Server 2012/2014/2016, SQL Server 2008 R2, Oracle9i/10g, |
|
Operating Systems |
Windows2000/2003 Advanced Server, Windows NT, Windows XP, Vista, Windows 7 |
|
Databases |
Oracle, MS SQL Server(V2008- V2019 and MS Access, Rally, JIRA |
|
Defect Tracking & Office Tools |
VSS 6.0, MS-Office 2007, TFS, TortoiseSVN, Red Gate Source Control, JIRA, StarTeam, FogBugz, Team City |
|
Other Tools |
SSIS, SSAS, MS SQL Server Management studio, MS Visual Studio 2016 |
|
App/Webservers and other tools |
HTML, XML, Web Logic Server, WebSphere, Soap UI, Web Services, Informatica. |
|
ETL & Reporting Tools |
Informatica, Power BI, Tableau, OBIEE |
Desk: 732-913-8428
iDimensio Inc.,
15 Corporate Place, Suite #103,
Piscataway Township, NJ 08854.
www.linkedin.com/in/sekhar-rao-51a512198
Hangouts: aforakkineni
