SUMMARY:

• Extensive 24 years IT experience with emphasis on Data Architecture, Architecture Design, in providing solutions for Data warehouse and created data marts, implementation of several large - scale projects and design for the integrated business intelligence framework including Data Warehousing, Reporting.
• Proven ability to set strategic direction for developed long term business intelligence framework, architecture, and roadmap in EDW. Build large scale logical data models using ER Studio and dimensional models for Enterprise data warehouse.
• Ravi has an extensive experience in building and developing Dashboards providing solutions to deliver business insights across platforms.
• Emphasis on Data Architecture, Architecture Design, Program and Project Management in providing solutions for Data warehouse.
• Ravi is forefront in enabling business self-service with the right culture and process enables several of our s to play a leading role in Data and Analysis.
• Expertise in building systems and applications to acquire, standardize, document, govern, secure and distribute data for analytical and transactional applications.
• Enterprise Data warehouse (EDW) and Architecture, Leadership and Data & Analytical Service Delivery and Data Platform and Strategy and Data Governance.
• Work experience in all the respective database technologies like Teradata, Oracle and Performance Tuning. Logical/Physical Modeling, Business Intelligence and reporting tools.
• Hadoop Administration and SAP Hana. Service Now System Administration.
• Working knowledge and defining the process and data flows in the areas of Cisco Finance, Profit and Loss, Subject Matter Expertise around Financial Reporting Measures - Revenue/COGS, Bookings, Expense and Financial Close Process.
• Good understanding of sales life cycle (Quote to Cash) - lead to quote, quote to order shipment to service fulfillment and to accounts receivable and Service Install Base and Service contract with Entitlements data and Sales Booking and Sales Credit Engine and Customer care data.
• Informatica, Design the ETL framework in data warehouse and Python participated in storytelling and business scoping and worked with cross functional team to Data Model the logical and Physical layer
• Teradata, Teradata Performance tuning, Teradata Unity, Golden Gate and Data Mover Replications tools. Data Marts and Data Architecture analysis, User Knowledge of Elastic searches Support and Operations.
• Hadoop Administration, Big Data, Oracle, SQL, PL/SQL Teradata Products, Teradata Unity, MySQL, Hadoop, Hive, Pig, HBase, Spark, SparkSQL, Kafka, SAP Hana
• Capacity planning and strategy and vision Planning across the platform and develop KPI metrics
• Service Now Administration in service portfolio and perform Architectural POC on new technologies application portfolio, host management and asset management

SUBJECT AREAS:

Worked in Cross functional teams, stakeholders and initial scoping for business analysis Services, contracts and install base data. Worked on support several business-critical applications like my business reports and Cisco Corporate Finance Applications. Software licensing, Sales and infrastructure. Define business and technical specification and define the strategy and planning for the future vision of the platforms. Subject Matter Expertise around Cisco Financial Reporting Measures - Revenue/COGS, Bookings, Expense and Financial Close Process. Good understanding of sales life cycle (Quote to Cash) - lead to quote, quote to order shipment to service fulfillment and to accounts receivable. Architecture the platform by building data warehouse at platform level and envision the new technology tools stack. Corss fucntional Program Management with Architecture hand to hand involvement working with teams and people management to some extent. At times helps my managers in vendors handling

SKILLS - TOOLS & TECHNOLGIES:

Business Process and Architecture: Business Architecture, creation of Data Flows Diagram and Data Analysis using SQL Python and JavaScript, Access the data using API’s and Microsoft Visio.

Architecture and Data Modelling for Enterprises: Design and worked extensive in Enterprise Data Warehousing, Enterprise Data Architecture, Product Architecture Review and Data Modelling using Erwin, ER Studio, Dimensional Modeling and Designer2000

Data Profiling and Data Quality: Worked experience in Metadata Management in ASG-Rochade and Collibra and other data quality tools like Informatica IDQ.

ETL Framework: Data Integration, Data Migration, Data Mining, Configuration Management, Database Design and Development, Database Creation Administration and OLAP/ OLTP, ROLAP, MOLAPReporting Tools Business Intelligence, Business Objects, OBIEE, Tableau, Spotfire, QlikView

PROFESSIONAL EXPERIENCE:

Confidential

Data Modeler / Lead Data Analyst

Responsibilities:

• Provides support for metadata management system development, implementation and maintenance
• Works with the IT teams to understand data requirements
• Collects, analyzes and summarizes data to support business decisions
• Provides data that is congruent, reliable, and easily accessible by the user
• Utilizes tools to monitor and mass update data changes
• Translates business requirements into conceptual, logical and physical data model
• Develops and maintains the logical and physical data models
• Uses technology to extract and analyze raw data
• Develops and maintains technical documentation regarding data
• Makes recommendations for process improvements in order to support data integrity efforts
• Analyzes program needs and translates them into data warehousing and data mart requirements
• Designs, develops and deploys query parameters, layout, filters, and analytics for program information solutions
• Recognizes and resolves conflicts between models, ensuring that data models are consistent with the enterprise model (e.g., entity names, relationships and definitions)
• Communicates data integrity accuracy to the business, and escalates / communicates issues when necessary
• Supports the development of enterprise data and performs regular data audits
• Builds data migration and single source strategies
• Participates in establishment of governance for metadata management across the enterprise
• Ensures integration of project logical data model into enterprise conceptual data model
• Works in partnership with data architects to design a common customer view of information
• Works with project teams to understand the business environment in order to manage enterprise - wide information/data support systems
• Works on complex enterprise-wide projects/issues/enhancements
• Designs logical enterprise-wide data models
• Provides support for master data management, logical data, quality system development, implementation and maintenance

