Abinav Chittyala

Senior Etl Developer @Independent Health

Buffalo/Niagara, NY, US

Skills: Informatica Power center 8.x/9.x/10.x, Oracle 9i/10G/11g, DB2, PL / SQL Developer, TOAD, SQL* Loader, UNIX, PL/SQL, XML, SVN, Tidal Scheduler, Kalido MDM, Customer Relations• Designed, developed and optimized complex Informatica workflows consisting on models and mappings from source to target leveraging on different types of ETL transformations, mapping parameters, variables and parameter files to deliver customer needs• Architected solutions for major process failures involving heterogeneous sources & legacy systems, i,e: PBM Data Mart (DM), and Impact Analysis. • Resolved and created backup action plans to minimize business impact in case of failures for vital processes, i.e: Provider Fee Schedules (PFS) part of Data Warehouse, EMPI, Impact Analysis, PPO Pricing, Premium Payment Accounts to HR• Took ownership and collaborated with other technical teams within the organization to ensure successful implementation of company-wide system upgrades/migrations in QA and Production regions, i.e: Transitioning from old EDW to Kalido and Informatica Upgrade from v. 8.x to v. 9.x and v. 9.x to v. 10.x • Collaborated with technical, non-technical, Business Analysts and third-party vendors during development and support cycles to bring ETL projects to completion• Key member in JAD Sessions & Informatica Review Team to ensure ETL best practices. Introduced process improvements plans as needed• Reduced failure probability in production by collaborating with QA Team in developing and executing test plans• Extended knowledge on Health Care industry business models: Managed Care plans such as Medicare, Medicaid, HMO, PPO and POS and Consumer-directed health plans such as HRA, FSA, HAS• Proficient understanding of Health Insurance claims, enrollment, eligibility verification for members and providers, benefit setup, backend payment cycle• Very good team facilitator and good experience in mentoring the other team members wherever necessary.