Nagesam M.

Nagesam M.

Technical Lead

Bangalore , India

Experience: 8 Years

Nagesam

Bangalore , India

Technical Lead

27428.5 USD / Year

  • Immediate: Available

8 Years

Now you can Instantly Chat with Nagesam!

About Me

Currently working as a Techinical Lead in Marlabs Innovations Pvt Ltd, Bangalore from Jul 2019 to till date. Having 8+ years of experience in IT Industry, Worked on BI projects with extensive usage of SQL Server Management Studio (SSMS), ETL tools li...

Show More

Portfolio Projects

Description

Essilor International S.A. is a French-based international ophthalmic optics company that designs, manufactures and markets lenses to correct or protect eyesight. Essilor is responsible for creating Varilux, the worlds first progressive lens which corrects presbyopia and allows clear vision in the wearers near, intermediate and far vision. Its activities are largely focused on research and development. It is the worlds largest manufacturer of ophthalmic lenses Roles: Involving in business calls and understanding business requirements Developing ETL packages to load data from Traller file to SQL tables. Working on dashboard enhancements as per customer requests. Creating reports using Nprinting based on customer requirement. Writing stored procedures and views to manupulate data based on requirement. Creating new measures and dimensions in Qlik level and performing calculations using set analysis Generated Stored Procedures and Functions for better performance and flexibility. Monitoring Data loads in Staging and Production environments Providing on call support for any issues in production environment.

Show More Show Less

Description

Kabloom is one of the online based E-commerce services. Kabloom and BloomKonnect is US based marketplace allows you to order flowers online, offering a wide selection of farm fresh flowers from farms around the United States. Kabloom is associated with Amazon, to receive fresh flower orders through Amazon. Roles: Involved in business discussions with marketing managers to understand the requirements Responsible to provide weekly, monthly reporting of metrics and KPIs to support the business needs of marketing managers. Delivering adhoc requests for information from established data sources, SQL databases, Quick base applications Reviewing data and develop visual representations of data to support management decision making Developed incremental reporting requirements and maintain and manage the data in line Managing tasks to reload data into the published apps in QMC. Managing streams to provide read and publish access to the end-users. Creating complex SQL Querys to achieve the customer requirements and feed into Qlik Sense reports

Show More Show Less

Description

Expedia, Inc. is an American travel company that owns and operates several international global online travel brands, primarily travel fare aggregator websites and travel metasearch engines including Expedia.com, Hotels.com, Hotwire.com, trivago, Venere.com, Travelocity, Orbitz, and HomeAway. The company operates more than 200 travel booking websites in more than 75 countries, and has listings for more than 350,000 hotels and 500 airlines. The aim of the project to migrate data from on-prem to AWS cloud and then provides insights using migrated data by creating data visualization dashboards with respect to the bookings from different POS. Roles: Involving business calls with onsite team to get the business and preparing confluence pages based on the business discussions. Participating in data modeling, design and development activities. Attending daily scrum calls to discuss the status of the assigned tasks. Modified the existing data models as per business requirements and implemented the required changes Feed data from staging server to Qlik Sense and created QVDs. Created data model in Qlik sense & created visualizations using assets panel and external visualizations. Deployed to server and scheduled tasks to refresh data automatically. Completely responsible for data quality, enhancements and implementation of new CRs.

Show More Show Less

Description

LRT provides a holistic view on Chevrons upstream logistics operations (both at global level and at business unit level), through effective reporting of iLogistics and VMS (Voyage Management System) data across multiple business units. Chevron Logistics Reporting Tool (LRT) provides a centralized analytical platform which integrates the information from various iLogistics and VMS instances to provide users with a unified reporting model for flexible KPI analysis. Roles: Handled support activities and interaction with onsite team over calls. Involved in LRT end to end deployment activities Involved in Requirement Gathering based on the Business Requirement Documents Interaction with product team to understand the business requirements Developed design and deployment documents for onsite team Developed Batch script to run bulk of SQL files. Developed DTSX packages to extract, transform and load into the SQL server database from OLTP database using of SQL Server Integration Services (SSIS) Designed Packages using SSIS task, Containers, Precedence constraint and data flow tasks using Source, Transformations and Connection managers. Involved writing stored procedures and views as per the requirement Used Trend Lines, Reference Lines, Forecasting and statistical techniques to describe the data. Used parameters and input controls to give users control over certain values. Created quick filters, table calculations, calculated fields and parameters.

