BOOBALSINGH K

1. Facilitated communication between internal stakeholders regarding project updates and changes.

2. Worked closely with other executive team members on strategic planning initiatives.

3. Conducted regular staff meetings to discuss progress on projects and initiatives.

4. Performed research into new technologies that could benefit the company's operations.

5. Prepared reports outlining progress on projects, budgets, staffing needs.

6. Documented meeting minutes and created detailed records of project updates.

Projects Worked/Handled:

1. Insight :
Insight is a regulatory and finance application. It deals with deposit and lending modules in the Citi applications. The source data comes from Genesis, DSMT, and other Citi applications. The Abintio tool processes the ETL operations for billions of data from various sources to Hive and Oracle destination tables. From there, Tableau as a service will deliver the regulatory reports to the Federal department in the USA. The core modules are (Personal Loan, Mortgage, ETD, OTC, Trade Product, Whole Sale OD, Retail OD,Comm Cards,Securities,Commercial Loan,Pearl,SFT,Deposits etc.)

2. BOSS Atlas:
BOSS Atlas is a Citi Business Operations application developed for external vendor credit cards used for travel, hotel bookings, and other expenditures made by the particular credit cards. Amex, HDFC, and HSBC will send the data to Citi bank employees' usage details. We will integrate the credit card details with Citi applications using different mapping keys and business logics. Abintio tool will perform ETL operations, and Tableau is for dashboard reports.

3. Continuity of Business:

The objective of this CoB(Continuity of Business) is to support the safety of Citi’s personnel and the soundness of its businesses through consistent enterprise-wide Continuity of Business risk management practices, including but not limited to risk assessment, recovery planning, testing, and crisis management.
It is also the objective of this policy to ensure Business and Technology senior management engagement in and oversight of CoB practices.
Failure to plan for and mitigate the effects of business disruptions could result in financial loss, legal or regulatory repercussions, reputational damage, or even physical harm to staff.
The Continuity of Business program is designed to safeguard Citi's staff, business operations, and.
Technology under a diverse set of conditions, including a resolution event.

Roles and Responsibilities.

1. Acquire files from CoBTrac Site, Cognos reports, files from various source and loading into database using HDFS SQQOP.Placing the files in HDFS

2. Building a Data Pipeline with Module,Dataset,Transformation Management that acquires data from sources like Genisys,DSMT file systems with file watcher validations in different layers and store in Hive and Oracle databases

3. Employed AVRO format for the entire data ingestion for faster operation and less space utilization.

4. Developed Generic graphs for data cleansing, data validation and data transformation.

5. Responsible for cleansing the data from source systems using

6. Ab Initio components such as Join,Dedup Sorted, Denormalize , Normalize, Reformat, Filter-by-Expression, Rollup

7. Metadata mapping from legacy source system to target database fields and involved in creating AbInitio DMLs and written complex XFRs for implementing the business logic transformation.

8. Implemented various levels of parameter definition like project parameters and graph parameters instead of start and end scripts.

9. Deployed and test run graphs as executable k-shell scripts in the application system.

10. Working on Stored procedures, Views, functions, and data issues related to SSIS Jobs.

11. Maintaining the QR Related month end activities.

12. Generating feed files for CoBIRT and load into Datastage ETL tool.

13. Development of Dashboard in Cognos 11 & Cognos 10 versions.

14. Develop and maintain CoB MoR pages in Cognos.

15. Created multiple dashboards in Cognos for multiple business needs.

• Duration: From June 2016.
• Project: Cash Management Reports.
• Client: Central Bank of Oman, Central Bank of UAE, Saudi Arabian Monetary Currency.
• Tools and Technologies: Cognos, Oracle, SQL Server, Java, .NET, SAP BO.

