Extensive development involving Informatica Power Center 9.5, SQL Server 2008/2012, and SQL Server Reporting Services
Designs and Develops Data mart to handle Provider data
Creates Exclusion Reports with SSRS for all the fallout providers
Uses Informatica B2B HIPAA library and XML transformations to process 837P, 837D and 837I format files
Tests Informatica mappings and tune them for better performance
Develops SQL queries for loading and validating data
Automates Provider Network File process using Tidal
Troubleshoots and performs tuning of existing SQL queries.
Designs and develops directories and exclusion reports using SQL Server 2012, MS SQL BI tools and Informatica Power Center 9.5
Creates test cases and unit test the data.
Develops relationships with the business to better understand business requirements.
Analyzes and classifies complex change request and identifies and documents possible enhancements.
Participates in developing application scope and objectives and preparing functional and/or technical specifications.
Aids graphic designers and other web team members to better understand and apply the right marketing focused content.
Codes and maintains complex components of information systems.
Develops and performs system testing and fixes defects identified during testing and re-executes unit tests to validate results.
Participates in integrating activities with other IT departments for successful implementation and support of project efforts.
Provides on call support and monitors the system. Facilitates small group design sessions or code reviews and participates in vendor evaluation.
