Palaniappan Annamalai
Chandler
Summary
Dynamic Sr. Developer with extensive experience at United Health Group, specializing in healthcare data solutions. Proven expertise in SQL and effective team leadership. Successfully designed and implemented complex data models, enhancing operational efficiency and ensuring seamless code migrations. Adept at collaborating with cross-functional teams to deliver impactful results.
Overview
21
21
years of professional experience
Work History
Sr. Developer
United Health Group – Optum
Tempe
07.2024 - Current
- Gather requirements from the business.
- Analyze & Validate the Facets Implementation Activities, Design process flow and System Use Cases for various requirements
- Perform complete impact analysis for the interface and reporting modules based on the program requirements and cutover strategy
- Design, Develop and Unit test the requirements.
- Design review and Code review the changes with Production Services team
- Code Validation for deployed components during SDLC
- Co-ordination with Dev team, SCRM & DBA team for the code validation process
- Deliver code migration checklists, Validate & move the codes to higher environment
Project Lead
Blue Shield of California
Oakland
11.2023 - 06.2024
- Gather requirements from Business and validate the existing functionalities.
- Perform impact analysis on the existing interface and profiling for the impacted DB objects.
- Create project architecture for data flow and implement varies methodology / EDW data modeling.
- Review the requirements & validation of the development activities.
- Code change validation and deployment of components in Non-Production and Production environments.
- Support of dev activities till Production deployment.
Project Lead
Silicon Valley Bank
Tempe
04.2021 - 11.2023
- Lead the ETL team in an Agile/Scrum development framework, Gather requirements from the business.
- Conduct requirements meetings with Business and trading partners, gather requirement details, document and review requirements with various business stakeholders.
- Review the Design & code review performed for the requirement & implementing the change to production.
- Design and review critical interfaces with Tech Leads, review the design documents with all the stakeholders.
Project Lead
Blue Shield of California
San Francisco
06.2016 - 04.2021
- Perform impact analysis on the existing custom applications around Facets for the new business requirements
- Prepare and verify the development activities for the MQMFT & Sterling development
- Create project architecture for data flow and implement varies methodology / EDW data modeling
- Analyze & Validate the Facets Implementation Activities, Design process flow and System Use Cases for various requirements
- Validate the requirements & data flow in Facets
Project Lead
Guitar Center
Westlake Village
03.2015 - 06.2016
- Manage the CR & production support activities on a daily basis for the GCEDW, GCIDW, MFIDW, MACDW applications
- Successfully implemented the Netezza upgrade Pure data Migration for all the Enterprise Dataware applications
- Successfully implemented the GCOM Chain Wide Rollout
- Implemented slowly changing dimensions (SCD) for Fact tables as per user requirement.
- Developing both physical and logical data models
- Defining metadata standards for the data warehouse applications
- Identify in-efficiently written SQL’s for fine tuning in order to improve performance
- Prepare EDD & Mapping document for all the Development / Enhancement Changes
- Build & Unit testing will be done & share the results to GC Customer for Sign off & moving the codes to higher Environments
- Deliver the code, Validate the check list, Do code sanity check in system testing environment
- Loaded data to data warehousing tables from integration using SCD type 2
- Responsible for performance tuning by determining bottleneck in source, target, sessions, mapping
- Fixing for defects raised during SDLC, promote the codes to PRODUCTION Environment
Project Lead
Health Net
Woodland Hills
07.2014 - 03.2015
- Analyze the Requirements/CRs from Analyst
- Build & Unit testing will be done & share the results to HN for moving the codes to higher Environments.
- Assist manager in tracking progress, prioritizing work, developing time estimates and work plans.
- Coordinating with client for requirement gathering, clarification and providing solutions for several problems
- Participating in team sizing and effort estimation sessions
- Deliver the code, Validate the check list, Do code sanity check in system testing environment.
- Created Stored Procedures to transform the Data and worked extensively in T-SQL, PL/SQL for various needs of the transformations while loading the data into SQL Server database.
- Complex T-SQL queries and designed SSIS packages to load the data into warehouse.
Sr.ETL Developer
Kaiser Permanente
Pleasanton
01.2014 - 06.2014
- Worked with Business users in understanding the requirements to get the planning for capacity / sizing to ensure ETL / BO database and reporting scalability.
- DoU will prepared & presented to KP leads for the requirements.
- Deliver the code, Validate the check list & move the codes to higher environment.
- Migrated Oracle environment from version 10g to version 11g.
- Performed feasibility analysis on version up-gradation.
- Involved in the business requirements gathering and analysis, understanding client's Data Warehousing requirements and system analysis.
- Responsible for designing of technical design document and production support documents.
- Reviewed and identify stored procedures, packages and functions for best practices, enhanced features and better performance.
Sr.ETL Developer
Blue Shield of California
San Francisco
03.2013 - 12.2013
- Gathered requirements from the business
- Analyze & Validate the Facets Implementation Activities, Design process flow and System Use Cases for various requirements
- Validate the requirements & data flow in Facets
- Analyze, figure out root causes, fixes for defects raised during UAT Validation.
Sr.ETL Developer
Well Care
Chennai
06.2012 - 12.2012
- Understand the functional requirements and come up with mapping Design.
- Participated in technical design reviews, presenting mapping design / design approach
- Develop mappings that extracts data from source tables, transformed source columns using various transformations such as aggregator, expression etc., and loaded them into target tables
- Develop Mappings, Sessions and Workflows for relational flat file sources and targets using Power Center
Sr.ETL Developer
Well Point Enterprise
Chennai
04.2011 - 06.2012
- Understand the functional requirements, and come up with mapping Design
- Translate the business requirements into technical specifications and prepared Technical Design Document (TDD)
- Prepared the database objects like tables & views
- Analyze the data quality issues during load & involved in testing and Performance tuning
- Development & Review of codes & SQL Scripts
- Prepared the Unit Test Case, Maintenance document and executed the UTC
ETL Developer
E-Trade
Chennai
02.2010 - 03.2011
- Involved in the development of SQL scripts
- Creation/modification of new/existing database objects and their corresponding loading scripts as per requirements
- Involved in Unit Test and analyzed the test results
- Coordinating with on-site teams during development
- Validating the target data with the source data
- Participating in project weekly status meetings. Involved in Release Activities like preparing Release Notes and Moving objects into the testing server and production server
ETL Developer
Deutsche Bank
Bangalore
07.2007 - 12.2009
- Implemented the changes & providing support to Oracle Retail applications / LIMA / PRAMS
- Participate in Solution Circle meeting and assist solution architects to come up with a final solution
- Review the test cases and analyzed the test results
- Coordinating with on-site teams during development
- Participating in project weekly status meetings. Release Notes and Moving objects into the testing server and production server
Developer
Dun & Bradstreet
Chennai
04.2006 - 06.2007
- Development of SQL scripts, Unit testing & deployment to higher environments
- Prepare weekly status report, dashboards and present to client
- Creation/modification of new/existing database objects and their corresponding loading scripts as per requirements
- Review the test cases and analyzed the test results
- Participating in project weekly status meetings. Release Notes and Moving objects into the testing server and production server
ETL Developer
Capital International Asset Management
Chennai
07.2004 - 03.2006
- Involved in the development and maintenance of the application of Facility office, Asset Management applications
- Implemented Business Logic through VB Code & SQL Scripts
- Migration of Tables & Other objects from one server to another server
- Design and develop stored procedures using SQL Server 2008
- Perform performance turning activities to minimize job runtime
- Creation/modification of new/existing database objects and their corresponding loading scripts as per requirements
- Review the test cases and analyzed the test results.
Education
Bachelor of Engineering -
Annamalai University
Tamilnadu, India04-2002
Skills
- Facets
- Datastage
- SAP BODs
- Microsoft SSIS
- Informatica
- Teradata
- Oracle 11g
- DB2
- MS SQL Server
- Netezza
- SQL
- UNIX Shell Scripting
- PL/SQL
- ETL Tools
Certifications Professional Awards
- Standing O Award Recognition Award, Guitar Center Client
- RMS Technology Consultant Recognition Award, D&B Client
Key Domain Technical Knowledge
Healthcare, Banking, Retail, Facets, Erwin, JIRA, SharePoint, Oracle Apps, Oracle Retail, Sterling, Jenkins, Tivoli, Autosys, Control M, Crystal Reports, BO Reports, Web Intelligence Reports, Tableau, Data Analyzer, Datastage, SAP BODs, Microsoft SSIS, Oracle Data Integrator, Informatica, Teradata, Oracle 9i/10g/11g, DB2, MS SQL Server, Netezza, SQL, UNIX Shell Scripting, PL/SQL, Visual Basic 6.0
Timeline
Sr. Developer
United Health Group – Optum
07.2024 - Current
Project Lead
Blue Shield of California
11.2023 - 06.2024
Project Lead
Silicon Valley Bank
04.2021 - 11.2023
Project Lead
Blue Shield of California
06.2016 - 04.2021
Project Lead
Guitar Center
03.2015 - 06.2016
Project Lead
Health Net
07.2014 - 03.2015
Sr.ETL Developer
Kaiser Permanente
01.2014 - 06.2014
Sr.ETL Developer
Blue Shield of California
03.2013 - 12.2013
Sr.ETL Developer
Well Care
06.2012 - 12.2012
Sr.ETL Developer
Well Point Enterprise
04.2011 - 06.2012
ETL Developer
E-Trade
02.2010 - 03.2011
ETL Developer
Deutsche Bank
07.2007 - 12.2009
Developer
Dun & Bradstreet
04.2006 - 06.2007
ETL Developer
Capital International Asset Management
07.2004 - 03.2006
Bachelor of Engineering -
Annamalai University
Similar Profiles
Celina AitonCelina Aiton
Assoc Tech Support Analyst at United Health Group - Optum HealthAssoc Tech Support Analyst at United Health Group - Optum Health
Daniel SuttonDaniel Sutton
Senior Sonographer at United Health Group/ Optum HealthSenior Sonographer at United Health Group/ Optum Health
FNU PAUL ROWEENAFNU PAUL ROWEENA
FULL STACK JAVA DEVELOPER at United Health Group – OptumFULL STACK JAVA DEVELOPER at United Health Group – Optum
Rachelle SchulmanRachelle Schulman
Implementation Field Trainer at Mars Veterinary HealthImplementation Field Trainer at Mars Veterinary Health
Irela LopezIrela Lopez
Behavioral Health Technician at Aurora Behavioral HealthBehavioral Health Technician at Aurora Behavioral Health