Confidential

Technical Architect

Responsibilities:

• Primary role is defining the Business Requirements and preparing the scope document .Working with business stakeholders in writing the functional specs and Detail Functional specs for the BRD.
• Define the conceptual Data Model and Logical Model using Erwin Data Modelling tool. Review the scope and BRD with stakeholders on Bi-Weekly basis
• Data Analysis and Requirement Gap Assessment work is done using Netezza system. Defined the Requirement Traceability matrix for source to target mapping in the initial phase of the project
• Preparing the Data Profiling like Map and Gap analysis provide high level visibility of the project scope. Sampling the dataset and giving the data quality inputs to client and provide the gap analysis inputs.
• Define the open questions and follow items with stakeholders for necessary actions documented
• Followed Agile Framework using Jira tool and other Program Management tools

Confidential

Data Architect

Responsibilities:

• Administer and Architecture Service Now's Configuration Management Database (CMDB) |Used Embarcadero’s ER studio as a Data Modeling
• Consulted on Data Modeling with multiple departments including: Sales, Marketing, Finance, Enterprise Data Warehouse, Cisco Capital, Human Resources and Global Infrastructure Services
• Built a Data Model for the Global Infrastructure Services for all modules like Service Portfolio, Application Portfolio, Host Management and Asset Management from IT operation Management and IT Service Management.
• Worked with Business Subject Matter experts to gather data requirements. Created both Logical and Physical Data Models and SQL Scripts for the Database generated Build Data Architecture and Business Intelligence reporting solutions using Teradata and Oracle.
• Analyze & Plan performance improvements for production and address performance issues.
• Provide performance solutions for Operational & User Support issues Fix the issues and address through proactive / preventive approach to avoid future issues.
• Work experience with Service Now in System Administration and Architecture of Service Now's Configuration Management Database (CMDB) Data Architecture and Business Intelligence reporting solutions using Teradata and Oracle.
• Teradata Unity Working on Teradata Platform and Identify & provide performance solutions during early phases of the PLC Analysis, Build & Test)
• Gather performance requirements and ensure requirements are met prior to production release and follow through PLC gates Monitor, Analyze, Prioritize & Plan performance improvements for production
• As we address performance issues proactively, ensure these issues gets addressed during the initial development cycle Provide performance solutions for Operational & User Support issues Fix the issues and address through proactive / preventive approach to avoid future issues

Confidential

Data Architect

Responsibilities:

• Involved in Business Analysis, Requirements Gathering, Functional & Technical specification, Development, Deploying, QA Testing, End Users and Business Group
• Worked with team leads to establish pre-analysis and post-analysis using activity diagrams system context diagrams to assist in business decisions Performed data warehouse modeling (Logical and physical data modeling based on star & snowflake schema)
• Developed the mapping document indicating the source tables, columns, data types, Transformation required/ business rules, target tables, columns, and data types
• Designing in E-R modeling and Report building using ProClarity and Analytic Server for generating the Database cubes using Analysis Services of SQL Server Involved in mapping data elements between legacy systems and operational data source and designing of the documentation process of the conceptual design and responsible for the Architecture, Modeling, and creation of standards for database design.

Confidential

Data Architect

Responsibilities:

• Commodity Audit -CMMS and HR Global DB - Empress will be a global web-based bill of material audit tool.
• Designed the database and mapped the data elements between legacy systems and operational data source
• Responsible for the documentation of the conceptual design
• Responsible for database related issue resolutions and activities, such as database space management, Application, Export of database at regular intervals to optimize I/O, SQL Tuning, Performance Monitoring, and using Data Import utility to transfer data from one database to another.
• Involved in setting the standards for the Database Creation and Table Definitions and updating the feature specs and generation SQL Reports.

Confidential

Principal Consultant -Data Warehouse

Responsibilities:

• Gathered and analyzed business requirements translated them into system applications and processes for the implementation and upgrade of applications Responsible for data aggregation at various levels by creation of Confidential Schema data marts comprising of multiple dimensions and fact tables
• Created of Databases using Oracle Configuration Assistance for Staging, Operational, and Production databases (Logical and Physical data modeling using ERWIN).
• Owned the Entity Relationship diagram, built the Confidential Schema repository, and owned/created all the corresponding documentation, including Corporate Data Dictionary Performed database tuning in migration of flat files using SQL loader and also involved in database development for the upgrades of the versions.

Confidential

Technical Leader

Responsibilities:

• Gathered functional and systems requirements from global stakeholders and created system requirements specification (SRS) documents.
• Involved in the full life cycle of the project including requirement analysis and leadership of the development team
• Developed data aggregation and extraction modules from the warehouse into the data marts using Designer 2000
• Designed data model, created logical and physical databases including tables, indexes, users, roles etc
• Developed, Scripts to build the database, developed SQL packages and optimized packages for performance.
• Fixed business logic and tested Oracle backend processing
• Involved in installing, maintaining and administering the following tools/products: Oracle 7.3.4 on Solaris. Involved in system analysis
• Prepared Database Design and Feature Specification Requirement. Developed database triggers,
• Stored procedures. Designing and creation of database and writing Database Triggers
• Testing the viability of the modular functions during the stages of Implementation, extensively used Third Party tools like VBX, OLE in designing the Forms and Reports Involved in implementation, end-users, documentation of the project