Architecture and Technology
=====================
Cloud Computing with Amazon Web Services
Database Design ( Relational, STAR Schema, Column/Column Family,Key Value Pair DB Design)
Database Administration of Oracle/ Real Application Clusters 10g 11g R1 & SQL Server 6.5, 7.0, 2000, 2008, 2008 R2
Logical and Physical Database Design of Very Large Databases in Healthcare Industry
Oracle 10g/11g & SQL Server Advanced Performance Tuning
Database Sharding and Distributed Database Systems
Oracle RAC/Oracle Exadata
Enterprise Data warehouse Design in Healthcare Industry
Delphi Programming
ASP Programming
J2EE Programming
RIA Programming (Jespresso)
Grails/Groovy Programming
C, FORTRAN, C++
Transactional Banking System Design
EHR/EMR system(HL7 CDA, OpenEHR)
Specialties
========
SQL Server Programming & Administration (MSSQL, SSIS, SSRS & SSAS)
Oracle (RAC) Programming & Administration
MySQL
Postgres SQL
Greenplum
Vertica
MPP & Shared Nothing Database Design
Database Modeling
Data Warehousing and Data Mining
Master Data Management
Oracle Performance Tuning
Enterprise Java Programming (JSF,EJB3 & Seam)
Restful Web Services,
Android Programming,
NoSQL- HADOOP/HBASE, Apache Pig, Apache Chukwa, Hive, MongoDB, Neo4J, DynamoDB, Cassandra, Hive
MapReduce,
Java Design Patterns
C# .NET Programming
Linux
Windows
AIX
EMC SAN
Oracle Data Integrator (Programming, Administration)
Golden Gate (Programming, Administration)
Cascading
Database Design, Relational DB, Star Schema, Key Attribute DB design, Metadata Driven Design
Realtime Data Warehousing using Change Data Capture and Journaling (ORACLE, SQL Sever)
SQL Server Reporting Services
Jasper soft
Pentaho
Tableau
Ant
Maven
Groovy/Grails
Jspresso
Data Architect @ From September 2014 to Present (1 year 3 months) Principal @ Realtime Data Integration using SQL Server CDC and Oracle Data Integrator in Exadata Environment using SIF data From January 2014 to August 2014 (8 months) Director, Data & Analytics @ * Client visit and JAD sessions
* Design, Develop & Implement Data Warehouse for Healthplans.
* Team management
* Real time data warehousing
* Implement Data as a Service
* RFPs
* Client Communication
* Reporting and Advanced Analytics.
* HEDIS, P4P Certification
* Worked with Medicare Advantage Plans, CRM, Enrollment, Claims, Billing, Commissions data From August 2011 to January 2014 (2 years 6 months) Director of Engineering @ * Migrate SQL Server environment to multi node Oracle RAC environment
* Automate and Optimize Very Large Healthcare Multitenant Database for data integration, aggregation, reporting and data mining routines
* Manage and develop, advanced healthcare analytics software for payers, brokers and providers for financial and clinical analysis.
* Team management
* Performance tuning of very large database
* Expertise in highly scalable distributed database systems such as Greenplum & Vertica
* HEDIS and HEDIS like measures From January 2005 to November 2011 (6 years 11 months) Principal Software Engineer @ * Program & automate data acquisition, integration, complex US healthcare rules in SQL Server and Oracle to build data integration, aggregation and analytics platform. From May 2002 to January 2005 (2 years 9 months) Software Developer @ * Member of Banking Software Development team, in Delphi & SQL Server 6.5 & 7
* Member of PumoriPlus banking software implementation team in Nepal, India & Bangladesh
* Architected and developed online banking system using ASP and SQL Server From May 1999 to April 2002 (3 years)
Masters in Software Engineering, Enterprise Software Architecture, Advanced Analytics, A @ Brandeis University From 2010 to 2013 BE, Electrical Engineering, Micro Hydropower & Electrical Distribution System @ Tribhuvan Vishwavidalaya From 1984 to 1998 Omkar Poudel is skilled in: SSIS, Java, C#, Linux, MySQL, Performance Tuning, REST, MapReduce, AIX, Windows, Master Data Management, PostgreSQL, Android, HBase, Vertica