Dhananjaya Reddy

Client: Wessex Water(UK) •Understand & interpret upstream and downstream data flow, data mapping, data profiling, check data quality from source to target. •Work closely with Solution Architect, Data modeler, Business Analyst to understand the requirements, providing solutions on DWH. •Design and build pipelines and workflows in Azure data factory (ADF) for integration. •SQL tunings & ETL optimization, testing and implementation, scheduling & monitoring SSIS jobs. •To create and review technical document.

Client: Tokio Marine Insurance •Assist the functional team in implementation of the IFRS-17 solution at customer environment, to participate in the end-to-end reporting process. •Orchestrate the data copying between different relational and non-relational data sources. •Use technical documentation and pair programming with other members to deliver well designed and tested codes.. •Extensive use of Azure components for creating workflows, create and maintain Azure blob storage and data quality check.

Client: Prudential Insurance •Perform technical assessment based on interpretation of the standards and designing the setup of IFRS17 solution for the customers. •To create Azure data factory self-hosted-IR pipelines which will be used transferring data files to on-premises SFTP server. •Build the SSIS packages for data loading, writing SQL scripts for the transformations and create orchestrate template for the SSIS packages. •Create and update technical documentations timely as per development sprints

Client: YTL group •To understand YTL MY IT landscape and business case to build reports for the clients, create data mart, production support and fix and update the defects. •Work closely with business analyst and end users for new enhancements. •Create and design SSIS packages, monitoring ETL jobs, ETL optimizations and fine tune the SQL scripts (stored procedures) for the existing codes. •Writing test scenarios using SQL, perform data quality checks for pre-post jobs. •Create Ad hoc reports in SSRS.

Client: AIA Insurance •Understand the Insurance focused BI solution like Insurance data models for life & health insurance, to work closely with data modeler and business analyst. •Designing dimensions, fact and snapshot table which are used across different data mart based on specific department requirements. •Create SSIS packages for data extraction and transform to meaningful data. •Writing SQL scripts for initial loading, fine tune the codes. • Fixing defects using BUGZILLA tool and update tracker.

Client: Tech Mahindra •Build SSIS packages, create data marts using T-SQL and normalization. •Deploy and schedule the ETL jobs for linear execution and using SQL interrogate the data warehouse and data sources to produce reports within both SSRS and Power BI for the business users. •Hands on with Visual Studio data tools, data flow tasks, environment setup

Client: UHG Insurance •Understand the functional HIPPA guidelines for US health care insurance. •Design and develop database solutions to drive efficiencies using SQL and SSIS and create reports using SSRS tool for the end users. •Creating work plans, schedules and supporting documentation for all SQL and ETL development work undertaken. •Backups, recovery, security, performance planning, patching, fine tuning. •Provide pre and post batch support, conduct unit test, SIT, and UAT support.