Amitesh Srivastava

• Played a key role in migrating legacy ETL processes (DTS) to latest SSIS version. • Worked on the BI upliftment project and got involved from the scratch in implementing parallel data automation / Reporting solution on MSBI project. • I participated in completed SDLC life cycle including requirement gathering from business designing development of data cleaning and designing reports top of this data. TOOLS / LANGUAGE: Power BI, SSMS, MSBI, DAX Studio, Git DATABASE: Microsoft SQL Server

• Played a key role in migrating legacy ETL processes (DTS) to latest SSIS version. • Worked on the BI upliftment project and got involved from the scratch in implementing parallel data automation / Reporting solution on MSBI project. • Worked on ETL blueprint designing, preparing staging environment and POC and production implementation. TOOLS / LANGUAGE: Power BI, SSMS, MSBI, DAX Studio, Git DATABASE: Microsoft SQL Server

• Handling database development work for big Clients such as - Bharat petroleum Corporation (BPCL) India Oil Corporation (IOCL) • Designed table partitioning schema and indexes for huge tables for optimization purpose. • Responsible for creating Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules. • Worked on Database migration from ORACLE 10g to MS SQL TOOLS / LANGUAGE: SSMS, MSBI DATAABSE: Microsoft SQL Server, ORACLE 10g

• Designing and developing T-SQL codes, Optimize SQL Queries, Script, Schedule Jobs • Supporting database development work on telecom data for daily call records (CDR) and top-ups received from varies telecom services providers in UK and further process tariff and billing details for reporting purpose. • designing reports on SSSR reports for ERP (Dynamics AX) for Distributor, sales agent, SIM/Voucher inventory and sales, return sales etc. TOOLS / LANGUAGE: MSBI, SSMS DATABASE: MS SQL

• Worked on designing a custom CRM Application for improving service quality. • Designed several reports on SSRS tool for business trends and forecasting. • Integrated mobile messaging service (SMS) delivery method with POS terminal to greet customers on purchasing products and improving customer experience.

Computer Science