Jakranpally

About Jakranpally

• Over 6+years of experience in Microsoft BITools (SSIS/SSRS/SSAS)and T-SQL using SQL Server2012/2014/2016. • Experience in developing and debugging Stored Procedures and Triggers. • Expertise in Visualizing and Analyzing Data using Power BI with cloud-based applications. • Experience in T-SQL (DDL, DML and DCL), Creating, developing new database objects by like Tables, Views, Indexes, Complex stored procedures, function (UDF), cursors, and triggers, locking issues, BCP, common table expressions (CTEs), Backups, Recovery and SQLServer Agent profiler using SQLSERVER2005/2008 R2/2012/2014/2016 • Experience in working with Self Service MS BI end user tools such as Excel 2010 (Power pivot), Performance Point Server (PPS), Power BI and Power view. • Experience in T-SQL Developer skills include stored procedures, Indexes views, User Defined Functions (UDF), Triggers, and Distributed Queries, Scheduled Tasks • Proficient Knowledge in dealing with RDBMS including E/R Diagrams, Normalization, Constraints, Joins, Keys and Data Import/Export. • Used tools like MS SQL Profiler, Index Tuning Wizard, and Pervasive and Windows performance for monitoring and tuning SQL Server performance. • Developing SSIS packages for data migration between different sources such as flat file, excel, oracle, Sybase, DB2, MS accessing SQL Server SSIS. • Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector. • Experience in Power BI, creating interactive visualizations, dashboards, reports basedonbusiness requirements. • Excellent hands on experience in ETL (Extraction Transformation and Loading) by extracting large volumes of data from various data sources using SSIS. • Experience in by using Row Transformations, Block and Unblock Transformations for Performance Tuning in SSIS packages. • Hands on experience working with Logging, Error handling using Event Handlers pre and post for SSIS Packages. • Creating SSIS Packages for integrating data using OLE DB connection from sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union • Experience in working with Data Cleansing technique in ETL procedures. • Experience in creating reports such as Parameterized, Cascading, Drill through/Drill down Reports, Conditional, Table, Matrix, Charts, Ad-hoc Specialized inusingRelational data warehouse and OLAP Cubes for producing Sub Reports. • Good experience in creating pivot tables and charts in Excel using data sources (SQL Server, SSAS cubes, and Access) andpower pivot. • Experience developing BI/dashboard components using tools like BIDS, PerformancePoint and Power Pivot. • Creating and Deploying SSRS Reports on the portal for user accessibility. • Worked on creating Azure Data Factory for moving and transforming the data. • Experience in implementing surrogate key generation strategy in the Data warehouse. • Experience in generating On-demand and Scheduled reports for management decision and business analysis by using SSRS. • Experience managing Azure Data Lakes (ADLS) and Data Lake Analytics and an understanding of how to integrate with other Azure Services. • Experience in databases like MySQL and NoSQL like MongoDB • Used Microsoft Azure date storage and Azure Data Factory, Data Lake • Experience in querying Azure SQL Server and working on Microsoft Dynamic CRM • Proficient experience in deploying and configuring packages, Error handling and batch logging, check points and troubleshooting Reports using SSRS. • Experience in developing OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles. • Experience in performance tuning, processing and deploying the cubes • Experience in cube partitioning for better database performance.