Harshini Reddy

Sr. BI Developer

Ph. # 267-***-****

ad2pge@r.postjobfree.com

PROFESSIONAL SUMMARY:

Over 9 years of IT experience in all the aspects of Software Development Life Cycle (SDLC) which includes Analysis, Design, Development, Testing of applications using Data Warehousing concepts and Business Intelligence tools.

Working experience with MS SQL Server (2012/2008/2005/2000/7.0) and Visual Studio (2010/2008/2005/2003) used to generate reports, design models, integration, developing custom utilities and applications using .NET.

Extensive experience developing and implementing solutions using Microsoft SQL Server integration services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS) for data warehousing and data marts.

Expertise in Power BI Premium, Power BI Pro, Power BI Mobile.

Experienced in Developing Power BI Reports and Dashboards from multiple data sources using Power BI Desktop.

Maintained existing Power BI reports and dashboards and made changes onto the same as per new and changing business requirements.

Utilized power BI desktop to design real time dashboards and scorecards for analytical decision.

Created packages using SQL Server Integration Services (SSIS) for data Extraction from/Load to Flat Files, Excel File MS Access, DB2, Oracle etc.

Creating and monitoring the batch jobs using SQL Server Agent.

Installed Configured and Maintained SQL Server Integration Services (SSIS). Created SSIS/DTS packages and deployed them to SQL Server and File system. Maintained the configurations passing the variable values though XML file, database table and sometimes through Environment variables to run the packages manually upon failure.

Also configured and deployed the new Project based deployment introduced in 2012 SQL Server Data Tools (SSDT). Deployed the Projects to Integration Services Catalog and managed the security. The Configurations are set from Project and Package parameters through the Environment.

Proficient in design and development of various dashboards for data visualization, reports utilizing Power BI Visualizations like Funnel Charts, Bar Graphs, Scatter Plots, Pie-Charts, Donut Charts, Bubble Charts, Line charts, Heat Maps, Tree Maps.

Installed Configured and maintained SQL Server Reporting Services (SSRS) reports and deployed to the Report Manager and the Sharepoint. Also maintained the security and performance of these reports.

Created cascade parameterized, adhoc, drillthrough, drilldown, Graph, Chart, KPIs, linked, snapshot, subreports, canned reports etc. using SSRS.

Integrated SSRS and Crystal Reports with .net application automatically passing the report parameters from the application and defaulting to the desired output to a certain format if required.

Created SQL Server Analysis Services (SSAS) cubes and migrated some of the existing cubes. Also created SSRS reports out of these cubes writing MDX queries to pull the data.

Created multiple cubes in a database solution with multiple facts in a single cube with shared dimensions.

Created hierarchies, partitions and perspectives as and when required based on the complexity of the cube.

Processed and maintained the cubes on a schedule directly in SQL Agent using XMLA or through SSIS process task.

Experience with design of Datawarehouse and DataMart’s using Inman and Kimball methodologies based on the organization.

Experience with design and implementation of Star Schema and Snowflake Schema Dimensional model.

Experience in RDBMS database and tables design Normalization, De Normalization, Unique, primary, foreign keys and Clustered, Non clustered Indexes.

Extensive experience with T-SQL in writing and debugging complex stored procedures, triggers, table views and user-defined functions.

Working experience with ASP .NET and C# and its integration with Webfocus Reporting and SQL Server Reporting Services.

Connecting to database using ADO.NET and data retrieval using Dataset and Data reader. Also using LINQ and AJAX in the new frameworks.

Experience in web applications with .NET framework 2.0/3.0/3.5/4.0 using ASP.NET,C#, ADO.NET, SOAP, Web Services, XML and XSL.

Development of Interoperable WebServices, Winforms, Console Applications using C# and VB. Net.

Well versed with IIS, registry, assembly configuration. Used Powershell script to register .net assembly in GAC.

Also has experience in MS SQL Server configuration, performance tuning (using Sql profiler and tuning advisor) client/server connectivity, query optimization, back-up/recovery, running Database Consistency Checks using DBCC.

Delivered 24/7 support including scheduled and emergency night and weekend work.

Effective Team Player with excellent Analytical, Programming, Written and Verbal Communication skills.

Technical Skills:

Databases

MS SQL Server 2017/2012/2008R2/2008/2005/2000, Oracle 10g/9i/8i, DB2, Access

ETL Tools

SSIS, DTS

Reporting Tools

Power Bi, SSRS, Crystal Reports X1/X,

