$$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Expert
{{ $t($store.state.user.experience_search_name) }}
0
jobs
Solution Architect
Pradeep Basetti
,
Luton, United Kingdom
Experience
Other titles
Skills
I'm offering
I am a successful End to End solutions architect with over 22 years of IT experience in Systems/Database Development, Integrations, application development using a wide range of technologies.
I am a software product designer with good business acumen and very strong in Architecting Databases solutions.
I am a software product designer with good business acumen and very strong in Architecting Databases solutions.
Markets
United Kingdom
Industries
Language
English
Fluently
Ready for
Larger project
Ongoing relation / part-time
Full time contractor
My experience
2018 - ?
job
Solution/Data Architect
Argo Global.
• End-to-End Solution Architect for the design (Data Modelling), development and implementation of the Reinsurance\Actuarial Allocation Engines using ASP.NET (MVC) and SQL Server BI stack (SSIS, SSRS and SSAS).
• Architected the solution and developed integration process between AWS Data Lake and SQL Server database.
• Architected and developed the Integration Systems for Sequel Claims into the data warehouse and between AWS Data Lake and Oracle/Inspire systems.
• Architected the solution and developed integration process between AWS Data Lake and SQL Server database.
• Architected and developed the Integration Systems for Sequel Claims into the data warehouse and between AWS Data Lake and Oracle/Inspire systems.
MVC, Server, BEE, Development, SSAS, Net, Implementation, SSRS, Ssis, Integration, Design, ASP, Data Warehouse, Database, ASP.NET, SQL Server, Oracle, AWS, .Net, Sql
2013 - 2014
job
Data Warehouse Architect
Travelers Management Ltd.
• Key roles in Architecting ETL (SSIS), stakeholder management, review Data Warehouse Architecture, development, Performance Tuning, Automation and Reconciliation processes.
• Developed and automated ETL processes, reports for Actuaries, Finance and Marine departments.
• Performed data analysis, data mapping on OpenBox Plus/OpenCo Plus/Open Exposure systems to set up data feeds into Data Warehouse.
• Carried out data analysis to develop data reconciliation processes between operational systems and the data warehouse.
• Converted DTS to SSIS packages on the Data Warehouse.
• Liaised with business stakeholders to gather business requirements to develop processes for MIS reporting on the data warehouse.
• Achieved 1700% performance efficiency on slow running and crucial automated processes/SQL Jobs by redesign and tuning the T-SQL code with best practices. Eg: 7.5 hours processes have been tuned to run in a range of 3 - 14 minutes.
• Developed and automated ETL processes, reports for Actuaries, Finance and Marine departments.
• Performed data analysis, data mapping on OpenBox Plus/OpenCo Plus/Open Exposure systems to set up data feeds into Data Warehouse.
• Carried out data analysis to develop data reconciliation processes between operational systems and the data warehouse.
• Converted DTS to SSIS packages on the Data Warehouse.
• Liaised with business stakeholders to gather business requirements to develop processes for MIS reporting on the data warehouse.
• Achieved 1700% performance efficiency on slow running and crucial automated processes/SQL Jobs by redesign and tuning the T-SQL code with best practices. Eg: 7.5 hours processes have been tuned to run in a range of 3 - 14 minutes.
T-SQL, UP, Processes, Tuning, Redesign, Development, Data mapping, Ssis, Architecture, Sql, Finance, Management, Data Warehouse, Automation, ETL, Stakeholder Management, Data Analysis
2012 - 2012
freelance
SQL Server Consultant
AlixPartners.
• Key roles in Development, production support and delivery of financial products.
• Performed System integration using ASP/VB .NET, VBA, SSIS.
• Developed processes to validate the business rules for quality checks.
• Provided technical support to batch processes using SQL Server 2008 R2.
• Performed code, database review and performance tuned the T-SQL processes and databases.
• Performed System integration using ASP/VB .NET, VBA, SSIS.
• Developed processes to validate the business rules for quality checks.
• Provided technical support to batch processes using SQL Server 2008 R2.
• Performed code, database review and performance tuned the T-SQL processes and databases.
Ssis, Sql server 2008, Processes, Vb, Production, Server, Development, Support, Net, Sql, Integration, T-SQL, System Integration, ASP, Database, VBA, SQL Server
2011 - 2012
job
Data Warehouse Architect
Aegis London.
• Key roles in data migration, data analysis, data marts development and data integration (SSIS) into the Data Warehouse.
• Developed procedures and data reconciliation processes on the data warehouse to support the data migration from OpenBox data to OpenBoxPlus system.
• Developed and implemented cubes/MIS reports using SSAS/SSRS.
• Developed data reconciliation procedures and schema comparison processes.
• Managed data migration and metadata (Data Dictionaries).
• Performed data analysis of financial data.
• Automated data feeds and reports using SSIS/MS-Access and SQL Server databases for Re-Insurance and Actuaries.
• Performed Business requirements gathering and analysis. Investigated, identify and fixed data issues.
• Produced Technical and Functional documentation on processes.
• Developed and implemented cubes/reports using SSAS/SSRS.
• Developed procedures and data reconciliation processes on the data warehouse to support the data migration from OpenBox data to OpenBoxPlus system.
• Developed and implemented cubes/MIS reports using SSAS/SSRS.
• Developed data reconciliation procedures and schema comparison processes.
• Managed data migration and metadata (Data Dictionaries).
• Performed data analysis of financial data.
• Automated data feeds and reports using SSIS/MS-Access and SQL Server databases for Re-Insurance and Actuaries.
• Performed Business requirements gathering and analysis. Investigated, identify and fixed data issues.
• Produced Technical and Functional documentation on processes.
• Developed and implemented cubes/reports using SSAS/SSRS.
Sql, Data Analysis, SQL Server, Data Warehouse, Integration, Ssis, SSRS, Support, Insurance, SSAS, Development, Server, Processes
2011 - 2011
job
Data Architect
Lloyds TSB Bank PLC.
• Key roles in architecting the highly scalable OLTP System (SDLC, Audit trail) for Credit Risk department.
• Developed ETL (SSIS, DTS)/ processes into Data Warehouse for MIS reporting.
• Performed Data Modelling/Analysis, Mapping & Data Migrations from Heterogeneous (SQL Server, Oracle, MS-Excel) data sources.
• Implemented centralised reporting database using SSIS.
• Developed Process/Data Flow Diagrams.
• Developed ETL (SSIS, DTS)/ processes into Data Warehouse for MIS reporting.
• Performed Data Modelling/Analysis, Mapping & Data Migrations from Heterogeneous (SQL Server, Oracle, MS-Excel) data sources.
• Implemented centralised reporting database using SSIS.
• Developed Process/Data Flow Diagrams.
Excel, Sql, Oracle, SQL Server, Audit, ETL, Database, Data Warehouse, Ssis, Server, Audit, Processes
2009 - 2010
job
Data Architect
Ofgem.
• Key roles in Architecting, Data Modelling and Implementation of OLTP and MDM (Master Data Management) databases using SQL Server 2008.
• Developed Entity Relationship (ERD) and process flow Diagrams for the databases.
• Develop data access components (CRUD) and utility web applications (ASP .NET) using C#.
• Designed, Developed and Implemented ETL processes using SSIS.
• Implemented audit trail using triggers on tables and databases.
• Created Data Dictionaries and relevant Meta data (Data Dictionaries) Reports for databases.
• Carried out unit/stress testing of the designed databases.
• Developed Entity Relationship (ERD) and process flow Diagrams for the databases.
• Develop data access components (CRUD) and utility web applications (ASP .NET) using C#.
• Designed, Developed and Implemented ETL processes using SSIS.
• Implemented audit trail using triggers on tables and databases.
• Created Data Dictionaries and relevant Meta data (Data Dictionaries) Reports for databases.
• Carried out unit/stress testing of the designed databases.
Ssis, Sql server 2008, Processes, Audit, Server, Web, Testing, Net, Implementation, Sql, Master Data Management, Management, ASP, C, ETL, Data management, Audit, SQL Server
2007 - 2008
job
SQL Server Developer
Fair Isaac.
• Key roles in Systems Integration (XML) of Debt Management and heterogeneous host system(s).
• Designed, Developed and Implemented ETL processes using DTS.
• Developed Dynamic T-SQL processes to automate business rules.
• Performed performance tuning and unit test of the SQL processes.
• Developed documents for Quality Assurance and database migration (SQL Server 2005).
• Designed, Developed and Implemented ETL processes using DTS.
• Developed Dynamic T-SQL processes to automate business rules.
• Performed performance tuning and unit test of the SQL processes.
• Developed documents for Quality Assurance and database migration (SQL Server 2005).
Sql, SQL Server, XML, ETL, Database, Management, Unit test, T-SQL, Integration, Test, Quality Assurance, Developer, Server, Tuning, Processes, SQL Server 2005
2007 - 2007
job
Senior Database Developer
MRM Worldwide Ltd.
• Key roles in Database Design (Data Modelling), development and implementation.
• Propose and implement technical solutions on VLDB (Very Large Databases, Terabyte(s) size) of SQL Server.
• Handle Change Requests via Workflow Management System.
• Provide support for web applications (ASP.NET).
• Performance tuned multi-million row tables on Terabyte databases related to Marketing.
• Developed ETL processes for data extracts using DTS, SSIS.
• Developed Dynamic T-SQL processes to automate business rules for mid month mailing extracts.
• Developed reports and produced high level technical documentation for with risk and impact assessment.
• Propose and implement technical solutions on VLDB (Very Large Databases, Terabyte(s) size) of SQL Server.
• Handle Change Requests via Workflow Management System.
• Provide support for web applications (ASP.NET).
• Performance tuned multi-million row tables on Terabyte databases related to Marketing.
• Developed ETL processes for data extracts using DTS, SSIS.
• Developed Dynamic T-SQL processes to automate business rules for mid month mailing extracts.
• Developed reports and produced high level technical documentation for with risk and impact assessment.
Workflow, Processes, Server, Web, Development, Assessment, Technical documentation, Support, Developer, Net, Implementation, Ssis, Marketing, T-SQL, Management, Database design, ASP, Database, ETL, ASP.NET, SQL Server, .Net, Sql, Design
2005 - 2007
job
Solution Architect
Virgin Media Ltd.
• Key roles in Solution Architecture, (SDLC) System Design, development, SQL Server Database Design/Administration and implementation of OLTP intranet applications for Front office teams (Churn, High Toll and Work List System).
• Performed System Analysis and data modelling for highly flexible and scalable OLTP databases.
• Developed ETL (using DTS, WSC) process for data extracts and imports into SQL Server Data Warehouse from Heterogeneous (Oracle, DB2, Text Files).
• Developed reports using Reporting Services (SSRS).
• Performance tuned the OLTP applications, SQL Server databases.
• Implemented backup and recovery procedures.
• Developed text search rules (T-SQL) for address data match and data mapping purposes.
• Carried out trend analysis/data mining on credit search/score data to data observe patterns.
• Implemented efficient techniques using T-SQL, Dynamic SQL for fast search, paging and lookup on multi-million row tables.
• Improved process efficiency worth £1.6 million (per year) by implementing robust systems and processes.
• Developed Architecture documents for deploying SQL Servers for Data Warehouse and OLTP Applications.
• Defined object naming conventions.
• Defined Archiving process for historic data.
• Experience with business requirements analysis, entity relationship planning, database design, reporting structures
• Implemented audit trail logging using Triggers.
• Performed System Analysis and data modelling for highly flexible and scalable OLTP databases.
• Developed ETL (using DTS, WSC) process for data extracts and imports into SQL Server Data Warehouse from Heterogeneous (Oracle, DB2, Text Files).
• Developed reports using Reporting Services (SSRS).
• Performance tuned the OLTP applications, SQL Server databases.
• Implemented backup and recovery procedures.
• Developed text search rules (T-SQL) for address data match and data mapping purposes.
• Carried out trend analysis/data mining on credit search/score data to data observe patterns.
• Implemented efficient techniques using T-SQL, Dynamic SQL for fast search, paging and lookup on multi-million row tables.
• Improved process efficiency worth £1.6 million (per year) by implementing robust systems and processes.
• Developed Architecture documents for deploying SQL Servers for Data Warehouse and OLTP Applications.
• Defined object naming conventions.
• Defined Archiving process for historic data.
• Experience with business requirements analysis, entity relationship planning, database design, reporting structures
• Implemented audit trail logging using Triggers.
Architecture, Processes, Naming, Audit, Search, Server, Patterns, Office, Backup, Development, System Design, Implementation, SSRS, Data mapping, Design, T-SQL, Database design, DB2, Solution architecture, Data Warehouse, Database, ETL, Audit, Data mining, SQL Server, Oracle, Administration, Sql
2004 - 2005
job
Data Architect/DBA
Mendip District Council.
• Primary roles in Data Modelling, database development, administration and web development.
• Design of Operational Data Stores out of heterogeneous databases like Oracle RDBMS, SQL Server, MS-Access and Paradox. Performed ETL (Extract, Transform and Load) using DTS
• Performed Data cleansing, mapping and integration into a central repository.
• Project Managed, Developed and Implemented an innovative web based system for managing the Collection Services (Refuse, Garden Waste, Food waste and Kerbside Recycling).
• Development of intranet applications (using SDLC) for administrative and Front office applications on a strict deadline to meet the demands of new e-Government requirements.
• Developed database tracking of editing processes on Land Gazetteer databases.
• Performance tuned SQL Server Databases using SQL Profiler, Query execution plan and Indexing.
• Deployed and configured web applications using IIS.
• Extensive Database design and performance tuning of T-SQL queries, SQL Server databases and ASP web pages.
• Developed Reports using (Crystal Reports) and Analysis Services (OLAP).
• Reduced licence costs and improved process efficiency by implementing web based systems.
• Developed processes and provided active technical support to the CRM (Northgate).
• Implemented Snapshot replication.
• Design of Operational Data Stores out of heterogeneous databases like Oracle RDBMS, SQL Server, MS-Access and Paradox. Performed ETL (Extract, Transform and Load) using DTS
• Performed Data cleansing, mapping and integration into a central repository.
• Project Managed, Developed and Implemented an innovative web based system for managing the Collection Services (Refuse, Garden Waste, Food waste and Kerbside Recycling).
• Development of intranet applications (using SDLC) for administrative and Front office applications on a strict deadline to meet the demands of new e-Government requirements.
• Developed database tracking of editing processes on Land Gazetteer databases.
• Performance tuned SQL Server Databases using SQL Profiler, Query execution plan and Indexing.
• Deployed and configured web applications using IIS.
• Extensive Database design and performance tuning of T-SQL queries, SQL Server databases and ASP web pages.
• Developed Reports using (Crystal Reports) and Analysis Services (OLAP).
• Reduced licence costs and improved process efficiency by implementing web based systems.
• Developed processes and provided active technical support to the CRM (Northgate).
• Implemented Snapshot replication.
T-SQL, Processes, Tuning, OLAP, Server, Web, Office, Development, Support, IIS, Integration, Design, Database design, ASP, Database, ETL, SQL Server, Oracle, CRM, Administration, Sql
2003 - 2004
job
Senior Developer / Project Manager
Sunmac (UK) Ltd.
• Application Design, Database Design and Administration, Programming and project management/proposals are the key responsibilities.
• Designed, developed and successfully implemented COM (N-Tier) based client-server applications, heterogeneous- database compatible applications.
• Managed teams (team size: 12), client-server and E-Commerce projects.
• Developed VBA applications for word and excel.
• Worked on POS system development, application integration and barcode scanner integration.
• Developed reports (Crystal Reports) on Database schema for SQL Server.
• Provided extensive support for SQL Server 2000 database administration and troubleshooting.
• All development was carried out with PHP, VB, ASP, Java, MySQL, SQL Server, Oracle, MS-Access, and VSS.
• Designed, developed and successfully implemented COM (N-Tier) based client-server applications, heterogeneous- database compatible applications.
• Managed teams (team size: 12), client-server and E-Commerce projects.
• Developed VBA applications for word and excel.
• Worked on POS system development, application integration and barcode scanner integration.
• Developed reports (Crystal Reports) on Database schema for SQL Server.
• Provided extensive support for SQL Server 2000 database administration and troubleshooting.
• All development was carried out with PHP, VB, ASP, Java, MySQL, SQL Server, Oracle, MS-Access, and VSS.
ASP, Manager, Vb, Server, Senior Developer, Development, Support, Developer, Pos, Integration, Management, Database design, Database administration, Word, Design, Database, E-commerce, VBA, SQL Server, Oracle, Administration, Project Manager, Java, Sql, Excel, Mysql, Php
2002 - 2003
job
Data Architect / SQL Server DBA
Kensington College of Business.
• Designed the workflow for the application.
• Designed the database, wrote stored procedures, UDF's and Transact SQL (T-SQL) code.
• Administered, migrated the database server, using SQL Server 2000.
• Actively provided database support for SQL Server.
• Reports were created in Crystal Reports/Business Objects using Visual Basic and ADO.
• Implemented the client-server application for Student management system.
• Designed the database, wrote stored procedures, UDF's and Transact SQL (T-SQL) code.
• Administered, migrated the database server, using SQL Server 2000.
• Actively provided database support for SQL Server.
• Reports were created in Crystal Reports/Business Objects using Visual Basic and ADO.
• Implemented the client-server application for Student management system.
Sql, SQL Server, Database, Management, Stored procedures, T-SQL, Workflow, Support, Server, Database server, Basic
2002 - 2002
job
Senior IT Engineer
Auto Crash Repairs.
• Design, developed and implemented applications for in-house purpose for managing and tracking courtesy cars and Indemnities.
• Provided Network and PC support.
• Implemented reports.
• All development was carried out with Visual Basic, ADO, MS-Access, ASP, and Visual Interdev.
• Provided Network and PC support.
• Implemented reports.
• All development was carried out with Visual Basic, ADO, MS-Access, ASP, and Visual Interdev.
Design, ASP, Network, It, Support, Development, PC, Basic
2000 - 2002
job
IT Engineer
BeXcom South East Asia Pte Ltd.
• I was responsible for the programming, database design, database administration, project integration and administration of the projects.
• Lead development teams of sizes ranging from 3-5.
• Designed the test cases, development log files for recording changes in the modules, bug list tracking, and involved in customer support. Developed reports using Crystal Reports.
• Actively involved in troubleshooting, performance tuning of the applications and databases.
• Was involved in development of Intranet/Internet, B2B, D2D, e-factoring, e-procurement portals.
• Involved in development of a transaction engine called BeXengine using Object Oriented technologies.
• All the N-Tier development was carried out using JSP 2.0, Java Beans, JavaScript, Oracle 8i, and Web Logic, VSS 5.0, ASP 2.0, SQL Server 7.0, IIS 4.0, Delphi 3.0 and VC++ for COM objects.
• Lead development teams of sizes ranging from 3-5.
• Designed the test cases, development log files for recording changes in the modules, bug list tracking, and involved in customer support. Developed reports using Crystal Reports.
• Actively involved in troubleshooting, performance tuning of the applications and databases.
• Was involved in development of Intranet/Internet, B2B, D2D, e-factoring, e-procurement portals.
• Involved in development of a transaction engine called BeXengine using Object Oriented technologies.
• All the N-Tier development was carried out using JSP 2.0, Java Beans, JavaScript, Oracle 8i, and Web Logic, VSS 5.0, ASP 2.0, SQL Server 7.0, IIS 4.0, Delphi 3.0 and VC++ for COM objects.
Integration, Tuning, Logic, Server, Web, Internet, Development, Support, Test cases, It, IIS, Delphi, Test, Jsp, Javascript, Database design, Database administration, ASP, Database, Procurement, SQL Server, Oracle, B2B, Administration, Java, Sql, Design
1999 - 2000
job
Software Engineer / Implementation Leader
Citadel Health Ltd.
• Worked as Analyst, Programmer/ web developer, Team Leader and involved in testing.
• Worked as Project Implementation In-charge, Head Office Implementation Co-ordinator.
• Actively involved in user training, requirement collection, SRS preparation, and product demonstration to the clients.
• Successfully carried out the implementation/integration of HIS ERP product.
• Development work was carried out using Visual Basic 5.0/6.0, ASP 2.0, JavaScript, SQL Server 6.5/7.0, IIS 4.0, Crystal Reports, and Printer object reports.
• Worked as Project Implementation In-charge, Head Office Implementation Co-ordinator.
• Actively involved in user training, requirement collection, SRS preparation, and product demonstration to the clients.
• Successfully carried out the implementation/integration of HIS ERP product.
• Development work was carried out using Visual Basic 5.0/6.0, ASP 2.0, JavaScript, SQL Server 6.5/7.0, IIS 4.0, Crystal Reports, and Printer object reports.
Developer, Basic, Server, Web, Software, Office, Development, Testing, Analyst, Javascript, Implementation, IIS, Integration, ASP, Training, ERP, SQL Server, Sql
1998 - 1999
job
Developer
Ebenezer Software Solutions (Pvt) Ltd.
• I was responsible for programming and testing.
• Developed the Client-Server applications using Visual Basic 5.0, Oracle 7.x, and SQL Server 6.5.
• Projects worked on are Super Market Management, Financial Accounting System, Materials Management
• Developed the Client-Server applications using Visual Basic 5.0, Oracle 7.x, and SQL Server 6.5.
• Projects worked on are Super Market Management, Financial Accounting System, Materials Management
Sql, Oracle, SQL Server, Management, Developer, Testing, Server, Basic
1995 - 1996
internship
Management Trainee
JVR Fine Chemie Ltd.
India.
Management
Pradeep's reviews
Pradeep has not received any reviews on Worksome.
Contact Pradeep Basetti
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Pradeep 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