Ajay Gupta

• Having 12 years of experience in Snowflake AWS Power BI SQL Server ,SSRS , SSAS& SSIS ,DBT.

Company Name:DXC Technologies, Gurgaon Duration:Aug’18 – Feb’21Role:Professional 1 Application DeliveryKey Result Areas:

• Deliver on key projects and data visualization strategies that directly support key business drivers.
• Assist in developing best practices for data presentation and sharing across the organization.
• Conceptualize, design and develop data visualization solutions that synthesize data concepts into clear communications for key business stakeholders.
• Build visuals with the teams. Consider into his own framework, objectives, challenges, and strategic decisions that product & data analytics teams have and build visualizations for consultants & customers to help answer UI/UX questions.
• Drive the design and build of visualizations and analytics.
• Provide advanced insights/suggestions to the clients.
• Meet the client expectations of the visualization request provided in the reports.
• Delivered Power BI Training to business users.
• Integration of SQL server, excel, SharePoint, web using Power BI and developed the insights using it.
• Having good understanding of Power BI Gateways, data flows, report server, schedule refresh.
• Have worked intensively on the creation of dashboards using parameters, sets, filters.
• Worked on the organization theme color and created Jsons file
• Worked on Pagination report for the consumers who want "pixel perfect" report.
• Experience in creating complex formulas and calculations within data visualization tools to meet the needs of complex business logic.

Company Name:Xceedance Consulting India Duration:Sep’21 – PresentRole:

Team Lead

• Complete software development lifecycle from designing to maintaining enterprise level applications with the Snowflake platform
• Implement ETL pipelines inside/outside data warehouses
• Snowflake querying with SQL including writing and optimizing queries
• Development of database design and reporting depending on BI needs
• Script development with SQL for ETL jobs
• Collaboration with cross-functional teams for adhering to objectives and for status reporting
• Integration with other third-party data sources and tools
• Create and implement identity and access management features
• Implementation of security compliances with encryption
• Managing transactions with distributed data processing algorithms
• New development and updates of code with reverse engineering
• Ensure data security and confidentiality
• Assessing and managing risks with appropriate mitigation plans
• Database migration activities within database or on-premises/cloud