Deepak Pedada
South Windsor,CT
Summary
Adept in ETL development and SQL programming, I spearheaded database design and data migration projects at Travelers, enhancing scalability and innovation. My collaborative approach and technical prowess in PostgreSQL and SQL Server led to robust solutions, significantly improving policy management processes. My leadership in cross-functional teams highlights my ability to drive efficiency and foster innovation.
Professional database specialist equipped to drive impactful results in data architecture and design. Strong skills in SQL, data modeling, and performance optimization. Proven ability to collaborate within teams, adapt to evolving requirements, and ensure reliable data solutions. Known for consistent delivery and high standards.
Diligent Data Architect with solid foundation in database design and development. Successfully contributed to projects that optimized data storage solutions and improved system performance. Demonstrated expertise in SQL and database schema design, ensuring data integrity and efficient retrieval processes.
Database design professional with proven track record in creating robust and efficient database systems. Known for delivering high-quality solutions that meet business needs and support operational goals. Emphasizes team collaboration and adapts to changing requirements, showcasing strong analytical and problem-solving skills.
Overview
20
20
years of professional experience
1
1
Certification
Work History
Database Designer
Travelers
09.2023 - Current
- Company Overview: In Travelers, the Policy Underwriting, Issuance, Rating, Quote Generation, Management and Claim Handling for BOND Insurance Policies is currently handled by an application called POLARIS
- This functionality is now being migrated into Guidewire Product which enables the business to be more scalable, cost effective and helps innovate faster
- Participate in US creation, sizing, prioritizing, and planning of Features
- Participate and Contribute for a robust and efficient Database Design and solution for Policy Conversion
- Participate in Data Modeling and Design sessions for POSTGRESQL and SQL Server
- Participate in Design reviews, Performance Tuning
- Creation and Review of Data Models using Erwin as per standards
- Create and Review Tables and Table changes required for Policy Conversion
- Analyze and Create Data Mapping for Policy Conversion into Guidewire
- In Travelers, the Policy Underwriting, Issuance, Rating, Quote Generation, Management and Claim Handling for BOND Insurance Policies is currently handled by an application called POLARIS
- This functionality is now being migrated into Guidewire Product which enables the business to be more scalable, cost effective and helps innovate faster
- Technology & Tools: Talend, PostgreSQL, SQL Server, PGadmin, AWS Aurora
Technical Designer
Mandalorians
01.2020 - 08.2023
- Company Overview: Mandalorians- CA Portal is a portal one stop place for multiple users at different levels to access the performance metrics of various claim handling processes and evaluate the processes and improve
- Participate in US creation, sizing, prioritizing, and planning of Features
- Participate and Contribute for a robust and efficient Technical Design and solution for CA Portal
- Participate in Data Modeling and Design sessions for POSTGRESQL and SQL Server
- Development and maintenance of Reports using COGNOS
- ETL processing using Talend
- Qlik sense applications
- Create and Implement Test Strategy and Test Plan
- Identify and report on defects and monitor them for closure
- Participate in Code reviews, Performance Tuning ensuring a quality product
- Turnover the Business Report to Prod Support teams
- Mandalorians- CA Portal is a portal one stop place for multiple users at different levels to access the performance metrics of various claim handling processes and evaluate the processes and improve
- Technology & Tools: Talend, QlikSense, Python, React, POSTGRE SQL, SQL Server
Report Manager
04.2016 - 12.2017
- Creation and Tracking of Report Execution plan
- Planning of Effort estimate for all the team members
- Prioritize Report enhancements and plan for them
- Review the Reports and changes to the report
- Tracking and ensure closure of Report Incidents
- Manage and ensure all SLAs are met for the team
- Identify and develop the Automations for different manual steps involved in the reports
- Technology & Tools: MS-Excel, AbInitio, SAS, MS-Access, DB2, Teradata
Production Support Manager
04.2016 - 12.2017
- Creation and Tracking of Report Execution plan
- Planning of Effort estimate for all the team members
- Prioritize Report enhancements and plan for them
- Review the Reports and changes to the report
- Tracking and ensure closure of Report Incidents
- Manage and ensure all SLAs are met for the team
- Identify and develop the Automations for different manual steps involved in the reports
- Technology & Tools: MS-Excel, AbInitio, SAS, MS-Access, DB2, Teradata
Application Developer
04.2005 - 03.2016
- Participate in Impact Analysis, Estimation, Planning and Execution of the project
- Participate and Contribute for a robust and efficient Technical Design and solution
- Participate in requirement gathering sessions and providing inputs to business to come up with an efficient workflow
- Participate in Data Modeling and Design sessions and ensure data pattern standards are followed
- Development and maintenance of applications using C# .Net, VS-2013, MVC Technologies, javascript, SQL Server, SAS, Mainframe technologies like COBOL, CICS, JCL, DB2, IMS etc
- Working with offshore team members in resolving the technical and functional issues and guiding the team
- Creation of Test Plan and Track test Execution
- Release Planning, Management and Implementation
- Participate in Code reviews, Performance Tuning for ensuring a quality product
- Manage Documentation like Business and Technical Specifications, Application functional work flow, test procedures for efficient PROD turn over
- Technology & Tools: COBOL, JCL, DB2, IMS DB/DC, CICS, CICS MAINVIEW, TRITUNE, DB2PM, CA-Intertest, Endevor, MS- Visio, FILE-AID, SPUFI, QMF, AQT, DB2 Stored Procedures, VSAM, SEEC, Abinitio, Teradata, SAS, .NET, Enterprise Architect
Education
Bachelor of Engineering - Electronics And Instrumentation
GITAM College of Engineering
Visakhapatnam04-2004
Skills
- ETL development
- SQL Programming
- Database Design
- Data Migration
Certification
- IBM Certified Database Associate
- Sun Java Certification
- Certificate in General Insurance
- SAFe Certified Agile Scrum Master
- AWS Certified Cloud Practitioner
Languages
English
Professional Working
Telugu
Professional Working
Hindi
Professional Working
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Timeline
Database Designer
Travelers
09.2023 - Current
Technical Designer
Mandalorians
01.2020 - 08.2023
Report Manager
04.2016 - 12.2017
Production Support Manager
04.2016 - 12.2017
Application Developer
04.2005 - 03.2016
Bachelor of Engineering - Electronics And Instrumentation
GITAM College of Engineering
Similar Profiles
Empress MathesEmpress Mathes
Sterile Processing Technician at TravelersSterile Processing Technician at Travelers
Victoria BiesterveldVictoria Biesterveld
Customer Service Representative, Specialty at TravelersCustomer Service Representative, Specialty at Travelers
Robert MillerRobert Miller
Senior Technical Specialist Construction Defect at TravelersSenior Technical Specialist Construction Defect at Travelers
Patricia LeMondPatricia LeMond
Unit Manager at TravelersUnit Manager at Travelers
Kevin WindKevin Wind
Assistant Integrated Facilities Manger at CBREAssistant Integrated Facilities Manger at CBRE