Giesecke & Devrient specializes in high-quality printing, notably currency and securities printing. Later, it has expanded operations to include banknote processing, smart cards, identification systems, and e-payments. The XML file from the banknote processing machine contains serial number, printing date, denomination, series, site, operator name, etc. The details will be stored in the database.
Cash management report includes various types of reports regarding the Bank note processing (Inventory Management, Custody Management, Destruction certificate, Deposit Notification from commercial banks, Schedule, Carrier Manifest, Productivity, BPS Machine Shredded report, Counterfeit Notes, Container Label, Robot Details)

Roles and Responsibilities:

1. Responsible for all the software products in Middle East-Africa.

2. Developing reports in all modules by Cognos 10.1.1 and SAP BO.

3. Designed Cognos Framework Manager Model with different views (Database View, Business View, Presentation View) using Oracle 11g as per Business Users Requirements.

4. Developed complex reports using Cognos Version 10.1.1, using Crosstab with different calculations, data items, and customized page formatting.

5. Developing business logics for implementation of the serial numbers for the bank note.

6. SQL Procedures and database operations from Application server to reporting server.

7. Creating frameworks with the Relational model, providing security aspects.

8. Customer visits for the Development plan, cost estimation, SDLC process.

9. Coordination with vendors in each country for technical issues and provide necessary support.

10. Created mappings using different look-ups like connected, unconnected, and Dynamic look-up with different caches, such as persistent cache. Performed impact analysis of the changes done to the existing mappings and provided feedback. Create mappings using reusable components like worklets, mapplets, and other reusable transformations.

11. Participated in providing the project estimates for development team efforts for the offshore as well as on-site.

12. Coordinated and monitored the project progress to ensure the timely flow and complete delivery of the project. Language files support from English to Arabic.

PROJECT 1:

• Duration: Aug 2015 to Jun 2016
• Project: Wealth Management
• Client: Riyadh Capital, Saudi Arabia
• Tools and Technologies: Cognos, Oracle, SQL Server, Java

Wealth Manager is the product running on Java technology and Oracle Database, holds different Account Analysis, Transaction, overtime frame, Benchmarks, realized gain loss, Valuation, Tax lot details, Portfolio for the customers, WM has the capacity of

1. Pulling order-related info from external system, 2. Support for external systems loaded into Wealth Manager, 3. Support for non-investment products, 4. External WM products to support money market, cash, loans, etc.
5. Include extensions to scheduled transactions, 6. Link an opportunity to more than one product.

Roles and Responsibilities:

1. Developing Reports in Cognos 10.2.2, all the modules mentioned above. Significant management and BI experience in identifying business needs and developing technology solutions to meet business objectives in the BI space.
3. Framework Manager Modeling (Physical Layer, Business Layer, Packages) and Complex Report building with Report Studio.
4. Creating Dashboard reports and using JavaScript in Report Studio.
5. Handled large BI engagements involving ETL, migration projects.
6. Installed and Configured Cognos 10 in a single server environment.
7. Creating the OLAP cubes for different dimensions of data for the customer portfolio, Loans, and Non-Investment Products.

8. Experience in data warehousing concepts and data modeling.

PROJECT 2:

• Duration: Jan-2011 to Jul-2015
• Project: Temenos Core Banking(TCB)
• Client: Kasikorn Bank – Thailand
• Tools and Technologies: Cognos,DB2,Java,VB.NET,Appbuilder,Data Manager

Temenos Core Banking (TCB) is the scalable Core Banking application, running on Mainframe technology and DB2 Database, capable of handling large number of transactions and the business volumes of the very largest Tier-1 and Tier-2 banks worldwide.

Roles and Responsibilities:

