• Design and implement end-to-end data solutions (storage, integration, processing, visualization) in Azure• Design and implement database solutions in Azure SQL Data Warehouse, Azure SQL• Design & implement migration strategies for traditional systems on Azure (Lift and shift/Azure Migrate, other third-party tools)• Developed dashboards and visualizations to help business users analyze data as well as providing data insight to upper management with a focus on Microsoft products Power BI.• Engage with business users to gather requirements, design visualizations and provide training to use self-service BI tools• Developed and maintained multiple Power BI dashboards/reports and content packs• implemented ETL and data movement solutions using Azure Data Factory• Designs Logical and Physical Data Model for Staging, DWH and Data Mart layer• Data sources are extracted, transformed and loaded to azure blob containers with Python programming and SQL queries in data bricks notebooks

Responsibilities:• Analyzing business requirements and designing data model for application• Design and development of efficient and performant systems to handle complex data using HANA• Performing database administration, performance optimization, data modeling using SQL script and calculation engine functions using HANA• Designing Attribute views, Analytic views, Calculation views with multiple table functions, Stored Procedures, Restricted and Calculated measures, Input parameters and Filters• Implementing data security using Analytic Privileges and setup data level authorization at database layer using roles• Integrating data from different data sources (MySQL, DB2) into SAP HANA using ETL tools like Pentaho etc.• Performing unit testing, acceptance testing, end to end testing with the help of integration tests• Researching appropriate techniques and tools for better performance of the application• Maintaining offshore and onsite team coordination and monitoring agile based project milestones to meet on time delivery of team• Analyze and propose potential improvements in existing application by collaborating with functional and non-functional teams.• Setting up the Jenkins pipelines and scan jobs like black duck, Veracode and Sonar for new modules with in MOCI.• Implemented REST API’s using Spring Boot as per business requirements.• Implemented search engines with in MOCI using SOLR.

Responsibilities:• Attended industry enablement training to enhance my knowledge about different methodologies, architecture, and technologies to solve business problems• Designed backup and recovery process using Pentaho for mitigating failure of HANA as a transactional system• Involved in developing a new data model for migrating data from DB2 to HANA• Involved in capturing data lineage, table and column data definitions, valid values and other necessary information in the data models• Worked with developers to transfer the logical data model into the physical data model• Engaged in database design and normalization• Maintained data dictionary for future use• Experienced in data modeling – Attribute Views, Analytic Views, Calculation Views, Stored Procedures, and Analytic Privileges• Gained practical knowledge of Java Stack with designing & implementation through case studies and projects in an agile environment• Design and implementation using Spring framework and managing GitHub requests• Hands-on knowledge on Amazon Web Services like EC2, S3, DynamoDB, Route 53• Completed Amazon Web Services Associate Developer Certification.• Completed Microsoft Certified professional Certification.• Completed PowerBI (Data visualizing & Analyzing) Certification.Power BI Project(POC):During my time in Turing I have worked on different use cases and build dashboard around the same. Some of the examples are as listed below.Sales Insight Dashboard: The above use case was developed using multiple data sources (excel, SQL Server, Text/CSV, Power BI Desktop) in Power BI and generated the reports with different visualizations – (Map, R Script, Line charts, Bar charts, Pie charts, Plot charts, Rotating Tile by MAQ Software etc... Tools & Technologies:• ETL – Pentaho Spoon• Database – SQL Server.• Development tools - SSMS, SSDS for creating cubes and MDX Query’s.