Oracle DB
Jitender Virmani
Data Warehouse Specialist | Data Engineer| Data Architect
New Delhi,Delhi
Summary
Specialist with 19 years of experience with 11 years extensively in Data Warehousing, Commerce Graduate from Delhi University, MCA from IIMT, 3 yrs Computer Diploma from NIIT, specializing in data architecture, database modeling, data warehousing projects and Configuration /Release Management. Proficient in mapping client's requirements, designing & developing customized solutions, troubleshooting complex information systems management. A process-oriented approach to assignments, with the ability to understand, plan and measure progress towards goals.
Data Warehouse Architect and Project-management professional with a proven record of accomplishment in increasing productivity, quality, and customer satisfaction and Managing Releases.
Overview
19
19
years of professional experience
9
9
years of post-secondary education
17
17
Certificates
Work History
Director
Ajooni Storage Systems
New Delhi, Delhi
10.2013 - Current
- Led the development and implementation of the company's first data warehouse.
- Replaced 176 existing reports with 45 new metric-unified warehouse reports for sales, marketing, and revenue management.
- Supervised entire database and technical operations for the company
- Established cross-functional relationships and directed all requirements gathering, data analysis, and documentation for enterprise projects to Logistics, Warehouse management, Racking, and loss data from 3PL and CNF Companies into a single multi-terabyte data warehouse with advanced reporting.
- Establish a strong working relationship with the internal team and clientele
- Identify business risks and opportunities
- Mentor 27 junior executives
- Design new sales strategies for additional revenue
- Supervise a team of 39
- Collaborate with customers and vendors to ensure high-quality products that adhere to scheduled timelines and meet budget
guidelines
Manager, Technology - Data Warehouse
Sapient Corporation (Client - RBS Global Banking & Markets)
Gurgaon, Haryana
03.2010 - 10.2013
- Analyzed large amounts of data to identify trends and find patterns, signals, and hidden stories within data.
- Expertise in Data Modeling, design & development of database architecture
- Expertise in data extraction, transformation, and load using diff tools, viz: Informatica, OWB, PL/SQL scripts, etc.
- Worked on Business Objects Universe design and Report generation
- Worked on Release Management, Change Management and Crisis Management
- Created Logical & Physical Data Models for the Project
- Worked on Requirement Analysis & Implementation
- Also involved in Post-Production Support
Manager, Technology - Data Warehouse
Sapient Corporation (Client - E.ON Energy Trading)
Dusseldorf, Germany
09.2008 - 02.2010
- Leveraged text, charts, and graphs to communicate findings in an understandable format.
- Provided reporting and technical expertise for maintenance of organizational processes.
- Managed implementation of new technological improvements resulting in increased efficiency.
- Created and maintained clear, concise project plans and developed strategies to meet deadlines
- Worked on n Data Modeling, design & development of database architecture
- Worked on data extraction, transformation, and load using diff tools, viz: Informatica, OWB, PL/SQL scripts, etc.
- Worked on Oracle & PostgreSQL Relational databases, SQL and PL/SQL programming, and query tuning
Senior Software Engineer -Data Warehouse Architect
Zensar Technologies (Client- Cisco Systems, Inc)
Pune, Maharashtra
09.2006 - 07.2008
- Worked as a Team Lead, Data Modeler, and PL/SQL Developer.
- Worked on Effort estimation, project planning, defining business flow, road map, and high-level process flow.
- Worked on tracking and mitigating the risk
- Performed Coordination with cross-functional teams.
- Performed requirement analysis and design of BI architecture using MS Visio
- Designing Dimensional Models
- Development of the business entity for DataMart using Oracle Designer 6i.
- Development of Complex views and stored procedures for reporting,
- Query optimization and performance monitoring.
- Project Scheduling for test/mock implementation, User Acceptance Test, Creating high-level business flow and case diagram
Software Engineer
i-Theeta Software Pvt. Ltd (OTIS Systems)
Bangalore, Karnataka
01.2005 - 09.2006
- Created Business Objects Reports
- Organized data in reports by using filters, sorting, ranking, and highlighted data with alerts,
- Developed Universe
- Performed the Integrity check
- Resolved loops by creating Aliases and Context.
- Created Conceptual models, Physical models, and designing of the final solution
- Created PL/SQL Scripts for Data Loading which increased performance by 40%
Software Developer
Analyze-it Technologies (Client - Airtel Ltd)
New Delhi, Delhi
06.2000 - 09.2002
- Design and implementation of ETL Mappings
- OLAP database Creation
- Requirement analysis, Test Case creation, and validation
- Unit and Integration Testing.
Education
Master of Computer Application -
IIMT
Greater Noida, U.P. 07.2002 - 06.2005
GNIIT in Systems Management -
NIIT
New Delhi 02.1999 - 01.2002
Certificate in Computing -
Indira Gandhi National Open University
New Delhi 01.2001 - 06.2001
Bachelor of Commerce -
University of Delhi
New Delhi 04.1998 - 03.2001
Skills
Data Analytics
Data Warehousing Architecture
Data Management
Data Modelling
Business Intelligence
Data Visualization
ETL Modeling
Data Mining
Project Life-cycle Management
Agile Framework
Scrum
RDBMS
Script review and revision
Issues resolution
Planning and Coordination
Analytical and Critical Thinking
Software
PostgreSQL
BigQuery
Big Data
Hadoop
Informatica
Pentaho
Erwin
Visio
Business Objects
MySQL
Python
PL/SQL
Microsoft SQL Server
Accomplishments
- Developed Cisco EDW of Size 17 Terabytes with 320 different reports, within half time allocated.
- Resolved product issues through consumer testing.
- Supervised a team of 39 staff members.
- Achieved Near Real-Time Data Refresh by completing tuning of Data Marts with accuracy and efficiency.
Certification
Scrum: Advances | PMI/LinkedIn
Quote
Judge a man by his questions rather than his answers.
Voltaire
Timeline
Scrum: Advances | PMI/LinkedIn
02-2022
Scrum: The Basics | PMI/LinkedIn
02-2022
Agile Foundation | PMI/LinkedIn
02-2022
Introduction to Big Data and Hadoop | Great Learning
02-2022
Learn Big Data Basics | Udemy
02-2022
Business Intelligence Concepts, Tools, and Applications | UOCB
02-2022
BigQuery Masterclass | Udemy
02-2022
Relational Database Support for Data Warehouses | UOCB
01-2022
Database Management Essentials | UOCB
11-2021
Data Warehouse Concepts Design & Data Integration | UOCB
11-2021
Data Analyst - Career Track | 365DataSciece
11-2021
Introduction to Data & Data Science | 365DataSciece
11-2021
SQL | 365DataSciece
11-2021
Introduction to Python | 365DataSciece
11-2021
Introduction to Excel | 365DataSciece
11-2021
Director
Ajooni Storage Systems
10.2013 - Current
Manager, Technology - Data Warehouse
Sapient Corporation (Client - RBS Global Banking & Markets)
03.2010 - 10.2013
Manager, Technology - Data Warehouse
Sapient Corporation (Client - E.ON Energy Trading)
09.2008 - 02.2010
“E-QIFTI” certified for Quality Assurance
03-2008
Cisco certified Security Champion for InfoSec Policy
05-2007
Senior Software Engineer -Data Warehouse Architect
Zensar Technologies (Client- Cisco Systems, Inc)
09.2006 - 07.2008
Software Engineer
i-Theeta Software Pvt. Ltd (OTIS Systems)
01.2005 - 09.2006
Master of Computer Application -
IIMT
07.2002 - 06.2005
Certificate in Computing -
Indira Gandhi National Open University
01.2001 - 06.2001
Software Developer
Analyze-it Technologies (Client - Airtel Ltd)
06.2000 - 09.2002
GNIIT in Systems Management -
NIIT
02.1999 - 01.2002
Bachelor of Commerce -
University of Delhi
04.1998 - 03.2001
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Awards
- Top 10% Most Viewed Resume from LinkedIn 2012
- “You Make a Difference” Award from Sapient, 2011
- Core Value Award for Client Focus Delivery, 2011
- Nomination for Core Value Award for Relationships, 2010
- Core Value Award for Client Focus Delivery, 2009
- “Spot Award” from Zensar Management for excellence., 2008
- Client Appreciation for Database Design and Documentation, 2007
Awards
- Top 10% Most Viewed Resume from LinkedIn, 2012
- “You Make a Difference” Award from Sapient, 2011
- Core Value Award for Client Focus Delivery, 2011
- Nomination for Core Value Award for Relationships, 2010
- Core Value Award for Client Focus Delivery, 2009
- “Spot Award” from Zensar Management for excellence., 2008
- Client Appreciation for Database Design and Documentation, 2007
- Rookie of the Year Award, 2001