Sql Server Data
Resume:
Sridhari Madala
Gmail:*********@*****.***
SQL BI Developer (SSIS/SSRS/SSAS)
Around 3 years of experience in Database Design, Development, Implementation and Administration in SQLServer […] and providing ETL/Business Intelligence solutions using Microsoft components (SSIS, SSRS, SSAS, Power BI).
Experience:
SQL BI Developer
St. Jude Medical, CA Nov 2016 to Oct 2017
Created Database Objects like tables, views, Store Procedures, User Defined Functions, Triggers, index and roles.
Created SSIS Packages to load the data into data warehouse from the various Sources.
Worked on different levels of ETL Loads like Extract Data from Source System to Staging and then from Staging to load data in Database Tables.
Troubleshoot of various SSIS ETL packages and its performance tuning, implemented failure alerts using email in SSIS.
Performed various transformations like conditional split, sorting and included data about the environment using the audit transformation.
Deploying, Scheduling, Monitoring, Debugging, and Troubleshooting SSIS Packages
Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
Created Jobs using the SSIS Packages for refreshing the data for every week.
Worked on performance tuning to improve the performance on SQL, TSQL and Power BI procedures and provided the recommendation on server related tuning issues.
Performed T-SQL tuning and optimized stored procedures using SQL Profiler, DBCC Commands and by analyzing Execution Plans.
Developed the power BI reports using the connection string like SQL server, SSAS and T-SQL statements.
Published and created the content pack for the Power BI report to access the reports in the organization.
Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.
Used different types of visualization Like (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer, Time Brush etc.) in Power
BI according to the requirements.
Designed and implemented the Tabular Cube for the Power BI reports to improve the performance of the reports.
Deployed the Tabular cube into SQL SERVER ANALYSIS SERVER 2016 to consume it in power BI.
Used DAX functions for the creation of calculations and measures in the Tabular Mode.
SQL Server (SSIS/SSAS/SSRS) BI Developer
HSBC Bank_Hyderbad, India March 2014 to July2015
Installation and configuration of SQL Server 2008(R2).
Analyzed the business requirements and building logical and physical data models.
Developed new stored procedures and optimize existing ones.
Developed template scripts for users so they can generate their own daily/weekly/monthly reports.
Developed and implemented stored procedures and triggers for automation tasks.
Developed SSIS packages to extract data from OLTP to OLAP systems and schedule the same as jobs using SQL Server Agent.
Modify the existing SSIS packages to reflect the new business requirements.
Developed packages to create Error Fallout Reports, send Business and IT mails.
Apply various transformations like Slowly Changing Dimension (SCD), Multicasting, Union, Derived Column and Data Conversion.
Used various advanced SSIS functionalities like complex joins, conditional splitting for better performance during package execution.
Developed Unit test plans for SSIS packages. .
Set up traces and use profiler to troubleshoot performance issues.
Created drill-down, drill-through and sub reports using SQL Server Reporting Services 2008R2.
Developed different chart reports for customers, based on the requirements.
Deploy the reports to the report manager and maintain the same providing necessary access to the users.
Created roles for the reports and assign them accordingly.
Developed UI mockups and ER diagrams using Visio and assisted teams working on Citrix and VMware.
Jr. SQL BI Developer
I-Cinergy Techmatics Pvt. Ltd_Bangalore, India. May 2013 to Jan 2014
Analyzed the business requirement documents (BRD) and defined workflows using MS Visio.
Used Erwin tool to understand the Database design and developed the database of specific file groups.
Extensively worked on querying and debugging SQL scripts including base tables, stored procedures, table valued functions, triggers and views.
Generated preformatted Excel and flat files (csv, tab and pipe delimiters) to marketing team using SSIS.
Worked on transactional queries using isolation levels, try-catch blocks and error notifications.
Extracted, Transformed and Loaded data from SQL Server and File systems using BCP, Bulk Insert utilities, Loop Containers, Look Up, Conditional Split, Derived Column, Aggregate transformations etc.,.
Developed and scheduled SSIS packages of incremental data loads using Slowly Changing Dimension (SCD) and Event Handlers.
Troubleshoot, debugged and performance tuned SSIS packages using SQL Profiler trace log files.
Implemented applicable joins, clustered and non-clustered indexes for better query execution plans.
Created macros, pivot tables, V & H lookups over MS Excel and generated daily roaster files.
Tuned SQL Server performance using SQL profiler, Index Tuning Wizard and Database Engine Tuning Advisor.
Created SQL Server Agent Jobs and monitored the scheduled SSIS packages.
Created categorical and trend analysis visualizations on periodic, financial and region segments using charts, graphs, Gauge and maps of SSRS.
Developed SSRS canned reports for customer segmentation based on the size of organization, gross income and other parameters with filters, drill down, drill through and table calculations.
Performed database mirroring and backups with differential and full recoveries over SQL Server 2012.
Tracked and closed the bug tickets as per priority and severity using TFS.
Responsible for Technical Design Documentation of Data Flows and BI reports developed and integrated them to SharePoint server.
Education:
Bachelors in Computer Science, JNTK, India
Master's in Computer science from University of New Haven Connecticut
TECHNICAL SKILLS:
Operating Systems Windows Server 2003, Windows Server 2008, Windows 7/Vista/XP
Data Bases SQL Server [ ] 2000, 2012 Oracle 8i/9i and 10g, MS Access
Data Base Tools SQL Server Management Studio(SSMS), SQL Enterprise Manager, query analyzer and SQL Profiler, SQL Server Data tools
Reporting Tools MS Access, MS SQL Reporting services (SSRS), Crystal Reports, Microsoft Excel
Data Modeling Tools VISIO
ETL Tools MS SQL Integration Services (SSIS)
Languages SQL, T-SQL, PL/SQL, C, C#
Contact this candidate