Ramashankar Sahu

Ramashankar Sahu

Senior Cad Production Executive

Followers of Ramashankar Sahu1000 followers
location of Ramashankar SahuThane, Maharashtra, India

Connect with Ramashankar Sahu to Send Message

Connect

Connect with Ramashankar Sahu to Send Message

Connect
  • Timeline

  • Skills

    Pl/sql
    Informatica
    Requirements analysis
    Pre sales
    Oracle
    Global delivery
    Solution architecture
    Soa
    Software project management
    Sdlc
    Data warehousing
    Pmp
    Business intelligence
    Erwin
    Embarcadero
    Data analysis
    Data architects
    Data warehouse architecture
    Business analysis
    Data migration
    Oracle applications
    Requirements gathering
    Oracle e business suite
    Business objects
    Etl
    Databases
    Project delivery
    Data modeling
    Enterprise architecture
    Project management
    Business requirements
    It strategy
    Sql
    Six sigma
    Architectures
    Quality center
    Database design
    Data integration
    Oracle pl/sql development
    Itil
  • About me

    I am having 14 years of IT work experience. My main area of expertise has been project delivery of various kind related to Data warehouse, Oracle database & Business Intelligence with consulting experience, focused in Architecture, designing, developing, Testing, Training and delivering custom or packaged solutions. Has assisted clients with implementation of IT PMO, Strategy, road map and visioning complex systems design, data integration, ETL, capacity planning, cost estimates, resource planning, scope management, risk assessments and large-scale project management. Possess strong understanding of cutting edge technologies, quick learning and problem solving Skills. Have excellent communication and presentation skills. I have worked primarily in the domain of financial services, accounting, telecom & Employee Self Services. * Certified Project Management Professional (PMP) * Six Sigma Green Belt * 4 Years of Onsite experience(USA)

  • Education

    • Govt. Engineering College, Ujjain

      1995 - 1999
      Bachelor of Engineering (B.E.) Mechanical Engineering 74.47

      Activities and Societies: SPIC MACAY Completed B.E.(Mechanical) degree

    • Loyola Higher Secondary School, Kunkuri, India

      1983 - 1994
      HSC Mathematics

      Activities and Societies: Schooling Schooling

  • Experience

    • Rolta India Limited

      Feb 2001 - Nov 2004
      Senior Cad Production Executive

      Development of PL/SQL scripts for directing and controlling the project i.e. for population of database table. Developed scripts to validate the database as per the business rules.

    • Tata Consultancy Services

      Jan 2006 - Jun 2014

      Working as Data Architect; Responsiblities1. Build a Treasury Data Mart (Staging database, MST) for Liquidity, ALM and FTP purposes. This data mart contains data at the most granular level possible. The implementation will be for Liquidity first and extend to ALM and FTP in the future – in line with the 5 years Treasury roadmap.2. Support a complete cash flow view of all on and off balance sheet instruments and increase data granularity3. Support multi-views of the balance sheet across currencies, legal entities, SBU’s, branches and subsidiaries, down to product level and client type.4. Automate the monthly GL reconciliation process to reconcile the liquidity data with the Bank’s GL 5. Support the production of standard and adhoc reporting for liquidity analysis and managerial and regulatory reporting purposes. Automate, as required manual reporting to improve operational efficiencies.6. Logical/physical Data Model creation, core data management Show less

      • Associate Consultant

        Jan 2013 - Jun 2014
      • Assistant Consultant

        Jan 2010 - Dec 2012
      • ITA

        Jan 2006 - Dec 2009
    • Accenture

      Jun 2014 - Oct 2016
      Data Architect

      1. Design and Development of an Enterprise Data ware house2. Actively involved in planning and implementation of Data Quality, Data Governance and Data Security.3. Logical/physical Data Model creation, core data management, Star schema modeling, Snowflake modeling, Data Normalization.4. Creating Data flow diagrams, Data dictionary, Entity relation modeling, dimensional modeling and design techniques.5. Liaising with Business owner, Business Analyst, ETL Architect and Reporting Team 6. Master ,reference data and Metadata Management7. Staging area design and audit, balance, control error and exception handling.8. Validation of Source to target mapping9. Performance improvement.10. Creation of Data Dictionary, Ontology document and naming standards templates.11. Managing team of 3 members. Show less

    • JPMorganChase

      Apr 2016 - now

      Data Solution Architect Working as a Data Architect

      • Vice President

        Feb 2020 - now
      • Data Solution Architect

        Apr 2016 - Feb 2020
  • Licenses & Certifications

    • PMP

      PMI
      Jun 2009