Languages

C, C++, C#, LINQ, Visual Basic

.NET Technologies

Web Forms, ASP.NET, ADO.NET, .Net 3.5/3.0/2.0, Web Services

Web Servers

Microsoft IIS, SharePoint 2010/2007

Scripting Languages

JavaScript, JQuery, AJAX, HTML, XML, XSD, CSS, T-SQL, Powershell

Methodologies/Tools

UML, MS Visio

IDEs/CMS/Tools

MS Visual SourceSafe VSS, TFS, Visual Studio 2010/08/05/03

Operating Systems

Windows Server 2008/2003/2000, Windows 7/XP

Cloud

SQL Azure

Professional Experience:

Client: Siemens Healthineers Jan 2019- Till date

Location: - Malvern PA

Role: Sr. Power BI Developer

Responsibilities:

•Worked in the Application performance team to identify, analyze and improve the performance of the applications.

•Created Power BI reports and Dashboards to identify the bottlenecks and coordinated with the Oracle source system.

•Built SQL Azure Data Warehouse bringing data from different source systems and created analytical reports.

•Created SSIS packages to perform the ETL operation and load data from excel spreadsheets, text files etc.

•Set up the Power BI environment and manage the permissions to the Power BI Service.

•Deployed the .pbix files to sharepoint, shared workspace with the team for quick internal review.

•Created reports using Power BI Desktop and published them to Power BI Service.

•Created rich visuals such as box and whisker, stacked area, Tree map, KPI, Card, field map, dual charts, pie, donut charts, graphs, slicers, gauge, drilldown, drillthrough etc.

•Crated reports using DAX functions such as sumx, maxx, if, switch, calendar, weeknum, year, distinct, summarize, group by, calculate etc.

•Created customized PowerApps to share dashboards with business users and managed the permissions.

•Created Power BI Dashboards and scheduled the data refresh and set subscriptions as per the reporting needs.

•Created SSIS packages to load data into Staging tables and eventually populating the dimension and Fact tables.

•Created stored procedures, views, functions etc., to transform complex business logic and load data into the data warehouse tables.

•Created Indexes to reporting tables and update statistics periodically to get the best performance.

•Involved in gathering business requirement from business users and prepared BI technical specifications.

•Expertise in performance tuning and optimization of the Reports and Dashboards.

•Provided production support and resolved any ETL/Reporting issues.

Client: Finance of America Feb 2017- Dec - 2018

Location: - Horsham PA

Role: MS BI Developer

Responsibilities:

•Worked as a developer in creating complex stored procedures, triggers, functions, indexes, tables, views and other T- SQL code and SQL joins for applications.

•Involved in gathering business requirement from business users and prepared BI technical specifications.

•Excellent experience in performance tuning and optimization of SSRS Reports.

•Extensive experience in developing reports with drill down reports, drill through reports, parameterized reports and sub reports.

•Designed and implemented stylish report layouts and Looked at the reports and fixed bugs in stored procedures.

•Identified and worked with Parameters for parameterized reports in SSRS 2005.

•Responsible for scheduling the subscription reports with the subscription report wizard.

•Deployed the generated reports directly on the client's workstation.

•Created Sub Reports, Linked Reports, Pie charts, bar graphs reports to users based on their requirements.

•Delivered final Power BI report as embedding in Sharepoint/Custom Application/Office Tools.

•Developed, monitored and deployed SSIS packages.

•Developed SSIS packages using various transformations such as conditional splits, fuzzy look ups, aggregations and multicasting.

•Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.

•Created a custom Content Pack in Power BI and published it across to specific usegroups / entire organization.

•Implemented SQL server 2014 latest features like Project level Deployment, Project Parameterization, GUID etc.

•Worked on Data Analysis Expressions (DAX) for accessing data directly from tabular SSAS database.

•Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.

•Created, Maintained & scheduled various reports in Power BI like Tabular Reports,Matrix Reports.

•Used SSIS to create ETL packages to validate, extract, transform and load data to Data Warehouse databases.

•Created Tabular Models as a source to Power BI dashboards and scheduled jobs to refresh it in a timely manner.

•Developed and maintained multiple Power BI dashboards/reports and content packs.

•Made changes to the existing Power BI Dashboard on a regular basis as per requests from Business.

•Provided production support on the existing Power BI dashboards and other ETL processes to resolve the issues quickly.

•Published Power BI Desktop reports created in Report view to the Power BI service.

