Experience

SUNY Downstate Medical Center
• United States
• Medical Practices
• 1 - 100 Employee
• Sr. Programmer Analyst

  • Feb 2016 - Present


Health Republic Insurance of New York

• United States
• Insurance
• 1 - 100 Employee

• Data Warehouse/Business Intelligence Developer

  • May 2014 - Jan 2016

  Design, develop, and maintain Enterprise Data Warehouse. Develop database procedures, transformations, integrations, and queries to access and transform data. Create ETL processes to import and synchronize data received from vendors. Use ETL and SQL technologies to prepare data for business intelligence applications and reporting tools. Create data models to support applications and reporting. Strong skills in data comparison and data profiling. Think strategically and consider best practices when developing to ensure maximum reusability, supportability, and performance. Debug and troubleshoot issues and implement fixes Participate in the business analysis process, conduct data quality investigations, and assist in the development of test plans and test data. Possess excellent technical/business communication skills to interact with both IT & business teams for understanding requirements to develop and deploy appropriate data solutions. Understand and experience in applying SDLC processes. • Project leader of development team for design and implementation of APD State Database, uniquely tailored to Encounter Intake System (EIS) requirements • Prepare and maintain the documentation required for creating, testing, and support of Post Adjudicated Claims Data Reporting (PACDR) transactions for APD • Work closely with data vendors, EDI vendor and APD team to break down business requirements into functional requirements in order to support APD data submissions • Contributed to the design and programming of processes used to validate and import data from claim data files into the APD Professional, Institutional and NCPDP files • Promoted by APD team to submit 298, 299 and NCPDP files to State Database o Develop and maintain reports using Business Intelligence tool like MicroStrategy Developer o Designed and implemented data extracts and worked with business team and vendors on the PNDS, HIDE, DFS Member Survey, CSR Claims reports Show less



HealthPlus/Amerigroup Inc. /Well Point

• ITS Application Development, Senior Programmer Analyst

  • Mar 2001 - May 2013

  Researched, designed, developed, documented, tested, and implemented automated processes to advance new and modified enterprise applications. Created multiple GUI applications utilizing Visual Basic/.Net programming languages. Produced and supported numerous Business Objects/SSRS reports which are used for monitoring and maintaining membership flow through MemberPro membership system processes. • Key Member of development team for design and implementation of the MemberPro membership system, uniquely tailored to New York state-funded program requirements • Designed and programmed various mission critical interfaces with claims system (MemberPro-to-Facets, VisualCactus-to-Facets) that support full membership and provider data loads, and maintained that data on an ongoing basis. • Created monthly PCP Auto Assignment process that assigns PCPs to all currently active members. The PCP Auto Assignment process was included in the Corporate Action Plan. • Created ETL processes to convert and synchronize membership from AmeriGroup and WellPoint mergers (Empire Blue Cross Child Health Plus business), migrating this new business to Health Plus systems. • Designed and implemented reports used by management to make business decisions by identifying and understanding operational data Show less



A & R Info Tech Solutions Inc

• Programmer Analyst, Web Developer

  • Jun 1999 - Feb 2001

  Designed, developed, tested, and implemented new database and web products, including ASP pages, COM objects. Created supportive technical documentation and conducted unit, integration, and system testing. Developed Advertising Management System, providing a leading edge e-business solution for the Company. Designed, developed, tested, and implemented new database and web products, including ASP pages, COM objects. Created supportive technical documentation and conducted unit, integration, and system testing. Developed Advertising Management System, providing a leading edge e-business solution for the Company.



ASA Technologies

• Pakistan
• Software Development
• 1 - 100 Employee

• Database/Web Developer

  • Sep 1997 - Jul 1999

  Developed web-based Human Resources applications utilizing ASP, VB 6.0, T-SQL, XML technologies. Created stored procedures, participated in database logical and physical design, data loading and data manipulation. Designed and implemented COM objects. Participated in meetings with clients and produced development estimates based on clients’ needs Key development team member for Employee Assistance Program, a new system supporting accurately tracking of employee qualification and status, and providing information management capability to Human Resources in a progressive working environment. Show less



Promstroy Bank

• Programmer Analyst

  • Aug 1994 - May 1996

  Analyzed, designed, and developed component-based technical solutions. Developed and implemented information security procedures. Analyzed, designed, and developed component-based technical solutions. Developed and implemented information security procedures.