Summary: Mr. Aggarwal is experienced in Configuration Management (IBM Rational tools), Business Intelligence and reporting tools like COGNOS and Crystal Reports as a Technical Lead, in developing applications for Client’s Business growth as well as managing and handling large data volumes through Configuration Management, Data warehousing and Business Intelligence and analytics. Understanding of handling large volumes of data. Provided ETL and Data Warehousing solutions using SQL and Unix Shell Script. I am on green card status. Open to learning new technologies and languages. Managed teams varying in size from 3-8 people.

Professional Qualification

COGNOS 10 BI Author (Report Studio), LOMA 280 (Basic Principles of Insurance in USA) certified with excellent score (97%).

Technical Languages Known

SQL, Unix Shell Scripting, Perl Scripting, VB Scripting, C++, Java, HTML, C#, COBOL

Platforms Worked On

Rational ClearCase and ClearQuest, Rational Publishing Engine, Rational Team Concert, DOORS, Crystal Reports 11, Git, SVN, Ansible, Jenkins, Tableau 10.3, COGNOS BI 10.x, COGNOS BI 10.2.2 Report Studio, Query Studio, COGNOS Framework Manager, SSRS, SharePoint, QlikView, ETL, DB2, Base SAS, SAS Macro, Putty, Win SCP, SQL Server 2008/2012, REXX Utility (Astro and Jane), Oracle, MS Access.

Education

07/2017-Present Rivier University New Jersey

Masters of Business Administration

09/2010-05/2014 Guru Gobind Singh Indraprastha University

Amity School of Engineering & Technology New Delhi

Bachelor of Technology, Scored 77%

Electronics & Communication (ECE)

Work Experience

08/2016

to Present Parsons New York

Configuration Management, Business Intelligence, Data Warehousing and Reporting solutions using IBM Rational, Crystal Reports 11 and SharePoint for PTC, Transportation, Communication, Security, Construction and other design build projects.

Prepare Configuration Management plans for PTC rails, CBTC, Communication, Security and transportation clients.

Configuration Management solutions using Shell scripting in Windows and Unix for ClearCase and ClearQuest CMDB.

Track Hardware, Software, Firmware and Config part types.

Client Interface for Development and managing the project for Configuration Management from scratch.

Worked on multiple Base ClearCase and ClearQuest integrations.

Baseline and maintain Configuration of BOM’s of Procurement, Parts, Configuration Items, Assets, Locations, Delivery records, Documents etc. on the project.

Perform Physical and Functional Configuration Audits on project sites for various COTS products and equipment’s.

Run CCB meetings and Technical review process for Change Management.

SME for onsite user training and queries on Configuration Management using IBM Rational tools and Business Intelligence.

DOORS and ClearCase Integration for Collaborative Lifecycle solutions.

Integrate ClearCase and RPE to build automated final documents.

Building Product Breakdown Structure and Hierarchy reports for BOM’s, Assets and Parts list using Crystal Reports and Visio.

Build Drill Down, On demand Sub-reports and Parameterized Filter reports on Crystal 11 platform.

Dashboard preparation for various projects in SAP Crystal reports, RTC and Tableau.

Design and automate front end screens in ClearQuest designer.

SME for Rational Tools and user Training on projects like NJ Transit PTC, NYCT Bus Radio and All Aboard Florida-FECR PTC.

Work in Unix and Windows environment for extracting reports.

10/2015 to

06/2016 IBM New Jersey

Worked on Configuration Management, Reports, Dashboards, analytics and cubes on COGNOS 10.1.1 and Crystal 11, handled Configuration Management, Data modeling, SQL (database) development as per user requirement for Sri Lanka and India, COGNOS 10 BI Author certified.

Deploying projects using Change and release Management through UCM ClearCase and ClearQuest environment.

Made Key Performance Indicators (KPI’s) for clients using SQL in DB2 environment.

Developed the backend database using SQL with DB2 and SQL Server 2008/2012 with a daily data volume of 2TB.

Created parameter maps, stored procedures for importing as data source and Extraction, Transformation, Loading (ETL) data through Unix Shell Scripting.

Proficient in Report, Dashboard building using COGNOS Report Studio, and Analysis Studio.

Created List, Crosstab, Drill down, Drill up and Drill-Through reports using Report Studio.

Used Bash scripting in Unix for ETL solutions using Putty.

Responsible for Unit testing and System testing of the reports based on the specification. Implemented SDLC.

Reports testing - creating test cases and executing them. Tested the fixed reports in Cognos 10 environment.

Handled large data volumes using DB2 relational database.

06/2014 to

10/2015 EXL Service.com Pvt. Ltd Noida

Worked extensively on COBOL, UNIX, C++, C# and SQL as Software Configuration Management analyst for Policy Admin System (LifePRO) in life insurance domain.

Migration of production data from SVN to ClearCase and ClearQuest.

Travelled onsite to Indiana for 48 days for enhancement in LifePRO.

Worked extensively for various U.S clients like GENWORTH, CUNA on LifePRO.

Extensive design in COGNOS 10 with Dimensional data modeling star schema, snow flake schema, OLAP/ROLAP tools, Physical and logical data modeling, Fact and dimensional tables using COGNOS 10.x BI and Qlikview.

Developed front end screens in LifePRO.

In-House built tools like Astro and Jane for Code Version Management.

Knowledge and implementation of SDLC.

Performed Unit Testing and System Integration Testing for Genworth, hands on experience of working directly with client site.

Nominated as Outstanding performer of the month for January 2015.

Contact this candidate