Amitesh Srivastava
Bis 2009, Software Development Engineer, Dawar's International
Macquarie Group, Indien
Über mich
12 Year of Experience in Data warehouse development, Dimensional modeling and complex ETL designing Extensive hands-on in Data analytics, mining , and visualization, interactive report building on Power BI and Python Skilled majorly in Python, SQL, Power BI, and Complete Microsoft BI Stack including SSIS, SAS and SSRS to enable businesses in making data-driven decisions and thereby, promote business growth by providing actionable insights and data backed recommendations.
Werdegang
Berufserfahrung von Amitesh Srivastava
Bis heute 8 Jahre und 11 Monate, seit Aug. 2015
Database and BI Developer
Macquarie Group
• 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
3 Jahre, Sep. 2012 - Aug. 2015
Senior Technical Consultant
Zones, Inc.
• 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
1 Jahr, Sep. 2011 - Aug. 2012
Database Developer
Pine Labs
• 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
1 Jahr und 8 Monate, Jan. 2010 - Aug. 2011
Software Development Engineer
primus professional services
• 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
1 Jahr und 3 Monate, Okt. 2008 - Dez. 2009
Software Development Engineer
Dawar's International
• 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.
Ausbildung von Amitesh Srivastava
3 Jahre, Jan. 2013 - Dez. 2015
Master of Computer Application
Arunachal University
5 Jahre, Jan. 2003 - Dez. 2007
Bachelor of Computer Application
IGNOU
Computer Science
Sprachen
Englisch
Muttersprache
Deutsch
Grundlagen