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
You received this message because you are subscribed to the Google Groups "SureShotJobs" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sureshotjobs+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/sureshotjobs/CA%2BRonb8RDcBTbE3c3YtCcSPaJPE19ug1kmY-4YnOmMmccXehcQ%40mail.gmail.com.
No comments:
Post a Comment