Vinay Pendam

Experience

• 

  Wilkes University

  Sept 2007 - Dec 2008

  Graduate Assistant

  Worked for Division of Engineering and Physics

• 

  ETeam

  Apr 2010 - Aug 2013

  Programmer Analyst

  Worked as a consultant/contractor at different client locations, collaborating with their in-house employees to deliver industry-specific solutions on time and on budget. * Worked with project managers, subject matters experts, business data analysts, and other developers to understand and validate end-user requirements in accordance with business needs. * Solicited business and functional requirements through interviews, meetings, JAD sessions with business users and SME's, and by studying the existing documentation. * Designed and Developed logical and physical data models using ERwin tool. (Kimball Approach, Star schema, and Snowflake schema) * Designed, Developed and Tested various ETL processes (Interfaces, Procedures, Packages, Scenarios, Knowledge Modules etc..) using Oracle Data Integrator tool(Designer, Operator, Security Manager, Topology Manager, Jython). * Coordinated with the reporting teams and helped them redesign, develop and test the Physical layer, Business layer, and Presentation layer in OBIEE. * Build reports per end-user specifications in SAP Business Objects. * Did extensive data profiling using DataFlux dfPower Studio. (Redundant data analysis, Pattern frequency distribution, PK/FK analysis etc..)Environment/Skillset/Tools: * RDBMS: Oracle 11g/10g/9i/8i, Teradata V2R6/V2R5, DB2 8.0, MS Access 7.0/2000 * DW/ETL: Oracle Data Integrator 11.1/10.1.3, Informatica Powercenter 9.1/8.x * BI: Business Objects XI R2-R1, SAP Business Objects 4.0/3.1, OBIEE 10.1.3.4 * Languages: SQL, PLSQL, Perl, Jython, Python. * DataModeling: CA ERwin Data Modeler 9.5/7.2, Visio, Oracle Designer Show less

• 

  Spectrum Health

  Aug 2013 - Feb 2023

  I have direct responsibility for ensuring the successful day-to-day operational activities of the Enterprise Information Management Support and Enhancements team consisting of 7+ software developers including data modelers, ETL, and business intelligence developers. * Responsible for monitoring and prioritizing incidents and requests across EIM specific data warehouse and business intelligence related support queues. * Maintain and deliver metrics on work completed and assure documentation updates occur for proper support handoffs. * Work with workgroup leads and business analysts to monitor cost, schedule and technical performance of component projects and operation; plan and evaluate contracted services. Show less Worked as a Lead Developer on the Pharmacy Benefit Manager Replacement project. * Performed impact analysis to identify code and reports for proper remediation. * Worked with the business customers and end users to Identify defects and limitations with existing PBM * Designed and Developed code to ensure that the existing defects do not repeat with the implementation of the new PBM * Designed, Developed and Documented the process, to receive CMS standard post adjudicated claims file for commercial, Medicaid and Medicare claims and to integrate them into the data warehouse as per business needs. Show less * Worked on DW support team - Responsibilities included troubleshooting customized integrations written primarily using PL/SQL and Adding enhancements to existing systems; Supporting production systems by helping resolve problems, providing timely follow-up on problem report, optimizing performance and streamlining processes. * Worked on the integration of the fully funded dental product into the data warehouse. * Worked on the implementation of a new vendor application (SmartQuote) to support the Priority Health group underwriting process, which replaced the mid/large group underwriting department rating and workflow tools. * Worked on adding enhancements to existing ASO (Administrative Services Only) reporting adding logic necessary to handle LFO (Level Funding Option) changes. Show less

  • Manager, Information Services

    Dec 2018 - Feb 2023

  • Supervisor, Information Services

    May 2015 - Dec 2018

  • Application Development Analyst, Sr

    Nov 2014 - May 2015

  • Application Development Analyst

    Aug 2013 - Nov 2014
• 

  Corewell Health

  Jan 2023 - now

  Manager, Digital Services