Experience

• 

  Aaseya

  • Riyadh, Saudi Arabia

  • Data Architect

    • Oct 2023 - Present
    • Riyadh, Saudi Arabia

• 

  Hitachi Vantara

  • Hyderabad, Telangana, India

  • Data Architecture Engineering Specialist

    • Jun 2013 - Oct 2023
    • Hyderabad, Telangana, India

• 

  CSC

  • Hyderābād Area, India

  • Senior Software Engineer

    • Oct 2006 - May 2013
    • Hyderābād Area, India

    Roles and Responsibilities:• Team lead• Understanding the business requirements• Maintain and Support ETL application for Diageo EMEA region• Implementing new business logic in the ETL Plans.• Key resource in Maintaining and Supporting ETL application• Handling multiple Data Marts: PPS, MMS, Transport, Inventory, GIS, Order Archiving• Fact Load and Dimension Load• Extensively used SCD Type 2 to maintain the history of the selected dimensions.• Worked with different sources such as .CSV files, .DAT files, and remote database.• Developed Workflows in SAGENT Automation to sequence the order of execution of ETL plans of all Data Marts.• Hands on experience with complex ETL Plans from varied transformation logics• Used Sagent Scheduler to schedule workflows.• Creating and maintaining complex Views, Indexes in Oracle• Writing complex PL/SQL Stored Procedures, Functions, packages as per the client requirement• Using Advanced concepts of PL/SQL bulk collection, bulk binding, PL/SQL tables, Cursors in implementation.• Applying Constraints to maintain Data Integrity while defining objects.• Interacting with the client and the onsite coordinator through weekly meeting and on regular basis

• 

  CMC LTD

  • Hyderābād Area, India

  • IT Engineer

    • Jul 2004 - Sep 2006
    • Hyderābād Area, India

    The project is premier Defence laboratory owned by the Government of India, dedicated to research, design and development of electronic warfare systems for the Defence forces of India. This entity sits at the highest level in Defence hierarchy. This controls various sub entities and collects various information given by the sub entities, which are at different locations. It interacts with almost twelve different software items running at different places on TCP/IP link. It analyses the data received and presents the analysis reports in various formats to the operator on GIS maps and GUI screens. The main objective of the system is to identify enemy threat locations and predict the time of arrival. Roles and Responsibilities:• Involved in Requirement capturing and Analysis.• SRS, GUI and IRS documentation. • Defining Procedures , Functions & Packages as per client requirement• Designed database to create database tables / Views /Indexes• Writing PL/SQL Procedures, Functions, Triggers, Cursors• Designing the database objects using Normalization.• Applying Constraints, Indexes to maintain Data Integrity while defining objects.• Defining code components like Triggers to apply User defined restrictions in database as per client requirement.• Generating different types of Queries for reporting purpose.• Mapping of documents using Rational Rose Requisite Pro.• Version control of documents using Visual Source Safe.