Gayatri Patel

Software Engineer @Network Solutions

Developed ETL programs using Informatica to implement the business requirements. • Created shell scripts to fine tune the ETL flow of the Informatica workflows. • Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections. • Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements. • Effectively worked in Informatica version based environment and used deployment groups to migrate the objects. • Performed unit testing at various levels of the ETL and actively involved in team code reviews. • Identified problems in existing production data and developed one time scripts to correct them. • Fixed the invalid mappings and troubleshoot the technical problems of the database. • Regularly communicate and work on joint tasks with both remote and on-site team members- Serve as Engineering Point of Contact for enterprise service platforms. • Collaborate across teams to troubleshoot reported problems in both UNIX and Windows environments. • Developed Database for EMS, HR Portal, Budget Add system and created packages for each. • Created tables and developed Stored Procedures for EMS, HR Portal, Budget Add • Designed and developed system for Web.com using J2EE, Spring, Servlets, JSP under the Apache Struts Framework. • Worked on enhancement for EMS system using Spring framework. • I also involved in designed and development of web interface using JSP, Servlets, JavaScript and JDBC for administering and managing users and clients. • Regularly communicate and work on joint tasks with both remote and on-site team members- Serve as Engineering Point of Contact for enterprise service platforms. • Collaborate across teams to troubleshoot reported problems in both Unix and Windows environments.