Priyanka P
Bengaluru
Summary
Over 9 years of hands-on IT experience specializing in the analysis, design, and implementation of MS SQL Server solutions across diverse business domains, including supply chain, discrete production, and finance. Demonstrated expertise in identifying complex problems, evaluating potential solutions, and selecting the most effective strategies to achieve business objectives. Adept at driving process improvements and delivering scalable database developments that enhance operational efficiency. Committed to leveraging technical skills and domain knowledge to support organizational goals and drive innovation.
Overview
10
10
years of professional experience
Work History
System Analyst
Ramco Systems Ltd
Bengaluru, India
06.2016 - Current
- Managed supply chain operations through ERP systems to enhance discrete production efficiency and financial accuracy.
- PROJECT#1 Toyota Tsusho Private Ltd:(SEP 2024 to till now)
- Description: TTIPL set up operation in Bangalore as part of Global Toyota plan for implementing its Project. TTIPL acts as Steel processing and integrated Logistics Service provider besides dealings of various materials with regard to import and export for TKM and its Parts suppliers
- PROJECT #1 : Axles India Limited (Jun 2016 to Dec2018)
- Implemented a report
- PROJECT #2: IVP Ltd. (Dec 2019 to Mar 2022)
- Description: First company to manufacture Foundry Chemicals in India in technical collaboration with M/s Ashland Inc. way back in 1965.Their manufacturing plants at Tarapur and Bangalore have a combined annual capacity of approximately 50,000 MT per annum catering to the foundry, composites, refractory & insulation industries in India and neighboring countries.
- PROJECT #3: P.T. Bali Seafood International (Sep 2017 to Mar 2019)
- Description: BSI is a wholly owned Indonesian subsidiary of North Atlantic, Inc. (NIA), a Portland, Maine-based supplier focused on sustainably sourced and socially responsible seafood.
- PROJECT #4 : Curatio Healthcare (I) Pvt Ltd (Apr 2019 to Mar 2022)
- Description : Curatio Healthcare (I) Pvt Limited is a service Industry which is providing a custom application to clients, thereby the dealers can take care if their daily transactions i.e., sales, purchase and services.
- PROJECT #5 : Subhasri Pigments Pvt. Ltd (Oct 2020 to Mar 2022)
- Description : Subhasri Pigments Pvt. Ltd is Pigment Manufacturing Industry which is providing a custom application to clients thereby the dealers can take care if their daily transactions i.e., sales, purchase and services.
- PROJECT #6 : Eagle Cement Corporation (Jan 2020 to till now)
- Description : Eagle Cement Corporation operates the largest cement plant in the Philippines and is the fourth largest player in the country. The Company is primarily engaged in the business of manufacturing, marketing, sales and distribution of cement.
- PROJECT #7 : Prism Cements (Jan 2023 to till now)
- Description : Prism Cement is a division of Prism Johnson Limited. Prism Johnson Limited is one of India’s leading integrated Building Materials Company, with a wide range of products from Cement, Ready-Mixed Concrete, Tiles and Bath products. The company has three Divisions, viz. Cement, H & R Johnson (India), and RMC (India)
- PROJECT #8 : Northern Cements Corporation (Jul 2024 to till now)
- Description : Northern Cement Corporation supplies its products in different areas in North and Central Luzon Provinces and provides high quality cement designed for heavy duty construction that needs high early concrete strength
- PROJECT #9 : Southern Star Aggregates Inc, (May 2024 till now)
- Description: Southern Star Aggregates Inc. is a leading provider of high-quality aggregate materials. Established in 2021 and earned a strong reputation for delivering superior products and committed to meeting the construction and landscaping needs of clients while providing sustainability and environmental responsibility.
- Tools & Environment used: MS SQL 2012/2018/2022, SSMS, SQL Server Profiler, Ramco Virtual Works, Decision Works, Jasper Reports, SSRS and D-Cube report
- Role & Responsibilities:
- Implementing customer requirements which are provided by customers like new customization screens and change requests in product screens.
- Played an active role during the requirements gathering, analyzing and designing of the system.
- Developing and testing the new features of Business requirements and involved in Defect Fixing.
- Tracing Errors using MS SQL Server Profiler.
- Develop SQL quality code as per requirements and latest code is moved into GIT.
- Create Stage/ODS tables, Clean STG /Load ODS Procedure and Current/Complete views for each source.
- Provide support in QA Testing and Production testing and resolve defects within time.
- Supported Production, UAT and development environment.
- Identified data issues and provided recommendations for resolution to ensure optimal performance.
- Responsible for the designing of the advanced SQL queries, procedure, views, functions and scripts.
- Current Updates(CU Upgrades) done for Many ON Premise servers.
- Implemented and Worked on IRIS Integrations for different Projects.
- Also been part of Backup and restore databases for ON Premise servers.
- Developed reports across projects using IREPORT, SSRS and TIBCO Jaspersoft Studio.
- Analyzed system requirements to ensure alignment with business objectives.
- Developed and maintained documentation for system processes and user guides.
- Collaborated with cross-functional teams to identify and resolve technical issues.
- Conducted testing of software applications, ensuring functionality and reliability.
- Provided support in data migration activities during system upgrades.
- Conducted comprehensive data analysis to identify patterns and trends, informing decision-making processes.
Education
Bachelor of Engineering - CSE
Yogananda Institute of Engineering & Technology
Tirupati01-2015
Higher Secondary College - undefined
Sri Sai Chaitanya Junior college
Tirupati01-2011
Secondary School - undefined
Sri Vidya E.M High School
Tirupati01-2009
Skills
Industries
Proficient in ERP for supply chain
ERP systems expertise
Financial ERP management
Database management systems expertise
Experienced with MS SQL Server versions 2016 to 2022
Data analysis tools
Experience with SQL Server Management Studio versions
Database activity analysis
ETL process management
Business reporting tools
Decision Works
Experience with Jasper Reports
Data visualization proficiency
Familiarity with various tools
MS Office Suite (MS Word, Excel)
Database design
End user support
Application support
Software development life cycle
Diagnostic tools
Technical documentation
System upgrades
Business process analysis
User acceptance testing
Requirements gathering
API integration
SSRS and SSIS
Languages Known
Telugu
Tamil
Hindi
English
Timeline
System Analyst
Ramco Systems Ltd
06.2016 - Current
Higher Secondary College - undefined
Sri Sai Chaitanya Junior college
Secondary School - undefined
Sri Vidya E.M High School
Bachelor of Engineering - CSE
Yogananda Institute of Engineering & Technology
DECLARATION
I hereby declare that all the above information is true to the best of my knowledge and belief. Place: Bangalore Date
PERSONAL INFORMATION
- Address : HNO-5, Dhana Lakshmi Subramanya Nilaya, Abhirudhi Garden 1st Lane, Sacred Hearts Road, TC Palya, KR Puram Bengaluru, Karnataka-560036
- Marital status : Married
- Nationality : Indian
DECLARATION
I hereby declare that all the above information is true to the best of my knowledge and belief. Place: Bangalore Date