| Candidate Information | | Title | Sql Server Power Bi | | Target Location | US-CO-Lone Tree |
| | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateExperienced IT professional with over 8 years of hands-on experience in designing, developing, and maintaining database applications using SQL Server.Specialized in Data Warehousing (DWH), ETL using SQL Server Integration Services (SSIS), and report development with SQL Server Reporting Services (SSRS), Power BI and Paginated Reports, TableauAdept at working with large datasets, SQL, and various BI tools. Strong background in collaborating with cross-functional teams to understand business requirements and deliver tailored solutions using Tableau .Proficient in cubes development using SQL Server Analysis Services (SSAS) Street Address , both Multidimensional and Tabular Model.Skilled in designing visualizations (Reports/Dashboards) using Power BI Desktop.Strong understanding of Relational Database Management Systems (RDBMS) concepts with expertise in Database Design and Programming using SQL Server.Good experience and understanding of Database Design, Relational Integrity Constraints, OLTP, OLAP and Normalizations.Good Experience in Tuning SQL Queries by implementing Indexes and using Stored Procedures.Good Experience in scripting using DAX language.Technical Skills:BI Data Warehouse Tools : SSIS, SSAS, SSRS, Power BI, Tableau, Report Builder, Paginated ReportsDatabases : Azure SQL Server, MS SQL ServerLanguages : T-SQL, DAXPlatforms/OS : Windows 2003/XP/NT/Vista/7/10.Version Control Tools : GitHub,Team Foundation ServerOthers : SQL Server Data Tools, BIDS, SQL Server Management Studio,, MS Office, FTP, SharePoint, JIRAProfessional Experience Summary:Working as Senior BI Developer for Archents, Inc., Dublin, OH, USA (www.archents.com) from Mar 2022 to Present.Worked as Senior Software Engineer for Zabda Technologies Hyderabad, India (https://zabda.com/) from Jul 2019 to Mar 2022.Worked as Software Engineer for Archents IT India Pvt Ltd Hyderabad, India (www.archents.com) from Jan 2016 to June 2019.Project #3: Brokerage (Mar22 Present)Client: RXO Inc. (XPO Logistics)Location: Charlotte, North CarolinaRole: Senior BI DeveloperResponsibilities:Transformed business requirements into detailed technical specifications by working closely with Business Analysts; optimized project workflows, achieving a 25% improvement in delivery speed and a 15% increase in accuracy.Authored and implemented advanced Runbooks in Azure Automation Accounts using PowerShell, optimizing system operations and achieving a 35% reduction in manual labor, equating to 130 hours saved monthly.Created Row level security in Power BI and SSAS Tabular model and created roles for column level security.Created Workspaces and apps to deploy Power BI reports to the cloud environment and created automated schedules to refresh daily.Developed and maintained interactive dashboards and reports using Tableau Desktop and Tableau Server for various departments.Analyzed large datasets to identify key performance indicators (KPIs) and business metrics using Tableau.Developed reports and dashboards using Tableau to visualize data trends and patterns.Interacted actively with Business Analysts and Data Modelers on Mapping documents and Design process for various Sources and Targets.Plan, design, and implement application database code objects, such as stored procedures and views.Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.Perform quality assurance and testing of SQL server environment.Enhanced existing customized reporting utility to meet evolving client needs and time constraints.Experience with performance tuning new and existing stored procedures.Developed and modified SQL queries and stored procedures to meet business requirements.Performed tests and produced results to ensure accurate compliance with project request requirements.Analyzed the business requirements from the given specifications.Writing of Stored Procedures and Functions using SQL Server 2012 and T-SQL.Maintenance of the various database objects - tables/views/stored procedures - in SQL Server 2012 Performed the Server optimization, tuning of the indexes and the queries and Consolidation of SQL Server environment Used the maintenance Plan for SQL Server databases to recreate indexes and statistics for the performance.Extracted data from sources and transformed the data using different transformations like Data Conversion, Derived Columns, look up, Conditional Split, Aggregate, Union all, Merge Join and MultiCast Transformations.Created Environments to change the package properties dynamically.Build and Deployed packages to SQL server and Scheduling Packages for IntraDay and End of Day execution.Query Optimization using Query Analyzer, Profiler, show plan, Index Tuning and Stats Time Tool.Created Cubes using SSAS Tabular model and process cubes for Power BI dashboards.Developed complex DAX calculations in SSAS Tabular cube, enhancing data analysis capabilities and reducing report generation time by 40%, resulting in more efficient decision-making processes for the business intelligence team.Implemented Row level security in Tabular model.Monitor Daily Jobs and report schedules and re-trigger if any failures.Co-Ordinated during QA/UAT/PROD deployments and bug fixes.Extensively used joins and subqueries to simplify complex queries involving multiple tables.Build various visualization reports using Power BI reports and publish them to cloud Power BI Service and Report Server (Paginated Reports).Build complex logics and place them in Stored Procedure, Views, and Functions.Designed SSAS Tabular Model Cubes (AAS) and deployed to Azure Environment.Enhanced existing old ETLs using SSIS packages.Support and Maintenance of existing ETLs, data, reporting (SSRS, Power BI) issues.Report weekly status, deliverables, and risks of the project to the management.Perform code review of the team before deploying it to QA and Prod Environments.Ensured to implement all the industry standards and best practices across all the SQL Scripts, ETL/Report designs.Environment:Azure Automation Accounts, SQL Server Data Tools (SSIS, SSRS, SSAS), SQL Server 2016/19, Power BI,Tableau,PowerShell, GitHub, Report Builder, JIRA, Windows 10, MS Office 2019Project 2: Brokerage (Jul19 Dec21)Client: XPO LogisticsLocation: Hyderabad, TelanganaRole: BI DeveloperXPO Logistics is the one of the major North American providers of intermodal services. The business is an asset-light transportation logistics provider. The business facilitates one of the most comprehensive double-stack intermodal networks in North America, with access to more than 60,000 miles (97,000 km) of rail routes and a nationwide relationship with independent truck drayage carriers.Responsibilities:Interacted with Business Stakeholders in gathering requirements for delivering various reports/dashboards.Designed Data warehouse using SQL Server and SSIS packages.Designed Star Schema (dimensional model) and created SSAS Tabular Model Cubes.Created SSIS Packages using Control Flow Tasks, Data Flow Tasks and SQL Script.Used various Data Flow tasks like Conditional Split, Merge Join, Derived Column, Lookup, DataConversion, Union All, ODBC & OLEDB source and destinations etc.Configured SSIS packages by mapping parameters to Environment Variables in SSISDB.Designed Dashboards and Reports using Power BI Desktop and published to Power BI Service.Designed SSRS Reports for operational reporting in SharePoint Environment. Implemented features like Drill Down and Drill through functionality.Using SQL, scripted complex logic and created objects like Stored Procedures, Functions, Views, and Inline SQL queries.Designed and Developed Complex Reports (using sub reports) as requested by Business.Migration of Oracle Reports to SSRS Reports.Analyzed existing Cubes and used them as Data Source for SSRS Reports.Pulled Data from different systems and loaded to SQL Server 2012 using SSIS.Written Complex Stored Procedures, Functions and Views.Created and Scheduled Jobs using SQL Agent for Database and SSIS.Created and Implemented Subscriptions for SSRS Reports on both Native (Report Manager) and SharePoint Mode.Support and Maintenance for existing SSRS reports and ETL.Performed Peer Reviews for reports developed by other developers.Implemented best practices in Reports, ETL Packages and SQL Scripting.Environment: SQL Server Data Tools (SSIS, SSRS 2012), SQL Server 2012, Power BI, SSAS, Mobile Report,Project 1: Freight Optimizer / Intermodal (Jan16 Jun19)Client: XPO LogisticsEmployer: Archents IT India PVT LTDLocation: Hyderabad, TelanganaRole: BI DeveloperResponsibilities:Interacted with Business Stakeholders in gathering requirements for delivering various reports/dashboards.Designed Data warehouse using SQL Server and SSIS packages.Created SSIS Packages using Control Flow Tasks, Data Flow Tasks and SQL Script.Used various Data Flow tasks like Conditional Split, Merge Join, Derived Column, Lookup, DataConversion, Union All, ODBC & OLEDB source and destinations etc.Configured SSIS packages by mapping parameters to Environment Variables in SSISDB.Designed SSRS Reports for operational reporting in SharePoint Environment. Implemented features like Drill Down and Drill through functionality.Using SQL, scripted complex logic and created objects like Stored Procedures, Functions, Views, and Inline SQL queries.Designed and Developed Complex Reports (using sub reports) as requested by Business.Pulled Data from different systems and loaded to SQL Server 2012 using SSIS.Written Complex Stored Procedures, Functions and Views.Created and Scheduled Jobs using SQL Agent for Database and SSIS.Support and Maintenance for existing SSRS reports and ETL.Environment: SQL Server Data Tools (SSIS, SSRS 2012), SQL Server 2012, Power BI, SSAS, Mobile Report,Education:Bachelor of Technology in QIS College of Engineering and Technology (2015). |
