Hariprasad K Email and Phone Number

Experience in Microsoft technologies such as MS SQL Server and Microsoft Business Intelligence tools (SSIS) and POWER BI Desktop and POWER BI Services.•Extensive experience in SQL and T-SQL in constructing Procedures, Table variables, user defined functions, views, indexes, CTE, temp tables and Constraints.•Strong Knowledge in SQL Commands like (DDL, DML, DCL, TCL).•Good Experience in optimizing the queries by creating various clustered, non-clustered indexes and indexed views.•Experience in using SQL Server Agent to Scheduling and Monitoring the Jobs.•Good knowledge in Admin related concepts like Backups and restores.•Experience in designing Control flow tasks by using for Sequence and for each loop Containers.•Designed various SSIS Packages for integrating data from heterogeneous sources (Excel, flat file) to Destination by using multiple transformations provided by SSIS like Data Conversion, Derived Column, Conditional Split, and Lookup, multicast, merge and union all.•Good Knowledge in connecting with multiple data sources like SQL Server and Excel from Power BI to build Datasets.•Worked on performing the ETL Activities in Power Query and filtering the Unwanted Data in Power Query.•Good knowledge in doing Data Modeling in Power Pivot Model. •Knowledge in creating relationships between multiple tables in power pivot.•Good knowledge in Creating Hierarchies and Drilldown Reports.•Knowledge in publishing reports to Power BI services and setting up the necessary connection details and scheduling.•Restricted data for users using Row level security and User filters in tableau and Power BI•Experience in SSIS package deployment.•Experience in GITHUB version control tools•Extensive experience in interacting with users, requirement gathering and converting the business requirements to technical requirements and design them as per the business.