Post Job Free

Resume

Sign in

Power Bi Sql Server

Location:
Detroit, MI
Posted:
September 13, 2023

Contact this candidate

Resume:

NITHYA KRISHNAN

Okemos, MI 517-***-**** adzohe@r.postjobfree.com www.linkedin.com/in/nithyakrish

Professional Summary

16+ years of extensive experience in Design, Development, Implementation and Maintenance of Web application using ASP.NET, SQL Server and extensive experience in Business Intelligence Technologies using Power BI for building the data models and creating visualizations using Power BI desktop.

Experience in understanding and modifying whole Software Project Life Cycle (requirements, design, development, testing, deployment, and version control), Modifying, requirement analysis, functional/design specifications, HLD, LLD & Test plans designing.

Experienced in developing Power BI reports and dashboards from multiple data sources using data blending.

Created and maintained rich interactive visualization in the reports using custom visuals like Bar Charts, Pie Charts, Line Charts, Cards, Slicers, Map, etc. with reporting components from multiple data sources.

Data analytics: The ability to drill down data and visualize it in the best possible way through charts, reports, or dashboards.

Design, develop and deploy Business Intelligence solutions using SSIS, SSAS and SSRS

Built SSRS reports, maintain the existing reports and publish them to the report server.

Worked closely with project managers to understand and maintain focus on their analytics needs, including critical metrics and KPIs, and deliver actionable insights to relevant decision-makers.

Successfully managed several client engagements, working directly with client stakeholders and exceeding their expectations that has helped account team earn trust.

Actively participated in our culture of continuous development and innovation by contributing ideas for new feature and functionality

Extensively communicated the requirements with the client teams, and with internal teams.

Experience

Associate Consultant TATA Consultancy Services Ltd., Chennai MAY 2008 – MAR 2023

Software Engineer Koland Technologies Ltd., Chennai NOV 2005 – APR-2008

Education

Master of Computer Application, Bharathidasan University, Trichy, INDIA 70% APR 2003

Bachelor of Computer Science, Bharathidasan University, Trichy, INDIA 65% APR 2000

Technical Skills

Data Analytics Microsoft Power BI, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Power BI Reports Scheduler (PBRS)

Language SQL Server, PL/SQL, Transact-SQL (T-SQL), Data Analysis Expressions (DAX)

Web Tools HTML, XML, AJAX, JavaScript, jQuery, VBScript, ASP

Web Server IIS

Microsoft technologies ASP.NET, C#.NET, VB.NET, ADO.NET, Webservices, WCF

Tools SQL Server Management Studio, Visual Studio, Eclipse, Tableu

Operating Systems Windows, Unix, Linux

Project Management Agile/Scrum, JIRA, Git, Remedy

TATA Consultancy Services, Chennai MAY 2008 - MAR 2023

Team Name : Technology and Innovation

Role : Team Manager – Technical Lead

Clients : Landmark, IT and Infrastructure Services, Qantas Freight, Comcast

Technologies : Power BI, Asp.Net, C#, SQL

Projects : Workflow Manager, Document Management System, and various .Net applications.

Team Size : 9

Duration : MAY 2017 – MAR 2023 as a Technical Lead.

Job Roles and Responsibilities

Experience in Technical Requirements gathering with Client and Prepared the HLD/LLD as per SOW

Lead, coordinate and manage the local team to develop, trouble shoot and optimize solutions, quality front end software portals.

Designing and Development of Power BI Reports/Dashboards as per Business requirements

Experience in writing advanced queries and transformations with T-SQL

Extensive experience with complex queries, DDL, DML, functions, triggers, Stored Procedure, views, and jobs for new and existing applications.

Optimized queried by looking execution plan for better tunning of the database.

Tunned server slow running queries in production. Implemented indexes and reindexed to achieve time performance.

Monitored, optimized, and did performance tuning of server using Performance monitor, SQL Profilers, Activity Monitor.

Progressive experience in areas of ETL, Data Modeling, Data Visualization, Reporting and Analytics

Experience in development, and implantation on security models in Power BI with Row level security

Build Measures and Calculated columns using DAX. Write M queries in Power Query to transform data and data modelling capability.

Expertise in building data visualizations with a strong understanding of the chart types which is used to highlight patterns in the data for unstructured and structured data sets.

Efficiently handle large sets of data and be able to confidently process them into required formats.

Provided technical input and effective data analysis to projects to support the achievement of deliverables to time and budget.

Conduct unit testing and troubleshooting and understand any BI-level SLA’s and taking care of BI performance tuning.

Have strong technical experience that helped me in building, guiding, and coaching the team to handle the issues independently. Yet pitch in and help the team doing hands on as required.

Experience in creating and optimizing dashboards with a focus on usability, performance, flexibility, testability, and standardization.

Stakeholder and Client Management: Regular Sync up with Segment Leaders across the projects to understand the gaps if any to improvise the process.

People and Performance Management of everyone in my team. Mentor the team members for their growth and create a positive environment.

Personal Information

Name : Nithya Krishnan

Nationality : India

Passport : Z3209966

Visa : L2 EAD

Alternative Mobile NO : 517-***-****

Address : 2340 Club Meridian Dr, A05, Okemos, MI - 48864



Contact this candidate