Harish A

Sr. SQL, Power BI(SSIS/SSRS/SSAS) Developer

Mail: adgv0m@r.postjobfree.com

Phone: 614-***-****

Summary

8+ years of Extensive Experience in Business Intelligence applications design, development and Maintenance of Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analytical Services (SSAS).

Good Experience in Database Design, Data modeling, Development, Implementation, ETL and Reporting in SQL Server 2018/2016/2014/2012/2008.

Expert in Data warehousing concepts and OLAP technology.

Expertise in Banking, Insurance, Finance, Retail, Healthcare sectors.

Working extensively in Power BI report, creating tabular cube, creating data model for Power BI Report, Validating data quality of the report.

Experience in creating and configuring Azure directory.

Configure Geo-Replication for SQL Server Azure databases.

Experience on creating the VM machine in SQL Server Azure and configured the Transaction replication from Physical server to Azure SQL Server database.

OLTP Experience:

Developed & supported various mission critical Client Server applications by handling Database requests for various application development teams involving complex business logic, functionality.

Extensive experience with SQL Server and T-SQL in constructing tables, triggers, user defined functions, relational database models and data integrity.

Good knowledge in creating, modifying, using and debugging Stored Procedures, Views, indexed views.

Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.

Experience in Implementing Change Data Capture (CDC) on databases.

BI (SSIS/SSRS/SSAS):

Expertise in configuring and creating SSIS solutions for ETL and Business Intelligence Process for Data Integration and Migration services.

Skilled in Merging data from various Heterogeneous Data sources, Populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS.

Experience in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.

Experience in Performance Tuning in SSIS packages by using Row Transformations, Synchronous and Asynchronous Transformations.

Experience in developing data driven subscription reports and Ad-hoc reports using Report Builder in SSRS.

Expertise in creating various SSRS Reports - Parameterized, Cascaded, Linked, Drill-through and Drill-down reports.

Experience in Troubleshooting Report Processing, Subscription, Delivery and Configuration Problems.

Expertise in building Star schema and Snow Flake schema depending on business requirements.

Experienced in Designing, Building the Dimensions, Cubes with Star Schema and Snow Flake Schemas using SQL Server Analysis Services (SSAS) in SQL Server.

Expertise in Configuring and managing data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies with SSAS.

Used Various third-party tools to analyze the data in the cube by using different features like Chart view, Decomposition Tree, Performance Maps, etc.

Power BI:

Explore data in a variety of ways and across multiple visualizations using Power BI.

Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.

Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.

Expert in generating Sub Reports, Standard, Mailing Labels, Cross Tab Reports and Graph Reports by using Chart expert of Crystal Reports.

Technical Skills:

Data Warehousing & BI: SQL Server Business Intelligence Studio (SSIS, SSRS, SSAS, DTS)

Reporting Tools: SSRS 2012/2008/2005, Crystal Reports XI/X/9/8, Excel, Power BI, Tableau.

Database: MS SQL Server 2014/2008/2005, Oracle 10g/9i/8i, MYSQL, MS-ACCESS.

Programming: C, C++, Visual C++ 6.0, VB6.0, C#.Net, VB.Net, PL/SQL, TSQL.

IT Processes: Software Development Life Cycle (SDLC), Project Management

Productivity Applications: MS Word, MS Excel, MS Access, MS Project, Visio

Operating System: Windows 8/7/Vista/NT/XP/98/95, UNIX.

Application Servers: Microsoft IIS 6.0/5.0/4.0, Apache.

Education: -

Master’s in electrical computer engineering; Cleveland State University, OH.

Bachelors in Electronics and Communication Engineering; Anna University, India.

Certifications:

Microsoft Certified Power BI Developer.

Professional Experience: -

Sears, Columbus, Ohio April 2018 – Present

Role: - Sr. SQL BI (SSIS/SSRS/SSAS) Power BI Developer

Created reports such as Parameterized, Cascading, Drill through/Drill down Reports, Charts and specialized in producing Sub Reports using Relational data warehouse and OLAP Cubes.

Created Weekly, Daily level reports from lowest granular level (store) to highest (company) granular level with lots of metrics.

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

Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.

Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.

Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging

Created deployment documents for the reports and worked with database administrator in the deployment of the report objects to the production server.

Created SSIS packages to get the data from source (FTP Server) to staging environment using different transformations on daily basis.

Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).

Created SSIS packages and daily jobs which sends the customer data from production server to other servers (E-com) on daily basis.

Created ETL metadata reports using SSRS reports include like execution times for the SSIS packages, Failure reports with error description.

Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer based on the requirements.

Worked with offshore team on creating ETL packages related to Data warehouse and Azure DWH maintenance.

