Sql Server Project
Resume:
CURRICULUM VITAE
LOKESH N.D
Phone: +91-886*******.
E-mail: ***********@*****.***
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 : ***********@*****.***
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