Namit

PROJECT/CLIENT/LOCATION/DURATION

SUMMARY

1) BCG (Boston cOnsulting group)

GURGAON

JUL, 2019 to –TILL DATE

I am currently working with my client BCG(Boston Consulting Group) as Power BI, Tableau, Alteryx, Snowflake, SQL Server developer wherein I am responsible for creating Power BI Dashboards using Power BI and Tableau , I also create complex Alteryx workflows which help in creating reports and dashboards providing organization level insights into the health of various kind of IT resource utilizations using pre-defined KPIs and metrics, thus helping leaderships and various IT departments get to know the current IT related usages, software adoption and also current progress related to ongoing critical IT activities at machine/user level with possible forecasts.

I am using Poer BI, DAX, Tableau, SQL for creating Visualizations and Dashboards, Alteryx for creating ETL workflows and Analytics, Snowflake/ SQL server for querying sand database related activities.

Technologies

Tableau, Alteryx, Snowflake, SQL Server

2) RBS/RBS/

GURGAON

MAR, 2017 to –JUL 2019

In RBS I was part of an accounting data reconciliation process called SGL to RGL, in this process SGL (Single Chart of Account Ledger) sends account level balance feeds to RGL (primary ledger which provides RBS with multi-dimensional chart of accounts, rule-based approval workflow and auditable journal substantiation) where in SGL Chart of Accounts get mapped to RGL Chart of Accounts and the balances are sent back to RGL.

This is complex process where the mapping between source and target Chart of Accounts happens through various complex PL/SQL and ODI modules.

I did various design level and code level enhancements using PL/SQL, ODI, OWB, and performance tuning using Oracle 11g/R2.

Which helped in reducing considerable number of reconciliation breaks and improved performance of various processes.

I also won LOV (Live Our Values) award for my work in this area.

 I was also part of RGL KSOR Team where I developed many complex Ledger

extracts using PL/SQL ODI required for Auditing and non-auditing / recon purpose.

My responsibilities also included helping other teammates in areas like ODI, PL/SQL, Unix, DB design etc.

Technologies

Oracle 11gR2, ODI, PL/SQL, Unix, Jira, BMC, Service Now

PROJECT/CLIENT/LOCATION/DURATION

SUMMARY

2) PRELUD/ SOCGEN /NOIDA & CHICAGO/

APRIL, 2012 toOCT-2014

NOV-2015 to FEB-2017

 Socgen Newedge Group offers global, multi-asset brokerage services on a range of listed and OTC derivatives and securities. This project PRELUD aims to utilize Risk and Exposures data coming from various sources and aggregates the data at various levels to prepare it for risk reporting based on risk category type and time bucket. The aggregated data is pushed into data warehouse to be utilized by BO reports.

 My role in current project is that of a Database, ETL and BO lead and it includes doing requirement gathering and analysis from Business Analysts in Paris, prepare or modify existing data model for new requirement, design and development, maintenance and support for PRELUD application in Oracle 11g which includes PL/SQL development and DBA activities, Data warehousing, ETL, performance tuning, complex problem resolution, BO Universe and BO report design.

I also lead and help other database resources working in the team.

As part of application maintenance, I had to do resolution of the tickets raised by the client against the various issues encountered in the application and inform the client about the progress as soon as possible. The resolution of tickets involved creation of detailed resolution and testing forms detailing out the various technical details and test cases respectively. Involved in getting the approval of resolution forms from the client and testing the resolved issues in QA environment and then further deploy in production. I attend the daily scrum status meeting scheduled by the client to report and discuss the resolution in detail against the various trackers raised during the whole week.