Experience

Gorton's

• United States
• Manufacturing
• 100 - 200 Employee

• SQL Developer

  • Mar 2023 - Present

  - monitored daily pipeline in azure data factory. - used log analytical workspace to create a monitoring solution from ADF to power bi . - Created Cube links by connecting the database to excel and created a pipeline to refresh the excel every fourth night. - created a automation solution to save the email attachment to the FTP SERVER Developed a solution for predicting sales using ML . developed power bi report for the sales team . Used T-sql to creat the fact table and dax commands to build the report. Used complex stored procedures to populate table in azure database. Used complex dax commands to create new measures , calculated columns , calculated measures for the power bi report. - used complex dax commands to populate top n in the report. - Created stored procedure to create paginated reports in power bi report builder. - Automated the file transfer email attachment to ftp using power automate . Show less



Cognizant

• United States
• IT Services and IT Consulting
• 700 & Above Employee

• Data Engineer/Data Analyst

  • May 2018 - Jun 2019

  • Designed, developed, and deployed Data Lakes, Data Marts, and Datawarehouse using AWS cloud like AWS S3, AWS RDS, AWS Redshift, and terraform. • Responsible for building Self-service data pipelines using AWS Services like SNS, Step Function, Lambda, Glue, EMR, EC2, Athena, Sage Maker, Quick Sight, Redshift, etc. • Moved a large amount of data from AWS S3 buckets to AWS Redshift using Glue and EMR. • Coordinated daily, weekly, bi-weekly, monthly, and quarterly oversight monitoring activities using AWS Quick Sight. • Developed ETL pipelines in and out of the data warehouse using tools like Python and AWS Glue. • Used AWS EMR to transform and move large amounts of data into and out of other AWS data stores and databases, such as Amazon Simple Storage Service (Amazon S3) and Amazon DynamoDB. • Assisting in Root Cause Analysis (RCA) efforts (identifying, validating, and prioritizing problems) and documenting the identified workarounds. • Preparation of detailed Incident Reports in REMEDY, XMATTERS, and weekly and monthly MTTR reports conveying progress notes to all Client teams and project stakeholders. • Hands-on experience in designing, scaling, and leading solutions for Informatica Security Audits, Informatica remediation Plans, platform enablement DR activities, and data decommissioning tasks. • Hands-on experience in developing Informatica mappings/workflows to perform ETL operations for data movement between source and target systems. • Have extensive experience in formulating complex solutions through SQL queries across MSSQL, Oracle and Teradata. Show less



Cognizant

• United States
• IT Services and IT Consulting
• 700 & Above Employee

• Data Analyst

  • Jun 2016 - Apr 2017

  • Prepare detailed workflow charts and diagrams that describe input, output, and logical operation. • Responsible for creating client/business requirement documents (BRD) and providing customized software solutions involving finalization of product specifications and selection of appropriate techniques • Designed both 3NF data models for ODS, OLTP systems and dimensional data models using star and snowflake Schemas. • Implemented advanced SL queries using DML and DDL statements to extract quantities of data from multiple data points on SQL Servers. • Defined best practices for Tableau report development and effectively used data blending feature in tableau. • Involved in creating database objects like tables, views, procedures, triggers, function using SQL to provide definition, data structure and to maintain data efficiency. • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. • Administered user, user groups and schedules instances for reports in Tableau. • Build Tableau data-driven dashboards to visualize core business KPI’s (monthly sales of the health care equipment’s). • • Helped the project to decide in dynamic pricing by identifying insights and forecasting the trends for future months using Tableau. • Performed Unit Testing and tuned the Informatica mappings for better performance. • Generated CSV files from Python and exported them directly to Tableau for visualizing data • Created effective visualizations using tableau and investigated a dataset to create data visualizations to tell trends and patterns in data. • Used different feature engineering methods in Python (Pandas, NumPy, Matplotlib, Seaborn) to cleanse high dimensional datasets and prepare it for modeling. • Analyzed and visualized different segments of users to understand their advertisement behaviors better with Tableau. Show less