Ranganath Attuluri

Ranganath Attuluri

Software Engineer

Followers of Ranganath Attuluri361 followers
location of Ranganath AttuluriSingapore

Connect with Ranganath Attuluri to Send Message

Connect

Connect with Ranganath Attuluri to Send Message

Connect
  • Timeline

  • About me

    Sr. Technical Lead consultant - Microsoft Azure Data Engineer

  • Education

    • Andhra University, LB PG College

      2002 - 2004
      Master's degree in computer science Computer Science
    • Andhra University

      2002 - 2004
      MSc Computer Science Computer Science
  • Experience

    • Web Synergies (india)

      Dec 2006 - Nov 2008
      Software Engineer
    • Web Synergies

      Oct 2008 - Jan 2021

      Responsibilities & Accomplishments:• Created SSIS packages to clean and load data to data warehouse.• Created package to transfer data between OLTP and OLAP databases.• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Tasks to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, and CSV files to data warehouse.• Created a table to save dirty records.• Created SSIS packages for data Importing, Cleansing, and Parsing etc. Extracted, cleaned and validated• Created complex queries to automate data profiling process needed to define the structure of the pre-staging and staging area.• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent• Wrote MDX queries and expressions for use in Front End BI Applications.• Wrote MDX expressions to create name sets and calculated members.• Created reports by dragging data from cube and wrote mdx scripts.• Created reports by extracting data from cube.• Generated reports using SQL Server Reporting Services from OLTP and OLAP data sources.• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.• Prepared the Layouts by placing the fields to the appropriate place according to the requirement of the final Report.• Created report models and deployed on report server.• Created standard report Subscriptions and Data Driven report Subscriptions• Created report snapshots and cache for better performance.• Used Notification services to generate error messages and send them to the user through e-mails.• Reviewed and adjusted deliverables involved during SDLC involving database changes/development. Show less

      • Aplication lead

        Nov 2008 - Jan 2021
      • Senior Software Engineer

        Oct 2008 - Nov 2008
    • Cognizant

      Feb 2021 - Oct 2021
      Sr. Associate
    • HCLTech

      Oct 2021 - now
      Sr. Technical Lead consultant
  • Licenses & Certifications