Home

Sumanth K - Business Intelligence Developer/Data Analyst

[email protected]

Location: New York City, New York, USA

Relocation:

Visa:

Resume file: Sumanth Kothapalli Resume_1782133396062.doc Please check the file(s) for viruses. Files are checked manually and then made available for download.

Professional Summary Over 7 years of strong experience in data engineering, data analysis, data mining with large data sets of structured and unstructured data, data acquisition, data validation, data modeling, data warehousing and data visualizations. Adept in statistical programming languages like R and Python, Apache Spark. Good knowledge of distributed data processing. Experienced on data architecture including data ingestion pipeline design, data extractions, data transformations, data modeling, data mining, machine learning and advanced data processing. Experience in developing complex ETL tasks and pipelines for data updates, data cleansing, data migration and data warehousing. Experience in SQL to extract data from a variety of operational data sources on multiple platforms and build a data warehouse and data marts that integrate the extracted data for cross-functional analytics and reporting requirements. Experience in designing the data conversion strategy, development of data mappings and the design of Extraction, Transformation and Load (ETL) routines for migrating data from non-relational or source relational to target relational. Strong experience in design and development of Business Intelligence solutions using data modeling, dimension modeling, ETL processes, data integration, OLAP and OLTP. Experienced in Azure Cloud services like Azure Data Lake Store, Azure Data Factory, Azure Synapse Analytics and Microsoft Fabric for deploying data architecture, ETL pipelines and dataflows. Excellent knowledge of Amazon Web Services (AWS) products like S3, Glue, Athena, EC2, EMR, Aurora, Redshift, RDS. Experience with Snowflake Multi-cluster Warehouses, Snowflake Virtual Warehouses and building Snowpipe. Hands on experience with Azure Data Factory & AWS Glue, monitoring datasets, developing activities, dataflows and ETL pipelines, and performing data transformations in ADF & Glue. Worked extensively with dimensional modeling, data migration, data cleansing and data profiling for data warehouses. Experienced in Dimensional Data Modeling experience using data modeling, relational data modeling, star schema/snowflake schema modeling, fact & dimension tables, conceptual, physical & logical data modeling. Hands on experience in formatting and ETL raw data in various formats such as CSV, JSON, Parquet, XML etc. Extensive experience working with Business Intelligence data visualization tools with specialization on Power BI (Power BI Desktop, Power BI Service) and Tableau (Tableau Desktop, Tableau Server). Strong experience and knowledge in data visualizations creating line and scatter plots, bar Charts, histograms, pie & donut charts, box plots, time series, multiple chart types, tables, matrices and drill-down charts. Strong DAX programming background for creating report measures and columns supporting the reporting functions. Excellent knowledge of machine learning, statistical modeling and data science life cycle. Experienced in using Python libraries like numpy, pandas, scikit-learn for data analysis, data profiling, and model building. Deep analytics and understanding of Big Data and algorithms using Hadoop, MapReduce, Spark and distributed computing tools. Expertise in managing entire data science project life cycle and actively involved in all the phases of project life cycle including data acquisition, data cleaning, data engineering, features scaling, features engineering, statistical modeling (decision trees, regression models, clustering, classification, ensemble models), dimensionality reduction using Principal Component Analysis. Experienced with MSBI services like Integration Service (SSIS), Reporting Service (SSRS) and Analysis Services (SSAS). Well-versed in version control and CI-CD tools such as Git, Gitlab, SourceTree etc. Experience in all stages of SDLC (Agile, Waterfall), writing Technical Design document, Development, Testing and Implementation of Enterprise level Data mart and Data warehouses. Expertise in COTS software like Salesforce CRM, Hexagon EAM, SAP EAM and deploying them to migrate processes to Enterprise systems. Keywords: continuous integration continuous deployment business intelligence sthree rlang