| MS BI/ Power BI with SQL Available. Open to relocate at Remote, Remote, USA |
| Email: [email protected] |
| Email from Saligrams Systems Power BI Developer over 10+ years of experience looking for a new role immediately on C2C basis Name : Shashidhar Visa : H1B Open to relocate PROFESSIONAL SUMMARY 10+ 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. 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. Developed multiple Dashboards , analytical reports, KPIs and Interactive reports based on business requirements using Power BI and SSRS to support executive needs. Worked on migration of legacy in house SQL server databases to Snowflake and AWS cloud . Designed Dashboards , Scorecards and reports using multiple KPIs . 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. 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 and Fact , Dimension tables. 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 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 Programming Languages: SQL, T-SQL, PL/SQL, MDX,DAX, Python, C#,ASP.NET,XML Databases & Data Warehousing: Snowflake, Palantir Foundry, MS SQL Server (2016,2012),Oracle (11g, 8.0i), MS Access Data Visualization Tools : Power BI (Desktop & Service), Tableau, Crystal Reports, SAP Analytics Cloud, Einstein Analytics (Salesforce), Alteryx. MS Power Platform: Power BI (Power Query, Power View and Power Pivot), Power Automate, Power Apps MS Business Intelligence: SSIS, SSRS, SSAS. Cloud Platforms Environments: Amazon Web Services (AWS): AWS RDS, AWS Redshift, AWS EC2, AWS S3. Microsoft Azure: Azure Synapse, Azure Data Factory (ADF), Azure Data Lake, Azure SQL Datawarehouse. Gen AI: Power BI Co Pilot, Chat GPT, Ask ATT. Version Control & Collaboration Tools: Microsoft Azure DevOps, Git, TFS, Jira, SharePoint, Confluence , HP Quality Center Other Tools : VS code, Microsoft Office 365, Visio, Smart sheets. PROFESSIONAL EXPERIENCE: Client : AT&T, TX, USA Dec 2023 - Present Role : Sr. Power BI Developer Client : Idaho Transport Department, ID, USA Aug 2022 Dec 2023 Role : Sr. Power BI Developer Client : Cross Country Mortgage, OH, USA Jun 2017 Aug 2022 Role : Power BI Developer Client : Tata Consultancy Services, Hyderabad, India Dec 2011 - Dec 2014 Role : BI Developer Warm Regards, Ram Lead Recruiter - IT Sales | SALIGRAM SYSTEMS INC., 666 Plainsboro Rd, Suite 1365, Plainsboro, NJ 08536. D: 732-753-0045 | Email: [email protected] Saligrams Systems | 666 Plainsboro Rd, Suite 1365 Plainsboro | Plainsboro, NJ 08512 US | Update Profile | Constant Contact Data Notice Keywords: csharp artificial intelligence business intelligence sthree active directory information technology hewlett packard microsoft procedural language Colorado Idaho New Jersey Ohio Texas MS BI/ Power BI with SQL Available. Open to relocate [email protected] hotlist |
| [email protected] View all |
| Thu Nov 14 20:12:00 UTC 2024 |