Home

RAMA SAI DANDAMUDI - Data Engineer

[email protected]

Location: New York, New York, USA

Relocation:

Visa: F1 OPT EAD

Brentwood, NY 11717 RAMA SAI DANDAMUDI www.linkedin.com/in/rama-sai-dandamudi-070282164 SUMMARY [email protected](+1) 929-595-3099 Strategic Data Analyst with a robust skill set in data analysis and visualization using Python, SQL, Tableau, and Power BI. Proven ability to convert complex datasets into actionable insights, fostering informed decision-making. A collaborative communicator with a commitment to continuous learning and staying at the forefront of data analytics trends Experience in transforming raw and complex data into rich and compelling analysis using an extensive set of data manipulation and enrichment tools such as Tableau, SQL, MS Excel, Python Proficient in Software Development Life Cycle (SDLC), Project Management methodologies, and Microsoft SQL Server database management. Exposed to all phases of SDLC and have in-depth knowledge of agile methodology, Enterprise Reporting Life Cycle, Problem management, and escalation procedures Designed and developed a ServiceNow reporting dashboard, resulting in a 25% increase in data visibility and improved decision-making processes Monitored and optimized ServiceNow performance, resulting in a 20% increase in system speed and improved user satisfaction scores Developed and maintained ServiceNow security policies and procedures, ensuring compliance with industry standards and best practices Good work experience in writing SQL queries with major Relational Databases Very strong in developing applications using HTML5, HTML, CSS3, XML, DOM Manipulation, javaScript, Jquery Experience in Core Java, Servlets, JSP, JavaScript, CSS, HTML, JDBC technologies Experience in Text mining, topic modeling, Natural Language Processing, content classification, sentiment analysis, recommendation systems, entity recognition, etc Experience as a Snowflake DBA responsible for on boarding the users onto snowflake, creating and managing storage integrations, DB objects, stages(Internal, External), file formats(JSON, CSV, TSV) Experience in Migrating SQL database to Azure DataLake, Azure data lake Analytics, Azure SQL Database, Data Bricks, and Azure SQL Data Warehouse and Controlling and granting database access and migrating on-premises databases to Azure DataLake store using Azure Data Factory Strong in Business Intelligence solutions in Data warehousing / Decision Support Systems using ETL tools Informatica, OLAP, OLTP, and Data Warehouse Reports using Business Objects, and Crystal Reports Experience in designing star schema (identification of facts, measures, and dimensions), Snowflake schema for Data Warehouse, and ODS architecture by using tools like Erwin data modeler, and E-R Studio Experience in Machine Learning, Data Mining with large datasets of Structured and Unstructured data, Data Acquisition, Data Validation, and Predictive modeling Experience in Data transformation, Data mapping from source to a target database schema, and Data Cleansing procedures also Adept in programming languages like Python including Big Data technologies like Hadoop, and Hive. LANGUAGES & TECHNOLOGIES SKILLS Programming Languages- Python, Java, C, Verilog, C++(basic), Embedded C(basic), SQL Operating System- Windows, Android, IOS, Linux Web Technologies- HTML, CSS, Java Script, Mainframe (COBOL, JCL, VSAM) Database- MySQL, DB2, MongoDB, PostgreSQL Analytics & Reporting - PowerBI, PowerApps, Tableau, SnowFlake, Handoop Other- GitHub, eclipse,, Embedded Systems, IOT, Arduino interfacing, ServiceNow (ITSM, Service Catalog, Record Producer, Web APIs, etc) Computer- MS Word, excel, PowerPoint, outlook. PROFESSIONAL EXPERIENCE Data Engineer Intern SOYO SOFT JUNE 2023 DECEMBER 2023 Client:- Toledo Finance Spearheading programming and data preparation support for file creation, facilitating subsequent in-depth analysis Skillfully compiling and integrating data from diverse sources, crafting comprehensive data files with requisite variables for rigorous analysis Employing R, Python, SQL, SAS, Stata, and SPSS to query data, discerning outliers, inconsistencies, and errors to ensure data quality Generating detailed descriptive statistics to provide comprehensive insights into data characteristics Translating project requirements into the conceptualization and development of impactful dashboards using Tableau Streamlining project data through effective formatting and summarization, enhancing the clarity of dashboards and comprehensive reports Developing and optimizing ETL processes for loading data into Snowflake Monitoring and troubleshooting data loads and data quality issues Creating and managing user accounts and roles Developing and executing performance tuning and query optimization Developing and implementing data security policies and procedures Associate Software Engineer DXC Technology August 2021 - August 2022 Client :- BLUESCOPE STEEL Worked as Associate software engineer in the domain of Building and construction to the client BlueScope steel as an ASE for the span of 1 year During my employment I was responsible for testing the New and Enhanced features of the Application Worked on legacy Mainframe & Java Applications and websites, employing various IBM utilities like DFSORT, IEBGENER, and IDCAMS to create customized jobs based on specific project requirements. And successfully maintained JCLs, PROCs, PARMs, and application loads, ensuring smooth operation and efficient management of critical components Enhanced customer-friendly web applications using Java and Ant, resulting in an improved user experience and increased client satisfaction. Utilized Eclipse as a development tool, effectively leveraging its features to streamline coding, debugging, and testing, resulting in enhanced productivity and code quality Demonstrated strong analytical skills by performing business analytics using Power BI, generating and visualizing Weekly & Monthly budget reports. Leveraged Power BI reports to conduct direct queries and compare legacy data with current data, producing insightful reports stored in easily accessible dashboards Worked on automated action filters, parameters, and calculated sets in Power BI, streamlining dashboard preparation and worksheet automation. Proficiently handled Maintenance tasks, including space management, removal of bad files, cache files, and monitoring services for seamless application performance Actively participated in project teams to implement database design changes for existing data models, collaborated with business stakeholders, and involved in developing web services using XML, jQuery, CSS, HTML, and Bootstrap Proficiently managed ITIL support by handling and tracking P2 & P3 tickets, ensuring prompt resolution of issues and efficient incident management to maintain system stability and service continuity Utilized Log4j to effectively log information, warnings, and error data, enabling seamless monitoring and troubleshooting of application performance and identifying potential issues proactively Leveraged GitHub for version control, collaborating with the development team to update documentation and code efficiently, ensuring a smooth and organized development process Demonstrated strong programming skills in Python and SQL, employing these languages to manipulate data, automate processes, and create efficient solutions for various projects Demonstrated a proactive attitude and quick adaptability in a DevOps transitioning environment while consistently providing valuable assistance and support in resolving complex database issues and optimizing SQL scripts Vdart Digital May 2021 August 2021 Internship on Software Intern Results-driven Python Engineer with expertise in Data Structures, Algorithms, and Data Wrangling. Proven track record of mentoring team members, contributing to diverse projects (Java & Django), and providing valuable insights in various technologies. Learned working with data manipulation and implementation of Machine Learning models Attended several other small term internships provided by Indian government - WEB DESIGN USING REACTjs, Embedded Systems, IOT, LabVIEW and PLC programming, Machine Learning & SCI Lab PROJECTS MAJOR PROJECT: Sri Vasavi Engineering College, Tadepalligudem, Andhra Pradesh, India Photo Colorization with Deep Learning Technique Plant Leaf Disease Detection using Deep Learning Technique (CNN) MINI PROJECT: Sri Vasavi Engineering College, Tadepalligudem, Andhra Pradesh, India Low Cost public addressing system using Arduino interfacing Project Expo: Developed a Sound Reactive LED lights prototype using raspberry pi EDUCATION Sri Vasavi Engineering College, Tadepalligudem, Andhra Pradesh, India Graduated August 2021 Bachelors in Electronics and Communication Engineering Department of Electronics and Communication Engineering CERTIFICATIONS ServiceNow CSA Microsoft Certified Azure Fundamentals & Azure Data Fundamental from Microsoft Mainframe Full Stack from DXC Technology AWS Going Cloud Native, Machine Learning foundations, Cloud Foundations, from AWS Academy Graduate GCP Data Analytics from Coursera Business Reporting, from Skillsoft Python for Data Science from IBM Elements of AI from University of Helsinki Frontend fundamentals from Pirple Keywords: cprogramm cplusplus artificial intelligence business intelligence database rlang microsoft New York