Designing the new data warehouse (DWH) in Azure by creating the cubes with measures for the purpose of analysis, decision making based on historical data.

Worked on Azure cloud database servers, ADLS and Blob Storage for ETL use. Also have knowledge on External and Internal tables along with Azure run books for job scheduling.

Created the report which gives the status of the production server jobs, which is useful for the team to track if there are any failures.

Environment: SQL Server 2014/2016/2018, SQL Server Management Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL server Profiler, Microsoft Visual Studio 2010, Power BI, Team Foundation Server(TFS), Azure.

UPS, Parsippany, NJ September 2017 – March 2018

Role: - Sr. SQL BI (SSIS/SSRS/SSAS) Power BI Developer

Writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers and SQLCMD.

Implemented Complex business logic with User-Defined- Functions, Indexed Views and created User Defined Data type, Clustered & Non-clustered Indexes.

Created Business-Crucial stored procedures and functions to support efficient data storage and manipulation.

Developed logical and physical data models, design data access strategies and wrote SQL code to access and manipulate data stored in relational databases.

Implemented ETL to Extract and Transform data from Flat File or CSV, Excel instance and to load into Staging Database.

Used some data conversion tasks in SSIS to load the data from flat file to SQL Server database.

Created packages in SSIS with error handling.

Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages.

Created reports with parameters, sub reports, cross tabs, charts using SSRS.

Export reports in various formats like MS Excel, PDF, MS Word, Text and CSV.

Modify the existing reports by adding new logic and deleting existing logic as the line of Business changes periodically.

Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.

Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports.

Updated mapping tables related to assigned functional areas as directed by the Business Analysts. Worked with Excel Power Pivot Tables.

Modified SSAS Tabular models with dimensions and fact tables from data sources.

Experience on publishing Power BI reports on dashboards in Power BI server.

Created different reports in Power BI Desktop and publish to Power BI online.

Wrote DAX Expressions, Power Query, Functions in Power BI.

Responsible for building reports in Power BI from scratch.

Used different type of slicers available in Power BI for creating reports.

Implemented row level security in Power BI.com by assigning these roles to specific persons.

Managed and viewed the security roles as per the requirement to implement the row level security.

Used recently introduced Power BI to create self-service BI capabilities and use tabular models.

Scheduled Jobs for executing the stored SSIS packages which were developed to update the Database on Daily basis.

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

To see the AML (Azure machine learning) Models and access Azure SQL DB we created SG (Security Group) and added to the Azure subscription, Azure ML workspace.

Configured and maintained the Transactional replication from SQL Server physical server Azure databases.

Studied the existing OLTP system(s) and Created facts, dimensions and star schema representation for the data warehouse.

Used Team Foundation Server (TFS) for version control of the code.

Environment: SQL Server 2012/2014 Enterprise Edition, SSIS, SSRS, SSAS, C#, Visual Studio 2010/2015, MS Visio, Team Foundation Server (TFS), SQL Profiler, Power BI, Azure.

Vizient Inc, Dallas, TX April 2016 – August 2017

Role: - Sr. SQL BI (SSIS/SSRS/SSAS) Power BI Developer

Developed complex programs in T-SQL, writing Stored Procedures, Triggers and Queries with best execution plan and defined Check constraints, Business Rules, Indexes, and Views.

Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.

Responsible for debugging failed ETL sessions and taking steps to mitigate impact to business users.

Worked with providers and Medicare or Medicaid entities to validate EDI transaction sets or Internet portals.

Designed and developed efficient SSIS packages for processing fact and dimension tables with complex transform.

Employed SSIS Data Profiler Task to profile Target Source Systems and build ETL Solutions, which was helpful in designing the table structures and cleaning data for data consistency.

Used configuration files and variables to deploy SSIS packages across several Environments (Development/Testing).

Created and tuned Event Handlers, Checkpoints and logging to maintain active packages.

Extensively utilized SSIS packages functionality to create complete ETL Process using scripts, stored procedure, Functions and Transformation of Data in BIDS.

Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).

Created Drill-through, Drill-down, Cross Tab Reports and Sub-Report using RDL.

Involved in implementing Key Performance Indicator (KPI) Objects in SSAS and Created calculate member in MOLAP cube using MDX in SSAS.

Automated KPI metrics reporting using Visual Studio Team Services/Power BI.

Exported or Imported data from other data sources like flat files using Import/Export through SSIS.

Building Ad-Hoc reports in Power BI depending on Business requirements is one of the major responsibility.

Used to connect different data sources like SQL DB (SQL Query), Tabular Model (MDX Query), Web Trends to Power BI and generate reports with different visualizations.

Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.

Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.

Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

