Data Project
Resume:
Career Objective:
To gain expertise in the major Processes and Technologies in Information
Technology to constantly grow with the organization. Thirst for knowledge
and the essential interpersonal skills facilitate progress in this
direction.
Profile Description:
Seasoned IT professional with 8+ years of experience encompassing a wide
range of skill sets, roles and responsibilities. Extensive experience with
Requirement gathering, Analysis, Research, Design, Documentation,
Development, Customization, Implementation, Testing and Support of software
applications in Master Data Management (MDM) and Data Warehousing.
Summary
* Good knowledge in Life Sciences, Insurance, Pharma and Healthcare
industry
* Deep understanding and vast experience in the area of MDM (Master Data
Management), Hierarchy Management, Data Governance, CDI (Customer Data
Integration), BI (Business Intelligence), CRM, Business Consulting,
Data Analysis
* Technical skills primarily include (but not limited to) Informatica
MDM( formerly Siperian), Informatica Data Director, Informatica B2B
Data Transformation, Informatica Data Quality, Informatica PowerCenter
* Strong knowledge and experience in Java, J2EE, JSP, Servlets, Web
Services
* Proficient with the installation, configuration and upgrades of
Informatica suite of products
* Conversant with software development life cycle (SDLC) implementing
methodologies like waterfall and agile
* Strengths: A good team player, Quick decision maker, Proactive, Fast
Learner, Drive to excel, Hardworking, Problem Solving skills,
Flexibility to work within domains, Excellent communication skills
Professional Experience:
Ojasin LLC January 2014 to Till Date
Informatica Corporation November 2011 to April 2013
Headstrong Services April 2010 to October 2011
Accenture Services March 2009 to March 2010
Cognizant Technology Solutions October 2006 to Feb 2009
Technical Skills:
Operating Systems Windows, Unix, Linux
Programming Java, J2EE, JSP, Servlet, Web Services, PL/SQL
Languages
Tools Informatica MDM(formerly Siperian), Informatica PowerCenter,
Informatica B2B Data Transformation, Informatica Data
Quality, Address Doctor, Eclipse IDE
DBMS Oracle, SQL Server, MySQL, PostgreSQL
Application Server Weblogic, Websphere, Tomcat, JBoss
Academics:
B.Tech. (Electronics and M.I.E.T, Meerut (Uttar Pradesh Technical 2006
Communication) University), India
Class XII City Vocational Public School, Meerut, 2002
India
Class X City Vocational Public School, Meerut, 2000
India
Relevant Project Experiences:
Project Name GeoData Analytics
Organization Ojasin LLC
Duration January 2014 to Till Role Senior Software Engineer
Date
Project Our client sells a software that creates powerful location based
Synopsis analysis and exploration with CMaps Analytics Designer that can
be embedded into any business App. This project involved writing
Java-based services for internal as well as external consumption.
The Java Services include functions like making shapefiles,
calculating drive time, creating and caching geocodes for
searches, etc.
Activities Requirement gathering
Domain Understanding and Research - Identifying the key problem
areas and key entities
Data Modeling
MDM Design and Development including MDM Hub, Hierarchy Manager,
Workflow, Reporting, Customization, ETL Mappings, DQ Mappings,
B2B, Address Doctor
Custom UI development, Google Charts Dashboard implementation,
Java User exits coding for additional features in IDD Workflow
Web Services Development
System Integration and Testing
Documentation
Technology & Amazon EC2, MDM, Tomcat, PostgreSQL, MySQL, Java, J2EE, Restful
Tools Web Services, JSON
Project Name Industry Solutions Development
Organization Informatica Corporation
Duration November 2011 to April Role Senior Software Engineer- Industry
2013 Solutions, MDM R&D
Project Industry Solution is a set of artifacts and messaging collaterals
Synopsis that can be used to help build the sales pipeline, accelerate
sales and streamline implementations. The Industry solutions are
not only primarily based on MDM, but also include integration
with Informatica Platform. Solutions implemented :
Pharma R&D - Clinical Trials & Compound Master
Generic Customer Master
Insurance Data Management
HealthCare Data Management Solution
Activities Requirement gathering from Sales, Marketing, Partners and
Professional Services
Domain Understanding and Research - Identifying the key problem
areas and key entities
Data Modelling
Solution Design and Development including MDM Hub, IDD, Workflow,
Reporting, Customization, ETL Mappings, DQ Mappings, B2B, Address
Doctor
Custom UI development, Google Charts Dashboard implementation,
Java User exits coding for additional features in IDD Workflow
Search and gather domain specific public and authentic real world
data
System Integration and Testing
Documentation and Demos
Enabling and Supporting Sales, Marketing, Partners, Informatica
Professional Services
Further releases of Solutions depending on the feedback from
stakeholders and Customers
Technology & Amazon EC2, Informatica MDM, Informatica Platform, Weblogic,
Tools Oracle, Java, J2EE
Project Name MFG - Institutional Sales Dashboard
Organization Headstrong Services
Duration July 2011 to Till Date Role ETL Designer/Developer and Data
Analyst
Project The Institutional Sales Dashboard is a scalable and highly
Synopsis interactive tool being built to provide the sales organization
with the metrics needed to analyze its customer relationships and
organizational performance. By capturing trade level details and
creating/maintaining relationships to associated Client, Product,
Location and Time dimensions, it is possible to create a wide
variety of aggregations and drill-downs. The dashboard will
depict indicative information as relative size of client
relationships, revenue generated by client, revenue generated by
asset class and sub-product, performance of the sales
organization at an aggregate and in relative terms, top revenue
generating deals
Activities Requirement gathering and Data volume/content analysis
Designing and developing of Data Mart and ETL Layer
Performing Unit Testing and System Testing
Technology & Informatica PowerCenter 8.6.0, Oracle 10g, Tidal
Tools
Project Name State Street Corporation : Entity Management System
Organization Headstrong Services
Duration March 2011 to June Role Senior Siperian Developer
2011
Project State Street uses Siperian MDM to maintain Counterparty data for
Synopsis Compliance and Risk assessment. Siperian MDM has helped State
Street in improving capital efficiency and gaining more
visibility into managing risks (in order to decrease exposure to
unseen, miscalculated credit and operational risks). By
maintaining a trustworthy master reference data management hub,
State Street is able to control reference data counterparties.
Siperian is used as a MDM tool to create a fresh Hub holding
Asset, Broker and Counterparty data. Business Data Director is
used for robust Data Governance capabilities for the
counter-party, broker and securities maintenance. The hub is also
used for hierarchy management of broker-dealers.
Activities Requirement gathering, analysis and designing data model for the
new source systems
Creating a BDD application as per the client's requirement on top
of the ORS data model.
Custom coding in java for validations in BDD using BDD user exits
as the functionality was not provided from Configuration tool
Configuring Hierarchy manager (HM), batch groups to load the data
into the EMS.
Working with Client team directly to get the requirements and
provide solutions
Worked on upgrade of Siperian XU to Informatica MDM 9.0.1 and
applying hotfixes
Technology & Siperian XU, Services Integration Framework (SIF), Oracle 10g
Tools
Project Name MF Gobal - Core Foundation Services
Organization Headstrong Services
Duration August 2010 to March Role ETL Designer and Developer
2011
Project MFG - Core Foundation Services project is intended to provide a
Synopsis consistent version of operational data to the risk, finance, SC&R
groups of MF Global. Asset classes covered will be Fixed Income,
Equities, Forex, OTC Derivatives, Futures and Options. This will
be achieved by creation of an operational data store and a data
warehouse. In order to support this, a common reference data
store will be created storing customer, account, entity, security
master and related data. Adequate data quality and identify and
access mechanisms will be created to ensure data integrity and
security aspects.
Activities Requirement gathering, analysis and creating design and mapping
documents for new source systems added to Data Warehouse.
Designing and developing complex mappings to load data from
source systems to the Data Warehouse.
Writing Unix Scripts, PL/SQL procedures and batch scheduling
using Tidal.
Performing Unit Testing and System Testing
Leading a team of four people
Technology & Informatica PowerCenter 8.6.0, Informatica B2B, Oracle 10g,
Tools Tidal, Quality Center
Project Name RBC Sophis- Database Management System
Organization Headstrong Services
Duration April 2010 to July Role Senior Software Engineer
2010
Project RBCCM business uses Sophis Risqu V 5.2.7.4 to manage the
Synopsis Proprietary trading lifecycle management across all asset classes
including Fixed Income, Commodities, Equity, Equity Derivatives,
Interest Rate products and FX. Due to huge data and poor design
RBC is facing performance issues on Sophis database which slows
down more critical operations of reporting. For this RBCCM
decided to build a Data Mart for reporting requirements which
will improve the performance of the system and further streamline
the reporting process for enhanced performance.
Activities Analysis of Sophis database and mapping of Reports with the
Sophis database.
Designing of Data Mart, ETL Layer and Reporting layer
Building Loaders (From Staging to Data Mart) and De-Loaders (From
Data Mart to Reporting Layer) for Data Mart and Reporting
database respectively
Performing Unit Testing and System Testing
Technology & SQL Server 2005
Tools
Project Name BMS Credo - Customer Master Exchange Hub
Organization Accenture Services
Duration March 2009 to March Role Senior Siperian Developer
2010
Project The Customer Master Exchange Hub is a system that prepares
Synopsis Customer information from one or more sources to create one
customer profile to serve as a central repository for BMS
customer data. The system performs the following functions: Data
Load, Vendor Data Tracking, Data Transformation, Data Scrub and
Standardization, Matching, Merging and Publishing data for
External Systems.
Activities Version upgrading from Siperian XT to XU SP2 Patch B and metadata
errors fixing
Siperian Administration tasks like Creating Users, Creating ORS
and Code Migration
Creating ETL designs for 3 new sources added to the CMEH
Implementation of Data Model in Siperian Hub
Defining and Configuring Cleanse rules, & Merge rules, Trust
settings, Queries and Packages
Performing Unit Testing and System Testing
Mentoring team members in developing Siperian skills
Technology & Siperian CDI Hub, Oracle, Informatica Powercenter 8.6.0
Tools
Achievements Awarded "Celebrating Performance Award" for Organizing and
Directing Quality Work Efforts
Project Name Pfizer Worldwide Pharmaceutical Operations (WPO) MDM
Implementation
Organization Cognizant Technology Solutions
Duration February 2008 to Role Siperian Developer
February 2009
Project This project is an extension of the Pfizer MDM WW project
Synopsis mentioned below. Pfizer has taken an initiative to create a
global data hub with the customers of Pfizer entities all over
the world. As part of this global initiative, data hub for all
US entities has been implemented. Currently, the process of
implementing the same concept for all Pfizer enterprises in
Europe and Canada (EuCAN) has been initiated in Pfizer WPO
Europe. To minimize the risk of such a vast implementation it has
been decided to take a multi wave implementation approach -
breaking down the entire scope into groups of countries. This
project involved the development of Master Data for Customer
Class and Product Class using Siperian Hub XT.
Activities Implementation of Data Model in Informatica and Siperian Hub
Configuring Cleanse rules, & Merge rules, Trust settings, Queries
and Packages
Exporting, Importing and deploying of Siperian and Oracle
database
Creating custom component for downgrade of trust in base object
and outbound publish
Designing and validation of the scheduling script for Pfizer
EUCan
Preparing test cases and performing Unit, System and Integration
Testing
Production support post project implementation
Technology & Siperian CDI Hub, Oracle, Informatica, SQL* Plus, SQL Developer,
Tools Unix, Mercury Quality Centre
Achievements Received client and senior management appreciation mails for
"Excellent" performance
Project Name Pfizer MDM WorldWide
Organization Cognizant Technology Solutions
Duration September 2007 to Role Siperian Developer
January 2008
Project This project aims to provide Master Data Maintenance on a varied
Synopsis set of master entities to the organization. For each entity, the
system will receive the information from its source systems. The
MDM application will cleanse the data and keep a unique copy of
the master entity. The system also controls any exception
activity which may occur while processing the data from the
source system.
The Master Data Management project includes development,
enhancement and maintenance of Identity (Employee, contractor)
Master, Customer Master, Product Master and Territory Master
using Siperian MRM.
Activities Implementation of Data Model in Siperian Hub
Configuring Cleanse rules, Match & Merge rules, Trust settings,
Queries and Packages
Exporting, Importing and deploying of Siperian and Oracle
database
Creating custom component for downgrade of trust in base object
and outbound publish
Preparing test cases and performing Unit, System and Integration
Testing
Production support post project implementation
Technology Siperian CDI Hub, Oracle, Informatica, SQL* Plus, SQL Developer,
Unix, Mercury Quality Centre
Achievements Awarded "CSP Appreciation Award" for "Hard work, dedication &
contribution to Siperian CoE & Pfizer MDM projects"
Received client and senior management appreciation mails for
Extraordinary performance
Project Name HealthCare Provider Master Support
Organization Cognizant Technology Solutions
Duration January 2007 to August Role Siperian Developer
2007
Project This project deals with HCPM components of the overall Healthcare
Synopsis Law Compliance (HLC) Solution. HCPM component for Pfizer is to
provide an Operational Reference Store of HealthCare Providers
(HCP) to be used in conjunction with
Master store of transactional data relating to the HCP population
Flexible reporting engine for satisfying current and anticipated
legal requirements in compliance with aggregate HCP spending
limits on a state-by-state basis
This project is a Support and Maintenance Project which aims at
incorporating one more source to the existing system plus
devising ways to develop various rules according to which the
records are consolidated based on client requirements. Also, this
project aims at automating download of lists of excluded people
and automatically converting the file from dbf format to the csv
format.
Activities Understanding and mapping the overall business process to the
system requirements
Conducting POCs for the application and translating them to
system requirements
Preparing test cases during the different cycles of testing
Performing Unit, System and Integration Testing
Technology Siperian Hub, Oracle, Informatica PowerCenter, SQL* Plus, SQL
Developer, Unix
Achievements Received appreciation mails from Project Manager for Good
performance
I hereby certify that the above information is true and correct to the best
of my knowledge and belief.
Monika Soam
Contact this candidate