Friday, April 1, 2016

Guide to Research Data Management Curriculum


Time Series DB
In many of my workshops and class sessions, especially for librarians new to data management, I've been asked about existing research data management (RDM) curriculum and resources. People new to the field want to be able to browse online learning courses, join mailing lists to see what's going on, follow a blog or two. After compiling a few of these lists to serve as handouts, I decided to put them online in a LibGuide for Research Data Management Curriculum. In a way a curated list of these things feels very Yahoo 1990s, but it allows me a place to keep tabs on new curricula, blogs and other resources that I or my coworkers use on a regular basis.

Got any favorite sites/classes/blogs/lists you'd like to see on the list? Put it in the comments and I'll take a look.

Data Management Specialist GENPACT LLC - Bangalore (Bengaluru Area, India)

Database system for time series data
JOB DESCRIPTION

Job Summary/Purpose
Complete ownership of all aspects of projects, including requirements gathering, scoping, estimation, implementation, quality checks. The position involves communication with customers, documentation, providing regular updates to leadership, identifying account mining opportunities. The person could also be required to meet with the customer teams and hence must be open to travel to Europe

Shift Timings: 11:00 am - 7:30 pm (need to be flexible)

Key responsibilities and accountabilities/ Essential Responsibilities:
4 to 8+ years Pharmaceutical industry knowledge -Sales Operations, Sales, Marketing, Field. Candidate must have experience on data driven projects for European businesses. In other words, must possess good knowledge of European Pharma data
Strong Knowledge of third party pharmaceutical sales/script/call details data (MIDAS, Xponent, IMS Data View, longitudinal patient data, Synovate patient data/Quanvert, ATLAS, MI Replica, CAM, A&U)
Hands on experience in projects that summarize, analyze, prepare, present various reports / decks and findings  
Ability to work with large data sources and merge multiple data sets
Project/Client Management experience
Excellent communication skills
Experience in handling issues and suggesting alternatives
Strong business acumen
DESIRED SKILLS & EXPERIENCE

Desired Skills & Experience:
This is a requirement for Data Projects for multiple Pharmaceutical companies in Europe and candidate should have exposure with Data Analytics/ Reporting working on Europe Pharma data.           
           
Qualifications/Requirements:
Bachelor’s Degree (BE or BTech)
Strong programming (SAS / SQL / SPSS /XLS) and data analysis skills
MS Excel, PowerPoint and BI tools (Micro Strategy, Business Objects, etc.) - intermediate to advanced user
Desired Characteristics:

Must possess good and hands on experience / knowledge of European Pharma data
COMPANY DESCRIPTION

Axis a 100% subsidiary of Genpact[ NYSE: “G”], is a specialist risk and compliance firm offering governance and risk consulting services to clients across the globe. Leadership team Comprises ex-Big 4 and IA heads of large public listed corporate. Our ‘ One Global Client Team” philosophy allows us to offer consistent global delivery and unique global bemchmarking for all clients. Genpact is a global leader in business process and technology management. Our entire organization of over 55,000+ employees is focused on process and engaged in improving client processes and driving business impact. We look at process as a science and our proprietary Smart Enterprise Processes (SEP) employs a scientific, highly granular approach to managing business processes. http://bit.ly/durftj Our broad portfolio consists of both enterprise G&A and industry-specific services. Services are seamlessly delivered from a global network of centers in 16 countries to meet a client’s business objectives, cultural and language needs, and cost reduction strategy. Genpact’s culture is uniquely ingrained in Lean Six Sigma and the Company enjoys a rich heritage, tracing its beginnings to 1997, when it was an independent business unit of the General Electric Company (GE). Built from the ground up, the organization was charted to provide business process management capabilities that would deliver outstanding efficiencies to all of GE’s businesses. The company became independent in January 2005, bringing process strength to companies outside of GE, and was successfully listed on the NYSE in August 2007 under the trading symbol ‘G’. Today, the Company manages over 3,000 processes for more than 500 clients world wide. Join Fellow Genpact Employees: http://www.linkedin.com/groupRegistration?gid=110066 Axis Risk Consulting, a 100% subsidiary of Genpact [NYSE:“G”], is a specialist risk and compliance firm offering governance and risk consulting services to clients across the globe. Leadership team comprises ex-Big 4 and IA heads of large public listed corporate. Our “One Global Client Team” philosophy allows us to offer consistent global delivery and unique global benchmarking for all clients.


Export/Import data using data management in AX 7

Time Series database
In this post I will be showing Import/Export using Data management in  AX7. For the purpose of demonstration, I will take example of product categories. 

Product categories are defined in AX can be mapped to Retail category, Procurement category, Sales category etc.

Export of product categories:

Navigate to Data management workspace and create a new export project as shown below:

Click on export.
In export screen:
Set the name of the project: Product categories (this is similar to processing group in AX 2012)
Set Target data format : Excel
Entity name: Product categories
Click on Add entity.
New entity(Product categories) will be added to "Selected files and entity section".

Now our entity is ready for export. 
Click on the "Export" on in the action pane.


Now you have 2 options to download.
Download package or download file.

Download Package:

If you choose this option 3 files will be downloaded:
Manifest.xml -> defines the entity structure
PackageHeader.xml -> defines the entity header
Product categories.xlsx -> actual data 

Download file:

If you choose this option only excel file containing product categories will be downloaded.

Import of Product categories:

We are going to use the same files from export to Import. Navigate to Data management workspace and create a new import project as shown below:

On import screen:
Set the name of the project: Product categories import
Set data format : Excel
Entity name: Product categories
Click on upload and browse to the excel file which we want to import.
New entity(Product categories) will be added to "Selected files and entity section".

Now our entity is ready for import. 
Click on the "Import" on in the action pane.

Your import is complete.

I have shown the import using excel, same can be done by using package.