Show More Show Less

Description

Lufthansa Cargo AG (LCAG) is the logistics service provider in the Lufthansa Group. With capacity from its freighter fleet now back to full operation after the recession and the belly capacity increasing through passenger network expansion, LCAG is in a strong position to maintain its premier market position. LCAG is dominant in its home market, the market leader in Europe and is amongst the largest and most successful operators in Asia Pacific. It is also a leader in innovation with its time definite products, its e-freight transformation programme and its joint ventures with DHL and jade that has contributed to its profitable growth. Roles: Involved in business meetings to understand the test scenarios. Understand the test scenarios and provided the test data for the testers. Responsible to provide test data to the manual testers to test their functionality. Knowledge to create test data in data base which is used by the testers Experience in testing the test cases manually as per the business requirements. Involved in writing test cases at data base level.

Show More Show Less

Description

Carnival is worlds most popular cruise lines which offers wide array of quality cruises which deliver memorable vacations to the guests. The project is mainly to provide development & support for the Business Intelligence division using oracle enterprise management system (Hyperion). Interactive reporting jobs are created and scheduled and the reports are sent to the respective departments. Roles: Development of packages according to the ETL specifications for the staging area & warehouse data loading using SQL Server Integration Services & SQL Server 2008. Importing Source/Target tables from the respective databases by using Execute Package Task& using Control Tasks in SQL Server 2008 Integration services. Used transformations like Derive Column, Conditional Split, Aggregate, Lookup and sort and execute SQL Task to load data into Data Warehouse. Created Event Handlers for the Packages Using Event Handler Tab for Error Handling. Maintained log information in SQL table to tracking Errors and recording package execution status. Created Configurations to change the package properties dynamically. Expertise in Enterprise Reporting in generating reports using linked reports, sub reports and filters, charts in SQL server reporting services.

Show More Show Less

Description

Limited Brands is a values-based company. While Limited Brands offers a broad array of products ranging from top-selling perfumes (Bath & Body Works and Victorias Secret) to fun collegiate dorm wear (Victorias Secret PINK),disciplined approach to all products when it comes to quality and protecting the customers. Roles: Understanding the business requirements Manually tested SSIS packages to make sure the data loading correctly or not. Involved in writing test cases based on business requirements. Worked on Performance Tuning of ETL Data flows. Developed the reports in the form of Table, Matrix, and Chart using Sql Server 2008 reporting services and Report Server

Show More Show Less

Description

Essilor International S.A.is a French-based international ophthalmic optics company that designs, manufactures and markets lenses to correct or protect eyesight. Essilor is responsible for creatingVarilux, the world's firstprogressive lenswhich correctspresbyopiaand allows clear vision in the wearer's near, intermediate and far vision. Its activities are largely focused onresearch and development. It is the world's largest manufacturer ofophthalmic lenses

Show More Show Less

Description

Kabloom is one of the online based E-commerce services. Kabloom and BloomKonnect is US based marketplace allows you to order flowers online, offering a wide selection of farm fresh flowers from farms around the United States. Kabloom is associated with Amazon, to receive fresh flower orders through Amazon.

Show More Show Less

Description

Expedia, Inc. is an American travel company that owns and operates several international global online travel brands, primarily travel fare aggregator websites and travel metasearch engines including Expedia.com, Hotels.com, Hotwire.com, trivago, Venere.com, Travelocity, Orbitz, and HomeAway. The company operates more than 200 travel booking websites in more than 75 countries, and has listings for more than 350,000 hotels and 500 airlines. The aim of the project to migrate data from on-prem to AWS cloud and then provides insights using migrated data by creating data visualization dashboards with respect to the bookings from different POS

Show More Show Less

Description

LRT provides a holistic view on Chevron’s upstream logistics operations (both at global level and at business unit level), through effective reporting of iLogistics and VMS (Voyage Management System) data across multiple business units. Chevron Logistics Reporting Tool (LRT) provides a centralized analytical platform which integrates the information from various iLogistics and VMS instances to provide users with a unified reporting model for flexible KPI analysis.

Show More Show Less