MS SQL Server Configuration, Performance Tuning, Client-Server Connectivity, Query Optimization, Database Maintenance Plans and Database Consistency Checking DBCC commands.

Acted as a Scrum member for multiple projects.

Environment: SQL Server 2014, SQL Server 2016, T-SQL, SSRS, SSIS, SSAS, TFS, C#, Management Studio 2008, Query Analyzer, Team Foundation Server (TFS), SharePoint, PL/SQL, Power BI.

Perr & Knight, Fortworth Tx August 2015 – March 2016

Role: - Sr. SQL BI (SSIS/SSRS/SSAS) Developer

Gathered user requirements. Responsible for Analysis and implementation for DB changes requested by users. Developing reports using efficient data retrieval techniques.

Designed and developed efficient SSIS packages for processing fact and dimension tables with complex transform.

Employed SSIS Data Profiler Task to profile Target Source Systems and build ETL Solutions, which was helpful in designing the table structures and cleaning data for data consistency.

Used configuration files and variables to deploy SSIS packages across several Environments (Development/Testing).

Specifying the named sets for calculations using named queries. Responsible for creating reports based on the requirements using SSRS 2012.

Developed complex reports using SSRS for HR and other Business users.

Created Drill-through, Drill-down, Cross Tab Reports and Sub-Report using RDL.

Generated periodic reports based on the statistical analysis of the data from various time frame and division using Power Pivot, Power Query and Power BI.

Developed Analysis Services Project. Responsible for identifying and defining Data Source and Data Source views. Created cubes and defined the dimensions.

Defining relationships between Dimensions and Measure groups. Involved in the design and development of the SSAS cubes and MDX queries.

Implemented cell level security in cubes using MDX expressions to restrict users of one region viewing data of another region using SSAS.

Analysis of financial data to provide information regarding loan activity, sales, transfers and other significant changes in the portfolio.

Collaborated with department of Risk Management Service, Communication, Accounting and Data Service team to explore and align on issues and provide solutions.

Designed different types of KPI’s for percentage growth in different fields and compared over the period and designed aggregations and pre-calculations in SSAS.

Involved in designing Partitions in Cubes to improve performance using SSAS.

Created Database Maintenance plans for Full/Differential/Transactional backup Strategies and involved in database partitioning.

Implemented multiple projects using Agile Methodology.

Generated and implemented schema objects and application objects by creating Facts, Attributes, Hierarchies, Reports, Filters, Metrics and templates using ETL.

Environment: SQL Server 2012/2008, T-SQL, SSRS, SSIS, SSAS, Power BI, C#, Management Studio 2012, Visual Studio 2012, Rally, Power BI

Reddy’s Lab, Hyderabad, India Dec 2012 –Jan 2014

Role: - SQL Server Developer

Installed and Configured SQL Server 2008 successfully.

Created other database objects like tables, views, Stored Procedures, User Defined Functions, Triggers and indexes.

Error handling using Try-Catch Block.

Developed Database Triggers to enforce Data integrity and additional Referential Integrity.

Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables, added Columns, triggers and Worked on Index tuning, stored Procedure tuning.

Maintained the table performance by following the tuning tips like normalization, creating indexes and collect statistics.

Scheduled Daily and weekly Jobs and Alerting using SQL Server Agent.

Assisted the front-end application developers with their queries.

Taking Database Full Backup, Transaction log backup & differential backups.

Configured Snapshot replication for reporting, user acceptance test and development servers.

Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.

Prepared the detailed project layout, analyzed existing technology involved, and documented work performed and stored in Visual Source Safe (VSS).

Environment: MS SQL Server 2008/2012, T-SQL, Data Transformation Services (DTS), MS Excel, XML, Microsoft Visual Source Safe, MS Visio 2007, SQL Server Management Studio (SSMS), SQL Profiler.

Project #5

BHEL, Hyderabad, India May 2011 – November 2012

Role: -Jr. SQL Developer

Complete analysis, requirement gathering and function design document creation.

Written various T-SQL Statements for application development.

Responsible for the designing the advance SQL queries, procedure, cursor, triggers, scripts.

Developed many T-SQL stored procedures, views, indexed views, UDF for business reporting.

Collaborated with the application developers in data modeling and E-R design of the systems.

Also created, modified, maintained and optimized SQL server database.

Maintained the documents and create reports for the business analysts and end-users.

Coordinating user acceptance testing amongst business users.

Responsible for the management of the database performance, backup, replication, capacity and security.

Environment: MS SQL Server 2008, T-SQL, Data Transformation Services (DTS), MS Excel, XML, Microsoft Visual Source Safe, MS Visio 2007, SQL Server Management Studio (SSMS), SQL Profiler.

Contact this candidate