Sr MSBI Developer
Resume:
Niveditha
Email: *****@******************.*** Phone: 469-***-****
PROFESSIONAL SUMMARY:
• Over 7+ years of Professional experience in SQL Server Databases and Data Loading and Reporting tools with SQL Server Integration Services (SSIS), SQL Server Reporting Service (SSRS), SQL Server Analysis Services (SSAS) and Power BI.
• Experienced in complete Software Development Life Cycle (SDLC).
• Extensive knowledge on SQL Server Management Studio (SSMS).
• Excellent knowledge in RDBMS concepts along with Database objects like Stored Procedures, Functions, Triggers, Cursors, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
• Extensive knowledge in performing query tuning and query optimizations.
• Proficient in Extracting, Transforming and Loading (ETL) Data from different type of Sources such as Excel, Oracle, and Flat Files using SQL Server Integration Services (SSIS) from OLTP to OLAP
• Loading data from source to target using SSIS that involves tasks, containers and transformations depends on requirement.
• Proficient in designing SSIS packages using various Transformations such as Derived Column, Conditional Split, Merge join, Lookup, Slowly Changing Dimension, Multi-Cast to load data into Data Warehouse.
• Created complex SSIS Packages using appropriate control and Data Flow elements with SSIS Standards like Error Handling, Logging and working with Package config files.
• Created cubes and dimensional models in SSAS using dimension tables and fact tables.
• Implemented calculations in cubes for better analysis as per user requirement.
• Implemented partitioning in cubes to improve query performance and ease of cube maintenance.
• Having knowledge on writing MDX, DAX queries.
• Created parameterized reports, drill-down reports, drill through reports, linked reports, and sub reports in SSRS.
• Worked on Power BI Desktop by extracting data from different sources and wrote DAX queries according to business needs in query editor.
• Good experience in creating Power BI Dashboard from scratch and handling Workspaces, Apps and User Security in Power BI Service.
• Created and scheduled of SQL server agent jobs to run ETL scripts (SSIS packages).
• Actively participated in the agile methodology, sprint planning and reviews.
TECHNICAL SKILLS:
Languages: T-SQL, C#, DAX and VB
Operating Systems
Windows Server 2018/2012/2008, UNIX
RDBMS/ Databases / Database Tools
MS SQL Server 2019/2016/2014, MS Access, SQL Server Management Studio, SQL Server Data Tools, SQL Profiler, Business Intelligence Development Studio (BIDS), Visual Studio 2019/2017, Performance Monitor, Microsoft DQS
Data Warehouse Tools/Technologies
SSIS, SSRS, SSAS 2014/2012/2008 R2/2005
Reporting Tools
MS Reporting Server (SSRS), Excel Power View, Power BI, Tableau
Microsoft Technologies
MS Office 2020/2016 (PowerPoint, Outlook, Word, Excel, Visio, SharePoint Designer), Office 365, One-Note
Source Control
Github, Azure Devops, Jira and GIT
PROFESSIONAL EXPERIENCE:
Client: Verizon Feb 2020 – Present
Location: Plano, TX
Role: Sr MSBI Developer
Responsibilities:
• Used Test Driven Development (TDD) and Scrum concepts of Agile Methodology to develop business Reports. Attended scrum meetings daily and took part in sprint planning.
• Configured SQL Server maintenance plans to automatically back up SQL Server Databases, optimize index and update statistics
• Designed and implemented Modular and Reusable ETL processes and associated data structures for Data Staging, Change Data Capture (CDC), Data Balancing & Reconciliation, Exception Handling & Reject Recycling, Surrogate Key Generation & Assignment, Data Lineage Tracking, ETL Auditing, etc.
• Created event handlers on events like on error, on warning or on failure and handled errors.
• Performed Loading of historical data using full load and incremental load processes into Data Warehouse tables.
• Created complex stored procedures and functions to support efficient data storage and manipulation.
• Filtered data from Transient Stage to EDW by using complex T-SQL statements in Execute SQL Query Task.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.
• Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and sub reports using SSRS.
• Designed, deployed, and maintained complex canned reports using SQL Server Reporting Services (SSRS).
• Documented all SQL Database structures and functionalities. Provided Database related documents and reports on Confluence page.
Environment: SQL Server 2016, SQL Server Management Studio (SSMS), Microsoft Visual Studio 2017, SSIS, SSAS, SSRS, MS Excel
Client: Accenture/ Fiat Jun 2018-Dec 2019
Location: India
Role: Data Analyst
Responsibilities:
• Created Power BI dashboards/reports using tabular models and good in managing Gateways and content packs.
• Involved in designing and publishing visually rich and intuitive Power BI dashboards.
• Embedded Power BI reports on SharePoint portal page and managed access of reports and data for individual users using Roles.
• Developed and maintained Reporting dashboard that depicts critical KPIs by using Power BI.
• Generated dashboards in Power BI Desktop and Power BI Service using super-fast slice and dice and modern data visualization features.
• Explored data in a variety of ways and across multiple visualizations using Power BI.
• Published Power BI Desktop reports created in Report view to the Power BI service.
• Monitored and Tuned MS SQL Server databases with tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optimal Performance.
• Created Power BI Dashboards (Power View, Power Query, Power Pivot, Power Maps).
• Used Power BI Desktop to develop data analysis multiple data sources to visualize the reports.
• Responsible for creating and changing the data visualizations in Power BI reports and Dashboards on client requests.
• Loading data from source to target using SSIS, which involves tasks, containers and transformations, depends on requirement.
• Participated in agile and Retrospective ceremonies to discuss about the requirements.
• Creating batch files to run the packages to load the data and copying the files from local to server locations using Linux.
• Experienced in Configuring Batch Logging, Error Logging, event handlers and Connection Managers in SSIS
• Created jobs and scheduled them using SQL server agent and involved in monitoring those jobs to make sure if they ran fine.
• Maintained the SSIS packages using Git version control.
Environment: SQL Server 2018, Microsoft Visual Studio 2017, GIT, JIRA, SQL Server Agent, Power BI, MS Excel.
Client: Tech Mahindra / AT&T Jul 2014 - Jun 2018
Location: India
Role: Software Engineer
Responsibilities:
• Interacted with team leaders and executive sponsors to gather both Functional and Technical requirements.
• Designed SSIS packages and performed ETL Operation for heterogeneous sources and destinations.
• Designed, developed ETL packages, tables, stored procedures, indexes, views etc. to implement best practices and to maintain optimal performances.
• Identified new sources of data and transformed into actionable information.
• Created multiple SSIS packages to perform the migration from old database to new database.
• Used checkpoints and breakpoints for debugging ETL packages.
• Designed, developed, unit tested and deployed SSIS packages along with complex stored procedures and queries for implementing complex business rules.
• Developed queries in T-SQL to extract data from a variety of SQL environments and to add data elements to the data warehouse.
• Created cubes and dimensional models in SSAS using dimension tables and fact tables.
• Implemented calculations in cubes for better analysis as per user requirement.
• Implemented partitioning in cubes to improve query performance and ease of cube maintenance.
• Worked collaboratively with staff and reporting officials to resolve data discrepancies and/or to clarify reporting procedures.
• Worked on designing Reports such as Tabular, Matrix, and list using SSRS. Configured and maintained Report Manager and Report server using SSRS.
• Created the reports based on the requirements and deployed the reports in report server.
• Created a sustainable reporting practice and means of storing, sharing/publishing the information and reports using subscriptions.
Environment: MS SQL Server 2012/2014, Reporting Services (SSRS), MS Visual studio 2012, MS Excel, Integration Services (SSIS), Analysis Services (SSAS)
Client: Tech Mahindra Jul 2013 - Jun 2014
Location: India
Role: Jr SQL Developer
Responsibilities:
• Requirement gathering and analyzing data sources. Assisted in design and implementation of Database.
• Worked and maintained SQL Stored Procedures, functions and views for updating customer usage information in the database.
• Mostly got involved with testing and documenting workflows.
Environment: SQL Server Management Studio, SQL Server 2008
Contact this candidate