Summary
Overview
Work History
Education
Skills
Websites
Affiliations
Interests
Timeline
Generic

Suresh Pusuluri

Summary

Creative data engineer with extensive experience in high-value BI projects with data-driven, technology focused and proven success in previous fast paced environments. Enthusiastically seeking a senior data engineer position where I can leverage existing skills and continue to learn new ones.

Overview

17
17
years of professional experience

Work History

Lead Data Engineer

Standard Bank
Johannesburg
11.2018 - Current
  • Design and implement multiple Data pipelines with more than 50 data sources by extensive SQL scripting, ETL tools and scheduling tools.
  • Optimize store procedures in the ETL process so that they can transform and load 200 millions of log records into a 5 billion records data warehouse within 3 hours of a run cycle.
  • Clean data and extract large datasets with more than 500 attributes for customer insight analytics and predictive modeling.
  • Create an ETL framework for the ease of automation.
  • Lead code reviews, share knowledge and mentor junior resources.
  • Managed OLAP Cubes using SSAS and created different measures using DAX to perform analysis based on business requirements.
  • Processed and maintained the cubes on a schedule directly in SQL Agent through SSIS Analysis Services Process Task.
  • Contributed to internal activities for overall process improvements, efficiencies and innovation.
  • Work closely with quality assurance analyst and business analysts.

Business Intelligence Specialist and Data Analyst

Europcar
Johannesburg
05.2013 - 10.2018
  • Develop a BI solution for a car rental management system.
  • Data profiling and data wrangling in SQL for car rental Database solution with more than 20 sources, 15 millions records and hundreds of attributes.
  • Experience with data modelling and data architecture to support multiple internal initiatives.
  • Participated in requirements meetings and data mapping sessions to understand business needs.
  • Participated in designing Data Warehouse using Kimball Architecture and generated dimension tables and fact tables.
  • Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.
  • Deployed SSRS reports into a reporting server and implemented security measures at report server by implementing authentication and authorization methods.
  • Provided continued maintenance and development of bug fixes for the existing and new Power BI and SSRS Reports.
  • Assessed data and issues and directed concerns to business unit leadership when appropriate.
  • Collaborated well cross-functionally with data scientists, software engineers and business managers.

Database Developer

South African Breweries Ltd (SAB)
Johannesburg
08.2012 - 04.2013
  • Develop reusable scripts for data wrangling.
  • Consolidation and migration of SQL Servers (SQL 2000, 2005 and 2008).
  • Decommissioning of SQL Servers (SQL 2000, 2005 and 2008).
  • Downgrading and Upgrading SQL instances (SQL 2000, 2005 and 2008).
  • Capacity planning of SQL Servers.

SQL Developer and DBA

Conexus
Johannesburg
10.2010 - 07.2012
  • Production Infrastructure DBA Support-Responsible for administration of almost several instances comprising of several databases.
  • Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
  • Developed, deployed, and monitored SSIS Packages.
  • Using the Database Maintenance Wizard to make some necessary changes and keeping the performance of the server at acceptable levels.
  • Ensuring that all the databases are backed up on the regular basis by monitoring Full, Differential, and Transactional Log backups for OLTP, WAREHOUSE and Business Object Repositories.
  • Fix backup failures, address and implement resolutions.
  • Restoring databases as requested; Recover/Restore as necessary; troubleshoot databases with data consistency/torn page problems.
  • Involved in writing T-SQL Statements and Stored Procedures and Triggers.
  • Running of Performance monitor, SQL Profiler or Query Server to identify performance problems servers experiencing bottlenecks.
  • Optimize existing store procedures to reduce running time to less than 30 seconds from 5 minutes.

Microsoft SQL Server DBA

CMS Computers Ltd
Hyderabad
10.2006 - 09.2009
  • Planning, Designing and Creation of Production database.
  • Migrated data (Heterogeneous Migration) from oracle 8i to SQL Server 2005 using SSMA.
  • Ensuring that all databases are backed up on a regular basis by monitoring full, differential, transaction log backups for OLTP.
  • Design and creation of database backup solutions considering disk space consumption, data transfer latencies, scheduling, I/O performance.
  • Monitoring disk space utilization, sizing, and capacity planning. Adjusting database sizes and restricting maximum size appropriately.
  • Running of performance monitor, Sql profiler, or querying server to identify performance problems on servers experiencing bottlenecks.
  • Creation of database maintenance plans, rebuild/defrag indexes, integrity checks.
  • Creation of T-SQL scripts for full, differential, transaction log backups, optimizations, integrity checks on some instances that has special requirements beyond maintenance plans.
  • Configured Replication of Production database with Test and Reporting Servers.

Education

Master of Science - Computer And Information Sciences

Griffith College Dublin
Dublin,Ireland
09.2004

Bachelor of Science - Computer Applications

Kakatiya University
Warangal,India
09.2001

Skills

  • BI Reporting Tools: Power BI, Reporting Services (SSRS) and Excel
  • Analysis Services (SSAS)
  • ETL tools (SSIS, Informatica)
  • T-SQL, DAX, MDX
  • Data wrangling
  • Data warehouse design
  • Data Analysis
  • Data Governance
  • Database Development
  • Master Data Management (MDM)
  • Architecture Improvements
  • Python
  • Shell scripting
  • Understand both business and technical concepts
  • MS Azure, Data factory
  • Continuously learning in data solution technology
  • Complex problem solver
  • Fast learner
  • Patiently listen and speak up when needed
  • Work well independently and in teams
  • Focus on the tasks at hand

Affiliations

  • Data visualization: Power BI & Tableau
  • Knowledge of other programming languages: R, C#, JavaScript (React and Flux design)
  • Languages: fluent in English , Telugu (native)

Interests

Playing Cricket with my son and Traveling

Timeline

Lead Data Engineer

Standard Bank
11.2018 - Current

Business Intelligence Specialist and Data Analyst

Europcar
05.2013 - 10.2018

Database Developer

South African Breweries Ltd (SAB)
08.2012 - 04.2013

SQL Developer and DBA

Conexus
10.2010 - 07.2012

Microsoft SQL Server DBA

CMS Computers Ltd
10.2006 - 09.2009

Master of Science - Computer And Information Sciences

Griffith College Dublin

Bachelor of Science - Computer Applications

Kakatiya University

Similar Profiles

CREATE PROFILE
Suresh Pusuluri