Rajendra Singh Negi
Chase the Dream and not the competition
Data Architect & Modeler, DWH, ETL Professional with 28+ years IT experience
Education: Bachelor of Technology (Hons.) Metallurgical Engineering, Indian Institute of Technology (IIT) Kharagpur. Year of passing: 1984. Marks: 69.1%
About Me


Attitude: Can Do, Will Do

Supporting Strengths: Hard work, Interest

What I like doing: Learning, Looking for different solutions, Solving problems & building teams
 

Other Projects

* POC : migration of Data from mongoDB Atlas to Snowflake@ Self

* Development & Framework design, Data Modeling with tracking, logging for Stocks/Shares application involving Python, shell scripts, SQLite, Snowflake, Linux@ Self

* Development & design of nodejs apps / websites@ Self

* Design & Hosting of web site https://www.reviewscans.com@ Self

* Design of apparel, t-shirts, hoodies including graphics. Design of the associated websites@ Self

* POC on SAP Data Hub@ SAP

* SAP Converged Cloud: Provisioning / infrastructure configuration/Admin Linux servers, network resources, storage@ SAP

* Installation of IQ 16, Support for IQ NLS@ Nerolac

* Installation of IQ 16, Support for IQ NLS@ HDFC Life

* POC: Replication of data from Oracle 12c to IQ 16 Sp08 using Replication Server 15.7.1@ SAP

* Workshop SAP IQ NLS@ Tata Power

* Design, implement Analytics project@ SBI

* MCC: Direct interaction with customer and issue resolution on multiple SAP products@ SAP

* Support BOBJ go Live@ BHP Billiton, Singapore

* FOIS (Freight movement and tracking) optimization of data movement@ CRIS,New Delhi

* Sizing & Installation of SAP ASE 16 Data Migration@ Adarsh, Ahmedabad

* POC : Replication of data from various sources using Replication Server 16 and Data Services (BODS) to HANA and IQ@ SAP

* Auditing & Reviewing the ODS Logical Data Model (LDM), Creating the Physical Data Model (PDM) for Sybase IQ16 @ TataSky

* Installation of Sybase IQ 16, Loading data @ 300GB/hr for POC @ Govt Vendor, Gujarat, India

* Supporting ETL for ASE to ASE using sql scripts for ICD9 & ICD10 - SAP ASE 15.7 @ AIM, USA

* Supporting the creation of customized Database password & audit policy SAP/ Sybase ASE 15.7 @ AIM, USA

* Conducted SAP / Sybase IQ EDB courses / classes (Admin & Dev.) @ TCS, NewDelhi

* Conducted SAP / Sybase IQ Training workshops @ Bangalore, Mumbai for SAP

* Installation SAP/Sybase IQ 15.x @ South-East Asian Bank

* Supporting a MS BI initiative @ ClayLogix

* Mobility POCs @ RMantras

* DataWareHouse / DataMart, 24x7 Production Sybase IQ DBA support @ UHG i3Global

* Hosted Analytics @ Mobile 365

* Query Analysis & DataModel Analysis @ TCS CHEP

* Sybase IQ Upgrade / Migration @ BMO

* Design / Develop Statistical / Analytical Reports @ US Govt

* Risk Management Module @ POLB, USA

* PowerBuilder to Appeon Migration @ Intervalve (Poonawalla Group), Pune

* Support FieldSaver Mobile Application @ FieldSaver, USA

* APT to PowerBuilder Migration @ Intervalve (PoonaWalla Group), Pune

* EC Maps @ AT&T, USA

* SCM support @ D W Morgan, USA

* Mobile POCs @ mLogica

* Air Defence Ex Servicemen's Portal @ Indian Army

* Army Vehicle Management System @ Indian Army

* mini-ERP @ Baker Oil Treating (India) Ltd

* Patient Record Management @ Radio Therapy Dept, AFMC

* Educational CDs (Cross-Sectional Anatomy, Embryology, Toxicology) @ AFMC

* Subscriptions & Articles Management System @ MJAFI, AFMC

* mini-ERP @ Megatech Power Equipments Pvt. Ltd

* Army Canteen Management System @ Indian Army

* Integrated Accounts, Payroll @ Goodwill Ex-Servicemen's Society

* Project & Job Management Software, Accounts, Inventory @ Saturn Electrical Pvt. Ltd.

* Golf Handicapping System with Tournament Play @ RSI Golf Course

* Laboratory Management Software @ Bharti Hospital

* Verification & Documentation Software @ Pune Police Commissionerate

* Other Projects:
Portrait Building Software,
Solutions For Retail Stores,
File Encryption,
Resume Reformatter,
Data Cleanser ( Duplicate row remover) for Excel data,
Converting Excel Data Models/Table Structures to PowerDesigner Data Models,
Web development projects with PHP, JS, Jquery, mySQL – esp Sliders,
Determinants of 10x10 Matrix,
Pascal to C converter program,
3D-Bar Charting Function in C,
Dbase (File) to ASCII converter program,
Auto Program Generators.
Achievements ...
Some Achievements and Important Projects:

1. Reliance JIO Project: As Architect : Designed, Modeled, implemented continuous fast loading (including using custom pipes) & aggregation framework. And thus led to the adoption of SAP IQ as a “Data Lake” for network data (size PetaBytes). Also tuned SQL for Data Analytics for Tableau.
2. ICICI Bank Data WareHouse (SAP Global Escalation ): As Architect/expert:Handled the escalation and ensured smooth migration of SAP IQ DWH and integration with landscape. Also Tuned SQL.
3. Aditya Birla Minacs Data Warehouse: As Expert Developer and DataModeler :helped to ensure that DataWarehouse was demonstrated and built in time. Led to Aditya Birla Minacs getting a contract of $17million with American Honda
4. AIM, USA : As Architect/expert: ensured the smooth migration of SAP IQ data and version upgrade and integration with landscape.
5. Bajaj Auto: As Architect /expert: Designed, Modeled, implemented a framework with tracking for Data Cleansing for MDM using BODS for ETL. Data from various sources (including webservice) to SAP ASE tables for single point of truth.
6. iCreate : As expert Modeler and SQL Developer: migration of Business Rules, Data for Banking Software. DataModel version comparison & syncing with master.
7. SAP HEC (Cloud): As Architect / expert : Successfully handled the escalation on SAP HEC Cloud with respect to applications, SAP BOBJ and ASE.
Skills, Statistics
Some Statistics:
1.Projects Handled: over 50
2.Major Escalations Handled: 3
3.Projects x Team Sizes Handled : at a time: 5 x 3

Top skills:
1.DataWareHousing, SAP Sybase IQ(Admin, Dev, Production Support).
2.Data Modeling. Design. CDM, LDM, PDM. SAP PowerDesigner, DBSchema,…
3.ETL / ELT (custom, BODS)
4.SQL
5.scripting (shell, python).

Other Skills:
Development, Analytics, PowerBI, Excel, mini-ERP, Snowflake, mongoDB,Vmware, Docker, Databases, Linux,…

Domains worked in: Telecom, Finance, Medical, Pharmaceutical, Automobile, Manufacturing(Chemical, Electrical)
Designed & Developed by : Rajendra Singh Negi
Teaching

I can take up conducting the following training courses:
1. SAP (Sybase) IQ, ASE
2. SAP  PowerDesigner
3. SQL Dev
4. DataWarehousing, Datamodeling
5. C/C++
6. Python
7. Delphi



etc…..