NJ

Narendra Reddy Jaggavarapu

Professional Summary

Accomplished IT professional with more than 11 years of expertise in steering software design and development initiatives within the insurance and reinsurance sector. Demonstrated success in leading cross-functional teams, managing concurrent projects, and serving as a Subject Matter Expert. Specialized in areas such as data warehousing, Business Intelligence, and streamlined data processing. Acknowledged for adeptly resolving issues, optimizing processes, and offering strategic insights. Proficient in task automation to improve efficiency and minimize manual efforts. Possesses robust analytical and problem-solving skills, coupled with a dedication to maintaining thorough documentation. Work History

The Hartford - Senior Data Warehouse Developer

Hartford, CT

01/2020 - Current

· Lead software design and development initiatives, specializing in the insurance and reinsurance domain, contributing to the success of key projects.

· Manage a team of 5 onsite and 10 offshore, ensuring efficient collaboration and delivery of high-quality software solutions.

· Work on multiple projects simultaneously, demonstrating strong multitasking and project management skills.

· Serve as the Subject Matter Expert for all projects, providing guidance and expertise in software development and domain-specific knowledge.

· Collaborated with cross-functional teams to gather and analyze business requirements for data warehousing projects.

· Perform as a Product Support SME, addressing issues promptly and ensuring the smooth operation of software applications.

· Design and develop a data warehouse that loads data into financial and statutory reporting applications, ensuring data consistency and accuracy.

· Implement Business Intelligence solutions within the Data Warehousing context, providing valuable insights for strategic decision-making.

· Develop complex stored procedures and SSIS packages for data loading and transformation, ensuring efficient and accurate data processing.

· Lead the integration of multiple applications and orchestrate the loading of data into financial and statutory reporting applications. ad3ffw@r.postjobfree.com

551-***-****

Farmington, CT 06032

Bold Profile

Skills

● ETL Development

● Technical Troubleshooting

● Database Design

● Data Integration

● Project Management

● SQL Expertise

● Data Warehousing

● Performance Tuning

● Data Modeling

● Dimensional Modeling

Education

04/2007

Jawaharlal Nehru Technological

University

Hyderabad,Telangana,India

Bachelor of Science: Computer Science

Engineering

· Periodically analyze jobs and implement performance tuning strategies to optimize processes as data volume increases day by day.

· Identify and resolve integration issues for statutory reporting applications, ensuring data accuracy and compliance.

· Develop complex queries to generate reports on written premium, commission, taxes, earned premiums, unearned premiums, loss reserve, loss paid, open balances, cash, and estimation premium.

· Proactively identify and resolve issues, ensuring the integrity of financial and statutory reporting data.

· Identify and automate redundant tasks, improving overall efficiency and reducing manual efforts.

· Review user stories to ensure comprehensive information, assess the anticipated time required for completion.

· Analyze production issues, offer solutions, correct impacted policies in the production environment, and provide scripts for implementation.

· Created and maintained documentation for data warehouse architecture, data dictionaries, and ETL processes.

AIG Global Services - Senior Database Engineer

New York, NY

02/2012 - 12/2019

Thoroughly review Business Requirement Documents (BRD) for clarity and collaborate with Business Analysts and Data Integration teams to address any ambiguities.

• Strategically plan and execute Sprints, ensuring meticulous crafting of user stories with well-defined scopes before team distribution.

• Adhere to Agile methodology for deliverables, utilizing the Rally Tool for planning, estimation, defect tracking, and requirement management.

• Contribute to the development of a PII data extractor tool, supporting data masking and scrambling initiatives across multiple applications at The Hartford.

• Create ETL jobs using SQL stored procedures to seamlessly load data into Focus Enterprise Data Warehouse from various source systems, employing Microsoft Visual Studio, SSIS, and SQL Server.

• Design and develop SQL procedures based on mapping documents, ensuring the development and execution of system integration test plans.

• Conduct comprehensive analysis of existing and new code for performance optimization, actively participating in tuning SQL procedures and Packages to enhance efficiency and avoid deadlocks.

• Develop and implement ETL Jobs using SSIS in alignment with industry- standard software development life cycle practices.

• Collaborate with customers to enhance data handling methods, employing optimized queries, structural changes, or migration to a more suitable server, while introducing new methodologies and best practices for database performance improvement.

• Present data models, technical design documents, and mapping documents to customers for approval, conducting walkthroughs to ensure alignment with requirements.

• Review technical design and integration code with clients, promptly identifying and resolving critical design and code issues.

• Analyze and resolve complex/critical issues reported during production data loads from Sapiens, adhering to SLA guidelines.

• Utilize the Rally tool for tracking work, monitoring status, identifying issues, and managing risks and dependencies.

• Monitor burndown charts and team capacity using the Rally tool, ensuring effective project management.

• Schedule bots using Scheduler and collaborate on work-queues, optimizing task execution.

• Plan and coordinate all releases, create deployment scripts, and prepare artifacts for deployment in compliance with change management processes.

Tools

● SSIS

● SQL

● T-SQL

● PowerShell Scripts

● Microsoft Visio

● Oracle Pl/SQL

● Ab initio

Contact this candidate