$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Senior
{{ $t($store.state.user.experience_search_name) }}
0
jobs
Senior Data Engineer and BI Developer
Rama Gudepu
,
Bracknell, United Kingdom
Experience
Other titles
Skills
I'm offering
Over 12 years of in-depth hands-on experience in full software development life cycle. Extensive experience as a Data Engineer using Azure Services like Azure Data Lakes, Data Factory, Data Bricks, SQL Data Warehouse(Synapse Analytics) and a BI Consultant using Microsoft BI Suite. Solid T-SQL coding and developer skills on MS-SQL server 2008 / 2008 R2 / 2012/ 2014/2016/2017. People-oriented, outstanding communications and project management experience.
Markets
United Kingdom
Links for more
Once you have created a company account and a job, you can access the profiles links.
Language
English
Fluently
Ready for
Larger project
Ongoing relation / part-time
Full time contractor
Available
My experience
2013 - 2020
freelance
Senior Data Engineer and BI Developer
Scottish and Southern Energy.
Implementation and Migration Skills:
• Azure Online Cost Calculator
• Cloud Data Migrations
• DB Migration Compatibility Analysis
• Data Synchronization
• Provisioning
Responsibilities:
• Involved in Data Mart Design, Design and Development of ETL packages and Reports.
• Responsible to create and enhance Logical Data Model using Erwin.
• Responsible to convert Logical Model to Physical Model with the help of DBA.
• Involved in creating Cloud/On-Premises Database
• Involved in Data migration of complex sets of data from multiple sources to different target systems.
• Involved in Cloud Data Migration with multiple sources of data.
• Involved in creating a Data Warehouse on Azure.
• Implemented Pipelines using Azure Data Factory.
• Performed ETL and ELT using Azure Data Factory.
• Populated the data lakes with data from multiple data sources.
• Interacted with the Business to understand the requirement and perform the Data Quality/Data Profiling analysis to meet the requirement.
• Interacting with the client on various forums to clarify any queries regarding the functionality and appropriate access required etc.
• Managed Team of 4 Junior developers during Key Project Development Stage and produced weekly Status reports.
• Involved in Logical and Physical Database design & development, Data Conversion, Normalization and Data modelling using Erwin.
• Developed complex T-SQL queries using joins, stored procedures, used defined functions based on the business requirements.
• Involved in performance tuning of T-SQL blocks and activity monitoring the server for any bottlenecks
• Developed scripts for identifying the shortfalls with the migrated data.
• Created complex SSIS packages and optimized them to the fullest depth to reflect required business logic to implement designed ETL Strategy.
• Efficiently managed complex ETL packages by creating logging, checkpoints, transactions, configurations and deployed it on the production server using push and pull deployment methodology.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP) and SQL Server Integration Services (SSIS).
• Created proxy account for automating SSIS packages using SQL Agent Jobs
• Scheduled & Maintained ETL packages in terms of data validation and consistency
• Involved in designing and creating Business Intelligence Reporting portal on the internal website
• Configured and maintained Report Manager and Report Server for SSRS.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Designed and created Report templates, bar graphs and pie charts based on the financial data also scheduled monthly/weekly/daily reports to run automatically
• Lead the backend design, development and implementation of Siebel based CRM.
• Created adhoc reports using excel Pivot Tables
• Created Board Scorecard, Data Quality and Performance KPI Dashboards using Power BI
• Published dashboards to Power BI service and administered user access permissions.
• Created workspace groups and organizational content packs in Power BI
• Implemented Power BI mobile dashboards via Power BI mobile application
• Automated Power Query refresh using power shell script and windows task scheduler.
• Installed and configured Enterprise gateway and Personal gateway in Power bi service.
• Created Workspace and content packs for business users to view the developed reports.
• Scheduled Automatic refresh and scheduling refresh in power bi service.
• Wrote calculated columns, Measures query's in power bi desktop to show good data analysis techniques.
• Weekly presentation to the business users about the reports and their changes as required.
• Participated in project planning sessions with project managers, business analysts and team members to analyse business requirements and outline the proposed solution.
• Designed and created data extracts, supporting SSRS, POWER BI, Tableau or other visualization tools reporting applications.
• Developed Excel Power View, Power Query and PowerPivot dashboards for data analysis.
• Developed confidential proprietary analytical tools and reports with Confidential Excel, and Power Pivot and Power Point.
• Experience in creating Power BI reports that represent different findings and insights from the data using interactive charts and maps, with ability to drill down to the underneath data.
• Created dashboards in Power BI using Dynamics CRM Data.
• Upload of Power BI reports to Power BI server and implement user-based authorization.
• Experience developing reports from Cubes using the KPI's for decision making, also debugged data connections, data sources and Data Source Views.
• Creating Ad Hoc and Parameterized Various Reports using SQL server 2012 Reporting Services
Environment: Azure data Factory, Azure Data Bricks, Azure Data Lakes, Azure Data Pipelines, SQL Server 2008 R2, SQL Server 2012/2016, SQL Agent, SSIS/SSRS, Microsoft Master Data Services, Report Builder 3.0, Report Designer, Erwin, SharePoint, Access database, Linked Server, Power BI.
• Azure Online Cost Calculator
• Cloud Data Migrations
• DB Migration Compatibility Analysis
• Data Synchronization
• Provisioning
Responsibilities:
• Involved in Data Mart Design, Design and Development of ETL packages and Reports.
• Responsible to create and enhance Logical Data Model using Erwin.
• Responsible to convert Logical Model to Physical Model with the help of DBA.
• Involved in creating Cloud/On-Premises Database
• Involved in Data migration of complex sets of data from multiple sources to different target systems.
• Involved in Cloud Data Migration with multiple sources of data.
• Involved in creating a Data Warehouse on Azure.
• Implemented Pipelines using Azure Data Factory.
• Performed ETL and ELT using Azure Data Factory.
• Populated the data lakes with data from multiple data sources.
• Interacted with the Business to understand the requirement and perform the Data Quality/Data Profiling analysis to meet the requirement.
• Interacting with the client on various forums to clarify any queries regarding the functionality and appropriate access required etc.
• Managed Team of 4 Junior developers during Key Project Development Stage and produced weekly Status reports.
• Involved in Logical and Physical Database design & development, Data Conversion, Normalization and Data modelling using Erwin.
• Developed complex T-SQL queries using joins, stored procedures, used defined functions based on the business requirements.
• Involved in performance tuning of T-SQL blocks and activity monitoring the server for any bottlenecks
• Developed scripts for identifying the shortfalls with the migrated data.
• Created complex SSIS packages and optimized them to the fullest depth to reflect required business logic to implement designed ETL Strategy.
• Efficiently managed complex ETL packages by creating logging, checkpoints, transactions, configurations and deployed it on the production server using push and pull deployment methodology.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP) and SQL Server Integration Services (SSIS).
• Created proxy account for automating SSIS packages using SQL Agent Jobs
• Scheduled & Maintained ETL packages in terms of data validation and consistency
• Involved in designing and creating Business Intelligence Reporting portal on the internal website
• Configured and maintained Report Manager and Report Server for SSRS.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Designed and created Report templates, bar graphs and pie charts based on the financial data also scheduled monthly/weekly/daily reports to run automatically
• Lead the backend design, development and implementation of Siebel based CRM.
• Created adhoc reports using excel Pivot Tables
• Created Board Scorecard, Data Quality and Performance KPI Dashboards using Power BI
• Published dashboards to Power BI service and administered user access permissions.
• Created workspace groups and organizational content packs in Power BI
• Implemented Power BI mobile dashboards via Power BI mobile application
• Automated Power Query refresh using power shell script and windows task scheduler.
• Installed and configured Enterprise gateway and Personal gateway in Power bi service.
• Created Workspace and content packs for business users to view the developed reports.
• Scheduled Automatic refresh and scheduling refresh in power bi service.
• Wrote calculated columns, Measures query's in power bi desktop to show good data analysis techniques.
• Weekly presentation to the business users about the reports and their changes as required.
• Participated in project planning sessions with project managers, business analysts and team members to analyse business requirements and outline the proposed solution.
• Designed and created data extracts, supporting SSRS, POWER BI, Tableau or other visualization tools reporting applications.
• Developed Excel Power View, Power Query and PowerPivot dashboards for data analysis.
• Developed confidential proprietary analytical tools and reports with Confidential Excel, and Power Pivot and Power Point.
• Experience in creating Power BI reports that represent different findings and insights from the data using interactive charts and maps, with ability to drill down to the underneath data.
• Created dashboards in Power BI using Dynamics CRM Data.
• Upload of Power BI reports to Power BI server and implement user-based authorization.
• Experience developing reports from Cubes using the KPI's for decision making, also debugged data connections, data sources and Data Source Views.
• Creating Ad Hoc and Parameterized Various Reports using SQL server 2012 Reporting Services
Environment: Azure data Factory, Azure Data Bricks, Azure Data Lakes, Azure Data Pipelines, SQL Server 2008 R2, SQL Server 2012/2016, SQL Agent, SSIS/SSRS, Microsoft Master Data Services, Report Builder 3.0, Report Designer, Erwin, SharePoint, Access database, Linked Server, Power BI.
Enterprise, SSRS, Developer, Mobile Application, Implementation, Monitoring, Development, Powerpivot, KPI, BEE, Server, Power, Production, Dynamics CRM, It, Planning, Visualization, Logic, Online, Tuning, Sql server 2012, Portal, Sql server 2008, Agent, Manager, Power Shell, Power Pivot, ETL, Sql, Excel, Data Analysis, Backend, Business Intelligence, SQL Server, CRM, Azure, Power BI, SharePoint, Deployment, Database, Data Warehouse, Design, Cloud, Tableau, Database design, Integration, T-SQL, Stored procedures, Windows, Service, Content, Website, Ssis, Data quality
2013 - 2013
freelance
Senior Business Intelligence Developer
Logicallis.
Responsibilities:
• Migrated all existing SSIS packages to the new dedicated server and configured all the environments to point at the new server
• Configured all the connection strings in configuration files and dll's for framework SSIS packages
• Migrated all the production SQL Server Agent Jobs to new SSIS Server and enabled all the jobs and schedules.
• Interacting with business and source system experts to resolve the Data Quality issues.
• Designing the Logical and Physical dimensional model using TOAD and detailing the Star Schema for the dimensions and facts.
• Created new SSIS packages as well as Framework SSIS packages and converted all the T-SQL steps within the jobs to SSIS type.
• Configured framework web app to point at new SSIS server for monitoring and supporting the SQL Agent Jobs
• Undertook integration testing, Unit testing and regression testing
• Created new Visual Studio Database project and scripted all the SQL Agent Jobs into it for effectively managing the deployments.
• Created and configured new SQLCMD variables.
• Deployed SSIS projects to the SSIS Catalog.
• Created reports using stored procedure and Experience in building Reports on Analysis Services cubes (SSAS)
• Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS)
• Developed a High-level dashboard using SSRS 2008.
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.
• Involved in designing Parameterized Reports and Report Models for generating Ad-Hoc reports as per the client requirements.
• Defined Key Performance Indicator metrics to create scorecards.
• Involved in creating report models and applying row level security filters for report model.
• Created daily, weekly, monthly and quarterly reports for the management team and field operation Managers
• Created a product grouping structure that can have multiple hierarchies within it.
• Managed and worked closely with Management team on various project tasks.
• Developed reports that can be extracted visually i.e. pie charts, line charts etc.
Environment: SQL Server 2012 - T-SSQL, SQL Agent, SQL Server Data Tools, Visual Studio, SSIS, SSRS, SSAS, Linked Server, TOAD Data Modeler.
• Migrated all existing SSIS packages to the new dedicated server and configured all the environments to point at the new server
• Configured all the connection strings in configuration files and dll's for framework SSIS packages
• Migrated all the production SQL Server Agent Jobs to new SSIS Server and enabled all the jobs and schedules.
• Interacting with business and source system experts to resolve the Data Quality issues.
• Designing the Logical and Physical dimensional model using TOAD and detailing the Star Schema for the dimensions and facts.
• Created new SSIS packages as well as Framework SSIS packages and converted all the T-SQL steps within the jobs to SSIS type.
• Configured framework web app to point at new SSIS server for monitoring and supporting the SQL Agent Jobs
• Undertook integration testing, Unit testing and regression testing
• Created new Visual Studio Database project and scripted all the SQL Agent Jobs into it for effectively managing the deployments.
• Created and configured new SQLCMD variables.
• Deployed SSIS projects to the SSIS Catalog.
• Created reports using stored procedure and Experience in building Reports on Analysis Services cubes (SSAS)
• Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS)
• Developed a High-level dashboard using SSRS 2008.
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.
• Involved in designing Parameterized Reports and Report Models for generating Ad-Hoc reports as per the client requirements.
• Defined Key Performance Indicator metrics to create scorecards.
• Involved in creating report models and applying row level security filters for report model.
• Created daily, weekly, monthly and quarterly reports for the management team and field operation Managers
• Created a product grouping structure that can have multiple hierarchies within it.
• Managed and worked closely with Management team on various project tasks.
• Developed reports that can be extracted visually i.e. pie charts, line charts etc.
Environment: SQL Server 2012 - T-SSQL, SQL Agent, SQL Server Data Tools, Visual Studio, SSIS, SSRS, SSAS, Linked Server, TOAD Data Modeler.
SSRS, Agent, Sql server 2008, Framework, Sql server 2012, Production, App, Server, Web, Testing, Monitoring, SSAS, Developer, Sql, It, Data quality, Security, Ssis, Regression testing, T-SQL, Integration, Management, Visual Studio, Database, SQL Server, Business Intelligence
2012 - 2013
freelance
SQL Server Analyst Developer
Alliance Boots.
Responsibilities:
• Gathered business requirements, definition and design of the data source, data flows and data quality analysis, and worked in conjunction with the data warehouse architect on the development of logical data models.
• Producing and reviewing Data Policies and Business Processes surrounding the data for Data Governance Process.
• Producing Data Model and enhancing the Model (in next phase) to include other data using TOAD.
• Implemented the Master Child Package Model for easier maintenance and better performance.
• Working on a data migration project, performed analysis on existing data structures, planned steps for data migration and integration and performed the actual migration and integration
• Performed high-level analysis on a variety of database systems. Some of the systems are pure data stores, both SQL Server and otherwise, and others are proprietary systems with a Front End.
• Extracted and transformed data (ETL) from various heterogeneous sources and created packages using SSIS, Import and Export Data.
• Created conceptual design and prepared documentation for data migration
• Created technical architecture and prepared technical documentation for data migration
• In SSIS using access database as a source migrated SharePoint based data into SQL Server destination.
• Developed Dynamic packages using SSIS and Implemented both Full and Incremental Data Loading
• Successfully implemented Incremental Data Loading even when there were no date columns in the source tables
• Performed data mapping and transferred data from staging tables to database tables using SSIS transformations.
• Loaded transformed data into dynamically named flat file destination
• Performed Unit testing, integration testing and assisted in user acceptance testing and created documentation for the same
• Deployed the SSIS Packages from development server to production server
• Provided Second Line support to the BAU Activities.
Environment: SQL Server 2008 R2 Enterprise / SQL Server 2012, SSIS/SSAS/SSRS, Report Builder 3.0, Report Designer, TOAD, SharePoint, Access database, Linked Server.
• Gathered business requirements, definition and design of the data source, data flows and data quality analysis, and worked in conjunction with the data warehouse architect on the development of logical data models.
• Producing and reviewing Data Policies and Business Processes surrounding the data for Data Governance Process.
• Producing Data Model and enhancing the Model (in next phase) to include other data using TOAD.
• Implemented the Master Child Package Model for easier maintenance and better performance.
• Working on a data migration project, performed analysis on existing data structures, planned steps for data migration and integration and performed the actual migration and integration
• Performed high-level analysis on a variety of database systems. Some of the systems are pure data stores, both SQL Server and otherwise, and others are proprietary systems with a Front End.
• Extracted and transformed data (ETL) from various heterogeneous sources and created packages using SSIS, Import and Export Data.
• Created conceptual design and prepared documentation for data migration
• Created technical architecture and prepared technical documentation for data migration
• In SSIS using access database as a source migrated SharePoint based data into SQL Server destination.
• Developed Dynamic packages using SSIS and Implemented both Full and Incremental Data Loading
• Successfully implemented Incremental Data Loading even when there were no date columns in the source tables
• Performed data mapping and transferred data from staging tables to database tables using SSIS transformations.
• Loaded transformed data into dynamically named flat file destination
• Performed Unit testing, integration testing and assisted in user acceptance testing and created documentation for the same
• Deployed the SSIS Packages from development server to production server
• Provided Second Line support to the BAU Activities.
Environment: SQL Server 2008 R2 Enterprise / SQL Server 2012, SSIS/SSAS/SSRS, Report Builder 3.0, Report Designer, TOAD, SharePoint, Access database, Linked Server.
Support, Sql server 2008, Pure Data, Processes, Sql server 2012, Enterprise, Production, Server, Technical documentation, Testing, Development, Analyst, SSAS, Data mapping, Design, Developer, SSRS, Data quality, Architecture, Ssis, Integration, SoMe, ETL, Data Warehouse, Database, SharePoint, SQL Server, Sql
2011 - 2012
freelance
SSIS/ETL Developer
Sanofi-Aventis.
Responsibilities:
• Involved in daily Scrum meetings and managing the user requirements in providing an efficient work plan.
• Involved in upgrading and migration from MS SQL Server 2005 to MS SQL Server 2008 and MS SQL Server 2008R2 to MS SQL Server 2012.
• Proposing the format/structure and frequency of sourcing the data to the internal model/repository.
• Migrated the Existing DTS packages to the SSIS Batch jobs and enhanced the packages with monitoring features so that audit information of the packages and their execution results are loaded in to the audit table.
• Involved in performance tuning and monitoring of T-SQL blocks.
• Developed Dynamic packages using SSIS and Implemented Incremental Data Loading
• Scheduled & Maintained ETL packages in terms of data validation and consistency.
• Created complex SSIS packages using proper control and data flow elements with error handling.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2008 using SSIS, BCP and Bulk Insert.
• Used Query Analyzer to optimize SQL Queries.
• Created Dimensions with the cube wizard and also individually.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Assisted in production of OLAP cubes, wrote queries to produce reports using SQL Server 2005/2008 Analysis Services (SSAS) and Reporting service (SSRS).
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2005 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Experience in using tools like index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
Environment: SQL Server 2008/2012 R2 Enterprise, SSIS/SSAS/SSRS, Data Import/Export Wizard, Report Builder 3.0, Report Designer, Oracle 11g, Performance Point Server 2007, MS Access, Visual Studio 2005, .NET 3.5
• Involved in daily Scrum meetings and managing the user requirements in providing an efficient work plan.
• Involved in upgrading and migration from MS SQL Server 2005 to MS SQL Server 2008 and MS SQL Server 2008R2 to MS SQL Server 2012.
• Proposing the format/structure and frequency of sourcing the data to the internal model/repository.
• Migrated the Existing DTS packages to the SSIS Batch jobs and enhanced the packages with monitoring features so that audit information of the packages and their execution results are loaded in to the audit table.
• Involved in performance tuning and monitoring of T-SQL blocks.
• Developed Dynamic packages using SSIS and Implemented Incremental Data Loading
• Scheduled & Maintained ETL packages in terms of data validation and consistency.
• Created complex SSIS packages using proper control and data flow elements with error handling.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2008 using SSIS, BCP and Bulk Insert.
• Used Query Analyzer to optimize SQL Queries.
• Created Dimensions with the cube wizard and also individually.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Assisted in production of OLAP cubes, wrote queries to produce reports using SQL Server 2005/2008 Analysis Services (SSAS) and Reporting service (SSRS).
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2005 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Experience in using tools like index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
Environment: SQL Server 2008/2012 R2 Enterprise, SSIS/SSAS/SSRS, Data Import/Export Wizard, Report Builder 3.0, Report Designer, Oracle 11g, Performance Point Server 2007, MS Access, Visual Studio 2005, .NET 3.5
Access, SSRS, Developer, SSAS, Monitoring, Backup, Server, Production, Net, Enterprise, OLAP, Tuning, Sql server 2012, Processes, Sql server 2008, Agent, SQL Server 2005, Integration, Excel, Scrum, SQL Server, Oracle, Audit, Database, ETL, Visual Studio, Sql, T-SQL, Stored procedures, Windows, Service, Sourcing, Ssis, Architecture
2011 - 2011
freelance
Cognos Consultant
CARDINAL HEALTH.
2008 - 2011
freelance
Cognos Consultant
Verizon, TX.
My education
2005
-
2006
Coventry University
Masters, Business Administration
Masters, Business Administration
2004
-
2005
Kristianstad University
Masters, Computer science
Masters, Computer science
2000
-
2004
JNTU University
Bachelors, Information technology
Bachelors, Information technology
Rama's reviews
Rama has not received any reviews on Worksome.
Contact Rama Gudepu
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Rama directly in Worksome.
38100+ qualified freelancers
are ready to help you
Tell us what you need help with
and get specific bids from skilled talent in Denmark