Lokesh N.

Lokesh N.

Microsoft Certified Business Intelligence Consultant, Data Scientist

Bengaluru , India

Experience: 11 Years

Lokesh

Bengaluru , India

Microsoft Certified Business Intelligence Consultant, Data Scientist

36571.2 USD / Year

  • Immediate: Available

11 Years

Now you can Instantly Chat with Lokesh!

About Me

•    9 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 ...

Show More

Skills

Operating System

Graphic Design

Portfolio Projects

Assurance Datawarehouse

Company

Assurance Datawarehouse

Description

  • Project Description:

              Assurance DW is the project for Implementing & Data Warehouse & Data Visualization for the Organization. And It manages the work of the Auditors and provide the Client and Assurance related informatio

  • Analyzed business requirements and build logical and physical data models that describe all the data and relationships between the data.
  • The Data was extracted from Different Databases Like Salesforce, DST Systems, MRI systems.
  • Used Azure Data Factory to develop jobs for extracting and loading data into Data warehouse.
  • The Azure SQL Data Warehouse was used as the Data Warehouse for the Project.
  • The Foundation layer was designed for staging database and Data Warehouse.
  • Implemented All Reports & Dashboards in Power Bi.
  • Deployed all the Power Bi Reports to the Power Bi Embedded Services and Consumed through Applications.

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.

Show More Show Less

Company

PwCTalentExchange

Description

  • Project Description:

              PricewaterhouseCoopers (PwC) US's Advisory Bangalore Service Delivery Center (SDC) is the natural extension of PwC's leading-class global delivery capabilities. PwCTalentExchange is the project for Implementing & Data Warehouse & Data Visualization for the Organization.
  • Analyzed business requirements and build logical and physical data models that describe all the data and relationships between the data.
  • The Data was extracted from CRM, Dynamic AX & DB Reporting databases.
  • The Foundation layer was designed for staging database and Data Warehouse.
  • 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.
  • Implemented All Reports & Dashboards in Tableau.
  • 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.

Show More Show Less

Applied Purchasing Cube

Company

Applied Purchasing Cube

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.

  • Analyzed business requirements and build logical and physical data models that describe all the data and relationships between the data.
  • 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.
  • Implemented All Reports & Dashboards in Power BI & Tableau Stack.

Show More Show Less

Clinical Content Management [CCM]

Company

Clinical Content Management [CCM]

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.

 

  • 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.

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

Show More Show Less

GrandeDataWarehouse & Data Visualizations

Company

GrandeDataWarehouse & Data Visualizations

Description

          PricewaterhouseCoopers (PwC) US's Advisory Bangalore Service Delivery Center (SDC) is the natural extension of PwC's leading-class global delivery capabilities. PwC SDC assists the elite customers with software development, ERP programming development, application integration and support and maintenance services. GrandeDataWarehouse & Data Visualizations is the project for Implementing & Data Warehouse & Data Visualization for the Client Using SQL Server 2014 & Tableau for Visualization’s.

  • Analyzed business requirements and build logical and physical data models that describe all the data and relationships between the data.
  • The Data was extracted from CRM, Dynamic AX & DB Reporting databases.
  • The Foundation layer was designed for staging database and Data Warehouse.
  • 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.
  • Implemented All Reports & Dashboards in Tableau.
  • 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.

Show More Show Less

Purchase Order System (E-Commerce Project)

Company

Purchase Order System (E-Commerce 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.

  • 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.

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

Show More Show Less

Retail & Sales Power Bi Project

Company

Retail & Sales Power Bi Project

Role

Software Architect

Description

►For the modern data drive organization, it’s mandatory to provide access to business data to every stakeholder instead of limiting it to the IT professional only.

►Businessmen who lack expertise in evaluating data by importing it and giving it the right shape before exploring its insight.

►The Azure Analysis Services is highly optimized in-memory engine work quickly and elicits the required data in exceptionally higher speed.

►The two major functions of Azure Analysis services are Provide Sematic Models & Excellent Speed.

►As Azure Anlysis services is a cloud services , it has several benefits we’ve come to associated with this type of PaaS services.

 Abiltiy to scale up or down to increase pefromance when the demand is there

 Ability to pause to save money if no queries are issues during a particular period of time ( such as overnight on Dev/test databases).

 No need to provision hardware, handle upgrades nor pacthing.

 Inherent redundancy of the data

Show More Show Less

Media

Share: