Savitha Chandrashekhar

SQL BI Developer

Email: adngfm@r.postjobfree.com Mobile: 616-***-**** Location: Grand Rapids, MI - 49512

PROFESSIONAL SUMMARY:

• Overall 4+ Years of IT Experience in Database and Business Intelligence Technologies with expertise on ETL process and Reporting using SQL Server 2016/2014/2012/2008R2, SSIS and SSRS.

• Expertise in SQL Server 2016/2014/2012/2008R2 Reporting Services (SSRS), SQL Server 2012/2008 Integration Services (SSIS) and in SQL Server 2012/2008 Analysis Services (SSAS) in Business Intelligence (BI).

• Excellent knowledge to deliver comprehensive Business Intelligence through integration of BI suite of products (SSIS, SSAS, SSRS) including MS solutions like Microsoft Excel.

• Excellent in Design of ETL SSIS Packages for integrating data using OLE DB connection from sources like (Excel, CSV, Oracle, flat file,) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Merge and Union all.

• Expert in generating reports using SQL Server Reporting Services, like Crystal Reports, parameterized reports, sub reports, drill down reports, drill through reports, MS Excel spreadsheets and PowerPivot for client requirements in SSRS 2005/2008.

• Extensive experience on building dashboards in Tableau and Involved in Performance tuning of reports and resolving issues within Tableau Server and Reports.

• Good understanding of Normalization / De-normalization, Normal Form and database design methodology.

• Expertise in Power BI, Power BI Pro, Power Bi Mobile.

• Expert in Creating and developing Power Bi Dashboards in to rich Look.

• Expertise in writing SQL Queries, Dynamics, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Indexes, Views and Cursors.

• Highly experienced in whole cycle of DTS/SQL server integration services (SSIS, SSAS, SSRS, PowerBI, Qlikview, and Tableau) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers Business Analysis.

• Expert in Developing and Extending MSBI SQL Cubes, Dimensions and data source view MSBI SQL-Data Mining Models and Deploying and Processing MSBI SQL object.

• Experienced in Building Cubes and Dimensions with different Architectures and Data Sources for Business Intelligence using SQL Server Analysis Services (SSAS).

• Experience in creating MDX query in SSAS cubes for various calculated members, KPI and various actions such as drill through, reporting etc.

• Experience in Migrating Data from an older version to newer version of MS SQL Server 2012.

• Expertise in resolving SQL Reporting services (SSRS) and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, OLAP and Sub reports in Business Intelligence Development Studio.

• Very good T-SQL Programming skills. Experience in query optimization & performance tuning used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.

• Experienced in creating interactive dashboards and scorecards utilizing Power BI.

• Hands on experience in MS Power BI desktop and Power BI service.

• Hands on Experience in Data Migration from MS SQL Server to Oracle ERP Systems. PROFESSIONAL EXPERIENCES:

Client: Irvine Company Irvine, CA SQL/Power BI Developer Jun 2019 - Present Responsibilities:

• Used various Transformations such as For loop container, For Each loop container, execute package task, FTP task, Bull Insert task, Script task In SSIS Control Flow and Row sampling, Lookup, aggregate grouping in SSIS Dataflow.

• Designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS

• Designed and documented the entire Architecture of Power BI POC

• Expertise in writing complex DAX functions in Power BI and Power Pivot.

• Created SSIS packages for File transfer from one location to the other using FTP task with Master SSIS Package to run all other packages.

• Created packages using the various control flow task such as data flow task, execute SQL task.

• Created SSIS Packages/projects to move data from source to destination programmatic by using Visual Studio 2014.

• Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.

• Generated monthly reports and budget analysis to drive forecast production plan with SQL Server Reporting Services (SSRS).

• Created Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).

• Created extracts, published data sources to Tableau server, refreshed extract in Tableau server from Tableau Desktop.

• Published Workbooks and Dashboards to the Tableau server.

• Created database objects like tables, users, roles, stored procedures, triggers.

• Performance Tuning of Stored Procedures and SQL queries using SQL Profiler and Index Tuning Wizard in SSIS.

• Administered SQL Server with Client/Server tools including SQL Server Enterprise Manager, Profiler and Query Analyzer.

• Worked on Data Warehouse Modeling with SQL Server Analysis Services (SSAS).

• Involved in automating SSIS Packages using SQL Server Agent Jobs. Generated Parameterized reports, Sub reports, Drill down and Drill through reports using SQL Server Reporting Services

(SSRS) working along with MDX queries.

• Worked on all types of transformations that are available in Power BI query editor.

• Created stored procedures and SQL queries to pull data into power pivot model.

• Imported Data from various sources such as SQL Server, SQL DB, SQL Server Analysis services, Excel etc. Worked on data modelling in Power BI.

• Utilized Power Query in Power BI to Pivot and Un-Pivot the data model for cleaning and massing.

• Utilized Power BI Gateway to keep the dashboards and reports up to date.

• Configuring Power BI Gateway for SSAS live connection.

• Developed complex DAX Queries to generate computed columns.

• Storage development and design utilizing Blobs, Tables, Queues, Files.

• Developed and published reports and dashboards using Power BI.

