Ashish Kumar Vanamala
Hyderabad
Summary
Experienced Oracle PL/SQL Developer with a strong background in programming and data analysis. Possessing around 3 years of experience as a developer and 3 years as a Senior Data Analyst, specializing in designing and implementing Business Applications using Oracle RDBMS. Proficient in all stages of the SDLC, ensuring timely delivery while meeting aggressive deadlines
Overview
6
6
years of professional experience
Work History
Oracle Developer | Implementation Engineer
Pheonix American Sales Focus Solutions
10.2021 - Current
- Proficient in SQL scripting for process automation, with extensive hands-on experience.
- Skilled in developing and modifying triggers, packages, functions, and stored procedures for data conversions, including dynamic database object creation using PL/SQL procedures.
- Collaborated with front-end design team to provide essential stored procedures, packages, and data insights, ensuring seamless coordination between back-end and front-end development.
- Actively resolved production issues and implemented enhancements efficiently.
- Played an active role in the design process, contributing to application functional and technical specifications.
- Contributed to iterative improvement processes, ensuring smooth operation of systems and applications.
- Thoroughly documented application design specifications and implementation procedures, promoting application quality and code reuse.
- Proficient in writing Sub-queries, Aggregate Functions, Grouping Functions, Window Functions, and Analytic Functions.
- Developed and customized SQL Plus, PL/SQL, and SQL Loader scripts for efficient data conversions.
- Resolving Core metrics issues after deployment, Conducting testing, troubleshooting, and QA tasks.
- Coordinating end-to-end data service implementations. Analyzing system performance and conducting code reviews.
- Proficient in .NET Application Deployments and Oracle Scripts, Testing various scenarios to ensure accurate data entry.
- Evaluating software/hardware for improvement recommendations, Maintaining detailed records of implementation changes.
- Managing configuration, installation, and software troubleshooting for clients.
Sr Data Analyst
Pheonix American Sales Focus Solutions
01.2019 - 10.2021
- Analyzed CRM data from 43 clients using Excel and SQL queries to identify patterns and trends.
- Collaborated with the US team for data analysis approval and communication in the Data Cleansing Project.
- Managed Unify, a centralized database integrating data from various sources, resolving exceptions at the F/O/R level.
- Implemented backend code enhancements in Unify for efficient work flow, including sorting and conditional operations.
- Utilized web-scraping techniques to gather data from web sources, performing cleanup scripts and integrating it into Unify.
- Addressed new case studies and scenarios, applying data cleansing strategies and automation where possible.
- Contributed to the development team's data acquisition process, ensuring organized and suitable data for analysis.
Data Analyst
Pheonix American Sales Focus Solutions
02.2018 - 01.2019
- Ensured data accuracy,consistency, and integrity through data cleansing and quality issue resolution.
- Established data governance processes to enforce integrity and quality standards.
- Utilized statistical methods and modeling techniques for pattern and trend analysis.
- Applied advanced data analysis techniques to drive actionable insights and informed decision-making.
- Implemented initiatives to improve data quality and reliability.
- Collaborated cross-functionally to develop and implement data governance policies. Conducted regular data quality assessments for monitoring and improvement.
- Developed and maintained documentation for data governance and quality standards.
Education
Master of Science - VLSI And Embedded Systems
JNTU Hyderabad
Hyderabad01.2017
Bachelor of Science - Electrical And Electronic Engineering
METHODIST COLLEGE OF ENGINEERING
Hyderabad05.2013
Skills
- Oracle PL/SQL
- SQL, SQL Loader
- Power BI
- Excel
- Git
- Jira
- Confluence
- MS-Office
Languages
English
Upper intermediate (B2)
Hindi
Intermediate (B1)
Telugu
Advanced (C1)
Additional Information
Have basic knowledge on R, Tableau, Python. I've done Google Data Analytics Certification (https://coursera.org/share/b0c8451bb7bb085cab4f1d9453a5a820)
Timeline
Oracle Developer | Implementation Engineer
Pheonix American Sales Focus Solutions
10.2021 - Current
Sr Data Analyst
Pheonix American Sales Focus Solutions
01.2019 - 10.2021
Data Analyst
Pheonix American Sales Focus Solutions
02.2018 - 01.2019
Master of Science - VLSI And Embedded Systems
JNTU Hyderabad
Bachelor of Science - Electrical And Electronic Engineering
METHODIST COLLEGE OF ENGINEERING
Similar Profiles
Vamshi Krishna DuddillaVamshi Krishna Duddilla
Data Analyst at Pheonix American Salesfocus Solutions Ind Pvt LtdData Analyst at Pheonix American Salesfocus Solutions Ind Pvt Ltd
Robert KotulekRobert Kotulek
Weigh Up/Material Handler/Laborer at American PheonixWeigh Up/Material Handler/Laborer at American Pheonix
Ankur KaushikAnkur Kaushik
Operations Manager at Pheonix Assist Taxation And Accounting SolutionsOperations Manager at Pheonix Assist Taxation And Accounting Solutions