Jigar Patel
Plainsboro,NJ
Summary
- Software engineering professional with deep expertise in delivering high-quality software application and services. Strong focus on team collaboration, driving projects to successful completion, and adapting to evolving requirements. Values listening to customer requirements and delivering high-quality results while fostering productive work environment.
- Experience of customer relationships and managing team of people to deliver excellent service and value to customers.
Overview
16
16
years of professional experience
Work History
Sr. Software Engineer
The Guardian Life Insurance Company of America
06.2021 - 06.2025
- Environment: ALIP (Accenture Life Insurance Platform), Informatica Power Center 10.x, PostgreSQL, Java, MS SQL Server, Jenkins, Amazon web services, Bit Bucket, Control M, Serena Dimension, UNIX, Linux.
- Description Guardian Life Insurance’s IM (Individual Market) Department have initiated a project called ALIP (Accenture Life Insurance Platform). The purpose of this application to create a more flexible organization able to pivot based on business need and deliver higher innovative quality products to our customers.
- Job Responsibilities
- Involved in design and requirements discussions with project managers, business users and customers.
- Design and develop Data Model for ACR (ALIP Cross Reference System) to capture the data from ALIP system on daily basis.
- Responsible for leading the team to to design and develop the requested solution and delivered to Customer.
- Conduct regular status meetings to review the weekly accomplished work and plan the next week's work.
- Get customer's feedback on the delivered solution and apply the feedback in next revision of the software.
Sr. Software Engineer (Investment Department)
The Guardian Life Insurance Company of America
09.2018 - 06.2021
- Description Guardian Life Insurance’s Investment Department have initiated a project called Investment DataBase 2 (IDB2) to satisfy the need for Trader’s Desk and Operation team to efficiently monitor and maintain various Asset Class Securities which are not limited Fixed Income, Equities, Private Placements, Structured Products, Futures, Over-the-Counter (OTC). The purpose of this application is to create a centralized, unified data source that can quickly provide diverse business users with the information they require from Guardian Investments. In order to consume and store the Investment data (Facility, Contract level and accounting data), our team worked with the external vendors such as Bloomberg, EPAM and WSO (Wall street office) to fetch the details of the securities, pricing, ratings and accounting information.
- Job Responsibilities
- Work with business users and customers to gather requirements and discuss design with project manager.
- Translate the user requirements into specific instructions for the team and lead the team on daily basis to implement and develop the best solution to meet those requirements.
- Maintain the data records of each meeting and communications for auditing and reporting.
- Do frequent status check with customers to provide them update the project progress and review the requirements to confirm if there are any changes.
Informatica Consultant
Wells Fargo
02.2018 - 09.2018
- Wells Fargo & Company initiated Project QFC (Qualified Financial Contracts) RecordKeeping to comply with the Department of Treasury’s Final Rule established in response to the Dodd Frank Act which is related to Orderly Liquidation Authority. QFC Recordkeeping repository and reporting solution would enable, Wells Fargo to Aggregate and consolidate Positions, Agreements, Counterparty, Collateral and Entity data across the enterprise. Accurately apply business logic mandated in Rule. Ensure quality assurance and control. And define and document a governance Model.
- Job Responsibilities
- Working closely with Business to accurately document the Data linage and mapping document for various Trading unit source systems.
- Prepare Feed onboarding document for each Trading unit which would pass through Data Quality and Exception Framework called QSXF (Quick Silver Exception Framework) built on Java platform.
- Acting as a bridge and supporting member between different teams to ensure smooth operation and progress of the project.
- Responsible in Data Analysis and Validation of the work performed by the teams.
- Managed approximately 30 incoming calls, emails and faxes per day from customers.
- Acting as liaison coordinating with Production Support team until maturity.
Informatica Developer
The Guardian Life Insurance Company of America
01.2017 - 01.2018
- Description Guardian Life Insurance’s business areas offer a multitude of products designed to provide solutions to individuals and business owners. To satisfy the requirement for initiative of Unified Desktop which would be Guardian’s customer face application. Guardian have engaged in building Enterprise Master Data known as Customer Hub, which creates a centralized repository for Guardian Parties from different line of business.
- Job Responsibilities
- Understand the customer requirements and profile data for various Line of Business to source in MDM (Master Data).
- Work closely with Data Architect on the Rule for Mastering the Party records using various Matching Algorithms
- Conduct brainstorming and retrospective sessions to review and align the project requirements.
- Perform hands on development along with training new talent for knowledge transfer and retention.
- Documenting the changes and new requirements in Serena Dimension.
- Coordinating with ETL Support team for Maintenance Activities
- Managed approximately 20 incoming calls and emails per day from customers.
Sr. ETL Informatica Developer
Prudential Insurance Company of America
01.2016 - 12.2016
- Description Prudential initiated a drive to build a modern, leading technology platform to benefit Prudential Distributors who expect accurate timely payments of sales incentive compensation. This System call Consolidated Compensation Management System (CCMS) will satisfy marketplace expectations and improve Prudential’s agility to respond to evolution in the insurance business, unlike today where it is dependent upon long change management cycles and manual workarounds.
- Job Responsibilities
- Develop the interface from ADB (Agency Database) and DSS (Distribution Support System) to load into CCMS (Consolidated Compensation Management System)
- Developed numerous Informatica Powercenter Mappings using various Complex business rules to load daily transaction on Polices.
- Perform Data Analysis and Validation on Agency data and Distribution transaction
- Perform impact analysis as per Business Requirements changes on overall system.
Sr. ETL Informatica Developer
The Guardian Life Insurance Company of America
10.2013 - 12.2015
- Description Guardian Life Insurance’s business areas offer a multitude of products designed to provide solutions to individuals and business owners. Guardian issues individual life insurance, including bank-owned life insurance (BOLI) products, for living benefits as well as protection against untimely death. The death benefit helps clients fulfill financial obligations for those they leave behind and also serves as a tax-efficient method for passing on wealth to the next generation. The living benefits of cash value life insurance can help enhance retirement, pay college tuition expenses, or may be used in business situations such as funding a buy-out or deferred compensation. Survivorship life insurance covers two lives under one policy, a good solution for married couples or business associates, especially if one of the individuals is uninsurable because of health.
- Job Responsibilities
- Develop the interface from Underwriter Issue System STP (Straight Through Processing) and Admin System LCS (Life Computer System) and UNITY to ILDR (Individual Life Data Repository) Data Mart
- Involved in Supporting and developing Customer web Portal called MAM
- Constantly Enhancing the Data Mart as per Business Requirements.
- Involved in gathering Business Requirement and developing new interface for same. Handled at least 3 meetings per week and daily status update emails from business users.
- Documenting the changes and new requirements in Serena Dimension.
- Monitoring the daily tasks at end of the day to ensure all systems are green and go.
- Coordinating with ETL Support team for Failures and Maintenance Activities
Sr. Informatica Consultant
Exelon Corporation
04.2012 - 10.2013
- Description Exelon buys, sells and Power as wholesaler to other retailers. The company has a fully-fledged trade floor. It deals with Trading, pricing, generation outages, real time gathering power data from different ISO’s. The subject areas in ETL are Transaction, forward pricing, Budget, Journal entries, General Ledger, References, Generation Outages, Lippman etc.
- Job Responsibilities
- Development of new interfaces using Informatica Powercenter 9.1, testing the interface, entering & exiting QA lab and finally promoting code to production
- Developed numerous Informatica Mappings using various Transformations like expressions, filters, lookups, router, update strategy transformations and many more.
- Applying/Executing Ad-Hoc solutions based on the user business
- Performing month beginning and month end activities, expiring partitions.
- Set up critical Data Quality checks to identify new deals, changed deals and dropped deals using home grown .Net Application for DQ software called Genie.
- Creating design and operation support documents.
- Performing Yearly Disaster Recover Drill
Data Warehouse Consultant
AstraZeneca Pharmaceuticals LP
10.2009 - 04.2012
- State laws requiring pharmaceutical and medical device companies to disclose the scope and nature of their interactions with health care providers, organizations and affiliations (HCP/O/As) have become an increasing source of compliance risk. Seven states and the District of Columbia have enacted legislation requiring pharmaceutical companies to report their aggregate spend on HCP/O/As. In addition, the federal government health care reform will likely include additional disclosure restrictions, perhaps in addition to or in the form of the Physician Payments Sunshine Act.
- To respond to these requirements, AstraZeneca pharmaceutical are developing aggregate spend solutions that are specific to their company’s needs based on their current state environment. Although AZ has the capability to meet state reporting requirements, the process is very labor intensive and is therefore not flexible or scalable to meet additional states or pending federal legislation.
- AZ is looking to make investments in an Aggregate Spend Solution that increases their capabilities to comply with existing and potential legislation and to monitor and manage internal spend caps. This must be implemented by the end of October 2010.
- Job Responsibilities:
- Analyze, Design, Develop, Tested, Install, and Configure the Data Warehousing applications, which supports the need of Aggregate Spend Solution.
- Involved in various level of project as an ETL expert, starting from requirement specifications to deploying the tested product in Production.
- Worked extensively with Data Modeler Team/Architect to engineer Logical model and engineered the physical model with Erwin
- Engaged with DBA Team while deploying Data Warehouse inclusive Masters, ODS, DDS, ADS & reporting Layer.
- Designed & Developed various Source system interface using Informatica Powercenter 9.1/8.6 Suite.
- Developed numerous Informatica Mappings using various Transformations like expressions, filters, lookups, router, update strategy transformations and many more.
- Developed Worked on CLM (CDW Load Management) Framework, which automate the data load processes with minimal intervention.
- CLM Framework developed using Complex UNIX Scripts, Oracle Packages and Job Schedulers (Autosys).
- Worked with PL/SQL Stored Procedure/Function/Packages to develop CLM Framework
- Worked with XML files and Flat files.
- Extensively worked with Web Development team to design and developed Front End Application
- Worked in designing and developing Business Object Universe that meets Reporting Requirement.
- Developed several Web Intelligence Reports that allow Users to perform Quality Check.
- Worked on Crystal Report development which are used to Submit Federal & State Reports.
- Currently engaged in Operation team that supports & Maintain Aggregate Spend Application.
- Also working on Service Enhancements which fits Users needs.
Education
Master of Science - Mechanical Engineering
Wayne State University
01.2008
Skills
- Software: Informatica 10x, 9x, 8x, SSIS, IICS, Erwin, MS Project, MS Visio, Auto sys, Toad, WinScp, Putty
- Investment Tool: Neoxam Data Hub
- Data tools: Microsoft Excel, Words, Outlook, Reporting and Auditing
- Soft skills: Personnel management, training new talent, customer relationships
Timeline
Sr. Software Engineer
The Guardian Life Insurance Company of America
06.2021 - 06.2025
Sr. Software Engineer (Investment Department)
The Guardian Life Insurance Company of America
09.2018 - 06.2021
Informatica Consultant
Wells Fargo
02.2018 - 09.2018
Informatica Developer
The Guardian Life Insurance Company of America
01.2017 - 01.2018
Sr. ETL Informatica Developer
Prudential Insurance Company of America
01.2016 - 12.2016
Sr. ETL Informatica Developer
The Guardian Life Insurance Company of America
10.2013 - 12.2015
Sr. Informatica Consultant
Exelon Corporation
04.2012 - 10.2013
Data Warehouse Consultant
AstraZeneca Pharmaceuticals LP
10.2009 - 04.2012
Master of Science - Mechanical Engineering
Wayne State University