Ranganath Attuluri

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