SUMMARY:

• Rajeev brings over 20 years of business systems sales, design and development, over 5 years in sales, 10 years in d Confidential warehouse implementation and over 20 years in d Confidential base design.
• He has lead and participated in countless projects and managed many people in his team over the years.
• He has been working with Oracle systems integration and development projects for 15 years.
• He is a certified Terad Confidential Master and has been working on Terad Confidential solutions for over 10 years. Rajeev is also a US Citizen, legally able to work for any employer.

PROFESSIONAL EXPERIENCE

Confidential

Architect

Responsibilities:

• Leading FOX’s d Confidential warehouse migration from SQL Server to Amazon Redshift. Rajeev is currently responsible for supporting FOX’s current SQL Server d Confidential warehouse until the migration is complete.
• He is responsible for the new architecture of the Redshift D Confidential Warehouse and migration plan.
• Rajeev is also responsible for process improvement on the project.
• This includes playing a leading role in improving the method of moving d Confidential, code, and schema into Production and other environments as well improving the software methodology. Agile development with 3 to 4 week sprints are currently used.
• Rajeev is also responsible for tuning and SQL query and other performance improvements.

Confidential

Consultant

Responsibilities:

• ENKON created an integrated Land Titles System for the Government of Botswana called LIS (Land Information System). Currently, Botswana has many limited systems with many manual paper based processes.
• Rajeev is responsible for migrating all existing d Confidential from 7 different systems into LIS for the initial production release and is responsible for setting up integration interfaces with another 8 different systems when in production.
• Role has involved travelling to Africa and consulting with the highest levels of Officials in the Government of Botswana to gather and analyze requirements.
• The list of Officials consulted with include the Permanent Secretary of Botswana, Surveyor General of Botswana, Directors and other Departmental Heads, Technical Architects, Programmers, DBA’s, and Analysts.
• As the Integration Lead also responsible for d Confidential base analysts, d Confidential modelling and providing Architectural direction and technical IT support. Have been hands on doing technical developer work and assisting team members by assisting them in development work to meet tight deadlines.
• Main hands on work was creating ETL/ELT code from various source systems into the new LIS system. Also, created technical documentation for all code personally created for sign - off by customer.

Confidential

Consultant

Responsibilities:

• Senior Consultant for Terad Confidential ’s DCM (Demand Chain Management) product. The DCM solution is designed to manage and improve inventory management and forecasting at the retail level.
• DCM is used by many fortune 500 companies across North America. Leadership role in customer presentations, RFP’s (request for proposal), demo’s, consultations, general sales support, complete Performance Benchmarking (Terad Confidential, DCM, Linux, Front End, etc.), POCs (Proof of Concept - which included creating Terad Confidential d Confidential bases and installing DCM from scratch on internal and customer environments before starting POC ), and customer support.
• This work also included Terad Confidential DBA work such as understanding Terad Confidential Optimizer and performance tuning and monitoring using Viewpoint, PMON, DBQL, and TASM. Queries performance improvements made by using appropriate indices such as UPI, NUPI, NUPI, NUSI, partitioning, JI’s, temporary tables, statistics, etc.
• D Confidential loaded (ETL/ELT) into the Terad Confidential D Confidential base for many different clients using a vast array of products and techniques including tools such as shell scripts, Perl, SQL Scripts, Multiload, Fastload, Fastexport, TPump, BTEQ, etc.
• D Confidential was in many different formats and sometimes located internally within client systems with only certain technologies available and choice of ETL tools and methods had to be choose accordingly.

Confidential

Systems Consultant

Responsibilities:

• Writing temporal SQL queries in Oracle on Areva’s D Confidential Warehouse.
• Queries included the sale price of selling futures contracts on electrical power, the value of electrical power over given time periods, the amount of power available to sell from a given company, etc.
• Also assisted in SQL query optimization for poorly performing queries.

Confidential

Responsibilities:

• Worked on Boeing’s BRIDGE and later BIDS projects. Both projects had use of PL-SQL, SQL, PRO-C, C, UNIX, Shell scripting, Perl, stored procedures, and triggers. D Confidential Model was stored in Oracle Designer.
• Assigned to work on performance improvements for slow loading ETL code. Both projects had extensive use of code generators.
• BIDS had approximately 100K lines of code and the project was 97-98% gener Confidential ble from Oracle Designer modelling tool with the push of a button.
• Many of the Documentation/Specs were also generated from Oracle Designer on BIDS.