Punyasloka M.

Punyasloka M.

Data Warehouse Developer

Hyderabad , India

Experience: 11 Years

Punyasloka

Hyderabad , India

Data Warehouse Developer

42000 USD / Year

  • Notice Period: Days

11 Years

Now you can Instantly Chat with Punyasloka!

About Me

10+ years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Health care, Pharmaceutical, Financial and Telecom Sectors Highly Motivated, Solutions Driven with over 7 years of Data Wa...

Show More

Portfolio Projects

Description

Description:

Oracle Utilities Global Business Unit (UGBU) is a world market leader in developing software products for the utilities industries. The product set includes products like Customer Care and Billing, Meter Data Management, Work and Asset Management, Mobile Workforce Management, Network Management System - just to name a few. These products generate a lot of meaningful data for different sections of the utility market. Oracle Utility Analytics (OUA) is an umbrella product to analyze the data generated by these applications.

We are transforming the OUA product to the enterprise data warehouse technology using the Oracle Data Integrator (ODI) and Oracle Golden Gate (OGG). We also use OBIEE as the tool to generate reports.

Roles and Responsibilities:

  • Analyzed Functional & technical design documents.
  • Created master & work repositories and configured ODI connections for source and target systems in topology.
  • Extensively used ODI (Oracle Data Integrator) ELT tool to create Data ware Housing OLAP model.
  • Experience in ODI designer, Topology, Operator and ODI Tools.
  • Transforming and Loading data into target tables.
  • Optimized the knowledge modules to improve the functionality of the process.
  • Developed packages, scenarios using interfaces and variables.
  • Debugging the master jobs and packages by using operator navigator.
  • Monitoring the execution logs in operator.
  • Experienced in Working with Load Plans and Scenarios.
  • Implemented Send E mail to the DBA on interface execution failure.
  • Used ODI commands like OdiFileMove, odiFileAppend,odiFilecopy etc.
  • Participated in all phases of project development, testing, deployment and support.
  • Working knowledge of Knowledge Modules (LKM, IKM, JKM and CKM).
  • Implemented SCD type1 and SCD type2.
  • Have knowledge about Changed Data Capture.
  • Performed unit testing at various levels of ELT flows.
  • Execute test cases with multiple data sets to attain exact test results and capture faulty construction.

Show More Show Less

Description

Merck is an American pharmaceutical company and one of the largest pharmaceutical companies in the world.
Merck headquarters is located in Kenilworth, New Jersey. The company was established in 1891 as the United
States subsidiary of the German company Merck (founded 1668).
It is the world's seventh largest pharmaceutical company by market capitalization and revenue. Merck publishes
The Merck Manuals, a series of medical reference books for physicians, nurses, and technicians.
These include the Merck Manual of Diagnosis and Therapy, the world's best-selling medical reference.

Responsibilities:
 Create informatica mappings to build business rules to load data.
 Involved in quality assurance of data, automation of processes.
 Developed complex mappings in Informatica to load the data from various sources.
 Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup,
Update strategy and Sequence generator and Stored Procedure.
 Parameterized the mappings and increased the re-usability.
 Used mapping designer and maplets to generate different mappings for different loads.
 Responsible for monitoring all the sessions that are running, scheduled, completed and failed. Debugged
the mapping of the failed session.
 Written documentation to describe program development, logic, coding, testing, changes and corrections.
 Extensively used Toad utility for executing SQL scripts and worked on SQL for enhancing the performance
of the conversion mapping.

Show More Show Less

Description

Description:
It was founded in 1996 as a joint venture between Telinfo and France Télécom (now Orange
S.A.), building a GSM 900 network and then founding a complementary DCS 1800 network.
Initially Mobistar added to its network coverage by signing contracts with providers such as Motorola & Talkline,
Cellway, a subsidiary of Martin Dawes Telecommunications and Debitel Belgium, the latter two which it would
take over respectively in 1997 and 2000.
Mobistar claims to have been the first GPRS operator in Belgium.
Responsibilities:
 Responsible for Business Analysis and Requirements Collection.
 Worked on Informatica Power Center 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 modeling (Star Schema) of the Data warehouse and used Erwin to design the
business process, dimensions and measured facts.
 Optimizing/Tuning mappings for better performance and efficiency.
 Involved in Unit Testing and Integration testing.

Show More Show Less

Description

Description:
GE is a diversified technology, media and financial services company with operations worldwide. In order
to run its businesses cash management and foreign exchange for the company worldwide. GE corporate Treasury
manages billions of dollars – money that must be collected from customers and paid to vendors around the globe,
in over a dozen foreign currencies.
EDW – GE Treasury has plans to build a DWH in the corporate enterprise model and replacing the existing DWH.
The main objective of this project is to analyze the bank account information. The data mart gets data
from different heterogeneous relational i.e. Oracle and flat file sources. Logic has been designed through
Informatica mappings to cleanse the data and load the data into the data mart. This project provides complete
historic information related with clients inventory by developing the data warehouse that stores all the necessary
data of last two years related with company.
Responsibilities:
 Understanding the business rules and implementation of data transformation methodologies as for
business process and handled with client.
 Designing the mappings as per ETL Specification.
 Developing the mappings optimized them for better performance.
 Performed Debugging and Tuning of mapping and sessions.
 Test mapping to assure that data is loaded as per ETL Specification.
 Performed extensive testing on the mappings and wrote queries in SQL to check if the data was
loading to the dimension tables and fact tables properly.
 Developed complex mappings in Informatica to load the data from various sources using different
transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate,
Update Strategy, Sequence Generator, Joiner, Filter, Update Strategy Rank and Router
transformations.
 Extensively used SQL* loader to load data from flat files to the database tables in Oracle.
 Modified existing mappings for enhancements of new business requirements.
 Used Debugger to test the mappings and fixed the bugs.
 Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.

Show More Show Less

Description

GE Asset Management (GEAM), a wholly owned subsidiary of GE. Is the investment management arm for the General Electric Company The GEAM Equity group makes investment decisions on Equities side for GEAM in terms of which stocks to buy and sell to earn more profits. It identifies the clients area of interests and invests the clients money profitably.

Show More Show Less