Rajendra Singh Negi's Linkedin Analytics

Some Achievements and Important Projects: 1. Framework [Stocks][Cloud + onPrem]: As Architect & Data Engineer : Designed, Modeled, implemented framework to load Indian Stocks data (BSE / NSE) from Stock Exchange website to multiple targets (configurable choice, with tracking): a. MariaDB, PostgreSQL, MongoDB, SQLite, Cassandra b. Hadoop HDFS, Hive (text and ORC/parquet/Avro), HBase c. Cloud: Snowflake (AWS/Azure), Amazon AWS RDS - MySQL , Autonomous ATP, ADW (Oracle Cloud), Google BigQuery using python, shell, pig, custom pipes/snowpipes. And graphing, visualization in python and PowerBI. 2. Migrations, conversions Delta Lake, Oracle, HANA... CT-LIB, DB-LIB, PRO*C/OCI, SparkSQL, SQL Anywhere, PostgreSQL. 3. Reliance JIO Project[Telecomm]: As Architect : Designed, Modeled, implemented continuous parallel fast loading (including using custom pipelines) & aggregation framework. Orchestrating SAP BODS. Thus led to the adoption of SAP IQ as a “Data Lake” for network data (size PetaBytes). Also tuned SQL for Data Analytics for visualization in Tableau. 4. ICICI Bank Data WareHouse (SAP Global Escalation) [Banking]: As Architect/expert: Handled the escalation and ensured smooth migration of SAP IQ DWH and integration with landscape. Also Tuned SQL. 5. Aditya Birla Minacs Data Warehouse[Automotive]: As Expert Developer and DataModeler : Migration of Oracle Data, PL/SQL Business logic to IQ. Helped to ensure that SAP IQ DataWarehouse was demonstrated and built in time. Led to Aditya Birla Minacs getting a contract of $17million with American Honda 6. AIM, USA [HealthCare]: As Architect/expert: ensured the smooth migration of SAP IQ data and version upgrade and integration with landscape. Using shell scripts, cron, DBArtisan. 7. iCreate [Banking]: As expert Data Modeler and SQL Developer: migration of Business Rules, Data for Banking Software. DataModel version comparison & syncing with master. Top skills: 1. DataWareHousing, SAP Sybase IQ(Admin, Dev, Prod Support). Snowflake. 2. Data Modeling. Design. CDM, LDM, PDM. SQL/NoSQL, Columnar. PowerDesigner, DbSchema. 3. ETL / ELT, Migrations(custom, SAP BODS) 4. SQL. Conversions. 5. Scripting (shell, python). Python libraries (numpy, pandas, matplotlib,…) 6. Analytics, Power BI, Excel Other Skills: Development, mongoDB, PostgreSQL, Apache Spark, Sqoop, Vmware, Docker, Databases, AWS, cloud, Linux, SAP Data Hub, C/C++, nodeJS, PHP, Tableau, Github, Oracle SQL Developer, DataModeler, SQLcl, pgAdmin4, DbSchema, DeltaLake, SAP HANA Cloud, SAP HANA DATA LAKE, MultiValue Universe DB