Sumit Kumar Srivastava Email & Phone Number

Gurugram, Hr, In

Delhi, India

My Responsibilities includes:1- Managing the Data Analytics and Data Engineering Team 2- Providing right solutions and services to customer3- Conducting pre-sales meeting to demonstrate technical know-hows capabilities and bring new business4- Creating solution architecture and response for various RFQ submissions.5- Requirement gathering, effort estimation, WBS creation for all fix cost projects.6- Conducting weekly project reviews, pulse check to ensure projects are on right track7- Developing relationship with customer by the concept of growing together with strong foundation of business8- Coaching and supervising the subordinate and built up the teamwork environment9- Assisting the L&D framework implementation and conduct pulse checks.10- Technical Resource hiring and mentoring

Delhi, India

Delhi, India

Dubai, United Arab Emirates

• Interacting across all applications holders and line business to understand the requirement.• Involved in the discussion of effort estimation, analyse business requirements and create process flow.• Developed and supported in ETL using business objects data services to populate the tables in the data warehouse.• Involved in technical document preparation of mainframe and data warehouse.• Responsible for the coordination with different application team and guiding them on all phase of projects.• Responsible for timely delivery of application dashboards.• Maintaining the query tracking sheet to communicate issue/queries to the client.

Noida, Uttar Pradesh, India

• Developed three-layer application structure on ETL principle to reduce the complexity and write cleaner code along with implementing all the coding principles.• Developed frontend on DAR methodology for providing the best possible visualization for business users in Qlik Sense and Qlikview.• Worked on different datasource (SQL/SAP/DYNAMIC-AX/EXCEL/WEB) connectivity with Qlikview/Qlik Sense.• Optimized application’s speed and performance by reviewing applications.• Worked on ETL principles to reduce the complications for applications.• Used advance set analysis and Data modeling for complex requirements as sometimes we needed to merge data from different data sources.• Have developed reports on N-Printing 16 and configured them to be sent to the users dynamically.• Worked in all aspects of software development life cycle.• Have administrated QMC (Qlik Management Console) to reload and publish Qlikview and Qlik sense applications.• Developed POC in POWER BI.

Noida Area, India

• Gathered functional requirements & developed QlikView dashboards.• Extracting data from SAP and stored into QVD.• Developed, enhanced, & maintained QlikView applications. Provided production support to QlikView applications.• Redesigned applications to improve performance.• Automated and scheduled daily data loads of QVW documents using QlikView Server.• Perform error handling process, debugging and troubleshooting the jobs.• Involved in testing process and performing the Unit testing and System testing.• Involved in Production Support for various applications and failure analysis using error logs.• Security implementation and deployment of QlikView applications to the production environment.

Noida, Uttar Pradesh, India

• Requirement gathering from the business and perform the feasibility study.• Created Prototype to finalize the report format.• Extracting data from SQL Server 2008 r2 and MS excel and stored into QVD.• Multiple Qlik sense applications are developed for tracking the performance on daily/weekly/monthly/quarterly and yearly basis. Also maintain the stock availability report.• Monitored daily data reload and resolved the customer queries.

Gurgaon

• Understanding the client requirement, gathering requirement information and resources.• Auditing the data collected by the Market Research team.• Design and Define quality matrix for process.• Designing Dashboards & Reports based on requirement.• Analyze historical sales activity in company database based on different parameters. • Update data on platforms used by company and produce customized dashboards.• Work on large data sets/Numbers and analyze complex data. • Work with external data suppliers regarding data accuracy and integrity.• Organizing and presenting data in a clear and concise manner• Demand-Supply Analysis: Competitive & Market Research, Pricing.• Analytics of data such as sales, marketing etc for understanding.• Analyzing Market Trends, Modifications in Development Control.• MIS and Inter Departmental Coordination.• Creating presentations for internal and external audience.• Providing presentations for acquiring new clients.

Noida

• Handle 3 People team.• Verify data from other market sources.• Provide the Area and segment level report by doing the primary and secondary research.• Work with external data suppliers regarding data accuracy and integrity• Organizing and presenting data in a clear and concise manner.• Involve in the company event promotional activity.

Noida, Uttar Pradesh, India

• Verify data from other market sources.• Provide the Area and segment level report by doing the primary and secondary research.• Work with external data suppliers regarding data accuracy and integrity• Organizing and presenting data in a clear and concise manner.• Involve in the company event promotional activity.

Noida

• Worked with Pre Sales team maintain client relationship and developed the POC.• Contacting potential clients via email or phone to establish rapport and set up meetings• Attended conferences, meetings, and industry events• Planning and preparing presentations.• Developed POC in Dot net and SQL Server.

Mba, Marketing, A

MBA in Marketing

B.Tech, Computer Science, A

B.TECH in Computer Science