Bharat Ahuja's Location
Brampton, Ontario, Canada, Canada
About Bharat Ahuja
· Currently working as a Sr. BI Architect, handling the Development, Migration, Upgrade, Support and the release process Qlik Sense and NPrinting Apps.· Working towards upgrading Qlik Sense and NPrinting to the latest version.· Worked as a Senior BI Architect (Qlik) with 20+ years of Total experience having 14+ years in QlikView / Qlik Sense & NPrinting Development with 8+ years in SAP BusinessObjects.· Worked with Web team to integrate Qlik Sense Objects into UI Application (i.e., Mashup type Springboard using Openfin) and enable features to export to PDF, Excel and Email body.· Lead the Qlik Team and took care of Migration, Upgrades, Development Issues, managing 20+ Qlik Servers across environments including DEV, QA, UAT, PROD and DR. · Experienced in managing the complete System Development Life Cycle (SDLC) that includes Requirement gathering, analysis and feasibility study (documenting functional specifications), designing, development and coding (Reports, Dashboards, Publications and Schedules), testing, implementation & support which includes supporting issues related to Product, Development, Administration, Access Rights and Infrastructure issues. · Worked on Agile Methodology attending Scrum meetings discussing Jira, Stories, Sprints, etc.· Experience of efficiently leading big team to get the work done within tough deadlines.· Worked on development, migration, administration, support and server upgrade activities.· Working knowledge of Informatica mappings and workflow Monitoring, Data Stage, Qlik View / Sense Server Management & Administration· Creating Dashboard in QlikView / Qlik Sense from Database and QVD files, setting up incremental load, partial loads, set analysis, writing load scripts, access point setup, managing user security, named user licenses and tokens.· Configuring NPrinting On Demand Extension object on a Clustered QlikView Environment as well as using Extension Objects in Qlik Sense.· Setting QMC task to trigger NPrinting and Qlik Sense task from QlikView & Control-M.· Worked on Version Control tool (Tortoise SVN, TFS) and External Scheduler (Control-M, Autosys) for QlikView / Qlik Sense Dashboards.· Worked on Defect logging tools like QC, Jira, Service Manager, ServiceNow and Falcon.· Exposed to other BI Tools like PowerBI, Tableau, SSRS, OBIEE and Big Data.· Involved in evaluating new project requirements, working on RFP and POC, assisting other teams from different accounts with development and migration work, and mentoring new developers, conducting interviews and classroom trainings.
Bharat Ahuja Work Experience Details
-
Bi Lead DeveloperPragraToronto, On, Ca -
Sr. Qlik ArchitectBank Of Canada Sep 2022 - PresentCanadaWith Qlik, I do most of the activities which include Requirement Gathering, Analysis, Design, Development, Testing, Implementation, Migration, Upgrade, Administration, Support, Training Business Users, Working with Business Analysts, Managing Security, Upgrading all the Qlik Sense and Qlik Sense NPrinting Servers from May 2022 to May 2023 version and managing user access.For Power BI, I have created some basic DAX Queries, Exploring the Power Query, Testing Power BI Desktop, Exploring Power… Show more With Qlik, I do most of the activities which include Requirement Gathering, Analysis, Design, Development, Testing, Implementation, Migration, Upgrade, Administration, Support, Training Business Users, Working with Business Analysts, Managing Security, Upgrading all the Qlik Sense and Qlik Sense NPrinting Servers from May 2022 to May 2023 version and managing user access.For Power BI, I have created some basic DAX Queries, Exploring the Power Query, Testing Power BI Desktop, Exploring Power BI Services and creating different type of Graphs on UI. Show less -
Senior Business Intelligence ArchitectRbc Capital Markets Nov 2019 - Sep 2022Toronto, Ontario, CanadaTo keep it simple, Along with Development and Application support, I take care of the working state and performance of QlikView, Qlik Sense (Partly), NPrinting and other BI Tools (Somewhat), that run on Windows, and read data from different databases. With everything upgrading every week including browsers, Log4j, TLS, SSL, chromium, Control-M versions, Git Hub, Jenkins, Nexus, SMTP, DRs, Backups, etc. it sometimes gets very difficult just to make sure the entire system is breathing normal. So,… Show more To keep it simple, Along with Development and Application support, I take care of the working state and performance of QlikView, Qlik Sense (Partly), NPrinting and other BI Tools (Somewhat), that run on Windows, and read data from different databases. With everything upgrading every week including browsers, Log4j, TLS, SSL, chromium, Control-M versions, Git Hub, Jenkins, Nexus, SMTP, DRs, Backups, etc. it sometimes gets very difficult just to make sure the entire system is breathing normal. So, that's what I do. I wear multiple hats of a Developer, Maintenance, Code Cleanup, Space Management, Coding Standards, Support, Migration, DR, Backups, Admin or to Summarize, a Senior BI Architect. Show less -
Bi Architect (Qlik + Nprinting)Rbc Capital Markets Oct 2018 - Oct 2019Toronto, Canada AreaDoing what an Architect does...- Planning upgrade with Software and Hardware, Backup, Archive, DR and Performance tuning with QlikView & QlikSense.- Not to forget, Agile Sprints with regular development & release work continues.- Other improvements include Control-M, Github, Jenkins, Nexus, better folder structures for storing common code in external files and implementing other best practices.
-
Bi Architect (Qlik + Nprinting)Rbc Capital Markets Mar 2018 - Oct 2018Jersey City, New JerseyWorking on ...• Infrastructure Upgrade Plan• Performance Tuning• Upgrading the release and support model
-
Bi Architect (Qlik + Nprinting + Bo)Catalent Pharma Solutions Sep 2017 - Mar 2018Somerset, New Jersey• Developing standard solutions with automated external file configuration• Designed a theme/template to use a standardized approach for the organization wide apps• Performance tuned QlikVIew apps to run from several hours to few minutes• Re-architecture the existing setup to use an ETL approach using QVD layers• Enhancing existing applications based on the change requests• Fixing issues with repots using JDE Julian Date Formats• Preparing server upgrade with DR… Show more • Developing standard solutions with automated external file configuration• Designed a theme/template to use a standardized approach for the organization wide apps• Performance tuned QlikVIew apps to run from several hours to few minutes• Re-architecture the existing setup to use an ETL approach using QVD layers• Enhancing existing applications based on the change requests• Fixing issues with repots using JDE Julian Date Formats• Preparing server upgrade with DR plan• Evaluating QlikView 12 and QlikSense September release with NPrinting Show less -
Bi Architect (Qlik Sense & Nprinting)Brown Brothers Harriman Jul 2017 - Sep 2017Greater New York City Area• Upgrading Qlik Sense Environment to June 2017 release upgrading from Synchronized Persistence to Shared Persistence.• Upgrading NPrinting Server to NPrinting June 2017 release.• Creating NPrinting Reports with Dynamic PowerPoint, Excel with Disclaimers, PixelPerfect PDF output and generating emails, NewsStand and Report for Hub.• Accepting stories through JIRA and updating the details.• Managing and allocating Qlik Sense Tokens and access pass.• Configuring NPrinting On… Show more • Upgrading Qlik Sense Environment to June 2017 release upgrading from Synchronized Persistence to Shared Persistence.• Upgrading NPrinting Server to NPrinting June 2017 release.• Creating NPrinting Reports with Dynamic PowerPoint, Excel with Disclaimers, PixelPerfect PDF output and generating emails, NewsStand and Report for Hub.• Accepting stories through JIRA and updating the details.• Managing and allocating Qlik Sense Tokens and access pass.• Configuring NPrinting On Demand Extension object using Extension Objects in Qlik Sense.• Configuring On Demand Reload within a Qlik Sense App by creating Widgets.• Exploring different extensions like Climber and xtablebox for creating Adhoc reports in QlikSense.• Fixing issues with the existing Apps for Fixed Income, Risk Management and other Streams.• Addressing issues related to the data and upgrade. Show less -
Sr.Qlikview / Qlik Sense DeveloperHsbc Nov 2015 - Jun 2017Jersey City, New Jersey, Usa• Working on Regulator Reporting as a Sr. QlikView / Qlik Sense Developer.• Working closely with the users and interacting with the Business Analysts to understand the changes required to the existing system and estimate efforts for the requirements.• Fixing defects on the existing QlikView applications, querying the database to validate the fixes as part of unit testing and work with the Testers and QAs to get the QC item tested and closed.• Configured Qlik Sense 3.2.2 Server… Show more • Working on Regulator Reporting as a Sr. QlikView / Qlik Sense Developer.• Working closely with the users and interacting with the Business Analysts to understand the changes required to the existing system and estimate efforts for the requirements.• Fixing defects on the existing QlikView applications, querying the database to validate the fixes as part of unit testing and work with the Testers and QAs to get the QC item tested and closed.• Configured Qlik Sense 3.2.2 Server Setup, and AD Group access, configured licenses and Tokens, created Dashboard in Qlik Sense using extension objects and allocated tokens to users.• Work with Version Control and automated job schedulers to trigger QlikView/Sense Jobs.• Get the list of users from the Business Analysts to grant/revoke QlikView/Sense Cals/Tokens.• Configuring NPrinting On Demand Extension object on a Clustered QlikView Environment.• Evaluating NPrinting 17.2 to achieve the expected output format.• Work with the team to review & redesign the existing QlikView Architecture, Data Model and the Dashboards for better Performance.• The existing QlikView project does the Extraction, Transformation and Loading (ETL), all within QlikView reading from the transactional database. So, worked on redesigning the incremental load code, to reload only the change piece of data with a check on loading parameters.• Adding code management tasks for better maintainability and performance.• Create QMC Tasks for Dashboard, monitor QlikView Services, run reload jobs, grant and revoke user access, and troubleshoot reload failures by reading and analyzing the reload logs• Working with the QlikView Server Administrators to synchronize all the QlikView Servers to get them on the same version, manage disk space on the server and perform other admin activities.• Perform production turnover and support post-production checkouts. Show less -
Sr.Qlikview DeveloperRbc Capital Markets Oct 2014 - Oct 2015Greater New York City Area• Work with the Business Analysts and Business Users to understand the requirements• Perform the feasibility study and provide the effort estimations• Develop and Maintain Dashboards in QlikView• Apply Set Analysis at different levels• Monitor QlikView Services and reload jobs.• Grant and revoke user access• Troubleshoot reload failures by reading and analyzing the reload logs• Provide Training to the end users• Create Ad-Hoc Reporting solution in QlikView•… Show more • Work with the Business Analysts and Business Users to understand the requirements• Perform the feasibility study and provide the effort estimations• Develop and Maintain Dashboards in QlikView• Apply Set Analysis at different levels• Monitor QlikView Services and reload jobs.• Grant and revoke user access• Troubleshoot reload failures by reading and analyzing the reload logs• Provide Training to the end users• Create Ad-Hoc Reporting solution in QlikView• Creating complex dynamic recurring QlikView Scheduled Jobs using NPrinting.• Work with the infrastructure team to setup a new QlikView Environment.• Write queries in SQL Server Management Studio and compare query output with QlikView Dashboard output. Show less
-
Bi Consultant (Business Objects & Qlikview)Capgemini Nov 2009 - Sep 2014New York, Us• Involved in POC and RFP for new Projects in QlikView and Business Objects; resource loading, allocation and utilization.• Training and re-tooling resources on QlikView and getting the allocated on different QlikView development projects.• Involved in evaluating SAP BI 4 and QlikView 11.2.• Mentoring BO Developers to analyze and document technical specs for new requirements.• Involved in POCs for new projects and training users on new tools like WebI Rich Client, Report… Show more • Involved in POC and RFP for new Projects in QlikView and Business Objects; resource loading, allocation and utilization.• Training and re-tooling resources on QlikView and getting the allocated on different QlikView development projects.• Involved in evaluating SAP BI 4 and QlikView 11.2.• Mentoring BO Developers to analyze and document technical specs for new requirements.• Involved in POCs for new projects and training users on new tools like WebI Rich Client, Report Conversion tool, Query As a Web Services (QAAWS), CR 2008 and Live Office.• Conducted several BO and QlikView Classroom and Virtual Trainings. Show less -
Bi ConsultantMorgan Stanley Nov 2009 - Sep 2014New York City, New YorkThe role and responsibilities includes the following:• Working on Dodd Frank Compliance and CRM Interaction Reporting• Monitor, support and fix Informatica Production ETL and Autosys jobs.• Gathering requirements from Business, coordinating work with the team, developing universe and reports in Business Objects, QlikView Dashboard and managing delivery.• Communicate with the Business Users, Business Analysts and Client to fully understand the requirements• Co-ordinate the… Show more The role and responsibilities includes the following:• Working on Dodd Frank Compliance and CRM Interaction Reporting• Monitor, support and fix Informatica Production ETL and Autosys jobs.• Gathering requirements from Business, coordinating work with the team, developing universe and reports in Business Objects, QlikView Dashboard and managing delivery.• Communicate with the Business Users, Business Analysts and Client to fully understand the requirements• Co-ordinate the requirements with the development team making sure that all the requirement information is clearly communicated.• Address any Production issue or Ad-hoc user queries.• Work with the development team on the requirement analysis and feasibility study• Communicate the development effort and delivery dates with the Client.• Design and update Data Warehouse.• Read the data from the transaction data from the transactional database through MQ Queries and load it into the data warehouse using Informatica (ETL) workflows.• Develop new Business Objects Universe, Reports and Schedules.• Update existing Reports, Universes, Informatica (ETL) workflows and database changes as required• Follow-up with the development team at offshore on their status and update the client.Environment: Windows 7, Business Objects XI 3.7, Informatica 8.1, IBM DB2 9. Show less -
Business Objects AssociateJ.P. Morgan Jan 2008 - Oct 2009As a Business Objects Assiciate worked on the following assignments which included the following responsibilities:• Data Analysis at client site in Paris, France.• End-to-end development cycle BO 6.5.4 designing Universe and Reports.{i.e. Analysis, Design, Coding, Testing, Implementation (DEV -> UAT -> PROD)}• Modification/Changes/Maintenance of BO XI R2 WebI Reports.• Upgrading Business Objects Environment from BO 6.5 SP2 to BO 6.5 SP4 o Preparing Test Case and… Show more As a Business Objects Assiciate worked on the following assignments which included the following responsibilities:• Data Analysis at client site in Paris, France.• End-to-end development cycle BO 6.5.4 designing Universe and Reports.{i.e. Analysis, Design, Coding, Testing, Implementation (DEV -> UAT -> PROD)}• Modification/Changes/Maintenance of BO XI R2 WebI Reports.• Upgrading Business Objects Environment from BO 6.5 SP2 to BO 6.5 SP4 o Preparing Test Case and Test Logs. o Performing Tests and updating Test Cases. Requirement gathering and assisting Business Analysts in creating Use Cases. Creating Universe and Reports from scratch using BO 6.x and BO XI 3.1.• Taking change requests for Existing Universes & Reports and making necessary changes.• Migration Project BO 6.5 to BO XI 3.1 (Testing migrated Universes and Reports)• Resolving issues like BO XI 3.1 Client connectivity, creation and deletion of users, Performance issues, user training issues, Ad-hoc Production issues and L3 support issues.• Communicating with the end users, taking new requirements, analyzing the feasibility, effort estimation, planning, designing, developing, testing, implementing and handling post implementation maintenance.• Handling all Process and Project related activities like Monthly Audit, Quarterly Audits, Delivery Audits, Risk Management, BCP, Defect Management, Metrics, Change management, version controlling (SCM Coordinator).Environment/Tools: Windows XP Client, Business Objects 6.5.2, Business Objects XI 3.1 & Oracle 9i. Show less -
Escalation Engineer (Associate - Sme)Business Objects Jan 2006 - Jan 2008Responsibilities: The role was an Escalation Engineer (Associate Subject Matter Expert) that consisted of• Handling a team of 18 Technical Engineers and guiding them in resolving following type of issues:o Designing, formatting, maintenance and replication of Universes, Desktop Intelligence and Web Intelligence Reports.o Performing different types of functionality testing with various patches available by Business Objects against different operating systems as well as different… Show more Responsibilities: The role was an Escalation Engineer (Associate Subject Matter Expert) that consisted of• Handling a team of 18 Technical Engineers and guiding them in resolving following type of issues:o Designing, formatting, maintenance and replication of Universes, Desktop Intelligence and Web Intelligence Reports.o Performing different types of functionality testing with various patches available by Business Objects against different operating systems as well as different database versions (e.g. Oracle, SQL Server, Sybase, DB2, MS Access, etc.).o Tracking all kinds of Bugs and dealing with Enhancement Requests for the Product. • In BO XI R2, I also have a basic understanding of CCM, CMC, CMS, Infoview, bugs and limitations in Business Objects, BO XI R2 Server Architecture, Restrictions, Security settings, Live Office and Crystal Reports.Environment/Tools: BO 5x, 6x and BOXI R2, Windows XP, Windows 2000/2003, Oracle, SQL Server, Sybase, Db2 Show less -
Web-MasterArk-Inc Design And Communications Aug 2005 - Oct 2005As a webmaster, involved in developing new static websites and updating the existing website based on the change requests.Environment/Tools: Windows XP, Dreamweaver, Flash, Corel Draw, HTML, DHTML and CSS.
-
Application DeveloperMilind-Oka Apr 2005 - Jun 2005Application Developer. Developed Back Office Support System.
-
Application DeveloperCyber-Em Computers Sep 2001 - Nov 2001Application Developer. Developed Sales and Purchase Order System.
-
Field OfficerWinners Insurance Partner For The New India Assurance Company May 2000 - Jul 2000Field Officer: Holding a team of 12 Free Lancing Sales Executives for selling a insurance Package provided by "The New India Assurance Company"
Bharat Ahuja Education Details
-
First Class -
Computer/Information Technology Administration And Management
-
Dr. D. Y. Patil College Of Arts, Commerce And ScienceComputer Science -
Adarsh Maha Vidyalaya GandhidhamScience
Frequently Asked Questions about Bharat Ahuja
What company does Bharat Ahuja work for?
Bharat Ahuja works for Pragra
What is Bharat Ahuja's role at the current company?
Bharat Ahuja's current role is BI Lead Developer.
What schools did Bharat Ahuja attend?
Bharat Ahuja attended University Of Pune, Savitribai Phule Pune University, Dr. D. Y. Patil College Of Arts, Commerce And Science, Adarsh Maha Vidyalaya Gandhidham.
Not the Bharat Ahuja you were looking for?
-
3hlgroup.com, averda.com, arenagroup.com -
Bharat Ahuja
Andhra Pradesh, India -
1ecosystemventures.in -
1yahoo.co.in
Free Chrome Extension
Find emails, phones & company data instantly
Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Aero Online
Your AI prospecting assistant
Select data to include:
Total price:
$0.00
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial