Learn Data Skills
Beta

Amul Jaiswal

Data Engineer

ITC Infotech | Delhi NCR

Technologies

My Portfolio Highlights

My New Project

Planning a Trip to Paris with the OpenAI API

My New Course

Working with the OpenAI API

Insightful puzzle solver, piecing together data fragments to reveal the big picture.

My Work

Take a look at my latest work.

course

Data Manipulation in SQL

project

Planning a Trip to Paris with the OpenAI API

course

Working with the OpenAI API

DataLab

Project: Planning a Trip to Paris with the OpenAI API

My Certifications

These are the industry credentials that I’ve earned.

Other Certificates

Udemy Azure Data Factory For Data Engineers - Project on Covid19

LinkedIn PostgreSQL Essential Training

Microsoft Microsoft Certified: Azure Data Fundamentals

datacamp Working with Hugging Face

datacamp Prompt Engineering with the OpenAI API

datacamp Working with the OpenAI API

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

ITC Infotech | Jul 2022 - Present

Lead Consultant

• Designed compliance frameworks for multi-site data warehousing efforts to verify conformity with state and federal data security guidelines • Developed, implemented and maintained data analytics protocols, standards and documentation. • Prepared documentation and analytic reports, delivering summarized results, analysis and conclusions to stakeholders. • Built databases and table structures for web applications. • Analyzed complex data and identified anomalies, trends and risks to provide useful insights to improve internal controls. • Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability. • Employed data cleansing methods, significantly Enhanced data quality. • Designed and developed analytical data structures. • Designed and implemented effective database solutions and models to store and retrieve data. • Contributed to internal activities for overall process improvements, efficiencies and innovation
Show More

Boston Scientific | Jul 2019 - Jun 2022

Sr. Data Analyst

• Migrated project from SSIS platform to Alteryx and developed backend database on MS SQL. • Report processing using SQL Server Database, ETL - SSIS run support. • Expertise in SQL Join, Views, Stored Procedures, Sub-query. • Having good knowledge in Advanced SQL. • Creating Tableau dashboard and reports with features like Joins, Data blending, operation of hierarchy, context filter, Calculated field. • Developed Tableau Dashboard for detailed insights for APAC/ASEAN Entities. • Project documentation, discussing requirements with clients, proposing solutions, maintaining databases, and performing quality assurance. • Automated more than 10 monthly/weekly Excel reports on Alteryx for APAC. • Analyzed large amounts of data to identify trends and find patterns, signals and hidden stories within data. • Performed root-cause analysis on data-related system problems to recommend or execute corrective action

Annalect | May 2017 - Jul 2019

Sr. Data Analyst

• Data Analysis on digital marketing data and media. • SQL Server, build queries for data processing, created view. • Created Tableau dashboard with cross database joins, multiple joins. • Lead SQL reporting solely for US based telecommunication company. • Used Google Ad words and Bing Ads platform as data resources. • Used Alteryx and Tableau to prepare report direct to clients. • Summarizing data in Excel sheet, consolidating data and Pivot. • Developed automated project on Alteryx.

Prometric Testing Limited | Jul 2014 - May 2017

Data Analyst

for design/development (creating table in SQL) of relational databases for collecting data. • Maintained data integrity during extraction, manipulation, processing, analysis and storage. • Created procedures and views for table in DB. • Pivot and Pivot-chart to prepare report and representing in graphical form. • Summarizing data into graphical presentation Excel pivot tables on charts, formulas, and charts to produce routine metrics and dashboards to represent real time SLA. • Developed Graphical reports to compare expected SLA and real time SLA as per management requirement. • Documented effective and replicable methods for extracting data and organizing data sources

Quatrro Global Services Pvt. Ltd. | Feb 2013 - Jul 2014

Solution Engg.

• Provided functional and technical support, performed troubleshooting and diagnosing hardware and software problems on Windows. • Deploy and configuring PCs, Workstations and Laptops. • OSRI, Blue screen error, Restoring PC, Data Back-up. • Outlook configurations and support. • Installed and configured computer hardware, software and peripheral packages • Installed Windows applications and updates to execute programs remotely • Analyzed proposed technical solutions based on customer requirements

Wipro BPO | May 2011 - Jan 2013

Sr. Associate

• Developed team attendance tracker on excel. • Resolving technical issue within time limits while maintaining SLA of Process. • Troubleshooting and supporting NO internet issue including modem troubleshooting. • Provided training to customers on initial set up of hardware products. • Customer handling, giving technical support to configure wired and wireless routers and modems. • Managed over 70 calls per day • Improved customer satisfaction by quickly and effectively addressing inquiries and complaints • Trained and supported new team members, maintaining culture of collaboration • Worked varied hours to meet seasonal and business needs • Maintained confidentiality on projects, with clients and regarding corporate data to alleviate data breaches • Used Microsoft tools to create correspondence, edit spreadsheets and develop presentations • Troubleshot minor issues with equipment and tools

My Education

Take a look at my formal education

Sam Higginbottom Institute of Agriculture, Technology and
Master of Business Administration - MBA, Information Technology  · (JanuarySikkim Manipal University - Distance Education | 2023
BCA, ComputerSciences(SHIATS) | 2010

About Me

A skilled Data Engineer with over a decade of experience transforming raw data into actionable insights and building robust data solutions across industries. Passionate about leveraging data for innovation.

Powered by

  • Work
  • Certifications
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free