Prathap A. Email & Phone Number

London, Gb

Stockport, England, United Kingdom

• Architecture and Implementation experience with medium to complex on-prem to Azure migrations• Data Modeler Work with key business representatives, data owners, end users. The role involved Analysis of requirement, Designing and supporting the Build and coordination with testing team, implementation support.• Worked on Complex Data mappings & Data gap analysis.• Worked on Data sourcing Strategy and Batch analysis.• Worked on Application design document.• Experience working on Data Model / Data requirement specification.• Defined data governance framework and policies with the business and technical data stewards to effectively leverage data assets.• Helped the business de-duplicating master data using fuzzy matching algorithms and third-party frameworks in the migration phase.• Experience working with Informatica MDM tool.• Worked on Informatica (IDQ) for Data Quality rules.• Worked on Data pipelines, ETL using ADF & Databricks• Designed and implemented Data Dictionary & Azure Data Catalogue • Implemented Azure storage with Azure Data Lake.• Experience working with BI reporting tools like (power BI/Tableau ,Qlikview/Qlik Sense)• Experience working with Azure Synapse analytics and Azure sql databases and On-premise servers.• Worked on Data Security and Policies and Encryption.• Worked on Data Discovery and classification.• Experience working CI/CD (Continuous integration and Continuous deployment)• Developed Spark applications using Pyspark and Spark-SQL for data extraction, transformation and aggregation

London, England, United Kingdom

* Worked on Azure Solutions Migration on premises to Cloud.* Worked on Databricks with pyspark and scala and RDD.• Worked on Data Architecture side• Worked on Azure Data warehouse and Azure databases• On premises data migration to Cloud• Azure data factory & SSIS and Azure Analysis Services.• Azure Data lake and Azure blob storage & data bricks• Worked On CI/CD pipelines (build & Release pipelines) for code merge and version control• Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as Opportunities, Leads and Weighted and Estimated revenue along with slicers and dicers enabling end-user to make filters.• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision mak-ers for strategic planning.• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data munging.• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.

Milton Keynes, England, United Kingdom

Data Processing with Data bricksData Orchestration with Azure Data FactoryCreate and build deploy and Maintain Data pipelineDesign Azure data storage solutionsDesign data processing solutionsDesign for data security and complianceIntegration with Marketing platformsdevelop batch processing solutions by using Data Factory and Azure Databricksingest data by using PolyBaseimplement the integration runtime for Data Factorycreate linked services and datasetscreate pipelines and activitiescreate and schedule triggersimplement Azure Databricks clusters, notebooks, jobs, and autoscalingingest data into Azure Databricks

Data Ingestion into Dynamics using Azure Data Factory & SSIS Data Architecting-for Single Customer viewAzure Sql Databases -HybridHandling multiple azure tenantsImplement data storage solutionsManage and develop data processingMonitor and optimize data solutionsDesign Azure data storage solutionsDesign data processing solutionsDesign for data security and complianceIntegration with Marketing platformsdevelop batch processing solutions by using Data Factory and Azure Databricksingest data by using PolyBaseimplement the integration runtime for Data Factorycreate linked services and datasetscreate pipelines and activitiescreate and schedule triggersimplement Azure Databricks clusters, notebooks, jobs, and autoscalingingest data into Azure Databricks

Paddington

* Worked on Azure Solutions Migration on premises to Cloud.* Worked on Databricks with pyspark and scala and RDD.• Worked on Data Architecture side• Worked on Azure Data warehouse and Azure databases • On premises data migration to Cloud• Azure data factory & SSIS and Azure Analysis Services.• Azure Data lake and Azure blob storage & data bricks• Worked On CI/CD pipelines (build & Release pipelines) for code merge and version control• Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as Opportunities, Leads and Weighted and Estimated revenue along with slicers and dicers enabling end-user to make filters.• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision mak-ers for strategic planning.• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data munging.• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.• Experience using CRM dynamics and Salesforce.• Integrating with CRM Dynamics 365• Complex Data transformation using Power Query -(Power BI)• Worked on Complex Dax calculations to satisfy business Rules• Worked on Various different dashboards On Revenue & Accounting and customer Profile.• Migrated Tableau and QlikView Dashboards into Power BI.• Visualising Various data science Projects in Power BI• Predictive Analytics dashboards for Estimated Revenue (Power BI)* AWS RDS Mysql/AWS RDS Oracle* AWS S3 Storage

