CURRICULUM VITAE

LOKESH N.D

Phone: +91-886*******.

E-mail: aceohg@r.postjobfree.com

Professional Summary :

• 4 years of experience as Business Intelligence Developer in Development, Production

In SQL Server 2012/2008 R2.

• Expertise in SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS)

& SQL Server Reporting Services (SSRS).

• Developed DTSX packages to extract, transform and load into the Campaign database from OLTP

database using of SQL Server Integration Services (SSIS).

• Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.

• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during

transferring, and archived data files for different DBMS.

• Have good experience with designing and implementing MDX queries, OLAP architecture, MOLAP,

ROLAP and HOLAP.

• Designing and Deployment of Reports for the End-User requests using Web Interface & SSRS.

• Experienced in programming tasks-Stored Procedures, Triggers and Cursors using SQL Server 2008

R2 with T-SQL.

• Involved in data migrations, transfers using utilities like Data Transformation Services (DTS), and

SSIS, Bulk Copy Program (BCP) and Bulk Insert.

• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for

SSIS Packages.

• Well acquainted with SQL Server Technologies SQL, T-SQL, SSIS and SSRS.

• Experienced in implementing Software Development Life Cycle (SDLC).

• Good Understanding of Business logic and ability to work well as a part of a team in agile

implementations and as an individual.

Technical Summary :

• Languages : SQL, T-SQL, MDX, PL/SQL, HTML.

• Databases : SQL Server 2012/2008 R2, Oracle 11g/10g

• Tools/ Utilities : SSIS, SSAS, SSRS.

• Operating Systems : Windows (XP/Server 2008), UNIX, Ubuntu.

Awards/ Certifications/ Achievements :

• Applied Achievement Award in Operational Excellence for Purchasing Cube Development.

Experience Summary:

Project Name: Applied Purchasing Cube

Company: Applied Materials India Pvt Ltd.,

Duration: Oct 2013 – Till Date

Project Description:

Applied Materials (NASDAQ: AMAT), the world's largest supplier of products and

services to the global semiconductor industry, is one of the leading information infrastructure providers.

As a core information infrastructure company, Applied Materials innovates and commercializes the

processing and manufacturing technology that helps semiconductor manufacturers produce the world's

most advanced chips. Objective is the provide support and development for Purchasing Order

applications and also address key weaknesses within the existing system of Purchasing.

Responsibilities:

• Analyzed business requirements and build logical and physical data models that describe all the data

and relationships between the data.

• Based on business requirement, developed the Complex SQL queries with Joins and T-SQL, Stored

procedure, Views, Trigger to implementing the business rules and transformations.

• Used ETL SSIS to develop jobs for extracting, cleaning, transforming and loading data into data

warehouse.

• Involved in designing, reviewing, and creating primary objects like Views, Indexes, Stored procedure,

Functions, Triggers based on logical design models, user requirements and physical constraints.

• Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies

based on the OLAP Reporting needs.

• Created and Designed Data Source and Data Source Views Using SQL Server Analysis

Services 2012 (SSAS).

• Created and Configured OLAP Cubes (Star Schema and Snow flex Schema) using SQL

Server 2012 Analysis Services (SSAS).

• Performance tuning MDX and dimensions design and scaling to large numbers of users in

SQL Server Analysis Services (SSAS).

• Generated various Report models on Views (due to security issues) and deployed them on to

the production reporting server and generated various Report models and ad-hoc reports.

• Created queries for generating drill down reports in SSRS 2008.

• Formatted the reports using the Global variables, expressions and Functions.

Project Name: Clinical Content Management [CCM]

Client: MHS Inc, USA.

Company: Griha Software Technologies Pvt., Ltd.,

Duration: July 2012 – OCT 2013

Project Description:

CCM Project is made for the USA Client MHS. This is a Hospital Domain Project

(Supply Chain Management). This project is designed to maintain the information about all the items

present in a Hospital with details of each year and Cleansing the master database for E-Procurement. so

they can find out what is the total cost of the hospital’s now and last year. This provides full security for

users; so that they can see items and details present in their hospital only. There are more than 400

hospital’s details present in the Database.

Responsibilities:

• Involved in Designing database, creating tables, Views, Procedures, Functions and packages to

enhance and improve functionality using T-SQL.

• Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing

DTS packages to SSIS for the on-going ETL Processes.

• Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.

• Monitoring backups for all databases.

• Created Reports Using SSRS to generate the Monthly, Quarterly and Yearly Reports.

• Generated the Reports Weekly and Monthly basis as per the Client Requirements Using SSRS.

• Created Sub-Reports, Chart’s based Reports in SSRS and Deployed in the Server’s.

Project Name: CONTENT WORK BENCH [CWB]

Client: Zewtana Companies, Saudi Arabia.

Company: Griha Software Technologies Pvt., Ltd.,

Duration: July 2012 – OCT 2013

Project Description:

The objective of this project is to provide the client with robust software for Content Management.

Content Workbench (CWB) enables organization to maximize such benefits by providing end-to-end

solutions to effectively create, manage, and leverage this product content asset. Employing a Web-based

architecture, CWB offers a comprehensive environment for creating, managing, and preparing product

information for e-Procurement needs.

Responsibilities:

• Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client

team, Development team of SQL Servers.

• Involved in Creation, Development and Deployment of SSIS packages in SQL Server 2008 R2.

• Involved in Data design, Created Tables, Indexes, Sequences, Constraints In

SQL Server 2008.

• Developed Stored Procedures, Triggers, and SQL scripts for performing automation tasks.

• Created Reports Using SSRS to generate the Monthly, Quarterly and Yearly Reports.

• Created Sub-Reports, Chart’s based Reports in SSRS and Deployed in the Server’s.

• Plan & Supervise the daily activities of the application support.

Project: Purchase Order System (E-Commerce Project)

Company: FirstGlobalSoftware Pvt., Ltd.,

Client: Brain Eye InfoTech Pvt., Ltd.,

Duration: Jul 2010 – Aug 2012

Project Description:

Designed and developed an integrated purchase system to facilitate purchase activities. Developed

purchase requisition inquiry, tabulation and purchase order applications. Enabled application to prevent

repetitive data entry as well as monitoring of purchase status.

Responsibilities:

• Involved in Data design, Created tables, indexes, sequences, constraints.

• Developed Packages, Procedures & Functions, Triggers on Oracle 10g.

• Database Query tuning and implementation.

Educational Background:

• Degree : Bachelor of Engineering

Branch: Telecommunication Engineering

Institute: K.S Institute of Technology, Bangalore

University: Vishveshwaraya Technological University, Belgaum.

Personal Details:

• Name : N.D. Lokesh

• DOB : 06-12-1985

• Sex : Male

• Languages known : English, Hindi, Kannada, Telugu, Tamil

• : # 185/f, 3rd Main Road, Girinagar 1st phase, Bangalore–560085.

Address

• Contact Number : +91-886*******, 080-********.

• E mail : aceohg@r.postjobfree.com

Declaration:

I hereby declare that the above written particulars are true to the best of my knowledge and belief.

Date:

Place: Bangalore (Lokesh N.D)

Contact this candidate