Download PDF

Work History

Senior Etl Developer

  • Coordinated with ETL team to implement all ETL procedures for all new projects and maintain effective awareness of all production activities according to required standards and provide support to all existing applications. 
  • Performed tests and validate all data flows and prepare all ETL processes according to business requirements and incorporate all business requirements into all design specifications
  • Maintained application codes, scripts and reports to the central repository (SVN tool).  
  • Responsible for Business Analysis and Requirements Collection.
  • Worked on Informatica /Medical Intelligence (MI) tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
  • Parsed high-level design specification to simple ETL coding and mapping standards.
  • Designed and customized data models for Data warehouse supporting data from multiple sources on real time
  • Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
  • Created mapping documents to outline data flow from sources to targets.
  • Involved in Dimensional modelling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
  • Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
  • Maintained stored definitions, transformation rules and targets definitions using MI repository Manager.
  • Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the MI Designer.
  • Developed mapping parameters and variables to support SQL override.
  • Extensively used SQL* loader to load data from flat files to the database tables in Oracle.

Accomplishments:

Worked with Medical, Provider and Enterprise Intelligence for functional and technical Analysis and configured performance management using out of the box solution.  §  Developed MI programs, Automation, Workset, Pages and iViews.

Environment and Tools:

Informatica PowerCentre, Workflow Manager, Workflow Monitor, Medical Intelligence 6.4/6.3, Data Analyzer 8.1, PL/SQL, Oracle 10g/9i, SQL Server 2008, Sybase, UNIX AIX, Toad 9.0, Cognos 8.

Etl Developer

  • Integrated data analysis and test reporting applications to the in-house central dashboard application developed. Prepared test cases and executed test scripts.
  • Using Informatica Power Center/ MI Designer analyzed the source data to Extract & Transform from various source systems(oracle 10g,DB2,SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports.
  • Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration tools
  • Created and Configured Workflows and Sessions to transport the data to target warehouse Oracle tables using MI Repository Manager.
  • Involved in Unit, Integration, System, and Performance testing levels.
  • Optimized the performance of the mappings by various tests on sources, targets and transformations
  • Scheduling the sessions to extract, transform and load data in to warehouse database on Business requirements.
  • Developed mappings in MI to load the data including facts and dimensions from various sources into the Data Warehouse, using different transformations like Source Qualifier, JAVA, Expression, Lookup, Aggregate, Update Strategy and Joiner.
  • Maintained application codes, scripts and reports to the central repository (SVN tool).  
  • Developed Java xml MIMiX protocol parser and implemented xml file "Pusher" and "Receiver" by using JSF, JavaScript, XML and JDBC

Accomplishments:

Worked as a team lead for more than 1.5 years and handled major clients like ‘Core Source’, ‘Wal-Mart’, 'Accenture' and ‘Tower’s Watson’ and Payors like 'Cigna', 'Aetna' and 'Mercer'

Worked with Business Intelligence staff to identify, create, and deliver the architecture, systems and software to improve the efficiency and accuracy of end user reports.

Environment and Tools:

Windows XP/NT, MI 6.1/5.9, UNIX, Oracle 11g, Oracle Data Integrator, SQL, PL/SQL, SQL Developer, Oracle Designer, MS VISIO, Informatica MDM

 

SOFTWARE IMPLEMENTATION OFFICER

  • Involved in development and Implementation of Web based Revenue Accounting System developed for Inland Revenue Department of Nepal and security modules in various databases.  (Major Tools Used: Oracle 10g, PHP , MySql )
  • Creation of forms related to the user management in database using forms 6i.
  • Creation of PL/SQL various package, procedure & function to implement different business logic.
  • Responsible for the smooth operation of Revenue Accounting System (Window based)

Accomplishments

Lead a group of developers in migration of Forms 6i to 10g and migration of database.

OLAP Migration, Provide technical support to users, management of RAS database of 22 IROs and central DB and generation of reports as required by the management

Oracle Hyperion

Environment and Tools:

Windows Server 2003, Window XP, Oracle 9i & 10g, SQL Server 2008, Vertica, Toad, VNC, Team Viewer, Dream weaver, Visual Studio 2008,  OAM-PM, MI

Education

Certifications

Verisk Information Technology

Jan 2014Present

Java


Symbiosis Concern Pvt. Ltd

Jan 2012Jul 2012

Oracle 10g – Workshop I

Aptech

Mar 2010Jun 2010

PHP, MYSQL

SSI

Apr 2008Aug 2008

ORACLE 9i  -SQL, PLSQL

Skills

MEDICAL INTELLIGENCE ▪ POWER SYSTEM ▪ ANALYTICS

  • Transformed the business of healthcare by providing data services, analytics, and advanced technologies that answer the healthcare industry’s most complex challenges
  • Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
  • Strong experience in Dimensional Modeling using Star and Snow Flake Schema
  • Designed, developed, coded, debugged and tested various client specific and generic, data analysis and test reporting applications
  • Integrated data analysis and test reporting applications to the in-house central dashboard application developed. Prepared test cases and executed test scripts.
  • Expertise in working with relational databases such as Oracle 11g/10g/9i/8x, SQL Server 2008/2005, DB2 8.0/7.0, UDB, MS Access and Teradata.
  • Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL.

 

SUMMARY OF QUALIFICATIONS

SUMMARY OF QUALIFICATIONS

  • 8+ years of IT experience in the Analysis, Design, Development, Testing and Implementation of MI systems for Health care.
  • Strong experience in the Analysis, design, development, testing and Implementation of MI solutions using Data Warehouse/Data Mart Design, ETL, OLAP, MI, Client/Server applications.
  • Highly skilled and knowledge of Linux/Unix and Windows Environment.
  • Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.
  • Experienced in ETL processing in Vertica System. and assisted in automation tasks to smooth-en processes

 

Text Section