Data Sql Server

Naresh

Email: ****.****@*****.***

Profile

. Over 2+ years of experience in IT industry, with more than 2 years of

experience in doing Migrations and building Data warehouse / Data marts

solutions using SAP Best Practices Data Services.

. Heavy experience in design, creation, and implementation of work flows,

data flows, scripts and performing simple and complex transforms in

dataflow using different data integrator, platform and data quality

transforms.

. Experience in setting up Development, Test and Production environment by

additionally setting up a local and central repository and migration of

reusable of objects such as Jobs, Workflow, Dataflow both by

Import/Export directly and Checking In/Out in Central Repository.

. Expertise in implementing Data Cleansing, Data Profiling, Transformation

Scripts, Stored Procedures/Triggers and necessary Test plans to ensure

the successful execution of the data loading processes.

. Hands on experience of Recovery Mechanism for unsuccessful batch jobs

execution.

. Proficiency in data warehousing techniques for data cleansing, Slowly

Changing

Dimension phenomenon, surrogate key assignment and change data capture

. Extensive knowledge in all phases of Software Development Life Cycle SDLC

(Requirement Analysis, Design, Development, Testing and Documentation).

. Worked with End-To-End implementation with Netweaver, Data warehousing

team and

Strong understanding of Data warehouse concepts Star Schema, Snowflake

Schema and

Multi-Dimensional Models for query and analysis requirements.

. Experience in resolving on-going maintenance issues and bug fixes, and

performance

tuning of reports.

. Ability to understand the business environment and translate business

requirements into

technical solutions.

. Outstanding communication and interpersonal skills, ability to learn

quickly, good analytical reasoning and high compliance to new environment

and tools.

Technical

ETL Tools: Business Objects Data Integrator 11.7/12.2, Data Quality 11.7,

SAP Data Services XI 3.0/3.2/4.0

Databases: Oracle 10g/11g, SQL Server 2008/2005, Teradata, My SQL, MS

Access

Modeling Tools: Mapping Designer, TOAD, Visual Paradigm, Rational Rose

OS: WINDOWS 98/XP/Server 2003/ Vista/7, LINUX, UNIX

Languages: C, C++, SQL

Web Environment: HTML, Java-script, XML

IDE & Packages: SQL Navigator, Visual Studio 2008/2005, Eclipse, MS OFFICE

Suite (Word, Excel)

Experience/Project Work

Client: Coca-Cola, Atlanta, GA

Role(s): SAP BO/Data Services Consultant

Duration: May 2012 to Till Date

Description: The SAP BPC (Business Planning Consolidation) project will

enable the delivery of a common set of financial management reports for

Coca-Cola Refreshments (CCR) and Coca-Cola North America (CCNA). The BPC

will support reporting of Actuals and Plan/RE for volume and financials for

the North America (NA) Segment. CCNA is accountable for managing the brand

category portfolio, directing marketing investments, and incubating

emerging brands. CCR is accountable for managing the customer relationships

from order placement to manufacturing and delivery of the final product.

Responsibilities/Deliverables:

. Involved in connecting the multiple source systems like SAP ECC, Legacy

systems, Flat Files, Oracle, SQL Server to get the data from different

individual organization and merging the data into one single SAP System.

. Deriving new rules for managing different source systems for rolling them

up into one organization that will help the P&L reporting.

. Help in the code reviews of the new projects for other developers and

also developing code for them.

. Take part in the rigorous integration testing of the projects before the

Technical Go-Live.

. Be a part of the business requirements and develop logic to be

implemented as part of the System Design Life Cycle.

. Provide end-to-end support for co-coordinating between the Architect,

Business analysts and the actual Business Users.

. Help in the error validation of the anomalies between the source and the

target systems and contact the business users for proper validation and

substitution of those errors with suitable replacements.

. Help in the reconciliation of the volumes and the Budget in the source

and target systems that will help the P&L reporting for the Forecast.

Environment: Business Objects Data Services XI 4.0, Teradata, Oracle 10g,

SQL Server 2008, and Windows XP

Client: TECH DATA, TAMPA, FLORIDA

Industry: Manufacturing

Role(s): Data Migration Consultant Duration: July

2011 to April 2012

Description: This scope of the project was to migrate historical data from

legacy and load the same into newly implemented SAP ECC 6.0 using SAP Data

services 3.2 (Data Integrator/Data Quality).

Responsibilities/Deliverables:

. Conducted multiple workshops with Legacy and SAP Functional folks to

gather the requirements.

. Enhanced the Standard Best Practices Data Flows based on the Clients

need.

. Prepared mapping templates & Technical specifications based on the

workshops.

. Created mappings using Designer and designed workflows using Workflows to

build DW as per business rules.

. Responsible to design and develop the data services components to migrate

the data into SAP ECC via IDOC's & LSMW.

. Worked with AIO methodologies to migrate the Customer, Vendor, Material

and Inventory Balances via IDOC's.

. Designed and developed preparation ETL jobs to extract, validate, enrich

and load the data into staging tables for the migration of SD and MM

objects.

Environment: SAP Data Services XI 3.2, Business Objects XI, TOAD,

Universe Designer, Web Intelligence, Oracle 10g, My SQL, XML, Windows XP,

Windows 2008 server

Client: North Forth Bank, NY

Industry: Banking

Role(s): SAP Data Services Consultant Duration: Jan 2011 to

July 2011

Description: This project was for the development, maintenance, and support

for the history to be loaded in SAP ECC 6.0 using SAP Data services 3.1

(Data Integrator/Data Quality). The most important task in this project was

to cleanse the data (Data Quality) by using Address Servers.

Responsibilities/Deliverables:

. Gather information from clients regarding business requirements by

conducting multiple workshops with business & functional to research

existing business and system

. Prepared the mapping documents as the requirements

. Used Business Objects Data Integrator for ETL extraction, transformation

and loading data from heterogeneous source systems.

. Used various Business Objects Data Services transforms like Query, Pivot,

Case, Validation, Address Cleanse, country ID. etc in the process of

developing various jobs, workflows, data flows.

Environment: Business Objects XI 3.1/R2, Oracle 10g/9i, SQL Server 2005,

Broadcast Agent 6.1, Web Intelligence 6.5, Windows 2003 Server.

Education & Certifications.

. Master in Computer Science, CA, USA.

Contact this candidate