• Installed and configured Enterprise Gateway and Personal Gateway in Power BI Services. Environment: MS SQL Server 2014, Micro Soft Visual Studio, Business Analysis, Power BI Desktop, Tableau, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), Microsoft Office Share Point Server, XML, Oracle, ASP.Net.

Client: Blue Cow Software MSBI Developer Lynnfield, MA June 2017 - May 2019 Responsibilities:

• Worked with Business Analyst in Gathering the Business Requirements and analyzing to design and create the database.

• Created SSIS packages for data conversion using Data Conversion Transformation.

• Created package configurations for dynamic connection string to enhance the ease of package deployment, implemented Event Handlers and Error Handling in SSIS packages.

• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server2008 R2 and Flat files.

• Created corresponding RDLs by using the stored procedures on New System.

• Using SSRS creating well-formed reports and web-based reports for Finance related applications and transactions.

• Advanced extensible reporting skills using SQL Server 2012/2008 Reporting Services (SSRS).

• Developed Drill Down, Drill through, Cross tab reports, Parameterized Reports and Report Models for generating Ad-Hoc reports as per the client requirements.

• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2012.

• Defined Key Performance Indicators (KPI’s) metrics to create scorecards.

• Report parameters included single valued parameters, multi-value parameters which also consist of different parameter types like hidden, internal, default (queried and non-queried parameters).

• Created SSIS Packages to move files from one location to another using FTP Task.

• Created Linked reports, Ad-hoc reports and etc. based on the requirement. Linked reports are created in the Report Server to reduce the repetition the reports.

• Involved in Dimensional modeling by identifying the fact and dimension tables based on the user and reporting requirements.

• Developed SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs.

• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.

• Having worked on configuring and developing Power BI dashboards.

• Experience in refreshing dataset using Power BI gateway.

• Worked on Data transformations, Data Migration/ Data Conversion to extract data from SQL Server Databases.

• Worked on Data Migration activities such as extracting, migrating, validation of data.

• Created SQL scripts for tuning and scheduling.

• Created extensive stored procedures and updated tables and triggers as per the changes in the requirement.

• Involved in debugging and testing of reports in SQL Server Reporting Services (SSRS). Environment: SQL Server 2012/2008/2008R2 Enterprise Edition, VB Script, ASP.NET, XHTML, XML, MS SQL Query Analyzer, SQL Profiler, SQL Server BIDS (SSAS, SSIS, SSRS), Tableau. Client: Sunraysys Solutions Pvt Ltd India ETL/SSIS/SSRS/Developer Feb 2016 - April 2017 Responsibilities:

• Involved in debugging and testing of reports in SQL Server Reporting Services (SSRS).

• Requirement gathering and understanding the trends that is to be shown in the reports.

• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases.

• Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.

• Written complex stored procedures and SQL queries.

• Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports.

• Using various SSIS data transformation tasks like SCD, Look-ups, Fuzzy Look-ups, Merge Union-All, Conditional Splits, Multi cast, Derived column etc.

• Wherever required, ETL process was created, the reports, will be stored, refreshed and utilized in the report on daily basis.

• Involved in design of SSIS Package configuration, logging, deployment & job scheduling.

• Created Cross-Tab and Sub-Report using RDL and promoted RDLs to Reporting Service Server.

• Create Tabular, Drill down, and Parameter reports using SSRS and configured Reports Snapshots, Report Caching for reporting performance.

• Used various SSIS components like Conditional split, derived column, multicast, OLEDB sources, OLEDB destinations, control flow components, data flow components, Aggregates, Execute SQL task, Send mail task, for each loop, row count, union all, merge, data conversion etc.

• Created indexes on selective columns to speed up efficiency of queries and analysis in SQL Server Management Studio.

• Developed SSRS Reports weekly and monthly for business requirements.

• Designed and developed custom .NET components and user controls using ASP.NET.

• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and parameterized reports using SSRS 2008.

• Developed SSRS reports which include dynamic grouping fields, drilldown and dashboard report and Export reports into various formats such as PDF, HTML, EXCEL, and WORD.

• Created Dashboards using SQL Server Reporting Services (SSRS). Environment: SQL Server 2008/2008R2, T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Visual Studio.Net 2008 (C#.NET), ASP.NET, Web service. EDUCATIONAL QUALIFICATION:

Bachelor’s in Engineering (Electrical & Electronics) P.E.S. Institute of Technology and Management.

TECHNICAL SKILLS:

Programing Languages: C#, SQL, T-SQL, ASP.Net, VB.NET, XHTML, XML Tools & Packages: SQL Server Management Studio (SSMS), SSRS, SSIS, SSAS, MS Visual Studio 2010/2008, Business Intelligence development Studio (BIDS), Export & Import (DTS), Tableau, Query Analyzer, SharePoint 2010/2007, Enterprise Manager, Team Foundation Server Databases: MS SQL Server 2012/2008R2/2008/2005, MS Access, DAX, MDX, SSIS, SSRS, Oracle 11g/10g/ 9i, MS Access 2000

Data Modeling Tools: MS Visio 2010/2007/2005, Erwin Application Packages: MS Office 2013/2007/2003/2000(Word, Excel, Power Point, Access) Operating Systems: Windows 7/ Vista /XP Professional. Windows Server 2008/2003/2000, UNIX

Contact this candidate