Pooja Bhatia

**** ************* ***, *********, ** 02138 857-***-**** ac0iev@r.postjobfree.com https://www.linkedin.com/in/poojasidhani/ EDUCATION

University of Mumbai, Mumbai, India June 2011

Bachelor of Engineering, Information Technology

CERTIFICATIONS

HL7 2.7 January 2013

TECHNOLOGY SUMMARY

Databases: Microsoft SQL Server 2008/2012/2014

EIM Tools: Informatica MDM 9.7.1, IDD, SIF

Application Server: Jboss EAP 6

Data Warehousing Tools: Informatica Powercenter 9, Microsoft SSIS 2008/2012, SSRS, SSAS

Source control Tools: Git, TFS, VSS

Job scheduler: SQL Agent, Visual Cron

PROFESSIONAL EXPERIENCE

CitiusTech Inc, Princeton, NJ Oct 2011 – Present

Navinet/ Nanthealth, Boston, MA Jul 2014 – Present Technical Lead

Designed and developed SSIS package as per requirement specification for various source systems (flat files, databases) to standardize different trading partners data to a common source-agnostic data model which can be fed to MDM HUB to consolidate to a single BVT record (Best value of truth) for all entities and provider’s data

Configured and installed Informatica MDM Hub server, cleanse Server, resource kit in Development, QA, Pre- Prod and Prod Environments

Defined the Base objects, staging tables, foreign key relationships, lookups, Mappings, delta detection setting, cleanse lists and custom cleanse functions, queries and packages for different trading partners as per business requirements

Configured Address Doctor which can cleanse US address Data and enhanced by making some modifications to the cleanse functions

Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master data.

Used Metadata manager for validating, promoting, importing and exporting repositories from development environment to testing

Presented analysis on the MDM upgrade options and worked on the hotfix upgrades

Researched and implemented batch process for automated MDM hub and database objects deployment

Analyzed the source system for integrity issues to the data resided in various source systems and reported the same to business by means of DQ Analyzer

Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Data steward, Client team, Development team, Capacity planning and Up gradation of System Configuration

Designed and implemented the Visual Cron job for daily, weekly and monthly jobs

Involved in production support, resolving and documenting the issues related to jobs, data integrity and match-merge process

Handled Performance Tuning and Optimization on SSIS, with strong analytical and troubleshooting skills for quick issue resolution in Prod-parallel Perf environment.

Diagnosed MDM server and cleanse logs & JBoss logs in order to resolve any connection pool or database connectivity issues and provided resolution for the same

Performed security tasks like Grant, Revoke permissions for security tasks

Conducted peer code reviews and owned release and supporting documentation

Responsible for Onshore-Offshore coordination and mentoring the implementation team

Created Unit Test Case Document, Technical Design Document and Knowledge Transfer Document

Environment: Informatica Multidomain MDM 9.7.1, JBoss EAP 6.1, Microsoft SQL 2012, Address Doctor 5, IDD, SIF, SSIS 2012, Windows Server 2012

The Schumacher Group Oct 2011 – Mar 2014

BI Developer

Implementation and delivery of MSBI platform solutions to develop and deploy ETL, analytical, reporting and scorecard / dashboards on SQL Server 2008 using SSAS, SSIS, SSRS.

Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.

Created complex SQL stored procedures and functions and views and implemented best practices to maintain optimal performance

Worked on optimization of SQL Stored procedures and parallelizing the ETL workflow to reduce job duration

Developed Informatica Powercenter ETL mappings/ workflow for new source systems as well migrated existing source SSIS packages

Developed various SSRS reports and worked on mechanism to deliver these reports to business users both on a regular pre-set schedule or in case if any alarming situation

Involved in configuring and querying SSAS cube and adding calculated measures to the provider/facility dashboards

Worked on the release and migration for SSIS packages as well Informatica mappings and workflows to QA/ Prod environment

Provided production support for the scheduled jobs and resolved any issues with high priority in order to move the job forward.

Used SQL Profiler for Performance monitor to resolve Dead Locks and Long running queries by checking appropriate changes to Transaction Isolation levels

Designed and developed the data transfer mechanism from Production SQL server to EC2 Cloud server via bcp process and later replaced this approach by database log shipping process Environment: Informatica Powercenter 9, Microsoft SQL 2008R2/2012, SSIS, SSRS, SSAS, Windows Server 2008/2012

Contact this candidate