Sasikumar Mani

Client: The Empire Life

Technologies: SSIS, SSRS, SQL Server.

Role: SQL & SSIS, SSRS Developer.

Description:

This company provides various insurance policies to its individual and corporate clients. The project is to maintain and update the database systems with changing information on defined intervals. This project uses SQL Server database which stores information about employees, plan details, decease covered, plans eligible etc... for various customers. The main aim of this corporate Data warehousing project is to analyze revenue for each of its customer varying with different promotional schemes.,

Roles & Responsibilities:

• Managed end-to-end BI and data integration projects, encompassing requirements gathering, design, development, testing, and deployment to ensure timely delivery of solutions.
• Designing and developing ETL (Extract, Transform, Load) processes using SQL Server Integration Services (SSIS) to facilitate efficient data extraction, transformation, and loading operations.
• Managing packages, scheduling jobs, and monitoring data flow to optimize performance and minimize errors.
• Developing SSRS, PowerBI and Tableau visuals and dashboards. Deploying reports to Report server portal and managing access to users Administered user access to SSRS (SQL Server Reporting Services) reports, applying appropriate permissions and security protocols.
• Managed and configured user permissions for Tableau Server, granting access to reports and dashboards based on organizational roles and requirements.
• Handled user access requests and permissions for Power BI reports, maintaining data security and compliance with company policies.,

Client: Nielsen Holdings

Technologies: SSIS, SSRS, SQL Server

Role: SQL & SSIS, SSRS Developer

Description:

This web-based application provides its users with insights into competitive advertisement information across different local markets on various platforms. The reports which were generated by this can alert the stack-holders with new sales information and makes it easy to interpret data for addressing most of the competitive questions. We will partner with our product managers, researchers, and stakeholder teams to develop applications that facilitate the use of our models and analytics within a larger, integrated workflow.

Roles & Responsibilities:

• Analyzed and designed high-level design documents.
• Supported in troubleshooting and solving various clients’ queries.
• Utilized various package elements, including data flow tasks and transformations, to load modeled data into SQL Server from flat files and Excel sheets.
• Create Ad-hoc reports, detailed and summarized reports using SAP Business Objects Involved in designing various report features like drill down, parameterized, sub reports, linked reports, and other complex reports.
• Created complex TSQL queries, functions, views, indexes, and stored procedures to simplify report data at the database level.