1. Developing Reports in Cognos for Loans, Deposit, Cash payments, Admin, and General ledger modules.
2. ETL process – extracting the data from the online server to the Data warehousing server through a batch process by IBM Data Manager and manual SQL scripts.
3. Experience in interacting with end users to gather requirements for reporting.
4. Designing of RSD(Report specification document) ie) Choosing the tables, fields, report elements mapping, data elements mapping ,reports layouts and unit test documents.
5. Framework Manager Modeling (Physical Layer, Business Layer, Packages) and Complex Report building with Report Studio.
6. Cognos 8 BI Suite (framework Manager, Cognos connection, Report Studio, Analysis Studio, Metric Studio, Event Studio and Query Studio).
7. Creating Dashboard reports and using JavaScript in Report Studio.
8. Installed and Configured Cognos 8 in a single server environment.
9. Online client support in production environment after TCB gone live.
10. Creating stored procedures, functions, views, and data marts for the retrieval of data from one layer to another layer.
11. Client Interaction (Analyzing requirements, feasibility study, design and development, testing, support ) in cognos reports

PROJECT 1:
• Duration: Aug-2009 to Feb-2010
• Project: American Health Net / Heathland
• Client: AHN-Omega-US
• Tools and Technologies: VB, ASP.NET, SQL Server, SSIS, SSRS, Cognos

American Health Net/Heathland deals with the complete medication process, consisting of online appointments with doctors, patient details and registration with the hospital, patient problems/symptoms characteristics, past history, family history, drug allergies, etc., patient-related scans-rays, reports, etc.
Some of the modules in the product are Doctor and Nurse Details, Patient details, Medicines, Pharmacy, Reports, etc.

Roles and Responsibilities:
1. Developing Pages in ASP.NET for Pharmacy Module
2. Experience in writing SQl Queries, Stored procedures, Functions
3. Designed, developed and modified Cognos reports using Cognos Report Studio and Query Studio.
PROJECT 2:

• Duration: Feb 2010 to Jan 2011
• Project: Online Bunkering Information system
• Client: Chemoil
• Tools and Technologies: Cognos, DB2, Java, VB.NET, Appbuilder

Online Bunkering Information system is an end-to-end bunkering system for bunker suppliers, traders, and brokers. It helps streamline the entire bunkering process from fuel purchase to sales, operations, inventory, claims and accounting. It automates and improves the entire bunkering process through better inter-department communication, automated workflow and access to information.
Some of the modules in the product are Bunker Procurement, Sales, Operations, Inventory, Accounting, Trading and Risk Management.

Roles and Responsibilities:
1. Developing Reports in Cognos For vouchering, cash payment, receipt and integrate with third party General Ledger packages.
2. Experience in writing SQl Queries, Stored procedures, Functions
3. Designed, developed and modified Cognos reports using Cognos Report Studio and Query Studio.
4. Maintaining the web pages in ASP.NET for the Barge Process
5. Interaction with the clients in Chemoil for the bunkering process

• Duration: Apr-2006 to July-2009
• Project: RCBS(Repco Core Banking System)
• Client: Repco Bank-India
• Tools and Technologies: Microsoft Visual Studio.NET, SQL Server, SQL Reporting System.


Repco Core Banking System is an implementation of all the functional features in Repco Bank's Business Process. Excluding Clearing this product will have all the capabilities of any industry Retail Core Banking Product, developer interface, history maintenance etc.
Some of the modules in the product are Customer Info, Loans, Deposits, Security, System Admin, Cashier, Bills Receivable/Payable, IBR, ABB, Standing Instructions, Account Transfer, FAS, Sundry Accounts, ALM, MIS, Statutory and Regular Reports, Fixed Asset Maintenance, User Profiles etc.


Roles and Responsibilities:
1. Developing UL Related Pages in all the Layers (i.e.) object Manager Layer, Business Layer, Data access Layer.
2. Creating Business Rules & Mapping the Business Rules with different operations.
3. Creating Interest and Service related components in SQL Server using stored procedures and Functions.
4. Designing Reports in Sql Reporting Service and Cognos for daily Ledgers and Transactions.
5. Designing Notice reports in XSLT Style Sheet.
6. Creating migration scripts for conversion of data from their old legacy system to Sql Server.
7. Issue Fixing, supporting for the clients in bank for smooth transaction upto completion of end of day process