GEETHANJALI P

Project: 7-Eleven Holdings Inc.
Role: Senior Developer / Technical Lead

• Designed and developed business reports using SSRS, Power BI and Python, leveraging SQL Server databases.
• Trained new hires on development processes, coding standards, and company culture to support effective onboarding and team alignment.
• Conducted performance tuning for long-running SQL processes to optimize system performance.
• Contributed across key modules including Enterprise, Money Order, Matching, Credit, Retail Sales, Lottery, Fuel, and Banking.
• Partnered with clients and cross-functional teams to gather, analyze, and translate business requirements into technical solutions.
• Authored functional specification documents and established SQL code review standards to enhance code quality.
• Proposed and implemented automation solutions, receiving client commendations for innovation and process efficiency.
• Led development efforts during ARIES-to-Oracle database migration, including the creation of SSRS reports, SSIS packages, stored procedures, and SQL jobs.
• Compiled and submitted detailed weekly and monthly status reports to leadership, supporting project transparency and decision-making.

Project: Wellmark Inc, Role: Associate Developer, Subject Matter Expert (SME).

• Specialized in Trizetto’s Facets Application Suite, with in-depth knowledge of data models, table structures, and business workflows.
• Developed complex stored procedures to process client data for claims payments and membership updates.
• Optimized SQL stored procedures by tuning long-running queries to improve performance and reduce processing time.
• Designed logic for pre-authorization checks in CM004 module, earning client recognition for saving $21,000.
• Led resolution of critical batch incidents and managed Claims, Provider, and Membership batch issues (MMS/KWD).
• Provided production support, implementation assistance, and engaged in client communication through walkthroughs and knowledge-sharing sessions.
• Acted as SME across multiple modules and conducted training for new team members.

Project: Aetna
Role: Program Analyst

• Gathered and analyzed business requirements; created Business Requirement Documents (BRD) and design documentation.
• Developed RO Sheets, test plans, and test data; performed unit and integration testing.
• Created and tested batch jobs across various environments.
• Conducted SQL code reviews and ensured adherence to coding standards.
• Modified existing SSIS packages and performed database operations.
• Customized web UI, built applications, and deployed to servers.
• Participated in client requirement calls and received appreciation from both client and management for successful project delivery.