London, United Kingdom

•Hands on experience in developing & deploying enterprise solutions, with Microsoft technology stack •Hands on experience in designing and deploying solutions on Microsoft Azure platform.•Experience with public cloud platforms, including design and implementation•Design Enterprise Business Intelligence Architecture.•Document existing enterprise system architecture using Info body Model and analyse problems for improvement.•Extensive experience in Installation, Configuration and Updates of SQL Server.•Extracting, transforming and loading data from multiple sources into Power BI/Tableau/ QlikView•Extracting, transforming and loading data from multiple sources into Power BI applications•Writing SQL Scripts to load the relevant data in PBI Dashboards•Experienced in programming tasks-Stored Procedures, Triggers in SQL Server 2005/2000/7/8 with T-SQL.•Expertise in generating reports using SQL Server Reporting Services, MS Excel spreadsheets.•Excellent skills in implementing ETL Packages using DTS and SSIS 2008/ 2005.•Experience on Data modelling and Data warehouse. & Data Wrangling. •Used Git-Hub for Version Controls.* Databricks & data science and machine learning models.•Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.•Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs .•Utilized Power Query in Power BI to Pivot & Un-pivot the data model for data cleansing & data munging•Implemented several DAX functions for various fact Cal's for efficient data visualization in PowerBI.•Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.•Implemented several DAX functions for various fact Cal's for efficient data visualization in Power BI. •Designed, created and maintained QlikView applications.

Havant

• Design, develop and implement Tableau/SSRS/Qlikview dashboards for multiple internal business units.• Modify and enhance existing dashboards.• Document logic behind dashboard objects along with any data transformation taking place within Qlikview• Analyse user requirements to produce high-performance, high value dashboards• Identify and define improvements to existing dashboards• Review and troubleshoot day-to-day dashboard support issues.• Performs other responsibilities as assigned.• Superior knowledge of relational databases and data modelling• High organisational and project management skills• Exceptional analytical and time management skills• Excellent ability to translate client requirements into effective solutions• Writing SQL Scripts to load the relevant data in QlikView Applications.• Designing Data Modelling and Loading data from Multiple Data sources.• Performance tuning by analysing and comparing the turnaround times between SQL and QlikView.• Worked on Section Access Including creating roles and conditional show for sheets.

• Responsible for positioning and delivering Tableau/SSRS/QlikView projects and cross building applications into new and existing customer base.• Worked with Qlikview 10.x, 11, 12, SQL Server, Oracle, Excel, flat files.• Customer reporting via N-printing.• Active & Custom directories Used for User Access.• Experience in Agile Development (Weekly Sprint reviews and Daily stand-up)• Worked On large data sets and Complex data models.• Migration to newer versions & Version Controls• Worked in different environments (Test/Pre-prod/Prod).• Developed Applications using Qlik Sense.• Developed complex SQL queries and functions to fetch data for reporting and to accomplish several computations.• Specified the standards/best practices for universes like maintaining design consistency.• Provided implementation and ongoing support related to Qlikview. • Submitted projects ensuring deadlines are met• In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework• Familiarity with BI technologies (e.g. Microsoft Power BI, Oracle BI)• Knowledge of SQL queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS)• Proven abilities to take initiative and be innovative• Analytical mind with a problem-solving aptitude• Ad hoc excel reports are created based on the business user requirements.

• Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.• Experienced in programming tasks-Stored Procedures, Triggers in SQL Server 2005/2000/7/8 with T-SQL.• Expertise in generating reports using SQL Server Reporting Services, MS Excel spreadsheets.• Excellent skills in implementing ETL Packages using DTS and SSIS 2008/ 2005.• Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.• Experience on Data modelling and Data warehouse.• Data Wrangling.

Master’S Degree, Computers Systems Engineering, A

Bachelors In Electronics And Communication Engineering, Ece, A