Venkateswarlu Sagala

BI Developer 


Over 5 years of comprehensive & in-depth experience in the Information Technology (IT) industry with specialization and expertise in Data Warehousing and Business Intelligence area. An excellent & highly-qualified senior BI professional with great amount of technical skills and a passion for resolving complex problems at ease. Adept at maintaining focus on achieving the right end results while formulating and implementing advanced technology and business solutions to meet a diversity of business needs. Highly effective interpersonal and communication style.

Work History

Work History
Jun 2013 - Present

Lead Engineer

Symphony Teleca, Bangalore, India

 The Integrated Data Verse provides a more complete view of pharmaceutical utilization, patient and prescriber treatment patterns and payer access than the traditional Source Prescriber Payer or the IMS exponent product line. In addition IDV data has greater practitioner coverage, payer granularity and IDV generally trends well with client factory sales numbers.

  • Gathered business logic and requirements to design dashboards and created views in Database if required, fetched data from Oracle Data-warehouse and stored in qvd's.
  • Worked with Business Analyst and the Business user to identify the user requirements, business reporting needs, layout, and developed reports.
  • Created data models, dashboards and reports in charts Dashboard, performed System Integration Test, User Acceptance Test and moved to production environment.
  • Configured expressions and implemented business logic using set analysis.
  • Schedule tasks on Management Console. 
Feb 2012 - Apr 2013

Senior Software Engineer


 The SMP offering is based on sub national data similar to that delivered through Sales Analyzer (SA) today. In SMP this data will be made available on line using the IMS Business Intelligence platform. Systems and processes already exist to enable the ordering and delivery of this data from a number of source systems e.g. XTS, Xponent, PTR. Data for SMP will be sourced using these existing systems and processes with minimal changes.

  • Gathering business requirements and created functional and technical specs and worked with business clients to confirm and clarify requirements and business logic.
  • Worked extensively on data modeling and built QVDs as per business requirement.
  • Optimizing applications by using QVD's and removing synthetic keys(Loading phase).
  • Created dashboard style of layouts using different sheet objects like List boxes, Multi boxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc Co-ordinate with testing team for QA and UAT support.
Jun 2010 - Jan 2012

Software Engineer

Technosoft Corporation, Bangalore, India

Software Engineer Fortune 500 retailer is a leading broadline retailer providing merchandise and related services and is part of ShopYourWay, a social shopping experience where members have the ability to earn points and receive benefits across a wide variety of physical and digital formats through online portal. We have developed a complete Merchandising analytics solution. This helps optimize merchandise and assortment performance, track new product performance, optimize markdowns and promotions and improve price realization.

  • Worked on all phases of reports development lifecycle, from gathering requirements, developing, implementation, and to support.
  • Created a number of cubes, dimensions and business critical KPIs using SQL Server Analysis Services representing aggregations in several different ways-hierarchically and using custom 2/3 groupings that the company will use to analyze performance.
  • Create ad-hoc queries and reports as requested and provide on-going analytical support for these requests.
  • Dimension Modeling and Developed and managed the deployment of OLAP cubes.
  • Performance optimization Cube processing and MDX queries.
  • Given SSAS session to Team members for OLAP Knowledge.
Jan 2010 - Jun 2010

Software Engineer

Helios & Matheson Ltd, Bangalore

India Software Engineer SearchForce is an online advertising Web service that makes creating and managing search-engine marketing campaigns simple and effective. SearchForce provides an intuitive experience to view search marketing performance across a broad range of networks, including Google Ad Words, Yahoo Search Marketing, Microsoft ad Center and others.

  • Created Dashboards, score cards, drill down, Drill through and various types of reports. Optimized ETL, OLAP cube and MDX queries Performance.
  • Interacted with the business analysts and Enterprise users and gathered requirements for generating reports.
  • Designed and developed ETL solution to populate a new reporting environment.


2004 - 2008


G Pulla Reddy Engineering College