With over 4 years of robust experience in IT, I specialize as a Data Analyst with a focus on developing and implementing Data Warehouse solutions. My expertise spans the entire spectrum of the Software Development Life Cycle (SDLC), from initial analysis and design through to testing, implementation, and ongoing maintenance.I am proficient in Microsoft Business Intelligence technologies such as SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS), leveraging them to design and optimize ETL processes and generate insightful reports. My skills include dimensional data modeling, encompassing both star schema and snowflake schema methodologies, and I am adept at creating and refining data models across conceptual, logical, and physical levels.I have a proven track record in database development and optimization, using T-SQL and PL/SQL to craft complex queries, stored procedures, triggers, and functions for ensuring data integrity and performance. Additionally, I excel in data analysis, transformation, and loading through various ETL tools including SSIS, Informatica, and others.My experience extends to utilizing BI tools like Tableau and Power BI for data visualization and dashboard creation, as well as implementing forecasting models and capacity planning strategies. I have also demonstrated proficiency in utilizing advanced analytics tools such as R and Python for text analytics and generating data visualizations.Throughout my career, I have effectively collaborated with cross-functional teams to deliver optimal business solutions aligned with corporate objectives. My strong analytical skills, coupled with excellent communication and interpersonal abilities, have enabled me to excel in both technical and managerial roles.I am passionate about leveraging technology to drive business insights and operational efficiencies, and I am committed to continuous learning and innovation within the field of data analytics and business intelligence.
-
Devops EngineerCox Automotive Inc.Atlanta, Ga, Us -
Data AnalystArhaus Aug 2022 - PresentIrving, Texas, United States• Implemented agile Scrum methodology to enhance software development processes, fostering rapid solution delivery. Collaborated closely with clients to address issues promptly within agile frameworks. • Resolved complex issues and unforeseen challenges to enhance decision-making within a dynamic business environment by establishing experimental data model designs. • Crafted a roadmap for replicating transactional databases into a Data Lake. • Designed and implemented schemas for data warehouses and data marts in SQL Server, utilizing • Visio, ER Studio, and T-SQL for script development. • Collaborated closely with business users to develop T-SQL scripts for constructing physical data marts, implementing stored procedures for data refresh pipelines, and generating SSRS reports from Data Marts. • Used agile scrum methodology and strategies for software development and to provide quick and feasible solutions. • Created reports and dashboards, by using Tableau to explain and communicate data insights, significant features, model scores, and performance of the new recommendation system to both technical and business teams. • Designed and created data visualizations in Tableau, incorporating cross tabs, heat maps, box and whisker charts, scatter plots, geographic maps, pie charts, and bar charts, as well as density charts. • Proficient in advanced analysis techniques including actions, calculations, parameters, background images, maps, trend lines, statistics, and table calculations. • Built Tableau visualizations against various Data Sources like Flat Files (Excel, Access) and Relational Databases (Teradata, Oracle, SQL Server). • Designed and developed graphical and visualization solutions in Power BI, aligning with business requirements and creating interactive dashboards. •Leveraged Power Query in Power BI to pivot and unpivot data models for data cleansing and massaging.
Sravan Kumar Education Details
-
Auburn UniversityComputer Science
Frequently Asked Questions about Sravan Kumar
What company does Sravan Kumar work for?
Sravan Kumar works for Cox Automotive Inc.
What is Sravan Kumar's role at the current company?
Sravan Kumar's current role is DevOps Engineer.
What schools did Sravan Kumar attend?
Sravan Kumar attended Auburn University.
Who are Sravan Kumar's colleagues?
Sravan Kumar's colleagues are Chaunte Johnson, Jake P., Shawn Washington, Pa Dao Khang, William Rodgers Jr., Michael Evans, Kristi D..
Not the Sravan Kumar you were looking for?
-
Sravan Kumar
Lawrence, Ks1rtx.com -
Sravan Kumar
Troy, Mi2htcinc.com, live.com -
Sravan Kumar
Houston, Tx1jpmchase.com -
Sravan Kumar
Dallas-Fort Worth Metroplex1tr.com -
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial