AMUL JAISWAL

• Developed 8 different ETL workflows, Data-pipelines and Data structures based on client requirement following agile methodology within month.
• 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.

Tools: SQL Server 2012, SSIS 2008R2, Tableau, Alteryx, Excel.

Project Responsibilities:

• 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.

Tools: SQL Server 2012, Tableau, Alteryx, Excel.

Project Responsibilities:

• 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.

Tools: SQL Server 2012, Excel.

Project Responsibilities:

• Conducted research to collect and assemble data for databases –responsible 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.

Tools: MS Excel, Windows 7 tools.

Project Responsibilities:

• 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.

• 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