Bharat Ahuja Email & Phone Number

Toronto, On, Ca

Canada

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… 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

Toronto, Ontario, Canada

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,… 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

Toronto, Canada Area

Doing 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.

Jersey City, New Jersey

Working on ...• Infrastructure Upgrade Plan• Performance Tuning• Upgrading the release and support model

Somerset, 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

Greater 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

Jersey 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

Greater 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

New 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

New York City, New York

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… 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

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… 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

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… 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

As 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 Developer. Developed Back Office Support System.

Application Developer. Developed Sales and Purchase Order System.

Field Officer: Holding a team of 12 Free Lancing Sales Executives for selling a insurance Package provided by "The New India Assurance Company"

Masters In Computer Application, Computer Applications, First Class

Activities and Societies: Professional Modeling M.C.A.

Master Of Computer Applications - Mca, Computer/Information Technology Administration And Management

Bachelor Of Computer Science (B.C.S.), Computer Science

Activities and Societies: Modeling Graduation

Higher Secondary, Science

Activities and Societies: High Schooling Fun@School