Princy Jaiswal Application Development Analyst

Professional Summary

Total 3.2 years of experience as SAP Technical consultant with working experience as SAP BODS Developer with expertise in following:

SAP BODS (Business Object Data Services)

Good understanding of OLAP Data warehouse concepts, Dimensional Data Model, Star Schema, Snowflake Schema.

Capable of understanding the business environment and translate business requirements into technical solutions.

Capable of working as a Team Member or individually with minimum supervision. Flexible to adapt to any new environment with a strong desire to keep pace with latest technologies. Technical Expertise in BODS

Strong Analytics/Data warehouse experience using SAP Business Objects Data Services/ Data Integrator.

Experience in using BODS as an external system for ETL.

Created Jobs, Work Flows, Data Flows, and Scripts using various Transforms to successfully load data from multiple sources into a desired target.

Proficiency in data warehousing techniques for Slowly Changing Dimension phenomenon.

Extensively used Data Services Management Console to schedule and execute jobs, manage repositories and perform metadata reporting.

Technical Skill

ETL Tools : SAP Business Objects Data Services 4.0/4.2

Databases : Teradata, CloudSQL,Big Query,Oracle

Professional Experience Highlights

Designation : Application Development Analyst

Company : Accenture

Client : Novartis – Health Care

Role : BODS Developer

1.1 Project 1:

Data migration from SAP BW to Google CloudSQL ( Part Simulation) Responsibilities:

Actively involved in creating jobs, extract in scope and transform jobs.

Jobs include extracting the data from SAP BW database. Built extract jobs in order to extract the data into staging.

Worked on script with Java to bulk load the data from SAP BW to CloudSQL .

Generated .csv file and bulk load the data through custom program.

Identified bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs and redesign the existing mappings for improving the performance.

Involved in the error handling to trace the error log. 1.2 Project 2:

File to teradata(CAPACITY MANAGEMENT TOOL)

Responsibilities:

Automating the project to ease the process.

Changing logic as per business requirement

1.3 Project 3:

Transferring data from oracle to mysql and then to big query(quality Management) Responsibilities:

Maintaining scd2 type using various transforms.

Dumping data from oracle to mysql using java scripts and substitution parameters. 1.4 Project 4:

Transferring data from xml to big query and then again big query to xml. Responsibilities:

Transferring data from xml to big query (upserting data via mysql)

Creating views as per business requirement at big query.

Loading data again from big query view tables to XML file. 1.5 Project 5:

Transforming Data and ftp to Server

Applying logics and transforming data as per business requirement

Ftp target file to client server

1.6 Project 6:

Integration project

Migrating a learning portal from Legacy system to target system 1.7 Project 7:

Dissolving a VB tool and converting the same to automated solution through BODS Personal Profile:

Name : Princy Jaiswal

Date of Birth : 15/08/1993.

Contact Number : +91-842*******

Email_Id : ac7uj3@r.postjobfree.com

Achievements:

Received a lot of Appreciations from client for handling the Business issues efficiently and quickly.

Declaration

I hereby confirm that the information in this CV is true and correct to the best of my knowledge.

Place: Mumbai Date: 13-11-2018

Contact this candidate