Client : Kendra ScottDeveloped core Ecomm data pipeline using Python and snowflakeFlattened the Ecomm Order raw json and modeled it into relational data and dimensional modelRefactored core Retail data pipeline from the scratch using Python and snowflakeFlattened the Retail Order raw xml and modeled it into relational data and dimensional modelDeveloped pipeline to bring in GA3 data from Bigquery to EDWDeveloped Fact and Dimension tables using ralph kimball methodology to support self service reporting and analyticsWorked on migrating the legacy database/on-premise database infrastructure to AWSDeveloped complex SQL views to support sales and financial reporting requirementsDeveloped a data quality framework in snowflake to detect the anomaliesDeveloped pipelines to acquire store traffic data from the third-party API and send the data to external downstream systems to support analytical and machine learning projectsBuilt a monitoring dashboard using Kibana and mentored the junior developersActively participated in gathering the requirement from the stakeholdersOverall responsible for the Kendra Scott EDW data engineering efforts and pretty much involved in all the aspects of data engineering

Responsible for data engineering functions including, but not limited to: data extract, transformation, loading and monitoring the pipelinesRe-designed and developed a critical dashboard from scratch which simplified the business reporting and monitoring the performance of a product. (well appreciated by the client)Perform in-depth analysis of input data for the purpose of identifying opportunities, developing proposals and recommendations for use by managementCreated ETL scripts using python to pull data from various sources like RDBMS, NoSQL data sourcesCreated Dashboards with interactive views, trends of key metrics and drill-downs using Internal Visualization tool, Tableau and Google Data studio

Responsible for maintaining and development of www.otrestaurant.com and its DWHMade significant improvements in the existing monthly reporting process by optimizing the SQLDeveloped python scripts to clean and aggregate the input dataDeveloped Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQLPartitioned large Tables using range partition techniqueDeveloped Tableau workbooks from multiple data sources using Data BlendingMigrated mySQL databases to the latest version of mySQL and support migration of data from legacy application to new stack

Worked as a database engineer / developer, primarily responsible for managing www.rivals.com and its sub-domains development and supported the migration of its database from SQL server to Postgres and its DWH developmentsDeveloped python scripts to scrape contents from the web using Beautiful Soup and sync the data to the internal systems via APIIntegrating college football stats data with Hadoop/HDFS, Real-Time Systems, Data WarehousesWrote python scripts to parse XML documents and load the data in databaseMonitor the website performance using Splunk and identify and fix the issuesAddressed many performance issues on semantic views, stored procedures, Reporting and Ad-hoc SQL requirements

Worked as a Full Stack developer focusing on developing Intranet Sales Portal and Data warehouse systems for Sales and Finance departments for BI and reporting purposesSpearheaded the post merger integration of sales data from the acquired company into the target BI systemsExperienced as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS)Developed automation and ETL scripts using python to retrieve data from the manufacturing systemsWorked on the Teradata stored procedures and functions to confirm the data and have load it on the global data warehouseSuccessfully developed web based dashboards with trending data, demographic charts with drill down functions that displays a breakdown of Regional/States sales, utilizing data aggregation from SQL statements

Design and develop websites using HTML , Classic ASP, and SQL ServerDeveloped Sales KPIs and dashboards using FusionChartTroubleshooting issues and maximizing web performance using best practicesAssisted upgrading the existing database to a newer version of SQL Server

• Provided Classroom Trainings on Web Development for academic students• Handled the tasks of providing technical support• Handled the tasks of testing beta software for academic students• Evaluated students' performance, assignments, and reports• Responsible for implementing relational database system in order to maintain inventory records for software and hardware• Responsible for setting up computer systems and other related equipment’s