Deepak Bajaj

Experience

• 

  ORG Informatics Ltd

  Sept 2006 - Apr 2008

  Technical Support Engineer

  Key Role:• Worked as a Technical Support at ORG Informatic ( Andheri Saki Naka ) in Banking Domain for 1.6 Years• Provided technical support and maintenance to support client operational activities• Support engagement with control functions to ensure data is leveraged across the Group to ensure a higher level of intelligence• Analyze application code logic to determine root causes of production incidents• Define and document software requirement changes necessary to fix root causes of production incidents• Implement moderate to high complexity code changes that resolve root causes of incidents or enhance operational characteristics (resilience, scalability, etc.) to applications which uses PL/SQL that support business operations and client activity• Install, maintain, and customize vendor built software that is utilized by development and support teams.• Design and develop in-house built applications and tools that streamline development and support processes.• Provided adhoc report to operation by using Oracle queries Show less

• 

  Infoton Systems & Services Pvt Ltd

  Apr 2008 - Jul 2009

  SQL Database Dveloper

  Key Role:• Design, create, and implement database systems based on the end user's requirements.• Executed performance tuning & query optimization using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.• Responsible for system tuning, optimization of information/data processing, maintenance, and support of the production environment.• Triage and provide root cause analysis and/or validation on issues arising in systems or system modules.• Created complex functions, scripts, stored procedures and triggers to support application development.• Participated in load and performance tests analyzing & resolving bottlenecks and performance issues• Diagnosed and resolved Data delivery/quality/consistency Issues• Worked on SQL reporting services tools and created business valuable reports Show less

• 

  Artech Infosystem Private Limited

  Oct 2009 - Jan 2011

  SQL Database Developer

  Working as Contractual Employee of IBM India Private LimitedKey Role: • Gathered requirements from Clients and perform the analysis of requirement.• Prepare the design document and process flow diagram• Develop data model and representing business metrics into valuable reports by using Qlikview• Coded new development and ensure that quality development is performed and delivered as per requirements• Diagnosed and resolved Data delivery/quality/consistency Issues.• Develop, Enhance Qlikview Applications or ETL Applications by fetching the data from various Data source like SAP R3, ODS,Open hubs, SQL server 2005, QVD files, Flat files, and storing in QVD files.• Solving technical issues of QlikView Applications• Fixing the bug in Qlikview Application• Debugging and solving technical issues of SQL Server 2005• Developing and Fixing the stored procedures in Data Base for information retrieval and performing DML Operations in SQL Database• Gathered requirements from Clients and perform the analysis of requirement.• Prepare the design document and process flow diagram• Provided technical support and resolve application-related issues experienced by end-users• Created and executed unit test system for report testing. Provided support and performed quality validation through test cases for all stages of Unit and Integration testing.• Worked on SAP BI tools to extract data into Qlikview Reporting tool• Worked on data bases like SQL Server and Oracle Show less

• 

  IBM India Private Limited.

  Feb 2011 - May 2012

  Application Developer

  Key Role: • Gathered requirements from Clients and perform the analysis of requirement.• Prepare the design document and process flow diagram• Develop data model and representing business metrics into valuable reports by using Qlikview• Coded new development and ensure that quality development is performed and delivered as per requirements• Diagnosed and resolved Data delivery/quality/consistency Issues.• Develop, Enhance Qlikview Applications or ETL Applications by fetching the data from various Data source like SAP R3, ODS,Open hubs, SQL server 2005, QVD files, Flat files, and storing in QVD files.• Solving technical issues of QlikView Applications• Fixing the bug in Qlikview Application• Debugging and solving technical issues of SQL Server 2005• Developing and Fixing the stored procedures in Data Base for information retrieval and performing DML Operations in SQL Database• Gathered requirements from Clients and perform the analysis of requirement.• Prepare the design document and process flow diagram• Provided technical support and resolve application-related issues experienced by end-users• Created and executed unit test system for report testing. Provided support and performed quality validation through test cases for all stages of Unit and Integration testing.• Worked on SAP BI tools to extract data into Qlikview Reporting tool• Worked on data bases like SQL Server and Oracle Show less

• 

  Tata Consultancy Services

  May 2012 - Feb 2018

  Assistant Consultant

  Key Role: • Gathered requirements from Clients and perform the analysis of requirement. • Prepare the design document, POCs and process flow diagram• Develop data model and representing business metrics into valuable reports by using Qlikview• Coded new development and ensure that quality development is performed and delivered as per requirements• Triage and provide root cause analysis and/or validation on issues arising in systems or system modules• Participated in load and performance tests analyzing & resolving bottlenecks and performance issues• Diagnosed and resolved Data delivery/quality/consistency Issues.• Develop and Deploy Qliksense, SAP Lumira dashboards• Perform Unit, Integration and Performance testing of the reports and document the same.• Performance Tuning, Setup and Configuration related to SAP Lumira dashboards• Interacting with business users to ensure that Dashboards are delivered and deployed in a timely manner.• Recommending and Implementing best practices for Qliksense dashboard and QVD development, sizing and configuration• Responding to users regarding access privileges and questions about data.• Worked on database like Teradata.• Creating Nprinting Reports and scheduling its distribution• Qlikview Production Code Deployments• Worked in Support team as Cognos Developer (Preparation of Reports using Report Studio, Query Studio by using Framework )• Worked in Support project of Informatica Show less

• 

  Virtusa Polaris

  Feb 2018 - Feb 2024

  Lead Consultant

  Key Role: • Provide technical direction to project team of Software Professionals engaged in implementation of large scale data warehouse and business Intelligence solutions working in distributed development environment• Requirement gathering from Business Owners and effort estimation for various Customer BI initiatives• Play key role of Onsite coordinator and technical leader for offshore technical team• Develop high level designs for converting requirement into business process and reporting using various technologies like SSIS as ETL tool Qlikview as Reporting tool• Analyze the requirements, and develop data model to handle large amount data and representing business metrics into valuable reports by using Qlikview• Develop and Deploy Qlikview dashboards• Design and configure Database stored procedures, indexes, views, queries using SQL database• Resolve application-related issues experienced by end-users• Participate in discussions with customers to crystallize business requirement and change request• Recommending and Implementing best practices for Qlikview dashboard and QVD development, sizing and configuration• Creating Nprinting Reports and scheduling its distribution• Frequent Upgrades / Updates to software (Qlikview/Qliksense/ Nprinting/ Connectors)• Qlikview Production Code Deployments• Planning for infrastructure changes/ new requirements for Qlikview and Qliksense• Develop strong and strategic client partnership Show less

• 

  Citi

  Jan 2024 - now

  Vice President