Client: Navient (Sallie Mae), Wilmington DE Nov 2014 – Jan 2017

Role: Reporting Analyst

Responsibilities:

Analyze Design, Development and Testing of applications using MS SQL Server and Visual Studio.

Migrated all SSRS Reports to Power BI Dashboards.

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

Translated the business needs into technical specifications.

Created reports using, Pie charts, Column chart, Scatter chart, Slicers, KPI, and Table Matrix.

Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.

Worked in Power BI environment to create dashboards like daily, weekly, monthly reports using Power BI desktop and publish them to server.

Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel.

Published Power BI Desktop reports created in Report view to the Power BI service.

Made changes to the existing Power BI Dashboard on a regular basis as per requests from Business.

Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.

Worked closely with business users in order to understand the legacy Excel reports and did conversion to SSRS.

Used subscription to schedule reports to be generated on predetermined time.

Created Drilldown, Drillthrough, Canned reports, Charts etc and Deployed to ReportManager.

Deployed and scheduled SSRS Reports to generate all daily, weekly, monthly and quarterly Reports including current status. Involved in optimizing report performance using Report Caching and Snapshots.

Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS).

Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services (SSRS). Deployed the generated reports on to the server.

Written complex SQL statements using joins, sub queries and correlated sub queries.

Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.

Fine-tuned the logic in stored procedures, Functions and Triggers for optimum performance.

Created indexes on the columns recommended by query optimizer to improve the performance of the slow running queries and stored procedures.

Migrated some of the SSRS reports from 2005 to 2008 environment.

Developed reports in SSRS from IBM Netezza warehouse and SQL Server.

Created new SSIS packages for the data migration from IBM Netezza warehouse to SQL Data Marts and created reports out of them.

Converted all the existing Excel reports into SSRS and created Tabular, Matrix Reports, Charts, Line Graphs, Stacked Bar Charts, Pi charts etc. and added default date parameters to refresh the data monthly in the reports.

Created Subscription for the reports and scheduled and maintained the delivery of the reports to the corresponding users.

Created detailed documentation of all the reports covering both the technical and non technical aspects.

Introduced SSRS and trained all the existing senior developers in SSRS and helped them to develop reports and resolve any issues they encountered while creating the reports.

Client: Sunoco, Philadelphia PA May 2013 – Oct 2014

Role: BI Developer

Responsibilities:

Interface with users, project manager to ensure that implemented solutions satisfy business requirements and are delivered in a timely manner.

Understand the functional requirement specifications and preparing design documentation.

Installed, configured and maintained SQL Server Integration Services (SSIS).

Deployed packages to SQL Server and file system in 2008 and also used the new Project based Deployment introduced in 2012 SQL Server Data Tools (SSDT) to deploy the 2012 packages.

Configured and deployed the SSIS 2012 projects to the new Integration Services Catalog. Set the Environment and managed configurations using the Package and Project variables.

Maintained the SSIS projects and users accessing the Catalog and SSISDB.

Scheduled and monitored the SQL Agent jobs to run these packages periodically.

Created SSIS packages to Extract, Transformation and Load (ETL) inventory and other sales data from Flat Files, Excel Files, Access, Mainframe DB2, Oracle etc.

Created new SSIS packages for the existing legacy Data Transformation Services (DTS) packages in the due course of data migration from SQL Server 2000 to 2005.

Scheduled and monitored the execution of the jobs using a third party tool Global Event Control Server (GECS) and SQL Server Agent.

Used package variables and configuration files to run the packages manually mapping through environment variables in case of job failure.

Implemented SQL Server SSIS packages for ETL methodologies involved in the migration from SQL Server 2000 to 2005 and 2008 and created new SSIS packages for the legacy DTS packages and scheduled and monitored the execution of the jobs.

Used SQL Server Reporting Services (SSRS) to create reports, customized Reports, on-demand reports, Charts, KPIs, Drilldown Drillthrough and other Canned reports and multi-dimensional reports from the cubes and Deployed to Sharepoint and ReportManager.

Migrated, recreated and maintained the Legacy packages, cubes and reports.

Migrated some of the SSRS reports from 2005 to 2008 and from 2008 to 2012 environment.

Supported Style Sheets that contain drill down parameters and links to arbitrary URLs and embedded GIF images in report headings and footings.

Involved in building and maintaining dimensional cubes with SQL Server Analysis Services (SSAS) and used MDX script for querying the data.

Developed Business views, Report objects, Cubes for the users to analyze the data and help them in decision making.

