Somnath Merupula
Frisco,Texas
Summary
Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data.
Overview
5
5
years of professional experience
Work History
Data Analyst
Paycom
01.2022 - 09.2023
- Performed root-cause analysis on data-related system problems to recommend or execute corrective action
- Worked with business intelligence software and various reports to glean insights into trends and prospects.
- Created and automated data visualizations to present insights and tell compelling stories
- Analyzed large amounts of data to identify trends and find patterns, signals and hidden stories within data
- Assessed large datasets, drew valid inferences and prepared insights in narrative or visual forms
Research Assistant
University of North Texas
08.2020 - 12.2021
- Evaluated client requirements and content standards for each phase of product development to produce quality creative structure
- Designed custom mapping applications using Adobe Creative Suite – predominantly Illustrator and InDesign
- Conducted meticulous research to identify information and answer multifaceted questions on urban sustainability management
- Summarized search results by preparing written reports and graphs later used at community town hall meeting.
Business Analyst
Techno Soft Solutions
01.2019 - 12.2019
- Performed several ad-hoc analyses to support business needs and presented it to discrete business units
- Prepared project documentation at all stages of implementation as part of knowledge transfer and listed simple steps for users to refresh and updated Excel tools
- Published and monitored multiple daily visualizations and assisted in continuous development as per customer needs
- Helped manage Global Leadership online platform and cultivate network of environmentalists
- Developed strong professional relationships by communicating effectively with wide variety of colleagues and external contacts.
IT Intern
DRDO
05.2018 - 10.2018
- Worked alongside with senior scientist in ongoing project
- Designed UML diagrams/models, Activity diagrams with Microsoft Visio and Lucid chart for better understanding.
- Supported IT department in handling technology rollout and maintenance.
Education
MS - Information Science
University of North Texas
Denton, TX2021
BS - Computer Science
JNTUH
India2019
Skills
- HTML, CSS, JavaScript, Python
- Data Analysis Tools: Excel, Python, Tableau, JSON, SQL, MySQL, , MongoDB, PostgreSQL
- Data analysis and visualization, communications
- Analyzing and Synthesizing Data
- Oracle Toad
- Advanced Excel Spreadsheet Functions
- Extraction Transformation and Loading (ETL)
- Business Requirements
Accomplishments
- Building ETL pipeline for twitter API data using airflow on AWS
- Employment Orientation System
Timeline
Data Analyst
Paycom
01.2022 - 09.2023
Research Assistant
University of North Texas
08.2020 - 12.2021
Business Analyst
Techno Soft Solutions
01.2019 - 12.2019
IT Intern
DRDO
05.2018 - 10.2018
MS - Information Science
University of North Texas
BS - Computer Science
JNTUH
Similar Profiles
Veselin VankovVeselin Vankov
Software Development Team Leader at PaycomSoftware Development Team Leader at Paycom
Stacia R. JohnsonStacia R. Johnson
EDI Production Specialist at PaycomEDI Production Specialist at Paycom
Jose EsparzaJose Esparza
Software Development QA II at PaycomSoftware Development QA II at Paycom
Albany AshtonAlbany Ashton
Software Development QA - II at PaycomSoftware Development QA - II at Paycom
JENNIFER MONTOYAJENNIFER MONTOYA
Sales Representative at T-MobileSales Representative at T-Mobile