Hello Good Morning.
Hope you are doing well.
Name: Shashidhar
Relocation: Yes
PROFESSIONAL SUMMARY
· 9+ years of experience in developing Business Intelligence applications utilizing SQL server, T-SQL, MS BI stack(SSIS, SSAS, SSRS), MDX, DAX, Azure, Power BI, Power Pivot and Power View reports and Tableau.
· Experienced with full life cycle phase of SDLC involving Systems Analysis, Design, Development and Implementation.
· Following agile methodology for the projects, setting up monthly sprints, and daily stand ups to identify roadblocks and measure the progress of the ongoing project.
· Excellent in High Level Design of ETL DTS Packages and SSIS Packages for Integrating data using OLEDB Connection from heterogeneous sources (Excel, CSV, flat file, Text format) by using multiple transformations such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union all.
· Developed multiple Dashboards, analytical reports, KPIs and Interactive reports based on business requirements using Power BI and SSRS to support executive needs.
· Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
· Experience in MS SQL Server configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery, running Database Consistency Checks using DBCC.
· Worked Extensively on ETL process using SSIS packages.
· Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart, Ad-hoc and Sub Reports.
· Experience in Dimensional Modeling, ER Modeling, Star Schema/Snowflake Schema, Fact and Dimension tables.
· Worked on migration of legacy in house SQL server databases to Snowflake and AWS cloud.
· Designed Dashboards, Scorecards and reports using multiple KPI’s.
· Created Reports with complex formulas and to query the database for business Intelligence.
· Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
· Experience in using profilers, Index Tuning Wizard and performance monitor to monitor SQL Server.
· Designing SSAS cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.
· Proficient in implementing and customizing Dynamics ERP solutions to streamline business processes and enhance overall efficiency.
· Hands on Experience with AWS Snowflake cloud Data warehouse for integrating data from multiple source system which include loading nested JSON formatted data in to snowflake table.
· Experience in working Azure cloud components ADF,ADL, and Azure SQL & Datawarehouse
· Built Interactive Power BI dashboards using multiple visuals, slicers, bookmarks, and Drill through functionalities.
· Experience in developing Dashboard Report, Parameterized Reports, linked reports, Sub reports by Region, Year, Quarter, Month and Week.
· Experience in creating Views, Constraints, Triggers, Joins, Cursors, Temp Table, Table Variable, Functions, Batch Scripts, and numerous stored procedures consumed at various stages of migration/cleansing process, reports or data validation.
TECHNICAL SKILLS
Languages
SQL, T-SQL, PL/SQL, MDX/DAX, C#, ASP.NET, XML.
Databases
MS SQL Server 2016/2012, Snowflake, Oracle 11g/8.0i, MS Access.
DWH /BI Tools
SSIS, SSRS, SSAS, Business Intelligence Development Studio (BIDS), Power BI Desktop and Services, Microsoft Visual Studio 2019/2017.
Cloud Environment
AWS, Snowflake, AWS RDS, AWS Redshift, EC2, S3, Lambda, Cloud watch , AWS Auto scaling, Microsoft Azure and Google Cloud Platform.
SQL Server Tools
SQL Server Management Studio (SSMS), SQL Server Enterprise Manager, SQL Server Profiler, Query Analyzer, Import & Export Wizard, Power Pivot, Excel Power Pivot, Excel Data Explorer.
Reporting Tools
Power BI, SSRS, Tableau, Crystal Reports, Einstein Analytics, SAP Analytics.
Other Tools
Microsoft TFS, GIT, HP Quality Center, Jira, Confluence, MS Office 365, Microsoft Visio, Smartsheets.
Warm Regards,
Ashok | Sr. Sales Recruiter |
TechSmart Global INC | Ph : 732-791-2779
666 Plainsboro Rd, Suite 1116, Plainsboro, NJ 08536.
