Hari Harra Sudhan V

Dedicated MSBI Developer with 5 + years of experience in creating stored procedures,views,functions,Indexes,Implementing data quality processes,developing reporting analytics solutions and collaborating with cross functional teams to improve the processes. Excellent team management and problem-solving abilities with a strong commitment to delivering high quality solutions that drive business success.

• Having 5 + years of experience in design and development using SQL Server, SSIS and SSRS
• Conversant in TSQL coding such as Tables, Stored Procedures, Views, CTE, User defined data types, functions, indexes and performance tuning.
• Developing SQL procedures and schedule the reports based on the client requirements.
• Experience in creating tSQLt unit test cases for stored procedures, functions regression testing.
• Analyzed the data to load with various source systems. Based on the analysis data will be handled.
• Basic ETL design and development of SSIS packages for extracting and transforming data from various sources (Excel, CSV, flat file, Text Format Data) by using multiple transformation tasks.
• Expertise in using global variables, expressions and functions for the reports with immense experience in handling sub reports in SSRS.
• Experience in design,report writing and developing reports by using SQL Server Reporting Services(SSRS), Business Intelligence Report Scheduling Tool (BIRST) and creating various types of standard reports and custom reports.
• Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.
• Handled the production support.
• Schedule and troubleshooting job failures.
• Performing Reconciliation on hourly/daily basis for source and database target.
• Proficient at grasping domain concepts quickly and utilize for Product Development.
• Highly enthusiastic and persuasive with communication and Personal Relationship Skills.

• DP-900 - Microsoft Certified Azure Data Fundamentals.
• DP-203 - Microsoft Certified Azure Data Engineer Associate.

Project : GP Customer OPS
Client : Lincoln Financial Group
Technologies : SQL Server2016, SSIS 2012, BIRST, Visual Studio 2019, SolarWinds
Duration : Jan 2023– Present
Description
•In GP Customer Ops project, based on the client requirement, new core procedure / Report Procedure logic/ Functions will be created along with the unit test cases, RDL,report template,XML Transformation file for report generation will be created.
•Worked around 45 plus Standalone report logic for generating the payroll reports, incentive reports, disability payments report, alerts reports, combined status report and several other custom reports for different customers.
•By using the Business Intelligence report Scheduling Tool (BIRST). The migrated reports are designed and scheduled to clients depends on the requirements.

Project : DRS Migration
Client : Lincoln Financial Group
Technologies : SQL Server2016, SSIS 2012, Sybase, Db Visualizer, BIRST
Duration : Dec 2021–Dec 2022
Description
•A DRS migration is the process of migrating old legacy platform SQR code to Microsoft Sql server platform.
•Converted around 50 plus standalone SQR code logics to SQL server platforms. So, the migrated codes will produce the data for various payroll reports, incentive reports, disability payments report, alerts reports and several other custom reports.
•By using the Business Intelligence report Scheduling Tool (BIRST). The migrated reports are designed and scheduled to clients depends on the requirements.

Project : LYCA Channel Kickback Process Development
Client : LYCA Mobile
Technologies : SQL Server 2008 R2, 2012, SSIS 2012
Duration : Sep 2019– Nov 2021
Description
•A kickback is the payment of something of value to a recipient as compensation or reward for providing favorable treatment to another party
•Kickbacks are often associated with procurement contracts. In the case of a government contract for office supplies, contractors and sub-contractors interested in winning the business are required to bid against each other. A contractor may reach out to a procurement officer and indicate that, if the contractor were to win, the officer may receive compensation. This could mean anything from cash to tickets to a concert.

Project : Subscribe Life Cycle Management
Client : LYCA Mobile
Technologies : SQL Server 2008 R2, 2012, SSIS 2012
Duration : Oct 2019– Nov 2021
Description
•Mobile number recycle is activity to find the customer were inactive for long period by doing no activity. After finding the list need to intimate that their number going to recycled.
•After some time period we will recycle that customers list and share the same to new production. This will help to control the mobile number shortage.
•Monitoring the customer’s activity by providing daily, monthly annual basis as per the client requirements.

Project : LYCA ETL
Client : LYCA Mobile
Technologies : SQL Server 2008 R2, 2012, SSIS 2012
Duration : Oct 2018 – Oct 2019
Description
•ETL is the process of extracting data from source systems and bringing it into our data warehouse.
•We need to load our data warehouse regularly so that it can serve its purpose of facilitating business analysis. To do this, data from one or more operational systems needs to be extracted and copied into the data warehouse. The challenge in data warehouse environments is to integrate, rearrange and consolidate large volumes of data over many systems, thereby providing a new unified information base for business intelligence.

Name                              : Hariharrasudhan V
Father’s Name           : Vijayasekar
Gender                           : Male
Nationality                  : Indian
Date of Birth               : 07-09-1996
Permanent Address: Plot No: 9A Uco Nagar,
                                             Perumantunallur, Guduvanchery,
                                             Chennai-603202.

I hereby declare that all the information given above is true, complete and to the best of my knowledge and belief.

Place:                                                                                                Yours Sincerely,

Date:                                                                                             (Hariharrasudhan V)