Deployed SSRS reports to Report Manager and made a call to those reports through a URL from .Net API (.aspx).

Developed reports using SSRS and exported directly to EXCEL, CSV and PDF formats bypassing the report manager screen running the reports from ASP.NET application.

Designed interactive web pages in ASP.NET and user controls using C#. The pages are developed using dynamic controls with java scripting.

Experience developing web applications using ASP.NET,C#, ADO.NET using both C# and VB#.

Also developer Web applications on the client side using HTML, AJAX, JQuery and LINQ to SQL which is much faster to render since it runs on the client side.

Performing Unit testing and internal QA for the developed application.

Created and maintained the SSRS reports, design documents and other scrum status trackers available on SharePoint for the business users and the steering team.

Used Compucom ticketing system for the change management and tracking the issues and enhancements.

Working closely with the users supporting the existing reports and creating new reports.

Client: Dept of Education, Dover, DE Feb 2011 – Apr 2013

Role: BI Developer

Responsibilities:

Developed system standards, architecture, scenarios, detailed screen specifications and documented logical and physical data model.

Design/Build Extract Transform Load procedures in SQL Server 2005 to import/export data feeds to/from data warehouse and claim systems.

Worked on Stored Procedures and Database Triggers.

Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the insurance data from various source systems feeds using SSIS.

Worked Extensively with SSIS to import, export and transform the data between the linked servers.

Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS).

Involved with various business groups while developing their applications, assisting in database design. Worked on SQL query tuning, execution plan to enhance query performance.

Design and implementation of Performance Tuning and Maintenance plan for database consistency checks, backup/restore. Designed DTS package to export data from/to access data source to SQL Server.

Performance Tuning the Stored Procedures used in SSIS Packages and SSRS Reports.

Worked with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.

Created SQL Agent Jobs and scheduled the SSIS Package to run overnight. Resolved the issues associated with the job failure.

Proficient with SQL Enterprise Manager, SQL Query Analyzer, scheduling jobs with SQL Server Agent, and SQL Profiler.

Experience in generating Drill through and Drill down reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2005/2008.

Prepare documentation related to database design, objects security and rules.

Involved in Performance Tuning of SSIS Packages, reports, Views, Stored procedures using SQL Profiler and Tuning Advisor improving performance and scalability.

Defined production support document with recovery process.

Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.

Hands on experience in designing SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert etc.

Used various control flow tasks like FTP, Bulk insert task, Transfer job task etc and different data flow tasks.

Created indexes and implemented optimizal fill factor for all tables.

Create and Modify User Defined Functions, Stored Procedures, Triggers, Views according to the business requirements.

Optimizing Stored Procedures and long running queries using indexing strategies and query-optimization techniques. Used Try catch and @@error for exceptional handling.

Deltasoft Solutions Pvt Ltd, India Jan 2010 – Jan 2011

Role: SQL Developer

Responsibilities:

Developed reports using SSRS and exported directly to EXCEL, CSV and PDF formats bypassing the report manager screen running the reports from ASP.NET application.

Worked on the Reports module of the project as a developer on MS SQL Server 2005 (using SSRS, T-SQL, scripts, stored procedures and views).

Developed complex queries in T-SQL, wrote Stored Procedures, Triggers and Queries with best execution plan. Created cubes and dimensions for the analysis of sales in specific areas.

Used the SSIS Import/Export, migrated the Heterogeneous Database such as Oracle and Access database, flat files to SQL server 2005.

Configured SQL mail agent for sending automatic emails when SSIS packages fails or succeeds.

Created stored procedures and user-defined functions for different Reports.

Created complex correlated sub queries to generate reports.

Knowledge of working on translation to SQL cluster.

Used various ETL tools like SSIS/DTS for data flow from source files like XML, Excel, Tables, and Views to other databases or files with proper mapping.

Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies. Developed, monitored and deployed SSIS packages.

Utilized SSIS (SQL Server Integration Services) to produce a Data Mart for reporting.

Worked with SSIS packages involved FTP tasks, Slowly Changing Dimension, Fuzzy Grouping, Merge, Merge joining, Pivot, Unpivot Control Flow Transformations.

Enhancing and deploying the SSIS Packages from development server to production server.

Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.

Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.

Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services (SSRS). Deployed the generated reports on to the server.

Education: Bachelor of Technology from J.N.T. University, Hyderabad, India.

Reference: Will be provided upon request.

Contact this candidate