POOJA AGRAWAL
Melbourne,VIC
Summary
Self-motivated Developer adds high level of experience over more than 7 years collaborating and working on multiple web-based projects. Passionate, hardworking coder with penchant for developing customized interfaces that factor in unique demands for accessibility, reachability and security. Organized approach to meeting multiple, concurrent deadlines. Pulls from active knowledge of current technology landscape to promote best practices in web design.
Overview
8
8
years of professional experience
1
1
Certification
Work History
Business logic developer (DB Developer)
Tata Consultancy Services
07.2014 - 07.2022
- Results-driven Database Developer having experience in designing, developing, and maintaining robust database solutions. Proficient in SQL, database performance tuning, and data modelling with a strong ability to translate business requirements into effective database solutions.
- Adept at troubleshooting and optimizing complex database systems and working collaboratively with cross-functional teams to achieve organizational goals.
- Tested programs and databases to identify issues and make necessary modifications.
- Collaborated on stages of systems development lifecycle from requirement gathering to production releases.
- Revised, modularized and updated old code bases to modern development standards, reducing operating costs, and improving functionality.
- Developed software for desktop and mobile operating systems.
- Developed and maintained complex SQL queries, stored procedures, and triggers to support business applications and also optimized database performance through indexing, query tuning, and partitioning, reducing query response time by 30%
- Designed reusable and reliable code for use within distributed cloud environments.
- Built databases and table structures for web applications.
- Supervised work of programmers, designers and technicians, assigned tasks and monitored performance against targets.
- Managed ETL processes using SSIS, ensuring accurate and timely data integration from multiple sources.
- Monitored database performance and implemented tuning strategies, leading to a 25% improvement in query performance.
- Participated in code reviews and contributed to best practices for database development.
- Explored cloud computing platforms such as AWS or Azure for scalable application deployment.
- Collaborated with inter-departmental teams and subcontractors to verify accurate application of prescribed testing protocols.
- Designed and implemented a relational database for managing customer interactions and support tickets, improving customer service efficiency.
- Developed a data warehouse and reporting system for sales data, enabling real-time analytics and visualizations using SQL Server and Power BI.
- Focused professional with experience in ITIL especially service operation process like Incident management, Problem management and release management.
Education
Masters of Information System - Information Technology
Holmesglen Institute
Southbank, VIC06.2024
B. Tech - Information Technology
Banasthali Vidyapith
India06.2014
Intermediate - Science Education
Ratanlal Phool Katori School
01.2010
High School -
Adarsh Vidya Mandir School
01.2008
Skills
- Database Technologies: SQL Server, MySQL, PostgreSQL, Oracle, Devops
- Programming Languages: SQL, T-SQL, PL/SQL, Python
- Data Modeling: Entity-Relationship Diagrams (ERD), Normalization, Dimensional Modeling
- Tools: SQL Developer, TOAD, ER/Studio
- Performance Tuning: Indexing, Query Optimization, Stored Procedures, Triggers
- ETL: SSIS, Data Transformation Services (DTS)
- Version Control: Git, SVN
- Operating Systems: Windows, Linux
Accomplishments
- TCS GEM for acting beyond call of duty, star performer of team, best team of account for organizational responsibilities and internal initiatives.
- Awarded as talent ambassador for enhancing and maintaining Touch Talent site.
Languages
Hindi
Full Professional
English
Full Professional
Punjabi
Limited Working
Certification
- Certified 1 year diploma in VB .net development.
Timeline
Business logic developer (DB Developer)
Tata Consultancy Services
07.2014 - 07.2022
Masters of Information System - Information Technology
Holmesglen Institute
B. Tech - Information Technology
Banasthali Vidyapith
Intermediate - Science Education
Ratanlal Phool Katori School
High School -
Adarsh Vidya Mandir School
- Certified 1 year diploma in VB .net development.
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services