Prashanth Madanu Email & Phone Number

Coventry, Gb

Greater London, England, United Kingdom

London Area, United Kingdom

➢ Designing & mapping the CRM data model, which sends out customer entities to the SalesForce cloud for the Customer Marketing & Campaign projects. ➢ Creating Data Feeds for Salesforce using SSIS Packages and T-SQL Procedures & Customers data Cleansing.➢ Design and implement a logical solution to Change Data Capture and generate incremental data feeds.➢ SQL Server Databases Migration into Snowflake cloud using dbt.➢ Reverse engineering of existing application to build a better solution for not-for-fit applications.➢ Integration of Nice-In-Contact API data using Python. ➢ SoLR (GREEN, PURE PLANET, GOTO, DALIGAS, COLORADO) Energy OFGEM data migration and integration into SERL. Data Analysis, Data Cleansing/Data Validation, Payments/Credits Analysis/Meter Reads validation/corrections.

London, United Kingdom

London, United Kingdom

➢ Re-factoring and re-designing the existing system, implementing the Best Practices, Code Documentation and Preparing the Flow of all processes.➢Creation of T-SQL Procedures, SQL Agent jobs for Extraction, Transformation, and Loading of data using SSIS 2012/2016 across multiple servers.➢ Monitoring and Documentation of all Business Processes, identifying the gaps, improvement areas and troubleshooting them.➢ Implementing email alerts for SQL Agent job failures, Quality Checks, Analysis of data, Data Validation, Bug fixing, Performance tuning of SQL queries & Reports rendering and database.➢ Maintenance and monitoring of OLAP Cubes using SSAS 2012/2016.➢ Creation of reports, subscriptions, troubleshooting and Bug Fixing of reports using SSRS 2012/2016.➢ Capturing all types of events during SSIS Package execution and logging into SQL Database for analysis and troubleshooting.

Warwick, Warwickshire

➢ Data Analysis, Data Cleansing & Migration, Data Investigation and Problem/Issue/Bug solving, Data Modeling, Normalization, Performance tuning of Database, stored procedures, functions & troubleshooting.➢ Extracting excel data into EDW and Creating T-SQL Procedures, to validate and apply business logic and scheduling the Stored procedures and packages using SQL Server Agent.➢ Creation of OLAP cubes for analysis and writing MDX queries to access cube's data. Adding Dimensions, Measures and KPIs, Implementing Cube Security based on User logins (GPs, Providers & CCGs).➢ Creation of Ad- Hoc reports, Drilldown, Drill through, Cascading Reports and Charts (Cylinder, Pie, Line and Scatter).➢ Analysis of data, Bug fixing, Performance tuning of SQL queries & Reports rendering and database.

London

• Business Analysis, Data Analysis, Data Investigation and Problem/Issue/Bug solving, Data Modeling, DB Tables re-design, Database Optimization, Performance tuning of Database, PL/SQL stored procedures, functions & troubleshooting.• Managing all activities of the software development life cycle starting from requirement gathering/ validation till Production Implementation in AGILE Environment.• Extracting EDW data to BQI Data model, to calculate Risk Adjusted Profit (RAP) and Loss (IBNR) for last 3 and 5 years.• Creation of ETL Procedures, Data Flow Packages to load the data from EDW into RDBMS database.• Identifying and validating the calculations against the business defined formulas and compare the results with LIVE data.• Performance tuning of SQL queries & Stored Procedure, Database Optimization, measuring the efficiency and performance of the system in order to handle large volumes of data i.e. more than 100 million records (3TB-5TB DW). • Liaising with the members of the team, business analysts, data analysts, and dashboard developers. And also interact with Business Users to understand their requirements and making sure that their requirements are met.

Singapore

➢ Acted as a module lead and member of a Consolidation team, responsible for requirement analysis, designing, preparation of system/technical specification and unit test plans (QA) and implementation.➢ Responsible for developing Reporting Website (Consolidation) using various technologies like ColdFusion,.NET, CSS3, HTML, jQuery..etc ➢ Involved in Data Modeling, DB Tables design, creation of database objects such as tables, indexes, triggers, views and creation of PL/SQL stored procedures and functions.➢ Performance tuning of SQL queries & procedural blocks and measuring the efficiency and performance of the system in order to handle huge no. of records. ➢ Developed Shell programs to load data into target tables by using SQL Loader.➢ Responsible for creating multiple reports Entity and Account based such as Matrix, Drill-down, Drill-through, Cross Tab Reports...etc.➢ Involved in performing incremental loads while transferring data into to database using different data flow and control flow tasks. ➢ Responsible for coordinating with QA team, handover, bug fixing and deploying in Testing, UAT and Production Environments.

➢ Acted as a member of a Development team, responsible for analyzing the business requirements and preparation of low-level design documents, unit test cases/plans and software implementation documents.➢ Reverse Engineering (Study of existing system and document the system flow) and suggest the improvements and new features.➢ Responsible for creating Financial Website for clients using various technologies like ColdFusion, CSS3, HTML, JavaScript..etc.➢ Identifying the workflow of the existing system and making efficient performance tunings.➢ SCM Website development using ColdFusion and re-factoring the existing system, bug fixing and enhancements➢ DB design and creation of DB objects such as tables, sequences, triggers…etc. and creation of PL SQL packages, functions and procedures.➢ Tuning SQL queries and packages in order to increase the performance related issues of the existing database packages & functions.➢ Writing the complex SQL blocks to accomplish the business logic.➢ Prepared Data Flow Diagrams for existing PL/SQL code➢ Providing Technical and Application Support.

Bengaluru Area, India

➢ Understanding the business requirements and preparation of technical documents such as high level, low level design documents and unit test plans➢ Developed database objects such as tables, views, sequences, procedures, functions and triggers ➢ Coding, Testing and Implementation.➢ Developed ColdFusion components to connect to payment gateways such as moneybookers, paypal, credit card...etc.➢ Prevent the site from SQL Injections and encrypt client data such as credit card details and other details➢ Created triggers for audit trials and SQL tuning for increasing the performance of the system➢ Developed ColdFusion components to connect to payment gateways such as moneybookers, paypal...etc.➢ Conversion of PHP pages to ColdFusion pages➢ Improved the site layout and prevented the site from SQL Injections.

Master Of Computer Applications - Mca, Computer Applications, 73%

Master of Computer Application

Bachelor Of Science, Mathematics And Computer Science, 80%