MOUNESHWAR VISHWAKARMA

Email :acp4a1@r.postjobfree.com

Phone: +91-973*******

Obtain a challenging position that would best utilize my efficiency to place myself in a suitable career. This can provide me an opportunity to showcase my talents to explore the infinite possibilities of the field.

Around 3+ years of experience in Design and Development of Data Warehouse applications using Informatica and PL/SQL.

Having strong experience in ETL tool Informatica (Power Center 8.6/9.1).

Extensive experience in implementation of ETL methodology in Data Extraction, Transformation and Loading.

Extensively used various client tools like Designer, Manager, Monitor and Repository while developing and debugging the ETL Job.

Strong Knowledge on Health Care Domain.

Strong Knowledge on Medical Professionals and Rep Activities.

Strong analytical, programming and presentation skills

Superior problem solving skills, quick and independent learning skills

Sharp debugging and correction skills

Able to work well as a responsible team member or an individual

Strong experience in coding using SQL, PL/SQL Procedures/Functions, Triggers and Packages.

Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages and Triggers.

Self-motivated, able to set effective priorities to achieve immediate and long-term goals and meet operational deadlines.

Having good Knowledge of Data warehousing architecture and concepts.

Having an excellent quality of adapting to latest technologies.

Able to communicate effectively with multifunctional teams, programmers and technical staff.

Working with Cegedim Software India Private limited acquired by IMS Health as Senior Software Engineer from March 2012 to till date

Tool : Informatica Power Center 8.6/9.1

Query Tools : SQL Developer, Golden Benthic, TOAD

Database : Oracle 10g

Operating system : Windows 7, 98, XP, UNIX

Configuration Management Tool : Surround SCM,TFS

Have received a Valuable award “SMART” from Cegedim for the smart work.

Excellent analytical, design and problem solving skills.

Certified on Mobile Intelligence Application Certification on Health care domain

Highly quality conscious with good knowledge of the quality processes to be followed through the complete life cycle of Healthcare Projects

Pursued B.Tech degree in Electronics and Communication Engineering in the year 2011 from

Sri Indu College of Engineering & Technology (Affiliated to JNTU) with 77.23%.

Project # 1:

Project Name : Daiichi Sankyo DWH

Client : Daiichi Sankyo Inc, USA.

Role : Informatica Developer.

Environment : Informatica 9.1

Project Description:

Daiichi Sankyo Company, Limited is a global pharmaceutical company and the second largest pharmaceutical company in Japan. It is the U.S. subsidiary of Daiichi Sankyo, Company, Limited and a member of the Daiichi Sankyo Group. The organization, which includes U.S. commercial operations and global clinical development (Daiichi Sankyo Pharma Development), is headquartered in Parsippany, New Jersey. The DSI have logical legacy source systems from which data is extracted and staged in to different staging tables. An Integrated view of data was needed, from where the analysis of data is done and reports are generated based on user’s requirement for decision-making purpose. The main objective of this project is to capture the customers’ data and reporting for bonds.

Responsibilities:

Understanding the Requirement Specifications.

Involved in the analysis of source to target mapping provided by data analysts and prepared function and technical design documents.

Created Informatica mappings to build business rules to load data.

Creating and importing source/target tables from respective databases

Created reusable transformations and mapplets and used them in mappings

Creating transformations like Router, Lookup, Expression, Joiner, Sequence generator and Update strategy

Creating source to target mappings and developing the ETL mappings using Informatica Power center

Monitoring the daily loads using workflow monitor

Preparing unit test cases and documentation

Responsible for automating all ETL process that can be automated

Project # 2:

Project Name : Mylan.

Client : Mylan, United States.

Role : Oracle Developer

Environment : Oracle 10g, PL/SQL,SQL, Unix, Informatica 8.6.

Project Description:

Mylan Inc. is a global generic and specialty pharmaceuticals company headquartered in Cecil Township, Pennsylvania. In 2007, Mylan acquired a controlling interest in India-based Matrix Laboratories Limited, a top producer of active pharmaceutical ingredients (APIs) for generic drug and the generics business. Project consisted of data warehouse designed to provide the company with accurate, on-time information it needs to more effectively support the decision making process. Mylan has grown from the third-largest generic and pharmaceuticals company in the United States to the second-largest generic and specialty pharmaceuticals company in the world. Information is collected from various source system distributed across the all regions. The collected information is loaded into data warehouse. And this information can be load into the Data marts to generate the reports.

Responsibilities:

Creation modification and Maintenance of data base objects.

Development of Re-usable objects like General Procedures, Functions & Packages.

Interacting with SDM(Service Delivery Manager)/ clients to collect & Scope of business requirement for enhancements

Implementing new versions, Client customizations and documenting the release notes.

Documenting root cause of Database issues.

Automate tasks and write scripts for manual reports on data base tables

Knowledge Transition on specific applications areas covering functional, technical and work process and environment

Project Documentation.

Monitored and maintained customers transactions activity and account information on the database.

Project #3:

Project Name : Becton Dickinson

Client : Becton, Dickinson and Company (BD), USA

Role : Informatica Developer.

Environment : Informatica power center 9.1, Oracle 10g, Toad.

Project Description:

Becton, Dickinson and Company (BD) is an American medical technology company that manufactures and sells medical devices, instrument systems and reagents. Founded in 1897 and headquartered in Franklin Lakes, New Jersey. The company's customers include healthcare institutions, science researchers, clinical laboratories, the pharmaceutical industry and the general public. BD was one of the first companies to sell U.S.-made glass syringes. The main objective of this project is to provide integrated information on health care Professionals and Organizations, which helps in the analyzing sales and purchase information at an aggregated level. The whole process has been automated and the entire extraction, transformation and loading process has been done with help of Informatica.

Responsibilities:

Extraction, Transformation and loading of data from Oracle sources into Target database.

Involved in designing the mappings between sources and targets and also tuned them for better performance.

Created and monitored the workflows using Workflow Manager and Workflow Monitor and the log were studied to modify the mappings to obtain correct results from the Transformation.

Prepare the Test Cases and Performed Unit Testing for Developed Mappings.

Involved in Documentation of Mappings As per Standards.

Name : Mouneshwar Vishwakarma

Date of birth : 15 th February 1990

Father's name : Lingaiah

Gender : Male

Nationality : Indian

Language known : English, Hindi, Telugu, Kannada.

I hereby declare that the information provided above is true and correct to the best of my knowledge.

(Mouneshwar V)

Contact this candidate