Customer Service Project

Lakshmi Sasidharan

*********@*****.***

Data Engineer

Summary

Data warehousing professional with expertise in designing, developing and implementing data warehousing systems for handling extremely large datasets for Business Intelligence, reporting and analytics for 10+ years. Experienced in working with Executives, Planners and Store managers to breakdown business needs and solve them using technical solutions, provide insights and solutions using advances data analytics.

Currently working on Data Warehouse Modernization project which will provide improved data insights for Executives and Store Managers in Nordstrom by migrating legacy databases to Cloud,

Solving problems of data latency and scalability of the systems. Providing faster report availability and new and more accurate metrics using big data.

Led successful implementations as the lead developer on enterprise inventory deployment project, upgraded inventory management capabilities and improved efficiency in planning and forecasting by developing and deploying a new and improved data model.

TECHNICAL SKILLS

Data warehousing – 10 years

Business intelligence -10 years.

RDBMS (Oracle, Teradata) – 10 years

OWB – 2 years

PLSQL – 10 years

SQL- 10 yeas

ETL – 10 years

Performance tuning – 10 years

Unix Shell Scripting – 10 years

Python- 2 years

NoSQL- 1 year

AWS – 1 year

Redshift – 1 year

Tableau – 1 year

Hadoop – 1 year

Hive – 1 year

Spark – 1 year

Tools- Jenkins, GIT – 2 years

Work Authorization in US: Green Card

Other Skills

Excellent Communication Skills, both written and verbal.

Strong project leading experience with a geo-distributed team in more than 4 projects, mentor for other team members.

Agile Methodology and the scrum process.

Well versed with SDLC best practices

Experienced in designing, developing and deploying in Agile CI/CT/CD and DevOps environment.

Experienced in working with Business users to understand the problems, derive insights from data analysis and providing technical solutions and implementing them successfully.

Expertise in Analysis, troubleshooting, monitoring and maintaining ETL jobs and reports for production and non-production support need.

Experience

INFOSYS Limited - Technology Lead 2014-17, Technology Analyst 2007-2014,.

Keane Inc. -Senior Software Engineer 2005-07.

Projects

EDW Modernization-Nordstrom (March 2017 till now):

Improved data insights for Executives and Store Managers in Nordstrom by migrating legacy databases to Cloud(AWS), helping to solve data latency and scalability problems.

Working on Design and development for loading large data sets to S3, processing it in Spark and loading to relational and No Sql databases and creating visualizations out of the data using Quick sight and Tableau for the Enterprise Data Warehouse and Sales Reporting.

Worked on migrating the Sales Flash Reporting to AWS, Human Resources DataMart to AWS.

Also worked on creating and executing sunset plan to deprecate the legacy systems.

Technologies: Spark, Python, Redshift, Quick sight, Tableau, Hadoop, Hive, Presto.

NGEN Enterprise Inventory Deployment-Nordstrom (Feb 2016 to Feb 2017): Enterprise Inventory Deployment project, which was a part of Nordstrom’s Next Gen program focused on upgrading the existing inventory management capabilities like Retail Demand Forecast, Item planning, Allocation, Scaling and Replenishment with new solutions.

Improved planning and forecasting efficiency by designing a new data model in Teradata for Retail Demand Forecast extracts and Item Planning extracts. This ironed out the inefficiencies in the Legacy data model.

As a Lead Engineer for a team of 3, mentored team members and conducted design and code reviews.

Worked on the performance tuning of the Teradata procedures, views, macros used in ETL processes.

Actively participated in the requirement review to evaluate the requirements and design review sessions.

Worked on release management and code deployment using GIT and setting up workflow in Control M, coordinating with multiple teams for the company wide deployment of NGEN project.

Worked closely with the System Testing/Performance testing team to review test scenarios and test cases.

Technologies: SQL, RDBMS, Teradata, Oracle, Unix Shell Scripting, GIT, Jenkins, Python

Merch Analytics Foundation Project- Nordstrom (Sep 2015-Jan 2016):

Remodeled legacy demand DataMart in Oracle using Teradata, making report availability earlier by 5 hours and reducing production incidents by 40%. As a Lead Engineer for this project, worked with Senior Architects on the design, and Business, Analysts and Program Managers for requirement review. Designed, developed and implemented the advanced DataMart in Teradata.

Technologies: SQL, RDBMS, Teradata, Oracle, Unix Shell Scripting, GIT, Jenkins, Python

Fulfillment Analytics Project- Nordstrom (Aug 2014-Aug 2015):

Eliminated data latency in the reporting system and built real time data marts for Fulfillment analytics reporting tracking Store fulfillment efficiency, drawing lot of appreciations from Store Managers. Designed, developed and implemented the features for creating real time Customer Order Management interface, building Price Type and HRMS DataMart in Teradata and integrating the data with real time interface done using Micro strategy.

Technologies: SQL, RDBMS, Teradata, Oracle, Unix Shell Scripting, GIT, Jenkins, Python

Rack Pack and Hold Project -Nordstrom (Jun 2013 to Jul 2014):

Eliminated the manual effort put by buyers and Planners for handing Rack Pack and hold POs separately by creating additional metrics from source, modifying existing DataMart and reports to handle new metrics. Designed, developed and done quality assurance (ST, E2E) for this enhancement project to include Rack Pack and hold measures in transfer and receipt dataflow and planning reports.

Technologies used in the project were Oracle, OWB, Unix Shell Scripting

Event Analytics Project- Nordstrom (Jan 2013-Jun 2013):

Created a new report for providing insight into new Back order metrics. Designed, developed and implemented the data model in Teradata and Oracle for reporting back order in Anniversary Event Sales dashboard in Micro strategy.

Technologies used in the project were Teradata, Oracle, OWB, Unix Shell Scripting

Alternate calendar reporting Analytics Project-Nordstrom (Jan 2011 – Dec 2012):

Solved the reporting time issues associated to the extra 53rd week that comes up once in 6 years in the company fiscal calendar by creating an Alternate Calendar in DataMart. Designed, developed and implemented the alternate calendar platform in Teradata and Oracle DataMart. This project was recognized in Nordstrom’s Q4 recognition program for its planning and error free implementation even after accommodating multiple change requests in a short time frame.

Technologies used in the project were Teradata, Oracle, OWB, Unix Shell Scripting

Import 2000 – Sears (July 2010 to Dec 2010):

Import2000 application is used to create and track new POs for Sears Holdings Corporation. Worked as a developer and successfully implemented enhancements and maintenance requests on Oracle forms.

Inventory Stager-British Telecom:

The Inventory Stager is a data warehousing application which accepts Network Inventory and Service Inventory as inputs and produces the configuration files required to be able to produce network performance reports associated with customer data. Worked as a developer in Abinitio and successfully implemented enhancements for this maintenance project.

Customer Service Systems Support-Orange Network, Keane Inc. (Feb 2005 to Apr 2007):

Mentor and SME for supporting the production environment of Customer Service Systems application of Orange Network. Customer Service System facilitates registration of contract customers and maintenance of their accounts.

Education

Bachelor of Technology – Electronics Engineering 2001 from CUSAT, India

Post Graduate Diploma in IT-2005 from IIITMK, India.

Contact this candidate